Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
INVALID_KEY_OR_REF Invalid custrecord_pr_psd_department reference key 1
// the department with id 1 is inactive

INVALID_KEY_OR_REF Invalid employee reference key 2457
// the employee with id 2457 is most likely inactive or has a historic termination date, or cannot be set as the field is filtered.

INVALID_KEY_OR_REF Invalid casetaskevent reference key 6241 for customer 5273
// the task with id 6241 set on a time record is not a task of the project 5273

INVALID_KEY_OR_REF Invalid custcol_pr_pcst reference key 21
// the pay component sub type with internalid 21 is inactive or does not have show on time entry ticked

INVALID_KEY_OR_REF Invalid class reference key 11 for subsidiary 2
// the class with internalid 11 cannot be set for an employee in subsidiary with internalid 2

INVALID_KEY_OR_REF Invalid Entity reference key 317 for subsidiary 12
// the Vendor/Supplier with internalid 317 cannot be set on a journal in subsidiary with internalid 12

The most common of these errors relates to an incorrect Super Fund Vendor/Supplier. Steps to fix below. 

INVALID_KEY_OR_REF Invalid Entity reference key 317 for subsidiary 12
// the Vendor/Supplier with internalid 317 cannot be set on a journal in subsidiary with internalid 12

...


2. You also need to fix any pay components or employee super funds on the employee record with that Vendor so that it doesn't happen in a future pay run.

Background

Excerpt

NetSuite returns an invalid record reference error when an attempt is made to set a field to a value that is no longer valid. The field value may not be valid for a number of reasons

...

  • Posting Payrun when the journal is creating setting accounts
  • Process Payslip where employee pay component values are used to create payslip details

Solution

To fix the error you will need to either a) re-enable the value so it can be set into the field  b) update the records that the inactive field values are being reference from. To diagnose

...