Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Invoice (receivable) Aging

Featured Replies

I was just putting together my A/R report when it occured to me that it would be really handy to have receivables grouped by the age (30 days from now, 60 days, 90 days, 180 days, 1 year, etc.)

The only way I can think of is to have a calculation field on the receivable like this:

Case(Status(CurrentDate) - receivableDate < 30, 1, Status(CurrentDate) - receivableDate < 60, 2, Status(CurrentDate) - receivableDate < 90, 3... etc.

Then group and subsummarize by that field in the report.

Is that the best way? Would this be slow if there were a lot of records because Status(CurrentDate) would have to recalculate for each record?

Also, would I be correct in assuming this should be an unstored calculation, so that the age will recalculate every day?

You're basically correct

The alternative to an unstored fields is to run a script at startup re-calculating the field ... this might be useful if you know you're never interested in invoices older than say 2-3 months so that you might restrict the number of records to be processed

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.