Flagged Item Report (ICR830)

Using Reports

Use this program to obtain a report of all items flagged by the End-of-Period Update.

Usage, lead time, frozen controls and ignore low sales each print a new page on the report. Anything flagged indicates there has been a variance from normal processing.

The usage page(s) indicates if usage is unusual due to high sales (period usage is greater than the previous 5 periods usage), low sales (usage is less than 1/2 unit), or a stockout (over 13 days in period where item was out of stock).

The lead time page(s) indicates if lead time is abnormal (a lead time causing a greater than 50% change in average lead time).

The frozen controls page(s) indicates which items were frozen (items are only frozen by the user).

The ignore low sales page(s) indicates which item are set to ignore low sales and the number of periods left to ignore.

This report is a to determine what is to be done with the item, i.e., whether usage, the safety allowance, lead time, frozen controls or ignore low sales are to be adjusted. Users should make adjustments through the Warehouse/Item F/M Program or the Item Flag/Restocking_SMG000_000 Program. Once adjustments are made, the Item Flag/Restocking_SMG000_000 Program is used to automatically reset the item restocking amounts.

Report information includes:

· Usage: warehouse, vendor, item class, item, stocking unit of measure, movement class, season code, qualified usage, actual usage and stockout days for the 12 previous periods. The total items listed with flagged usage is also included.

· Lead time: warehouse, vendor, item class, item and description, movement class, season code. The date and lead time for the last 5 receipts and average lead time for each item is also printed. The total number of items listed with invalid lead time is also included.

· Frozen controls: warehouse, vendor, item class, item and description, movement class, season code, and the following frozen controls: controls, number of periods, date and memo. The total number of items listed with frozen controls is also included.

· Ignore low sales: warehouse, vendor, item class, item and description, movement class, season code, number of periods remaining to ignore low sales. The total number of items listed to ignore low sales is also included.

The basic calculations involved are included in the report legend. For additional information, refer to the glossary.

To access this program, choose Inventory Control-->End of Period -->Flagged Item Report.

Use the following fields to print a Flagged Item Report:

1. Order

Enter whether to print in Vendor or Movement Class order. Press Enter (CR) to default to Vendor.

2. Beginning Order Choice

Enter the beginning vendor or movement class to print. Press Enter (CR) to default to FIRST vendor or Movement Class 1. Press Enter (CR) or $image\ex_allft_shg.gif$ to default to the FIRST Press F2 or $image\find_shg.gif$ to search.

3. Ending Order Choice

Enter the ending vendor or movement class to print. Press Enter (CR) to default to LAST vendor or Movement Class 14. Press Enter (CR) or $image\ex_allrt_shg.gif$ to default to the LAST. Press F2 or $image\find_shg.gif$ to search.

4. Movement Class/Vendor

Enter the movement class or class to print. If movement class is the report order, enter the vendor to print. If vendor is the report order, enter the movement class to print. Press F3 or $image\all_shg.gif$ to default to ALL. Press F2 or $image\find_shg.gif$ to search.

5. Subsort By Movement Class/Vendor

If movement class is the report order, indicate whether to subsort by vendor? If vendor is the report order, indicate whether to subsort by movement class? Press Enter (CR) to default to selected.

6. Item Class

Enter the item class to print. The entry must be a valid class. Press F3 or $image\all_shg.gif$ to default to ALL. Press F2 or $image\find_shg.gif$ to search.

7. Item Description

Enter whether to print item description 1, 2, or Both from Item F/M, or Neither. Press Enter (CR) to default to 1.

8. Warehouse

Enter up to twenty 2-character warehouse codes side by side to print. Press Enter (CR) to default to the warehouse assigned to the terminal. F2 defaults to ALL. Press F2 or $image\find_shg.gif$ to search.

9. Criteria

Enter whether to print items with flagged Usage, abnormal Lead times, Frozen controls and/or Ignore low sales. Press Enter (CR) or $image\all_shg.gif$ to default to ULF.

10A. Include Permanent Freezes

If F was not entered in Criteria, this field is skipped. Indicate whether to include items whose controls are frozen permanently. Press Enter (CR) to default to selected.

10B. Include Permanently Ignored Low Sales

If I was not entered in Criteria, this field is skipped. Indicate whether to include items whose low sales are permanently ignored. Press Enter (CR) to default to selected.

Flagged Item Report (ICR830)

Using Reports

Use the following fields to print a Flagged Item Report:

See Also

Using Reports