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 and can therefore not itemize the invoices I send to customers (I have to lump the entire month in to one line).  Does anyone know a way to import that I can have multiple lines (say 2 hours on way day and 3 another, etc)?  I tried just putting the same invoice number multiple times in my Import spreadsheet, but it gives me an error that the invoice number has already been used.

Thanks!!!!!

  • 0

    Hi dgangelhoff,

    Consider setting up an open-source eCommerce front-end where your contractors can enter their hours for specific customers and then use the www.CartSpan.com eCommerce integration for Sage 50 to automatically import your items and create your invoices.

    Scott

  • 0

    For each invoice you would have the same reference number for each line item to appear on the invoice and then the import field "Number of Distributions" would be the number of lines in the invoice.  The import process will read the Number of Distributions field to determine how many lines are in the invoice and then it will validate each line to be sure it has the same Customer ID, Reference #.