Calculate charges

[Bikeman17]

Hi there,

I got an Accounts Receivable file that holds invoices that have outstanding balances. I got two buttons that generate statements. One for the last 30 days and the second one for the last 60 days. They will gather invoices by customer. When an invoice is passed due for 60 days, a 4% charge applies (calculation field).

When clicking the second button to produce a statement for a 60 day period, some invoices may be due for the past 30 days only. So, no charge should apply to those one but it is not the case the way I did it. See how I tried to overcome that problem.

Here

[comment]

Try:

ChargeDue (calculation, number) =

Date < Date ( Month (Status (CurrentDate)) -1, 1, Year (Status (CurrentDate)))

Charge (calculation, number) =

InvoiceAmount * 0.04 * ChargeDue

Total (calculation, number) =

InvoiceAmount + Charge

For convenience, you can format ChargeDue to display as YES/NO on the layout (Format -> Number .. -> Format as Boolean).

[Bikeman17]

Hi,

I tested the Charge Due field and the result is

[comment]

Check your input - ChargeDue is a comparison, therefore cannot be blank, unless Date is empty and Do not evaluate if ... is checked.