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 / Microsoft Dynamics AX (Archived) / Aging Report - queries
Microsoft Dynamics AX (Archived)

Aging Report - queries

(0) ShareShare
ReportReport
Posted on by Vaibhav S 240

Hello Experts

Is there an option or way to generate the AP/AR aging (Aging report) with the original invoice amount included?

Currently we have Invoice Number and balance outstanding against it in buckets.  However if we would like to see the original invoice amount then that will help.

Any suggestions

TIA

Vai

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Satish Panwar Profile Picture
    Satish Panwar 14,673 Moderator on at

    Hi Vaibhav,

    Original invoice amount is not available in standard AR/AP aging report. The aging reports are meant for open balances only. If you need it on occasional basis, you can search customer / vendor transactions.

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

    Hello Vai,

    An alternative to this report might be the standard cubes for AX2012 that also allow you designing and modifying an aging analysis in excel. Have you checked whether you can include the original invoice amount if you create the report from there? It should be much easier to modify the data needed there.

    Another alternative is the collections form in AR. This form allows you viewing your open transactions in the form of a list page that can be personalized. I haven't checked whether the original invoice amount is available there and would like to ask you to check this.

    A means of last resort is always a report modification but this is expensive and requires the help of a developer.

    Best regards

    Ludwig

  • Vaibhav S Profile Picture
    Vaibhav S 240 on at

    Thanks Ludwig

    I will check on collection form and I will update.

    Thanks for help

  • Vaibhav S Profile Picture
    Vaibhav S 240 on at

    Hi Satish

    Thanks for your answer.  I thought so that in general OOB report these columns can not be included by Configuration or setup changes.

    Thanks again

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Sanhthosh.Kumar.K Profile Picture

Sanhthosh.Kumar.K 2

#2
Raed Salah Bzour Profile Picture

Raed Salah Bzour 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans