web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Round quantity up to f...
Microsoft Dynamics NAV (Archived)

Round quantity up to full pallet on warehouse pick/movement

(0) ShareShare
ReportReport
Posted on by Community Member

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.

*This post is locked for comments

I have the same question (0)
  • 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 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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans