Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Get Days in Current Status for Inactive Orders

Posted on by 1,320

On the Order entity, I have a custom workflow that takes the DaysDiff between two date fields and places that whole number in a field on the Order. This is to track how many days an order has been in the current status reason. My issue is the records are in the Inactive state so I cannot Update Record with the whole number. Is there a workaround to getting the Days in Current Status on Inactive records?

*This post is locked for comments

  • Verified answer
    prt33k Profile Picture
    prt33k 6,907 on at
    RE: Get Days in Current Status for Inactive Orders

    Hmm... the other way would be to create child entity for order and store your field there. You can put the child entity quick view form on order form so that update will be visible(it will be read only though).

    So even when order get deactivated, you will have freedom to update the child record and get the changes reflected on form and views.

    Thanks,

    Prateek

  • epark06 Profile Picture
    epark06 1,320 on at
    RE: Get Days in Current Status for Inactive Orders

    Thanks, but unfortunately I don't think that's wise in my case because I am running this workflow every night on over 1K records. Toggling the status may pose problems because the statuses are tied to some processes with GP.

  • Suggested answer
    prt33k Profile Picture
    prt33k 6,907 on at
    RE: Get Days in Current Status for Inactive Orders

    Hi,

    You wont be able to update inactive order.

    You need to first change the status to Active, Update it and then change it back to fulfilled.

    In workflow, something like this:

    Caporderwfture.PNG

    Thanks,

    Prateek

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans