Small and medium business | Business Central, N...

Setting up Parent Item and Child Item in NAV 2016

(0) Share

Report

Posted on by DinoDavis

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.

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Inge M. Bruvik 1,035 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
DinoDavis 30 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,035 Moderator on at

Like (1)

Report

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).

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 89,835 Super User 2025 Season 2 on at

Like (0)

Report

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.

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

Was this reply helpful? Yes No
DinoDavis 30 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 89,835 Super User 2025 Season 2 on at

Like (0)

Report

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.

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

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No