Dear sql-ledger users / fans,
Does anybody know how to do inventory management in sql-ledger ? Or does sql-ledger do not have higher level inventory management functionality? Or maybe I don't know how to ? Following are the 3 situations for which an accounting software have to manage inventory well. This is usually normal operations for traders of almost any industry. #Example Situation 1 # (stock dissemble) ------------------------------------------ Traders buy goods in bulk so it would be in mix contents (all qualities). Lets name it "Mix01". So we bought "Mix01". Now this inventory item we want to split into 5 categories / qualities. For e.g "Q1" to "Q5". HOW do we do this in sql-ledger? #Example Situation 2 # (only some quality sell ) ---------------------------------------------------------- Traders also sell a part of mix contents. Lets name this mix contents "Mix 02". For e.g. we had initially bought total quantity of 500 units @ $10 per unit. (so total cost $5000). Now we sell only one quality of this mixed quality content. Say for e.g. we sell only top quality of this mix content : 40 units @ $25(sell price) per unit which we want to regard $20 as cost. Now the remaining 460 units (500-40) should be shown in inventory at cost $4200 [ 5000 - (40 * 20) ]. How can we do this in sql-ledger ? #Example Situation 3 # (goods stock transfer) -------------------------------------------- Traders often mix/transfer one goods stock with other. How is this possible in sql-ledger? Please do write if sql-ledger is capable of above. Regards, krish
