Uploading Physical Counts (MPIU)

Purpose: Use the Upload Physical Inventory Counts menu option to convert counts you have uploaded from an external system to the CWSerenade Physical Inventory table.

This menu option takes the contents of the Physical Inventory Upload table (INPIUP) and adds it to the first count information in the Physical Inventory table (INPHY): the first count quantity is updated in the Physical Inventory table, and the count one status field is selected to indicate that the item location or LPN has been counted.

In each case, this menu option updates the fields related to the first count only. To enter a second or final count for item locations or LPNs, you can use the Enter Physical Counts (MPIE) menu option or RF Physical Inventory.

Also see Working with the Physical Inventory Upload (WPIU) to review the contents of the upload table, add or change records, or correct errors that remain after you use the Upload Physical Inventory Counts option.

See Physical Inventory Overview for a diagram depicting the entire upload process.

Note: You must select the Upload Counts (A12) system control value to use the Upload Physical Inventory Counts menu option.

In this topic:

• Physical Inventory Upload Selection Screen

• Physical Inventory Upload Error List

• Physical Inventory Item Location Audit Report

Physical Inventory Upload Selection Screen

Purpose: Use this screen to submit the job that will upload the physical inventory counts.

How to display this screen: Enter MPIU in the Fast path field at the top of any menu, or select Upload Physical Inventory Counts from a menu.

How to use this screen: Select OK at this screen to submit the upload process. The Confirm Accept pop-up window opens.

If you do not have the Upload Counts (A12) system control value selected, the screen displays an error message.

The system submits the job PIUPLOAD. This job:

• for each valid record in the Physical Inventory Upload table,

• updates the Count one quantity field for the item location in the Physical Inventory table

• selects the Count one status field for the item location in the Physical Inventory table

• if there are invalid records in the upload table,

• runs the UPLD_RPT job, which produces the Physical Inventory Upload Error List

• updates the Status field for the item location in the upload table with a code identifying the type of error.

• Also, if the Create Location/Item Location/Item Warehouse from PI Upload (F09) system control value is selected, and if the system created any of these records as a result of the job,

• produces the Physical Inventory Item Location Audit Report, which lists each record created as a result of the upload. You can create location records only if you have set up default location settings through the Defaults Options table.

Physical Inventory Upload Error Codes

Code	Description	Comments
IC	Invalid Company	The company code does not exist in the Company table, or is not included in the cross-company scan. See Setting Up Companies (WCMP) for more information on setting up companies on your system.
IS	Invalid Item/SKU	This is not a valid item or item/SKU in the company indicated.
IL	Invalid Location	This is not a valid location in the company and warehouse indicated. Note: If the Create Location/Item Location/Item Warehouse from PI Upload (F09) system control value is selected, you can create a location warehouse if the upload record passes all other error checks. See the Physical Inventory Item Location Audit Report.
IW	Invalid Warehouse	This is not a valid warehouse for the company indicated.
CS	Item/SKU not in Cmp Scan	There was no company code indicated, and the item and SKU do not exist in any company included in your cross-company scan group.
MW	Loc At Multiple Whse	This is a valid location at more than one warehouse. (This error occurs only when there is no warehouse code defined.)
LP	LPN W/Primary Location	There is an LPN associated with an item in a primary location, which is not possible.
PB	P/I Batch Doesn't Exist	There is not a current physical inventory generated for the company selected (or associated with the item location).
I7	First Count Already Loaded	The first count for this record has already been loaded or entered.
NI	Non-Inventory Item	The item is a non-inventory item.