Physical Inventory Batch Work Sheet

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.

CWDirect Rel 4.0 PI Batch Work Sheet KLETENDRE INR0868 8/27/99 10:25:09 Page 1 KAL Co. Control# 1 / 1 Count: SECOND Warehouse 60 PHYSICAL INVENTORY PRIMARY LOCATIONS Item SKU Location Class LPN On Hand Qty BUN01 PA1 0 25 ¦ ____________________ FUZZY BUNNY TOY FIEL89 PA1 0 25 ¦ ____________________ BRIGHT ORANGE FIELD VEST JUIC54 PA1 0 5 ¦ ____________________ THE FAMOUS JUICER MACHINE MIT8Y RED SMLL PA1 0 69 ¦ ____________________ HOMEMADE MITTENS RED SMALL MITTENS MIT8Y RED MEDM PA1 0 97 ¦ ____________________ HOMEMADE MITTENS RED MEDIUM MITTENS MIT8Y RED LRGE PA1 0 25 ¦ ____________________ HOMEMADE MITTENS

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 set to Y.

• 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 Size (A08) and Batch Grouping (L64) 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 Counts Using Physical Inventory 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. 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 set the Clear LPN file before generate field to Y at the Generate Physical Inventory File screen. See Chapter 12 for more information on LPNs and radio frequency.

• On Hand Qty: The on-hand quantity. This quantity prints only if the Print On Hand Quantity (A11) system control value is set to Y. 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.