Inventory Reconciliation Report

With the Inventory Reconciliation Report, you can research your inventory quantities and the transactions that increased or decreased those quantities in a given date range. Because this report displays the ending quantities and costs of items for the specified date range, you might want to include printing it in your month-end closing procedures.

To generate an Inventory Reconciliation Report

1. Select Reports from the Inventory menu. The Report List appears with the Inventory tab selected.

2. Select Inventory Reconciliation Report and click Launch. The Custom Inventory Lookup screen appears.

3. Look up the items you want to include on the report. The Selected Inventory screen appears. For more information, see Looking Up Inventory Items.

Note: If you want to look up different items, click Change.

4. Click OK. The Inventory Reconciliation Report screen appears.

5. Select the starting and ending dates for the report’s date range.

6. Select one of the following methods for organizing items on the report:

Category
Group

7. Select or clear the following check boxes as needed:

Show Detail includes document numbers, unit costs, and part numbers on the report.
Show Current Qty includes current on-hand and current work order quantities.

8. Click Print. The Report Window appears.

9. Print the report and close the Report Window.

10. Close the Inventory Reconciliation Report screen.