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

Job Queue to schedule running of planning worksheet

(1) Share

Report

Posted on by Amrit

179

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

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Amrit 179 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,202 Super User 2025 Season 2 on at

Like (1)

Report

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

Jun Wang

Was this reply helpful? Yes No
Amrit 179 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,481 Super User 2025 Season 2 on at

Like (1)

Report

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/

Was this reply helpful? Yes No
Amrit 179 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,481 Super User 2025 Season 2 on at

Like (1)

Report

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/

Was this reply helpful? Yes No