SKU setting

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

I'm fighting with this issue and it seems I can't find a direct solution. This is the issue:

I have a product (skirting strip) that has basic unit M(meter), one pice is 2,4m, we sell this product per package (5 pieces or 12meter) and we buy it per box (10 pieces or 24m).

If I make a special order of this article and you sell 1 package for order A and one for order B, NAV will order 2 boxes at our supplier and I want it just to be one. Then I thought I make a SKU for this article, lot-for-lot and basic lot is 24M but when I need 36meter or 3 packages, NAV will only order one box and not 2 boxes.

I have a lot off articles likes this (sell per 5, buy at our supplier per 20..) and I'm searching for a direct and easy solution so I combines the orders.

Many thanks in advance!

Kind regards,

Harry

*This post is locked for comments

All responses (2)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: SKU setting

Ideally as per NAV planning engine logic, it should round up on higher side and should show you 2 boxes.

I believe your Purchase Unit of Measure is DOOS...
Suggested answer

Alexander Ermakov 28,094 on at

Like (0)

Report

RE: SKU setting

Is there a such a case that you want to order 10 pieces (24m) from the supplier, and then perform re-joint of them into two separate lots of 5 pieces for each customer?

It depends on the minimum package quantity and minimum order quantity from supplier. Can you order from you supplier just meters, but not boxes, so the supplier himself would convert it to the upper round of a box? It also should depend on how you perform the ordering from you supplier. Is it a manual compilation of orders of do you use standard/customized planning for that purpose?