While running MRP Reorder cycle is not considering

thinafans

Dear all,
I have a doubt on re order cycle. This is my scenorio
I have created sale orders for item A for location Blue. There is no inventory at location blue.

1. SO1- Shipment date 01/08/08 = 10 Nos
2. SO2-Shipment date 01/09/08 = 20 Nos
3. SO3-Shipment date 01/10/08 = 50 Nos

These are the planning parameters for Item A

Reordering Policy = Lot for Lot
Include Inventory = Yes
Re order cycle = 3m

I am running planning worksheet for MPS with
order date = 01/08/08
End date = 31/08/08

the output for this is
Only 10 nos which considers only the SO1.

Notes: My Guess is, it should have calculated the demand for all the three Sales orders since my re order cycle is 3m and my order date is 01/08/08.so the demand consideration should be 01/08/08+3m=01/11/08.

Please give me your valuable feedbeck. Thanks in advance.

AdamRoue

Your end date is 31/08/08

So you have said no matter what the planning metrics if the demand fals after 31/08/08 ignore it, so you have told the system to ignore your orders in September and October. Set your ending date to 31/12/08 and see what happens

thinafans

Thanks for your reply.

But the explanation given in the database for ending date by pressing F1 is

Enter the date where the planning period ends. The program does not include demand beyond this date.
"However, if an item reorder cycle extends beyond the ending date, then the planning period for that item is the order date plus the reorder cycle".

Please clarify this.

Thanks in Advance \:D/

AdamRoue

Well I obviously did not write the help

My help also mentions nothing about the reorder cycle and the ending date.

This would work with lot-for-lot if the ending date was set after the last demand - I would suggest you try this and see what happens.

thinafans

Dear Sir,

We tryed with lot for lot only.

Even though we didn't get the Reliable result.

Please see our scenario which we posted in first reply.

Thanks in Advance.

Regards,

THINA.

AdamRoue

Using what you have given me I set a new item up in Cronus.

I then ran the requisition worksheet and it told me to order 10.

I then set the ending date to 31/12/08 it told me to order 80.

This means one of serveral things:
i) You are not telling me everything.
ii) You have not set up the system correctly to work.
iii) You have modified the system to make it work differently.
iv) You have a localisation making it work differently.
v) You did not try what I suggested.

Works fine for me as I understand the system and how I would implement it for the requirement you suggested.

cernst

Maybe you are using different NAV versions? The planning functionality has been rewriten a couple of times so yoy could get different results.

AdamRoue

Hi Noname

At a base level the lot-for-lot and reorder cycle have been pretty consistent since 3.x onwards, I think it is something else in the setup or understanding.

thinafans

Dear AdamRoue & noname

Thanks for your reply.

We also tried in Cronus 4.0SP3.

In that we also set the same ending date to 31/12/08 and we get the same result as 80.

But our worry is if we set the ending date as 31/08/08 also it should give the same result as per reordering cycle.

In Navision Cronus 4.0 sp3 help they given

"However, if an item reorder cycle extends beyond the ending date, then the planning period for that item is the order date plus the reorder cycle".

Please Guide us.We also really worked different scenario as you mentioned.

Waiting for your positive reply.

Regards,

THINA.

AdamRoue

Simply put the help is wrong.

Feel free to contact Microsoft and ask them to correct it, but they will correct the help and not the system!

santoshmkcet

thinafans wrote:

There is no inventory at location blue.

1. SO1- Shipment date 01/08/08 = 10 Nos
2. SO2-Shipment date 01/09/08 = 20 Nos
3. SO3-Shipment date 01/10/08 = 50 Nos

These are the planning parameters for Item A

Reordering Policy = Lot for Lot
Include Inventory = Yes
Re order cycle = 3m

I am running planning worksheet for MPS with
order date = 01/08/08
End date = 31/08/08

the output for this is
Only 10 nos which considers only the SO1.

If sales order is for item A, then u have to use order policy as "ORDER".

and you can use the order policy "LOT FOR LOT" for item A Raw Material.

U will get the result in Planning worksheet for all the sales order, production orders will be asked to be created seperately.

Santosh