Inventory Control > Screen Guides > Reports > Inventory Worksheet

I/C Inventory Worksheet report screen

Learn more

Counting and Reconciling Inventory Quantities

Generating Inventory Worksheets for Stocktaking

Overview

Use this report to write down the quantities on hand when performing a physical count of inventory. You later enter these quantities on hand into Inventory Control to prepare for inventory reconciliation.

Use this report screen to specify the range of locations whose worksheets you want to print, whether to include inactive items, and whether to include the Unit Cost and Quantity on Hand, and whether to include Comment rows for each item.

When to Print

Print the worksheet when you want to perform a physical count of inventory in a location.

Information Printed on This Report

The location, worksheet creation date, and worksheet comment (that was entered for the worksheet in the I/C Generate Inventory Worksheet screen).
The item number, description, and picking sequence.
Note: The items included depend on the selections made when the worksheet was generated. Inactive items are included only if you select the Include Inactive Items option when printing the worksheet.
The Unit Cost column, if you selected Unit Cost when printing the report.

If you use the most recent cost or standard cost costing methods, the unit cost is the same as that displayed in the I/C Location Details screen. For average and LIFO/FIFO costing, Inventory Control calculates the average unit cost by dividing the actual cost by the quantity on hand.
The Quantity on Hand column, if you selected Quantity when printing the report.
The Quantity Counted column (with a blank line). When performing the physical count, you can write down the inventory count for each item for each unit of measure. You later enter these figures in the Physical Inventory Quantities screen.

If you selected the Default Quantity On Hand choice in the Generate Inventory Worksheet screen, the current quantity on hand for each item is already printed in the Quantity Counted column. You then manually enter figures only when the quantity counted differs from the figure stored as the quantity on hand in your Inventory Control program.
The Status column (with a blank line).

When performing the physical count, you can write down the temporary status for items whose status you want to change for reconciliation purposes. You can later use the I/C Physical Inventory Quantities screen to assign that temporary status to those items.

Use the On Hold status to prevent items from being updated when you post the inventory reconciliation. Use the Ready To Post status to allow on-hold items to be updated when you post the reconciliation.
A Comment row (with a blank line) for each item, if you selected Comment when printing the report.

When performing the physical count, you can write down comments or remarks about the item for your records. You do not enter these comments into Inventory Control.