We can use NetSuite global search to open records or pages quickly. For this type the first few letters of the record type needed to be opened and then type the search query(like record id).E.g: For opening a customer record, type “cu:” and type the name/id of the customer. cu: 001 Test Customer Or if… Continue reading Some basic NetSuite Global Search Keywords
Month: June 2022
Account Hierarchy in the Workbook
If we want to show the accounts in hierarchical order while setting the account in the workbook as raw, Click the three dots to the right side of the ‘Account’ raw/column. Select the option ‘Multi-column Hierarchy’. It will show the levels of hierarchy.
Google Search Console Adds Translated Results Search Appearance Filter
You can now set the translated results search appearance filter in Google’s Search Console. Google will translate your page’s results automatically, so that your content is displayed to searchers in their native language. This filter is opt-in by default. However, you may wish to opt-out if you’d like to prevent Google from automatically translating your… Continue reading Google Search Console Adds Translated Results Search Appearance Filter
Update Item status to inactive
Requirement We need yo update an to inactive item records if the following conditions are satisfied: Item is discontinued item Total inventory is zero (Quantity on hand in item record is zero) If there is no purchase orders exist for the item in the following status Purchase order: Pending Supervisor approval Purchase order: Partially received … Continue reading Update Item status to inactive
User Acceptance Testing
Certification module: Audit trail
Every User action performed within the Certification Module (referred to here as an “operation”) is tracked within the master Certification Audit Trail, which can be viewed in the “Audit Trail” tab of the Certification Module. The Audit Trail displays a list of User actions that have occurred within the Certification Module. A subset of this Audit… Continue reading Certification module: Audit trail
Certification module: Reassign tab
The reassign tab enables the Administrator to reassign all the accounts for which one user is assigned to another user in the same role, as well as manage the assignment of backup users. The system will prevent any role conflicts. For example: it is impossible to assign a user to be Reviewer of an account and… Continue reading Certification module: Reassign tab
Resolve Error: “An unexpected error has occurred.” When Viewing Item List
ScenarioUser receives an unexpected error message when they open the Item List via List > Accounting > Items. Note: The error occurs, when the user customize the view of Item Lists and an incorrect syntax is added on the saved search. Solution1. Login to NetSuite Account2. Paste the link on the browser URL: https://system.netsuite.com/app/common/item/itemlist.nl?searchtype=Item&sortcol=Item_NAME_raw&sortdir=ASC&csv=HTML&OfficeXML=F&pdf=&showall=F&style=NORMAL&report=&grid=&searchid=-400&quicksort=&dle=T Note:… Continue reading Resolve Error: “An unexpected error has occurred.” When Viewing Item List
Passing the data in response to the next step in Rest API connection – Celigo
After the import step go to the response mapping and create a mapping for the _json field as the following The HTTP response looks like the following Then in the field mapping add the path to this value in HTTP response and map it with the field in which we need to add this data
Handling null/empty/undefined values in JavaScript
Javascript code to check if a given value is null,empty, or undefined using util library. var is_empty = function (_value) { if (typeof _value === “undefined” || _value === null) { return true; } else if (util.isString(_value) && (_value.trim() === “” || _value.length === 0)) { return true; } else if (util.isArray(_value) && _value.length ===… Continue reading Handling null/empty/undefined values in JavaScript