Custom Report With Zero Quantity Sold

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.

Reply to
Arthur Rosenbaum
Loading thread data ...

You can create a report using the HAVING sql statement to apply a filter on ItemMovement/Transaction Entry quantity when 0

cod

Reply to
cod

Reply to
Arthur Rosenbaum

please write me privately..

thx cod

Reply to
cod

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.