Inventory Control > Physical Inventory Count > Physical Count Reports

The Physical Count Variance Report displays the difference between the recorded on-hand quantities in the system at the time the freeze inventory was performed against the actual recorded counted quantities after performing the physical count.

The report can serve as a tool in verifying the reasonableness of any variances between the physical inventory count results and the on-hand quantities of the inventory items before you update the inventory records.

Before you can generate this report, you must have frozen your inventories, performed the physical inventory count, and recorded the results of the physical count using the Input Physical Count function.

You can no longer generate this report after updating the physical inventory count using the Update Physical Count function or clearing the frozen inventory items using the Clear Frozen Item function; thus, it is important to generate this report before performing both procedures.

To generate the Physical Count Variance Report, follow these steps:

1.Access the Physical Count Variance Report function from the Physical Count Reports group under the Reports main menu in the Inventory Control module.

2.Click the List box button next to the Configuration field; then, select the report configuration that you want to use.

3.Select the report sorting option by clicking the List box button next to the Sort By field.

4.In the Layout field, click the List box button to select the report layout you want to use in generating the report.

5.In the Report Configuration area, define the report filters. Depending on the sorting option you choose, mark the Individual checkbox if you want to generate the report for a single warehouse and enter the appropriate value in the adjacent field; otherwise, select in the Filters area the preferred criteria in generating the report.

6.Select which items you want to show in the report, depending on its status:

•Active and Inactive Items

•Active Items Only

•Inactive Items Only

7.Select which of the following you want to include in the report:

oInclude All Items

Mark this option to include in the report all the frozen inventory records.

oInclude Items with Count Variances Only

Mark this option to include in the report only those frozen inventory items with variances between the actual physical count results and the on-hand quantities when you freeze the inventory records.

oInclude Bins with Count Variances Only

Mark this option to display the bins of the corresponding inventory items with count variances.

8.Mark any or all of the following checkboxes, if applicable:

oShow Specification

Mark this checkbox to display on the report the inventory item specifications.

oShow Average Cost and Total Variance

Mark this checkbox to display on the report the Average Cost and Total Variance columns that show information about the counted inventory items' average costs and total variance amounts.

9.Click the Preview or Print button to preview or print the report. Click the Configure tab to return to the report configuration page.

The Physical Count Variance Report function also provides you with the flexibility to perform the following:

•Set up user-defined report macro

•Set up user-defined sort option

•Set up user-defined report layout

•Include notes in the printed report

•Export the report to various supported file formats

•Send the report as attachment to an email

•Include time and printed by information

•Drill-down on certain fields in the report:

oItem #

AccountMate displays the Item Profile when you double-click the item number in the report.

Physical Count Variance Report

Physical Count Variance Report

See Also