Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Adding aging buckets t...
Microsoft Dynamics GP (Archived)

Adding aging buckets to the RM Summary Historical Aged Trial Balance report

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I'm sure this is a rookie question, but my objective is to add 3 more aging buckets to the AR reporting we prepare. I've followed the instructions provided by Microsoft (https://support.microsoft.com/en-us/kb/857284), however this does not seem to change the report I run:

GP-Report.PNG 

When editing the reports, is "RM Summary Historical Aged Trial Balance" the correct one to change the report I've included in the screenshot above? Or is there something else I am missing?

Many thanks in advance!

*This post is locked for comments

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Adding aging buckets to the RM Summary Historical Aged Trial Balance report

    Hi Tom,

    If you are trying to modify the RM Summary Historical Aged Trial Balance, then you need to use the existing calculated fields named Current Trx Amount. It's an array field and a field exists for each possible aging bucket. The Display Type should be Sum. This field goes in both the Customer Footer (F1) and the Report Footer. Since it is the Historical report, you will not have to run the aging routine as the system goes back and 'ages' it according to the 'as of' date you want to print. The system uses the apply date from sales to determine the balance of a particular transaction at that point in time.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Adding aging buckets to the RM Summary Historical Aged Trial Balance report

    I ran the aging, and checked that the diplay types in buckets was set to sum, however the report still shows zeros. If I switch the report back to the "detailed" view, it shows the totals correctly.

    thank you for your help so far.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Adding aging buckets to the RM Summary Historical Aged Trial Balance report

    Have you aged your accounts so the buckets get filled with data?

    Tools->Routines->Sales->Aging

  • Peter Muchira Profile Picture
    Peter Muchira 1,910 on at
    RE: Adding aging buckets to the RM Summary Historical Aged Trial Balance report

    Hi TomW,

    In ReportWriter, confirm the 'Display Type' of the buckets' 'data fields'. If they are the report footer, then the display type should be set to 'sum'.

    Aging-Bucket.PNG

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Adding aging buckets to the RM Summary Historical Aged Trial Balance report

    I had not done that, so thank you.

    I found the issue was because I was running the "Detailed" report, it was using a different template (i.e. not the "RM Summary Historical Aged Trial Balance"). Now I've unchecked the "Detail" box, I can see the additional buckets, however all the buckets (total included) are zero. Any idea?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Adding aging buckets to the RM Summary Historical Aged Trial Balance report

    Did you go to Tools->Setup->System->Alternate Forms and Reports and select to use the modified version of this report?

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans