I think I understand what you are saying. Correct me if I am wrong.

You buy bottles of a particular product but sell by the ml. You want to calculate the selling price of your selling unit (ml's) using the purchase price of your purchasing unit (bottle).

Since the 1.2 update this feature has been available through the supplier tab in products and through the delivery and invoice workspaces in supplier system.

A product can have multiple suppliers. Each of these has fields for package size, units, list and nett prices and quite a few other settings. The most important one for this exercise is the auto price update checkbox. If this is ticked and the list price (the normal buying price ex tax) changes for the supplier either by manually editing it or during a delivery or invoice entry , the system will automatically divide the list price by the package units and update the unit cost price in any unit prices for the product. It then calculates the new selling prices based on markup and tax settings.

Now if the Nett price (price you actually paid for package) changes but list price doesn't no price recalculation occurs.

You will also note that you can have many suppliers for the same product and many different package sizes. Any can be used to do automatic price updates.

I hope this answers your question :-)

Cheers Tony

-----Original Message----- From: users-bounces@lists.openvpms.org [mailto:users-bounces@lists.openvpms.org]On Behalf Of tlbrewer@optusnet.com.au Sent: Saturday, 25 October 2008 09:36 To: users@lists.openvpms.org Subject: [OpenVPMS Users] Inventory pricing

I do the inventory and seem unable to calculate prices if they need to be a divided unit. It calculates if in a single unit. eg. a 50ml bottle, 50 units per bottle, unable to display total price of bottle then divide into cost and sell price of single unit. hope this makes sense. _______________________________________________ OpenVPMS User Mailing List users@lists.openvpms.org To unsubscribe or change your subscription visit: http://lists.openvpms.org/mailman/listinfo/users

_______________________________________________ OpenVPMS User Mailing List users@lists.openvpms.org To unsubscribe or change your subscription visit: http://lists.openvpms.org/mailman/listinfo/users