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
- weightUnitPrice field type of ShipmentCostEstimate entity Raj Saini
-