![]() The most common options would be FIFO, LIFO, or Specific Identification (all terms that can be Googled). The first scenario you need to address is what accounting method you'll use to determine the cost of any item sold. You're also doing an inventory management & basic cost accounting system. The tricky part here is that you're really doing more than a POS solution. Also, since I’m using Ruby on Rails for the first time, actually, as a learning experience, it’s a shame to be stopped at design, not letting me punch through implementation quicker, but I guess that’s the way it should be. ![]() I’m sure I still have some questions, but these are mostly the ones I need addressing. How would you keep/know your current stock levels? Since I had to separate the inventory table to keep up with cost updates, I guess I would just have to add up all the quantities stated in inventories_detail.Are relationships well stablished? I still have a hard time thinking if the locations have inventories, or if inventories have several locations.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. Archives
January 2023
Categories |