Posted by
David Garrett on
Oct 01, 2005; 1:55pm
URL: http://ofbiz.116.s1.nabble.com/OFBiz-Users-VAT-and-rounding-tp135121p135140.html
Tarlika,
OK I agree.
I was looking for what I thought were simple solutions. That being sticking
to what I understand as the Ofbiz structure based around the net price.
In a VAT world the need is to work from the gross price.
In a sales tax world the need is to work from the net price.
I am interested to see David's comments as to what the best way forward
might be.
I am still thinking my best short-term solution may be to work with high
precision net prices.
Tarlika, have you implemented a VAT solution that I may be able to use as a
model for my required implementation?
Regards
David G
-----Original Message-----
From:
[hidden email] [mailto:
[hidden email]]
On Behalf Of T E Schmitz
Sent: Saturday, 1 October 2005 9:33 PM
To: OFBiz Users / Usage Discussion
Subject: Re: [OFBiz] Users - VAT and rounding
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
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users