Category Archives: Dynamics

GP 2010 Item last sold: Including BOM components

Starting with the SQL view for last sale by customer and item by Victoria Yudin with a couple modifications.  I created some queries to recursively capture all of the components associated with the items sold as well and where they are … Continue reading

Posted in GP, GP 2010, GP SQL | Leave a comment

ClickDimensions: Fancy Formatting Forms

I do think Click Dimensions is a pretty good content style management tool for CRM 2011.  Although you are extremely limited in the formatting of forms.  The labels have to go on top of the text box, the submit button … Continue reading

Posted in CRM 2011, Dynamics | Leave a comment

Dynamics Connector: The CrmReference mapping query returned no results for property

First I want to give a huge thanks to this blog: This blog had the exact solution to a problem that was difficult to diagnose and then finding a fix seemed near impossible. I have committed to using the Dynamics … Continue reading

Posted in Connector for Microsoft Dynamics, CRM, CRM 2011, Dynamics | 3 Comments

CRM 2011 Plugin causing “Could not load file or assembly ‘Microsoft.Xrm.Client” error

I know I am not the first person to come across this error.  I see a lot of solutions out there to resolve this error.  This is how I resolved this error. First for a little back story.  I have … Continue reading

Posted in CRM, CRM 2011, Dynamics | 1 Comment

CRM 2011 Customer Portal: Adding Paging and Sorting to Caseview

A Customer Portal is only as good as it is User/Customer Friendly.  One of the things that I have been asked is… Can you add sorting and paging to the case view?  No matter how you sort the result set … Continue reading

Posted in CRM 2011, Customer Portal, Dynamics | 4 Comments

Microsoft Connector V2 Upgrade GP 2010 to CRM 2011: Gotchas and Improvements

This connector version is a substantial improvement.  I will say that we are doing pretty basic integration, mostly OOB with a couple changes to the maps.  Nothing overly exciting. That is why it surprised me when we had issues with the previous … Continue reading

Posted in Connector for Microsoft Dynamics, CRM, CRM 2011, Dynamics, GP | 2 Comments

Connector for Microsoft Dynamics: a little story about debugging

I have been able to resolve most of the issues by using the DynamicsWebServicesExceptionsConsole but this problem was even hosing up the exception logs “Cannot access the exception service. Verify that the configuration file exists and contains the correct path … Continue reading

Posted in Connector for Microsoft Dynamics, CRM, Dynamics, GP | 3 Comments