I’m seeing some odd issues with a particular order. The OrderDtl & OrderRel tables are in play here.
All that is needed is 2 lines being shipped to the same customer. However, the release customer number on line 1 is different from the rest of the order. And when I look in the DB I see this…
The person who entered the order has no idea how this could have happened. We need both release destinations to have the ShipToCustNum be 994. This whole order is for customer 994.
Any insight on what could have caused this, and how to resolve?