Req. Worksheet Calculation
ADARTIHS
Member Posts: 78
Hi Everyone :P
Version: NAV 2009 SP1
DB: SQL
I am great problems understanding the requistion process in NAV. The values returned are not what I expected.
I have setup a new item with the following Values:
Inventory Stock = 0
SKU Reorder Policy = Fixed Reorder Qty
Safety Stock Qty = 100
Reorder Cycle = 3M
I raise a new sales order for 50 with a Planned delivery date 27/01/11
I raise a new PO for 25 with a Planned Receipt date of 28/01/11
When I run the Req. Worksheet Calulate Plan for that Item with Start Date = 01/01/11 and end date 30/03/11
I get 2 lines back??
1 with the Qty of 100 to Replenish stock
The other value is 50 for the Sales Order.
There is 2 problems here
1. First the Calculate Plan should only create 1 line for the
2. The value to be reordered should also only be 125 because I already have 25 on purchase order.
Would you agree? Please help this is driving me crazy [-o<
Cheers
ADARTIHS
Version: NAV 2009 SP1
DB: SQL
I am great problems understanding the requistion process in NAV. The values returned are not what I expected.
I have setup a new item with the following Values:
Inventory Stock = 0
SKU Reorder Policy = Fixed Reorder Qty
Safety Stock Qty = 100
Reorder Cycle = 3M
I raise a new sales order for 50 with a Planned delivery date 27/01/11
I raise a new PO for 25 with a Planned Receipt date of 28/01/11
When I run the Req. Worksheet Calulate Plan for that Item with Start Date = 01/01/11 and end date 30/03/11
I get 2 lines back??
1 with the Qty of 100 to Replenish stock
The other value is 50 for the Sales Order.
There is 2 problems here
1. First the Calculate Plan should only create 1 line for the
2. The value to be reordered should also only be 125 because I already have 25 on purchase order.
Would you agree? Please help this is driving me crazy [-o<
Cheers
ADARTIHS
0
Comments
-
It has to do something with dates on sales and purchase orders.
Try to set reorder cycle to 0.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
- 251 Dynamics CRM
- 103 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