Skip to main content

Notifications

Announcements

No record found.

Supply Chain Management forum
Unanswered

Reset Status Production Order in Batch Job

Posted on by 45

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?

Categories:
  • NickLaenen Profile Picture
    NickLaenen 45 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
    ToddB 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
    NickLaenen 45 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
    GeorgeC 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?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans