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

Merge Standard Swiss QR Bill with Custom Sales Invoice Report in one PDF (Business Central)

(8) Share

Report

Posted on by SR-19090744-0

Hello everyone,

I’m trying to add the Swiss QR Bill at the bottom of the Sales Invoice using RDLC Report Builder and AL dataitems in report extension. The QR layout comes from the Microsoft extension (its own report), while our Sales Invoice is a custom report extension of the standard Sales Invoice.

The problem is that they currently run as two separate reports instead of one combined output. There are no page breaks and all expressions given. Has anyone figured out how to merge them into a single report so the QR Bill appears directly at the bottom of the invoice?

Thanks in advance for any help!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Rishabh Kanaskar 6,231 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi,

You cannot merge two reports directly in BC. To combine your custom Sales Invoice with the Swiss QR Bill:
> Embed the QR Bill as a subreport in your Sales Invoice RDLC.
> Use a report extension to pass the QR Bill dataset from the standard QR report into your invoice report.
> Place the subreport at the bottom of the invoice layout so it prints as part of the same PDF.

This approach ensures a single PDF output with the QR Bill included.

Thanks

Rishabh

Was this reply helpful? Yes No
Suggested answer

Nimsara Jayathilaka. 5,128 Super User 2026 Season 1 on at

Like (5)

Report
Copy link

Link copied!

Hi

The recommended solution is to add the Swiss QR Bill report as a subreport in your custom Sales Invoice RDLC layout, passing the needed invoice fields as parameters. This ensures the QR code prints seamlessly at the bottom of the invoice in a single output without rewriting Microsoft’s logic.

Thanks

Nimsara

Was this reply helpful? Yes No
Suggested answer

Sumit Singh 11,799 Super User 2026 Season 1 on at

Like (5)

Report
Copy link

Link copied!
Hi,
What you’re seeing is by design. When you enable Swiss QR‑Bill Management in Business Central, it adds a separate report to Report Selection – Sales, so the invoice and the QR‑bill are rendered as two PDFs, not one. To get one combined output with the QR‑bill at the bottom of your custom Sales Invoice, you must build it into the same report/layout rather than letting the QR‑Bill app print its own report.
Recommended approach (one PDF, QR at bottom of invoice)

Turn off the “extra PDF”

Go to QR‑Bill Setup and clear Sales Invoice under Document Types Enabled for QR‑Bills (or remove the QR‑Bill line in Report Selection – Sales). This avoids generating the separate QR‑Bill PDF.[1]

Extend your invoice report (AL)

Use a report extension on the standard Sales Invoice (or your custom ID) and add the QR‑bill data (IBAN/QR‑IBAN, reference, amount, payer/creditor blocks) to the dataset.

Then add a new RDLC layout in the report extension (you can’t extend the existing layout in-place; you add another layout and set it as default).[2]

reportextension 50100 SalesInvWithQR extends "Sales - Invoice"
{
    dataset
    {
        // Add columns your RDLC needs for the QR bill block
        add("Sales Invoice Header")
        {
            column(QRIBAN; / your code to get IBAN/QR-IBAN /) { }
            column(QRReference; / build payment reference /) { }
            column(QRAmount; "Amount Including VAT") { }
            // ... other creditor / payer fields
        }
    }
    rendering
    {
        layout(SalesInvWithQrRdlc)
        {
            Type = RDLC;
            LayoutFile = 'SalesInvWithQR.rdlc';
        }
    }
}

The QR‑Bill Management docs explain the fields/choices (IBAN vs. QR‑IBAN, reference types, layout options) so you can compute the same content inside your invoice dataset.[1]

Design the QR‑bill block in RDLC

Put the QR‑bill rectangle in the page footer so it sits at the bottom.

Show it only on the last page with a visibility expression such as: Hidden = IIF(Globals!PageNumber < Globals!TotalPages, True, False)

RDLC design guidance is in Working with RDLC layouts.[3]

