Sales Report of item X

(0) Share

Report

Posted on by Community Member Microsoft Employee

I need a report that will show the total of all sales which contain a certain item. For example last month what was the value of our sales that included Labor?

Many thanks

*This post is locked for comments

All responses (4)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Sales Report of item X

Thanks Ed! I'm able to run the query in Admin to get the info I need. Not the ideal situation but at least I'm heading in the right direction.
Verified answer

Community Member Microsoft Employee on at

Like (1)

Report

RE: Sales Report of item X

That makes sense.

Unfortunately none of the reports act that way. You would have to create a custom report with something like the following query.

select * from [transaction] where TransactionNumber IN (select transactionnumber from [TransactionEntry] where ItemID = 43 )

Replace 43 with the ID for the item from the [Item] table.

To get the id from the item table, run the following in Admin: Select * from [Item]
Community Member Microsoft Employee on at

Like (0)

Report

RE: Sales Report of item X

Thanks Ed. Unfortunately that just gives me the total for Labor. I need to see the total for all transactions that included Labor not just the amount of Labor. Does that make sense?
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Sales Report of item X

Run the Detailed Sales report and include a filter for that item.