[jira] Created: (OFBIZ-494) Support for prices in multiple decimal places

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] Created: (OFBIZ-494) Support for prices in multiple decimal places

Nicolas Malin (Jira)
Support for prices in multiple decimal places
---------------------------------------------

                 Key: OFBIZ-494
                 URL: http://issues.apache.org/jira/browse/OFBIZ-494
             Project: OFBiz (The Open for Business Project)
          Issue Type: Improvement
          Components: order
            Reporter: Si Chen


Support for order and invoicing with prices in multiple (3, 4, + decimal places).

At a basic level it can be supported just by modifying OrderItem.unitPrice and other ._Price fields, ReturnItem.unitPrice, and InvoiceItem.amount to currency-precise types and then changing currency-precise to NUMERIC(18,4) or whatever you need.

David however also suggested that we then create an Order and Invoice line (and by extension probably ReturnItem line) total amount in currency-amount so that the rounding behavior is predictable.  When order/invoice/returns are created those recordes should be updated accordingly.

Also there is the issue of OrderAdjustment.amount being currency-precise and InvoiceItem.amount being currency-amount leading to possible 0.01 rounding errors in some cases.


--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira