VAT amount in sales invoices

GD

hello,

i have a small problem, i want in a sales invoice to print in each item detail line the Vat amount, and not the VAT identifier. I tried to take it from the Vat Amount Line record but in each detail line it sums the amount of the previous detail line.

any help?

george

Fermi

You can take the amount in the field VAT Base amount of each sales line, and using the VAT %, calculate the VAT Amount for that line.

It's a quite peculiar solution, but it can work.

Albertvh

or you could use

Oustanding amount - line amount excl. vat

Mauddib

What IS the best way in code to find the excluding and including price of a unit on each line of an order

when its released there is loads of ways with unit price, unit price excl vat, line amount, line amount excl vat, amount, vat base amount, loads of them....

However most of these fields are empty when the order is open. Which method is the safest and best to find the two values on an open order? Bearing in mind of course that "prices including vat" can be ticked sometimes and not others.