Creating a workflow process for Product Order in CRM Dynamic 2015

Hi, I need help in creating a workflow which will send an email alert for when orders that have product purchases over $5,000 and the order status must be Fulfilled.

The issue I'm running into is when the user adds an product to the order via Product & Lot grid, they refresh the grid and save, then it doesn't trigger the email action. The email only sends when the user does not hit save or refresh the Products grid but add the product and hit FULFILL order. (See PRODUCT-GRID.PNG)

I believe that grid section is customized by some external consultants...please correct me if this is not out of the box for Orders Information page for Dynamic CRM. Any other solution to get around this to trigger the email to check the price after an order is fulfilled?

Here are the settings:
 The "Start when: Record is created and Record fields change" have been checked and set only the Modified On box on the Record Fields change. (see images: WF-PROPERITIES.PNG and RECORDSFIELDSCHANGE.PNG)
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

teknovationAuthor Commented:
Rikin ShahMicrosoft Dynamics CRM ConsultantCommented:

The grid surely is customized and not OOB feature. In this case you don't have any control as you're not in control of what grid does here.

What I can guess here is when user hits Fulfill order button, then only the grid/process saves all the order products to CRM and not when you add any product to grid. When you add products it only shows you order products  logically added to the CRM/record until you fulfill the order.

I do not think there is much scope here for your requirements as an editable grid is provided to alter the order/products. However you will be able to get clear understanding of how the grid and order products save process work from the developer/consultant who has developed it before. And he may be able to help you achieve what you desire.

Give this a try (with my wild guess): Add products to the grid and hit save to the CRM record and check if that triggers email or not.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
teknovationAuthor Commented:
I've requested that this question be deleted for the following reason:

Custom app
Rikin ShahMicrosoft Dynamics CRM ConsultantCommented:

I gave the answer as per your question and suggested some tricks as well. I do not see any point why you want to delete the question and would not like to assign any points to my answer?!?
teknovationAuthor Commented:
It's not a big deal. I just thought to be fair, it's a custom solution which you cannot offer anything further and what you've suggested is something I've already tried prior to posting this so it wouldn't be beneficial to anyone reading this post looking for a solution to a similar problem. Anyways, I've awarded you your points, thanks for trying to help though. :-)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Dynamics

From novice to tech pro — start learning today.