Month: December 2017

Run On-Demand Workflows on bulk records using XrmToolBox – bulk workflow execution

Microsoft Dynamics CRM On-Demand workflows are great and help in so many ways/

you can easily run these on records such as 100 , 500, 1000 & may be on 2000? But wait… how about 10000 records? thats where it might become very hectic but with introduction of a new plugin/tool in XrmToolBox – it has become very easy. – thanks to Andy Popkin 🙂

All you have to do is download XRM toolbox from the main website or github :

Now once you have this tool and extracted – you might not have the bulk workflow execution tool in it. you will have to go to plugin store from the xrm tool and add it as belowpluginstore

once you go there it will give you hell lot of plugins you have to look for “bulk workflow execution” plugin and install it as below :


once this is done you should be able to search this tool in your XRMtoolbox :


double click on it and get into action

  1. make sure your workflow is already is configured to run as ondemand
  2. all ondemand workflows in the organization will come under the dropdown i have highlighted.
  3. once you select the wofklow – it will give a list of all views from the entity which is a primary entity of the workflow. you can select the view and run your workflows on view returned records.
  4. you can also define your own custom fetch XML query ; which we will do now.


here i am using the below fetch XML as an example :

<fetch distinct=”false” mapping=”logical” output-format=”xml-platform” version=”1.0″ >

<entity name=”task” >

<attribute name=”subject” />

<filter type=”and” >

<condition attribute=”scheduledend” operator=”null” />

<condition attribute=”statecode” operator=”eq” value=”0″ />

<condition attribute=”createdon” operator=”on-or-before” value=”2017-12-15″ />





you can click on validate to validate your query ; once your query is confirmed you will have run workflow button enabled next to it and also will show how much record it has retrieved. click on the run workflow button and see the action :


it will work like a charm and will definitely save alot of your time.

i will be sharing more cool add-on in XrmToolBox because i am a fan of this tool ; so stay tuned.





Escape from waiting condition workflows – Microsoft Dynamics CRM

Waiting condition workflows are definitely great and almost perfect for the functionality where you have to wait for months for something to be triggered.

but are they really good ; should actually keeping them alive for months is a good idea? Well there are certain measures that you can take if you really need them :

  • Combine waits and check condition. So you have a process that emails a customer service representative three days after the case is open. No need to email them if the case has been closed, right? After the wait, have the workflow check conditions to verify that the condition that triggered the workflow is still true. If not, cancel , but stop it.
  • Use a child workflow to do something when wait time is over.
  • Use short wait periods. 20  minute waits are ok. 1 year waits are bad.
  • Use timeouts rather then wait condition.


however apart from the above there is another way which can be effective in terms of your organization performance.

Create an entity to keep the crucial date or timestamps on which you want to do something.

  1. create an entity(workflow task) , with fields as “regarding” & “Due date”.
  2. In your workflow – if you need to do something for example 20 days before the expiration date – calculate that date and create a a new record for the entity created(workflow task) with regarding as the current record and the date in due date field.
  3. Stop your workflow – just end it right there.
  4. Create a bulk delete job -that you should run everyday which checks for the records who’s due date is today and delete them.
  5. Create a workflow on the new entity created(workflow task) – run it on deletion of the record and do the actual things you wanted to on your record from that workflow for example closing the activity , sending email etc.


Best thing about this approach this that you can continue using this logic in your organization with n number of records & entities.


let me know your thoughts on this.

Cheers !

Sample Questions & Tips for Exam MB2-713: Microsoft Dynamics CRM 2016 Sales

It is the most difficult and interesting crm certification i have come across.

i am going to give you some tips and sample questions that you can expect.

  1. understand the CRM sales process :
  2. guidance from a champion :
  3. finally some sample questions:

1.Your Dynamics CRM organization uses Microsoft Yammer.
You plan in enable integration with Yammer to replace the default CRM activity feeds.
You need to identify which security rights are required to enable the integration.
Which two security rights should you identify? Each correct answer presents part of the solution.
A. Dynamics CRM administrator
B. Dynamics CRM System Customizer
C. Yammer administrator
D. Microsoft SharePoint administrator
E. Microsoft Office 365 administrator

Answer :AC

2. You Open the My Open Opportunities view,
You need to export the data in the view, and then to reimport the data so that the existing records are
What should you do?
A. Export the data as a dynamic Pivot Fable.
B. Export the data as a Static worksheet.
C. Export the data and select the Make available for re-import option.
D. Export the data as a dynamic worksheet

Answer : B

3.You have a recalled product that should no longer be sold.
You need to remove the. Product from the available list of products and to prevent any sales from being
processed for the product.
Which two actions should you perform? Each correct answer presents part of the solution.
A. Remove the product from the family hierarchy.
B. Modify the open opportunities.
C. Update the price list.
D. Retire the product.
E. Modify the validity date of the product.


4.You have an existing customer named customer1.
You have a new add-on product for an existing product that you sell.
You want to offer the add-on product to a customer who has purchased the existing product already.
You need to track the sales initiative in Dynamics CRM.
What should you do?
A. Update the original opportunity record.
B. Create a new opportunity record for the new offering.
C. Create a sub-account for the new offering.
D. Reopen the original opportunity record.

Answer : B

5.Your marketing team is promoting a sale that they will announce by using email. The email message will
be sent to existing customers who recently purchased similar products and to potential customers from
a purchased mailing list.
Any sales made as a result of the sale need to have the pricing applied, the sales must be tracked so that
the marketing team can report on the return on investment (ROl) of the initiative.
What are two possible ways to achieve the goal? Each correct answer presents a complete solution.
A. Convert the email activities to leads.
B. Convert the campaign response activities to opportunities.
C. Convert the campaign response activities to leads.
D. Convert the email activities to opportunities.

Answer : BD

6.You have a Dynamics CRM organization that has several currencies enabled. What occurs when a user
creates a record that has a currency field?
A. The currency is based on the sales territory of the user.
B. The currency is based on the location of the user record.
C. The currency is converted into the base currency and is always displayed in the base currency
D. The system default currency is the record default, unless a customer has a default currency

Answer : D

7.You company employs consultants who bill customers for their time.
You sales team is responsible for selling the consultants time, in addition to selling product licenses.
You need to provide the sales team with the ability to create opportunities, quotes, and invoices for the
consultant’s time.
What should you create first?
A. a product family
B. a price list
C. a product bundle
D. a unit group

Answer 😀

8.Your company plans to deploy Dynamics CRM.
In the previous sales database, you did not track products
Members of the management team are evaluating whether to use the product catalog in the CRM
organization. You need to identify which enhancements to the sales flow can be achieved by using the
product catalog. What are two possible enhancements that you can identity? Each correct answer
presents a complete solution.
A. inventory management integration
B. automated sales pipeline velocity tracking
C. automated revenue calculation
D. automated quotes, orders, and invoicing

Answer :CD

9.Your company has a Dynamics CRM organization.
The company plans to use the product catalog.
You need to identify which component must be configured before you can implement the product
A. product families

B. product
C. price lists
D. unit groups


Answer : D

10.You need to identify which type of object can be associated to sales territories. Which type of object
should you identify?
A. Opportunities
B. Users
C. Leads
D. Facilities
E. Teams

Answer : B


Hope this helps

you can write to me @ if you need any support.


The CRM Mailbox incoming and outgoing email field is setting to “None” Microsoft Dynamics CRM 2016

I had a strange issue in production ,so whenever we were doing a deployment ( reference data +solution). After the deployment the mailbox settings incoming email and outgoing is getting set to “None” rather then “Server – side synchronous or email router”.

After performing multiple steps/deployments; I  found the solution to this issue.

I use migration utility tool to export and import the reference data.

Please see below steps:

  1. Removed the default mailbox field from the queues schema, exported the data and deployed to internal test. However it didn’t work and still was taking the incoming outgoing setting from dev; hence made it none again. <field displayname=”Mailbox” name=”defaultmailbox” type=”entityreference” lookupType=”mailbox” />



2. Then I started looking these two fields (incoming and outgoing email) in the schema and found below :

<field name=”incomingemaildeliverymethod” value=”0″ />

<field name=”outgoingemaildeliverymethod” value=”0″ />


I removed these two properties and I could see it was excluded from the mailbox update.


moral of the story : queue will have so many fields dedicated for its mailbox. we have to make sure what will update what.

hope this helps


Microsoft Dynamics CRM 2016/2015/2013- Dynamic and Static Marketing List

This has been a most population concept in marketing module of CRM ; i would like to share some crucial difference between them:

Dynamic marketing lists is able to save time and ensured that everyone that should be on the list was on the list.

A Static marketing list is a snapshot in time. You add the contacts you want in that marketing list depending on certain criteria…and that was it. If a new contact is added to the CRM database you can manually add them to the marketing list, or if the marketing list is no longer relevant to a contact you can manually remove them.

Dynamic marketing lists removes the manual element. You can create a query (e.g. all customers where their country equals Ireland). This means that any contacts with “Country = Ireland” will be added to the list. As you add new contacts to the CRM database, they will automatically be added to the marketing list if they live in Ireland. If a contact moves and the Country field in the contact card is updated, then they will be automatically removed from the marketing list.


Some other major differences below :

Dynamic List Static List
Member types Leads, Contacts or Accounts Leads, Contacts or Accounts
Adding members The query to select members automatically adds records which meet the criteria You can manually add records using the Add to Marketing List button
Manage Members – Add records using a lookup
Manage Members – Add records using an advanced find
Removing members Members are automatically removed if they no longer meet the dynamic list query criteria Manage Members – Advanced find to Remove records
Manage Members – advanced find to evaluate members
Blocked attribute You cannot block a dynamic list (you can use the copy to static button to copy the members of a dynamic list to a new static marketing list) You can block a static list, which stops members being added or deleted.
Updating list members automatic Manual – a static list has to be updated manually.
deactivated records/members Automatically excluded from the list
Can lists be added to a campaign Yes – All marketing lists can be added to a campaign and both static and dynamic can be added to the same campaign Yes – All marketing lists can be added to a campaign and both static and dynamic can be added to the same campaign


Happy CRM 🙂 cheers!!