NetSuite Server Side SuiteScript (2.1) to Automatically Redirect and Load Form The following script illustrates the general pattern to redirect to a specific form. In the pattern below, the logic is hard coded for customer records to load form 108. const beforeLoad = (scriptContext) => { var logTitle = “beforeLoad ” + scriptContext.type + “… Continue reading Automatically Load Specific NetSuite Forms via SuiteScript
Month: March 2023
Add Prescription Table in Customer Record
A prescription is a custom record available in the system we want to show all available prescriptions for that customer. The following script creates a prescription HTML table in the customer record. The Prescription Table shows all essential data like the quantity of prescription items used in Transactions, Auto-ships, Pet & Vet details, etc. Also… Continue reading Add Prescription Table in Customer Record
Saved Search > Add a Link of Custom record to the transaction saved search.
The users want to have a saved search that shows the links of the custom record which will route them to the results of that custom record from transaction search Navigate to Reports > Saved Searches > All Saved Searches > New Select Transaction Saved Search Rename Search Under Criteria tab, add the field:**You may also add another criteria such as the type and… Continue reading Saved Search > Add a Link of Custom record to the transaction saved search.
Delegating Approvals with Suite Approval
We can delegate your approval to another employee within your subsidiary indefinitely or for a period, specified by start and end dates. To delegate approval: Go to Lists > Employees > Employees. Click Edit next to name in the Employees list. Click the Human Resources tab. On the Approval Delegation subtab, complete the following fields: Delegate Approval – Check this box. Delegate To –… Continue reading Delegating Approvals with Suite Approval
Create a Report to Show Customer Returns Quantity per Item
1. Navigate to Reports > Sales > Sales by Item > Customize Summary. 2. Under Filters link, click on Sales folder. Scroll down and click on Transaction Type folder. Click on Long Name. Set the filter to Long Name is equal to Credit Memo. 3. Enter a Report Name and click Save.
Deleting a Custom Record Throws an Error: “This custom record cannot be deleted because it is referred to by custom fields”.
User is unable to delete a custom record type even when it is not referred to by any workflow/script, item, entity, or transaction fields. Steps to Reproduce: 1. Navigate to Customization > Lists, Records, & Fields > Record Types. 2. Click on the Custom Record Type’s name. 3. Navigate to More Actions > Delete. Actual Result: This custom record cannot be deleted because it is referred… Continue reading Deleting a Custom Record Throws an Error: “This custom record cannot be deleted because it is referred to by custom fields”.
Creating a responsive login form without creating router file using CSS.
Creating a a responsive login form without creating router file using CSS. When pressed on “log in” button, login page popup will appear on the website page, We can create a “login” page without creating a router file which redirect after clicked on the button, How To Create a Login Form Step 1) Add HTML:… Continue reading Creating a responsive login form without creating router file using CSS.
CSV Import Inventory Transfer Error: Invalid Item Reference key for Subsidiary
Scenario User is trying to import Inventory Transfer records for Inventory Items via CSV Import and getting an error: “Invalid Item Reference key XXX for Subsidiary XXX”. Solution There are instances when doing CSV Import involving Inventory Items where Item Name/Numbercolumn in the CSV file is not going through resulting to the aforementioned error message. An alternative solution is to re-process the… Continue reading CSV Import Inventory Transfer Error: Invalid Item Reference key for Subsidiary
Shipping Addressee getValue in Sales order
Scenario The Shipping adressee value is null when getting the field value of the ship addressee in a sales order. var addressee = nlapiGetFieldValue(‘shipaddressee’); Solution The recommended way of getting the ship addressee in the sales order is by accessing the subrecord of shipping address field. nlapiViewSubrecord(‘shippingaddress’) The line above will return the address subrecord which… Continue reading Shipping Addressee getValue in Sales order
Setting Field Values Using the Date JavaScript Object
Scenario A developer uses the JavaScript Object new Date() when setting date field values via SuiteScript and is uncertain of the timezone being used by the API. Solution The date and time that is set to fields accepting new Date() varies depending on the current timezone set on the local computer it is running on. So in order to… Continue reading Setting Field Values Using the Date JavaScript Object