Aging Invoices

[#1]

I am trying to age an open invoice file using incremnts of 30, 60, 90, and 120+. What's the best way to go about creating the buckets for this? I've attached my QV doc as well as the source docs that the data comes from. The Age chart I have is in the Main tab. Thanks in advanced for any help you can provide.

[#2]

Hi there,

Do you mind rephrasing/elaborating a little more on the requirement. Maybe some examples of whats the result you are looking for would be helpful as well in solving this.

Thanks

[#3]

So I have a bunch of records with various invoice dates and I'm trying to seperate those dates by how long they've been outstanding. So i need to count the number records that fall between 0-30 days outstanding, 30-60 days, etc from a cutoff date.  Let me know if you need more information.

[#4]

How do you determine the outstanding bracket. Lets say

Invoice # 1234 has invoice date 3/23/2013. How do you determine which bracket it falls into?

[#5]

How many days have expired from the cutoff date. Say the cutoff date is 3/31/2013, your invoice would fall under the <30 days bracket becuase only 8 days would have passed.

[#6]

So the cutoff date is something the user enters?

[#7]

Yes

[#8]

If above is the case then the attached will help you. I created an input box where you can enter the cutoff date and the bar chart below that will change accordingly.

Thanks

[#9 · Accepted solution]

Updated. There was a bug in my previous attachment. Please use this one.

Thanks

[#10]

Exactly what I was looking for. Thank you very much.