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) / Vendor Aging balances ...
Microsoft Dynamics AX (Archived)

Vendor Aging balances are not matching with Vendor balances in Trail balance.

(0) ShareShare
ReportReport
Posted on by RaghavR 246

Hi All,

One of my client want to match vendor payable balances in trail balance with Vendor Aging report balances.

i have checked vendor payable balance in Trail balance with aging report balance.

is both balances will match in AX generally???

please suggest.

Regards,

Ramanadham.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Ramanadham R,

    Those balances should match if no filter or wrong report selection was made.

    Can you check the vendor reconciliation report in GL whether it shows a difference between GL and AP?

    In addition, can you compare the vendor aging report with the vendor balance list to find out whether they match?

    Best regards,

    Ludwig

  • Suggested answer
    guk1964 Profile Picture
    guk1964 10,888 on at

    Differences can arise in the reports  with closed dates of transactions and the reports may not necessarily match for that reason.

    • Vendor Balance list records the balance as at a date.

    • Vendor Ageing Report looks at what transactions  are OPEN at a date.

    Through open transaction editing (normally) the date principle determines the date the transaction is settled (closed) and that this could be closed at a date prior to your balance date, and be settled against a payment past your balance date. Therefore it would be excluded from the Ageing Report, but not the balance list.

    Dynamics AX is date driven system rather than by period buckets, that's how it works.  – when you set the date principle to the date on which you do the open transaction editing settlement (i.e. today's date), generally the results match. It is possible to get currency differences after exchange rate adjustment when the invoice stays open after financial closing and you are running a back dated report.

    An example is  the year-end process when the Exchange adjustment process for Supplier, resulted in a few of transactions being created). The currency revaluations are posted  into the current year adjustments for invoices which were settled and  posted last year, but for which  the invoice was not closed prior to the revaluation (i..e. the order had been settled but was still open for revaluation). In  that case such a currency revaluation posting  affects only the aging analysis report. . It would not not affected Vendor balances / Statement of Account in the GL/AP module. If the system has posted settlements and the transactions are closed, then this cannot be rectified with data corrections,.  However to clarify such a situation e.g.  for audit purposes there is an exception report available which highlights such differences ; Name : “vendcheckSettlement”

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
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Ali Zaidi Profile Picture

Ali Zaidi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans