I need to run a sales report for consigned items that shows:
- Vendor
- Item
- Item Cost
- Item Sales price
I posted this message earlier and got the following reply which works well but I need to include the above information. When I apply the following I get Item and Sales price but I need Vendor and Item Cost in addition.
Reply from Tara--
**Here's what I do for an art gallery that gets artist consignments:
Items are entered as Inventory Part *but* they do not go to Inventory Asset account.
I have two liability accounts setup that offset each other:
Other Current Liability: Consignments " " ":Consignments:Due to Artist " " ":Consignments:Artwork
When entering a New Item:
COGS account = Due to Artist Inventory Asset = Artwork Income account = Sales:Consignments
Thought the background was necessary since, technically, you don't own consignments and don't want them counted as assets but do need to track them as liabilities because its something you owe to someone whether its the returned item of the cost of the item.
I just pull a Quick Report on Sales Consignments to see if there were any sales of consignment merchandise and, if so, the artists we need to pay. If you want more than that you could setup classes for those vendors you receive consignments from. Every line item that is a consignment item on an invoice or sales receipt can then be assigned the vendor in the class column. If you're worried about knowing which is consignment and which isn't you could preface your consignment item descriptions with Vendor Name Consignment.