1,565
Hey guys, we're looking for a report that would list all transactions within a specific date range that contain two items on the report.
ie:
date sold - (date range)
transaction contains both item 1 and item 2
not looking for transactions that contain item 1 or item 2, but only the transactions that contain both items in the same sale.
Has anyone made this? or have an idea as to what code I could punch in to start my own?
Thanks,
Devon
*This post is locked for comments
Hi, sorry for delay. Here is a basic SQL solution:
SELECT DISTINCT A.TransactionNumber, A.ItemID AS ItemNo, A.Description AS Description, A.TransactionTime FROM TransactionEntry AS A, TransactionEntry AS B
WHERE A.TransactionNumber=B.TransactionNumber And A.TransactionTime=B.TransactionTime And ((A.ItemID=Item1 And B.ItemID=Item2) Or (A.ItemID=Item2 And B.ItemID=Item1)) And A.TransactionTime Between StartDate And EndDate
ORDER BY A.TransactionNumber, A.ItemID;
A=Database, and ItemID and the Dates are variables for you to change.
MGordon - this has been suggested already but does not work.
You can do this with the detailed sales report just use the filter settings to do it,
Something like date range is between A and B
AND itemlookupcode = Item #1
AND date range is between A and B
AND Itemlookupcode = Item #2
Drage the transaction number to the left side and that should give you what you need.
Any luck with this Todd?
I haven't had any luck with it.
You are of course right, sorry. I am however working on a solution for you because I think the information interesting. :)
Wish it were that simple Todd, unless you're using a different report than I am?
I'm using the Sales - detailed sales report (in store ops AND hq) with no results when selecting AND as a condition
You have to select these two items by ItemLookupCode in the conditions screen on the report filter, and select AND as a condition.
Basically, we want to see how frequently two items are sold together - has anyone seen or made a report like this before?
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
