• AR Invoice History file size limits or performance hits

    Looking to see how big AR Invoice History Header and Detail files can get before there is a performance hit or a file size limit. We are looking at importing AR invoice details going forward in 2024, instead of a 1 line summary per invoice (actually…
  • 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…