Scenario:
The user is attempting to import a journal entry using a CSV file that includes data in the Name column, referencing vendor or customer records. The journal entry is intended for a specific subsidiary, but upon import, NetSuite throws in an error even though the user confirms that the vendor is associated with subsidiary 3, the error persists.
To illustrate, suppose the Parent Subsidiary has a base currency of USD, and a Vendor record associated with this subsidiary is set to a primary currency of CAD. The user creates a CSV file for a journal entry intended for the Parent Subsidiary, where some lines are in USD and one line references the CAD vendor. When the import is attempted, NetSuite throws the error:
Invalid entity reference key 2031 for subsidiary 1.
Although the vendor is correctly associated with Subsidiary 1, the currency inconsistency between the journal entry lines (USD) and the vendor’s currency (CAD) causes the transaction to fail.
Solution:
There are two common reasons for this error:
- Subsidiary Mismatch:The entity referenced (such as a vendor or customer) is not assigned to the subsidiary selected in the journal entry. NetSuite enforces strict subsidiary access, and the entity must be linked to the same subsidiary as the transaction.
- Currency Mismatch:Even if the entity is assigned to the correct subsidiary, the error may occur due to a mismatch in base currencies. Each subsidiary has a base currency, and entity records (especially vendors and customers) have a primary currency. If the journal entry involves multiple currencies or lines that do not match the entity’s primary currency, NetSuite will return this error.
Step 1: Confirm Subsidiary Assignment
- Navigate to the relevant entity record (e.g., Lists > Relationships > Vendors).
- Open the entity record in Edit mode.
- Confirm that the Subsidiary field includes the subsidiary selected in the journal entry
Step 2: Check Entity Primary Currency
- While on the entity record, review the Currency field (also referred to as the primary currency for the entity).
- Ensure this currency aligns with the journal entry lines.
Step 3: Check Journal Entry Currency Consistency
- Journal entries must use a single currency across all lines.
- If an entity (vendor, customer, etc.) has a currency that differs from the journal entry’s base currency, either:
- Adjust the entity’s currency to match the journal entry, or
- Modify the CSV file to ensure all lines are consistent with the currency supported by the entity.
Hope this helped!
