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.

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.

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

 

Report Setting

Report Options

Description

Print Quantity on Hand

Type

Product Types to Print

Default Report

Procurement Types to Print

Print Report Settings

Default Quantity Counted to Quantity on Hand

Three Hole Punch

Operand

Number of Copies

Value

Collated

Printer/Output

Sort Report By

Keep Window Open After Print

Double Space

Keep Window Open After Preview

 

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks