The status of a shipper is not updated to Closed and the Shipper Update Log Viewer (40.460.00) screen does not include an entry for the shipper ID in Order Management in Microsoft Dynamics SL

Symptoms

After you complete or cancel a shipper, the value in the Status box is not updated to Closed in Order Management in Microsoft Dynamics SL.

Note The Status box appears on the Other Information tab in the Shippers (40.110.00) screen.  Additionally, the Shipper Update Log Viewer (40.460.00) screen does not include an entry for the shipper ID. 

Cause

Cause 1

The Delay Shipper Update setting is incorrect. See Resolution 1.

Cause 2

The sleep time setting for Process Manager is too small. See Resolution 2 

Cause 3 

The Update Shipper step on the Steps tab in the Order Types (40.200.00) screen is set up incorrectly. See Resolution 3.

Cause 4 

The order type was changed on the Steps tab in the Order Types (40.200.00) screen before the existing shippers were closed. See Resolution 4.

Cause 5 

Customizations were added to the Shippers (40.110.00) screen that interrupted the processing of the shipper records. See Resolution 5.

Cause 6 

Any cause other than cause 1 through cause 5.  In this case, this problem occurs regardless of the order type. See Resolution 6 or Resolution 7.

Resolution

Resolution 1

Verify that the setting to delay the shipper update is not too large. To do this, follow these steps:

1. In the Module menu, click Order Management.
   

2. In the Order Management pane, click Order Management Setup under Setup.
   

3. On the Other tab, make sure that the value in the Delay Shipper Update (minutes) box is not too large.
   
   Note If the Delay Shipper Update (minutes) value is set to 30, the shipper will not close until 30 minutes after you complete the shipper record.

Resolution 2

Increase the sleep time for the Process Manager process. To do this, follow these steps:

1. In the Module menu, click Order Management.
   

2. In the Order Management pane, click Order Management Setup under Setup.  
   

3. On the Other tab, type 15 in the Process Manager Sleep Time (seconds) box if the value in the box is smaller than 15.
   

Resolution 3

Correct the status for the step in the order type. To do this, follow these steps:

1. In the Modules list, click Order Management.
   

2. In the Order Management pane, click Order Types under Maintenance.
   

3. In the Order Type box, type the order type ID that you want to change.
   

4. On the Steps tab, click Required in the Status for the Update Shipper step.
   

5. Click Save. Then close the Order Types (40.200.00) screen.
   

Resolution 4

Cancel the shippers and the related sales orders. To do this, follow these steps: 

1. In the Modules list, click Order Management.
   

2. In the Order Management pane, click Shipment Confirmation under Input.
   

3. In the Shipper ID box, type the ID of the shipper that you want to cancel.

4. Click to select the following check boxes:

   • Cancel Shipper 

   • Cancel Order 

5. Click Finish. Then, close the Shipment Confirmation (40.117.00) screen.
   

Resolution 5 

Remove customizations for the Shippers(40.110.00) screen. To do this, follow these steps:

1. Close all screens except the Shippers(40.110.00) screen.
   

2. On the Customize menu, click Customize Mode.
   

3. On the Customize menu, click Remove Changes For Screen.
   

4. Click Yes, and then click OK.
   

5. Close the Shippers (40.110.00) screen. Then open the screen.

Resolution 6

Change the order of the shippers to an order that is recognized by Process Manager. To do this, follow these steps. 

Note Before you follow the instructions in this procedure, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.

1. In the Process Manager (40.400.00) screen, click Stop.

2. Using Microsoft SQL Query Analyzer or Microsoft SQL Server Management Studio, run the appropriate statement against the application database.

3. • Microsoft SQL Server 7.0
     

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

   • Microsoft SQL Server 2000 or Microsoft SQL Server 2005 or Microsoft SQL Server 2008
     

     SET QUOTED_IDENTIFIEROFF SELECT "exec ADG_Release_For_Update '" + rtrim(CpnyID) + "','', '" + rtrim(ShipperID) + "'" from SOSHIPHEADER whereNextFunctionID = "4043000" and NextFunctionClass = "0200"

     
     

4. Copy the results of the statement into a new window. Exclude any column headings or row count lines. Then run the new statement to requeue the shippers that are listed.
   
   Note The following statement is an example of the results that you would copy.

   exec ADG_Release_For_Update '0060', '', 'S0009868'

5. In the Process Manager (40.400.00) screen, click Start.

Resolution 7

Cancel the shipper. To do this, follow these steps:

1. In the Modules list, click Order Management.

2. In the Order Management pane, click Shippers under Input.
   

3. On the Other Information tab, click to select the Cancelled check box, and then click Finish.