A customer is going on-line transferring invoices, credits (and maybe payments) from an AR Open Item list of the "existing" Accounting System.

What is the SQL command to add, invoices, credit invoices as statement charges (not into the invoice file as I have no line items or tax information)?  What is the name of the file to add this information to.

How do I tie the credits or payments into the open invoices?  It may be less time consuming to have the customer enter those open credits/payments so entering the open invoices is mandatory.  I would perform this task at the end of a month after the purge is performed on their own system to minimize this problem.

Of course I would have the listid of the customer when doing this process.

Thanks

Victor Nahigian

This is a little beyond the scope of this forum at the moment.

The traditional approch for open invoices is to follow the: How do I create a new Customer, invoice them and mark the invoice as paid?  procedure or if the sale is already paid, it's to use Sales Receipts: How do I create a Sales Receipt using QODBC?