Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
NSC | How is Unrealized Gain/Loss Currency Revaluation calculated in Accounts Payable/Receivable?
Scenario:
User have an Invoice recorded in 1,065 Euro and the Base Currency of the Subsidiary is in USD:
At month end, user have an Unrealized Gain/Loss Currency Revaluation:
Breakdown of amounts as per SuiteAnswers Id: 15060 | Revaluation Record Details
Transaction Exchange Rate – Rate of the foreign currency to the base currency used on the transaction can be found in the accounting tab of the Invoice:
Ending Exchange Rate – Rate of the foreign currency to the base currency as of the last day of the posting period
In this case, 12/31/2022
Gain/Loss – Difference in the base currency amount calculated as (Ending Exchange Rate minus Transaction Exchange Rate) multiplied by Balance. A positive number indicates a gain.
Patrick Fresnosa | Advanced Accounting | SRP | Ask a Guru