Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Customer Aging report ...
Microsoft Dynamics AX (Archived)

Customer Aging report differences

(1) ShareShare
ReportReport
Posted on by imran ul haq 3,964

Hi all

I am trying to generate the customer aging report and seen the wired behavior, while generating the report for one customer i select the below parameters:

2117.11.jpg

Following is the output:

4274.12.jpg

And the below is the customer transactions details:

5340.13.jpg

Now when i compare the Voucher from the customer transaction amount is different from the aging report like in first voucher "QIGC-30000001" customer transaction amount is showing "0.0200" while in the report it is "245.98".

Please guide me how i can cross check the report with the customer transactions.

Thanks in advance.

*This post is locked for comments

  • Kenneth S. Profile Picture
    Kenneth S. 10 on at
    RE: Customer Aging report differences

    Hi, may I know how you update the record in CustSettlement? What value did you put? Thanks

  • imran ul haq Profile Picture
    imran ul haq 3,964 on at
    RE: Customer Aging report differences

    Hi Prakash,

    I don't think its a bug, i believe the aging is totally based on the due date and the settlement dates and all the data revolves around the dates, so the result will be based on the dates.

  • Prakash P Profile Picture
    Prakash P 800 on at
    RE: Customer Aging report differences

    Hi Imran, Thank you, your solution helped us.

    We faced exactly the same issue. Settlement got reversed in Jan 2017 and if we run the aging report as of Jan 2017, balance is correct and if run the report on Dec 2016, balance is wrong.

    Seems to be a bug in the report.

    Thank you.    

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Customer Aging report differences

    Hi Imran,

    Can we verify your solution that you described in your last comment? I believe it might be helpful for many other users.

    Best regards,

    Ludwig

  • Verified answer
    imran ul haq Profile Picture
    imran ul haq 3,964 on at
    RE: Customer Aging report differences

    Hi Ludwig/Brandon

    Thanks for your reply

    I checked in history tab available on the customer transaction form, and found user settled the invoice 12/31/2016 and reverse the settlement on 1/9/2017. So i manually update the date in the custsettlement table and then generate the report. So far this updation worked for me.

    Thanks for your usual support.

  • Suggested answer
    Brandon Wiese Profile Picture
    Brandon Wiese 17,788 on at
    RE: Customer Aging report differences

    It appears at a glance like you might have a problem between the CustTrans record and the CustTransOpen record for that transaction.  The customer aging report pulls the amounts from CustTransOpen for customer transactions that are not closed (fully settled).

    Please inspect the CustTrans record versus the CustTransOpen record.

    It might be easiest to view the CustTransOpen record from the customer using Settle open transactions.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Customer Aging report differences

    Hi Imran,

    Can you identify anything "strange" if you open voucher "QIGC-30000001" from the ledger accounts used while posting this voucher?

    If you cannot find anything else, please have a look at LCS whether this issue might be caused because of a bug.

    If there is nothing available there you need to consult a developer who can help you with analyzing what might be wrong with the report.

    Would be great if you could keep us updated here.

    Many thanks and best regards,

    Ludwig

  • imran ul haq Profile Picture
    imran ul haq 3,964 on at
    RE: Customer Aging report differences

    Hi Ludwig,

    My transnational and accounting currency is the same for the customer. Also when i generate the report without aging definition it is showing the same. Also i tried generating the report  balance as of today's date report is coming fine but if balance as of 31 dec 2016 its wrong.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Customer Aging report differences

    Hi,

    Have you tried running the report with the parameter 'show amounts in transaction currency?

    Can you also please run the report without referring to an aging definition to see if this makes a difference?

    Many thanks,

    Ludwig

  • imran ul haq Profile Picture
    imran ul haq 3,964 on at
    RE: Customer Aging report differences

    Can anyone suggest me what's wrong with the report

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,514 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans