Round quantity up to full pallet on warehouse pick/movement

(0) Share

Report

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.

*This post is locked for comments

All responses (3)

Answers (0)

Hannes Holst 5,767 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 5,767 on at

Like (0)

Report

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.