Inventory Reconciliation Report — Features
The Inventory Reconciliation report lets you compare actual physical inventory totals 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.
For instructions on printing the report, see Printing the Inventory Reconciliation Report.
Information printed on the report
The Include All Units Of Measure version of the report includes:
-
The ranges of account sets and item numbers selected when you generated the Inventory Worksheet.
-
The adjusted unit cost, which is the Adjustment Unit Cost you entered for each item in the Physical Inventory Quantities form after taking inventory.
-
The quantities on hand, calculated by Inventory Control from the transactions posted for each item.
-
The physical count (quantity counted) you entered in the Physical Inventory Quantities form for each item's units of measure.
-
The variance, if any, between quantity on hand as calculated by Inventory Control and the counted quantity you entered.
-
The cost variance, which Inventory Control calculates by multiplying the adjusted unit cost by the quantity variance.
-
The Serial/Lot Quantity variance (if any) between the quantity counted and the numbers assigned.
-
The status code of each item, indicating whether the item information can be posted by the Post Inventory Reconciliation form.
-
Comment lines where you can write remarks for your own information.
-
Explanations of each status code:
-
The item is ready to post and will be deleted from the report when you post the inventory reconciliation.
-
The item is not ready to post. Information for on-hold items is not updated when you post an inventory reconciliation, and the item is not deleted from the report when you post the reconciliation.
-
The item record was deleted from Inventory Control after you generated the Physical Inventory Worksheet.
-
This status identifies non-stock items.
-
This status identifies items at a location which are not allowed to be used in transactions.
-
This status applies only when you do not use the Allow Negative Inventory option. The status identifies items whose quantity on hand would fall below zero if you posted the reconciliation.
-
The item's status has been set to Inactive on the item record.
The Include Stocking Unit Only version of the report includes a single line for each item, showing information for only the stocking unit of measure, rather than for all units defined for the item. The report also includes comment lines if you selected this option.
See also