30, 60, 90 day outstanding invoices

[Cynron]

I'm trying to convince my boss to switch over to a FM7 billing/invoice system of my creation, but I can't figure out how to age outstanding invoices. I've gotten as far as converting the creation date into a number which I thought I could use to calculate vs. a current date. Now I see when the year turns it goes back to 1. Please help...

[Ender]

Welcome Cynron,

I would stick with date fields, calculating the parent key by Get(CurrentDate) - 30, 60, or 90. The relationship would look something like:

Interface <=> Invoice

Interface::ParentKey_DateLess30 >= Invoice::Date

AND Interface::ParentKey_DateLess60 < Invoice::Date

AND Interface::gStatusOpen = Invoice::Status

Where gStatusOpen is a global with text "Open" (or whatever you use to indicate an unpaid invoice.)

[Cynron]

Thank you! I don't exactly understand everything youv'e written (I'm kinda new to this) but I get the gist. I appreciate the help. Thanks again.