Save / CSV Import transaction (Journal Entry, Bill, Invoice, Expense Report, etc.) > Error: Invalid entity reference key xx for subsidiary yy

The numbers (YYand XX) found in the error arethe Internal IDs of the Subsidiary and Entity record (Customer, Vendor, Employee, Other Name) respectivelythat are found in the NetSuite account

 

To view the records indicated in the error:

1.    Navigate to Home> SetPreferences > General tab

2.    Set Show Internal IDs = True

3.    Hit Save

4.    Subsidiary record

•        Navigate to Lists> Search > Saved Searches > New > Subsidiary

•        Enter this filter under the Criteria tab > Standardsub tab:

•        Internal ID (Number) = YY

•        Hit the Previewbutton

5.    Entity record

•        Navigate to Lists> Search > Saved Searches > New > Entity

•        Enter this filter under the Criteria tab > Standardsub tab:

•        Internal ID (Number) = XX

•        Hit the Previewbutton

To resolve the issue:

o   Entity record referred to in the error:

•        Must be Active

•        Must have the same Subsidiary value as that of the transaction

 

o   For CSV Import:

•        Entity value specified in the CSV file must have thesame format as seen in the UserInterface (UI) or

•        Enter the InternalID instead of the entity name in the CSV file

•        Depending on what is on the file, during mapping > set the Reference Type to either Internal ID or Names by clicking on the small pencil icon beside the Entity field