Thursday, April 18, 2019

CSV Import of Journal Entry > Error: Invalid department reference key xxx

1. Department must be correctly spelled. If Parent-Child relationship is involved, make sure that the name(s) of the Parent Department(s) are included. For example, if the name of the Department is Accounting and it is a Child Department of Finance, it must be entered as Finance : Accounting.

2. Department should be Active. Navigate to Setup > Company > Departments. Set the Show Inactives box to True and make sure that there is no check mark on the Inactive box besides the Department selected on the CSV file.

3. If Internal Id's are used, make sure that on the Field Mapping Page of the CSV import, the Choose Reference Type is set to Internal Id. This can be done by clicking the small pencil icon besides the Department field.

4. If External Id's are used, make sure that on the Field Mapping Page of the CSV import, the Choose Reference Type is set to External Id. This can be done by clicking the small pencil icon besides the Department field.

No comments:

Post a Comment