Aging charges on billing

[angelo]

How can I calculate and show the age of charges on billing statements? I. e., the amount due that is less than 30 days old, over 30 days but less than 60 days, 60 to 90 day, and over 90 days.

------------------

angelo

[mrpc]

check your templates

most versions have templates with aging scripts.

if you can't find any I can email you the script steps

------------------

[Chuck]

quote:

---

Originally posted by angelo:

How can I calculate and show the age of charges on billing statements? I. e., the amount due that is less than 30 days old, over 30 days but less than 60 days, 60 to 90 day, and over 90 days.

---

It sounds like you want a three flag fields that are either true or false.

Create a calculation field and set it to have a number result. For the 30 day field, set it to:

Case( Status( CurrentDate ) - InvoiceDate > 30, 1, 0 )

And just create two other similar calculations for the 60 days and 90 days cases.

Create a value list with a single value of 1. Place the three fields on your layout, and use the field format to format them as check-boxes tied to the value list. Resize the fields on the layout so that the "1" of the value list doesn't show up, but the check boxes do.

Chuck