precision of price fields

[Vince Clark]

This is an issue with Purchase Orders, not sales orders. Our client buys large quantities of items from suppliers that sell in bulk. The supplier prices their products in volume, so you might buy a pack of 100 for a single price. However, our client inventories everything in pieces. This causes the individual unit cost to be very small, requiring more precision. We accommodated this in SupplierProduct by altering lastPrice field to be fixed-point instead of currency precise. I'm thinking of doing the same on OrderItem.unitPrice and am wondering if anyone can think of any negative implications. I need to do this in order to place the proper quantity and unit price on purchase orders. Alternatively if there is a way to capture the "vendor qty" on the order and purchase in those qty's that might be better.



Vince Clark
www.globalera.com
[hidden email]
[phone] office
[phone] cell