web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
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 4,017

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

I have the same question (0)
  • imran ul haq Profile Picture
    imran ul haq 4,017 on at
    RE: Customer Aging report differences

    Can anyone suggest me what's wrong with the report

  • 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 4,017 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 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

  • 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.

  • Verified answer
    imran ul haq Profile Picture
    imran ul haq 4,017 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.

  • 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

  • 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.    

  • imran ul haq Profile Picture
    imran ul haq 4,017 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.

  • 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

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

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 3

#3
Scott_itD Profile Picture

Scott_itD 2 Community Manager

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans