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 AX (Archived) / Reconciliation between...
Microsoft Dynamics AX (Archived)

Reconciliation between Accounts payables and Trail Balance Payable account

(0) ShareShare
ReportReport
Posted on by Nabil Abdelrahman 1,551

In AX 2009 after printing GL>>reports>>reconcilation > vendors it dose not show any diffrence with zero grand total ,but when comapring between Accounts payables vendors balances  and Trail Balance Payable account I can see diffrence ,

My qestion is how i can identify if this issue is bug by the system or its not ,and how I can spot these diffrences and Fix ?

I'm using AX 2009 RU6.

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

    Hi Becatcho,

    Do you have the difference if you include all transacions or did you entered an end date for the selection? You can try to identify the movement on the ledger account and the vendor transactions per month. When there is a difference within a certain month, try to find differences per date. Then you might be able to find the culprit.

  • Community Member Profile Picture
    Community Member on at

    HI Becatcho,

    if the  recon report does not show any difference, then most likely the AP report is ignoring  few transactions. i have seen that if you run a report for example: period ending 11/30 and if you have settled transactions on 11/30 or 12/1, strangely those transactions might be excluded in the balances report.

    these transactions could be your starting point for troubleshooting.

  • Nabil Abdelrahman Profile Picture
    Nabil Abdelrahman 1,551 on at

    Hi André Arnaud de Calavon

    I was printing TB report from 1/1/2014 to Nov 1st 2014 and I realized differences .

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

    Hi,

    Try to match the vendor transactions with the GL transactions on the voucher and transaction date. There should be some transactions not matched. Then you know which transactions. With this information you can search how transactions are posted and why there is a difference.

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 AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans