Notice of Maintenance on October 9th. Click here for further details.

x Want to participate? Join the group to interact

  • Use VI to change customer pricing?

    Looking to mass update one customer's pricing from an Excel doc. Can I do this through VI? Or do I need to do something with price codes? Unfamiliar with this- will need to update a large number of SKUs with price override, not discount/markup. Thank…

  • VI Import to SO_InvoiceTracking with multiple packages from UPS Worldship export

    Hi Sage 100 Community, I'm trying to help our warehouse cut some manual entry time with their UPS tracking numbers. There is currently a process in place with UPS Worldship that exports a CSV at EOD to our Sage server and then a series of VI Import…

  • VI Job Output via Command Line

    I'm currently running SAGE 100 version 7.10.5.0. I can run VI Import jobs no problem via a .bat file or through command line. However I'm looking to get some output back from running the job. Ranging from: Successful or unsuccessful login (right…

  • VI Cash Receipt with only invoice number

    Sage 2019 - Looking for way to import into AR_CashReceiptHeader from a source file that contains only the invoice number and check number but not the customer number. Manual entry allows to enter an invoice number followed by the check number. This automatically…

  • exporting invoice detail lines

    is there a way to export the line details on current open AR invoices. When I use Business insights the current open AR invoices just give the balance of the invoice not the line detail for those invoices. If I use invoice history I get more then open…

  • Are we able to import memo settings for auto-display?

    When you create a new memo, there is a preset list of records automatically populated into the module's ...memosettings.m4t table. I don't see anything in VI nor any other work-around that will let us access that table to do updates. (This is when we…

  • Perform logic and VI

    I am importing into Sage 100 Payroll Data entry. Using perfom logic, I am able to import earnings using TBL(NOT(Temp006), coBusiness'Lines'CreateStandardEarningsLine( Temp001$, Temp006 ) , 0) Does any know if I can import Deductions as well? I tried…

  • Importing Serial Numbers for Purchase Receipts

    I have multiple serial numbers that need to be entered for purchase receipts They are not in the warehouse where they can be scanned in. I am trying the import tool but keep getting an error message. HELP

  • Importing Wire Transfers into Manual Check Entry - not getting W check number

    I'm importing Wire Transfers into Manual Check Entry with Check Type "W" before the Check Number field. Using Next on Check Number. It is pulling the next CHECK number instead of the next WIRE number. Anyone run into this and have a fix?

  • how to export Customer contacts (all) with email address's? File is AR_CustomerContacts but when I try with VI it only exports the primary contact.

    How can export all Customer Contacts in VI from AR_CustomerContacts. When I do this in VI I only get the primary contact. I don't see a record type field that would allow me to select multiple contacts.

  • VI Job How can I import a job with forced return?

    I am importing new item descriptions and it includes a character return (alt enter). If I enter it in the file, it causes the entry to error out when imported. Is there another way I can import it or will we have to go in and manually enter the hard return…

  • VI import from Excel file

    When using VI and importing from an Excel file, does the VI import job spin off a *.csv file into ..\mas90\home\textout to use as the source data? I'm getting this error:

  • VI - How to replace an Additional Email Address in AR_CustomerDocumentDocuments.M4T - v2019

    I can add new emails by importing into AR_CustomerDocuments, but I want is to replace one of the existing Customer Email addresses with a new one. Backgroud: the "Additional Email Address" is populated with an internal email address to cc themselves when…

  • How to create a VI export for records that were changed today

    I suppose this could be for almost any table with a DateCreated or DateUpdated field, but in this case I'm trying to create an export for CI_Item what includes only those records with a DateUpldated of today. Based on 3 different posts here on Sage City…

  • VI Export Conditional Expression

    Morning, I am trying to create a conditional express for a VI export job, but don't seem to be able to figure out the formula. Can someone guide me on what it is I am doing wrong (if not all)? {SY_SalesTaxClass29.TaxClass$} = "NT" then {Temp002…

  • Visual Integrator Chain to & Change company code

    Is it possible to change the company code during a VI Chain to event? We have a process of importing data into the SO tables in one company code and then updating a field in the PO Header of another company code. I'd like to use the VI Chain To field…

  • VI JOB Cash Receipts Import - How do you set up the job to validate INVOICE TYPE in the user's source column/field to be either IN or PP and never blank or null?

    Please help!!! Very simple VI job has been in use since 2015, maybe earlier. But within the last year, we have had at least 3 incidents, and want to make sure that if user forgets to populate this column of the AR cash receipts excel template, the record…

  • VI - Import Inventory Adjustments - Transaction Date = "Today" ?

    I am trying to create a VI - Import job into the IM_TransactoinHeader table. For the field, TransactionDate, we are wanting to ASSN <MODULEDATE> or <TODAY>, but keeps receiving error about invalid date. "20230609 This is an invalid date." I've tried…

  • Use VI to Import So Invoices and create So Invoice batch

    I am looking to import sales orders either into sales order invoice and create an invoice batch or import into sales order shipping data entry. Of course it would be ideal if it would pull the lines in without having to give each line item its own line…

  • AR_CashReceiptsDetail table missing in VI Import Job Maintenance

    I'm working on an import job to enter cash receipts and don't have the AR_CashReceiptsDetail table in the table list. I see it when I'm in export job maintenance, just not import. What am I missing?

  • VI job to import cash receipts

    I've been tasked with creating a VI job to import cash receipts and am new to using VI. Actually, fairly new to Sage, but I come with some relational database experience. I am having issues linking the AR_CashReceiptsDeposit and AR_CashReceiptsDetail…

  • VI Import - Split a data row into multiple detail lines?

    Hi, We want to import a sheet from a client that sends us a csv of monthly invoice info. Some lines on the csv need to be split into 2 and occasionally 3 lines, based on the data. I can parse the line fine, but is there a way to have multiple detail…

  • Visual Integrator Importing (and removing) Paperless Office for Contacts

    I set up a VI job to set paperless office settings for all of our customers so it would email their A/R Statement to a contact code (rather than the customer email). Now I'm trying to figure out how I can remove that contact code using a similar job …

  • VI job for PO receipt of goods - T Record Invalid or Write Failed

    I've been working on a VI Import job for PO receipt of goods, serialized items. I think I am close, but I am running into this error: T Record Invalid or Write Failed. I've scoured the net, Sage City, Knowledgebase for a solution but no luck. Does anyone…

  • VI Import Job Expression Builder IF THEN ELSE Statement

    How can I use an IF THEN ELSE statement in the Expression Builder when importing a job? I keep getting a syntax error. For my current example: I'm looking to import item shipping weights. I already have my import value assigned to Temp001 . So now I…

*Community Hub is the new name for Sage City