This window is a tool to help in auditing the reconciliation between the inventory subledger, which is the value entries, and the general ledger.
When you open the window, the matrix grid is empty, containing no information. In the filter fields at the top, you can enter filters to limit, for example, the period of time for which you want information.
If you place a check mark in the Show Warning field and if there are any discrepancies between the inventory totals and G/L totals, the program shows messages in the Warning field of the grid that explain the discrepancy. If you click the drill down button in the Warning field, the program gives you more information on what the warning means.
When you have entered all relevant filters, click Calculate at the bottom of the window to populate the window with information. The Calculated field at the top of the window contains a check mark.
On the far left column in the grid, you see the various general ledger account types that are associated with inventory. The grid then shows the invoiced, non-invoiced (interim), and WIP inventory totals for each of these account types. The program calculates these totals from the value entries.
The next columns then show the totals for the same account types calculated from the general ledger entries.
Click the drill-down button in any of the total fields to see the inventory report entries that were used to calculate the totals. For inventory totals, the inventory report entries are the sums of the value entries for the items. For the G/L totals, the inventory report entries are the sums from the general ledger entries.