-
Exchange Rate Automatic Update on PHP-COP; COP-PHP
When user creates journal entry for certain subsidiary (base currency is Philippine Peso (PHP)) with currency - Colombian Peso (COP), the exchange rate reflecting is not accurate/outdated. The exchange rates of other currency pairs of COP are being automatically updated except PHP-COP and vice versa. Is this related to…
-
Expense report is not taking currency set at line level
The user has EUR as her default expense report currency, however she had to create an expense report with few lines in GBP currency together with EUR lines. Even if the "Use multiple currency" check box is marked, the amount set under "Amount in local currency" for the GBP line is being considered by Netsuite as the EUR…
-
Wrong exchange rate on item fulfillment
I have this scenario with multi book accounting: Issue: NetSuite is using a wrong currency exchange rate in the item fulfillment, creating a wrong impact in a secondary accounting book that uses a different currency. Description: Subsidiary base currency (Primary book) = CRC Secondary book currency = USD I created a Sales…
-
Intercompany FX Rates: FX rate isn’t the same for the same pair of currencies
For some reason depending on which entity we look at the FX rate isn’t the same for the same pair of currencies as per below. This is causing intercompany differences. When we consolidate the transactions in GBP, we’re reliant on the system to translate that at a consistent rate and we do not have control over the rate is…
-
How to Convert amounts into Specific Currency (non-base) using Workflow for approvals?
I have a requirement where Customer wants to RUN approvals in USD for all subsidiaries. How can i get the amounts to be converted to USD irrespective of the base currency.
-
How to allow users to change their transaction exchange rate only? (not the system rate).
Hello Gurus, while users are changing their transaction exchange rate, the system will display a message, through this message if they click OK they can change the system default exchange rate, by clicking CANCEL the transaction rate only is changed. Sometimes by mistake the users click on OK, but in fact we don't need to…
-
Exchange rate question - Jan rate is used for Dec transaction
We noticed that JE47597 posted to Dec 2021, is using exchange rate of 1.26344, which is a rate we've specified for Jan 2022 instead. As you notice, the rates are updated once a month. And you would think that Dec transaction should be using the rate for Dec 1.27928. Would you be able to help us why the system is picking up…
-
Exchange Rate used for Reversal Journals
Hello, I would like to ask you for any suggestions regarding issue with Exchange Rates used on Reversal Journal Entires. Per checking the Answer Id: 7744 : A reversing journal entry is an exact opposite of the original journal entry. For example, the original journal entry debits Accounts Receivable $100, credits a revenue…
-
[NetSuite] Discrepancy in the transaction amount
Team, I have the following difficult case with Customer Balance. Maybe you could help me? In NetSuite, the Customer has the adjustment $ 6805.96. The exchange rate is 1.298904 During the integration, we received this transaction, but the transaction amount is $5470.769 and the currency is unknown. I tried to calculate…
-
Action Recommended – Review Currency Exchange Rates and Transactions
Some customers will receive this notice because the Currency Exchange Rate Integration feature in your NetSuite account was inadvertently disabled after you accepted the new Terms of Service for the feature. After the feature was disabled, your account stopped receiving exchange rates from Refinitiv, your selected exchange…