Saturday, March 16, 2019

Current Consolidated Exchange Rate Type for Transaction Seaches > Date Range to Translate the Transaction Amounts


1. If you use NetSuite OneWorld, and your subsidiaries have different base currencies, you can maintain a table of consolidated exchange rates. This table is used to ensure that currency amounts roll up properly from child to parent subsidiaries for consolidation purposes. Each consolidated exchange rate translates between the base currency of a subsidiary and the base currency of its parent or grandparent subsidiary, for a specified accounting period.

2. Consolidated exchange rates include three different rate types per period and subsidiary pair: Current, Average, and Historical.

3. On a Saved Search, we can select the type of exchange rate applied to results for each transaction search. This capability allows you to apply the right exchange rate for each search context and to maintain consistency between consolidated report data, transaction search results, and any custom KPIs and KPI scorecards based on transaction saved searches

4. On the Consolidated Exchange Rate dropdown on the Results subtab > shows Current
Current - Uses the current rate for the date range/period selected to filter the search or custom KPI results, if any. If none is selected, uses the rate for the date/period when the search or custom KPI is run.

5. If there is more than one date range on the saved search criteria, what is date range of the Current rate that will be used  to translate the transaction Amounts?

Example:

A Transaction Search has the following Criteria fields/filters:

Type = any of Cash Sale  or Invoice
Date = is within 01/01/2013 to 01/31/2013
Rev Rec Start Date = on or before 03/31/2013
Rev Rec End Date = on or before 01/31/2014


The Consolidated Exchange Rates From : Child Subsidiary  To: Parent Subsidiary are as follows:
Jan 2013 = 1.3523
Mar 2013 = 1. 20
Jan 2014  = 1.410375

Answer:
1. The transaction amount will be translated using the latest or most current date on the criteria. In this case, it will be the Jan 2014 rate.

.

No comments:

Post a Comment