Author: Geordy Cleetus

Finding the duration of a list field based on system information

A standard or custom record in NetSuite has fields that has standard lists or custom lists which changes based on process. These could be approval process or status changes. All these changes are stored on the system information. In case if we need to find the duration of each status for which they were present… Continue reading Finding the duration of a list field based on system information

Identification of the production and sandbox accounts for real-time integration

When using real-time APIs (user event scripts), we need to identify the environment as well as the account id so that the data is sent to the correct database. In this case, we can add functionality in the library file or in the code to find the production account, and sandbox accounts and send data… Continue reading Identification of the production and sandbox accounts for real-time integration

Proposal For Inventory Adjustment Of Trash Items

Requirement   Add a scheduled or map/reduce script in the sandbox that takes every serial number that is in the TRASH bin in Warehouse and creates an adjustment where inventory adjustment reason is “Trash Inventory”.  Our Solution   1. Saved search to fetch the Items moved to the Trash   Need to create a saved search for the… Continue reading Proposal For Inventory Adjustment Of Trash Items

Custom Asset Module

NetSuite provides a standard Asset Module to manage Assets and take Reports.Apart from the standard module, It’s possible to build a custom module so that Assets can be transferred, Revalued add Interests and Dividends for Asset. In this custom module, Asset transactions can be created by manipulating Journal entries. An asset can be tracked using… Continue reading Custom Asset Module

Check record Import – Data requirements

On attempting an import process for Check records, we have to prepare data such that both Body field accounts and line field accounts must be defined separately and should be set accordingly. For preparing the CSV data, the body account should be repetitive along all the columns with the same internal id.The body amount should… Continue reading Check record Import – Data requirements

Filtering Amount(Sum) measure in Workbook

In order to add filters to the Amount (Sum) measure in a workbook, the condition added to Amount in the Dataset can sometimes lead to an unexpected error. So to tackle this, use the Filter By option in the previous column of the Amount (Sum) and add the necessary filter criteria.

Showing sub-total for the hierarchy of the chart of accounts

When creating a workbook for a balance sheet or another transaction query, in order to show the balances for the Chart of accounts in a hierarchical manner, try selecting the multi-column hierarchy from the options of Account. In the option of showing Subtotals and grand totals, select ‘Show Hierarchy Sub-totals’

OneWorld Subsidiaries in Mid-market account

In the OneWorld account, there is a provision for using multiple subsidiaries for managing data and taking reports for all the subsidiaries of the respective company. In the case of a Mid-market account, the multi-subsidiary feature is disabled. So in order to use the multi-subsidiary features in a Mid-market account, we can use a custom… Continue reading OneWorld Subsidiaries in Mid-market account

Currency Revaluation Deletion – Workaround

Currency Revaluations are standard NetSuite record which is automatically created when the Transaction record and the Payment transaction record exchange rates are different. These currency revaluations are attached to the Transaction record and cannot be deleted. In order to remove these transactions, we can edit the Payment record and make the exchange rate the same… Continue reading Currency Revaluation Deletion – Workaround