Error: Data could not be saved. Arithmetic overflow error for data type tinyint, value = 999 - when selling a membership through Advance sales

When attempting to sale a membership through Advance Sales you may receive this error message: Data could not be saved. Arithmetic overflow error for data type tinyint, value = 999

Article Number: 113131

Products:

Blackbaud_Altru

This error message can be caused by having a membership count that is too high in Altru. For example you may have a membership level that allows 999 members. You would need to reduce the amount of those members to a smaller number. You can process the membership transaction by using Daily Sales or through the constituent's record

Reduce membership count:

Click Memberships > click on the name of the membership
Click on the terms and levels tab > click edit
Reduce the number of members on the membership level
Click save

Process a membership through the Constituent's record:

Click Constituents > Constituent Search
Search for and select the constituent
Click Add a membership > enter the membership information
Click Save to complete the payment

Steps to Duplicate

Click Sales > Advance Sales
Enter a patron on the Select a patron screen
Click on the Create order tab > Click Memberships >Click sell a membership
Choose the membership program and click save

After clicking on the membership program an error message will occur

Environment

Affected Product Altru Arts & Cultural

Affected Version (from previous KB) 4.97

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.

Blackbaud Community

Connect and collaborate with fellow Blackbaud users.

Chat with Support

Chat with our experienced staff to receive help right away.

Connect

The Blackbaud team is online and ready to connect with you!