Currency Context for Account Balances in NetSuite

With this update, account balance fields now include clearer currency context for Account records in Analytics and in the Chart of Accounts. The Foreign Balance is calculated from the account's default currency, if defined. Additionally, SuiteScript and REST now expose both Foreign Balance (fxbalance) and Balance (balance), making values easier to interpret.

Key Changes

• Foreign Balance and Balance columns are now clearer in Analytics and the Chart of Accounts.
• SuiteScript and REST APIs expose both balance types: fxbalance for original amounts and balance for consolidated values.
• Balance now returns consolidated amounts based on the user role and top-level parent company in the subsidiary hierarchy.
• Previously, Balance returned non-consolidated amounts, which could lead to inconsistencies across different interfaces.

Important Note

This change is a breaking update. If your SuiteScript logic or REST integrations relied on the previous behavior of Balance, updates may be necessary. For non-consolidated amounts, continue using Foreign Balance (fxbalance) instead.

For comprehensive currency management information, refer to the Currency Management documentation.

Who This Affects

Roles impacted by this change include:

• Administrators: Need to review and potentially update scripts and integrations.
• Developers: May need to refactor API calls and scripts due to this breaking change.
• Accountants: Will see clearer account balance displays in reports.

Key Takeaways

• The new currency context improves clarity for account balances.
• fxbalance provides non-consolidated amounts, essential for accurate reporting.
• Breaking changes require updates to integrations and scripts relying on previous behavior.

Source: This article is based on Oracle's official NetSuite documentation.