The physical count sheets are created and maintained on the C.20.17 Physical Count Sheets screen.
To create a count sheet, select the date from the LOV in the Count Date field. The Sheet Code value is generated automatically based on the pre-defined PICS rule assigned to the user.
The Count Seq field shows the number of counts, based on the maximum count sequence of the details. The Final indicator shows if all counts were marked as final, which means a final agreement has been reached on the inventory quantity.
If you want to limit the count sheet to one particular warehouse, select the warehouse from the LOV in the Insert only Warehouse field. The LOV for the inventory items only displays the inventory items of the selected warehouse. If the project default ZC_MULT_WH is set to Y, you can only work with those warehouses for which the Use for Issues box has been checked on the C.10.02 Warehouses screen.
You can use the Location button to include the material of a particular location. Clicking the button opens Window 2, which displays the available locations.
Select the Count indicator of all locations to be included, or click the Mark All button to select all. Then click the Fill in Sheet button to close Window 2 and insert all inventory items assigned to the selected location(s) into the count sheet.
You can use the Part Name Material button to include particular material. Clicking the button opens Window 3, which displays the available commodity codes, ident codes, and their sizes.
Select the Count indicator of all idents to be included, or click the Mark All button to select all. Then click the Fill in Sheet button to close Window 3 and insert all inventory items available for the selected ident(s) into the count sheet.
You can use the Inventory Items button to include particular material. Clicking the button opens Window 4, which displays all inventory items.
Select the Sel indicator of all inventory items to be included, or click the Mark All button to select all. Then click the Fill in Sheet button to close Window 4 and insert all selected inventory items into the count sheet.
To enter new records in the second (Physical Inventory Counts) block, select the location/warehouse from the LOV in the Location field. If the project default ZC_BIN_LOC is set to BLOC, you must select a site code first from the LOV in the Site Code field.
Next, select a commodity code from the LOV in the Commodity Code field. Then select the ident from the LOV in the Ident Code field. Finally enter a number in the Count Seq field and save the record.
When the physical count sheet is complete, print this sheet and count the inventory items. If the count was made, enter the counted quantity in the Count Quantity field and increase the count sequence by 1 in the Count Seq field for each item.
When the count of the inventory items has been finished, all counted quantities have been entered in the software, and the Final indicator has been selected for all items, click the Post button to post the physical count sheet to the inventory and to adjust the inventory quantities.
The physical count of plate number inventory items is not supported.
If the counted quantity is less than the quantity stored in the database, you must manually create an OS&D report on the C.20.19 OSD for Inventory screen.