Requisition worksheet: only NEW action

wesleys

I know the requisition worksheet is one of the more complicated realms of navision, but I need some advice on it. I run Navision 3.70 if that will help.

When calculating a plan I do not want any action messages other than NEW. I do not have the luxury of rescheduling, or changing the quantity on purchase orders.

I tried following codeunit 99000854 to find out how to stop this, but the best I could come up with was never letting the "Original due date" = 0D. The "Due Date" on my purchase orders are set to pretty reasonable values (not 0D from the plan date or order date by any means).

I've also tried the "manufacturing setup" table. I've had the dampner fields as blank and as 365D and 1000% as suggested on another thread, but it seems to have had no affect.

Thank you for your help.

Wes

DenSter

How about OnPostReport you program a few lines that filters the requisition Line table on Action Message = New and delete them all?

wesleys

I'm hoping I misunderstood you. Are you suggesting, that when the requisition worksheet is done, that I simply take all of the records that aren't NEW and just delete them? So if I'm 1000 units short on a product and the system suggests that I change qty on a pre existing PO to cover the needs, you think I should just ignore the CHANGE QTY and delete it instead of creating a NEW PO with the 1000 unit difference?

Can anyone tell me what "planning flexibility" on PO lines is? Why does it default to "unlimited" and can I change that default to "none" and will this fix my problem?

DenSter

well do you want to go in there and figure out the MRP and make it not create the lines, or do you want to do a quick and dirty few lines of code that just removes them before it shows you the form?

To me these are the same, with the same effect. Unless you carry out action message, the requisition lines are just records in a table. YOU are the one that doesn't want to see anything that is not New, which to me is a silly request. You can always manually delete the lines you dont want to, or you can add a little code to uncheck the 'Accept Action Message' field, so the user has to make a conscious decision.

There are more ways that one my friend, I'm just trying to give you a way to do what you asked us to do. :?

wesleys

I'm sorry, I don't think I'm being very clear. I like the requisition worksheet and would love to get my buyers to use it. We've worked through a number of their concerns with it and this is one where I just don't know how navision would like me to handle it.

When they calculate the plan, it does very well at calculating needs based on reorder points, qty on sales and qty on purch. The unfortunate part is that we often have multiple purchase orders for any given vendor at one time. So, the system goes ahead and suggests to "change qty" or "reschedule" pre-existing orders. I like all of the calculations that it's doing to figure out the inventory needs. I would prefer if there is a setting somewhere that will tell the system to simply create "new" orders instead of changing the qty or rescheduling a previous order.

Someone suggested using "Lot-for-Lot", but from the description of it, it doesn't sound like the reorder policy I want. I'm kind of partial to the "maximum qty" reorder policy.

vanrofi

If you change the planning-flexibility (purchase line, or purchase requisition line) to none instead of unlimited the system won't try to replan.

PVBS

If you set the PO line flexibility to be none, then it will exclude that line in the demand calculation. Thus you could be over ordering.

golfer

Indeed the PO with planning flexibility=none is calculated in the demand.
Demand checks a number of parameters such as if deliverydate on the PO is within the dateframe when running the worksheet.
Example; Item A with 100 pcs. reorder point. You have 10 pcs. on PO with planning flexibility=none with expected deliverydate today. If you run the req. worksheet for today and forward you will get action message to order 90 pcs.
However, in real life you must consider leadtimes etc. If I order item A today and expected delivery is next week, the scenario above will result in a message to order 100 pcs. This is because the leadtime is 0 and thus the system thinks I can get the stock back to reorder point today.

Regards
Golfer