Sale by Vendor

Thanks for the help, it works well. I do have two questions.

1. How do I get the vendor name to show in the report "Sales Consignments"?
2. When entering this item for payment will the accounting be correct, since we changed the COG account and inventory asset?

Tim

I've not found a way to do this from a Quick Report or any other ready report based on Vendors. However, you can pull a Sales>Sales By Item Detail report then choose to add Account to the column list. Then sort by the Account column. This will show you all the items sold, grouped by Vendor, sorted by sales account.

No, see my follow-up post. Again, I'm very sorry for giving you a bad accounting setup.

I need to run a sales report for consigned items that shows:

1. Vendor
2. Item
3. Item Cost
4. 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--

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.

Tim, I posted a correction to the procedure as well as answered your questions in the original thread. I don't know if its your server or your newsreader hiccupping but your last question kept reposting.