[OFBIZ-494] Support for prices in multiple decimal places

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: order
• Sprint: Bug Crush Event - 21/2/2015
• Assignee: Unassigned
• Reporter: Si Chen
• Created: 25/Nov/06 00:05
• Updated: 26/Feb/15 19:34

Description

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.

Issue Links

• depends upon: OFBIZ-490 UtilFormatOut to use default.currency.decimals
• relates to: OFBIZ-224 Problem with approximations if the ShoppingCart.basePrice has more than three decimal digits.