Sage 100

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…

Trying to upload a budget file. However, when I test the upload I am getting errors where the 3rd segment of a GL account number is being left off and causing the error XXXXX-XX- is not on file. However, other GL accounts are loading just fine. Our…

I'm trying to create a VI Import job to bring in some general journal entries but can't seem to figure out to grab the next Entry No automatically like I can with Batch Numbers and Invoice Numbers. I can't get them to import properly without actually…

I've been tasked with creating an AR Invoice import job with the input file not having an invoice number. Looking for a way to have a "Run Assign" field that would prompt for the next invoice number to use and then increment that number upon change…

need to import Quantity used in to work tickets. I have a VI Import to JT_Transaction that when run populated the JT_Transasction file. Seen in DFDM. However, it does not show in the work ticket; the exploded sales order nor does the quantity appear…

Working on Sage 100 v2016 and trying to figure out how to import cash receipts using one file when the file does not contain a Deposit Number. I don't believe I can use the 'NEXT' operation because my Cash Receipts Header/Detail import needs to use the…

I am needing to run an Open Balance Export job that contains specific headers that are located on different tables. The primary table I'm using is the `AR_OpenInvoice`, to which I am attempting to link to the `AR_InvoiceHistoryHeader` table. The problem…

How can I use a Sage UDT SQL table as a source for a VI job?

Have the following source file (CSV) 2 questions: 1 - I want to import the Invoice No and append "-CM". Is this possible? 2 - Importing the lines Distribution Amount from the Credit Column. How do I reverse the sign so it comes in as a negative…

Running Sage 100 Premium 2021: need to reduce the size of the AR Invoice History tables. The purge invoice history utility is good as far as it goes, but I need to remove invoices for only one division that creates thousands of repetitive invoices monthly…

Client is running Sage 100 v2018 and have asked for a VI import of cash receipts. They scan in information and save it as a csv. However, the information does not include Customer Number...only Invoice Number. Within the Sage 100 Company where the data…

I am hoping to streamline my VI script designed to import AR credit memos. If entered manually I only enter CM <Next Invoice>, Customer Number, Apply To Invoice. I am then asked "Do you want to copy invoice information from history?" Clicking Yes allows…

Client running Sage 100 v2018. Trying to export purchase order information based on two select criteria that is outside standard fields. I'm able to create a Perform for the individual selections and when I add one of the two perform functions to the…

I'm doing an import job maintenance. Our PO has the field L.QuantityOrdered as 12 and L.UnitOfMeasure as "EA". In Sage, the Item has a Sales UOM of "CS6", which translates to 6. So when we import the order, the PO means 12 total, but the system…

When exporting payment history for AP I am only getting a few years information. If I run a report I can see the system has 20 years worth of data but its only giving me 2+ years which is more like just the time frame for viewing in the system. I tried…

Trying to import POs with different Units of Measure in the lines. Inventory item is set up with Purchase UOM TON and Sales UOM LB. For some reason, the imported PO has a quality error (when UOM is different from the Purchase UOM, it multiply the conversion…

I'm trying to create a job to change dates for Work orders. Some WO through errors like this when the Revision Code has any letters. Some of our revisions are just numbers like the ### but some do have some letters which are allowed in the Bill of Materials…

I have a CSV file with new employee pay rates for a couple hundred hourly employees. Is it possible/advisable to import the new rates with a visual integrator job, and have the change appear on the "Pay Rate Change Report". Thanks!

Our client has a system in place that kicks out a dept code. This department code has been directly linked to a G/L account by utilizing the AP Expense Distribution Table (Code 5 on the Distribution Table is equivalent to the G/L account we want to import…

Hi all, I hope everybody is doing well. I apologize in advance if I post this in the wrong section. I recently discovered the Visual Integrator module for Sage 100 and have been trying to learn how to create a job that imports an Excel spreadsheet…

I feel like I should know this, but for some reason I'm struggling with this VI job. I am importing into AR Invoice Data Entry. My file has over 400 lines in it. What I want to happen is have the import assign the Next new invoice number, once. However…

Hi, I am attempting to export the JT_Template table to turn around and import the file in another company. The only field not coming through the export is the Text field from tab 6 of WT Template Maintenance. The field in the Data tab of the export says…

Running SAGE 100 v2018 and exporting a file using VI that requires the current date and time be appended to the file. Is there a way to accomplish this using the Perform option within the VI Export job or do I need to create a separate batch process once…

I am trying to figure out how to create a VI job to be able to change all of the customers for a sales person to email Sales Order & S/O invoices. I've tried exporting AR_CustomerDocuments and AR_CustomerDocumentsContacts, but neither of those seem to…

I've encountered problems while trying to use SAGE 100's Visual Integrator to export data from Job Cost's JobHistoryTransDetail table to a SAGE 100 User Defined Table? I need to export all of the JobHistoryTransDetail table records for a desired date…