Hello everyone,
I have a problem printing a purchase order in D365 F&O because I keep getting an error
(Unable to find the report design MBSPurchPurchaseOrder.Report.)
. Additionally, this report does not exist in the Docentric reports. If possible, I would like to change the report used for the purchase order to another report. Unfortunately, I can’t find where to change the print report for the purchase order.
Hi @khiar_mohamed,
There are quite a few things we need to cover here, but most of them are not related to Docentric. For some of these, you’ll need either development knowledge or assistance from a developer. Let’s address them one by one:
Error “Unable to find the report design…” comes from the SSRS processing, before it reaches Docentric. It means that the report isn’t deployed on the SSRS server. As you say that this happens on the DEV environment, you can deploy the report from your Visual Studio.
You say that you cannot locate this (custom) report in the Docentric reports list. It is because it isn’t registered – please look in our how-to manuals for the instructions on how to setup Docentric reports.
You say that you would like to change the report used for PO. If you are printing through Print management, then you can select a different SSRS format there. If you are just using Preview, then it means that your developer has switched in the code which SSRS format is default, so you would need to discuss it with your developer.
If you need further clarification or support, feel free to reach out. We’re here to help with any Docentric-related questions.
Yep, you are right, Amir. I deployed all the reports from my model using PowerShell. I think this link will be helpful for others to deploy using PowerShell if they don’t know the report’s project :Deploy SSRS Reports using PowerShell in D365 F&O
Amir. I already have the SSRS version of the report. I registered the docentric version using the link provided by you. Still getting the same error. I am also in dev environment. I can preview the report on the docentric screen. When I do the actual screen, I get the error.
Hi @Subodh_Kant, welcome to the Docentric community!
Can you please explain how is the report ran when you say you can preview it on Docentric screen? This would mean that the PIPCAPACaseDetail.Report can be run on the Docentric Screen print destination but not the standard SSRS Screen print destination?
Additionaly, as my @AmirO mentioned already, the error message “Unable to find the report design… ” comes from the SSRS pipeline, before Docentric even kicks in. That would mean that the report should be printed on SSRS Screen destination as expected.
Can you please also share the report setup you have done for the PIPCAPACaseDetail.Report in Docentric?
Hi @Subodh_Kant ,
Based on the error “Unable to find report design”, you didn’t deploy your custom report to SSRS server. Please do so from Visual Studio and try again.
Hi Subodh Kant,
You need to deploy the report. Please try using this script in PowerShell. Ensure you run PowerShell as an administrator and then paste the following script:
K:\AOSService\PackagesLocalDirectory\Plugins\AxReportVmRoleStartupTask\DeployAllReportsToSSRS.ps1 -PackageInstallLocation “K:\AosService\PackagesLocalDirectory”
Hi @khiar_mohamed Thanks for the reply. When I run the command in the Power shell. I got this error.
Thank @BlazJ. I am looking forward to hear from experts
Hello again @Subodh_Kant , try to make the operation like this, let me know if that help you :
@khiar_mohamed thank you for sharing the command over CLI, this is definitely a great way to deploy all SSRS reports to the server in one go.
I did tweaked it a bit to make it work on my side:
So it looks like this:
C:\AOSService\PackagesLocalDirectory\Plugins\AxReportVmRoleStartupTask\DeployAllReportsToSSRS.ps1 -PackageInstallLocation "C:\AOSService\PackagesLocalDirectory"
@Subodh_Kant have you tried it with these slight modifications?
@khiar_mohamed Thanks for the detailed instructions. It has fixed my issue. I appreciate your help
Thanks, @SemirT for looking it for me.
You’re welcome @Subodh_Kant ! Could you please make it a solution so that others can find it easily
@khiar_mohamed I would have loved to do it. But You have already accepted the solution since you are the topic owner.Post#2 by @AmirO. Please advise If I can still mark it a solution