Error when converting Lead to Opportunity in CRM 3.0
We just did several custom attributes and fields in the Lead and Opportunity forms.
Now, when we try to convert the lead to opportunity, we get the following error:
Server Error in '/' Application.
The string was not recognized as a valid DateTime. There is a unknown word starting at index 3.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.FormatException: The string was not recognized as a valid DateTime. There is a unknown word starting at index 3.
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Can you check the date settings of the user you're using to try and promote the Lead and compare it with the date settings of the CRM server itself? They could be out of whack which might be causing the issue.
Yes...The Tools-->Options--Formats Tab-->Current Format to check the user settings.
Administration-->System Settings-->Formats Tab-->Current Format to check the organisation setting.
The mapping could potentially be causing an issue as well if the settings are different. You may find that if the settings are the same the mapping will work fine but if they're different then there could be issues.
Excellent! I just hit 'Generate Mappings' which took us back to a time when we knew it was working.... Thankfully there were only 21 mappings we had to do manually, so this shouldn't take long to diagnose...
So, looks like it could be either:
- target field attribute was nvarchar, when source was datetime (or something to that effect)
- Source was system attribute and target is custom attribute?
Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.