Setting up Approvals

Overview

Approvals or checklists systematically check that certain fields and information are correctly completed on a transaction before it advances to the next step.

Approval checklists can be created for each of these transaction types:

  • When a module has checklist items, every new transaction of that module gets the checklist when it is created.
  • The Limit items are added when they apply to the transaction's total.
  • Changes to the setup reach an existing transaction when its checklist is reset or approved.
  • If all the items of a module are deleted, its transactions no longer use a checklist.
Navigation

Main Menu > Setup > Settings & Defaults > Approvals (tab)

Approval Item Fields

Info

Fields marked in green (✎) can be edited.

Field Description
IDThe system-generated number allocated to the entry.
DescriptionA description of the approval (e.g. Rep is selected).
CodeUsed in the condensed views – max 20 characters. An abbreviation of the description.
TypeThe available options depend on the selected Module (see below). These types are common to all the modules:
  • Manual: The item must be manually checked.
  • Auto - SQL:
    • This type uses SQL to test if the item's conditions are met.
    • The SQL must always return two fields – VALUEID (Integer: 0=False, 1=True) and NOTE (string).
    • If a note is not required, you can pass a NULL value to the note field.
    • A parameter TRANSID can be used in the SQL to reference the transaction values.
  • Auto - SQL (Override):
    • This type works the same as Auto except that approved users can override these items when the SQL does not approve them.
    • Approved users are also allowed to cancel the overrides.
  • Limit:
    • This type is similar to a Manual checklist item except that the approval is linked to the Transaction Total.
    • Multiple limit items can be added in ascending order.
    • The required approvals are added based on the transaction's VAT exclusive total and the entered limits.
Limit fromThe transaction total that triggers the approval.
Limit toThe upper limit of the transaction total for which approval is needed.
UpdatedThe user who last updated the entry and the date and time of the update.
Menu (...)A submenu that can also be accessed by right-clicking an entry with the following functions:
  • Set Dependencies: Specifies which items must first be checked before the current item can be approved. Applicable to Manual and Limit.
  • Set Users: Specifies which users can approve the item. Applicable to Manual, Override and Limit.
  • Edit SQL: Opens an interface to edit the SQL.
  • Copy
  • Delete
  • Move Up
  • Move Down

Transaction Status

Navigation

Main Menu > Setup > Settings & Defaults > Status (tab)

If a Transaction Type must be approved, the following defaults must be selected in the Approvals column for each applicable status:

Status Description
ApprovalThe Status that starts the approval process (e.g. Pending with Editing unchecked).
ApprovedThe transaction is changed to this Status (e.g. Active or Complete) once the checklist is Approved.
DeclinedThe transaction is changed to this Status (e.g. Pending) if one or more checklist items are Declined.
  • Each transaction type has its own statuses, so each type can use different approval statuses.
  • Within one type, only one status can be the Approval status, one the Approved status and one the Declined status.
  • When you select one of these defaults for a status, it is cleared from the other status that had it.
  • The same statuses apply whoever approves the transaction.

For example:

  • Quotation statuses: Pending, Approval, Approved, Sent, Accepted, Template and several Lost statuses. The Quotation uses its own Approval and Approved statuses, and Pending as the Declined status, so a declined Quotation goes back to Pending.
  • Purchase Order statuses: Pending, Approved, On Order, Received, Invoiced and Cancelled. There is no separate approval status, so Pending is the Approval status and Approved follows it.

Approval Levels

A transaction can need several approvals, one after the other or by amount:

  • Dependencies: a Manual or Limit item waits (red) until the items it depends on are approved. Use Set Dependencies to set the order, for example, the manager first and then the director.
  • Limits: add several Limit items, each with its own Limit from, Limit to and users. When the transaction is saved, each Limit item with a range that includes the transaction's VAT exclusive total is added, and the ones that no longer apply are removed. For example, a manager approves Purchase Orders up to 50,000, and a director approves those above it.
  • Users: use Set Users to choose who may approve each item.

Checklist Types by Module

Quotations

