Error: Cannot insert the value Null into column 'REVENUESPLITID', table 'BBCRM_Prod.dbo.REVENUESPLITBUSINESSUNIT'; column does not allow nulls. INSERT fails. when adjusting the business units on a pledge through Enhanced Revenue Batch

When adjusting the Business Units on a pledge in an Enhanced revenue Batch, this error occurs:

“Cannot insert the value Null into column 'REVENUESPLITID', table 'BBCRM_Prod.dbo.REVENUESPLITBUSINESSUNIT'; column does not allow nulls.  INSERT fails”
Download and install the latest version and patch if applicable.

Steps to Duplicate

  1. Go to Batch Entry
  2. Create a new Enhanced Revenue Batch
  3. Add a pledge and populate the required fields
  4. From the "Revenue" tab in batch, click "Business Units" in the Revenue Details section
  5. Highlight the application; click Edit
  6. Check the box to Override business units and give a reason
  7. Choose a business unit from the dropdown and apply the full amount to that business unit
  8. OK
  9. OK
  10. Update projected totals
  11. Validate
  12. Observe error
 
 

Environment

 Blackbaud CRM
 3.0
 4.0

Was this article helpful?