Questions Problem With Drop-Ship Invoicing Locked "drop ship lines on PO are not linked to any sales order lines"

This is an error we ran into occasionally. Although we never pinned down the exact cause, I do have some notes on how to fix individual orders. Hope this helps!

Symptom: When attempting to prepare an invoice for a DI sales order the action will fail and display the error message. “SO Error: Some of drop-ship lines in the purchase orders are not linked to any sales order lines. Check Trace for more details.”

Cause: Root cause unknown – likely related to DI order lines not having the item warehouse field set to ‘DI’.

Solution: Relink the SOLineSplit records in SQL

Select statement to verify:

--Set OrderNbr and OrderType
DECLARE @OrderNbr NVARCHAR(7);
DECLARE @OrderType NVARCHAR(2);
SET @OrderNbr = '9999999';
SET @OrderType = 'DI';

SELECT SOLineSplit.OrderType, 
       SOLineSplit.OrderNbr, 
       SOLineSplit.LineNbr, 
       InventoryItem.InventoryID, 
       InventoryItem.InventoryCD, 
       SOLineSplit.POType, 
       SOLineSplit.PONbr, 
       SOLineSplit.POLineNbr, 
       SOLineSplit.POCreate, 
       POReceiptType, 
       POReceiptNbr, 
       RefNoteID, 
       POReceiptLine.POType, 
       POReceiptLine.PONbr, 
       POReceiptLine.ReceiptType, 
       POReceiptLine.ReceiptNbr, 
       POReceiptLine.NoteID
FROM SOLineSplit
     LEFT JOIN InventoryItem ON SOLineSplit.InventoryID = InventoryItem.InventoryID
     INNER JOIN SOOrderShipment ON SOLineSplit.OrderNbr = SOOrderShipment.OrderNbr
                                   AND SOLineSplit.OrderType = SOOrderShipment.OrderType
     INNER JOIN POReceiptLine ON SOOrderShipment.ShipmentNbr = POReceiptLine.ReceiptNbr
                                 AND SOLineSplit.InventoryID = POReceiptLine.InventoryID
WHERE SOLineSplit.OrderNbr = @OrderNbr
      AND SOLineSplit.OrderType = @OrderType;

Thank you for your suggestion above, however, I have no idea how to apply your suggestion in actual practice.

Incase anyone else runs across this problem - here's how I was shown to fixed it:

On the PO Screen, for each PO Line, click the VIEW SO DEMAND button  Confirm that each PO line is linked to a SO.   A line that is linked will be listed under the DEMAND with Sales Order Number etc. listed for each item. ** I had one that was, and one that was without a demand

If an item is not linked but needs to be, go to the Sales Order Screen and click the "Mark for PO" check box (the column may be far off on screen, or need to be made visible by clicking the file-cabinet/drop down select looking icon next to the paperclip icon in header above item lines).

Once it is checked, for each line click the PO Link button (Above the Item line Headers)  ** This is where my problem was, never having used this method before or even noticing this button while trying to problem solve.

Select the correct PO to link the SO to from options provided. This successfully linked my PO to SO and vice versa.

Hopefully someone can benefit from my former frustrations; while an easy fix in retrospect, missing one vital step can be quite frustrating! 

SB