• AP Invoice Entry - VI Job

    Hello Everyone, We are currently on Sage 100 Advanced v2018. I am trying to create a VI Job into table AP_InvoiceHeader to load AP Invoices into AP Invoice Entry. but i keep getting an error during load from my Excel FIle that i am using. adding…
  • How to avoid duplicates during VI import into AR_InvoiceHeader

    FormerMember
    FormerMember
    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…
  • Script to conditionally modify discount date during visual integrator job

    Good afternoon. I have a client that wishes to import invoices from a data collection system into Sage 100 ERP 2016. We have a working Visual Integrator job for that purpose. The client has a unique requirement however that they wish to populate the…