Inventory Value vs GL compares calculated inventory lot value by product line to the corresponding GL balance.
What this report is for
Use Inventory Value vs GL to identify differences between inventory subledger value and GL inventory balances.
This report is a reconciliation review tool. It does not correct differences by itself.
Screen path
Dashboard > Inventory > Reports > Inventory Value vs GL
Actions
| Control | What it does |
|---|---|
Copy for Excel |
Copies product line rows and a total row to the clipboard. |
Report columns
| Column | What it shows |
|---|---|
Product Line |
Inventory product line. |
GL Account |
GL account mapped to that product line. |
Inventory Value |
Quantity on hand times lot cost for active inventory in that product line. |
GL Balance |
Current GL balance for the mapped account. |
Difference |
Inventory Value minus GL Balance. |
The report also shows a total row.
Product line to GL mapping
| Product Line | GL Account |
|---|---|
01 |
1200 |
02 |
1210 |
FG |
1220 |
RS |
1230 |
What happens behind the scenes
PAX calculates inventory value from active inventory records in product lines 01, 02, FG, and RS, using lot quantity on hand times lot cost.
PAX calculates GL balance from the current fiscal period opening balance plus period debits minus period credits through the current timestamp.
Running or copying the report does not post journal entries, change inventory, change costs, or close periods.
Troubleshooting
Difference is not zero
Likely cause: Inventory value and GL balance do not currently reconcile for that product line/account.
Safe fix: Review recent inventory adjustments, receiving, shipments, work order completions, cost corrections, and manual journal entries before making any correction.
Contact support if: You cannot identify the source of the difference.
A product line is missing
Likely cause: The report only includes active inventory in product lines mapped by the report: 01, 02, FG, and RS.
Safe fix: Confirm the part product line and whether it should be included in this reconciliation.
Contact support if: A mapped product line with inventory value does not appear.