Hi Everyone,
I'm looking for recommendations on how to best design a Purchase Order approval workflow in NetSuite with the following requirements:
1. PO Creation
We need to determine which users/roles should be able to create Purchase Orders.
Is there a recommended approach for restricting PO creation to specific roles or employees?
2. Submit for Approval
Users should submit POs using a "Submit for Approval" button.
The Approval Status should not be manually selectable from a dropdown on the PO form.
3. PO Approval
Approvers should approve POs using an "Approve" button rather than editing an approval status field.
The approval process should be controlled through workflow actions.
4. PO Edits After Approval
After a PO has been approved:
Users should still be able to edit most fields (quantities, unit costs, dates, etc.).
The PO should automatically return to a Reapproval status if:
The total PO value increases by more than 25%, or
The increase exceeds a defined dollar threshold, or
New line items are added to the PO.
My questions are:
Can all of the above be handled using a standard NetSuite Workflow, or would SuiteScript be required?
What is the best method to compare the original approved PO total against the updated total?
How are others handling detection of newly added line items on approved POs?
Are there any best practices or common pitfalls when implementing a reapproval process like this?
Any guidance or examples would be greatly appreciated.
Thank you!