Guys, I have a problem!
I need to change the status of a product to inactive after the expiration date (system field) is exceeded. What is the best solution for this?
Tks
*This post is locked for comments
Guys, I have a problem!
I need to change the status of a product to inactive after the expiration date (system field) is exceeded. What is the best solution for this?
Tks
*This post is locked for comments
tks! It worked!
Hi,
You can create a Microsoft flow that runs on scheduled time, see the sample from my worklog
Hi Silasdoug,
First of all I think you should go through with recurrence job to execute console on daily basis to check if any product is about to expire on given date.
You can use to different approach to execute job based on type of CRM environment.
1. If you are using CRM on- premise then go through with console app and create task scheduler to execute it on daily basis. Inside console application you can check any product is having expiry date today.
2. If you are using CRM - Online then go through with plugin approach. Create third entity record and delete that record on daily basis to execute your plugin. Inside plugin after updating product status again create third entity record.
3. Create custom activity workflow to check expiry date and update status of product accordingly.
Hello,
I would recommend either daily SSIS job or recurrent workflow:
kaskelasolutions.com/schedule-workflows-in-dynamics
alexanderdevelopment.net/.../updated-solution-for-scheduling-recurring-dynamics-crm-workflows
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,269 Super User 2024 Season 2
Martin Dráb 230,198 Most Valuable Professional
nmaenpaa 101,156