Sage 100

Hi Everyone, I am trying to export the AP_CheckDetail and CheckHeader information but I need to have a counter on the invoices. There is a field NumberOfDetailLines but if the Check has 5 invoices this field shows 5 but I need to have each invoice…

I use VI to regularly import sales orders. In this case, I would like to reference an existing master order, as the only data that needs to change per order is the header comment. As I have several master orders to reference, it would be nice to populate…

I am trying to export a report, by vendor (or product line), of the quantity of items sold AND issued for the last 12 months. We would like to be able to export it using any custom date range that we want. What is the best way of getting this data? I…

OK. This has me flustered. I have figured out how to use Temp fields in Vi for Sage 100 2019 to create a single SO that has multiple items on it. The data source I'm using has a separate row for each item purchased, and my current VI job creates one…

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…

Hello! I am trying to find a way to automatically export sales order data (specifically ship date) from business insights sales order view into a locked excel document provided by my customer. It would be nice if i could filter a whole list of orders…

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…

I've uploaded multiple Journal Entries from the VI. How can I post only 1 at a time? (in the example below, I am ready to post GJ-000005, but not GJ-000004 just yet) Will Sage 100 post whatever is in the queue even though the JE contains zero or has been…

We have a long time customer that has been running a batch file that launches a VI job. The first job chains to another and so on for several jobs. They are and have been Sage 100 premium, we just upgraded them to 2020. The batch file works and all the…

Can a VI job be setup to total a column on your source file? For example if importing cash receipts I have a column in my source file pointing to the Line Amount Posted and I want the job to sum up that column by customer and put the amount in the Header…

Hello everyone, I received existing import job with defined perform logic The import job contains Command "CREATE_ERRORLOG" on Failure. Сan anyone tell me where I can find this error log? Also, Is there a link where listed all available commands…

Can someone explain the purpose of the Cycle Option in VI. I have read what documentation I can find but want a "real world" explanation of how it is used. I am hoping it will cause my VI Job to complete. I have a bat file that is run from Windows Task…

All, I'll try and be concise. I am working with Sage100 2019 and Visual Integrator Jobs. We just moved up from Mas90 4.3. Whoa, I know. Here's my dilemma: In Mas90, we had a VI job that would bring in website orders in a csv formatted file and import…

W/O-Legacy experts, I need help! I have been trying to set up a VI job to import W/O material transactions. I followed the KB advice to create an export job, and look at the fields that are populated, I also double-checked that I am using the proper…

I'm trying to recreate PO Receipt of Goods from history. I can't seem to import to a PO where 10 lines are lot distributed and 1 line is not. What field can i add to distinguish between them?

We have an export for item quantities. At the moment we're exporting 3 columns of data which include "Item Code", "Temp001" (which is a calculated field), and "Suggested Retail Price". We're having negative numbers that are exporting in the "Temp001…

Hello, I've used VI jobs for various import and export jobs to import things from sales order info to bill structure. I dont use a lot of conditional based columns. What im trying to do is have the ShipExpireDate be 5 business days added to the order…

Good day; Newbie here, any help is greatly appreciated. I created a VI job to export the previous day invoice no,, day, customer number, customer name. I am exporting this data from table "AR_InvoiceHistory Header". No management wants me to also…

Wrote a simple script for client that has a pop up if when entering SO, you forget to put in qty ordered on lines page and you try to go to the next line pop up says please enter qty ordered. The script works great on my install. Tried to install on client…

I am running a VI import to import AR invoices into AR Invoice Data entry to post Invoice to Customer accounts. The import works I am using an assigned Misc Item code that contains a GL Account number for Sales. But when I try to post the invoice I get…

I need to know if there is a script or perform logic that can help my situation. - I have a VI Import Job importing Invoices from Sales Orders - The source file does NOT contain the Misc or Charge items from the SO Can this be done without the…

Hi, In importing through VI into IM_TransactionHeader (which also has L and LL), how do I use "Next" operation for EntryNo and apply the first EntryNo generated to all L and LL lines?? Or should I be using different Operation or can I simply not achieve…

I would like to automate some Visual Integrator Exports. However, I need to use the Select Tab to make sure each time the export runs the correct records are selected. I found the following formula helpful on the Sage Knowledgebase...and it works based…

Importing new costs into IM_TransactionHeader. Serialized inventory. I'm importing a negative adjustment quantity, updating, then importing a positive adjustment with the new cost. The positive adjustment uses the old cost (from the negative adjustment…