Wednesday, April 10, 2019

Invalid subsidiary reference key xxx is received on CSV Import of Journal Entry

To correct the error message "Invalid subsidiary reference key xxx" when importing Journals:

1. Verify that the subsidiary is an active and existing subsidiary by navigating to Setup > Company > Subsidiaries. The subsidiary should be spelled the way it is spelled in the record. It is also possible to export the list of subsidiaries to get the correct format. If the Subsidiary has sub subsidiary, the format should be Parent Subsidiary:Child Subsidiary.

2. When using the Internal ID of the Subsidiary, set it correctly on the field mapping page.  On the Field Mapping page of the Import Assistant, map the field for Subsidiary, click on the pencil icon and set Choose Reference Type to Internal ID.

3. When importing a single Journal, a default value could also be set on the Field Mapping page. On the Subsidiary (Req) line, click on the pencil icon and set the subsidiary.

No comments:

Post a Comment