Aged Bills Portal

[kiwiora]

Hi guys,

I've created my calc ok to calc the current age of the bill (get(currentdate) - billdate)

What I want to do is have a portal set up for each "age" i.e 0 - 29 days, 30+ (30 - 59), 60+ (60 - 89) and 90+ (90 +)

So i've then created a calc (joinage)

If(Paid = "unpaid";

Case(CurrentDate - InvoiceDate < 30; "0";

CurrentDate - InvoiceDate > 29 and CurrentDate - InvoiceDate < 60; "30";

CurrentDate - InvoiceDate > 59 and CurrentDate - InvoiceDate < 90; "60";

"90");"")

I created several join fields (tried unstored calc, and global):

JoinCurrent = 0

Join30 = 30

Join60 = 60

Join90 = 90

Joined them all up as TO's but I can't get them to display correctly : Am I missing something?

Cheers

[-Queue-]

Joinage must be unstored to update daily. Since it is unstored, it cannot be used as the child key field in a relationship. Instead, you may need to create a script to isolate unpaid invoices when opening the file and set each of them with the appropriate age. In this case, Joinage would be a normal, non-calculated, number field, which can then be used as the child key.

[comment]

Or move the unstored calculations over to the parent side.