Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV forum / Round quantity up to f...
Microsoft Dynamics NAV forum
Unanswered

Round quantity up to full pallet on warehouse pick/movement

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Is there a way to round quantity up to next full pallet on warehouse pick and warehouse movement?

Examples:

I have 50 pcs left in a certain bin. A pallet size is 300 pcs and I have set min.qty 100pcs and max.qty. 300pcs for bin content. I can now run bin replenishment and get a suggestion to move 250 pcs to this bin. But what I want is to always replenish the bin with a full pallet, but I can't let the bin run out before replenishment. Is there a way to get a suggestion for a warehouse movement of 300pcs?

Same goes with warehouse pick to production. If I need for example 100 pcs for a production order and the pallet size is 300pcs. When I create a warehouse pick for the production order, is there a way have a suggestion to pick a full pallet? After production I would return the left to warehouse.

Categories:
Warehouse
  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: Round quantity up to full pallet on warehouse pick/movement

    [quote user="Juha U."]

    I tried changing the base unit of measure to pallet. I set min quantity to 0,2 pallet and max quantity to 1 pallet fot the bin content. I have 0,1 pallet stock in the bin. The suggestion for warehouse movement is now 0,9 pallet. So I think it's not working the way needed. Also it would not maybe be very good idea to use pallet as base unit of measure in production.

    [/quote]

    Do you allow Breakbulk for that location?
    Could be that you must amend the BOM also (to contain 1 pallet). But this might create other problems.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Round quantity up to full pallet on warehouse pick/movement

    Thanks for your answer.

    I tried changing the base unit of measure to pallet. I set min quantity to 0,2 pallet and max quantity to 1 pallet fot the bin content. I have 0,1 pallet stock in the bin. The suggestion for warehouse movement is now 0,9 pallet. So I think it's not working the way needed. Also it would not maybe be very good idea to use pallet as base unit of measure in production.

    For the pick I found a way using Rounding Precision on item card. Setting the quantity of a full pallet here, quantity to pick for production order will be rounded to this quantity. But, also the quantity on production order component list is rounded, which might cause some trouble when planning the demand/supply with planning worksheet.

    If there is any other way to round up quantity on warehouse pick and warehouse movement, advices are welcome.

  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: Round quantity up to full pallet on warehouse pick/movement

    Hi,

    Only solution I can think of, is to change the Base Unit of Measurement for these products to pallet and align min/max Quantity accordingly (to 1).

    In NAV-world, when you handle the Unit pcs (or each), NAV "thinks" you can actually handle this unit.

    For the warehouse pick, not sure how the manufacturing module works in detail. Maybe you can establish a new location for the Manufacturing stock. Using this new location you could setup a Reorder Quantity (in Stockkeeping Units), but this would be independent from actual Production Order.

    I would give it a try with the Base Unit first and go from there.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,552 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,552 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans