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
Category:
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
Sort items (matrix/variation) in Shopify
You can now create a custom item field to sort matrix items or items with variations in ascending order in Shopify. You can then use the custom item field to specify the item position. For example, if you have 5 matrix items, in the custom item field you can specify the position (1 through 5)… Continue reading Sort items (matrix/variation) in Shopify
India Localization Suitetax engine Bundle Update 2025.2
With India Localization SuiteTax Engine SuiteApp 2025.2, you’ll be able to set up vendor exemption rules for periods of less than a year. This change will align exemption rules with TDS certificates that are issued for shorter durations, such as a quarter or a few months. The India Localization SuiteTax Engine SuiteApp 2025.2 is targeted… Continue reading India Localization Suitetax engine Bundle Update 2025.2
Customer credit system for prepayments and Deferred Revenue
A credit system is implemented for prepayments, where 1 credit = $1 USD. This will make buying credit similar to buying reserved capacity for US buyers i.e. paying prepayments as credits. Price/usage is metered in USD or relevant currenies, but customers can pay in their local currency at the spot rate at time of billing,… Continue reading Customer credit system for prepayments and Deferred Revenue
Resolve Error: “Invalid orderstatus reference key H.” When Changing Order Status Using Workflow
User is trying to override the Order Status to Closed using workflow, it returns the error “Invalid orderstatus reference key H”. Transactions can be set the Order Status to Closed only if all Items on the Order are also Closed. Below is a sample of workflow that sets the Order Status to Closed after clicking… Continue reading Resolve Error: “Invalid orderstatus reference key H.” When Changing Order Status Using Workflow
OAuth 2.0 Machine to Machine (M2M) Certificate generation
We can generate OAuth 2.0 M2M certificate files, public key, and private key files for NetSuite in this method. Prerequisites: Download and set up OpenSSL portable version. Run this command in Powershell from the ‘bin’ folder in the SSL library: .openssl req -new -x509 -newkey rsa:4096 -keyout private.pem -sigopt rsa_padding_mode:pss -sha256 -sigopt rsa_pss_saltlen:64 -out public.pem… Continue reading OAuth 2.0 Machine to Machine (M2M) Certificate generation
NetSuite – Shopify integration
1. Purpose of Integration Syncs orders, inventory, customers, and financials between NetSuite and Shopify. Reduces manual data entry and improves operational efficiency. Enables scalable ecommerce operations with automated workflows. 2. Create a Role for Token-Based Authentication Before creating the Integration Record, you must create a custom role with specific permissions to support token-based authentication. Steps:… Continue reading NetSuite – Shopify integration
Unlocking Contextual AI-Driven Insights with NetSuite and Salesforce Integration
In today’s data-rich business environment, integrating NetSuite’s financial intelligence with Salesforce’s customer engagement data opens the door to a new frontier: contextual AI-driven insights. This advanced capability goes beyond traditional data syncing—it enables predictive intelligence that transforms how businesses interact with customers. Key Highlights: Predictive Churn Analysis By combining NetSuite’s financial behavior data (e.g., late… Continue reading Unlocking Contextual AI-Driven Insights with NetSuite and Salesforce Integration