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
Author: Jesna John
Calculating The Landed Cost Value in the Item Receipt
Requirement On the Item Receipt record, we can use customization to source the landed cost category values at the item receipt line level. we need to source the landed cost category values from the landed cost template to the standard landed cost golden box by using customization. Solution
Displaying PO# and Order# duplicate alert in sales order record
REQUIREMENT Need to display an alert if the PO# with that customer exists in sales order record. Also, display an alert message if sales order is tried to save with the duplicate order# value. SOLUTION
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
Excel connector using suitelet
Requirement Set up a test account to establish a dynamic connectivity to the excel using a suitelet script. Excel should pick up data from a saved search. Solution Use a suitelet script External url with the saved search Id and a secret key to use in excel sheet.
Auto Populate Preferred Vendor on Item Record
Requirement In the item record, there is a custom field called PRIMARY VENDOR. When it is selected then under the purchase and inventory tab we need to set it as the primary vendor, in the standard sublist. Solution
Saved search to list invoices with multiple deposit application
Requirement Create a saved search to list all invoices details for which the number of deposit application is more than one. Solution Create a invoice type saved search with the following criteria: Standard : Type: Invocie Applying Transaction Type: Deposit Application Summary: Applying transaction count greater than One. Results : Add necessary fields and Count… Continue reading Saved search to list invoices with multiple deposit application
Update Status field of the task record
Requirement We need to change the standard status field, which is not displayed on the task form based on the custom status field. Solution We can create a user event script to update the standard field for this purpose.
Dynamic connection to Excel
Requirement We need to create a Suitelet page to load the saved search and the search results should be loaded to the Excel sheet by connecting Excel to the Netsuite using the Suitelet URL. Suitelet should be respond with CSV file format. Solution We will be creating a suitelet script to load the saved search… Continue reading Dynamic connection to Excel
Adding Planogram Button in customer Record
Requirement We need to create a Planogram button in customer record. If the customer record doesn’t have a planogram custom record entry yet, we need to set show a button .If not hide the button. On button click, we need to show a planogram and create a page in a new tab with the customer… Continue reading Adding Planogram Button in customer Record