Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 298 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
planning worksheet "due date" calculation
MrsM1ggins
Member Posts: 2
I'm having a problem with planning in 5.0 SP1 and I'm not sure if it's a NAV issue or a setup issue somewhere.
When I run the planning worksheet I am seeing suggested transfer orders which I do not expect. I have traced the 'issue' back to the base calendar and whether or not "yesterday" is a nonworking day. If it is, I get an unexpected result in the planning worksheet.
Scenario:
Item A in stock in location BLUE qty 10
SKU for item A at location RED is replenished via TRANSFER from location BLUE. Transfer route is set up but there are no shipping agent details/times entered. Inventory at location RED=0.
Demand for qty 1 on a service order: posting date on line is 13th July; location RED.
If I calculate the plan it suggests a transfer of qty 1 from BLUE to RED. This is correct. However, if "yesterday" is a nonworking day then the 'due date' on the planning worksheet line is today and the 'receipt date' on the transfer order is also today once it is created. If these dates are allowed to populate through and I ship the transfer order then rerunning the planning worksheet leads to another suggestion to create a transfer order to satisfy the same demand. This suggestion is repeated until the day rolls over or the transfer order is received.
If yesterday is a working day then the 'due date' on the planning worksheet line is yesterday and the 'receipt date' on the transfer order is the same so I don't get the repeating transfer suggestion.
My understanding is that demand in the frozen zone should be treated as follows:
"If the initial available inventory is below zero, the planning system suggests an emergency supply order on the day before the planning period to cover the missing quantity."
Any idea why my system isn't counting back past the nonworking days to determine "the day before"?
When I run the planning worksheet I am seeing suggested transfer orders which I do not expect. I have traced the 'issue' back to the base calendar and whether or not "yesterday" is a nonworking day. If it is, I get an unexpected result in the planning worksheet.
Scenario:
Item A in stock in location BLUE qty 10
SKU for item A at location RED is replenished via TRANSFER from location BLUE. Transfer route is set up but there are no shipping agent details/times entered. Inventory at location RED=0.
Demand for qty 1 on a service order: posting date on line is 13th July; location RED.
If I calculate the plan it suggests a transfer of qty 1 from BLUE to RED. This is correct. However, if "yesterday" is a nonworking day then the 'due date' on the planning worksheet line is today and the 'receipt date' on the transfer order is also today once it is created. If these dates are allowed to populate through and I ship the transfer order then rerunning the planning worksheet leads to another suggestion to create a transfer order to satisfy the same demand. This suggestion is repeated until the day rolls over or the transfer order is received.
If yesterday is a working day then the 'due date' on the planning worksheet line is yesterday and the 'receipt date' on the transfer order is the same so I don't get the repeating transfer suggestion.
My understanding is that demand in the frozen zone should be treated as follows:
"If the initial available inventory is below zero, the planning system suggests an emergency supply order on the day before the planning period to cover the missing quantity."
Any idea why my system isn't counting back past the nonworking days to determine "the day before"?
0