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) / Issue on: Customer Agi...
Microsoft Dynamics AX (Archived)

Issue on: Customer Aging Report not matching/tie with Customer Transactions

(0) ShareShare
ReportReport
Posted on by Community Member

Hello to Every One Please Help on this issue.

The SL (ageing) vs GL does not tie (both for vendor and customer). 

In Customer Transactions we have Multiple Currency's as well Reversed Transactions also.

Please let me know any answers to similar this issue.

 Is it possible to tie Customer Transactions with Customer Aging Report?

One Customer Aging Report:

11_2D00_1_2D00_2017-8_2D00_09_2D00_49-PM.png

Customer Transaction Amount: we have more than 3000 transactions so its not copy to here.

11_2D00_1_2D00_2017-8_2D00_12_2D00_26-.test.png

Regards,

Anjan.

*This post is locked for comments

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

    Hi Anjan,

    What $ amount do you see in the customer balance report?

    Is it the same that is shown in the customer aging report?

    Have you already checked the reconciliation reports between the main and the subledgers available in GL?

    Best regards,

    Ludwig

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

    Customer Balance list records the balance as at a date.

    Customer Ageing Report looks at what transactions  are OPEN at a date.

    Dynamics AX works on  dates not  period buckets,  – 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. but you may experience currency differences after exchange rate adjustment when the invoice stays open after financial closing and you are running a back dated report.

     Through open transaction editing (normally) the date principle determines the date the transaction is settled (closed) and  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.

    This post is an example of the type of issues that can arise with dates: https://community.dynamics.com/ax/f/33/t/222617

    I find the Collections form it  looks very similar to the “Customer aging” report, click the “Transactions” button to see the transactions that make up the balance.  This form acts on a snapshot of open transactions. 

    When the form is opened, to see the current balance, click the “update aging” button in the ribbon bar.  This will update the balance for the  customer  selected.

    To update all customer balances,  process, or batch the periodic job found in “Accounts receivable”–>”Periodic”–>”Collections”–>”Customer aging snapshot.” 

    Periodically running this job keeps the bulk of the records updated, though you should till perform the manual “update aging” when accessing the record to make sure you have the most up-to-date information.

     

  • Community Member Profile Picture
    Community Member on at

    Hello Ludwig,

    Thanks for your response but right now i dont have access from client,

    so once i got i'll check that and then i will revert with confirmation/query.

    Have you already checked the reconciliation reports between the main and the subledgers available in GL?

    Yeah those are showing there.

    Thanks,

    Anjan.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Anjan,

    Would be great if you could keep us updated once you have a feedback from your customer.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig,

    Now the Issue is changed like " the total GL does not tally with the Customer Ageing Report"(AP/AR) postings. Actually there was one GL Voucher for this they did some Exchange Adjustments to tally the voucher amount like below.

    AROPN-000049 1/1/2013 RCPT AUG08 SRV08-007 USD    (175.96)

    some more transactions we have in b/w to tally but the issue with the last 3 transactions:

    PCV17-00033 7/26/2017 RCPT AUG08 SRV08-007 USD         21.93 0 Exchange adjustment
    PCV17-00033 7/26/2017 RCPT AUG08 SRV08-007 USD         21.93 0 Exchange adjustment
    PCV17-00033 7/26/2017 USD       (21.93) 0 Exchange adjustment
    GLEXCP17-00463 7/25/2017 USD       197.89 0
    Diff Amount         21.93

    Actually i search in AR>Periodic> Exchange Adjustment: in voucher transactions i got transaction like below:

    As same way showing in Customer transaction also.

    2072.124.png

    for this Voucher Transaction: here we found 6 transactions, normally it will show 4 only right ? i am not able 

    to get original transaction of this voucher.

    2072.124.png

    So please any one help out me from this issue.

    Regards,

    Anjan.

    PCV17-00033 26/7/2017 No Normal USD 0.00 -21.93 -13.96 0 Exchange rate loss Yes No Current Normal USD 0.00 0.00 -13.96 No 0.000000000000 0.000000000000 3TPY_AU CC030 O NA NA NA NA NA false 1150007 TRADE RECEIVABLE - REGULATORY PRINCIPALS PCV17-00033 26/7/2017 No Normal USD 0.00 21.93 13.96 0 Exchange rate loss No No Current Normal USD 0.00 0.00 13.96 No 0.000000000000 0.000000000000 3TPY CC030 O NA NA NA NA NA false 1150007 TRADE RECEIVABLE - REGULATORY PRINCIPALS PCV17-00033 26/7/2017 No Normal USD 0.00 21.93 13.96 0 Exchange rate loss No No Current Normal USD 0.00 0.00 13.96 No 0.000000000000 0.000000000000 3TPY CC030 O NA NA NA NA NA false 1150007 TRADE RECEIVABLE - REGULATORY PRINCIPALS

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