Foreign Currency Variance Posting Rule Import
Each foreign currency variance posting rule specifies the account into which NetSuite posts gains or losses resulting from foreign currency variances. This account is the destination account. The rules consist of a set of source or revaluation transaction criteria that determine the posting account. You must create the posting accounts you want to set as destination accounts before you import rules. A destination accounts must be an account of the type Other Income or Other Expense.
If your NetSuite account has no variance posting rules, NetSuite posts the gains and losses from fluctuations in foreign exchange rates to default system-generated accounts. The default system-generated accounts are also used if no rules match the transaction. For information about the default accounts, see Foreign Currency Revaluation.
Each variance posting rule must have a unique set of criteria. NetSuite compares each transaction to the foreign currency variance posting rules in the order of rule priority. When a rule matches, that rule is used and evaluation ends. Key fields, custom segments, and custom fields that apply to Purchase, Sale, Journal, Customer Payment, Vendor Payment, or Deposit are available as criteria. Custom fields are limited to the following types:
-
Check Box
-
Currency
-
Date
-
Decimal Number
-
Email Address
-
Free-Form Text
-
Integer Number
For more information about foreign currency variance posting rules and instructions to create the rules in the UI, see Foreign Currency Variance Mapping and its subtopics.
Use the Import Assistant to import foreign currency variance posting rules. The Import Type is Rules Setup, and the Record Type is Foreign Currency Variance Posting Rule. For help with the Import Assistant, see Importing CSV Files with the Import Assistant. For general information, see Tips for Successful CSV Imports.
Features and Permissions Required for Import
The Foreign Currency Variance Posting Rule record type is available for import only when the Foreign Currency Variance Mapping feature is enabled.
In addition to the Import CSV File permission, the Foreign Currency Variance Mapping setup permission is required at the Full level to import rules.
Field Reference for Foreign Currency Variance Posting Rule Import
Change the Reference Type as needed. See Select Reference Types.
Rule Header Fields
Field |
Description |
---|---|
Rule Name |
Required. The rule name must be unique. Include enough information to identify the rule in a list if you change the priority of your rules. The rule name can include symbols in addition to letters and numbers. |
Destination Account |
Required. Use the internal ID or the exact account name, including the account number if the accounting preference box Use Account Numbers is checked. Include the reference type in your field mapping. The account must be of the account type Other Income or Other Expense and must exist prior to import. Foreign currency variances post to this destination account when the source or revaluation transaction matches the rule. Multiple rules can have the same destination account. |
Description |
Include a short description of the rule if wanted. |
Inactive |
This field is a box in the UI. For acceptable inputs, see Boolean Values in CSV Files. Inactive rules appear on the Foreign Currency Variance Posting Rules page, but they are ignored during revaluation processing. |
Rule Criteria Fields
Each variance posting rule must have a unique set of criteria. These fields are in the Criteria subtab in the UI. In the Import Assistant, they are a sublist.
Field |
Description |
||
---|---|---|---|
Criteria Field |
You can import the standard criteria fields for foreign currency variance posting rules, plus custom fields and segments. You cannot set a default value in the Import Assistant. Be sure to create any custom fields and segments prior to import. For a description of the standard criteria fields in the UI, see Defining Foreign Currency Variance Posting Rules. |
||
Criteria ID |
Use this field to update existing rules. To determine the criteria ID, look at the rule in the UI and assign numbers to the criteria fields beginning with 1. You cannot set a default value in the Import Assistant. |
||
Criteria Values |
The criteria values depend on the criteria field. The Gain/Loss criteria field is Boolean. Use T or TRUE to indicate gain. Use F or FALSE to indicate loss. For fields that do not support external IDs (Account Type, Country, Posting Period, Variance Type, and custom segment), the default reference type is Name. (For more information about countries, see Country Names for CSV Import.) Be sure to select the reference type during field mapping. Do not mix name and internal ID reference types in the same CSV file. You cannot set a default value in the Import Assistant. |
||
Operator |
The following table lists the supported operators for the field types and number of inputs shown. You cannot set a default value in the Import Assistant. Number is used for Currency, Integer Number, and Decimal Number field types. Boolean includes Check Box. Text includes Email Address. Operators are not case sensitive. |
||
Operator |
Field Type |
Input Count |
|
AFTER ANYOF BEFORE BETWEEN EMPTY EQUALTO GREATERTHAN GREATERTHANOREQUALTO IS ISEMPTY ISNOT ISNOTEMPTY LESSTHAN LESSTHANOREQUALTO NONEOF ON ONORAFTER ONORBEFORE WITHIN |
Date List/Record Date Number Number Number Number Number Boolean and Text Date and Text Text Number, Date, and Text Number Number List/Record Date Date Date Date |
1 1…N 1 2 1 1 1 1 1 0 1 0 1 1 1…N 1 1 1 2 |
Foreign Currency Variance Posting Rule Import Example
The following table shows the structure of a file to import Foreign Currency Variance Posting Rules with the rule header fields and the rule criteria fields in the same file.
Rule Name |
Destination Account |
Description |
Inactive |
Criteria Field |
Operator |
Criteria Values |
---|---|---|---|---|---|---|
Germany Realized Losses |
612 Realized Losses |
German subsidiary realized losses |
N |
variancetype |
anyof |
Realized |
Germany Realized Losses |
612 Realized Losses |
German subsidiary realized losses |
N |
isgain |
is |
F |
Germany Realized Losses |
612 Realized Losses |
German subsidiary realized losses |
N |
subsidiary |
anyof |
Germany |
Germany Realized Gain |
611 Realized Gains |
German subsidiary realized gains |
N |
variancetype |
anyof |
Realized |
Germany Realized Gain |
611 Realized Gains |
German subsidiary realized gains |
N |
isgain |
is |
T |
Germany Realized Gain |
611 Realized Gains |
German subsidiary realized gains |
N |
subsidiary |
anyof |
Germany |
Other Realized Gains/Losses |
613 Other Realized Gains/Losses |
All other subsidiaries' realized gains and losses |
N |
variancetype |
anyof |
Realized |