The “Advance to Apply” field in the Expense report in NetSuite is a helpful feature for managing non-reimbursable expense reports. It allows the recording of expenses as paid without directly reimbursing the employee. Steps to Use the Advance to Apply Field Create the Expense Report Enter the Non-Reimbursable Amount in the Advance to Apply field.… Continue reading Non-Reimbursable Expenses Using the Advance to Apply Field
Category: NS Administration
All articles / code related to Netsuite administration
Worldwide Support for Phone Number Formatting
Worldwide Support for Phone Number Formatting Values in custom fields set to the Phone Number type use localized formatting if the Phone Number Formatting feature is enabled in your account. The Country field in the subsidiary of the user determines the local formatting that is applied.Worldwide phone number formatting is supported for all countries in… Continue reading Worldwide Support for Phone Number Formatting
Turning on Redwood Experience in NetSuite – Release 2024.2
NetSuite New Release 2024.2 You can now use the new Redwood Experience theme, which gives NetSuite a different look and feel. The Redwood Experience theme offers new colors, icons, and fonts for the page header, forms and lists, and dashboards. By default, the Redwood Experience theme is enabled only for the Login page. To enable… Continue reading Turning on Redwood Experience in NetSuite – Release 2024.2
Why Emails Sent by a User Appear from a Different Email Address in NetSuite
Problem: The user Cathy Cadigan has her email address listed as adminfun091324nv@netsuite.com in her Employee record. However, emails sent by her show the “From” email address as abc@gmail.com instead of the email listed in her Employee record. Cause: This discrepancy is due to the “From Email Address” configured in the Set Preferences section of the… Continue reading Why Emails Sent by a User Appear from a Different Email Address in NetSuite
Disabling History for a Workflow
You can use the Keep Instance and History dropdown list to specify if instance and history records are saved for workflows. Workflow history records take the form of execution and error log records. In the Keep Instance and History dropdown list, you can select to save workflow instances and history records Always, Never, or Only… Continue reading Disabling History for a Workflow
Vendor Prepayment Saved search
var vendorprepaymentSearchObj = search.create({ type: “vendorprepayment”, settings:[{“name”:”consolidationtype”,”value”:”ACCTTYPE”}], filters: [ [“type”,”anyof”,”VPrep”] ], columns: [ search.createColumn({ name: “formulahtml”, summary: “MAX”, formula: “‘<a href=”/app/accounting/transactions//vprep.nl?id=’||{internalid}||’” target=”_blank”>View</a>’”, label: “View” }), search.createColumn({ name: “trandate”, summary: “GROUP”, label: “Date” }), search.createColumn({ name: “transactionnumber”, summary: “GROUP”, label: “ID” }), search.createColumn({ name: “subsidiarynohierarchy”, summary: “GROUP”, label: “Subsidiary” }), search.createColumn({ name: “classnohierarchy”, summary: “GROUP”, label:… Continue reading Vendor Prepayment Saved search
Workflow Instance and History Record Management
Active workflows can generate a large number of workflow instances and history records. The following records are usually generated when a workflow executes: An instance record is generated every time a workflow starts a new execution on a record. A history record is generated for every state that the workflow enters and exits for each… Continue reading Workflow Instance and History Record Management
Using SuiteQL to Retrieve Time Zone Offset and Session Time Zone
In many applications, accurately handling time zones is essential for ensuring consistency across various regions. SQL provides straightforward methods for retrieving the time zone offset and session time zone, enabling precise time adjustments. In NetSuite, when working with time zones in SuiteQL, there are two key functions to understand: TZ_OFFSET and SESSIONTIMEZONE. These functions allow you to determine time zone… Continue reading Using SuiteQL to Retrieve Time Zone Offset and Session Time Zone
Create a Custom Sublist That Shows Associated Cases on Item Records
Scenario User wants to create a Custom Sublist on the Item record that shows the associated Case record it was included. Solution 1. Create Case Saved Search Navigate to Lists > Search > Saved Searches > New Select Case Search Title: Enter Title Example: Cases Associated to an Item Available as List View: Enter Checkmark Available as Sublist View: Enter Checkmark Filter: Select Item Fields… Select Name(Internal) Select Is Not Empty Click Available Filters Tab Filter: Select Item Click Save 2. Create Custom Sublist Navigate… Continue reading Create a Custom Sublist That Shows Associated Cases on Item Records
Add Images to File Cabinet via CSV Import and Associate Them to Item
User would like to add images on File cabinet and associate it to Item record via CSV import. Solution Upload the images to your File Cabinet. On your Computer, collect all your images and make sure to name them accordingly. Move it to one folder then Archive it Login as an Administrator Navigate to Documents > Files… Continue reading Add Images to File Cabinet via CSV Import and Associate Them to Item