Multiple reorder levels for multiple locations?

We are about to open a second warehouse within our building. Our warehouse folks wanted to create duplicate Item Categories and duplicate every stocking item to keep them separate. I’m hoping that Navision will allow us to not get to those ridiculous extremes.

We have one company, and I’ve created the new Warehouse, new bin codes, etc and I assigned sample items to the sample bin locations. Really, the only thing I’ve got left is figuring out how to separate the Maximum Inventory per location.

Our Purchasing Manager uses the Inventory Reorder Report to look at QOH vs stocking levels (Maximum Inventory), which is fine when we only order for the main warehouse and only hold inventory in the main warehouse. But now he will need to know QOH and Max Inv for Warehouse1 and QOH and Max Inv for Warehouse2, as Warehouse2 will be ordered and shipped separately.

Is there any way to have stocking levels set to something like “Max Inv for WH1 = 4, Max Inv for WH2 = 2”??? Or maybe a “custom field” we could use?

Then of course, it would be great if there is a report to spit that out, but if it’s not a canned report, we can build one…

Other info - we are a resort property, so there are no sales orders or build/materials sheets. To the best of my knowledge, they don’t use the Reordering Policy and he does it all manually, but the items are set to Maximum Qty for the policy. We are running version 4.0 (don’t think we’ve ever installed any SP’s).

Hopefully someone out there could help point me in the right direction? I’d really appreciate it!

Thanks,

Herb

I’m not a warehousing specialist by any standard, but I believe that Stockkeeping Units is what you could use for that. Have your NAV partner explain how that works and see if that will meet your requirements.

SKU’s will do this for you, they allow the setting of warehouse specific options including max inventory etc. This also allows you to create transfer rules between the warehouses.

Great…I’ll check into those. Thanks!

Well, at least it sounds great…but the Stockkeeping Units aren’t there! The options skip right over it, so I checked on the sample Cronus DB and it is there, but says I don’t have access to it.

Can you describe exactly error message ? Seems that your problem is a license error . Did you open Cronus database with your license or you Cronus license ?

SKU’s are an extra granule that needs licensing, we use it, and it does exactly what you are asking.

If you change the license, while you are in the demo database, to the cronus license, you should have access to SKU’s (Purchase menu, Inventory & Costing, or from the Item button on the Item Card). For many Items you will need to create them first, but from the Item Card you can create them (Functions, Create Stockkeeping Unit from the Item Card) and get to them from the Item button.

You will need to purchase the SKU granule into your own license if you want to get access in your production database.

Agree completely with the suggestions - SKU = Stock Keeping Units garnule sounds appropriate for you.

Receommned that you upgrade to Version SP3.