I am importing orders (and writing them from scratch) with item costs at three decimal digits. I have changed order.decimals to 3.
However, I end up with amounts like .466 truncated to .46 I looked at OrderItem and OrderItemBilling definitions and amount is a currency-amount which is defined as NUMERIC(18,2) I am wondering what is the best way to solve this problem. I am thinking of changing the schema for OrderItem and OrderItemBilling to be floating-point. I could also change the fieldtypepostgres.xml to be NUMERIC(18,3). However, I only want the sold item prices to be three decimal digits, and not the totals and so forth. Anyone have any advice? Skip No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.0/1381 - Release Date: 4/16/2008 9:34 AM
