Welcome to Cognettacloud

9x Microsoft Business Solutions 365 MVP, I'm the CTIO for congruentX and a community Technology Evangelist Delivering Edge Experiences Using Microsoft Dynamics 365, Azure & Power Platform (Power BI, PowerApps & Power Automate) & Office 365

Problems Resolving Cases after upgrade to CRM 2011?

Are you having problems resolving cases after CRM 2011? The key is in the error file, it states Allotment overage is invalid.

This leads to the contractbase. When this data is upgraded from CRM 4 the values are NULL. CRM 2011 does not want the null value. Simply update the existing contractbase using the query below:

update ContractDetailBase set AllotmentsOverage = ISNULL(AllotmentsOverage, 0);

All new cases after the upgrade will not be effected! Enjoy!