NetSuite Scripting Project
Budget: $30 – $250 USD
I require a script to be created that does the following :
1. I enter or upload a CSV of a list of purchase order numbers.
2. The script searches for each Sales Orders with the PO number from the list and changes the line item "Location" field to a set value. It also changes another line item column called "Carrier Code" to a set value. Each Sales order is usually only 1 line item but could be multiple in a rare situation and all should change.
3. The script then searches for Item fulfillments and cash sales related to the same document and changes those Line Item "Location" fields to a set value.
Note that not all Sales Orders will have the Item fulfillment and Cash Sale. It should just skip those if they don't exist.
Thanks
1. I enter or upload a CSV of a list of purchase order numbers.
2. The script searches for each Sales Orders with the PO number from the list and changes the line item "Location" field to a set value. It also changes another line item column called "Carrier Code" to a set value. Each Sales order is usually only 1 line item but could be multiple in a rare situation and all should change.
3. The script then searches for Item fulfillments and cash sales related to the same document and changes those Line Item "Location" fields to a set value.
Note that not all Sales Orders will have the Item fulfillment and Cash Sale. It should just skip those if they don't exist.
Thanks