Daily/Weekly Job to run a Regenerative Plan- Planning Wks

fredp1

Hi,

How do I setup a regular schedule/job to run a Regenerative plan from the planning worksheet in V5sp1?
I think the report is 99001017 Calculate Plan - Plan. Wksh..
How do I specify the dates/options in a job schedule?

Do I need to use ExpandiT or some other method?

The dates in the Options tab would need to chnage too.?

Any suggestions would be great!

Thanks
Fred

themave

I have done a similar thing with the requision worksheet, which I run nightly

I copied the report ( and modified it) so there is no request form.

on the init report section I added

OrderDate := TODAY +20;
ToDate := TODAY +20;
CurrTemplateName := 'REQ';
CurrWorksheetName := 'SF';

This sets the date fields and tells it which template and worksheet to put the results in.

I already have the blank worksheet set up, so every night in the job scheduler the report runs and fill the worksheet with the current items meeting the requisition requirements.

fredp1

Hi,

That sounds like a good idea. I'll have a look at it and see if I can get it work for me as i'm new to Nav.

How did you schedule it?

Thanks
Fred

themave

fredp1 wrote:

Hi,

That sounds like a good idea. I'll have a look at it and see if I can get it work for me as i'm new to Nav.

How did you schedule it?

Thanks
Fred

I run it in the job queue every night.

fredp1

Thanks for the suggestion. I'll try modifiing a copy of the report and try it out!

Kind Regrads
Fred