Uploading Physical Counts (MPIU)

Purpose: Use the Upload Physical Inventory Counts menu option to convert counts you have uploaded from an outside service or store-and-forward devices to the CWDirect Physical Inventory file.

This menu option takes the contents of the Physical Inventory Upload file (INPIUP) and adds it to the first count information in the Physical Inventory file (INPHY): the first count quantity is updated in the Physical Inventory file, and the count one status field is set to Y 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 Entering Counts Using Physical Inventory Tickets (MPIE) or Entering Counts Using Physical Inventory Worksheets (MPIE).

Also see the following related menu options:

• Working with the Physical Inventory Upload: Use this menu option to review the contents of the upload file, add or change records, or correct errors that remain after you use the Upload Physical Inventory Counts option.

• Physical Inventory Upload Screen (PIUP): Use this menu option to convert your original count files to the Physical Inventory Upload file format if the counts are contained in a non-CWDirect (Regis) flat file on your system. You must run this process before using the Upload Physical Inventory Counts option.

• Physical Inventory Tape Upload (MPTU): Use this menu option to convert your original count files to the Physical Inventory file format if the counts are contained on a tape. You must run this process before using the Upload Physical Inventory Counts option.

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

Note: You must set the Upload Counts (A12) field in the System Control file to Y 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.

INR0212 ENTER Physical Inventory Upload Selection 3/27/97 17:24:42 EZK Mail Order **Pressing Enter will submit a job to upload the Physical Inventory counts.** F3=Exit F12=Cancel F24=Select company

How to use this screen: Press Enter at this screen to submit the upload process. The following pop-up window appears:

Confirm Accept Press ENTER to confirm Accept. F12=Cancel

If you do not have the Upload Counts (A12) field in the System Control file set to Y, an error message will display.

The system submits the job PIUPLOAD. This job:

• for each valid record in the upload file,

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

• sets the Count one status field for the item location in the Physical Inventory file to Y

• if there are invalid records in the upload file,

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

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

• Also, if the Create Location/Item Location/Item Warehouse from PI Upload (F09) in the System Control file is set to Y, 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 file.

Physical Inventory Upload Error Codes

Code	Description	Comments
IC	Invalid Company	The company code does not exist in the Company file, or is not included in the cross-company scan. See Setting Up Companies (WCMP) of the Installation guide 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.
LC	Invalid Loc Cntl Char	The location control character, which appears at the end of the location code and is used to perform an additional validation against the location code, is not correct. The system performs this validation only if the Location Label Type (E32) field in the System Control file is set to W/Ctl Char.
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 set to Y, 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.