The accumulated errors would only really seem to be important on the measure of actual stock held, and presumably the errors would deviate both + / - and so the total error at the inventory end would not be expected to increase exponentially wrt number of transactions applied to it.
Working on the assumption that errors will occur, I imagine the resulting errors from conversion / rounding would be less than the discrepancies of rounding of the precision of the measurement down to the displayed amount to customers (obviously dependant on your usage). unless you are dealing in trace levels of product (again errors would be more likely to arise from physical measuring inaccuracies) The only total error you would need to monitor would be on the total inventory held, rather than the sum of the errors per transaction. The difference between these being is that the inventory held can always be reset to an absolute level after a "restock" if feasible, or on a per container basis or how ever the physical inventory is stored etc. I guess the accuracy / units decision you make would be strongly related to the average size of the transactions applied to the inventory and also the reporting precision of the mechanisms used to deliver the product. On Dec 3, 12:05 am, Dave <[email protected]> wrote: > I have to agree at least if you store in metrics you will ever only have to > convert it once, when you are displaying it. Though this inherently loses > some accuracy, it is exponentially worse if you have to convert a conversion > > On Wed, Dec 2, 2009 at 1:45 PM, fly2279 <[email protected]> wrote: > > I agree that metric would be much easier to convert but therein lies > > the problem. Every time you convert from the user input of imperial to > > metric you lose some accuracy in the total inventory. I guess I just > > need to use the smallest unit to store it in the table and then > > convert when inventory is added/subtracted. > > > Are there any good tutorials/examples on methods to add/subtract > > inventory? Should I be using a 'transactions' table and total those > > transactions to come up with a quantity on hand or will that get out > > of control with thousands of rows? > > > Check out the new CakePHP Questions sitehttp://cakeqs.organd 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]<cake-php%[email protected]>For > > more options, visit this group at > >http://groups.google.com/group/cake-php?hl=en 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
