• Copying the Date value into new date UDF on the Invoice Data Entry

    Hi We have a requirement, where when a new invoice is getting entered in AP, using a VBScript copy the Invoice Date to a new UDF. I did try to put the same using the Post Validate event on the Invoice Date, but it's not copying the data into the new…
  • 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…
  • Help! trying to delete a very wonky invoice situation (delete erroneous invoice header)

    We used a VI job to import manual checks where the invoices were already in the system. We forgot that some of the invoices had leading zeroes, which were lost in the .csv translation. the import created new invoices, with invoice numbers without the…
  • 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…