Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Inventory management o...
Small and medium business | Business Central, N...
Suggested answer

Inventory management of cut items such as cables.

(0) ShareShare
ReportReport
Posted on by victorpbr 35

Hi,

Let's imagine the following situation. I'm a company that sells cables on desired length per customer request. My supplier sells me cables in rolls of 1000 meters, so that is my Minimum Quantity and also Order Multiple (MOQ & MLS).

In my current setup I have item A, using base unit of Measure as Meters.

Let's say I buy 1000 meters of cable. I then sell to my customer one piece of 700m. So my inventory is now one piece of 300M.

Now, let's suppose the same operation happens again, I buy 1000m, and sell 700m again, My inventory is now 600M (2 pcs of 300M)

A new customers places an order for 500m of cable. Now this is my problem, the system sees I have 600m of inventory and does not creates the need of replenishment. However I will need to buy a new roll since I need to sell one piece of 500m, and I cannot join smaller pieces.

Any ideas on the best way to handle this in the system?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory management of cut items such as cables.

    Hello,

    OK, so they do stay in inventory. I guess you have to way both options and play with them in a Sandbox/Test environment. Making Order the Reordering Policy give you the demand and creates PO but then you have these scraps lying around. You can review the scraps to determine if a size works and not produce the PO.

    On the other hand, maintaining UOM size or ranges might work in that you maintain UOM that fall into the scrap lengths. Now someone can enter a SO with the correct scrap UOM size and you will utilize that UOM scrap and for those larger you select a larger UOM size which creates demand PO.

    Both require administration and the UOM one will at least give visibility by scrap UOM size and allow for Order Entry to select a size to consume the scrap.

    Something to think about.

    Thanks,

    Steve

  • victorpbr Profile Picture
    victorpbr 35 on at
    RE: Inventory management of cut items such as cables.

    Hi Steve,

    Thanks for your input. We actually leave the rest in invertory until next sell (usually we are able to use the scraps in other cuts). Only when length is very short  and not possible to produce any common size we discard it.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory management of cut items such as cables.

    Hello,

    Now this is a pickle. My first question is what will you do if no one buys a 300M or less length. The 2 300M will sit around for awhile I'm guessing. Given that NAV is looking at the on-hand inventory and will not create a PO based on this (Reordering Policy you have setup), I have 1 idea:

    1. Based on what you do with the left overs that are small, you could create a Reordering Policy = Order, which generates demand per Order. You can then decide if you have a smaller size to fulfill but this will require administration.

    I have thought about UOM but then you are creating many Item UOM's and Ordering in 1000M, Selling in specific portions of 1000M and then create Item UOM's for the differences 300M, 500M, etc... Again, this is doable but an admin nightmare. Not knowing what you do today with small sizes that will not work, I am guessing they stay available for those orders that work. This is why I thought about UOM's. Not that the UOM will flag an Order that it does not have ample supply and generate a PO.

    If I think of something else, I will update.

    Thanks,

    Steve

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans