Requirement The client needs to close the transfer orders and the RMA records automatically which is not scheduled and created 10 days ago. Solution A scheduled script can be used to close the transfer orders and RMS records which is not scheduled and created 10 days ago. For the Transfer and RMA orders both ignore… Continue reading Auto close of transfer order and RMA records
Tag: map reduce script
Deleting Subscription Records
REQUIREMENT The requirement is to delete a few subscription records created in NS. The subscription records are of different statuses- Draft, Closed, Active, and Pending Activation. The subscriptions include change orders associated with them. Develop a script to delete subscription records through scripting. SOLUTION The requirement can be achieved by using the map /reduce script.… Continue reading Deleting Subscription Records
Promotion code transmission Script
Requirement The client needs to implement the promotions feature in NetSuite. Therefore, need to transfer the promotion code record to the website. Map reduce script is created to transfer promotion codes to the Website. When triggered will transfer the promotion codes to the website. Solution
Item Cost Auto Update in Open POs
REQUIREMENT The requirement is that need to update the none of PO status closed, canceled and billed PO’s with the new item rate when it is being updated in the item record. SOLUTION Client script for to check if the item rate is changed in Item Record A custom record is created to store the… Continue reading Item Cost Auto Update in Open POs
Scheduled Email For PM’s using MR script
Requirement: We need to send pending timesheet details to the corresponding project manager by end of the Day.We can use a scheduled script for the development and it will check the timesheet and send a list of pending timesheets to the corresponding project managers with necessary details such as Date,Timesheet details,Actual Hours,Employee name , timesheet… Continue reading Scheduled Email For PM’s using MR script
Project Status Field Update by Scripts NCPS-70
Project Status Filed Update Using Map Reduce Script.