I currently have a VI job that we use to import commissions invoices. We obtain those commissions from a separate software. Here is a screen shot.
I am looking to modify this in order to adjust an invoice. For example, we pay our corporate credit card statement bill on one date, code it to a specific account, and later go in and "adjust" the invoice and recode it to a new set of accounts without ever changing the invoice amount, date, or invoice comments. This usually results in the recoding of the invoice to as many as 40 different/lines and accounts and is all done manually. For example, if I original coded the payment of the bill for $1,000 to account 1001-526-65, I would recode it later by posting a negative $1,000 to account 1001-526-65 and then code that $1,000 out to many other accounts in different amounts that would total $1,000. I would like to be able to use VI to recode that invoice, or upload a new $0.00 invoice that would be in lieu of recoding the original invoice number.
When I upload a .csv file I have 40 lines. Each line has the same invoice date, invoice number, invoice amount, and it accepts the first row but has exceptions on the rest that all say the invoice is out of balance. Seems like the way I have it written now, you can only code an invoice to one spot per an import.
I appreciate your help.
Sage 100 ERP 2014 5.10.0.6