News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Job Queue to schedule ...

Small and medium business | Business Central, N...

Suggested answer

Job Queue to schedule running of planning worksheet

(1) Share

Report

Report

Posted on by Amrit

38

Hello,

I am trying to schedule running of planning worksheet (Object ID to Run - 99001017 - Calculate plan-plan. wksh).

but i keep getting the following error,

Please help.

Categories:

Business Central

All responses Img

All responses (7)

Answers Img

Answers (0)

Suggested answer

Valentin Castravet 24,822 Super User 2024 Season 2 on at

Like (1)

Report

Job Queue to schedule running of planning worksheet

Its a very simple customization for a Business Central developer. For example - How do I: Create a Report Extension to add a field to the dataset of a Report? – think about IT

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/
Amrit 38 on at

Like (0)

Report

Job Queue to schedule running of planning worksheet

Thank you @Valentin Castravet,

Can you please walk me through how to procced with the solution you proposed?

Please recommend the reference material, if you have any.
Suggested answer

Valentin Castravet 24,822 Super User 2024 Season 2 on at

Like (1)

Report

Job Queue to schedule running of planning worksheet

I tried and it didn't work for me either. The job queue runs successfully, but if I looked at the planning worksheet errors I had the same errors.

Next I looked at the code of report 99001017. The report has the function SetTemplAndWorksheet, what this means is that when you run the report from the planning worksheet page it will take the template name from the current page you're on. When you run the report from the job queue, there is no where to take the template name from; so this is why you get an error message.

Running the out of the box report in the job queue won't work. You can create a copy of the report and add the template name as a filter field to the report request page. This way in the job queue you can filter on a specific template.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/
Amrit 38 on at

Like (0)

Report

Job Queue to schedule running of planning worksheet

I checked the Requisition worksheet templates are setup properly. Please find below,

Also the Requisition worksheet names,

I still get the same error.

is there any other setup required for this?

Please help!
Suggested answer

Jun Wang 7,443 Super User 2024 Season 2 on at

Like (1)

Report

Job Queue to schedule running of planning worksheet

check below if set up properly, also check the requisition worksheet names to ensure a batch has been set up.

Jun Wang
Amrit 38 on at

Like (0)

Report

Job Queue to schedule running of planning worksheet

Hello ZHU,

I am following all the steps that you mentioned below, but i still see the same error.

The requisition worksheet templates are also setup properly.
Suggested answer

YUN ZHU 73,696 Super User 2024 Season 2 on at

Like (1)

Report

Job Queue to schedule running of planning worksheet

Hi, I simply tested it and didn't encounter your problem.

Please check your Requisition Worksheet Templates page settings again.

Hope this helps.

Thanks

ZHU

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans