Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Set Limit on Stocks on hand/ inv. management/Planning engine
Gabor
Member Posts: 3
NAV 2009 R2
Dear All,
For a manufacturing company, I have set up a component item (i.e. raw material) with the following parameters (let's say item Test 1/ NAV 2009).
Reordering Policy: Max. Qty. / Reorder Point: 10 units/ Min. Order Qty: 25 units/ Reorder Cycle: 1 month/ Maximum inventory: no value set/ Include inventory is selected.
Due to the nature of the industry, my client needs to have a certain qty. of stock on hand, even if there is no demand (neither dependent nor independent). The current level of inventory on hand is Zero. OK, I run the Planning Engine to stock up to the Reorder Point, which is 10 units. The result of the Planning Run is 25 units, due to the value set in the Min. Order Qty. Field. OK, I "buy" ("receipt+invoice") item Test 1. So now my inventory has increased to 25 units, which is exactly what I wanted to do.
I then re-run the Planning Worksheet (neither consumption, nor demand occur in the meantime), and the Planning Engine suggests a new PO for 25 units, which represents unnecessary surplus. This way, I am stocking up item Test 1 with no control. I thought that values set in either in 1) the Reorder Cycle field or in 2) Maximum Inventory field stop me from overstocking.
The Planning Engine works against business rationale, because I cannot expect my client to spot every single suggestion leading to overstocking and delete the respective lines from the Planning Worksheet manually. I am talking about hundreds of component items, and it is literally impossible to take out these suggestions from the P. Worksheet.
Does anyone know any automation against overstocking? (I noted the same behavior for each Reordering Policy). I simply can't believe that no automation is built into the system by default.
Thanks for any help.
Gabor :roll:
Dear All,
For a manufacturing company, I have set up a component item (i.e. raw material) with the following parameters (let's say item Test 1/ NAV 2009).
Reordering Policy: Max. Qty. / Reorder Point: 10 units/ Min. Order Qty: 25 units/ Reorder Cycle: 1 month/ Maximum inventory: no value set/ Include inventory is selected.
Due to the nature of the industry, my client needs to have a certain qty. of stock on hand, even if there is no demand (neither dependent nor independent). The current level of inventory on hand is Zero. OK, I run the Planning Engine to stock up to the Reorder Point, which is 10 units. The result of the Planning Run is 25 units, due to the value set in the Min. Order Qty. Field. OK, I "buy" ("receipt+invoice") item Test 1. So now my inventory has increased to 25 units, which is exactly what I wanted to do.
I then re-run the Planning Worksheet (neither consumption, nor demand occur in the meantime), and the Planning Engine suggests a new PO for 25 units, which represents unnecessary surplus. This way, I am stocking up item Test 1 with no control. I thought that values set in either in 1) the Reorder Cycle field or in 2) Maximum Inventory field stop me from overstocking.
The Planning Engine works against business rationale, because I cannot expect my client to spot every single suggestion leading to overstocking and delete the respective lines from the Planning Worksheet manually. I am talking about hundreds of component items, and it is literally impossible to take out these suggestions from the P. Worksheet.
Does anyone know any automation against overstocking? (I noted the same behavior for each Reordering Policy). I simply can't believe that no automation is built into the system by default.
Thanks for any help.
Gabor :roll:
0