In NetSuite, Incoterms (International Commercial Terms) are used in Transfer Orders to define the point of ownership transfer between locations—either at the time of shipping or receipt. Here’s a breakdown of how Incoterms work and how to configure them: Available Incoterms in NetSuite NetSuite supports two default Incoterms for transfer orders: Ex Works (EXW): Ownership… Continue reading Incoterm in Transfer Orders
Author: Divya Unnikrishnan
Missing Submit button in Match Bank Data page
With the 2025.2 release, NetSuite introduced enhancements to the Match Bank Data page (referenced in the NetSuite 2025.2 Release Notes under the Banking section). As a result of these updates, the traditional “Submit” button is no longer present. The following changes have been made: The Review subtab now includes options to: Submit Selected transactions Undo Selected transactions… Continue reading Missing Submit button in Match Bank Data page
SAML Single Sign-on role permission
In NetSuite, the “SAML Single Sign-on” role permission allows users to log in using SAML-based Single Sign-On (SSO), which is an authentication method that enables users to access NetSuite through an external Identity Provider (IdP) like Okta, Azure AD, or OneLogin without entering separate NetSuite credentials. Key Points about the SAML Single Sign-on Permission: Purpose:… Continue reading SAML Single Sign-on role permission
Verify TDS Amount Page
The Verify TDS Amount page is designed to assist administrators in reviewing, comparing, and correcting TDS calculations. Through this feature, the SuiteApp enables users to search for vendor bills using filters such as subsidiary, vendor, fiscal period, and section code. It then performs an automatic calculation of the exact TDS that should have been collected… Continue reading Verify TDS Amount Page
Subsidiary Hierarchy Change – Implications
As highlighted by Oracle NetSuite, modifying the subsidiary hierarchy is a highly complex and sensitive operation. Oracle itself has stated that: “The consequences of implemented modifications are outside the scope of any support made available to your organization by Oracle, and your organization is solely responsible for the effect of such modifications on your organization’s use of the… Continue reading Subsidiary Hierarchy Change – Implications
NetSuite Financial topics – CTA, Exchange rate Gain/Loss
Currency Translation Adjustment (CTA) CTA is meant to reflect currency fluctuations during consolidation. For example, if the Indian subsidiary (base currency INR) has ₹1,00,000 in retained earnings and the INR-USD rate changes from 83 to 85, NetSuite calculates the translation difference during consolidation and posts a CTA adjustment in the Netherlands parent (base currency USD). … Continue reading NetSuite Financial topics – CTA, Exchange rate Gain/Loss
Calculating Consolidated Exchange Rates in NetSuite
Consolidated Exchange Rates are used to translate financial data across subsidiaries with different base currencies. Rate Types Used: Current Rate: Exchange rate at the end of the period (used for assets/liabilities). Average Rate: Weighted average of transaction rates (used for income statement). Historical Rate: Weighted average for equity accounts Automatic Calculation: Go to: Lists >… Continue reading Calculating Consolidated Exchange Rates in NetSuite
Month-End Currency Revaluation in NetSuite
Currency revaluation is essential for adjusting foreign currency balances to reflect current exchange rates at the end of an accounting period. This ensures accurate financial reporting. Steps to Perform Currency Revaluation: Enable Accounting Periods: Ensure the Accounting Periods feature is enabled to allow proper posting of revaluations Navigate to Revaluation: Go to Transactions > Financial… Continue reading Month-End Currency Revaluation in NetSuite
List of SQL Functions
NetSuite offers a comprehensive suite of SQL Functions, catering to various data manipulation and analysis needs. Here’s a list of some of the common functions used: Note: The links to the function explanations will be updated as new articles about SQL Functions are posted. Numeric Functions ABS ROUND FLOOR CEIL MOD REMAINDER MOD vs. REMAINDER Character… Continue reading List of SQL Functions
The custom segment shows but not under classifications group, it is displayed at the end of the list in the setup tab > company.
The recommended solution as suggested by SuiteAnswers #1013645 is: Navigate to Customization> Lists, Records, & Fields > Custom Segments Preferred Custom Segment: Click Edit Custom Record Type: Click on Custom Record Type Click Edit Click Links Insert Before: Select Segment Note: Select Preferred Segment where Custom Segment should be placed. Click Save Based on your requirement, the following setup would solve the issue: Section – Setup Category – Company Link… Continue reading The custom segment shows but not under classifications group, it is displayed at the end of the list in the setup tab > company.