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

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) / 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

    any idea...

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

    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

    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

    help please...

  • Rana Anees Profile Picture
    Rana Anees 1,813 on at

    any idea...

  • Community Member Profile Picture
    Community Member on at

    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

    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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Sagar Suman Profile Picture

Sagar Suman 2 Super User 2026 Season 1

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans