Assemble-to-Order Link error

tharden1

Somehow my ATO orders have become out of sync with the corresponding Sales Orders.
I have a Sales Order with only 2 lines on it (one of these has an Assy BOM and is set to replenishment type ATO).

The problem is that the ATO line on my SO has two Assy Orders open for it. When I look at the Assemble-to-Order Link table I see both Assy orders listed, but one of them refers to a SO Line No. that doesn't exist (the other Assy order refers to the correct remaining open ATO line on my SO.

So I have two problems - I can't delete the extra Assy order because NAV believes it is LINKED to a Sales Order (because it's in the Link table). I was able to clear the component lines from that extra Assy order (to remove demand), but the header is still creating Supply. Secondly, how did NAV create this duplicate Assy order (If there had been an additional ATO BOM line item on the SO that was deleted, shouldn't the linked Assy order have also been deleted?).