Jump to content

Calculating Days aged on Invoices


This topic is 6562 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi Edward,

You only need your InvoiceDate field and a calculation (number). To produce just the total numbers of days past due, it would be:

Status(CurrentDate) - InvoiceDate

But you might also want to account for the Invoice still having an outstanding amount; whether a payment field is empty? Or whether InvoiceAmount - PaymentAmount > 0?

You may also wish to group them for Aging purposes to display those overdue 30-59 days, 60-89 days, 90-119 days and 120+ days. This can all be accomplished within this one calculation if you wish. smile.gif

If you want to take the thinking further than number of days old, let us know and we can provide the calculations. smile.gif

LaRetta

Link to comment
Share on other sites

This topic is 6562 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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