Open Invoice Load

Im trying to load some AR and AP invoices using Open Invoice Load via DMT. It (both the Client version and DMT) seems to be a bit confused as to whether I should used signed values on credit notes/debit notes and whether I should upload tax amounts as signed or unsigned. Anyone got any expereince of this?

Credit memos amount and tax amounts as as positive and the ceditmemo flag is set to credit.

Split your AR Invoices and Credit memos to two imports and run the invoices first. This solves issues you might have any credit memos that might apply to invoices.

For AP, it does not appear to make a difference if you run AP invoices and Debit memos at the same time.

If you are importing from another system. I suggest you setup a UD field or fields that identify the type and invoice number from your old system.

1 Like