Comment 2 for bug 1045851

ThinkOpen,

We just faced this issue suddenly on a live database where we started applying x.y% discounts via pricelist.

We actually faced them on bank statements.

You will always get such errors if your amounts are x.33333, x.6666.

In order to fix, we propose these ways:
1. Set Account decimal accuracy to be 4, which is an accurate solution.
-- We could not move on with this solution because our accountants do not need 4accuracy on reports and also on view.

2. Round every ugly looking float value to 4 (when its a price subtotal) and when used in making accounting entries, get them rounded by 2.
-- We could not enjoy the solution because our values are uglier.

3. Have an account that stores your difference, could it be 0.01,0.002, etc. Knowingly you wanna reconcile them, let them through validated and reconciled.

Hope this helps.

Thanks.