Safety stock is getting on my nerve...grrr....
thomast
Member Posts: 102
Hi Guys,
I now have two customers with the same issue with safety stock getting in the way...
Situation:
Whenever they buy the item, they want to buy Q=250. Today they have an inventory of Q=10. They get a sales order for Q=45 and since they don't have enough stock to cover that, they want the Planning Worksheet to suggest 1 lines with Q=250. This would cover the sales order, and then they have some quantities left that they can keep in stock. (Is this really an unreasonable requirement....!?!)
HOWEVER: When running the planning work sheet, this will create TWO lines: One Exception line of Q=35 and then another line with Q=250.
Is there any way to achieve what we want?
Thanks!
I now have two customers with the same issue with safety stock getting in the way...
Situation:
Whenever they buy the item, they want to buy Q=250. Today they have an inventory of Q=10. They get a sales order for Q=45 and since they don't have enough stock to cover that, they want the Planning Worksheet to suggest 1 lines with Q=250. This would cover the sales order, and then they have some quantities left that they can keep in stock. (Is this really an unreasonable requirement....!?!)
HOWEVER: When running the planning work sheet, this will create TWO lines: One Exception line of Q=35 and then another line with Q=250.
Is there any way to achieve what we want?
Thanks!
0
Answers
-
How short are their delivery horizon? If the sales order has an expected shipment date far enough in the future, I believe it should not suggest this.
How are the item Reorder Policy, Reorderpoint, Safety Leadtime and Safety stock setup?0 -
When calculating the plan, make sure the Starting Date is before the Sales Order Shipment Date0
-
Kishorm,
I almost thought this would work. It makes a lot of sense, unfortunately it did not. I had a delivery date on the sales order of 10/10/17, but ran the regenerative plan with a start date of 01/01/17, but still it came up with two lines: An exception line for 45 and then another line for the 250.....
Thanks for the effort guys!0 -
That’s strange, can you provide more info, in particular...
- Planning parameters for the item
- Options used on calculate plan
- Dates and quantities of the planning lines that are generated
Just to double check, did you have an Ending Date after 10/10/17?0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 250 Dynamics CRM
- 102 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
