Is there a reason you can't set it up as one pound per kilogram?
-David
On May 16, 2008, at 11:38 PM, Raj Saini wrote:
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
