Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Shipper stuck on Updat...
Microsoft Dynamics SL (Archived)

Shipper stuck on Update Shipper step, has invoice number.

(0) ShareShare
ReportReport
Posted on by Ed Leffler 155

We have a sales order, shipper, and invoice which never shows up on any Sales journal.

On the Shipper windows 'Other Information' we see the invoice number, date, and period to post, but no sales journal number. The 'Next Step' is report as Update Shipper.

Process Manager is running.

Running the sales journal (for this single shipper) returns a blank report, and the shipper remains open. I have no IN batches suspended or otherwise unreleased.

After bringing up the shipper, pressed finish, something happens to cause mouse to change to hour glass and back, screen goes to "new shipper". When I bring the shipper back up, I see no changes.

Event history shows "Modify Shipper" for each of the several times I have trued to update it.

Doesn't show up in the shipper update viewer log.

Not sure what to do next.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Shipper stuck on Update Shipper step, has invoice number.

    First, let's look in the Shipper Update Log Viewer - do you see the Shipper id listed in there?  If yes, what is the explanation showing?

    If it is not there - run the following in query on the application database:

    SET QUOTED_IDENTIFIER OFF

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

    Does your Shipper id show in the results pane?  If yes, do the following:

    Stop  Process Manager

    Paste the results of the above query (minus the first column header line and the last row count line; i.e., only the lines that start with "exec") into another query window and execute. This should requeue the affected Shippers for updating.

    Start Process Manager to update the Shipper to the Print Invoice step.

  • Tracy Meyer Profile Picture
    Tracy Meyer 10 on at
    RE: Shipper stuck on Update Shipper step, has invoice number.

    Hello Ed,

    What build of SL are you working with and have there been any changes / customizations made recently to the shippers screen (40.110.00), or changes in the steps tab in order types screen (40.200.00) before the existing shipper was closed?  

    Tracy

  • Ed Leffler Profile Picture
    Ed Leffler 155 on at
    RE: Shipper stuck on Update Shipper step, has invoice number.

    I tried all of that before I posted, Unfortunately it didn't help.

    Our shipper is stuck in a different step and does not show up in the Shipper Update log and also does not have a work order.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Shipper stuck on Update Shipper step, has invoice number.

    This sounds like an issue I just resolved this morning with the help of 'Mark E.' The shipper showed an invoice number, and period to post, but no Sales journal.

    Also, you may want to check the information in the 'Shipper Update Log' for other possible problems. In my case, I found that the work order tied to the sales order was 'on hold'. Once I opened the order, and ran the query below, everything worked out and the shippers closed with the invoice showing on the next Sales Journal.

    You can execute the following query, and paste the results into a new query, which will re-queue the Shipper for update.

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

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans