Currency revaluation records are created by NetSuite when there is a fluctuation between the base currency and foreign currency amounts in transactions. The currency revaluation records are automatically created when we run month end task “Revalue open foreign currency balances” and also while creating payment records. If the Currency Revaluations are ran more than once in a period, we would check first when the particular Currency Revaluation record was created:
1. Go to List > Search > Saved Searches > New > Transaction
2. Set the following under Criteria:
– Type = Currency Revaluation
– Document Number = Provide the document number of the record.
3. Under the Results tab:
Add Date Created Field.
4. Click Save & Run
This search will provide the date when the currency revaluation is created.
To check the total of transactions up to this date:
1. Go to List > Search > Saved Searches > New > Transaction
2. Criteria:
Account = is (provide the account name)
Subsidiary = (Provide subsidiary name)
Type = is not Currency Revaluation
Date Created = is not after (provide the date of revaluation record as per the previous search)
Date = is not after (Provide the month end date of the month on revaluation posted)
3. Results:
Consolidated Exchange Rate = None
Show Totals = T
Add the columns with Summary Types:
- Document Number | Group
- Amount | Sum
- Amount (Foreign Currency) | Sum
- Currency | Group
- Exchange Rate | Group
4. Click Save & Run
5. The results can be exported to recalculate the Gain/Loss (Total of the amount in the result).