Create a custom approval rule set
Create a custom approval rule set. Then, add your custom approval rule set to a Purchasing approval policy.
Before you begin
Learn about custom approval rule sets and header-level and line-level approvals.
Available fields
The Field in Custom rule set UI column shows the field names available when configuring approval criteria. These values correspond to internal field names used by the custom approval rules engine.
The Field in transaction UI column shows the corresponding field labels displayed elsewhere in Purchasing.
| Field in Custom rule set UI | Field in transaction UI | Description |
|---|---|---|
| DOCNO | Document number | Apply approval rules based on the document number. For example, route transactions with specific document number patterns to a designated approver. |
| DOCID | Document ID | Apply approval rules based on the document ID. For example, route transactions created from a specific transaction definition to a specialized approval path. |
| SUBTOTAL | Subtotal | Apply approval rules based on the transaction subtotal. For example, apply approval thresholds based on the transaction amount before taxes, fees, or other adjustments. |
| TOTAL | Total | Apply approval rules based on the transaction total For example, route transactions with a transaction total greater than $25,000 to executive approval. |
| TRX_SUBTOTAL | Transaction subtotal | Approve based on transaction subtotal. For example, apply approval thresholds based on the transaction amount before taxes, fees, or other adjustments. |
| TRX_TOTAL | Transaction total | Approve based on transaction total. For example, route transactions with a transaction total greater than $25,000 to executive approval. |
| CREATEDBY | Created by user | Route transactions created by specific users or teams to a designated approver. For example, route transactions created by temporary staff to a manager for review. |
| MODIFIEDBY | Modified by user | Require review when a transaction has been modified by specific users before approval. For example, route transactions modified after initial submission to an additional approver. |
| WHENDUE | Due date | Approve based on when the transaction is due. For example, require expedited approval when payments are due within seven days. |
| STATE | State | Route transactions in a particular processing state for additional review. Apply approval rules based on the transaction state. |
| STATUS | Status | Apply different approval paths based on the status of a transaction. Apply approval rules based on the transaction status. |
| PONUMBER | Reference number | Apply approval rules based on the reference number. Route transactions with a specific reference number prefix to a designated approval group. |
| VENDORDOCNO | Supplier document number | Apply approval rules based on the supplier document number. Route supplier invoices with specific supplier reference numbers for additional review. |
| TERM.NAME | Term | Apply approval rules based on the payment term assigned to the transaction. Route transactions with extended payment terms to Finance for review. |
| MESSAGE | Memo | Apply approval rules based on the message entered on the transaction. Route transactions containing specific business justification text for additional review. |
| SHIPVIA | Shipping method | Approve based on the shipping method. Route overnight or priority shipments to an Operations manager for review. |
| BASECURR | Base currency | Apply approval rules based on the company's base currency. Route transactions entered in a base currency used by a specific entity to a designated approver. |
| CURRENCY | Currency | Approve based on the currency of the transaction. Route transactions in foreign currencies to Finance for review. |
| PROJECT | Project | Approve based on the project of the transaction. Route transactions associated with a specific project to the project manager. Project is available as both a header-level and line-level field. Use the header-level field to evaluate the transaction's overall project and the line-level field to evaluate the project assigned to an individual transaction line. |
| VENDOR.VENDORID | Supplier ID | Route transactions from specific suppliers to designated approvers. |
| VENDOR.NAME | Supplier name | Route approvals based on Supplier name. For example, route transactions from a strategic supplier to a dedicated approval group. |
| VENDOR.PAYMENTPRIORITY | Payment priority | Route approvals based on supplier payment priority. For example, route transactions from suppliers with a payment priority of High to a senior approver. |
| VENDOR.TYPE | Supplier type | Route approvals based on Supplier type. For example, route transactions from suppliers classified as Contractors or Professional Services to specialized approvers. |
| VENDOR.ONETIME | Supplier on hold | Choose to require additional approval when transactions involve suppliers currently marked as On Hold. |
| VENDOR.ONHOLD | One-time supplier | Route transactions for one-time suppliers through an additional approval process. |
| VENDOR.PAYMETHODKEY | Preferred payment method | Route approvals based on the preferred payment method of the supplier. For example, route transactions paid by wire transfer to Treasury for review before payment. |
The Field in Custom rule set UI column shows the field names available when configuring approval criteria. These values correspond to internal field names used by the custom approval rules engine.
The Field in transaction UI column shows the corresponding field labels displayed elsewhere in Purchasing.
The fields in this section are available only to companies enabled for the Purchasing line-level approvals Early Adopter program.
| Field in Custom rule set UI | Field in transaction UI | Description |
|---|---|---|
| ITEMID | Item | Route transactions based on item of the line item. For example, route purchases of laptops, servers, or software subscriptions to the IT department. |
| ITEMDESC | Item description | Route transactions based on the item description. For example, route purchases containing specific keywords or descriptions to specialized approvers. |
| MEMO | Memo | Route transactions containing specific notes or business justification text for additional review. |
| UNIT | Price | Apply approval rules based on the unit of measure assigned to the line item. For example, route purchases measured in a specific unit of measure to a designated approver. |
| UNITQTY | Unit quantity | Apply approval rules based on the unit quantity assigned to the line item. For example, route purchases measured in a specific unit quantity to a designated approver. |
| TOTAL | Transaction total | Apply approval rules based on the extended price of the line item. Require approval when the total value of a line item exceeds a specified threshold. |
| TRX_PRICE | Price | Apply approval rules based on the unit price of the line item. For example, require approval when the unit price exceeds a defined amount, such as $1,000. |
| TRX_VALUE | Extended price | Apply approval rules based on the extended price in the transaction currency. Require approval when a line item's value exceeds a defined threshold in the transaction currency. |
| CREATEDBY | Created by | Apply approval rules based on the user who created the transaction line. Route lines created by specific users or teams to a designated approver. |
| MODIFIEDBY | Modified by | Apply approval rules based on the user who last modified the transaction line. Require review when a transaction line has been modified after initial submission. |
| WAREHOUSE.LOCATION_NO | Warehouse | Approve based on warehouse of the line item. For example, route lines associated with Warehouse D to the warehouse manager. |
| DEPARTMENTID | Department | Approve based on department of the line item. For example, route lines assigned to the IT department to the IT director. |
| TASKID | Task | Approve based on the task. Require approval from the task lead when purchases are assigned to a specific project task. |
| BILLABLE | Billable | Apply approval rules based on whether the transaction line is billable. Route billable expenses to project accounting before approval. |
| FORM1099 | Form 1099 | Apply approval rules based on Form 1099 reporting requirements. Route transactions subject to Form 1099 reporting to Finance for review. |
| FORM1099TYPE | Form 1099 type | Apply approval rules based on the Form 1099 type assigned to the line item. Route transactions mapped to specific 1099 reporting types for additional review. |
| FORM1099BOX | Form 1099 box | Apply approval rules based on the Form 1099 box assigned to the line item. Route transactions mapped to specific 1099 reporting boxes for additional review. |
| CUSTOMERID | Customer | Apply based on the customer of the line item. Require review for purchases associated with strategic or high-value customers. |
| VENDORID | Supplier | Approve based on the supplier of the line item. For example, route purchases from specific suppliers to specialized approvers. |
| EMPLOYEEID | Employee | Apply based on the employee. Route employee-related purchasing requests to the employee's manager. |
| CLASSID | Class | Apply based on the task. Apply different approval paths for capital expenditures versus operating expenses. |
| ITEM.GLGROUP | Item group | Approve based on item group of the line item. For example, route capital equipment purchases to Operations for review. |
| LOCATIONID | Location | Approve based on location of the line item. Route purchases associated with a specific office or business location to a local manager. |
Create a custom approval rule set
| Subscription | Purchasing |
|---|---|
| User type | Business user with admin privileges |
Go to Company > Setup > Custom approval rule sets.
Select the Object to approve.
Currently, the option available is Purchasing document.
Select the Transaction definition for which you want to create the rule set.
You can select from the following transaction definitions:
Purchase Order
Purchase Requisition
Purchasing Debit Memo
Supplier Invoice
Select the User or User group to approve the transaction definition.
Select the following options in the Process section:
Select the Condition type.
If you select Expression, enter the Condition.
There is a 50-character limit for conditional expressions.
The expression cannot have any spaces in between values. Use "&" for AND and use " | " (the pipe symbol) for OR. For example: (1&2&3)(4&5&6)|(7&8&9)
Set up approval routing and limits.
Select the Field.
Select the Operator.
Select the Value.
Select Save.
