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

Inventory Management Options

Receipt of Goods Entry

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, and Disassembly 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

 

Report Setting

Description

Type

Default Report

Print Report Settings

Three Hole Punch

Number of Copies

Collated

Sort Report By

Double Space

Report Options

Lot/Serial Tiers

Include Inactive Items

Print Quantity on Hand

Product Types to Print

Procurement Types to Print

Default Quantity Counted to Quantity on Hand

Operand

Value

Printer/Output

Keep Window Open After Print

Keep Window Open After Preview