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

Announcements

Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Customization in Custo...
Finance forum

Customization in Customer Aging Report D365

(0) ShareShare
ReportReport
Posted on by Ali Sajjad 195

Hi All,

I want to make changes to the out of the box Customer Aging Report in D365.
Currently the out of the box functionality only shows aging for parents and regular customers (with no parent child relationship). It does not show aging for children because technically the parent will receive payment.

However, I want to do customization so as to be able to send an aging report to the children with their aging details as well.

Any ideas about adding changes in code?

TIA

Categories:
Development / Customization / SDK
I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi TIA,

    When you say children, do you refer to the invoice account that can be setup for the customers or to something else?

    Would be great if you could let us know how you identify the parent-child relationship.

    Many thanks,

    Ludwig

  • Ali Sajjad Profile Picture
    Ali Sajjad 195 on at

    Yes exactly.
    If you see, I have a customer "Test-02" on which I have set an invoice account "Test-01" which is another customer. Now, the transactions of Test-02 will show up in Test-01 and ultimately report will show the aging in Test-01 (correct me if I'm wrong).

    *Btw I'm Ali :) 

    pastedimage1569399018480v1.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Ali,

    When you setup an invoice account the open position is tracked at the invoice account level - the parent in your case.

    At the child level you don't see any invoice data and as a result you cannot run an aging at that level.

    You can try doing a customization but that might be difficult as your code would have to 'distribute' the amounts to the different children and then age it, which might result in a complex code that needs some time to run.

    Wouldn't it be better and feasible not using the invoice account functionality?

    That is because you can always summarize data from the children and roll them up in a report e.g. by using a financial dimension.

    The other way around that you try is much harder.

    Best regards,

    Ludwig

  • Suggested answer
    KrishnamRaju Profile Picture
    KrishnamRaju 95 on at

    Hi Ali,

    There is a possibility as we have already done this in AX2012 in the past. But coming to D365 F&O, the customization may not be that straight forward when compared to AX2012 considering the over-layering limitations in D365 F & O.

    To achieve this, you may need to play with two main fields (AccountNum, OrderAccount) from CustTrans table. In your case Test-02 customer account will be stored in OrderAccount field of CustTrans table based on which you need to change the querying logic to pull the data on to the ageing report. In D365 F & O, you may need to extend standard Ageing report related classes to achieve this.

    Hope this helps. Thank you.

  • Ali Sajjad Profile Picture
    Ali Sajjad 195 on at
    [quote user="Ludwig Reinhard"]

    Hello Ali,

    When you setup an invoice account the open position is tracked at the invoice account level - the parent in your case.

    At the child level you don't see any invoice data and as a result you cannot run an aging at that level.

    You can try doing a customization but that might be difficult as your code would have to 'distribute' the amounts to the different children and then age it, which might result in a complex code that needs some time to run.

    Wouldn't it be better and feasible not using the invoice account functionality?

    That is because you can always summarize data from the children and roll them up in a report e.g. by using a financial dimension.

    The other way around that you try is much harder.

    Best regards,

    Ludwig

    [/quote]

    Hi Ludwig,

    I'll consult this solution with team.

    Thank you so much.

    Regards,

    Ali

  • Ali Sajjad Profile Picture
    Ali Sajjad 195 on at
    [quote user="Krishnam Raju"]

    Hi Ali,

    There is a possibility as we have already done this in AX2012 in the past. But coming to D365 F&O, the customization may not be that straight forward when compared to AX2012 considering the over-layering limitations in D365 F & O.

    To achieve this, you may need to play with two main fields (AccountNum, OrderAccount) from CustTrans table. In your case Test-02 customer account will be stored in OrderAccount field of CustTrans table based on which you need to change the querying logic to pull the data on to the ageing report. In D365 F & O, you may need to extend standard Ageing report related classes to achieve this.

    Hope this helps. Thank you.

    [/quote]

    Hi Krishnam Raju,

    As far as I was digging up, I found out these classes which are behind the scenes for calculations,
    1. CustBalanceList
    2. CustVendBalanceList
    3. CustAgingCalculation
    4. CustVendAgingCalculation

    Can you please elaborate in which class or classes I have to do the coding stuff for the particular reason?

    Regards,

    Ali

  • Suggested answer
    KrishnamRaju Profile Picture
    KrishnamRaju 95 on at

    Hi Ali,

    From the D365 F & O point of view, you may need to look at the below changes to maintain Order account and to query the aging data.

    Need child classes for the below classes

    1. CustBalanceList

    2. CustAgingCalculation

    3. CustBalanceListDocumentDate

    4. CustBalanceListTransactionDate

    Need extensions to the below tables

    1. CustAgingReportTmp

    2. CustTmpAccountSum

    3. CustVendAgingCalculatedTmp

    4. CustVendAgingProcessTmp

    Finally, new Controller and DP classes and new report to call the customized logic from child classes and tables to accomplish the customization.

    I forgot to mention in last reply that, we have already done this in D365 F & O as well based on our original version from AX2012.

    Hope this helps. Thank you.

  • Awaxx Profile Picture
    Awaxx 229 on at

    Hi do you have some explaination and details about what you ve done here ?

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans