Sage 100

Looking to see how big AR Invoice History Header and Detail files can get before there is a performance hit or a file size limit. We are looking at importing AR invoice details going forward in 2024, instead of a 1 line summary per invoice (actually…

I'm on Sage 100 Standard 2020 (v6.20.1.0). We create sales orders, and then after each sales order ships, invoices are imported into a SO_InvoiceHeader batch. When the batch is posted, all the sales orders are supposed to disappear from SO_SalesOrderHeader…

The original statement we have is as follows - Temp001$=“458” I want to include "459". How should the formula look? Temp001$=“458, 459" or Temp001$=“458” or Temp001$=“459”

I am putting together a VI import job to import invoices into the AR_InvoiceHeader table in Sage 100 2016. The import appears to be identifying the headers and line items appropriately, however it does not skip duplicates as all existing invoices are…

Hi, I am trying to load some sales orders using VI, the file that the customer is sending has some unwanted charecters in the ship to name field. I am wanting to remove them during the import. i noticed in the field properties of the ship to name…

we use visual integrator to import sales orders. I have a customer that sends us a csv file and on that file we have header and detail information on each line. so i would see something like: PO#, Vendor#, Shipto, item#, model#, sku#, ship date, qty…