I am working to customize the AP Aging Report, and need the aging buckets to be:
30, 60, 90 and 120+, in the payables setup how do I accomplish this.
*This post is locked for comments
All due respect Scott, maybe you shouldn't be working on this report after all. The issue I see here is training related. The Aging report looks at the, well, age of the document to establish in what bucket it falls. The buckets are not dead set numbers, but rather ranges 0-30, 31-60, 61-90, etc., or whatever you want them to be, but you can only specify the upper part of the range.
Are you saying you want one bucket just for invoices that are exactly 30 days old? And another bucket for invoices that are exactly 60 days old? What happens to invoices that 31 - 59 days old?
I have no issue with the lables its the aging buckets I need to change where one column would be for the 30 day, the next for the 60 days, and 90 and 120+
[quote user="Scott Rusoff"]
thanks for the info, my concern is with not the setup but the aging range.
for example in the 30 day column, they do not want 1-30, just 30 days same with 60 days not 31-60, just 60.
[/quote]I think you are confused with the labels. These can be change to whatever you want as they are only part of the cosmetics. If you want one of your labels to say "30", instead of "1-30" you can change these at will. In fact, if you want to call these "Good", "Not So Good", "Not So bad", and "Bad" you can do that too as long as the corresponding number you put to each aging bucket represent your understanding of those terms.
thanks for the info, my concern is with not the setup but the aging range.
for example in the 30 day column, they do not want 1-30, just 30 days same with 60 days not 31-60, just 60.
Part 1 - Setup and Cards, Chapter 1 - Payables Management Setup, Section: Aging Periods, page 13 of the Payables Management manual outlines the steps necessary to accomplish this.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156