• 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…
  • VI Error, L record AddLine() Failed. Missing or invalid header.

    I am trying to import payroll as I do every pay period. But for some reason I keep getting this error today. My VI import job for payroll has not changed, and has worked for years...until today. Any direction where I could get some help to fix the issue…
  • VI Job for Inventory Adjustments

    Hi there, I hope you can help me. I created a job to import data for a positive inventory adjustment, and I need to specify the unit cost. We are using Scanforce multi-bin software, so we also need to specify the bin and lot. The issue is that the job…
  • How to avoid triggering pre-total events for each line of the same imported invoice?

    I've developed a script that, for some customers, discounts TX ItemCode's to absorb their AvaTax calculated sales tax and present a invoice total including sales tax (but not freight) equal to the original net invoice, but when the invoice is imported…