Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

How to add new field to Customer Aging Report?

Posted on by 1,811

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

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,024 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

  • Community Member Profile Picture
    Community Member Microsoft Employee 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) .

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

    any idea...

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

    help please...

  • Rana Anees Profile Picture
    Rana Anees 1,811 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

  • 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,811 on at
    RE: How to add new field to Customer Aging Report?

    any idea...

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans