Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Unanswered

Reset Status Production Order in Batch Job

(0) ShareShare
ReportReport
Posted on by 51

I'm having problems with re-scheduling production orders in a bath job. Currently we do re-schedule all production orders in status Scheduled again in a batch job, which is working fine. Now we want to be able to schedule a group of production orders in another scheduling direction (Backward from delivery date instead of Forward from tomorrow). 

To make this happen, I'm trying to reset the status of all production orders with current status Scheduled (to Estimated), to make sure they are out of the scheduling. After this I will re-schedule in two separate batch jobs.

When running the batch job to reset the status of the production orders, the first run works without problems. But when running the batch job for the second time, I do get an error mentioning "The status cannot be reset from Estimated to Estimated on production 3884 because of the parameter setup."

As far as I can see, the batch job is trying to reset the status of the same production order. So I thought I forgot the Late Section option, but this function is already turned on. 

Anybody an idea how to solve this problem?

  • NickLaenen Profile Picture
    51 on at
    RE: Reset Status Production Order in Batch Job

    Hi ToddB,

    Thank you for you assistance. I do already filter specifically on the status Scheduled... I will open a support incident.

  • ToddB Profile Picture
    on at
    RE: Reset Status Production Order in Batch Job

    Hi Nick,

    This could be an issue with the filter on the batch job; and you may need to add a filter to weed out orders with an estimated status or something similar.

    If you are still needing assistance, and/or believe this is a bug, please open a support incident with Microsoft.

  • NickLaenen Profile Picture
    51 on at
    RE: Reset Status Production Order in Batch Job

    Hi George, many thanks for your input. it seems to be a bug in D365... I need to think about a workaround.

  • GeorgeC Profile Picture
    1,865 on at
    RE: Reset Status Production Order in Batch Job

    I was able to reproduce your issue in my environment, using a simple selection filter ProductionOrder.Status = Scheduled (with an additional filter on the range of production order numbers, because I did not want to reset too many orders). Same error - the system tried to reset the status of the same production order again.

    It might be a bug. I noticed two things:

    On some batch task forms (e.g. Purchase order confirmation), when you activate Late selction, the form updates and displays the filter criteria instead of the list of selected records. The Reset status form keeps showing the list of selected records. A sign that Late selection is not applied?

    When I opened the select filter, there was already a line with ProductionOrder.Status = (ProdStatusSysQueryRangeUtil::prodStatusBetweenCostEstimatedAndReportedFinished()). I was able to change it to "Scheduled" but maybe it still affects the query?

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,311 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,183 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans