Past Due

[hcmbrbj]

I've got the following calculation, but need to add to it in order to show "Yes" if a payment is less than the calculated Payment Amount and show nothing if the different is made up later or an over payment was made previously. i.e. Pledged 1200 to be paid monthly, made a 200 payment in Jan. but skipped Feb. and paid in Mar. In this scenario the account wouldn't be flagged Past Due. The way the calculation is now the pledge is past due simply because a payment wasn't made in Feb. Should I be tying the calculation to Total Paid in reference to the date or add to what I've got? Either way, please help.

If (

pmOneDate and Get ( CurrentDate ) > pmOneDate and not Amount1

or

pmTwoDate and Get ( CurrentDate ) > pmTwoDate and not Amount2

or

etc. through pmTwelveDate and Amount12

[Zcast]

Well, common sense dictates that the account should be past due in March if a payment wasn't made in Feb....but as for your question, wouldn't it just be simpler to reset the "Past Due" account back to good standing if the "amount due" is equal or less than 0? So, if they missed a payment in feb, the account is "past due", but set a script to see if the amount in March is less than or equal to zero, obviously showing that the account is in good standing once again, if true? Or am I going about this the wrong way?

[comment]

I'd do it this way:

BalanceToDate.fp7.zip

[hcmbrbj]

Thanks. I was trying to make it way more complicated than necessary. Thanks for the simplification.

[Zcast]

another helpful file from comment....for all of us. Thanks.