The add-on works with sample data, from which it is easy to see how it works. The same scripts and processes can be easily linked to your own tables on a central settings page. Various processes can be preset and easily adapted in the scripts as needed.

Swiss payment slip

In order to be able to create a Swiss payment slip, 3 tasks must be clarified for the developer:

1. Compile invoice data
2. Generate QR code
3. Create payment slip

The add-on “Swiss QR Bill Enhanced” solves all these steps, makes them traceable and configurable. The data and QR code are combined into a payment document that can be dragged and dropped onto an invoice layout.

Preparation

In preparation, two fields need to be added to the invoice table: A repeating field will hold the invoice data and a container field will store the QR code. After installing the add-on, this is demonstrated comprehensibly with sample data. Once you understand how it works with the help of the sample data, you can integrate the solution. There are simple settings for this purpose.

The solution works according to the previously mentioned steps. There is a script for each individual step, which can be easily adapted if required.

1. collect invoice data

The invoice data is summarized in a repeating field. The specification for the data provides for certain fixed information, and information from the invoice must be copied in here. What information this is is determined by the specification. A script fills all repetitions. You can easily add your own data fields to this script. The repeating field is, so to speak, the intermediate storage of the information. QR code and payment receipt are now filled from this buffer. This simplifies the delimitation and structure of the information.

2. generate QR code

The QR code is generated from the invoice data stored in the repeating field. This is done using the solution provided as an add-on by Otmar Kramis(here). Thx! The code is generated using JavaScript in a web viewer and stored in a container field of the invoice table.

3. create payment slip

All information is now created and can be summarized for the payment slip. The QR code has been placed in the invoice table and must be inserted from there. All text information for the payment slip is stored in global variables and displayed on the payment slip. The inpayment slip itself has its own styles customized to the specifications. Therefore, the payment slip can be simply dragged and dropped onto the invoice layout. Texts work immediately. Only the container field for the QR code must be linked to the invoice table.

Texts on the payment slip must meet certain requirements. Numbers, IBAN code and the like must be formatted in certain ways. For this purpose, Custom Functions are used, which are part of the add-on.