A client of ours is looking to create a report that will show items sold per supplier even if the actual quantity sold is 0. Using the Item Movement Report, I can see these unsold items but as soon as I specify a date range, they disappear. Thanks in advance for any help.
Custom Report With Zero Quantity Sold
Jun 10, 2008
3 Replies
You can create a report using the HAVING sql statement to apply a filter on ItemMovement/Transaction Entry quantity when 0
cod
please write me privately..
thx cod
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required