Field Description
Auto - Contact is blankEnsures you select a Contact on the Quotation.
Auto - Rep is blankEnsures you select a rep on the Quotation.
Auto - Category is blankEnsures you select a category on the Quotation.
Auto - Branch is blankEnsures you select a branch on the Quotation.
Auto - Account is blankEnsures you select an Account on the Quotation.
Auto - SQLCustom checklist created with SQL.
Auto - SQL (Override)Custom checklist created with SQL including an Override for specified users.
LimitAdd Limits for values (e.g. Approval is required for Quotations with a value of R50 000+).
ManualManual approval for specified users.

Sales Orders

Field Description
Auto - Customer is blankEnsures you select a customer on the Sales Order.
Auto - Contact is blankEnsures you select a Contact on the Sales Order.
Auto - Rep is blankEnsures you select a rep on the Sales Order.
Auto - Category is blankEnsures you select a category on the Sales Order.
Auto - Order No is blankEnsures you enter an Order No. on the Sales Order.
Auto - Duplicate Order NoWarns a user if a duplicate Order No. is found. This warning avoids duplicate Sales Orders created in error.
Auto - Due Date is blankEnsures you enter a Due Date on the Sales Order.
Auto - Branch is blankEnsures you select a branch on the Sales Order.
Auto - Account is blankEnsures you select an Account on the Sales Order.
Auto - SQLCustom checklist created with SQL.
Auto - SQL (Override)Custom checklist created with SQL including an Override for specified users.
LimitAdd Limits for values.
ManualManual approval for specified users.

Work Orders

Field Description
Auto - SQLCustom checklist created with SQL.
Auto - SQL (Override)Custom checklist created with SQL including an Override for specified users.
Auto - Branch is blankEnsures you select a branch on the Work Order.
ManualManual approval for specified users.

Purchase Orders

Field Description
Auto - Contact is blankEnsures you select a Contact on the Purchase Order.
Auto - Due Date is blankEnsures you enter a Due Date on the Purchase Order.
Auto - Supplier is blankEnsures you select a supplier on the Purchase Order.
Auto - Branch is blankEnsures you select a branch on the Purchase Order.
Auto - Account is blankEnsures you select an Account on the Purchase Order.
Auto - SQLCustom checklist created with SQL.
Auto - SQL (Override)Custom checklist created with SQL including an Override for specified users.
LimitAdd Limits for values (e.g. Supervisor approval is required for Purchase Orders with a value between R0–R10,000, and management approval is required for Purchase Orders with a value above R10 000).
ManualManual approval for specified users.

Supplier Invoices

Field Description
Auto - Supplier is blankEnsures you select a supplier on the Supplier Invoice.
Auto - Due Date is blankEnsures you enter a Due Date on the Supplier Invoice.
Auto - Duplicate Invoice NoWarns a user if a duplicate Supplier Invoice No. is found. This warning avoids duplicate Supplier Invoices created in error.
Auto - Branch is blankEnsures you select a branch on the Supplier Invoice.
Auto - Account is blankEnsures you select an Account on the Supplier Invoice.
Auto - SQLCustom checklist created with SQL.
Auto - SQL (Override)Custom checklist created with SQL including an Override for specified users.
LimitAdd Limits for values (e.g. approval is required for Supplier Invoices with a value of R100 000 and above).
ManualManual approval for specified users.

Campaigns & Contracts

Field Description
Auto - SQLCustom checklist created with SQL.
Auto - SQL (Override)Custom checklist created with SQL including an Override for specified users.
Auto - Branch is blankEnsures you select a branch on the Campaign.
ManualManual approval for specified users.

Materials Movement

Field Description
Auto - SQLCustom checklist created with SQL.
Auto - SQL (Override)Custom checklist created with SQL including an Override for specified users.
Auto - Branch is blankEnsures you select a branch on the Materials Movement.
ManualManual approval for specified users.

Report an issue with this page

For more useful feedback, select the text on the page you're reporting about, then click Feedback again — or continue without selecting anything.