Query about the MRP calculating stocks from more than one lo

Tan_Eng_Siong

Hi

I have started using the Planning worksheet for a customer. I found that I could not get the MRP to include inventory in other location. My customer needs the MRP to calculate purchase for a location exclduing the stocks from other locations. Is there any way to handle it in the MRP?

Tan Eng Siong

srikanta

Dear Tan Eng Siong,

1.First Define the SKU for the items and specify different location on SKU.
2.In SKU, Define Reorder policy as "ORDER" in Planning Tab of SKU for those items you do not want to consider the stock/Inventory.
3. In SKU, Define Reorder policy as "LOT FOR LOT" in Planning Tab of SKU for those items you want to consider the stock/Inventory.
4.While Running the MRP, select both the location what you are mentioned in the two SKUs in the item tab.

So that system will generates two lines with different order quantities.

Hope this will help you

Srikanta

darshanm

unlike Nav 3.7, You have to define SKU in NAV 4.0 for running
multi Location MRP.

Tan_Eng_Siong

Thanks

I will try it and let you know the result.

Miklos_Hollender

Last time I checked (3.6) SKU's did not automatically reserve stock at another Location (would be strange) but generate Transfer Orders to move the stock to the Shop Floor Location. The basic problem is, the SKU of the Item at the Shop Floor Location can be set up be replenished from one and only one other Location. Therefore if you'll have two Raw Material Locations in the future, you're stuck.

Therefore, what I can suggest is to always setup Navision so that all available inventory at one physical site is one Location: Raw Material, Shop Floor, Finished Goods warehouses are represented with one and only one MAIN Location. Only warehouses containing unavailable goods (Scrap, Returns etc.) should be set up as different Locations. Within this Main Location, you can differentiate with Bins. F.e. in a candle factory I have set up Navision so that shelves in the Raw Materials warehouse are represented as Bin 1_A34, 1_C41, then the Shop Floor is represented as Bin 2, then the shelves in the Finished Goods warehouse as 3_A12, 3_C21 etc. Worked so well - Navision considered inventory as one Location, while the users could see inventory of a given warehouse by filtering a simple report for 1*, 2, or 3*

Tan_Eng_Siong

Hi

I noticed that this MRP selection from more than one component location works only when the Sales order line location code is empty. Otherwise it will then select the components from the same location code.

Is this how it is suppose to work?

Tan Eng Siong

darshanm

Hi,

Not at all... You have to select a Location in Sales header and
it will automatically get reflect in sales line.

Once the Location is selected on sales header, system generates
the demand on that Location for production.

If you dont select the Location, system generates the demand
on blank Location and you can not run the MRP for multi location.