Skip to content

Record rules

A record rule (set Watch to Each Record) goes through every record of a table and asks the same question of each one: does this record break the rule? Recipients get one email listing the records that newly break it.

Setting What it does
Record Table The table to check, for example 18 Customer or 36 Sales Header.
Record Filter Which records to check, in the same syntax as measure filters, for example Document Type=Order;Status=Released;Shipment Date=..{TODAY-1D}. Leave it blank to check all records. Date tokens work; user and {Rec.…} tokens don’t, because rules run in the background for everyone. Show Record Table Fields lists the field names.
Alerts When Matches the Record Filter: every record the filter finds breaks the rule. Measure meets the condition: a Per Record measure is calculated for each record and compared.
Measure For Measure meets the condition: a Per Record measure with the same Record Table.
Condition, Compare With is above, is below, equals and so on. Compare with a Fixed Value or with a Field on the Record, such as Credit Limit (LCY).
Repeat Every (Minutes) 0 lists each record once, until it stops breaking the rule. Otherwise, records that keep breaking it are listed again after this many minutes.
Alert Again When Field Changes Optional. A number field on the record; a record already reported is listed again when this field changes. See below.
Link To Page The page the email’s links open, for example 42 Sales Order on a rule for sales orders. Leave it blank to use the table’s own card or list page.
Rule Record Table Record Filter Alerts When
Late shipments Sales Header Document Type=Order;Status=Released;Shipment Date=..{TODAY-1D} Matches the Record Filter
Over credit limit Customer Credit Limit (LCY)=>0 Measure (the customer’s balance) is above the field Credit Limit (LCY)
Low stock Item Type=Inventory;Blocked=false Measure (the item’s inventory) is below the field Reorder Point

A Per Record measure for the credit limit example: Source Table Cust. Ledger Entry, Record Table Customer, Sum of Remaining Amt. (LCY), filter Customer No.={Rec."No."};Open=true.

Some records stay broken but get worse. Set Alert Again When Field Changes to list them again when a number moves, for example:

  • Balance (LCY) on a rule for customers over their credit limit;
  • Inventory on a rule for items below their reorder point.
Setting What it does
Direction Goes Up (the default), Goes Down, or Goes Up or Down
By At Least How far the field must move before a fresh alert, for example 5,000. Blank means any amount.

The email shows the change, for example (Balance (LCY) up from 52,000 to 58,500).

  • Changes are measured from the value at the last alert, not the last check, so small changes add up.
  • For Goes Up, if the value falls first, the rise is measured from the lowest point (and the other way round for Goes Down).
  • When you first set the field, the current values are only recorded, so nothing is sent until a value actually changes.
  • Each check, recipients get one email listing the records that newly break the rule: up to 100 in the email, each linking to its card. The Alert Log keeps the full list. If nothing is new, no email is sent.
  • A record that stops breaking the rule, or is deleted, is forgotten, so it’s reported again if it breaks the rule later.
  • The first check after enabling reports every record that already breaks the rule. Use Show Matching Records first to see how many that will be.
  • Everyone on Recipients gets the whole list.
  • Every rule runs independently, so one rule needing attention never holds up the others. Its status is shown on the rule card under Last Check.
  • The job runs as the user who started it, using their access to the Record Table.
  • Measure meets the condition works the measure out for each record. Use the Record Filter to focus on the records that matter, for example only customers with a balance, and rules stay quick on even the largest tables.
Action What it does
Show Matching Records Lists the records that break the rule right now. Changes nothing and sends nothing.
Send Test Email to Me Emails you the full list of records that break it now.
Check Now Checks the rule straight away and sends any alert.
Record Alert States The records already reported that still break the rule.
Last Check group Records Breaking, Last Checked and Last Error.

In the Alert Log, choose the value (the number of records) or Show Records to see which records an alert listed.