I/C Generate Inventory Worksheet Screen

Learn more

Counting and Reconciling Inventory Quantities

Generating Inventory Worksheets for Stocktaking

Printing Inventory Worksheets

Open Inventory Control > I/C Physical Inventory > Generate Inventory Worksheet.

Click this button to generate worksheets for the locations, account sets, and items you specified.

Enter a comment to appear for Worksheet Comment near the top of the inventory worksheet. (Optional)

This option controls what displays in the Quantity Counted column for items in the I/C Inventory Counts screen and the I/C Physical Inventory Quantities screen:

  • Select this option to display the current quantity on hand (as tracked by Inventory Control). You then only need to enter figures for the item if the quantity counted differs.
  • Do not select this option to leave the column blank. You then always need to enter the count for items.

Note: This option does not control the printing of the Quantity on Hand column on the inventory worksheet. That column is included when you select the Quantity option on the I/C Inventory Worksheet report screen when printing the worksheets.

If you want to limit the report to a range of values for the sort field, enter the range for From and To. You can type the code, or click Image of Finder button. (the Finder button) and select the code.

Select which items you want to include on the worksheet:

  • All Items from Inventory List. Lists all the items in your inventory that are in the Sort By range.
  • Items from Location Only. Lists only the items in the Sort By range that are assigned to the locations you selected for the worksheets.
  • In Use Items Only. Lists only the items in the Sort By range that are assigned to and have been used in one or more transactions at the locations you selected.

Select the sort order for the worksheet, which can be by item number, category, item segment, picking sequence, or an optional field value.

If you want to change the type of range in which to list items on the worksheets, select another type from the list.

You can select from Item Number, Category, Item Segment, Picking Sequence, and any optional field names used in your Inventory Control system.

If you select Item Segment, also select one of the defined segment names for Segment.

If you want to limit the account sets included in the worksheet, specify the range of account sets in the From and To columns. You can enter the account set code, or click Image of Finder button. (the Finder button) and select the account set.

If you want to limit the locations included in the worksheet, specify the range of locations in the From and To columns. You can enter the location code, or click Image of Finder button. (the Finder button) and select the location.

Overview

Use the I/C Generate Inventory Worksheet screen to generate worksheets showing the item quantities on hand for inventory locations where you want to perform a physical count. You can then print these worksheets to help with the physical counts.

You can generate inventory worksheets for a range of items sorted by item number, category, item segment, picking sequence, or any optional fields defined for Inventory Control. You can choose to include:

If you generate an inventory worksheet for a location that already has a worksheet, the program warns you and lets you choose whether to replace it.

Warning! To ensure quantities and costs on worksheets are current, do not post transactions (receipts, shipments, transfers, or adjustments) or run Day End Processing between the time you generate inventory worksheets and the time you post the inventory reconciliation.