Inventory works on first in first out basies. If you want to reclassify a lot, you stock the lot as partial lots. So, instead of purchasing 1 lot 'A' you purchase 0.2 Lot 'A-1', 0.1 lot 'A-2', etc.
Inventory writedowns can be handled by selling the goods at zero value to yourself or a customer i.e "Inventory writedown". This gives you a) a record of what happened to it b) write down the cost of goods and c) remove the quantity from inventory. This is basically how you treat shrinkage, spoilage and theft. When you mix/transfer you do the same thing, buy and sell the goods. Dieter Simader http://www.sql-ledger.org (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 =========== On a clear disk you can seek forever =========== On Fri, 25 Oct 2002, Saurabh Shah wrote: > > 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 > > > >
