Articles tagged #CURRENCY
Articles tagged
#CURRENCY
Post Time Entries > Error Message: "Invalid Account Reference Key on Currency XX"
An error is being generated when posting time: "Invalid Account Reference Key on Currency XXX"
Display Amount Net of Tax (Foreign Currency) on Transaction Searches
Currently, there is no standard field to show Amount Net of Tax (Foreign Currency) on Transaction Searches.Enhancement 207815has been filed to keep track of the process of making this functionality a part of standard NetSuite Features.This article will tackle how to expose the Foreign Currency Amount of Foreign Currency Denominated Transactions (Net of Tax) entered in NetSuite in a Transaction Saved Search. Also, this serves as an alternate solution for the aforementioned Enhancement.
Transaction Saved Search > Type: Payment > Total Amount is using the Base Currency of the Parent Subsidiary > To be able to see the Amount in Foreign Currency
Payment Saved Search > Total Amount using the Base Currency of the Parent Subsidiary > To be able to see the Amount in Foreign Currency
Why is the amount of Balance and Balance (Foreign Currency) column on Vendor Saved Search different from the amount in the Balance fields on the Vendor Record
If theSubsidiaryselected under theHome>Set Preferences>Restrict View tab>Subsidiaryfieldis the same as thePrimary Subsidiaryselected on theVendor record, the amount showing up in theBalance (Base)field on theVendor Recordis the same as theBalancecolumnon theVendor Saved Search,the amount showing up in theBalancefieldon theVendor Recordis the same as theBalance(Foreign Currency)columnon theVendor Saved Search.
Create a Transaction Search with Foreign Currency Balance and Base Currency Balance
Users can create a transaction search that shows the Base Currency of and Foreign Currency amounts.
Amount showing under Amount (Foreign Currency) column is not equal with multiplying Amount with Exchange Rate
When doing bank reconciliation of bank accounts, accounts with Amountshowing 0.00 have values showing on the Amount (Foreign Currency) column greater than 0.00.
Add Amount Due (Foreign Currency) into Open Bills Report
In this article you can find alternate solution forEnhancement 121606. Currently, the Amount Due (Foreign Currency) for A/P Reports including the Open Bills Report is not available.
Saved Search to Pull up Base Price and Other Price Levels for a Specific Currency
User has multiple currencies setup under theSales/Pricingtab of item records and would like to create a saved search to pull up theBase PriceandPrice Levelfor a specific currency.
Accept Customer Payment for Invoice in Different Currency
It is currently not possible to directlyaccept Payment in different currency from the Invoice (as well Bill) currency. This is because NetSuite is not capable of double conversion of Currency. We only have a single Exchange Rate field on a single transaction.This feature is requested underEnhancement112956.The alternate solutionis applicable when a Customer Payment (in USD) and an Invoice (in Euro) were already created and it consists of 4 steps.Step 1: Create Customer Payment for Invoice inEuro. This is the original unapplied Payment based on the Invoice currency.
Saved Search to Expose all Currencies Associated with a Vendor
When users enableMulti-CurrencyforVendor, theCurrencyfield on Saved Search will only point toPrimary Currencyselected on theVendor record.
Multi-Currency Transaction > Bill Payment > Save: An unexpected error has occurred. Please click here to notify support and provide your contact information
The error is due to absence of setup in your Variance Account Mapping. This can be accessed inSetup>Accounting>Foreign Currency Variance Posting Rules.
Saved Search To Show Price Level in a Currency other than the Base Currency When Multi-Currency Feature is Enabled
A user needs to show a Price Level in a Currency other than the base currency set on the account.
Currency Field Disabled when Creating New Project for Multi-Currency Customers
When creating a newProjectfor multi-currencyCustomers, theCurrencyfield is disabled.
How to create a new multi-currency payment file format:
Go to Payments > Setup > Payment File Templates > New.
Use Income Accounts on Multi-Currency Transactions
Currencyfield is grayed-out when creating anIncome type Account(Lists > Accounting > Accounts > New). On existing Income type Accounts, Currency field is not displayed.
Balance Sheet > Amounts Incorrectly Translated from Foreign Currency to Base Currency, especially after a Currency Revaluation
Users customizes Balance Sheet to include the Amount (Foreign Currency) column and the system shows below behavior: Amount in Foreign Currency x Month-end Ending Rate* Amount in Base Currency
Enable the Currency Exchange Rate Types feature
Go toSetup > Company > Enable Features.
Currency Exchange Rate Types
The Currency Exchange Rate Types feature lets you store multiple currency exchange rates for a currency pair and date. Unless you enable this feature, you can have only one exchange rate for each currency pair and date combination. You cannot disable the Currency Exchange Rate Types feature after you enable it.
Revaluation Record Details
The following information is available in the Details subtab for each unrealized gain/loss currency revaluation transaction atTransactions > Financial > Revalue Open Currency Balances > List ( Administrator ). You can also view this information fromTransactions > Financial > Revalue Open Currency Balances ( Administrator )after you run revaluation for a period. Click View in the Results column to view the information from last time revaluation was run for an account.
Currency Revaluation Transactions
Currency revaluation is a system-generated transaction that records the impact to base currency valuation due to exchange rate fluctuations. NetSuite generates several types of currency revaluation transactions. The type is displayed in parentheses at the top of the transaction record.