Hi,
Here at work I am taking care of a fancy coffee-machine that uses a
cash-card system for payments, and I decided to use sql-ledger to keep
track of inventory and transactions. The idea is not to make profit on
coffee-sales, but to charge people only the costs involved.
But I have a problem accounting properly for my used inventory.
The sales process is as follows:
* Cash cards are refilled once in a while and I receive money
for this. These transaction are nicely recorded in sql-ledger.
* People use their cash cards to pay for coffee-drinks and the
machine keeps track of how many times each coffee option is
used. These transaction aren't recorded in sql-ledger even
though inventory is used, but no money is received.
The inventory process is as follows
* Inventory is received from vendors and payments are recorded in
sql-ledger
* I do inventory checks monthly to keep track of use of inventory
My questions is: how do I account properly for the use of inventory?
The only way I found was to create a virtual customer and sell the used
inventory to them after which I rebalance the income account with
towards an expense account. I asked an account about this, and she said
it was a strange construction.
Besides this, I don't seem to be able to get the numbers right for
inventory use.
What is the proper sql-ledger way of doing this?
Thanks for any help,
-Aschwin
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sql-ledger-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
