Product Customer Forecast Usage Report ranges and options
Ranges
For more information, see Report ranges.
- Contract
-
Specify a range of contracts to limit the report by contract.
- Customer #
-
Specify a customer number to limit the report by customer.
- Expire Date
-
Specify a date range to limit the report by the date forecasts expire. If you are going to inactivate or remove forecasts when you run this report, you must specify an expiration date. To be sure to select forecasts that are already expired, specify an expiration date range which is earlier than the current date.
- Product
-
Specify a range of products to limit the report by product.
- Product Category
-
Specify a range of product categories to limit the report to forecasts by product category.
- Product Line
-
Specify a range of product lines to limit the report by product line.
- Start Date
-
Specify a date range to limit the report by the date forecasts begin.
- ShipTo Group
-
Specify a range of shipto groups to limit the report by shipto group.
- Vendor
-
Specify a range of vendors to limit the report by vendor.
- Warehouse
-
Specify a range of warehouse to limit the report by warehouse.
Options
- Create CSV File?
-
Select this field if you want to create a .csv file from running this report.
- CSV Directory
-
If you select the Create CSV File field, specify the directory in which to create the .csv file.
- CSV File Name
-
If you select the Create CSV File field, specify the .csv file name.
- Status A)ctive, I)nactive, B)oth
-
Specify A to limit the report to active forecasts. Specify I to limit the report to inactive forecasts. Specify B to see all forecasts, regardless of status.
- Usage Rate Variance Pct
-
Specify a usage rate variance percent greater than zero to limit the report results by actual usage rate percent.
The calculation for the usage rate percentage is:
Actual usage to date / Forecasted usage to date * 100 = Usage rate percentageFor example, if the actual usage to date is 80 and the forecasted usage to date is 85, the usage rate percentage is
80 / 85 * 100 = 94%If you specify 10 as the variance percentage, then products with an actual usage rate greater than 90% or less than 110% are included on the report.