Requirement Update the values in a new custom field from another field in the custom record for newly creating custom records and on the edit and save of the custom record. Solution There is a custom field named Runtime (Internal id : custrecord_au_production_runtime ) of free form type. Created another field named “Runtime Numeric“ (Internal… Continue reading Updating a field value from another field on the save of the record
Author: Jesna John
Restrict the sales order creation if the sales team is empty
Requirement While creating a sales order, if the sales team is empty, then show a pop-up message to notify that the sales team is empty and doesn’t allow the creation of a Sales Order record. Solution Create a client script and check if the sales team is empty in the Sales Order record. If the… Continue reading Restrict the sales order creation if the sales team is empty
Restricting users to add items to sales order records.
Requirement The requirement is to either allow or disallow items to be selected on a sales order based on the user’s certifications and the items being chosen.If a user does not meet the criteria for selling an item when it is added to the Sales Order through the UI, a popup needs to notify the… Continue reading Restricting users to add items to sales order records.
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
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