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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / year end closing proce...
Finance | Project Operations, Human Resources, ...
Suggested answer

year end closing process Balance difference for vendor sub ledger accounts

(0) ShareShare
ReportReport
Posted on by sunil narvaneni 261

Hi all, we are facing balance difference after running Year End Closing.

For e.g. We have an Account A with closing balance of $100 in 2018 period, now after we run the Year End Closing, the Opening Balance of this GL in 2019 is $70. The total balance is not transferred.

Like this some sub ledger accounts were not transferred correctly. Any one experienced this kind of issue? And can you please tell me the solution for this.

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: year end closing process Balance difference for vendor sub ledger accounts

    Hello sunil,

    Have you already checked LCS to ensure that this behavior is not related to a bug?

    If you cannot find something there can you then provide us some more details about the issue?

    An example with some screenprints that illustrate the problem would be great.

    Best regards,

    Ludwig

  • Suggested answer
    Zain Mehmood Profile Picture
    Zain Mehmood 4,173 Most Valuable Professional on at
    RE: year end closing process Balance difference for vendor sub ledger accounts

    Hi Sunil,

    Did you run the report for checking your vendor balance is equal to the amount in GL before you went for Year End Closing?

    This is a very small chance of happening but did your vendor posting account was changed during the period by any way? This can be a reason due to which the 30$ balance might have gone to the profit  & loss section.

    Warm Regards,

    Zain

  • sunil narvaneni Profile Picture
    sunil narvaneni 261 on at
    RE: year end closing process Balance difference for vendor sub ledger accounts

    Thank you very much for your reply @Zain Mehmood

    i have checked the vendor GL Reconciliation amount is not matched, Because user made many manual entries directly (Do not allow manual entry check box is  not enabled)

    Why i am getting difference for only two sub ledger accounts

    Thanks

  • Suggested answer
    Zain Mehmood Profile Picture
    Zain Mehmood 4,173 Most Valuable Professional on at
    RE: year end closing process Balance difference for vendor sub ledger accounts

    Hi Sunil,

    Can you show me which sub ledger accounts you are getting the difference ?

    Regards,

    Zain

  • sunil narvaneni Profile Picture
    sunil narvaneni 261 on at
    RE: year end closing process Balance difference for vendor sub ledger accounts

    Thank you@ Zain Mehmood

    Accounts Payable local and Advance Paid account

    Thank you

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: year end closing process Balance difference for vendor sub ledger accounts

    Hello sunil,

    Can you provide us more information on the issue especially on the account setup.

    As an example, have you setup opening accounts in the COA for the accounts that show a difference?

    Best regards,

    Ludwig

  • Zain Mehmood Profile Picture
    Zain Mehmood 4,173 Most Valuable Professional on at
    RE: year end closing process Balance difference for vendor sub ledger accounts

    Hi Sunil,

    I agree with Ludwig here, if there is no difference you could find in between the period and you are unable to find any manual transaction. There might be something in the opening balance for GL and sub-ledger accounts. Additional information might help.

    Thanks,

    Zain 

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: year end closing process Balance difference for vendor sub ledger accounts

    Hello sunil,

    Do you have any update on this one?

    Have you possibly already resolved the issue?

    Best regards,

    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.

Helpful resources

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 813

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 738 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 566 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans