Best method to print a report through Job Queue - BC SaaS

(1) Share

Report

Posted on by MahGah

15,430

in BC SaaS you cannot select Print for Job Queue to print a selected report in job queue. I saw idea that requested this function. But meanwhile what is the best method to accomplish this?

Thanks

All responses (8)

Answers (1)

Verified answer

vanBeers 11 on at

Like (1)

Report
Best method to print a report through Job Queue - BC SaaS

Hi,

I faced this same issue with a customer and at first, I couldn't get it to work either.

But finally, I managed to get it working:

A Universal Printer for the warehouse has been setup

Created a Job Queue Entry for a Report (in this example report 5752 - Picking List for the printing the Inventory Pick)

The Report Output Type could not be set to Print via this page

This provides the error message: You cannot select a printer from this online product. Instead, save as PDF, or another format, which you can print later.\\The output type has been set to PDF.)

Instead, I created a configuration package for table 472 and modified the Report Output Type to Print by skipping the validation of this specific field. Which is accepted by BC

Then, I added a filter to the Report Request Page of Report 5752:

No. Printed = 0

This customer then creates Inventory Picks automatically via Report 7323 - Create Inventory Put-away/Pick/Movement

After the Inventory Picks have been created, the Job Queue for Report 5752 has created a print job for the Universal printer that has been setup in the Printer Selection.

So, there is no need for selecting a Printer Name in the Job Queue, the Printer Selection will work as well

N.B.: this will work for an emailprinter as well I have tested this and received the email in my mailbox.

Hope this will help
Suggested answer

Marco Mels on at

Like (1)

Report

RE: Best method to print a report through Job Queue - BC SaaS

Hello,

It only has 9 votes so not a huge request yet. To help, I voted for the idea.

Thanks.
Suggested answer

MahGah 15,430 on at

Like (0)

Report

RE: Best method to print a report through Job Queue - BC SaaS

Hi Marco Mels

Thanks for response. Idea has been submitted before by another user. My guess is at the beginning since no method for printing was available Microsoft decided to do this. But right now we have email and universal print (by Microsoft) and some others.

Is it any way that we can expedite this request since I found some other posts related to this request.

experience.dynamics.com/.../

Thanks
Suggested answer

Marco Mels on at

Like (0)

Report

RE: Best method to print a report through Job Queue - BC SaaS

Hello,

This is by design based on code:

if "Report Output Type" = "Report Output Type"::Print then begin

if EnvironmentInfo.IsSaaS then begin

"Report Output Type" := "Report Output Type"::PDF;

Message(NoPrintOnSaaSMsg);

end else

"Printer Name" := InitServerPrinterTable.FindClosestMatchToClientDefaultPrinter("Object ID to Run");

NoPrintOnSaaSMsg: Label 'You cannot select a printer from this online product. Instead, save as PDF, or another format, which you can print later.\\The output type has been set to PDF.';

If you want this to be changed, which I can imagine you want, please raise it as an idea via https://aka.ms/bcideas .

Thanks.
MahGah 15,430 on at

Like (0)

Report

RE: Best method to print a report through Job Queue - BC SaaS

Thanks Mr Yun

I have no issue to use universal printer but as soon as I select Print in Job Queue I receive the following error. Hence, nothing will print because the setup is PDF (or word, Excel) and not print. This is on SaaS and cannot be replicate in On-prem or docker.

Am I missing something here?

Thanks
Suggested answer

YUN ZHU 74,149 Super User 2024 Season 2 on at

Like (0)

Report

RE: Best method to print a report through Job Queue - BC SaaS

Hi, It might be possible with Universal Print. But as far as I know, it's not free.

https://docs.microsoft.com/en-us/dynamics365-release-plan/2021wave1/smb/dynamics365-business-central/support-cloud-printing-using-universal-print

https://docs.microsoft.com/en-us/dynamics365/business-central/ui-specify-printer-selection-reports

Some info about Universal Print in Dynamics 365 Business Central Launch Event 2021 Release Wave 1.

Hope this will help.

Thanks.

ZHU
MahGah 15,430 on at

Like (0)

Report

RE: Best method to print a report through Job Queue - BC SaaS

Thanks

What I mean is if in Job Queue (SaaS version) instead of PDF user select Print then receive the message about this is not possible. For example, I want to set the system up to run the job queue and print pick instructions (just as an example) then I cannot select the Printer to print. How I can accomplish this?

I like the Power Automation idea. But I do not know how to do it? I mean how I trigger Power Automation after report generated as PDF? Where in Power Automation I define the printer? etc

Thanks
Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

RE: Best method to print a report through Job Queue - BC SaaS

Noe sure if i understand you correctly. But one option could be to save the report to a PDF and let Power Automate do the printing.