Error: Cannot insert the value NULL into column STARTDATE. - M2 Sync

A row level error for T2B TRANSACTIONS > REVENUESCHEDULE may have this error:
Cannot insert the value NULL into column 'STARTDATE'.
The STARTDATE comes from one of two places on the Transaction:
  1. The Gift_Date if it has a Soft Credit Type of ‘GM’ or a gift kind of ‘OP’
  2. Everything else that it is set to Schedule_Start_Date
Since a Gift_Date cannot be null, the problem is likely an IN PL with a null Schedule_Start_Date. Either adjust the pledge and add a Schedule_Start_Date or adjust the pledge and change the Gift Kind to ‘OP’ so it will use Gift_Date instead.



Was this article helpful?