Open the Item Usage 10 Week window.

Shows all of the items that were sold or used in a ten week period. The report will show a summary by item/variant for each day/week in the period.

This report could be used for identifying sales consumption trends or raw material trends. A planner or sales person could use the report to identify periodic trends.

Running this report for all items could take some time since many individual calculations are being made. To limit the datasets, you could filter according to raw materials, finished goods, etc.

This report has an RDLC layout.

Options

Field Description

Set Current Week

Select the date from which you want to report the item sales or usage for the last ten weeks.

Usage Mode Indicates the type of usage to include in the report.
  •  Sales: Creates a report that shows items’ sales for the last ten weeks.
  •  Component: Creates a report that shows how many times the item was used in components for the last 10 weeks.
Start Report Expanded Select the check box if you want all of the report rows to be expanded when the report is opened.
Tip

See Also