In Focus Resource Center > Insights

How to Customize Aging Reports with Buckets in Dynamics GP

By Citrin Cooperman Digital Services Practice .

In Microsoft Dynamics Great Plains (GP), users are given four aging buckets in Receivables Management by default. However, users are able to increase the number of buckets to as many as seven. The screenshot below shows two added aging buckets for a total of six. When adding buckets, it is important that the days from and days to on each bucket flow from one to another with no gaps. If there are any gaps, then some invoices or payments may not appear on aging reports.


Once aging buckets have been added, they will automatically update available columns in SmartList and appear in queries, if selected.


To get transactions to display accurately in the correct bucket, the aging routine must be run.


However, even when the aging routine is run, the Aged Trial Balances will not display the modified aging buckets.

Getting custom aging buckets to display on Dynamics GP aging reports

The aging trial balances (summary and detail) must be manually modified in Graphical Report Writer (GRW). It is strongly recommended that users do not attempt to modify reports in GRW themselves. It is a technical process and can easily go awry. This could invalidate the report, leaving the user with no trial balances at all.

Even though users have added two buckets to the Accounts Receivable setup, note that they do not appear on the Aged Trial Balance below as the report has not been modified yet.


Note that in the second Aging Trial Balance posted below, the new aging buckets appear as this report has been modified.


Although this process focused on receivables, buckets can be added to payables setup as well. In this case, users will also need to modify the Accounts Payable Aged Trial Balances accordingly.

How Citrin Cooperman can help

Citrin Cooperman’s Digital Services Practice is skilled in helping businesses develop more efficient processes to reach their strategic goals. To learn more about adding aging buckets to your receivables or payables setup and how our team can help you modify the Aging Trial Balances, reach out to your Citrin Cooperman advisor at

Our specialists are here to help.

Get in touch with a specialist in your industry today. 

* Required

* I understand and agree to Citrin Cooperman’s Privacy Notice, which governs how Citrin Cooperman collects, uses, and shares my personal information. This includes my right to unsubscribe from marketing emails and further manage my Privacy Choices at any time. If you are a California Resident, please refer to our California Notice at Collection. If you have questions regarding our use of your personal data/information, please send an e-mail to