Notifications
Announcements
No record found.
Hi Experts !
Inventory balance is differ with Gl and inventory module. Can any one help me out how to do reconcile ?
Hi Manik,
Inventory management > Inquiries and reports > Inventory accounting - status reports > Potential conflicts - inventory and general ledger, it will identify what caused the imbalance. The report was designed to check for the most common issues that cause discrepancies between GL and Inventory values.
The potential conflicts report that Mattguo mentioned is a possibility to do a reconciliation. You might however see lines in that report that are not related to a difference between GL and inventory.
For that reason, you can use the inventory value report in addition. This report allows you showing the ledger balances at the end of the report, which allow you a relatively fast reconciliation.
Yet, the best option in my opinion is using a findim for each released product or at least for the product group that are posted on the same ledger account. If you have that then you can directly see from your trial balance form in GL where a difference between GL and inventory arose. With such a findim you don't even need to run a report or do some very detailed investigation in invent trans data to see where the difference came from. Probably think about this setup option for the longer term; it might help not only with the reconciliation but also with the calculation of costs and the profitability of your items.
Best regards,
Ludwig
when i run this potential conflicts report inventory value is showing wrong,compare to Inventory value report total .
Right. The potential conflict reports gives you - in my opinion - often too many potential conflicts that highly depend on how the setup is made. The right inventory value is the one that you see in the inventory value report. Please use this inventory value report for reconciliation and the potential conflict report only as additional supportive tool.
Thank you Ludwig.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 559 Most Valuable Professional
André Arnaud de Cal... 464 Super User 2025 Season 2
Sohaib Cheema 250 User Group Leader
