Printing the Item Location Reconciliation Report (PILR)

Purpose: The Item Location/LPN Discrepancy Report lists items in your warehouses whose item/location quantity does not equal the total quantity assigned to LPNs. This report includes non-primary locations only, since the system deletes an LPN when you place it in a primary location.

How to print: Enter PILR in the Fast path field at the top of any menu or select Item Location Reconciliation Report from a menu.

A discrepancy between item/location and LPN quantity can occur when you:

• perform an inventory transfer, adjustment, or “make set” transaction through Performing Inventory Transactions

• create an LPN using the Create LPN Screen and set the Update inventory? flag to unselected

• build an LPN using the Build LPN Screen

• adjust an LPN quantity using the Adjust LPN Screen and set the Update inventory? flag to unselected

• pick out of a non-primary location

Normally, the system updates LPN records as a result of standard CWSerenade transactions only when you receive a purchase order. Similarly, you have the ability in RF to work with LPN quantities without updating your actual inventory levels. Depending on how you use CWSerenade and RF to run your business, you may find it useful to run this report to track down incidents where your LPN records are out of sync with standard CWSerenade inventory.

How to correct errors: Your options in correcting inventory/LPN discrepancies include:

• Use Displaying License Plate Information (WLPN) to delete LPNs for which there is no actual inventory in the location

• Use Adjust LPN in Radio Frequency Inquiry and Maintenance (RFMN) to adjust the LPN unit quantity if the LPN quantity is inaccurate

• Use Work with Inventory Transactions to adjust the on-hand quantity for the item in the location, if this quantity is inaccurate and the LPN quantity is correct (see Performing Inventory Transactions)