Calculating Time Taken to Approve Orders

You can use formulas in searches to calculate the time taken to approve orders.

To use a formula for calculating the time taken to approve orders:

1. Create a Transaction search, with filters of Type is Sales Order, Main Line is true, System Notes : Field is Document Status, and System Notes : New Value is Pending Fulfillment.

2. Add a Formula(Numeric) results column with the formula {systemnotes.date}-{datecreated}. You can add a Custom Label that indicates this calculation is the time taken to approve each order.

Related Topics

• Search Formula Examples and Tips
• Formulas in Searches
• Using a Custom Formula Field in a Search
• Using a Formula in Search Criteria
• Using a Formula in Search Results
• Using Formula Tags in Search Results
• SQL Expressions

General Notices