JIRA CODE : [RSTP-274] Issue in total cost workflow – JIRA – Jobin & Jismi IT Services LLP (atlassian.net)
Workflow Link in PRODUCTION Account
https://776865.app.netsuite.com/app/common/workflow/setup/nextgen/workflowdesktop.nl?id=34&whence=
This workflow is used to calculate the total rental cost for an SPRB Booking record. It will trigger on the After Submit Context.
This workflow have two states. In the first state with the help of a workflow action script we will find the value for optional extra requested. Then store this value with in a field called “Sum of Optional Extras Requested” within the SPRB Booking record. This value is used to calculate the total rental cost.
Workflow action script link in PRODUCTION Account:
https://776865.app.netsuite.com/app/common/scripting/script.nl?id=190
In the second state we will calculate the total rental cost and the store the value with in the field “Total Rental Cost” in the SPRB Booking record.
4 different equations are used to calculate the total rental cost.
- {daily rental rate}*{number_of_phones}*{number_of_days}*(1.1)*({special_school_discount}+{sum of optional extra requested}+(NVL({sprb_courier_charge},0)*2))
Executes under the following conditions: Returned = T and Special School Pricing = T
- {daily rental rate}*{number_of_phones}*{number_of_days}*(1.1)*({special_school_discount}+{sum of optional extra requested}+(NVL({sprb_courier_charge},0)*1))
Executes under the following conditions: Returned = T and Special School Pricing = F
- ({daily rental rate}+{sum of optional extra requested})*number_of_phones}*{number_of_days}*(1.1)+(NVL({sprb_courier_charge},0)*2)
Executes under the following conditions: Returned = F and Special School Pricing = T
- ({daily rental rate}+{sum of optional extra requested})*{number_of_phones}*{number_of_days}*(1.1)+(NVL({sprb_courier_charge},0)*1)
Executes under the following conditions: Returned = F and Special School Pricing = F
Note:
Each equation we are multiplying the value by 1.1 for deducting the tax 10% as per the client request.
The optional extra values are sourcing from the custom record Extras.
The daily rental rate is fetching from the corresponding service items records.