I have some really weird issues with assembly orders, and cannot for the life of me figure this out. Wondering if anyone else has seen anything like this. I have assembly orders linked to lines that are not assembly orders. This is causing headaches as it's messing with demand numbers and causing our picking tickets and order confirmations to print extra items.
Here is a sales order we have, note, line 10000 and line 130000 are Assembly Items, and the Qty to Assemble to order is properly populated. These are the only two assembly items on this order.
Table 904 is the Assemble-to Order Link Table, based on above, we'd expect two entries there, no? Well, I have 4! Lines 10000 and line 130000 correctly have assembly orders linked to them. However, Lines 30000 and line 15000 also have assemblies linked! Line 30000 is not an assembly item, and line 150000 isn't even of Type Item, it's just text.
Now, if i search my assembly orders for those for four (3590,3588,3591,3589) there are only 3 actual assembly orders.
To summarize... 1 order, 2 assembly items on it. 4 assembly orders linked to it, 3 actual assembly orders. I've tried every which way to duplicate this, but haven't figured it out. It's happening enough that it's not a random fluke, but I cannot duplicate this in a test, I'm only finding these as they appear in our live data. In this example the big problem is line 150000 as that is linked to an assembly order that really exists.. my pick tickets will show to pick components for a line that's not even an item! Line 30000, while it has a link to an assembly, isn't really troublesome as the linked assembly order doesn't actually exist, so that weird, but not causing issues.
The closest I've come to duplicating is this:
I add an assembly item to order, add qty. which populates the qty to assemble to order and an assembly order is created. I think zero out the qty and the qty to assemble to order, change the item number to something that's not an assembly, then give it a quantity. The assemble link remains in this scenario... table 904 will show an assembly order linked to an item that isn't an assembly item. However, in this scenario the actual assembly order deleted itself as you'd expect, so, it's not causing an issue. I cannot recreate the situation we see above where both the link, and the actual assembly order remain.
Any insight to this will be greatly appreciated!
What version of NAV? Do you have any mods or are you importing data into the sales order?
Sorry, forgot to note the version, this is 2016. Nothing is importing to Nav, this error is coming when a sales orders are directly entered into Nav by our sales staff.
If you've found this thread useful, dive deeper into User Group community content by role