Skip to main content
Microsoft Dynamics NAV forum
Suggested answer

Setting up Parent Item and Child Item in NAV 2016

editSubscribe (0) ShareShare
ReportReport
Posted on by 30

Hi. We are using NAV 2016 and would like to set a parent item code and child item code for our operations. We procure the Beef meat in one master item code and sells in different item code based on meat cuts (Chuck, RIB, Short LOIN, etc). How this can be done with NAV with all proper cost flow and inventory. Please help.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,714 Super User on at
    RE: Setting up Parent Item and Child Item in NAV 2016

    So what you basically needs is a automatic item revaluation based on your sales.

    I think your LS-Retail partner should be able to assist you in a way to do that and at the same time not compromise the system integrity.

    The sales process in LS-Retail is slightly different from what you find in standard Business Central, So i would definitely recommend that you discuss your need with an LS-Retail partner.

  • DinoDavis Profile Picture
    DinoDavis 30 on at
    RE: Setting up Parent Item and Child Item in NAV 2016

    Sincere thanks for your suggestion Mr. Inge but the sold weight of the child items can be booked after the business EOD statement posting (because we integrated LS Retail for POS operations). If item code mapping or a scheduler job with code unit is possible, the system will automatically adjust stock and cost from the parent code for the next business day.

    Pasting the current stock position from retail item card for both item codes

    01_5F00_RAW.png

    01_5F00_CHILD.png

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,714 Super User on at
    RE: Setting up Parent Item and Child Item in NAV 2016

    What you basically are doing is a simple manufacturing process.

    If you do not want to implement some kind of manufacturing procedure you could use the item revaluation journal to reduce the inventory on your parent item and increase the inventory on the child item according to how many kg. of cuts you have gotten from the parent item.

    bc365.co/.../

    But it requires that you have a founded strategy for handling cost for your cuts (child items).

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 59,766 Super User on at
    RE: Setting up Parent Item and Child Item in NAV 2016

    Hi, I'm not sure if Sales Unit of Measure can meet your needs? But I think you can try it.

    pastedimage1654503544301v1.png

    pastedimage1654503562545v2.png

    More details:

    https://www.youtube.com/watch?v=-a9-CyZfiUQ

    https://archerpoint.com/considerations-setting-base-unit-measure-dynamics-nav/

    Hope this helps.

    Thanks.

    ZHU

  • DinoDavis Profile Picture
    DinoDavis 30 on at
    RE: Setting up Parent Item and Child Item in NAV 2016

    Hi. Thanks for your suggestion but what I understand is variant option can be used for same item with different color or pattern. How about items which has different weight and have separate item codes? The base unit of measure of all this is on KG and the weight can be varied based on customer purchase. Right now all these child codes are selling on minus stock and we performing assembly order from parent code to adjust stock everyday. This consumes lot time and staff have to record sold quantitiy of child codes manually at the butchery section.

    We ideally wish to automate this process when a sales record on child codes should automatically reflect on the parent code (especially stock and cost). How about setting up dimension on parent code? Would you please advice or share any links?

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 59,766 Super User on at
    RE: Setting up Parent Item and Child Item in NAV 2016

    Hi, as for the product categories, in the standard features of NAV 2016, Item Category Code and Product Group Code can be used. If that's not enough, I think Dimensions can also help you.

    pastedimage1654471750015v1.png

    If it has to do with cost statistics, you can use Item Variants.

    pastedimage1654471977692v2.png

    pastedimage1654472034792v3.png

    Hope this helps.

    Thanks.

    ZHU

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Sundar…

Industry experts answer burning questions directly from our amazing Community…

Enabling Copilot Case and Conversation…

Agents can easily recap an ongoing chat, transcribe a voice conversation…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 282,978 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans