Sunday, September 14, 2008

Reset Auto-Numbering counter - CRM 4.0

If you've worked with the default CRM functionality more over with the settings area, you must be aware of figure below. This is the Set Auto-Numbering window :


What if you created a few Contracts or Invoices or any of the mentioned entities in the auto-numbering page and now you want to reset the counter (i.e. the number field of those entities).

Not a good idea, don't even think of it! Well you may, considering all the consequences. Here I'll tell you where the counter values are stored in the database.

Table dbo.OrganizationBase as shown on your left which is stored under OrgName_MSCRM Database.

Take a sneak peek at the table content and you can notice the prefixes and counter value of KB article, Case and Contract entities. Now you can manipulate, AT YOUR OWN RISK!

Friday, September 12, 2008

Thanks to Nithya for.......

Passing CRM Form values to an IFrame

I guess the Title + Hyperlink explains it all. I had this similar requirement to accomplish and I googled "passing crm form values to iframe".

That was it, the first search result was my answer. Thanks for that post Nithya.

Passing CRM Form values to an IFrame

I assume that you have already added an IFrame to the entity amd unchecked "Restrict cross-frame security" under IFrame properties > Security section

PASSING SINGLE PARAMETER TO AN IFRAME :

  • new_customfield1 - Schema name of my custom field.
  • IFRAME_Custom - Name of the IFrame.

Snippet (You may place it on OnLoad or OnChange of the CRM Form as per your requirements)

var CustomFieldValue = crmForm.all.new_customfield1.DataValue;
crmForm.all.IFRAME_Custom.src = 'http://localhost/YourURL.aspx?value='+CustomerFieldValue.

PASSING MULTIPLE PARAMETERS TO AN IFRAME :

  • new_customfield1 - Shema name of first custom field.
  • new_customfield2 - Schema name of the second custom field.
  • IFRAME_Custom - Name of the IFrame.

Snippet

var CustomField1 = crmForm.all.new_customfield1.DataValue;
var CustomField2 = crmForm.all.new_customfield2.DataValue;
crmForm.all.IFRAME_Custom.src='http://localhost/YourURL.aspx?value1='+CustomField1+'&value2=' + CustomField2;

Tuesday, September 9, 2008

Download MS CRM SDK version 4.0.6

Latest Microsoft CRM SDK 4.0.6 is available for download.

Direct yourself to the download page:
Download CRM SDK 4.0.6

Read the New Releases here:
New Release in Microsoft Dynamics CRM SDK v4.0.6