link from sales order to delivery not complete

[keith_taylor2]

2007A

We have a few cases where the link from a sales order to delivery is not complete. For example, we have a sales order with 2 lines on it. We copy to delivery and add. Remarks field has the comment "based on sales order ...." However if you try to get to base document the icon is not available. In looking at the base document, base reference, base line fields on the items they are blank.

We also have instances of this where there were 20 lines on a sales order, we copy to delivery and 19 lines are linked but one is not.

Any ideas as to why this might be happening?

[Former Member · Accepted solution]

Hi Keith ,

It looks like an application error to me if the action is straight forward - copy from SO to Delivery .

If you can replicate the issue , it is definitely a bug and you probably need to test with upgrade if it is happening or not .

So far , I would look for a higher version of patch and see if that issue is particularly addressed and resolved .

Also use this query for more help

SELECT DISTINCT T0.DocNum FROM ODLN T0, DLN1 T1 WHERE (T0.DocEntry = T1.DocEntry) AND (T1.BaseEntry = [%0] OR T1.BaseRef = [%1])

Hope this helps

Bishal

Edited by: BIshal Adhikari on Dec 11, 2009 9:47 AM

[Former Member]

If you changed something like warehouse codes for the line items, the link will be broken between those two documents. You may run a query to compare those lines.

Thanks,

Gordon