Browse By Tags

  • 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…
  • Import error message

    Does anyone else get error messages when they import cash receipts? I have been using the same template for years, and now I get an error message
  • Is it possible to import quick bill invoices or non-contract invoices?

    I have been able to find the import layout for AR Invoice Import but it looks as if this is using contract based type billing for the imports. Is there anyway to import an invoice as a quick bill with standard items on it?
  • 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…
  • Delete range of Customers

    I imported thousands of customers in Sage 300. How can I delete a range of customers in the system? I called Sage Support and they said you need to delete one at a time. Is this true? I have to click delete 10000+ times. Isn't there a utility to do…
  • Importing in AR Receipts using single line items

    I know how to import into AR Receipts in Sage 300. Is there a way where Sage 300 can read single line items per transaction. For example, on the import file, I just want a single line item on the CSV for every cash receipt. Right now, Sage 300 requires…
  • File customer does not exist. Please specify an existing file???

    Please Help! Since I upgraded from 6.0 to 6.2 2014 PU3, when I import file on AR customers I have this error message :'File customer does not exist. Please specify an existing file' Any clue?
  • Import Invoices with multiple line items

    My company downloads a spreadsheet each month of billable hours that our contractors put in to a database. I then Import them in to Peachtree as Accounts Receivables, which creates invoices. In my spreadsheet, I have to put each line as a different invoice…