Would like to perform analysis on Slow Moving Items.
Specifically:
• Display Items where Total Qty Sold in the previous year (Jan 1-Dec 31, 2010) is greater than 0 but fewer than 10
Among the modules that we are using:
• Receivables
• Order Entry
• Inventory Control
• Sales Analysis
• GridView
Question: Not sure how to generate the report
- Sales Analysis can summarize this information, but I am not sure how to restrict the reporting to only Items where Qty summary is between 1 and 9
- I can generate the data in GridView from I/C, and then Summarize on Item #. But again, how do I filter for only Items with a summary amt of between 1-9?
_________________________
Samuel Kopstick
S Kopstick & Associates Inc
Toronto, ON