Physical Inventory Batch Work Sheet

Purpose: Physical Inventory Worksheets are used to record the item quantities counted during the physical inventory.

How to print: Use the Generating a Physical Inventory (MGPI) menu option.

For more information: See the sample report in PDF format.

Contents: A separate report prints for each warehouse in the physical inventory. The report page breaks by location type (primary, secondary, and bulk) and by batch number if Assign Batch Numbers (A07) is selected. See Assign Batch Numbers (A07) for more information on how the information sorts on the report.

• Control #: The control number assigned by the system to identify the physical inventory.

• Batch #: The batch number assigned by the system for the locations on the sheet. The Assign Batch Numbers (A07) system control value determines whether the system assigns batch numbers. The Batch Grouping (L64) and Batch Size (A08) system control values determine when the system starts a new physical inventory batch.

• Count: The physical count for which the sheets were printed. When the system prints the sheets at the time you first generate the physical inventory, the count will be FIRST. You can generate sheets for the second or final count through Entering Physical Counts by Worksheets (MPIE) or Reprinting Batch Sheets or Tickets (RPIF).

• Warehouse: The code and description of the warehouse where you are performing the inventory.

• Location type: The location type. Valid values are PRIMARY, SECONDARY, BULK, and TEMPORARY.

• Item/SKU: The item code and SKU being counted, and the description of the item and of the SKU.

• Location: The location where the item(s) are being counted.

• Location class: The location class, if any.

• LPN: The LPN (license plate number) used to track the inventory in your warehouse, if any. You would normally use LPNs if you also use radio frequency to manage your inventory; see Radio Frequency Overview. If there is more than one LPN of an item in a location, each LPN counts as a separate item location for the purposes of printing batch sheets or entering counts only. Any “loose” items in an item location appear grouped under LPN 0. Items in a primary location are never associated with an LPN (the number would be 0). The LPN would also be 0 if you select the Clear LPN file before generate field at the Generate Physical Inventory File screen.

• On Hand Qty: The on-hand quantity. This quantity prints only if the Print On Hand Quantity (A11) system control value is selected. In the case of LPNs (see description above) the total on-hand quantity for the item location that is not assigned to an LPN appears under LPN 0.