web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / General Ledger and Sub...
Microsoft Dynamics NAV (Archived)

General Ledger and Sub Ledger Reconciliation Problem.

(0) ShareShare
ReportReport
Posted on by Rabin 2,976

Hello,

There is an issue with one of the system i am working on related to "Difference in value between G/L and Sub Ledger". They do not match up. The user did direct posting ant its been more than 5 years. The data in the Ledger table is huge. 

User Says," When I run my G/L to inventory Reconciliation and compare it to my inventory G/L, they don’t match.  In fact if I run my Inventory Valuation and track the changes month by month, the changes do not tie to my G/L.   In some cases the inventory decreases but the G/L increases. " 

Any idea on this one... I tried to match the ledger total with the total generated by "Inventory to G/L Reconcile" report. But there is huge difference. I have to find the reason for the difference. 

NAV Version 2009 Classic. 
----------------------------

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Miguel Llorca Gómez Profile Picture
    Miguel Llorca Gómez 7,019 User Group Leader on at

    Hope this helps: https://community.dynamics.com/nav/b/navguestcolumn/archive/2011/09/12/reconciling-inventory-value-to-your-inventory-general-ledger-account

    Good luck!

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,096 on at

    If users are posting to the same account both using items and items groups and directly to the same account, this is a worst nightmare )). What you need to do is to separate in G/L Entry the transactions posted directly and take them out from your reconciliation between G/L ledger and Item ledger. Preferably, if you would be able to identify G/L transactions, posted directly, you can move them to a different account via SQL or manually in the tables, so they would be separated.

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans