Tags: D365FO, Free Edition, Invoice, Proforma, SSRS, X++ 
If you need to generate a SSRS report as a byte array, you can use a utility X++ class DocSrsReportGenerator, which is delivered with Docentric Free Edition. Learn more >>
To learn more about the limitations and different use cases (for example, printing the SalesPackingSlip report to a memory stream) of the DocSrsReportGenerator class, you can check out this forum post!
However, this class cannot be used for proforma scenario. Printing Sales invoice proforma can be done via the SalesFormLetter class. To generate a proforma as byte array, we will use Docentric Memory print destination and the DocReportRunDelegates.printToMemoryEnd delegate. Please note that you can also use any other Docentric print destination instead if needed.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 |
class DocExamplePrintSalesInvoiceProforma { public static void main(Args _args) { DocExamplePrintSalesInvoiceProforma::printSalesInvoiceProforma(); } public static void printSalesInvoiceProforma() { SalesFormLetter salesFormLetter = SalesFormLetter::construct(DocumentStatus::Invoice); SalesParmLine parmLine; SalesLine salesline; SalesTable salesTable; SRSPrintDestinationSettings pds; salesTable = SalesTable::find('000700'); salesFormLetter.salesTable(salesTable); salesFormLetter.transDate(systemDateGet()); salesFormLetter.specQty(SalesUpdate::All); salesFormLetter.proforma(true); salesFormLetter.printFormLetter(true); salesFormLetter.usePrintManagement(false); // To generate a proforma as byte array, you can use Docentric Memory print destination. // Note that you can use any other print destination as well, e.g. Docentric Printer, which will // result in distributing proforma report to this destination, e.g. to the selected network printer. pds = new SRSPrintDestinationSettings(); pds.printMediumType(SRSPrintMediumType::Memory_DC); // Use the default Docentric design. pds.parmMemoryPrintDestSettings_DC().parmUseSsrsBuiltInDesign(false); pds.parmSrsPrintReportSettings_DC().setProperty_PrintSrsOriginalDesign(false); pds.parmMemoryPrintDestSettings_DC().parmOutputFileFormat(DocOutputFileFormat::PDF); /* Uncomment this code if you want to use the original SSRS design instead */ //pds.parmMemoryPrintDestSettings_DC().parmOutputFileFormatSrs(SRSReportFileFormat::PDF); //pds.parmMemoryPrintDestSettings_DC().parmUseSsrsBuiltInDesign(true); //pds.parmSrsPrintReportSettings_DC().setProperty_PrintSrsOriginalDesign(true); salesFormLetter.updatePrinterSettingsFormLetter(pds.pack()); // Due to standard bug the system still executes print management configuration, but replace print destinations with the one explicitly provided (for Original and Copy) // Print destination for Copy print management configuration with blocked report generation. pds = new SRSPrintDestinationSettings(); pds.parmSrsPrintReportSettings_DC().parmExecuteOnlyData(true); // block report generation salesFormLetter.updatePrinterSettingsFormLetter(pds.pack(), PrintSetupOriginalCopy::Copy); salesFormLetter.initParmSalesTable(salesTable); salesFormLetter.initParameters(salesFormLetter.salesParmUpdate(), Printout::Current); salesFormLetter.initLinesQuery(); salesFormLetter.run(); } // Use the following delegate to get the report content as byte array when printing to Docentric Memory print destination. [SubscribesTo(classStr(DocReportRunDelegates), delegateStr(DocReportRunDelegates, printToMemoryEnd))] public static void DocReportRunDelegates_printToMemoryEnd(DocPrintReportSettings _printReportSettings, DocPrintDestSettingsMemory _memoryPrintDestSettings, DocPrintReportToMemoryExecutionInfo _memoryExecutionInfo, DocEventHandlerResult _result) { // Check if the printing report is Sales invoice. if (_printReportSettings.parmReportId() == ssrsReportStr(SalesInvoice, Report)) { // Check if this is a proforma. SalesInvoiceContract reportContract = _printReportSettings.parmSrsReportContract().parmRdpContract(); RecId journalRecId = reportContract.parmRecordId(); if (!CustInvoiceJour::findRecId(journalRecId)) { // Check if the document has been successfully generated. if (_memoryExecutionInfo.isExecutionSuccessful()) { // Use the generated document as byte array or memory stream as needed. // We'll just send the file for download in browser. str invoiceId = _printReportSettings.parmArchiveContract().parmDocumentId(); str filename = strFmt('%1 %2.%3', 'SalesInvoiceProforma', invoiceId, _memoryPrintDestSettings.getResolvedOutputFileType()); DocFileMngHelper::sendFileToUser(_memoryExecutionInfo.getReportContentAsMemoryStream(), filename); } } } } // Use the following delegate to get the report content as byte array when printing to any print destination. [SubscribesTo(classStr(DocReportRunDelegates), delegateStr(DocReportRunDelegates, generateReportContent))] public static void DocReportRunDelegates_generateReportContent(DocPrintReportSettings _printReportSettings, DocPrintedReport _printedReport, DocEventHandlerResult _result) { // Check if the executing report is Sales invoice printed to Docentric Memory print destination. if (_printReportSettings.parmPrintDestination() == DocPrintDestination::Memory && _printReportSettings.parmReportId() == ssrsReportStr(SalesInvoice, Report)) { // Check if this is a proforma. SalesInvoiceContract reportContract = _printReportSettings.parmSrsReportContract().parmRdpContract(); RecId journalRecId = reportContract.parmRecordId(); if (!CustInvoiceJour::findRecId(journalRecId)) { // Use the generated document as byte array or memory stream as needed. // We'll just send the file for download in browser. str invoiceId = _printReportSettings.parmArchiveContract().parmDocumentId(); str filename = strFmt('%1 %2.%3', 'SalesInvoiceProforma', invoiceId, _printedReport.getOutputFileFormat()); DocFileMngHelper::sendFileToUser(_printedReport.getReportContentMemoryStream(), filename); } } } } |