Requirement:
Add an item line for the additional fee depending on the item added
Assumptions & Pre-requisites:
- Turn off promotions
- Search for finding the matching fee items for the subset of tag items – to power the script. (search is provided for item/s that are eligible for a specific fee item)
- Search should eliminate the fee items from the list
- A Fee item will not have another fee item in it.
Solution:
- We will create a button called
Add DropShip Feein the Sales Order (Button only will show up in Create or Copy mode). - Add the Tag Qualified items
- Upon hitting Save user will be intimated with an Alert “Your order contains tag qualified items Click the Add DropShip Fee button to initiate the process and adjust the rates”.
(why such an alert on save otherwise there will be an ambiguity whether all item/s added or the user still wants to add more & thereon when to trigger the item addition via the automation) - So unless they hit the “Add DropShip Fee” button the SO cannot be saved.
- Once they hit the “Add DropShip Fee” button, fee items will be added with an amount of 0.00.
a. If all the tag items in the SO have a commonly preferred vendor then only one fee item should be added
b. if all the tag items in the SO have distinct preferred vendors then the fee items will be more than one.
( Amount is set to zero because in case b multiple fee items will be added where the script will be interrupted in the automation because of the standard Netsuite Alert “please Enter an Amount…”. - Here we allow the user to manipulate the fee manually and then SO can be saved by clicking the save button.
- We will mark a field
ADDED DROPSHIP FEE?(under items subtab) once the fee item/s are added.
Also, if the item added is of tag type, you can directly start from the 5th step.
We will use a combination of client script and User-Event/Workflow here.