Physical Count Worksheet

Window Details
	Navigation
	Overview
	Fields
	Report Sample

How Do I...
	Create a Report Setting	E-mail, Fax, or Print a Report as a PDF
	Print a Report, Listing, or Form	Enter Multiple Values Using Separators
	Process a Physical Count

Related Topics
	Physical Count Entry	Physical Count Variance Register
	Transaction Entry	Production Entry
	Invoice Data Entry	Disassembly Entry
	RMA Receipts Entry	Work Order Transaction Entry
	Receipt of Goods Entry	Inventory Management Options
	Role Maintenance

Navigation

Select Inventory Management Physical Count menu > Physical Count Worksheet.

Overview

Use Physical Count Worksheet to freeze items to count and to print worksheets for the selected items. The worksheets include information such as the item code and description, bin location, inventory cycle, product line, product type, and quantity on hand, and they have space for writing the physical count quantities and initials of the person who performed the count.

You can print the Physical Count Worksheets in order by item code, bin location, or item description and enter a selection of item codes, bin locations, item descriptions, warehouses, inventory cycles, and product lines to print. You can also select the product types and procurement types to print. For items with either Lot or Serial as the valuation method, if the Track Lot/Serial Expiration Dates check box is selected in Item Maintenance, the expiration dates print, and you can specify whether items are included based on the expiration date.

The perpetual inventory must be frozen while the actual physical count is in process. When the actual physical count is completed, normal operations can still be performed while the physical count is entered. After the physical count is entered and updated, any shipping and receiving that occurred between the completion of the actual physical count and the Physical Count Variance Register update is considered as the perpetual inventory and is adjusted. Normal operations do not include the relieving or populating of actual inventory in the warehouse when Physical Count Entry is in process. This can cause a variance by inaccurately representing the actual quantity on hand.

Note If you set a warehouse to Restricted status while counting inventory, be sure to click the Allow Restricted Warehouse button in Warehouse Code Maintenance, and select I/M Physical Count Entry in the Allow Entry of Restricted Warehouse window.

Data entry is checked in the following tasks to prevent a variance from occurring after the count is frozen: Transaction Entry, Invoice Data Entry, RMA Receipts Entry, Receipt of Goods Entry, Production Entry, Disassembly Entry, and Work Order Transaction Entry.

You can have the quantity counted in Physical Count Entry be the same as the items' actual quantity on hand by selecting the Default Quantity Counted to Quantity on Hand check box when freezing items.

Warning When you freeze inventory, any existing records in Physical Count Entry will be removed.

Fields

Print Report Settings