Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Calculate charges

Bikeman17
in Calculation Engine (Define Fields)

Featured Replies

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

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).

  • Author

Hi,

I tested the Charge Due field and the result is

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

Create an account or sign in to comment

https://fmforums.com/topic/31716-calculate-charges/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.