Open Forum

Like what you see? Discover the benefits of the NAVUG Community. Learn More

1.  planning worksheet

Posted 23 days ago
I would like to use the planning worksheet (2015 version nav) and am lost at where to begin.  I have set up some min max etc paramaters per item however when i try to regenerative plan or get action message nothing shows up.  If anyone has any help i would appreciate it.

------------------------------
Mike Zentveld
Production Manager
Prosci Inc
Fort Collins CO
------------------------------


2.  RE: planning worksheet

TOP CONTRIBUTOR
Posted 23 days ago
Edited by Franz Kalchmair 23 days ago
best you start here:
https://msdn.microsoft.com/en-us/library/hh173804(v=nav.80).aspx
https://msdn.microsoft.com/en-us/library/hh172784(v=nav.80).aspx

for setting up item planning and replenishment goto
https://msdn.microsoft.com/en-us/library/hh879436(v=nav.80).aspx
https://msdn.microsoft.com/en-us/library/hh879478(v=nav.80).aspx
https://www.youtube.com/watch?v=BbDFiHXUW40

------------------------------
Franz Kalchmair
Microsoft MVP
Senior Consultant
Vienna, Austria, Europe
------------------------------



3.  RE: planning worksheet

SILVER CONTRIBUTOR
Posted 23 days ago
​Make sure you have the Planning parameters setup on the item card for "Order Tracking Policy" = Tracking & Action Msg. as well.

I found these help links to be helpful when we started setting up MRP/MPS

http://navdevtier2:49000/main.aspx?lang=en-US&content=tskRunMPSMRP.htm
http://navdevtier2:49000/main.aspx?lang=en-US&content=B_99001017.htm

------------------------------
Catherine Collins
Business System Analyst
San Francisco Bay Coffee Company
Lincoln CA
------------------------------



4.  RE: planning worksheet

Posted 20 days ago
​Hi Mike

I haven't checked the links associated but make sure you have a reordering policy set for the items on the Item Card. If this is blank the Planning Worksheet will ignore the item planning parameters you have set (example min/max/etc).



------------------------------
Jenn Morton
Manufacturing Consultant
Sabre Limited
Cambridge Ontario Canada
------------------------------



5.  RE: planning worksheet

TOP CONTRIBUTOR
Posted 5 days ago
I agree with Jenn, the likely issue is a blank "Reordering Policy" on the Item(s) that are not showing up.  If this field is blank the Planning Worksheet will skip over the record.

If you do have a Reordering Policy value, then the next place to look are the dates.  Is there demand within your planning horizon (Start/End Date when running Calc. Plan)?

Run a quick test to make sure you are filling in the correct fields as well.  If using Fixed Reorder, set a Reorder Point (0 is okay), and a Reorder Quantity (0 is NOT okay).  If you set the Reorder Point at or below your current on hand quantity, this creates demand and you should see a suggestion in the Planning Worksheet equal to your Reorder Quantity.

P.S.  When using a Fixed Reorder Quantity, do NOT use the Min. Order Qty or Max Order Qty as you have already defined the exact amount to make/purchase in the Reorder Quantity field.


------------------------------
Ben Baxter
Consultant
Accent Software, Inc.
Carmel IN
------------------------------



6.  RE: planning worksheet

Posted 19 days ago
On the Inventory Setup is the Location Mandatory set to Yes?  If set to Yes, NAV is looking to the Stockkeeping Card for the Order Parameters.  Have you setup the Stockkeeping Cards?

------------------------------
Brett Bartholomew
TGS Management
Denver CO
------------------------------



7.  RE: planning worksheet

TOP CONTRIBUTOR
Posted 6 days ago
Mike - to add to Brett's comment - you may not need a SKU - it depends on how you are setup - but try filling in the MFG setup 'Components at Loc' to your main locations. By doing this NAV will then use the Item card Planning and not need SKU's. There are other considerations if you are using SKU's for another location that also manufactures and in those items you would setup components at location on the SKU as well as setup SKU's for the Purchased items.

It all has to do with setup - try the MFG setup 'Components at Loc' first.

Let us know
Best Regards

------------------------------
John Grant
Senior Application Consultant
Innovia Consulting
------------------------------



8.  RE: planning worksheet

SILVER CONTRIBUTOR
Posted 6 days ago
​Is this for a purchased item or a manufactured items? As their might be different paths?
The next is related what is the demand or driving the replenishment of this Item or items?  e.g., Sales Orders and dates, etc., stock levels, lead time, location and bin requirements, etc.

When you are doing your planning worksheet are you selecting both MPS and MRP? and as mentioned then Manufacturing Setup must have the right values setup.  Also, are you getting errors in the planning error log?

------------------------------
Ronald McVicar
National Steak Processors, Inc.
Owasso OK
------------------------------