Open Forum

Expand all | Collapse all

Troubles with Assembly Orders

  • 1.  Troubles with Assembly Orders

    Posted Aug 12, 2016 03:42 PM

    Hi All,

    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!

    Frank Irons
    Brown Deer WI

  • 2.  RE: Troubles with Assembly Orders

    Posted Aug 15, 2016 06:56 AM

    What version of NAV? Do you have any mods or are you importing data into  the sales order? 

    Ron Ketterling
    Business Automation Specialists of MN, Inc.
    Minneapolis MN

  • 3.  RE: Troubles with Assembly Orders

    Posted Aug 15, 2016 08:13 AM

    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.

    Frank Irons
    Brown Deer WI

  • 4.  RE: Troubles with Assembly Orders

    Posted Jan 25, 2019 08:57 AM
    I realize this is an old post, but I'm curious if anyone has found a solution to the issue described.
    We are seeing a similar problem in NAV 2016.


    Tim Harden
    Brookfield Equinox

  • 5.  RE: Troubles with Assembly Orders

    Posted Jan 25, 2019 09:10 AM
    ​The text lines coule be coming from Item Extended Text.

    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    BCUG/NAVUG All-Star
    BCUG/NAVUG Board of Advisors, Chairperson
    BCUG/NAVUG Programming Committee

    Twitter: @RosenbergL

  • 6.  RE: Troubles with Assembly Orders

    Posted Feb 20, 2019 01:08 PM
    Thanks for the comment, Lewis.  You are correct that the OP's text lines could be coming from Item Ext Text.
    However, I'm still stuck with the issue of the Assembly-to-Order Link table being out of whack (similar to what the OP showed in his screen shots).

    In my case, I have records in that Link table (and even actual Assembly Orders) that link back to Sales Orders that are already completely closed/posted.  I can't delete the Assembly Orders because NAV 'thinks' they are linked to a Sales Order (due to the Link table), but the Sales Order no longer exists.

    I suppose to correct this issue I need to have my SQL guy clean up the Link table, but I'm curious if there is a better way to correct this issue.

    NAV2016, no ATO/SO mods, SO's are created manually (no imports).

    Tim Harden
    Brookfield Equinox

If you've found this thread useful, dive deeper into User Group community content by role