System Administration: Support for Formulas in Triggering Conditions
System Administration: Support for Formulas in Triggering Conditions
System Administration: Support for Formulas in Triggering Conditions
MYOB Acumatica 2024.1.1 introduces support for formulas in the trigger conditions for business events. Now when a system administrator is defining a business event of any type on the Business Events (SM302050) form, the administrator can specify a formula in a trigger condition.
Use of Formulas in Conditions
Formulas give the administrator the ability to use advanced calculations and data transformation functions if some values are calculated or depend on data from other sources.
In certain scenarios, the administrator might want the system to compare the values of different boxes in order to decide whether it should trigger a business event. These usage scenarios include the following:
- The owner of a record is not the same as the creator of the record.
- The last activity related to a case whose priority is High took place more than eight hours ago.
In previous versions of MYOB Acumatica, the administrator had to create a generic inquiry to retrieve this data, which could be time consuming.
In MYOB Acumatica 2024.1.1, the administrator can use the Formula Editor and enter formulas in the Value 1, Value 2, and Field Name columns on the Trigger Conditions tab of the Business Events (SM302050) form. The following screenshot show the Formula Editor (Item 1) for the Value 1 column (Item 2).
Figure 1. Formula Editor for a triggering condition
Tip: The Formula Editor is available in the Value 1 and Value 2 columns if the From Schema check box is cleared for the row.
The process of specifying formulas in triggering conditions is the same as the process of using formulas on other forms that contain the Formula Editor. For details on the Formula Editor, see Formulas in Inquiry Results: General Information and FormulasThe Use of Formulas.
Important: For business events of the Triggered by Record Change type, the system does not add to the Fields to Track tab the fields that the administrator has used in the formulas. If these fields should be tracked, the administrator must add them to this tab manually.