Hi,
Ofbiz must be capable of calculating tax or vat correctly (the term vat is
used in the UK to describe tax on goods, tax at a rate of 17.5%).
TO BE CLEAR;
THE CALCULATION OF TAX IS THE PROBLEM.
THE CALCULATION OF PRODUCTS IS CORRECT.
'arithmetic.properties' is the file I have been working with. Essentially
there are three parameters I have looked at that control the rounding and
length of decimals used with regards to calculation of tax or vat.
salestax.calc.decimals = 3
salestax.final.decimals = 2
salestax.rounding = ROUND_HALF_UP
It is safe to say that I have tried every combination of 'Big Decimal'
rounding field types and 'decimals' length (for salestax.calc.decimals and
salestax.final.decimals) without any success!
I have of course been stopping and restarting the server after each change
to reload the file at startup. Even tried some crazy wild figures just to
ensure that I was getting a different figure, to ensure the process works.
Therefore, there must be other files that also have some bearing on this
calculation. Does anyone know what other files maybe relevant?
VERY HAPPY TO PAY SOMEONE 'US$500' for a solution at this point. On
condition that the solution actually works and produces the figures below,
only one payment to the first working model will be paid;
-------------------------------------------------
price tax product+tax
-------------------------------------------------
Product1 35.74 6.2545 41.995
Product2 35.74 6.2545 41.995
-------------------------------------------------
Product Total 71.48
Shipping 6.00 1.050 7.050
Tax (17.5%) 13.56 13.559
-------------------------------------------------
Grand Total 91.04 91.039
-------------------------------------------------
Let's see if someone can prove to me that Ofbiz is capable of calculating
vat correctly. Had this issue open is various threads for around a month.
Thanks & Regards,
Peter
-----Original Message-----
From: Scott Gray [mailto:[EMAIL PROTECTED]
Sent: 18 April 2007 10:50
To: user@ofbiz.apache.org
Subject: Re: Doesn't calculate tax correctly...Inaccurate Calculation of
Order Total
Hi Peter
Did you try what I suggested?
>Change this line:
>salestax.calc.decimals = 10
>and see if that gives you the results you are expecting.
Regards
Scott
On 18/04/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> Actually 91.04 is what i need as a result, but i can't seem to get Ofbiz
> to reproduce this result. Technically right now Ofbiz is not calculating
it
> correctly. I have tried most permatations of the big decimal class and a
> varying the digit length and mostly get 91.03 or 91.05.
>
> Surely, Ofbiz must be able to calculate the tax (at 17.5%) correctly, it
> is such a basic requirement.
>
> I must be overlooking something. Anyone, can you help.
>
>
> Thanks & Regards,
>
> Peter.
>
>
> - original message -
> Subject: Re: The Return of...Inaccurate Calculation of Order
> From: "BJ Freeman" <[EMAIL PROTECTED]>
> Date: 18/04/2007 02:19
>
> if I read this right
> Grand Total 91.04 91.039
> so if you round to two places on 91.039 you get 91.04
> which means they equal.
>
> [EMAIL PROTECTED] sent the following on 4/17/2007 4:00 PM:
> > Hi,
> >
> >
> >
> >
> >
> > There is something very odd about the way Ofbiz calculates tax (in the
> order
> > manager).
> >
> >
> >
> > Using this model from Excel;
> >
> > US$ price tax p+tax
> >
> > Product1 35.74 6.2545 41.995
> >
> > Product2 35.74 6.2545 41.995
> >
> > Shipping 6.00 1.050 7.050
> >
> > Total 77.48 (3 digit)
> >
> > Tax 13.56 13.559
> >
> > -------------------------------------------------
> >
> > Grand Total 91.04 91.039
> >
> >
> >
> >
> >
> > Method1 gives 91.05
> >
> > Method2 gives 91.03
> >
> >
> >
> > Tried each of the different big-decimal rounding scheme, not give the
> value
> > I was expecting (91.04). I get either 91.03 or 91.05
> >
> >
> >
> >
> >
> >>From the arithmetic.properties file;
> >
> >
> >
> > METHOD1
> >
> > # Most companies would want their sales tax calculations ALWAYS to round
> up
> > (ie, 100.081 becomes 100.09)
> >
> > # This could be ROUND_CEILING or ROUND_UP. (The difference is that
> > ROUND_CEILING rounds towards positive infinity,
> >
> > # ROUND_UP away from zero. So, for 1.13, both ROUND_UP and
> ROUND_CEILING
> > will round to 1.2, but for -1.13,
> >
> > # ROUND_UP gives you -1.2 and ROUND_CEILING -1.1.)
> >
> > salestax.calc.decimals = 2
> >
> > salestax.final.decimals = 2
> >
> > salestax.rounding = ROUND_HALF_UP
> >
> >
> >
> > METHOD2
> >
> > # Most companies would want their sales tax calculations ALWAYS to round
> up
> > (ie, 100.081 becomes 100.09)
> >
> > # This could be ROUND_CEILING or ROUND_UP. (The difference is that
> > ROUND_CEILING rounds towards positive infinity,
> >
> > # ROUND_UP away from zero. So, for 1.13, both ROUND_UP and
> ROUND_CEILING
> > will round to 1.2, but for -1.13,
> >
> > # ROUND_UP gives you -1.2 and ROUND_CEILING -1.1.)
> >
> > salestax.calc.decimals = 3
> >
> > salestax.final.decimals = 2
> >
> > salestax.rounding = ROUND_HALF_UP
> >
> >
> >
> >
> >
> > Thanks & Regards,
> >
> >
> >
> > Peter
> >
> >
> >
> > _____
> >
> > From: Tim Ruppert [mailto:[EMAIL PROTECTED]
> > Sent: 16 April 2007 19:06
> > To: user@ofbiz.apache.org
> > Cc: 'Chris Howe'
> > Subject: Re: The Return of...Inaccurate Calculation of Order
> >
> >
> >
> > He means - kill the process - and then restart it. Shut it down and
> start it
> > up.
> >
> >
> >
> >
> >
> > Cheers,
> >
> > Tim
> >
> > --
> >
> > Tim Ruppert
> >
> > HotWax Media
> >
> > http://www.hotwaxmedia.com
> >
> >
> >
> > o:801.649.6594
> >
> > f:801.649.6595
> >
> >
> >
> >
> >
> >
> >
> > On Apr 16, 2007, at 12:02 PM, <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> wrote:
> >
> >
> >
> >
> >
> > Hi Chris,
> >
> >
> >
> >
> >
> > Thanks very much for your quick response.
> >
> >
> >
> > Exactly do you mean by 'restart ofbiz', by your definition?
> >
> >
> >
> >
> >
> > Thanks & Regards,
> >
> >
> >
> > Peter
> >
> >
> >
> > -----Original Message-----
> >
> > From: Chris Howe [mailto:[EMAIL PROTECTED]
> >
> > Sent: 16 April 2007 18:04
> >
> > To: user@ofbiz.apache.org; [EMAIL PROTECTED]
> >
> > Subject: Re: The Return of...Inaccurate Calculation of Order
> >
> >
> >
> > Hi Peter,
> >
> >
> >
> > You need to restart OFBiz, not just clear the cache. Hope that helps.
> >
> >
> >
> >
> >
> > --- [EMAIL PROTECTED] wrote:
> >
> >
> >
> > Hi,
> >
> >
> >
> >
> >
> > Sure hope you can help with this, I have been going around in
> >
> > circles.
> >
> >
> >
> > I am having a problem with the way that Ofbiz calculates tax and
> >
> > order
> >
> > totals.
> >
> >
> >
> >>From what I can gather, the file
> >
> > './applications/accounting/config/arithmetic.properties' controls the
> >
> > rounding and digit length for the calculation of taxes & order
> >
> > totals.
> >
> >
> >
> > I am starting to think the changes I make to the file are not being
> >
> > applied,
> >
> > I say this because when I look at the 'Unit Price' in an order it
> >
> > shows
> >
> > 35.742, rather than 35.74. Which would tend to indicate that settings
> >
> > are
> >
> > not being used because the number of decimal points in each of the
> >
> > settings
> >
> > in 'arithmetic.properties' are set to 2 digits. I have pasted in the
> >
> > contents of the 'arithmetic.properties' file below so you can have a
> >
> > look. I
> >
> > have changed the 'rounding' to a different method to try to achieve
> >
> > the
> >
> > correct figures.
> >
> >
> >
> > There is only a disparity of +0.1 but, technically it is wrong. Ofbiz
> >
> > keeps
> >
> > giving me a total of 91.05, but it should be 91.04. I am been given a
> >
> > hard
> >
> > time about it...
> >
> >
> >
> > Essentially;
> >
> >
> >
> > Using Excel;
> >
> > US$ tax p+tax
> >
> > Product1 35.74 6.2545 41.995
> >
> > Product2 35.74 6.2545 41.995
> >
> > Shipping 6.00 1.050 7.050
> >
> > Total 77.48 (3 digit)
> >
> > Tax 13.56 13.559
> >
> > ------------------------
> >
> > Grand Total 91.04 91.039
> >
> >
> >
> > Simply put, I think that the problem is a combination of two issues;
> >
> > (i). Ofbiz uses 3 digits, not 2 digits (I would like to use 2
> >
> > digits).
> >
> > and
> >
> > (ii). Uses rounding 'ROUND_HALF_UP', I would tend to use
> >
> > 'ROUND_HALF_DOWN'.
> >
> > I think the 'arithmetic.properties' file below, should do the trick.
> >
> > But it
> >
> > doesn't seem to being 'applied' to the calculation.
> >
> >
> >
> >
> >
> > So I have two Questions;
> >
> >
> >
> > 1). (BIGGEST ISSUE) Do I have to 'activate' the
> >
> > 'arithmetic.properties'
> >
> > file, and if so how do I do that? (All I have been doing is clearing
> >
> > the
> >
> > cache and logging out then logging in again, as I had been told this
> >
> > is the
> >
> > way to do it).
> >
> > 2). Do you see my point about 94.05 and 94.04, and the best way to
> >
> > make this
> >
> > calculation?
> >
> >
> >
> >
> >
> > ---CONTENTS OF---
> >
> >
> >
> > .../Ofbiz/trunk/applications/accounting/config/arithmetic.properties
> >
> >
> >
> >
> >
> > #
> >
> > # Arithmetic properties for configuring BigDecimal calculations
> >
> > #
> >
> >
> >
> > # For setting decimal precision and rounding method of operations
> >
> > related to
> >
> > invoices
> >
> > invoice.decimals = 2
> >
> > invoice.rounding = ROUND_HALF_DOWN
> >
> >
> >
> > # For setting decimal precision and rounding method of operations
> >
> > related to
> >
> > orders,
> >
> > # such as shopping cart amounts and order amounts
> >
> > order.decimals = 2
> >
> > order.rounding = ROUND_HALF_DOWN
> >
> >
> >
> > # For setting decimal precision and rounding method of operations
> >
> > related to
> >
> > customer accounts
> >
> > # such as Financial Accounts
> >
> > finaccount.decimals = 2
> >
> > finaccount.rounding = ROUND_HALF_DOWN
> >
> >
> >
> > # Most companies would want their sales tax calculations ALWAYS to
> >
> > round up
> >
> > (ie, 100.081 becomes 100.09)
> >
> > # This could be ROUND_CEILING or ROUND_UP. (The difference is that
> >
> > ROUND_CEILING rounds towards positive infinity,
> >
> > # ROUND_UP away from zero. So, for 1.13, both ROUND_UP and
> >
> > ROUND_CEILING
> >
> > will round to 1.2, but for -1.13,
> >
> > # ROUND_UP gives you -1.2 and ROUND_CEILING -1.1.)
> >
> > salestax.calc.decimals = 2
> >
> > salestax.final.decimals = 2
> >
> > salestax.rounding = ROUND_HALF_DOWN
> >
> >
> >
> >
> >
> >
> >
> > Thanks & Regards,
> >
> >
> >
> > Peter
> >
> >
> >
> >
> >
> > ________________________________________
> >
> >
> >
> > On 05/04/07, [EMAIL PROTECTED] < [EMAIL PROTECTED]> wrote:
> >
> > Hi Scott,
> >
> >
> >
> >
> >
> > Just strikes me that the file should be 'correct' for everyone. What
> >
> > would
> >
> > be your guidance as to what the file should be?
> >
> >
> >
> > Appreciate your fast responses this evening. It is 1:15am here in the
> >
> > UK
> >
> > just can't stay awake any more.
> >
> >
> >
> >
> >
> > Thanks & Regards,
> >
> >
> >
> > Peter
> >
> >
> >
> >
> >
> >
> >
> > ________________________________________
> >
> > From: Scott Gray [mailto: [EMAIL PROTECTED]
> >
> > Sent: 05 April 2007 01:16
> >
> > To: user@ofbiz.apache.org; [EMAIL PROTECTED]
> >
> >
> >
> > Subject: Re: Inaccurate Calculation of Order
> >
> >
> >
> > Here is the configuration file, you can change the settings to
> >
> > whatever you
> >
> > want them to be:
> >
> >
> >
> >
>
http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/config/arit
> >
> > hmetic.properties?view=markup
> >
> >
> >
> >>From the default settings, it looks like calculation takes place at 3
> >
> > digits
> >
> > then gets rounded up to 2 places.
> >
> >
> >
> > Regards
> >
> > Scott
> >
> > On 05/04/07, [EMAIL PROTECTED] < [EMAIL PROTECTED]> wrote:
> >
> > Hi,
> >
> >
> >
> >
> >
> > There must be something we are missing here. This can't be a bug,
> >
> > someone
> >
> > would have noticed already. Especially something so fundimental.
> >
> >
> >
> >
> >
> > Thanks & Regards,
> >
> >
> >
> > Peter
> >
> >
> >
> >
> >
> > -----Original Message-----
> >
> > From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]
> >
> > Sent: 05 April 2007 00:11
> >
> > To: 'user@ofbiz.apache.org '
> >
> > Subject: RE: Inaccurate Calculation of Order
> >
> > Importance: High
> >
> >
> >
> > Hi,
> >
> >
> >
> >
> >
> > Whichever way I work it out the Order Entry system does seem to be
> >
> > slightly
> >
> > out.
> >
> >
> >
> >
> >
> >>From Excel...
> >
> >
> >
> > Price tax 2 digits tax 3 digits tax 9
> >
> > digits
> >
> >
> >
> > Product 1 35.74 6.25 6.255
> >
> > 6.254500000
> >
> > Product 2 35.74 6.25 6.255
> >
> > 6.254500000
> >
> > shipping 6 1.05 1.050
> >
> >
> >
> > === message truncated ===
> >
> >
> >
> >
> >
> >
>
>
