![]() I thought of inventories_detail mostly for this. How do I keep track of changes in units cost? If some day I start paying more for a certain product, I would need to keep track of the marginal utility ( (cost*quantity) - (price*quantity) = marginal utility) some way.Okay, so, are there any questions? Of course. total (calculated from orders_detail quantity * price just for future data validation).Selling one (1) unit of product X from location Y, means inventory of location Y should subtract one unit from its inventory.Location Y and Z may both have for sale units of product X, but if, for example, two units are sold from location Y, location Z’s inventory should not be affected. The products are always the same (same ID) through the whole system, but inventory (available units for sale per product) is unique per location.I’m trying to create a basic Point of Sale and Inventory management system.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |