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.
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.
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
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.
But it requires that you have a founded strategy for handling cost for your cuts (child items).
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
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?
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
#1
André Arnaud de Cal...
291,703
Super User 2024 Season 2
#2
Martin Dráb
230,433
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
