• Visual Integrator; Importing into SO_InvoiceHeader and Leaves Back Order

    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…
  • Visual Integrator Import Sales Orders Referencing a Master Order

    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…
  • VI PO Receipt of Goods both Lot and Avg items in the same receipt

    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?
  • VI Job for work order transactions - Job validations contain obsolete file references that no longer exist in the dictionary. Job will be deleted.

    Client is currently on Sage 100 2016. We are in the process of updating to 2018. Client has an import job for work order that I created many years ago. As I recall it was a particularly difficult import to create. It still works nicely and is used on…