Posted by
T E Schmitz on
Oct 01, 2005; 12:33pm
URL: http://ofbiz.116.s1.nabble.com/OFBiz-Users-VAT-and-rounding-tp135121p135139.html
David Garrett wrote:
> I am suspecting that the solution is
> * more decimals in the price
disagree - it's the line VAT amount which needs more than 2 decimal
digits. 3 would do for the UK; you Aussies need more ;-) : (How much is
/as many decimal points as their system allows/)?
> * a flag priceIncludesVAT in ProductPrice
> * use ProductStore rather than Currency in ProductPrice (this will also
> allow the pre tax price to be calculated.)
Apologies, I don't know OFbiz well enough to comment or understand this
point.
That aside, I don't think we need the net (VAT exclusive) price at all
for our VAT calculations, which are based on gross (VAT inclusive)
prices. For us (VAT countries), the price just needs to be interpreted
as gross price; this is what the consumer sees and pays. Therefore only
2 decimal digits are needed.
The extra digits are just needed for the line VAT amounts.
The bought items will always add up neatly to the order total - no
rounding needed here. It's just the interim VAT calculations which
require higher precision, again resulting in a 2-digit final VAT total.
The net product price doesn't come into it anywhere at a retailer's
because the VAT is calculated at order, not at product level.
> What is the short term impact of me changing ProductPrice.price from
> currency-amount to floating-point.
*Floating point arithmetic is not an option for finacial
applications!!!* See Jira issue 377.
Regards,
Tarlika
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users