“Invalid custcol_far_trn_relatedasset reference key xxx” on Journal Entry Import

User imports a Journal Entry with line items linked to related assets but receives the error message provided above.

1. The Asset Record linked to the Journal Entry line is not set to inactive

1. Navigate to Fixed Assets > Lists > Assets
2. Click View on the Fixed Asset Record
3. Ensure that the Inactive checkbox is not marked on the Asset Record

2. Ensure that the FAM Asset ID as well as the name is included in the Journal Entry .csv import file

Example: FAM000001 Example Asset Name3. If internal IDs are used, on the Field Mapping page

1. Click the edit icon beside the Department field
2. Click Choose Reference Type
3. Select Internal Id