-
Edit Consolidated Exchange Rate
Hi Team, I have a question regarding consolidated exchange rate. Understand that NetSuite calculate indirect consolidated exchange rate based on subsidiary hierarchy. For example like this screenshot Is there a way to force the consolidated exchange rate from subsidiary A to subsidiary C to 1? Because they shared identical…
-
NSC | Foreign Amount Field Not Visible on Expense Report in Employee Center Role
When creating an Expense Report in NetSuite using the Employee Center role, users may need to enter a Foreign Amount for expenses incurred in a different currency. In this scenario, the user reported that the Foreign Amount field was not visible on the Expense Report form, even though the form supports this field. The…
-
Foreign Amount & Rate
Using suitescript api, fxrate is currently working, just like fxamount, but fxrate is not available in documentation and record browser, so just wanted to get confirmation that this is a supported field..
-
In "Trial Balance with Foreign Currency", column "Amount (Foreign Currency)" displays strange values
The Amount (Foreign Currency) column in the "TB - Trial Balance with Foreign Currency" report displays unusual numbers. See attached image. The subsidiary's currency is GBP. For account 5806, debit is 9,596.75 GBP, but 0.00 USD under Amount (Foreign Currency). For account 5820, credit is 4,864.97 GBP, but -8.96 USD under…
-
NSC | How To Resolve Unexpected Error In Bill Payment With Foreign Currency?
Scenario: User encountered unexpected error when processing Bill Payment in foreign currency. Please be advised that the error happens when the Foreign Currency Variance Mapping is enabled under Setup > Company > Enable Features > Accounting subtab > Advanced Features section and there is no Variance Account Mapping made…
-
NSC | Currency Used in Financial Reports
Scenario Users have transactions processed in NetSuite involving currencies other than the Subsidiaries' base currency. They want to know the currency and exchange rate utilized by the system when running reports. Solution The value you select in the Subsidiary Context list for a report determines the data and currency to…
-
Foreign Currency Transactions
Hi Sorry if this is a silly question, but when a transaction is processed in NetSuite that involves a currency not the Subsidiaries base currency so when I run reports which exchange rate does the system use? Is it the exchange rate of the period the transaction was processed or the exchange rate of the period I run the…
-
Purchasing Clearing (Accrued Purchases) account
Hello When Item receipt has been processed our GL will be Inventory / Purchasing Clearing (Accrued Purchases) And when processed vendor bill the our GL will be Purchasing Clearing (Accrued Purchases) / Accounts Payable If they are foreign currency transaction and posting period is different, Purchasing Clearing (Accrued…
-
Impact of transaction date on the Currency Conversion Rate
Hello Gurus, I got an interesting question here. Want to get clarified the below scenario on the Currency Conversion Rate. Let say I created a journal entry a future date (transaction date as 07/10/2023) and let’s say the JE is in a currency other than the base currency of the entity. As I see NetSuite is assigning a…
-
How are currency conversions performed on purchase orders?
I have a question regarding currency conversions on PO's. For example: If a subsidiary has EUR as base currency and the PO is filled in USD then the total amount is displayed in USD (which is good). But then when a saved search is created to display the amount, that amount is always displayed in a different currency. There…