As part of an organisation’s internal financial controls, the finance team may instate a purchase requisition process to help manage requests for purchases. A purchase requisition is typically sent to the purchasing department to procure goods or services, containing a description and quantity of the goods or services required. Typically, a finance staff member is assigned responsibility for purchase order management.
Here, users can submit purchase order requests, choosing from a list of available products. The costs for each product are pre-defined in the database, so users simply need to choose the product and insert the quantity needed. Subtotals for each line item are auto-calculated, along with an overall total at the end. If the total is less than $1,000, approval from a member of the purchasing team is required. If the total is more than $1,000, approval from management is required. All interested parties will receive automatic notifications throughout the process.
The purchase ordering process differs between organisations. In some cases the department head may approve the purchase request initially, based on their monthly or annual budget, before it is sent to the purchasing team. In other cases, as shown in this demo process, the purchasing team have authorisation to approve requests up to $1,000. Please bear in mind that this form alone does not compare to a full purchase ordering process, it simply makes up one part of the process.
Dynamic Field Changes: The Unit Cost fields will change depending on the product selected. Triggers look for changes in the Product field. If the option selected changes, the trigger pushes the Dynamic Field Change and the value of Unit Cost will be automatically updated.
The Dynamic Field changes table
Workflow: Rules are in place to control what the ticket's status can move to next. For example, if the status is Awaiting Purchaser Approval then any user in the 'purchaser' role can move the status to Approved or Rejected. But anyone in the 'managers' role can also move the status to Awaiting Management Approval. Those in the 'admin' role can move the ticket to any status.
One of the Workflow rules, applicable whenever the status is currently set to 'Awaiting Purchaser Approval'
Formulas: Edit the form, and then edit the Total field. Here you can see a 'parseFloat' expression used to add together the values of the totals above.