Maximum order quantity and reorder cycle

Hi all,

In our factory many of our products have a fixed batch/lot size due to processing constraints. For example, a batch may be limited to 100 units. I have set this size up as both the minimum order quantity, maximum order quantity and order multiple. I also have a reordering cycle of 45 days for this item to allow rescheduling within that time to occur.

If I enter a sales order for 300 units, the planning worksheet plans beautifully and suggests 3 production orders of 100 units. If I then create those orders and re-run the regenerative plan, the system suggests that I cancel two production orders, and change the quantity of the third to 300. Is MRP disagreeing with itself?

Microsoft tells me (via our partner/consultants) that I should not use a reorder cycle with the field maximum order quantity (although this is not in the help file). If I remove the re-order cycle and my customer decides to move the sales order a week earlier (as they are apt to do) the planning worksheet will suggest I cancel my production orders and create new ones for the new date rather then re-schedule the existing ones.

Has anyone else come accross this issue? Any suggestions?

Thanks

Matt