I would like to have a report that can show me what items, by store, that have a quantity, and have not sold since a specific date. Currently you can only get close by using the master quantity report, then drill into the item to see what store it is reporting. Store is not an option to filter, nor is ,or any other variables for a date specific filter. I appreciate any input you all may have.
Dead Item
Dec 23, 2006
1 Replies
Kevin,
you might the attached query, it might help you, u just need to set the desired date.
Please note that the attached query shows u the items that haven't been sold per store level so u have for each store, the items that this store didn't sell, but if u want to know items that haven't been sold at all in any store, just remove one line from the query (i already has a note on it)
Nashat
formatting link
begin 666 never sold.sql M9&5C;&%R92! 4VEN8V5$871E(&1A=&5T:6UE#0IS970@0%-I;F-E1&%T92 ] M("
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required