Cumulative Translation Adjustment (CTA) is a special type of account that is required for consolidated balance sheets in NetSuite OneWorld accounts with multi-currency enabled. The CTA is used on the consolidated balance sheet to make it balance despite differing consolidated exchange rate types. The CTA Balance Audit report shows the contribution from individual accounts to… Continue reading CTA Balance Audit Report
Author: Hormese Paul
Manage Translations tool
Simplifies the process of translating your custom text, called Customization strings. • Allows NetSuite Administrators and Developers to create a collections of strings for translation, called Translation Collections. • Supports a standard file format that can be used by your internal or third-party translation service providers, a translation industry standard called XLIFF file format. A… Continue reading Manage Translations tool
Allow Web Queries
• An on-demand report that is available to non-NetSuite license holders • Works for all reports except Financial Statement Layout-based reports • Calculated (Formula) Fields that are not custom fields must be rebuilt
Workbook Benefits
Complements saved searches & reports Unified data model Access, join, compare & visualize your data Slice and dice data to gain deeper insights Centralize & maintain analytics across the organization Complements saved searches & reports Unified data model Access, join, compare & visualize your data Slice and dice data to gain deeper insights Centralize & maintain… Continue reading Workbook Benefits
Custom GL Lines
The Custom GL Lines feature lets you create custom GL impact lines on standard transactions, such as invoices and vendor bills • It’s used in situations where NetSuite standard GL impact doesn’t cover the specific needs of industry / country / customer • It’s used instead of manual journal entry adjustments for better auditability of… Continue reading Custom GL Lines
Custom Transactions
The Custom Transactions feature lets you create customized types of business transactions • You can create an unlimited number of custom transactions to extend existing business flow or to differentiate from standard transactions, especially journals. • Custom Transactions can move balances in General ledger based on pre-defined rules. Why use Custom Transactions? Automate and implement… Continue reading Custom Transactions
SuiteGL- Custom Segments
Custom Segments • Use the segments to classify records appropriately, permitting filtering and grouping of data based on categories specific to your business The Custom Segments feature lets you create custom classification fields similar to class, department, and location. • You can create an unlimited number of custom segments, define possible values for each segment, … Continue reading SuiteGL- Custom Segments
CSS in Formula HTML field
Case Statements CASE WHEN {source} is “x” AND WHEN {createdby} = “John” THEN ‘<div> 🚨 </div>’ ELSE ‘<div> ✅</div>’ END || CASE WHEN {source} is “y” AND WHEN {createdby} = “Jane” THEN ‘<div> ⚠️ </div>’ ELSE ‘<div> ✅</div>’ END CASE WHEN {source} is “x” AND WHEN {createdby} = “John” THEN ‘<-–!1–-> <div style=”color:white;backgroundcolor:red;padding:3px;text-align:center” > 🚨… Continue reading CSS in Formula HTML field
How is Contra Account Sheet SuiteApp different vs other Financial Reports?
On a Standard General Ledger report or Account Register, users customize the details to add the split column (this is the contra account) . When analyzing an account with contra accounts, the Split column has a value of -Split- and users need to open the transaction to be able to check the accounts, instead users… Continue reading How is Contra Account Sheet SuiteApp different vs other Financial Reports?
Workflow to set Do Not Commit on all lines
Upon further checking, the setting the Commit field via Workflow is a current system limitation. I’ve found several related cases to this and they’re attached to an enhancement. This is logged and being tracked under Enhancement 498309 Sublist Action Group to Set Field Value in Sales Order Item Sublist > Commit Field Unavailable in Field Options