inventory management

I need guidance on how to setup an inventory system. The inventory I
am managing is in liquid form and will be added/subtracted in
different units. For example Product A will be added from the supplier
in gallons, distributed out the door in pints, and applied in fluid
ounces. I thought about having a quantity field in the products table
to keep track of this but the only problem I see is which unit do I
store it in? If it's stored in gallons and you subtract only a few
ounces then it won't be very accurate to have a huge decimal number
i.e. you had 5 gallons and subtracted a few ounces so now you have
4.966 gallons left. I could store it in ounces to avoid that but each
product will have different units and it might be difficult to keep
track of all that.

Any suggestions on a good way to handle this? Are there any examples
of inventory/inventory management systems for cake?

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en