Aging? Dates...Help???? 1

[JCook23]

CR 10.0
SqlServer

Hello All,

I am trying to create a type of aging report for A/R. I need six formulas that will all be the same with the exception of the days. It needs to be like this:

if {armast.fcinvoice} is 1 to 30 days old then {armast.fnamount} else 0

The report will look like this:

Invoice # Date Current 1-30 31-45 46-60 61-90

12345678 9/9/2004 0 2500 0 0 0


What is the proper wording for this formula? I saw the Aged0To30Days in the Date Ranges in the formula workshop but did not know how to use this. Also, I need the ranges as stated above.

Thanks for any help,

Jeff C.

 

[bdreed35]

Place these in your detail section and then create summaries off of the formulas. You can then suppress the detail section.

//1-30 days
if {armast.fcinvoice} in Aged0To30Days then
{armast.fnamount}
else
0

//31-45
if {armast.fcinvoice} in minimum(Aged31To60Days) to minimum(Aged31To60Days)+14 then
{armast.fnamount}
else
0

//46-60
if {armast.fcinvoice} in maximum(Aged31To60Days)-14 to maximum(Aged31To60Days) then
{armast.fnamount}
else
0

//61-90
if {armast.fcinvoice} in Aged61To90Days then
{armast.fnamount}
else
0

~Brian

 

[JCook23]

Brian,

Thanks for the help. However, when I put the first formula (1-30) it highlights Aged0To30Days and says a string is required here. Which string would I use?

Jeff

 

[bdreed35]

I guess {armast.fcinvoice} is not a date field then. What data is stroed in this field? We want to compare teh invoice date in these formulas.

~Brian

 

[JCook23]

Brian,

Would you like to polish the bullet before I shoot myself? I had the wrong field. It was f.invdate instead.

Works perfectly now!! Thanks a ton!

Jeff