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.
Settings
Section titled “Settings”| 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. |
Examples
Section titled “Examples”| 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.
Alert again when a field changes
Section titled “Alert again when a field changes”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.
How record rules behave
Section titled “How record rules behave”- 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.
Useful actions
Section titled “Useful actions”| 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.