problem to import invoices!!

[Former Member]

Hi all,

when I import some invoices by DTW I have an automatic discount of "15.25", yet I put the field "DiscountPercent

" to 0. why?

Thx for any help.

[Former Member · Accepted solution]

Hi Trad,

If the total amount of the lines does not add up to the total amount of the invoice then SBO assumes that there is a discount to validate the difference between the two. Make sure that your lines adds up (after Tax and other Discounts) to the total of the Header record. Try posting the exact amounts on the lines with the same customer in the GUI of SBO and see what the document total comes to.

Hope it helps,

Adele

[Former Member · Accepted solution]

Hi,

The total amount of the lines and the total amount of the invoice are equal, but the total amounts are before tax and other Discounts (DTW doesn't accept the amounts after Tax and other Discounts: error).

Can someone give me an example for the import of the invoices?

thx for advance.

[Former Member · Accepted solution]

Hi,

I will explain this with eg.

DocTotal = 9,200

Line Total = 9,200

Tax = 4%

Discount=0

when we import with above details, system will assume that there is a 3.85% of discount and calculate tax on the remaining amount now the doc total will return to 9,200.

hope this hleps

good day