Discussions
SuiteWorld is where the NetSuite community comes together to learn, connect, and discover what’s next.
Whether you’re looking for product updates, practical tips, new ways to improve efficiency, or insights from other customers, SuiteWorld offers something for every stage of your NetSuite journey.
■ NetSuite 2026.2 Release Notes
■ NetSuite SuiteApps Release Notes
■ NetSuite Sneak Peeks
■ Release Preview Guide
■ Release Preview Test Plan Template
Show Custom Field in Another Custom Field Formula
Hi,
I would like to compare between Invoice currency and Customer Primary Currency and then show both the amount in USD and Customer Primary Currency amount.
First, I created custom field (id: customerprimarycurrency) and set the Sourcing and Filtering (Source List = Customer, Source From = Currency).
That worked, however, when I tried to do comparison of the currency in my other custom field, I do not see my newly created custom field (id: customerprimarycurrency) in the Field dropdown list.
Here is my formula on the second custom field to show the amount either in USD or Customer Primary Currency:
CASE WHEN ({currencyname} != {customerprimarycurrency}) THEN NVL({amountremaining}*{exchangerate}, 0) ELSE {amountremaining} END