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) / How to add new field t...
Microsoft Dynamics AX (Archived)

How to add new field to Customer Aging Report?

(0) ShareShare
ReportReport
Posted on by Rana Anees 1,813

Hii,

I have to add field name PaymTermId from CustTable to CustAgingReport Report. 

I have added this field in CustAgingReportTmp table.

In CustAgingReportDP -> insertCustAgingReportTmp method and insert_recordset custAgingReportTmp I am not getting from where the values are coming.

From where to get PaymTermId value and save in temp table?

Thanks

*This post is locked for comments

I have the same question (0)
  • Rana Anees Profile Picture
    Rana Anees 1,813 on at
    RE: How to add new field to Customer Aging Report?

    any idea...

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: How to add new field to Customer Aging Report?

    Hi Rana Anees,

    What Payment Termin ID do you want to add?

    The payment term can differ for each invoice.

    Do you simply want to add the default payment term that is setup for the customer?

    Adding the payment term from each invoice does not make much sense to me because you would just get a very long list of invoices.

    An average term calculated from all invoice lines might make sense but then things get complicated.

    Best regards,

    Ludwig

  • Rana Anees Profile Picture
    Rana Anees 1,813 on at
    RE: How to add new field to Customer Aging Report?

    Hii Ludwig Reinhard,

    We want to show Payment Term from Customer master means from (CustTable).PaymTermId.

    Please guide from where in the code I can get it and save in tmp table.

    Please see the pic.

    PaymTerm.png

  • Rana Anees Profile Picture
    Rana Anees 1,813 on at
    RE: How to add new field to Customer Aging Report?

    help please...

  • Rana Anees Profile Picture
    Rana Anees 1,813 on at
    RE: How to add new field to Customer Aging Report?

    any idea...

  • Community Member Profile Picture
    Community Member on at
    RE: How to add new field to Customer Aging Report?

    Hello,

    There are 3 temporary tables used in this report : CustAgingReportTmp, CustAgingCalculatedTmp and CustAgingProcessingTmp. 

    To be able to get field data in CustAgingReportTmp you should add this field to CustAgingCalculatedTmp and CustAgingProcessingTmp so open CustBalanceList class and CustVendAging (not sur) .

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,110 on at
    RE: How to add new field to Customer Aging Report?

    Hi Rana Anees,

    Have found any solution for this same requirement I have but here I need to add more 7 fields almost!!

    Best Regards,

    Shabir Ahmad

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
Community Member Profile Picture

Community Member 2

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans