Error: "Cannot insert the value NULL into column 'NAMECODE', table '20957" - When entering constituents into a constituent update batch

When adding constituents to your constituent update batch you may receive this error message:  Cannot insert the value NULL into column 'NAMECODE', table '20957_264f3555-69d1-4070-a880-638fc9e7cfab.dbo.BATCHCONSTITUENTUPDATE'; column does not allow nulls. UPDATE fails
After experiencing the error message follow these steps to permanently resolve the issue
  1. Click Revenue > Batch Entry
  2. Click Batch Templates > Click the arrow next to your Constituent Update batch template
  3. Click edit
  4. Once the edit batch template screen loads, click the save button without making any changes

Steps to Duplicate

  1. Click revenue > batch entry > add
  2. Choose the constituent update batch template
  3. Enter an organizations information into the batch
  4. Click validate


 Altru Arts & Cultural

Was this article helpful?