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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
