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

87

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:

Dynamics 365 Business Central

All responses Img

All responses (7)

Answers Img

Answers (0)

Suggested answer

Valentin Castravet 28,272 Super User 2025 Season 1 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 87 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 28,272 Super User 2025 Season 1 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 87 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,761 Super User 2025 Season 1 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 87 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 84,350 Super User 2025 Season 1 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

News and Announcements

Check out the New Agent Creator Community

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

Sohail Ahmed 1,452

#2

YUN ZHU 1,313 Super User 2025 Season 1

#3

Gerardo Rentería Ga... 1,083 Most Valuable Professional

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans