Product Information
QR-Bill in SAP S/4HANA onPrem
The QR-bill is replacing the existing multiplicity of payment slips in Switzerland and so is helping to increase efficiency and simplify payment traffic, at the same time offering a way of dealing with the challenges presented by digitalization and regulation. The new bills contain all the payment information in a QR code and can simply be scanned digitally.
The QR-bill replaces the current orange and red Swiss ISR (Inpayment Slip with Reference Number) starting on June 30, 2020.
This blog post helps you understand the individual functionalities and solutions regarding the QR-bill. To help you understand the QR-bill solution, this blog is divided into two parts:
Enabling QR-Bill Functionality
QR-Bill Reference
QR-bill can be in three different versions:
- QR-IBAN with QR reference
The QR-IBAN is comparable to the International Bank Account Number (IBAN) that identifies the supplier’s international bank account number that is used during a payment transaction. The QR-IBAN contains the QR-IID (bank identification) in positions 5-9, using a number range from 30000 through 31999. QR-IBAN must be used for payments with a structured reference. The formal structure of this IBAN corresponds to the rules defined in ISO 13616.
The QR reference type is a 27-digit reference. This reference type follows the same rules as the former ISR reference. Position 27 contains a check digit according to modulo 10 recursive. It can be used with a QR-IBAN (IID 30000-31999) only.
- Standard IBAN without a reference
If you choose this reference type, no reference will be created. You can use this reference type with a standard IBAN, not with a QR-IBAN.
- Standard IBAN with ISO creditor reference
The ISO creditor reference type is a maximum 25-digit reference generated according to ISO 11649. The reference starts with ‘RF’, then followed by 2 check digits, and then maximum 21 characters – altogether maximum 25 characters. You can use this reference type with a standard IBAN, not with a QR-IBAN. ISO 11649 reference can be used internationally.
Configuration of Parameter Types
To enable the QR-bill functionality, follow the guideline below.
In Customizing for Financial Accounting under Financial Accounting Global Settings > Global Parameters for Company Code > Maintain Additional Parameters:
There are two new parameter types available: CHQR. For these parameter types, enter parameter values as follows:
«empty» | ISR number only |
B |
Both, ISR number and QR-IBAN Note: this option will be used in the transition period when both ISR Number and QR-IBAN will be allowed |
Q | QR-IBAN only |
Configuration of Payment Method
Create a payment method for the ISR outgoing payment procedure with QR-IBAN in transaction Maintain Payment Program – Payment methods in country (transaction code FBZP).
Ensure that the followings are set:
- You have selected the ISR Payment Procedurecheckbox in the Payment Method Classification group box.
- You have selected the Bank Detailsand the IBAN Required checkboxes in the Required Master Record Specifications group box.
- You have maintained vendor master data with this newly created payment method.
Activating the Fast Entry Functionality
For the ISR Subscriber Number Solution:
Fast entry functionality helps the user to quickly find vendor with specific ISR number during document posting. The ISR number is assigned to the vendor master data.
Activate the fast entry in transaction Accounting Editing Options (transaction code FB00) by selecting the following checkboxes:
- Fast Entry with ISR Number/QR-IBAN
- ISR Entry with Control Display
After the activation, when you enter an ISR number in the document, the system searches for the vendors having the same ISR number in their master data and display the list so that you can select the relevant one in transaction FB60.
For the QR-Bill Solution:
The QR-IBAN is entered as a regular bank connection in the vendor master data. More than one QR-IBAN can be entered for one vendor.
Activate the fast entry in transaction Accounting Editing Options (transaction code FB00) by selecting the following checkboxes:
- Fast Entry with ISR Number/QR-IBAN
- ISR Entry with Control Display
After the activation, when you enter a QR-IBAN in the vendor invoice, the system searches for the vendors as follows:
- The system searches for all entries with the QR-IBAN in the IBANdatabase table (technical name: TIBAN).
- The system takes BANKS, BANKL, and BANKN values from each TIBAN entry and searches for the vendor bank connections (LFBK).
Note: If the system does not find any vendor with the QR-IBAN you entered, a warning message is displayed, and the user must enter the vendor number manually.
Accounts Payable
Posting documents with QR-IBAN
Vendor invoices can be created and posted in transaction Enter Vendor Invoice (transaction code FB60).
If you use only the ISR number solution, enter the ISR number and the ISR/QR reference number in the relevant fields.
If you have chosen to use only the QR-bill or both the QR-bill and the ISR procedure solutions, enter the QR-IBAN and the ISR/QR reference number in the relevant fields.
ISR subscriber number visible
Transition period: both ISR subscriber number and QR-IBAN visible
Only QR-IBAN visible
Validations during document posting
When you enter a QR-IBAN, you must also enter the QR reference and when you enter the QR reference, you must also enter the QR-IBAN. The provided QR reference must be valid. The provided QR-IBAN must be of countries CH or LI and must be of proper IID. It is not possible to enter both ISR Number and QR-IBAN.
Additional Information in QR-Bill
In the payment part, two elements «Unstructured message» (Ustrd) and «Billing information» (StrdBkginf) are available as additional information. The number of characters in the two fields together must not exceed 140 characters:
Unstructured messages can be used to give the payment purpose or for additional textual information about payments with a structured reference. Unstructured references are printed on the payment part under the heading «Additional information».
Billing information contains coded information of the biller for the bill recipient. The data is not forwarded with the payment, but it is printed on the payment part. The coding of the element always begins with delimiter «//».
Field Addl Info is available in the financial transactions. By double-clicking this field, the content is split into Structured and Unstructured Info fields. When you save the entries, the content of these two fields are concatenated.
Alternative payee data
When the FI document is posted with QR-IBAN or Additional Info, Vendor address and bank data are always automatically copied into the Alternative payee data (BSEC).
You can change or display the alternative payee data in transactions Change Document (transaction code FB02) or Display Document (transaction code FB03), by choosing Extras > Alternative Payee.
- When Additional Info and Partner Bank Type (BVTYP) fields are filled, the system clears BVTYP and creates Alternative payee data (BSEC).
- When CH/LI IBAN that matches Vendor Master Data (LFBK) is entered and Additional info is empty, field Partner Bank Type (BVTYP) will be filled.
- When Partner Bank Type (BVTYP) is entered and Additional Info OR QR IBAN is empty, the value stays in BVTYP.
Please note BVTYP cannot be used along with BSEC and will always be empty. Bank data, in that case, are always maintained in BSEC.
Entering ISO Creditor Reference into FI Document
ISO Creditor Reference has to be entered in the field Payment Reference.
If the field Payment Reference is not available in the FI transaction on Vendor line item, it is necessary to change the Field status group on Reconciliation Account and set the filed as Optional. This is done following way:
- In transaction FS00 display Reconciliation Account and find to which Field Status group it is assigned to.
- In IMG activity: Financial Accounting (New) – Accounts Receivable and Accounts Payable – Business Transactions – Outgoing Invoices/Credit Memos – Define Field Status Variants (transaction OBC4), set the field Payment Reference for the previous Field status group as Optional entry.
- In transaction FB60, the field Payment Reference is available in the Payment folder.
Accounts Receivable
QR-bill slip is generated during the outgoing invoice processing and sent to the corresponding business partner to pay it. The electronically readable Swiss QR-code contains all payment-relevant data.
After the business partner has paid the QR-bill, the bank sends a camt.053 or a camt.054 file to the business partner who created the QR-bill. The paid item in the camt.054 file contains a unique reference that is used to search for and clear the corresponding line item in the system.
Configuration of Control Data
You can define rules for generating the reference number of QR-bills and make additional settings for the creation of outgoing invoices. When you read an electronic bank statement file, the rules defined for the reference number are used to de-compose the reference number into document number and customer number to enable the search algorithm to find the open items that were created during the posting of the SD invoice.
You can define control data for the following settings regarding the QR-bill:
- You can map data for the generation of the reference number of QR-bills.
- You can set whether you want the payment amount or the billing information to be printed on the QR-bill, or if you want to print the QR-bill.
- You can define how you want the payment data to be added to the invoice.
You can make all these settings in Customizing for Cross-Application Components, under General Application Functions > QR-bill > Switzerland/Liechtenstein > Define Control Data for QR-Bill.
This view contains keys and common data:
- QR-IBAN/IBAN
- Document and Customer number length and offset in QRR and SCOR Reference
- Parameters relevant to QR-bill form layout
In the last four columns of this view, it is possible to control data for Sales and Distribution and data for Finance. In the SOrg. column, sales organization can be assigned. In the Acct Mod. column, you can control the account determination if you want to post the amount to a bank subaccount. You can also choose an application indicator (Application Ind.) as a selection characteristic for importing bank statements. You can also decide if you want a dunning notice to be printed for a QR-bill (Print Dunning Notice).
Generic parameters for printing:
No amount | No amount will be printed in the QR-bill |
NoBill.Inf | The structured billing information will not be printed |
No Print | QR-bill is not printed for this table line |
Format Par | Select the format to be printed |
QR Prov. | Provider of the tags for structured billing information |
Ref. Type |
Reference Type QRR is used for the replacement of ISR payments with QR-IBAN Reference Type SCOR is used for ISO 11649 Creditor Reference |
Configuration of Search Priorities
After the data in the bank statement has been imported, the system searches for the open items in the system and matches them to the imported payment data for further processing, which is posting and clearing activities. Optimize the search for these open items by defining search strategies and setting the priority order of the search strategies in the Define Search Priorities configuration step. You can use the predefined search strategies, or you can create your own search strategy.
Process Bank Statement
You can import the data from the CAMT.053 (version 4) and the CAMT.054 (version 4) bank statements that contain all the incoming payment data, including the ones according to the QR procedure, following the standard process as described in Electronic Bank Statement: Application.
During the import process, the system calls the FIEB_800_ALGORITHM function module that contains a predefined interpretation algorithm. This algorithm applies the search strategies in the priority order for matching open items. The search strategy defines the rule of how the system searches for open items. For information about the function module, see SAP Notes 2283622 and 2532498.
The system clears the open items based on the QRR/SCOR references that contain the customer and the document numbers when the CAMT.054 file is uploaded.
For mapping of bank statement in XML format into internal structures, the following transformations are used:
- FIEB_CAMT053_V4_ISR_TO_FEB for CAMT.053 processing
- FIEB_CAMT054_V4_ISR_TO_FEB for CAMT.054 processing
Dunning Notice
The dunning notice is available in a standard PDF dunning form with QR code (F150_DUNN_PDF_CH_QR).
The form must be assigned to dunning level in the Customizing activity Assign Dunning Forms:
To generate payment advice from dunning, select the Indicator: Generate Payment Advice (Adv) checkbox.
To generate QR-bill data to the form, assign the “O” value in the Form ID field.
Print Control
In order to print dunning notice, the following parameters for company code IBAN/QR-IBAN must be set in transaction QRBILL_CH_REF:
- No Print – must not be selected
- Print Dunning Notice – field Print Dunning Notice must be selected
Form layout control
The layout of the form can be controlled in QR-bill Control Data
- Format Par – defines form layout
SAP supports following formats:
01 | PDF form with Scissors |
02 | PDF form with Separated Lines |
03 | Integrated QR-bill A4 |
04 | Separated QR-bill A5 |
05 | e-Bill |
- No Amount – Amount is not printed
- NoBill. Inf – Billing information (SWICO tags) is not printed
See Transactions Prepared for the QR-bill on the SAP Help Portal.
See more information regarding QR-bill on SAP Help Portal or in collective note 2673953.
Do you have any further comments regarding this topic? Do not hesitate to share them in the comment section below. You are also welcome to ask any questions about SAP S4/HANA Finance in the Community Q&A section.
Hello Michal,
Thank yo very much for this explanation. However, I still have a question on the place(s) where the vendor QR-IBAN is stored. I see that it is at the invoice level in BSEC + TIBAN, but is it really requird to have it stored in the vendor master bank data (LFBK + TIBAN).This way, the same bank account would be stored twice in LFBK: the 'old' IBAN and the QR-IBAN.
Do we upload the complete bank master QR-IID (key between 30000 and 31999) in BNKA like we did with the old bank master? I have not yet found any code table in Six-Group or other website.
In case we indeed need to mass-upload vendor QR-IBAN, is there a utility that can convert the IBAN into QR-IBAN?
Finally, when a Swiss vendor invoices another (non-Swiss) company code in the system, will the payment run in this company code always select the IBAN and not the QR-IBAN?
I know this is a lot of questions, but thanks very much indeed,
Alex
Hi Alex,
I hope this answers your questions.
Regards,
Tomas
Hi ,
I have some questions about the IBan / Qr-iban.
Qr-Iban are stored in Vendor master data or not ?
If Qr-Iban are stored in Vendor master data, then how we will distinguish between the QR-Iban and IBAN details at the invoice level.
As per QR Reference type SCOR, Iban details are fetched which is stored in Vendor master data.
Similarly, QR reference type QRR, Qr-Iban details are also stored in Vendor master data under the Payment transaction tab.
What is the difference between these two.
Thanks & Regards,
Hi Machal,
Great blog. Very helpful.
One addintional question. If we want to scan the QR-Code to fill the fields in FB60 is there a recommended way how to do this?
Kind regards
Sigi
Hi Sigi,
SAP does not provide any scanning functionalities so this needs to be communicated with 3rd parties like implementation partners or the scanning device manufacturer.
Best regards,
Michal
Hi, -congrats. Great note.
I would appreciate your feedback about Swiss company scenario.
In relation House Banks:
A) when Swiss company gets a new QR-IBAN that replaces a previously IBAN bank account, How is the correct way to setup or proceed/what does SAP recommends?
A.a) Create the new one (QR-IBAN) and delete the IBAN bank account.
A.b) Create the new one (QR-IBAN) and set an end use date for the IBAN bank account.
B) when Swiss company gest a new QR-IBAN not replacing a previous IBAN bank account, how is the correct way to setup or proceed/what does SAP recommends?
In relation these 2 possible scenarios ( A.a) and A.b) ). Which possible impact could be, for example,
In relation B) scenario, what possible impact and/or how suggested to proceed?
Thanks. Kr.
Dear Casto,
In general, it is to say that the concept of the Swiss QR-bill is set up that way that it replaces the formerly known ISR Inpayment Slip with Reference Number payment method for domestic payments in CHF and EUR. Hence also the successor QR-bill Inpayment slip with QR-IBAN and QR reference is for a domestic payment for CH/LI and in CHF and EUR only, cross-border payments should always implement a variant of the QR-bill with IBAN (see also the QR-bill processing rules).
The QR-bill as such offers 3 different options:
In addition, it is to say that acc. to the concept of the QR-IBAN it's also possible that it may also be a virtual IBAN only. As a result, in this case, it is not possible to derive the IBAN of the actual account directly on the basis of the QR-IBAN (for details see document 04 Virtual Accounts (PDF) https://www.postfinance.ch/content/dam/pfch/doc/460_479/470_91_4_en.pdf available under https://www.postfinance.ch/en/business/products/accounts-receivable-solutions/qr-bill.html).
Since some banks also use a virtual QR-IBAN and some are not and since QR-IBAN is a domestic payment only from our point of view it's not a matter of replacing an existing IBAN with a new QR-IBAN (so neither A.a) nor A.b), but to add the QR-IBAN to your maybe already existing house bank because they can still co-exist or create a new house bank with IBAN and QR-IBAN (your bank provides an IBAN either way). Electronic Bank Statement (EBS) processing shouldn't cause any issues because it's not a transition from IBAN bank account to QR-IBAN but a supplement.
For additional QR-bill related information see the different documents available under https://www.paymentstandards.ch/de/shared/communication-grid.html, some of them are also available in EN like the
Processing rules for QR-bills (English), Technical information about the QR-IID and QR-IBAN (English) etc.
In case you need to use a new QR-IBAN as your house bank account then there is the same way how to achieve it as you would use a new IBAN in a different bank.
It cannot directly replace/rewrite the normal IBAN as the bank key differs for both of them.
In the case of additional queries please kindly reach out to us again!
Best regards,
Michal
Hi Michal,
Thanks a lot for your time and feedback, really very useful and interesting.
In relation next topic you talk about.
Thanks. Kr.
Hello,
Congratulations for the topic, very clear and helpful.
I still have a question concerning the Fiori Interface. Is the field QR-IBAN is displayed in the "Manage supplier invoice" tile (F0859) or do we have to use the FB60 old transaction.
Regards
Dear Mathieu,
the Manage Supplier Invoice does not have the QR-IBAN field.
besides the FB60 transaction, there is also a visual harmonized app https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps('FB60')/S22OP
Best regards,
Michal
Hi
Thank you very much for this useful blog, really clear and easy to follow.
Do you have an idea/ documentation on how to set up a scanning tool in order to fill the QR Iban and reference
We use Zebra scan but the QR code is not populated correctly
Thank you,
Have a good day
Jean
Hi all
We have to post Accounts Payable Invoices with FB01. How to I get the QR-IBAN into the screen? I have the reference - not the IBAN. FB60 works fine - but we have to post some invoices with FB01.
Thanks for your help, liebe Grüsse, Inge
HI Ebner,
the FB01 should work in the same way as FB60.
In case you have the QR-IBAN and Reference in FB60 and you can not see it in FB01 (for the same company code) then you should create an incident to FI-AP-AP-B1.
do you have all notes implemented as mentioned in collective note 2673953 https://launchpad.support.sap.com/#/notes/2673953 ?
Best regards,
Michal
Hi Michal,
Why does SAP treat QR Iban vendor invoices on regular vendors similar to one-time vendors?
SAP allows the manual entry of a qr iban and gives only a warning in case the qr iban does not exist yet in lfbk table and we cannot switch it to error.
Where is the segregation of duties? Before a department would take care of master data ideally with dual control and another department would post the invoice (without creating bank data) and now SAP basically coded you can post qr invoice and put any qr iban you like. Why does SAP use the bsec table at all and did not keep the same concept of segregation of duties?
Thanks in advance for your opinion&facts.
Pedro
HI Pedro,
QR Bill or better to say QR IBAN is a successor of the ISR number.
As the ISR number was entered during the document entry and it was not connected to supplier master data so also the QR IBAN is not.
If you want it is possible to implement validation routine which will check whether the QR IBAN is in the master data.
Best regards,
Michal