AR Invoice Import (positive and negative values)

[iwells]

Hi,

I'm trying to perform an AR import using an excel file overall is a net negative balance (TEXTTRX = 3), however the details of the invoice have a mix of positive and negative values with positive and negative taxes.

Basically, we have 2 adjustments as charges that are say (1000) each and a positive charge that's 500. The net balance of the invoice (credit note) is (1500), but because there's a positive charge the taxes on the invoice_details tab don't balance. And that's the issue, the taxes associated with the adjustments are different than the taxes associated with the charge, but because on the header the transaction is specified as a credit note then it sums up all the taxes.

I could be blind because I've been up for a few days in a row, but is there no TEXTTRX equivalent on the invoice_details?

 

[ettienne]

No - that only applies to the header.

 

[DjangMan]

So you have to total the details to see if you have a positive total or a negative total. If positive then you have an invoice. If negative then you have a credit and you flip the signs when you import.

 

[ettienne]

Correct - that's the joy of working with import file. I avoid imports at all costs.