Monday, June 17, 2019

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

 

 

No comments:

Post a Comment