Category: NS Customization

All articles / code related to Netsuite customization

How to Fix Table Cell Alignment Justification Anomaly

Here is the typical HTML code used for structuring the <td> cells of the table. White spaces are appeared between the letters of the words. Here is the modified HTML code. The last line shows the fix for the unexpected cell alignment in the “PO #” column. This simply wrap the cell contents inside of… Continue reading How to Fix Table Cell Alignment Justification Anomaly

How to create a View to Render a Registered Page Type.

When we register a page type with the PageType Component, we must also create a view to render the data when a user navigates to an instance of that page type. When creating this view, follow these best practices: Any view handling requests for a registered page type must extend PageTypeBase.View.js. Any view handling requests for a… Continue reading How to create a View to Render a Registered Page Type.

Custom Role User Is Unable to See a Custom Field on the Saved Search

A Custom Field with View Access for a Role is not showing when the Saved Search is run for the Role. Solution Confirm the setup of the Custom Field and Add the Custom Field on the Saved Search using a Role with higher Permissions for the Custom Field. Confirm the setup of the Custom Field Navigate to Customization > List, Records & Fields > CRM Fields (or the type of field… Continue reading Custom Role User Is Unable to See a Custom Field on the Saved Search

Activity Saved Search Filtered by a Custom Employee Field

how to create an Activity Saved Search wherein the filter is based on an Employee field. Currently, no Employee fields are available on the Activity Saved Search filter fields drop-down. Solution Create a Custom Entity Field for Employee Records Navigate to Customization > Lists, Records & Fields > Entity Fields > New Label: Enter labelExample: New Region Type: Select Free-Form Text Store Value: Enter Checkmark Click Applies To Employee: Enter Checkmark Click Display Subtab: Select Main… Continue reading Activity Saved Search Filtered by a Custom Employee Field

Inventory Activity Detail Report in Saved Search

Requirement: A user wants to show the Item with Quantity only that will match with Inventory Detail Report. This search should only expose the Item and Quantity Summary Initially but upon clicking on the Item it should expose all the relevant transactions for it. Solution Create a Transaction Saved Search by navigating to Reports > Saved Searches > All Saved… Continue reading Inventory Activity Detail Report in Saved Search

Separate GST and TDS in Saved Search

Requirement: Client would like to see GST and TDS in separate columns in the search. Using NetSuite Standard behavior, it is obtained as Amount (Tax) in search. Solution: Create a Transaction Search. In Criteria Subtab, -Add Type is Bill -Mainline is False In Results Subtab, Add necessary fields. For TDS, Field: Formula Currency, Function Absolute… Continue reading Separate GST and TDS in Saved Search

Clarification on displaying discount item in commercial invoice print if there are multiple IF records

Requirement: Discount line in sales order should be displayed in corresponding commercial invoice print. The sum of total items in commercial invoice will be the same as shown in sales order. Current functionality: ‘Test Button’ is added in IF record, and once clicked it, commercial invoice print will be created including the items in the… Continue reading Clarification on displaying discount item in commercial invoice print if there are multiple IF records

Create Transaction Detail Report to show Related Transactions of Item

Scenario User would like to create a report to show all related transactions of an item. Solution You may follow below steps: 1.) Navigate to Go to Reports > Financial > Transaction detail > Customize2.) Rename  the report3.) Under Edit Columns, add fields: Transaction Type: Transaction Type Long Name Transaction: Date Transaction: Item Transaction: Document Number Transaction: Account Full… Continue reading Create Transaction Detail Report to show Related Transactions of Item