Req worksheet - combining action messages

mulletron

I am trying to get my hands around the requisition worksheet but can't seem to get the proper settings to get the results I am trying to get. To keep it simple, I have a purchase item that has demand coming from 2 production orders, both with different due dates.

So I have tried setting the items reorder policy to every option available and running the requisition worksheet - each time the same results: giving me 2 lines, one with 10 due Feb 10, one with 26 due Feb 26. My end goal is one action message of 36 due Feb 10. I basically want to combine all demand within a 1M window into one action message.

The only other option I tried (aside from each Reorder Policy setting) was to set the Reorder Cycle to 1M. Yet nothing changed when I reran he plan after making this setting (I tried that setting with each Reorder Policy setting as well).

I am hoping this is an easy explanation, but I couldn't find it through my searches. Any help is very appreciated!

vasilis6669

Hi, if what you are trying to achieve is not mentioned in the training materials or the navision help file you have to write code. So, in the code were the line is generated you need to write some logic to check if the same item exists in the same month to add the qty. another option is to add an action on the requisition worksheet to consolidate the data per month per item.

rico1931

Are you using stockkeeping units? You have to change it there and not on the item card. also try lot-for-lot..

mulletron

Thank you both. We are not using the stockkeeping units (as of now) so it looks like we may have to turn to the custom code. I was hoping to stay clear of that but if the only method, we will look into it.