Workflow Rules: Conditions (How) setup

View

The fields you can use depend on the record type you want to approve. In the Sage 300 world, the record type is linked to a view.

Batches: You can use fields from the Batch, the First Entry in the batch, the first detail in the first entry, or the batch optional fields.

Transaction Headers (such as O/E Orders, P/O Purchase Orders, I/C Transactions): You can use fields from the Header, the first detail or the Header optional fields.

Flat records (such as A/R Customers, A/P Vendors): You can use any fields from the Entry or any optional fields attached to the record.

All

Use the All option for the view if you want to approve all records.

If All is included in the first rule (the rule with the lowest Evaluation order), then all records will follow the rule.

If All is not the first rule, All will mean all remaining records (all the records that don't meet the conditions in the prior rules).

Optional fields

You can use optional fields associated with the record you want to approve as a condition.

  • Use the Finder (or F5) to select an Optional Field added on Workflow View defaults.

  • F6 shows all the optional fields for the application, (in my case AR). You need to select an optional field configured for the right location.

Tips:

You can add the optional fields you want to use in Workflow View Defaults to simplify the data entry.

Workflow View Defaults

Use Cases

Example:

If you have an optional field called UPSZONE configured for A/R Customers in A/R Setup, you can have different rules and approvers based on the value of the UPSZONE optional field.

Compare operation

You can compare a field value to values configured in the rule.

Equal, Not Equal, Greater Than and Less Than requires one value

Between requires two values.

Depending on the comparison, one or two fields are enabled (value and value2).

In / Not In

Use a comma separated list of values.

Example:

If field is ENTEREDBY, the list could be UserA, UserB, UserC

If the user is in the list, set certain approvers.

If the user is not in the list, set other approvers

In Opt Table / Not in Opt Table

You can use a list of valid values configured in an optional table in Common Services.

This is useful for a long list, such as a list of countries, and when you want to use the list in Sage 300 optional fields as well.

Example:

If the value is one of the values in the optional table, set certain approvers.

If the value is not in the optional table, set other approvers.

This is demonstrated in the Purchase Order Approval example.

In AC Chat Sec Group/ Not in AC Chat Sec Group

You can use a list of valid values configured in A/C Chat > Users > Security Group.

This is only available if A/C Chat is activated in the database.

This condition requires two values: the AC Chat Group Name and the Group Type (2 for customer, 3 Vendor, 4 for Item, 5 for Location, 6 for Users).