Hi,

I have a situation where shipping prices for weight breaks increments £1 per 1000 gm i.e. £ .001 per gram. (gram is UOM for the said product). Field type for weightUnitPrice is defined as currency-amount and in PostgreSQL it is mapped as numeric(18, 2). Due to this, shipment cost estimate entry I create truncates the price to 0 instead of .001.

I believe this is a common scenario for weight breaks where price increments can be very small for a UOM like gram. I have been thinking of using the fieldType currency-precision instead of currency-amount. Currency precision is mapped as numeric(18,3) in PostgreSQL. Is this the right thing to do or there are better alternatives?

Thanks,

Raj




Reply via email to