• 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…
  • Posting One Journal at a time...

    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…
  • 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?
  • Summarizing Payable Detail in VI Transactional Import

    I am currently using an import in VI that uses the GL Transactional Journal Header table. Currently when I run this the, GL Detail Report gives me a breakdown line by line of every entry hitting the liability account. Is there any way to make this summarize…