Scenario
User is importing a Customer Payment uses the External ID of the Invoice in the CSV Template and receives the error “Invalid doc reference key”, ensure that the Reference type for the Invoice field is set to External ID.
Solution
- Navigate to Setup > Import/Export > Import CSV Records
- Import type: Select Transactions
- Record type: Select Customer Payment
- CSV File(s): Upload CSV file
- Click Next
- Data Handling: Click Add
- Click Next
- Invoice field: Click on the Pencil Icon
- Choose Reference Type: Select External ID
- Click Next
- Import Map Name: Enter Name
- ID: Enter ID
- Click Save & Run