2 Replies Latest reply: May 15, 2014 10:01 AM by perezmanuel _ RSS

    Aging Reports

    perezmanuel _

      Good morning:

       

      I'm new to the forums and have been working with Monarch for a while. I am trying to create an aging report from a PDF and I'm having problems creating the different aging periods (31-60; 61-90; etc). I'm using the IF function to create the date ranges, but it only lets me do the upper range of the aging period.

       

      Any insight would be greatly appreciated!

       

      Thanks,

       

      Manny

        • Aging Reports
          Data Kruncher

          Hi Manny, and welcome to the forum.

           

          There are probably a few ways to handle this; here's one.

           

          First, you need an "as of" date to determine how old your invoices are. You may be able to capture this from the report itself, or you might want to use a runtime parameter calculated field.

           

          Next, build a numeric DaysOld field, with this expression:

          AsOfDate-InvoiceDate[/CODE]

           

          The expression for your Current amount would be:

          If(DaysOld<31,[InvoiceAmount],0)[/CODE]

           

          The 31-60 field would be:

          [SIZE=2]if(DaysOld>30 .and. DaysOld<61,[InvoiceAmount],0)[/SIZE][/CODE]

           

          Other aging buckets would be the same, until your last one. If it's 360 days +, then the formula would be:

          if(DaysOld>=360,[InvoiceAmount],0)[/CODE]

           

          Does that get the result you want?

           

          Kruncher