Demand Action Report (ICR110)

Using Reports

Use this program to obtain a report of items with on-hand quantities (plus on order minus committed minus backordered) which are less than the order point or minimum stock level (whichever is used). The report should be printed on a daily basis since it tells you which items demand immediate reordering action (based on their available quantity).

Report information includes

  • warehouse code and description

  • vendor

  • item class

  • item number and description

  • movement class

  • season code

  • order point

  • line point

  • minimum and maximum stocking quantities

  • order quantity method

  • lead time

  • frozen controls

  • restocking warehouse (blank = direct from vendor)

  • available, on order and backordered quantities

  • usage rate and stocking unit of measure. The total number of items listed is also included. The basic calculations and headings are included in the report legends. For additional information, refer to glossary

 

 

Access this program by choosing Inventory Control-->Restocking-->Demand Action Report.

The following fields are involved in printing the Demand Action Report:

1. Beginning vendor

Enter the beginning vendor to print. Press image\ex_allft_shg.gif to default to First. Press F2 or image\find_shg.gif to search.

2. Ending vendor

Enter the ending vendor to print. Press image\ex_allrt_shg.gif to default to Last. Press F2 or image\find_shg.gif to search.

3. Class

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

4. Item description

Enter whether to print item description 1, 2 or B-both as set up in the Item F/M. The program defaults to Description 1.

5. Warehouse

Enter up to 20 two-character warehouse codes side by side to print. CR defaults the warehouse assigned to the terminal. Press F1 or image\all_shg.gif to default to ALL. Press F2 or image\find_shg.gif to search.

6. Include on order

Indicate whether to include on order quantities as part of the available stock. The program defaults to selected.

7. Skip

Enter the number of lines to skip between items (0-9). The program defaults to 0.

8. Inactive

Indicate whether to include inactive items on this report. The program defaults to selected.

9. Flagged

Enter N, Y, or M (maybe, option by item) to indicate whether to include flagged items on this report. If you choose Y, calculations are performed using actual usage.

If you choose M, the program presents a prompt each time it finds a flagged item. Press F2 from this prompt to skip the item and not include it on the report, or press CR to continue. If you press CR, you must reset the item at another terminal before this program will continue. Change the usage flag from qualified to actual in the IC Warehouse/Item F/M. The item is then included on the report using qualified usage.

10. buyer

Enter the buyer code to include. When the report prints, a caption will print at the top of the first page to indicate that the report is for a specific buyer. Buyer codes are created in the PO Buyer Code F/M. The program leaves this field blank by default. Press F1 or image\all_shg.gif to default to ALL. Press F2 or image\find_shg.gif to search.

See Also

Selecting existing templates

Creating system templates

Editing the order, range and properties stored in templates

Setting printer properties in templates

Using print options in reports

Setting a default printer using templates topics

Using print options

Using report templates

Viewing reports on screen (using the viewer)

Using reports, registers, and prints as audit trails

Register formats and procedures

Reports and Prints Menu Options

Using Reports