There are a lot of issues regarding consignment record keeping.
I opened a business just the keep track of consignment items in my shop, so:
- Supplier - Consignment Supplier
- Customer - My business
- Inventory, all the consignment inventory with the supplier as a custom field.
So i firstly create a purchase invoice for the items then i take receipt of the goods.
End of the month once the items has been sold i process a sales invoice on behalf of my company.
Everything works great i think but for the reporting. Currently i draw three reports:
Inventory quantity movement
inventory value movement
This give me the items sold, current inventory quantity available and current value of inventory available.
I want to generate a report whereby i can see all on one report:
Opening stock count, opening stock value, sales and closing stock value, plus closing stock count.