Why not “merge two reports” at runtime?\ Business Central doesn’t support embedding another report layout into your report; a report extension can add dataitems/columns and new layouts, but you can’t “subreport” the QR‑Bill report or instruct the platform to output two reports as one PDF. The supported route is to include the QR‑bill content in the same report.[2]
Practical tips

Dataset: Add a helper codeunit or reuse logic to build the QR reference string and data. (The QR‑Bill Management feature describes the required elements you must surface in the dataset. )[1]

Layout: Keep strict positioning in the footer so the payment slip prints cleanly on pre‑printed or plain paper. RDLC tools and mechanics are covered here.[3]

Testing: Disable the QR‑Bill line in Report Selection – Sales, set your new layout as Default in Report Layouts, then preview/email to verify it’s a single PDF with the QR‑bill on the last page.[2]

References
[1] QR-Bill Management [CH] - Business Central | Microsoft Learn
[2] Report extension object - Business Central | Microsoft Learn
[3] Working with RDLC Layouts - Business Central | Microsoft Learn
[4] QR-Bill Management [CH] - Business Central | Microsoft Learn
[5] Report extension object - Business Central | Microsoft Learn
[6] Working with RDLC Layouts - Business Central | Microsoft Learn

Response created with the help of Co-Pilot. Please mark "Verified" if it helps.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 101,995 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Hi, hope the following helps.

Dynamics 365 Business Central: Generate Swiss QR Code without external services/APIs

https://yzhums.com/65522/

Dynamics 365 Business Central: Generate barcode through external services/APIs (Telepen, Swiss QR Code, QR codes with colors, images or text……)

https://yzhums.com/56046/

However, your problem seems to be the layout. You can export the standard layout file and try to modify it.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Jeffrey Bulanadi 9,123 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Hi,

By default, the Swiss QR Bill is rendered as a separate report in BC, which results in two PDFs instead of one unified layout. This behavior is by design, but it can be overridden with a clean report extension strategy.

Here’s how to merge the QR Bill into your custom Sales Invoice report:

First, disable the automatic generation of the separate QR Bill PDF:

Go to QR-Bill Setup and uncheck Sales Invoice under Document Types Enabled for QR-Bills.

Alternatively, remove the QR Bill entry from Report Selection – Sales. This prevents the system from generating the second report.

Next, embed the QR Bill layout directly into your custom Sales Invoice report:

Extend your custom report using AL and include the necessary QR Bill fields in the dataset:

IBAN or QR-IBAN

Reference number

Creditor and payer details

Amount

You can export the layout of the standard QR Bill report and reuse its RDLC components.

Position the QR Bill section at the bottom of your invoice layout, ensuring no page breaks interfere with rendering.

If you’re using RDLC, make sure the QR Bill section is placed in the footer or bottom group of the main body, and that it respects the invoice’s page height constraints.

For advanced scenarios, you can also generate the QR code using AL or external services and embed it as an image in the report. This gives you full control over placement and styling.

Helpful Reference
QR-Bill Management – Microsoft Learn
Generate Swiss QR Code without external services – Yun Zhu
QR-Bill App Integration – Continia

If you find this helpful, feel free to mark this as the suggested or verified answer.

Cheers
Jeffrey

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Pallavi Phade 5,742 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Namaste @SR-19090744-0

For our customers in India, we have created completely custom RDLC report with IRN and QR information

There are two options which i can suggest

1) Kindly extend the Sales invoice Report and add QR components to consume . Check width , Hieight , of Page and Header, Body , Footer part in Report RDLC Layout . Page and ( total of Header,BOdy,Footer) should be same inches.

https://community.dynamics.com/forums/thread/details/?threadid=5f6873a8-8ce3-ef11-a730-7c1e52687e75

https://learn.microsoft.com/en-us/dynamics365/business-central/localfunctionality/switzerland/ui-extensions-qr-bill-management - Prerequsities for QR Bills

2) Or Create Fresh Report copying the Sales Invoice Report and do apply the necessary changes .

Regards

Pallavi Phade

Was this reply helpful? Yes No