-
Amount Debit foreign currency is empty in Item Fulfillment saved search
A saved search is created to show item fulfillments created from sales order, along with the sales order amount in base currency and consolidated, COGs amount in base currency and consolidated and the consolidated exchange rate. The issue is the formula used to calculate the consolidated exchange rate is Formula (Currency)…
-
want to set more than 2 decimal places in report builder
In the A/P Aging Detail report builder, I selected the "Exchange Rate" field to display in the report. This field is currently set to show 2 decimal places, but I would like to display 8 decimal places, as the original document uses up to 8 decimal places. Could you please advise me on how to configure this setting? Thank…
-
NetSuite Admin Tip | How to Verify the Computed Average Consolidated Exchange Rate
The success of multinational corporations is significantly influenced by exchange rates. Exchange rates enable countries to assess their currency values and facilitate cross-border transactions. Global businesses must understand how exchange rates work for effective operations. These global and multi-subsidiary…
-
Search the exchange rate list via a script?
It seems there is no way to search the exchange rate list via script. (Not consolidated exchange rate.) Is it really impossible to access the exchange record list with the N/search module?
-
Future Dated Transactions > Exchange Rate Managment
Dear Community, Recently, we began managing our company's Sales Orders within our Netsuite account. However, we have encountered a specific challenge regarding the exchange rate between our accounting books: the primary book (Local currency) and the Secondary book (US Dollar). Our primary objectives are twofold: Align the…
-
Ability to change the exchange rate in transfer funds
Good day again Oracle NetSuite Community! I just need help on changing the exchange rate when using the transfer fund functionality. What is the logic as to why the Exhange Rate field cannot be edited. Cause definitely there would be a scenario (seems very common) that the rates will be provided by the bank that is not the…
-
June 2021 Ending Consolidation Exchange rate does not match the Ending Rate
While doing our month end reconciliations we noticed that the exchange rate being used on the Balance sheet is the Consolidated Exchange rate which is quite different from the Exchange rate at the end of June. In the past, the Consolidated rate always matched the ending rate for the month. As a result, our balance sheet is…