SAP Business One Notes
3149813 - IN_Dynamic QR Codes for B2C Invoices
Component: SBO-SD (SAP Business One > Sales - A/R), Version: 1, Released On: 16.02.2022
Symptom
The authorities in India have mandated the placement of dynamic QR Codes on business-to-consumer (B2C) invoices for
payments through UPI (Unified Payments Interface) apps.
The requirement to generate QR Codes on B2C invoices allows for scanning of dynamic QR Codes and digital payments by
customers.
Cause
Legal change
Solution
SAP intends to provide a feature package or patch to solve the symptom that is described in this SAP Note. The
section References below lists the related feature package or patch once they become available. Be aware
that References can only be confirmed at feature package or patch release date. SAP delivers feature packages or patches
only for selected releases at its own discretion, based on the business impact and the complexity of implementation.
The generation of QR (Quick Response) Codes has been supported on print layouts of marketing documents since SAP
Business One and SAP Business One, version for SAP HANA version 10.0 patch level 02. For more information, see SAP
Note 2889899.
To generate dynamic QR Codes for UPI apps, we recommend that you use SAP Business One and SAP Business One, version
for SAP HANA version 10.0 FP2105 or higher to take advantage of the improvements for QR Codes provided in FP2105. For
more information, see SAP Note 3066813.
Procedure for Dynamic QR Codes
1) Execute the query that is contained in the attachment to this note (createSPexample) to add a "StoredProcedure"
(TmSp_QRCodeSPGenerated_IN_13) that activates QR Code generation for the India localization on A/R invoice documents.
If you need to add the same functionality for other document types or localizations, see SAP Note 3066813 for details
about the naming convention of stored procedures for QR Code generation.
If you need to change the URL or you are using custom GST tax codes, change the body of the query accordingly.
The provided query collects the required parameters from the following fields (if the fields contain a null value, the query
result will be null so QR Codes will not be generated):
UPI ID: DSC1.IBAN
Account Number: OCRB.Account
IFSC: OCRB.UsrNumber3
Seller Name: OADM.CompnyName
GSTIN: OLCT.GSTRegnNo
The stored procedure (SP) created by the query is called every time an A/R Invoice (object type 13) is added or updated.
The results of the stored procedure are used as source strings for the generation of QR Codes.
The generated PNG file is stored in the table "OQRC" field "FileContnt".
"SrcObjType" gets value 13 (A/R Invoice).
"FieldName" gets value "QRCodeSPGn" (this is the constant value for QR Codes generated by the feature described in
SAP Note 3066813).
"SrcObjAbs" contains the key for the source document, "DocEntry" of the A/R Invoice in this case.
2) QR Codes are generated and stored in table OQRC and can be used in Crystal Report (CR) layouts for A/R Invoices
Add a command to your database source in the CR designer, for example:
select FileContnt,CAST(SrcObjAbs as int) as SrcObjAbs from OQRC where FieldName = 'QRCodeSPGn' and SrcObjType
= 13
Link the added command to the table "OINV" (DocEntry to SrcObjAbs)
Drag and drop the field "FileContnt" from the Field Explorer to your report
Save the layout for use (import) in the usual way.
Attributes
Key Value
Other Components SAP Business One > Reporting > SAP Crystal Reports for SAP Business One (SBO-REP-CR)
Other Components SAP Business One > Localization > India (SBO-LOC-IN)
Products
Products
SAP B1 10.0 FOR SAP HANA
SAP BUSINESS ONE 10.0
This document refers to
SAP Note/KBA Component Title
3066813 SBO-GEN-QR QR Code Generation Enhancement for Marketing Documents and Payments
2889899 SBO-REP-CR Creating QR Codes for Marketing Documents
Attachments
File Name File Size Mime Type
createSPexample.txt 3 text/plain
