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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.