@colin
The inventory value shown in the Inv Value report (i.e. Parts > Reports > Inventory Value) - that is derived from the Inventory Activity log (Parts > Reports > Inventory Activity), which takes a snapshot of every movement of inventory and its related cost impact.
The inventory value shown in the Inventory Overview is calculated using the inventory quantity on hand times the avg cost of the quantity.
The inventory value shown in your Balance Sheet is simply the sum all of the gl splits and sum of the amounts therein; these amounts are generated by ledger postings, which maybe posted to manually or via system generated ledger posts. System generated ledger posts depend on how you have your G/L Account mappings set.
Any discrepancy between those numbers… could be due to any number of possible issues.
It could be a data issue with the inventory details that were migrated from your previous system, it could be a process-related issue, it could be a bad manual post, it could be bad mapping, etc. etc. - to pinpoint root cause on this type of thing usually requires fairly deep forensic accounting analysis.
Alternatively, you could attempt to draw a clean line as of today (or a date in the near future) and reconcile the inventory numbers from here moving forward (and then monitor any deviations between those two values daily/weekly/monthly into the future).
To do this, first note that we strongly recommend the practice of tying your Balance Sheet inventory account to a particular report in Cetec ERP called “List By Bin”. The “List By Bin” report is the gold standard for any inventory valuation; it is always real time, and it is always the bullet proof calculation of the current real-time count and value of your inventory in the moment.
If you want to draw a clean line as of today (real time), you could run List By Bin, get the total, and create a manual ledger entry against your balance sheet inventory account(s) to accommodate any delta, such that the Inventory asset account balance matches the List By Bin data. Then, monitor any deviations between those two values daily/weekly/monthly into the future.
Hope this helps. Thanks!