Req. Worksheet Calculation

ADARTIHS

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

Malajlo

It has to do something with dates on sales and purchase orders.
Try to set reorder cycle to 0.