job queue : report modifications

vanrofi

Hi all,


I'm planning to use the job queue for Report 795 (adjust Cost - item entries) and report 296 (Batch post of Sales order) since they are getting Time-consuming.

2 questions :

1 : How can I add options and filters in the setup?
2 : What to program to capture the errors instead of having them on the screen?

I have searched the forum first, but could find more on errors on setting up the nas, etc...did not find a practical guide with tips and tricks for using Job queue. If you have a link or document that might be usefull, please send me as well. Be aware that, as a customer that pays tons on licensing nav only, I don't have access to partnersource, and the customersource is worthless...but that is again another question.

bbrown

You can build a codeunit or a process-only report that can be used to pass parameters to Adjust Cost. You will need to modify Adjust Cost (Report 795) to accept them. Job Queue will trap errors and write to the Job Queue log.

See this BLOG for more information. I found this very useful the first time I setup Job Queue.

http://blogs.msdn.com/microsoft_dynamic ... v-5-0.aspx

ara3n

you also need to modify both processed to hide all the dialog windows that open.

The code will look like this

//MOD01 Start
IF GUIALLOWED then
//MOD01 Start
  window.open.



//MOD01 Start
IF GUIALLOWED then
//MOD01 Start
  window.update.


//MOD01 Start
IF GUIALLOWED then
//MOD01 Start
  window.close.

vanrofi

Great!

Thx...think I will manage now...i saw a similar link somewhere in the forum but the link did not work. This one works, definitely the info I was looking for.

davmac1

I am currently running this report nightly at a customer using the job queue through a codeunit that calls the report using the methods described in the other posts. Works great.

vanrofi

The 795?

I'm still not convinced on how to give the options to the report, like the boolean for post...put if I indeed run a CU, I can give the parameters to the report.

can you shortly describe the code-modifications you did?

ara3n

you can actual modify the existing report. On prereport add code.

Report - OnPreReport()
If not GUIALLOWED then begin
   PostToGL := true;
end;

vanrofi

ah, that's better...of course, Now I see...I should have known that.

Thx!

ara3n

welcome.