D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Sequence group's lowest unit does not match inventory unit of the item.

  • 1.  Sequence group's lowest unit does not match inventory unit of the item.

    Posted Mar 27, 2019 11:29 AM
    Hello!

    We received the following critical message when applying a template to a new 'Released Product':

              "Sequence group's lowest unit does not match inventory unit of the item."

    What is causing this?

    (We are new to AX and in the implementation phase.)

    Thanks!

    #UnifiedOperations
    #AX2012


    ​​​​​

    ------------------------------
    Mark Yankovich
    Allegheny Bradford Corporation
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Sequence group's lowest unit does not match inventory unit of the item.

    TOP CONTRIBUTOR
    Posted Mar 28, 2019 06:23 AM
    Hi Mark,

    I have never used it in combination with Product Templates, but in general, this error means that you are trying to set a Unit sequence group ID on the Released product (Warehouse management fast tab), and the Unit sequence group you have selected does not have the item's Inventory unit as it's lowest unit.

    The Item's inventory unit can be seen on the Manage inventory fast tab.

    If you look at the Unit sequence groups you have configured (Warehouse management -> Setup -> Warehouse setup), you need to use one which has the Item's inventory unit set on the first Line.

    Essentially, it means you need to stock the item in the smallest unit which you will put on to the Unit Sequence Group. And if you're not using multiple units on your items in the Warehouse processes, your Unit sequence group need have only one line.

    ------------------------------
    Guy Terry
    Application Consultant
    Annata
    Portsmouth
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Sequence group's lowest unit does not match inventory unit of the item.

    TOP CONTRIBUTOR
    Posted Mar 28, 2019 10:01 AM
    Hi Mark,

    If you are using Advanced Warehousing the first thing you should do is make sure that the inventory UofM for the released product matches the lowest UofM of the Unit Sequence Group ID that is assigned to the product (WM Fast tab > Physical dimension > Unit Sequence Group ID).

    Hope this helps.

    Regards,

    Alison

    ------------------------------
    Alison Wright
    IT/Project Manager
    The Dodge Company
    Billerica MA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Sequence group's lowest unit does not match inventory unit of the item.

    Posted Mar 28, 2019 04:03 PM
    Guy & Alison,

    Thank you both for your responses.  Alison - we are not using Advanced Warehouse at this time.

    Your suggestions were looked into and we found that we were in-line with them in the template that was being used.  We created a new released item - manually entering each field the template had and all worked fine - no error.  The record was deleted and re-created again this time applying the template - the error returned.  We were able to reproduce the error this morning at will.  When we revisited it this afternoon, all worked fine.  At this point, not really sure what changed but all is working as expected.  I will concur that the 'template' itself would not generate the message unless something was not correct in it, but that is the timing of when this error would appear.

    Thanks again for clearing up what the message means as we hadn't a clue what it meant and did not find it online from a search.

    Mark.

    ------------------------------
    Mark Yankovich
    Allegheny Bradford Corporation
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Sequence group's lowest unit does not match inventory unit of the item.

    TOP CONTRIBUTOR
    Posted Apr 02, 2019 09:47 AM
    Hi Mark,
    The unit sequence group ID field is specific to Warehouse management. You would get that message based on Guy's and Alison's scenarios if the Storage dimension group assigned to the item had the checkbox "Use warehouse management processes" selected. This field would do that validation on the item comparing the Inventory unit of measure to the assigned Unit sequence group ID.

    Sounds like the template for one reason or another was seeing a field that was enforcing this validation.

    Thanks
    Andrew

    ------------------------------
    Andrew Lencsak
    Solution Architect
    DXC Technology
    Atlanta GA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: Sequence group's lowest unit does not match inventory unit of the item.

    TOP CONTRIBUTOR
    Posted 29 days ago
    We ran into this problem while testing R3 yesterday, and the problem is not going away for us.  Here are more details on how we were able to generate the error on demand:

    • In the "New Released Product" form, the Retail Category field must be selected using the mouse (not typed in)
    • A template must be applied after that.
    (I confirmed that the template has units of measure set and a unit sequence group set.)

    If either the category *or* the template is left blank (or the category is typed in instead of selected using the mouse), there is no error and the item is saved successfully.  So there is something conflicting between the retail category selection process (\Forms\EcoResProductCreate\setCategory) and the application of the template.

    When I examined the setCategory method, I found that the "unitInvent" (among other variables that refer to a unit of measure) is set by a call to RetailAttributesLegalEntityLookup, but since we don't have attributes set on our categories, it sets it to blank.  However, this happens before the application of the template, so I would think the template setting the inventory UoM should be sufficient.

    That's as far as I've gotten at this point.  If anyone else has any insight regarding why selecting both a category (using the mouse) and a template causes this error, please add your thoughts.

    This is a showstopper for us, so we may end up paying a consultant to figure it out, but it sure looks like a bug that Microsoft left in R3.
    Note: We are on application version 6.3.6000.151

    ------------------------------
    Daniel Zook
    Director of IT
    Lehman's
    Dalton OH
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 7.  RE: Sequence group's lowest unit does not match inventory unit of the item.

    TOP CONTRIBUTOR
    Posted 29 days ago
    After doing some digging, I found a hotfix in LCS that appears to refer to this issue.  I'll update this thread once I've tested it.

    ------------------------------
    Daniel Zook
    Director of IT
    Lehman's
    Dalton OH
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 8.  RE: Sequence group's lowest unit does not match inventory unit of the item.

    TOP CONTRIBUTOR
    Posted 29 days ago
    Unfortunately, the hotfix I found on LCS is already installed on our R3 system, so no luck there.

    https://fix.lcs.dynamics.com/Issue/Details?kb=4073652&bugId=3913997&dbType=0&qc=9d3376aa1b7e38071dce8817462ee9255b63a57adf816f4b72b2170ea7c623e5

    If I find a solution I'll share it on this forum thread.



    ------------------------------
    Daniel Zook
    Director of IT
    Lehman's
    Dalton OH
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 9.  RE: Sequence group's lowest unit does not match inventory unit of the item.

    GOLD CONTRIBUTOR
    Posted 28 days ago
    Daniel,

    We are no longer receiving this message.  We just make sure the Inventory and WMS matches.  At the time of this original message we did not have 'Retail' turned on and were not using 'Advanced WMS'.  Both are turned on now.  We are using 'Retail' to have 'Style' available to use as 'Revision' number is the only reason for us at this time.  We may be able to take advantage of some other features at some future time.

    I'm interested in what resolves this for you and will be keeping an eye on this thread.


    ------------------------------
    Mark Yankovich
    Allegheny Bradford Corporation
    PA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 10.  RE: Sequence group's lowest unit does not match inventory unit of the item.

    TOP CONTRIBUTOR
    Posted 28 days ago
    After working on this for a number of hours, it occurred to me that the template I was using was created from an existing item (that happened to be imported into the R3 environment).  To test if the template was the problem, I created a new item from scratch, with just the fields populated that need included in the template, and created a new template from that new item.  When I use the new template to create a new item (and select a category using the mouse), there is no error!

    I still don't know what was actually causing the error, other than something about the first template was the problem.  I managed to narrow it down to something about lines 54-59 in the \Forms\EcoResProductCreate\Methods\write method, since remarking that code eliminated the error as well.

    I hope my experience helps someone else in the future who finds this post via Google like I did...  :)

    ------------------------------
    Daniel Zook
    Director of IT
    Lehman's
    Dalton OH
    ------------------------------

    Academy - Online Interactive Learning from Experts


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