web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

Order Management - Shipper stuck at "Update Shipper" status

(0) ShareShare
ReportReport
Posted on by 1,000

I'm wondering if anyone else has come across issues with hanging shippers in Order Management. We have two clients, and today added a third, where the shipper will hang for no apparent reason. Nothing we can do will get it to release.

As part of the process, we look at the following suspects :

The ship complete flag is not turned on.
The customer is not on hold.
The inventory items have enough stock on hand to process the order.
The dates on the order are not in the future.
The order type steps appear fine.
Event history looks fine up to the update step.
Process manager is running.
There is no error message in the Shipper Update Log Viewer.
We try the Release/Confirm step again (this will sometimes fix the problem, maybe 30% of the time).
Look at this order in SQL against a completed shipper to see if there are differences in the database information that would cause it to hang.
 
 There's nothing helpful in the KnowledgeBase.
 
The clients usually work around by cancelling the shipper, and allowing Process Manager to create a new one which then releases fine. But this is frustrating, we've spent a lot of time on it, and we still don't have a resolution.
 
Any ideas?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    kevinmcg Profile Picture
    455 on at

    Take a look at Credit Manager's Assistant in Order Management Inquiries (40.170.00)

    It might be your credit checking on the customer that causes it to go into credit hold.

    Just open up Credit Manager,hit Refresh ,Select the Shipper/Order and check off RELEASE

    Then Save and Finish.

    .

  • TomMalia Profile Picture
    325 on at

    I know this post is really old.... but I'm dealing with the exact same problem right now so I was wondering if anyone ever found a resolution to this.?

  • Mark E Profile Picture
    6,451 on at

    I occasionally run into situations where the Shipper is "stuck" in the Update Shipper status, and the below script is often the cure.  This can "nudge" the Update Shipper proc to move the Shipper forward.

    --Run this script when there are Shippers in an Update shipper status and clicking the Finish button on the --Shipper does not move the Shipper to the Print Invoice step

    SET QUOTED_IDENTIFIER OFF SELECT "exec ADG_Release_For_Update '" + rtrim(CpnyID) + "', '', '" + rtrim(ShipperID) + "'" from SOSHIPHEADER where NextFunctionID = "4043000" and NextFunctionClass = "0200"

    --Paste the RESULTS of the above query into another query window and execute.

    --This should re-queue the affected Shippers for updating.

  • TomMalia Profile Picture
    325 on at

    Thanks Mark.  I had found a tech. bulletin that suggest the same script and was about to try the same thing... however in my case I think there might be a little bit of a difference... maybe not and maybe you can let me know if you see an error in my logic.

    The TB that had the same script you posted was for a Shipper that got stuck when it was being "canceled" where in my case the shipper is stuck being released.  In the script you posted, the "NextFunctionClass" is "0200" which I'm guessing is the function class for "cancel".  In my Shipper, the "NextFunctionClass" is "0100" which I'm guessing is the class ID for "Release" and subsequently I would need to replace '0200' with '0100' but otherwise all else should be the same.  Does this sound correct to you?  Anyone see any flaws in this logic?

    Thanks all.

  • TomMalia Profile Picture
    325 on at

    I wanted to follow up with what I found.... Whether the shipper needed to be requeued or not, I don't know, but in the processing of doing so I found the following:

    I tried requeuing  the shipper by calling

    exec ADG_Release_For_Update 'US', '', 'FLRS-01442'

    But nothing happened.  Then I tried again and ran a trace an noticed that it was executing the following query which I’m 99% answers the mistery:

    select * from SONoUpdate where ….(Shipper ID info here)

    When I query that same table, the shippers that a problem show up with messages like:

    The status for project P0005400000 is Plan.                                                                                              

    The status for project P0002400000 is Plan.                                                                                    

    The status for project P0002400000 is Plan.                                                                                    

    Line 00017 missing from sales order 11-2613.

    So, it appears that there were perfectly good reasons why the shippers were "stuck"

    Now, where and how you would find this problem in the standard UI, I don't know and if someone with more familiarity with Order Management than me can fill in that blank, I'd certainly be interested in the answer.                                                                                          

  • Mark E Profile Picture
    6,451 on at

    You have to look at the combination of the NextFunctionID (4043000) and the NextFunctionClass (0200).  In standard SOType setups, this combination matches the "Update Shipper" step in the SOStep table, which calls the "ADG_Release_For_Update" proc.

    The SONoUpdate table is exposed in the Shipper Update Log Viewer screen in the OM Module, Inquiries section.

  • Community Member Profile Picture
    on at

    Couldn't Microsoft use the word "inactive" instead of "plan" for describing the status?  What is "plan" supposed to mean?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans