Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Difference in GL accou...
Microsoft Dynamics AX (Archived)

Difference in GL account balance between Trail balance report and vendor balance report

(0) ShareShare
ReportReport
Posted on by RaghavR 240

Hi Friends,

Good evening,


The issue belongs to GL account balance difference between Trail balance report and vendor balance list report.


We have noticed the Difference in GL account (Sundry creditors) between Trail balance report and Vendor balance list report.

Example: Sundry creditors GL account number- 222001
Date range given- 01-04-2018 to 31-03-2019 for both reports

Sundry creditors GL balance at Trail balance report-119,000
(path: GL-Common-Trail balance)

Sundry creditors GL balance at Vendor balance list report- 100,000
(path: AP-Reports-Status-vendor balance list)

can i know the reason behind the Difference between both reports balances, both reports are standard reports but balances are showing difference.


please do needful.

Regards,
Ramanadham.

*This post is locked for comments

  • Suggested answer
    SouravDam Profile Picture
    SouravDam 11,721 on at
    RE: Difference in GL account balance between Trail balance report and vendor balance report

    Hi Ramanadham R,

    Kindly find response on below points.

    Case-1: - Summary account will definitely show in voucher as it is ultimately updating sub-ledger balance into this summary account. However; my concern is below in this context;

    • If you look at View subledger journal available in voucher, you will see which subledger account is posted in that journal corresponding to that summary account. Subledger account definitely show here if you post the transaction based on subledger and not directly with summary account.
    • Are you sure that Do not allow manual entry check box in Main account form is not recently set ticked? What if it was earlier not ticked and later it was set ticked to not allowing manual entry. But by that time; may be transactions already posted manually in that summary account directly and without recording it through subledger !!

    Convincing this part to the users is a bit challenging I know especially if they want to stick to their own perception. However you can be sure that; this type of mismatch happen because of this reason where transactions are posted directly in summary account, without recording through subledger account.

    Is database log is enabled in your system? Can you check when the Do not allow manual entry check box was last updated. At least then you can find a valid reason to explain the root cause of this mismatch.

    Case-2: - Have to check if any hotfix is available and then can update you.

    Best regards,
    Sourav Dam

    Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.

  • RaghavR Profile Picture
    RaghavR 240 on at
    RE: Difference in GL account balance between Trail balance report and vendor balance report

    Hi Sourav,

    Good evening,

    Thanks for your reply,

    Regarding Vendor Ledger balance report we have noticed some of the vouchers in the report for the particular period previously but in our forum some of professionals are commented that the report is wrong and we need to update with hotfix, so that i have not considered this report, other wise we have noticed the vouchers in the Vendor/ Ledger report.

    Case-1 : If i consider the Vendor Ledger balance report,

    In the vendor ledger balance report I have noticed some vouchers but report showing with Header of Summary account-1 and when i go to the line with voucher its showing also summary account-1 with credit (In vendor group setup also showing with summary account-1 for vendor master).

    Note: these invoices are still overdue, not settled. (checked with reference to andre suggestion)

    What could be the reason from your side and how can i Convince the client, please suggest.

    Case -2: Is Vendor ledger balance report wrong/ hotfix is available for this report, kindly share the Hotfix number.

    Thanks & Regards,

    Ramanadham.

  • Suggested answer
    SouravDam Profile Picture
    SouravDam 11,721 on at
    RE: Difference in GL account balance between Trail balance report and vendor balance report

    Hi Ramanadham R,

    Have you checked the Vendor to ledger reconciliation report as Satish Panwar mentioned in his post ? You  can check this in AP > Periodic tasks. Below is the extract of the report where you can directly click on journal numbers to go the original document to check the details and find out the cause of this difference.

    7888.JPG

    Also, check what André mentioned in case if there is any wrong settlement happened.

    Have you checked whether rebuild balances in financial dimension sets form is helping you to update the values in Trial balance or not.

    In fact, you don't need to do this rebuilding for standard TB as it should automatically update the balances when you are running the TB. However, you can try this option separately too.

    Kindly check all above points and update in this forum for further concern.

    Best regards,
    Sourav Dam

    Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.

     

  • RaghavR Profile Picture
    RaghavR 240 on at
    RE: Difference in GL account balance between Trail balance report and vendor balance report

    Hi Sourav,

    Good Afternoon,

    Thanks for your immediate reply,

    Before posting this issue i have checked the scenario's include "Do not allow manual entry check box" at main account setup, its already ticked and there are no transactions in sub ledger journal entries not yet transferred form.

    Can i know any other reason behind Sundry creditors GL balance at Trail balance report and at Vendor balance list report.

    Kindly suggest.

    Regards,

    Ramanadham.  

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Difference in GL account balance between Trail balance report and vendor balance report

    Hello Ramanadham,

    Have you been able to get this issue resolved in the meantime?

    Would be great if you could keep us informed/updated here.

    Many thanks and best regards,

    Ludwig

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Difference in GL account balance between Trail balance report and vendor balance report

    Hi Ramanadham,

    Please check the suggestions mentioned above. In addition, it can also be caused by wrong settlement updates. E.g. settlement of future transactions (e.g. payment later than 31-03-2019 marked with an invoice with a settlement date before 31-03-2019).

    Have you verified if the balance as of today is correct?

  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,645 on at
    RE: Difference in GL account balance between Trail balance report and vendor balance report

    Hi Ramanadham,

    Try running report under AP module and see if this provide you the details for the difference.

    Vendor to ledger reconciliation report

    Thanks,

    Satish Panwar

    Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.

  • Suggested answer
    SouravDam Profile Picture
    SouravDam 11,721 on at
    RE: Difference in GL account balance between Trail balance report and vendor balance report

    Hi Ramanadham R,

    Can you please check below;

    --- In Main accounts form; whether Do not allow manual entry check box is not ticked for the sundry creditors account or not ?

    --- If this is not ticked; then can you check whether you have posted any transactions directly on that main account; instead passing entries on this account through sub-ledger vendor ?

    --- If you posted transactions directly in this account, then you need to generate all transactions for the same date ranges you specified. At the same time you have to generate all posted transaction for the same date ranges from the vendor. Then you need to compare both records to identify which entry you posted directly in the sundry creditors main account, instead posting it through sub-ledger vendor.

    Addition to above; you need to check in below areas too.

    --- Whether there is any posted transactions are not yet transferred to sub-ledger journal entries or not. If 'Yes', then you need to run Subledger journal entries not yet transferred or Batch transfer for subledger journals as available in General ledger > Periodic tasks.

    --- Also you have to check, based on which financial dimension set, you are generating the standard Trial Balance in system. Then you can go to Financial dimension sets form. Select the same dimension set based on what you are generating the TB and then click on Rebuild balances.

    Kindly check above areas and update in this forum.

    Best regards,
    Sourav Dam

    Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans