How can we extract detail sales reports for total transactions 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
I'd really like to see this in a report format instead of a query. Can that be done?
The following query will do the job for u but u can use it in SO only, if the idea of using a query is ok with u and u still need it for HQ, just let me know and I will adjust it and re-post
select sum(total)
from [transaction]
where time >='2014-01-01'
and time <'2014-02-01'
and transactionnumber in
(select distinct [transaction].transactionnumber
from [transaction] inner join transactionentry
on [transaction].transactionnumber=transactionentry.transactionnumber
inner join item on item.id=itemid
where time >='2014-01-01'
and time <'2014-02-01'
and itemlookupcode in ('xxx','zzz'))
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (