Product Administrator Review Cycle Adjustment Report ranges and options

Ranges

See Reports - Ranges overview.

Options

Print Review Cycle Report

Select Yes to include newly calculated review cycles and the product lines that are affected. Select Yes to review the information before you run the report in update mode.

Select No to exclude the entire review cycle report if you already generated and reviewed the report. Select No to run the report in update mode. The number of records that were processed is included on the report.

Update Review Cycles?

Select Yes if you have already reviewed the report and are ready to run in update mode.

Select No to review the review cycle report.

# of Days For Review Cycle Exception

Specify the number of days for the review cycle.

A review cycle should not exceed one month, except for seasonal products that are out of season. If your review cycle is longer than one month, you are probably carrying excessive safety stock.

An "X" next to the Review Cycle In number on the report indicates that the product line was calculated with review cycle days value that is equal to or greater than the review cycle exception. The "X" denotes an exceptionally long review cycle. Manually review those product lines to ensure that these values are appropriate:

  • Order point
  • Line point
  • Order quantity
  • Target buy levels
Minimum Review Cycle Days and Maximum Review Cycle Days

The Minimum and Maximum Review Cycle Days options limit the review cycle calculation.

If you specify 5 as a minimum and 25 as a maximum, only days within that range are valid.

If the calculated value is less than 5, then the value is automatically set to 5 and an "n" id displayed after the value.

If the calculated value was greater than 25, then the value is automatically set to 25 and an "m" is displayed after the value.

If the calculated value falls between 5 and 25, then the actual value is included on the report with no notation.

Product Line Usage Method?

Select No to use purchase history to calculate the review cycle days. Select Yes to use product line usage to calculate the review cycle days.

Note: Product line usage is calculated when you select Yes for the Recalculate ICSL Product Line Usage option in Product Administration Month End Processing Report.

To calculate the review cycle days using product line usage, the sum of usage for each warehouse product in the product line is multiplied by the PO cost.

The sum of usage is based on the months that are specified in Product Replenishment Setup. PO cost is specified in the Post to G/L By field in SA Administrator Options-Products-Costs.

This number is then divided by the purchasing target that is defined in Product Line Setup. The result is divided into 365 to determine the number of review cycle days.

Review Cycle Days = Purchasing Target / Daily Target Usage