Location Replenishment Report (IC141)

Run Location Replenishment Report (IC141) to print a report of replenishment quantities for items with an available quantity less than the reorder point for items that are stocked from another location.

Processing Effect

Available quantities are based on the current stock-on-hand quantities minus allocated, picked, and backordered quantities plus on-order and intransit quantities.

This report applies to items set up in IC12.1 (Item Location) with the following.

A replenishment location set up in the Source form.
The following set up in the Reorder form: reorder point and one of the following reorder document types: issue, transfer, intransit (X), or requisition.

You can create unreleased documents based on the reorder document code. Unreleased documents can be reviewed and released in IC21.1 (Issues), IC22.1 (Transfers), RQ10.1 (Requisition). If you create unreleased documents, you can enter the general ledger posting date.

Note: To create intransit documents you must enter an estimated delivery date. To create requisition documents you must set up requesters in RQ04.1 (Requesters). Define requesters based on the form name followed by the requesting location. For example, to run this program for the Minneapolis (MPLS) location, set up IC141MPLS as a requester.

This program prints by company, location, report group, and/or inventory class. You also can also include items set up as inactive in IC11.1 (Item Master). This report prints by replenishment location in item number sequence the required leadtime, safety stock quantity, reorder point, stock-on-hand, supply minus demand quantity, and reorder quantity.