Print the Inventory Reconciliation Report
Overview
The Inventory Reconciliation report lets you compare physical inventory counts with the totals in your Sage ERP Accpac Inventory Control system. The report identifies discrepancies between item quantities and costs, and shows what will be posted by the Post Inventory Reconciliation form.
See Count and Reconcile Inventory Quantities for a complete list of the steps in the stocktaking process.
Before
you start
-
Run Day End Processing to update the company's Inventory Control data.
-
Create inventory worksheets for each location using the Generate Inventory Worksheet form.
-
Count inventory items.
-
Enter item quantities using the Physical Inventory Quantities form or using the Inventory Counts form.
To print the Inventory Reconciliation report:
-
Open Inventory Control > I/C Physical Inventory > Inventory Reconciliation.
-
Make your selections as follows:
Location [ ] to [ ]. Specify the range of locations to include in the report.
Show Only Items with Quantity Variance. Select this option to list only those items that show a variation between the quantity on hand recorded in Inventory Control and the physical count you entered in the Physical Inventory Quantities form. The report then excludes items for which the totals are the same in Inventory Control as in your physical count.
Include Comment for Each Item. Select this option to print a blank comment line for each item listed in the report.
Include [ ]. Select from two types of report.
-
All Units of Measure. The report lists quantities counted for each unit of measure.
-
Stocking Unit Only. The report lists total quantities counted in the stocking unit of measure only.
-
To begin printing, click the Print button.
After
printing the Inventory Reconciliation report
-
Count inventory items.
-
Use the Physical Inventory Quantities form or the Inventory Counts form to enter physical inventory counts for inventory worksheets.