Inventory Report

Is there an inventory value report that ties to the general ledger?

Hi @Brandi.Blow

The gold standard for real-time accurate inventory value is Parts >> Views/Lists >> List By Bin

There is another report - Parts >> Reports >> Inv Value - that takes a snapshot of what the inventory’s value (from List By Bin) was each day, letting you report on what inventory value was in the past.

Now, as for inventory tying to the general ledger, that is a common accounting practice (e.g. month end). If you go to Accounting >> Audit >> Daily Ledger Vs. Inventory Activity that helps you track each days inventory value activity against the corresponding General Ledger credits/debits that inventory is mapped to.

Theoretically those should always line up. But, if you have any users that are breaking process and divorcing inventory activity from corresponding inventory ledger value, you should see those discrepancies in that Audit report and be able to address them, address any process isssues they may reveal, adjust any inventory G/L amounts you might need to do in order to get Inventory Details vs. Ledger reconciled and tying again, etc.

Hope this helps.