PT Sterling Tulus Cemerlang
www.sterling-team.com

Whatsapp
+62-877-8655-5055

Email
sales-enquiry@sterling-team.com

Address
Ruko Graha Arteri Mas Kav 30
Jl. Panjang No.68, RT.19/RW.4
Kedoya Selatan, Kebon Jeruk
Kota Jakarta Barat
Jakarta, 11520 Indonesia

500+ FREE Tips for you from Sterling Tulus Cemerlang (STEM) - SAP Indonesia Gold Partner, and Become SAP B1 Super User

Display QR Code in Crystal Report

SAP Business One Tips Display QR Code in Crystal Report


SAP Business One 10 come with so many updates, one of them is to allow us to print QR Codes in Crystal Report. SAP Business One provides a new field in Marketing Document labeled “Create QR Code From”, placed in Accounting Tab. We can fill anything to be generated as QR Code, for example in a picture below, we fill with information of Document Number and Document Date.

SAP Business One Tips - Display QR Code in Crystal Report

SAP Business One Tips – Display QR Code in Crystal Report

As we fill field Create QR Code From, it will save a record in the database and stored it in Table OQRC, with the detail needed field :

  1. SrcObjType: Source Object Type Document which we fill the QR Code information. In this example, we use the Sales Order Document, so the value is 17.
  2. SrcObjAbs: Source Document Internal Number. In this example, we use the Sales Order Document, so it will link to the field “DocEntry” in ORDR Table.
  3. FieldName: Source Document Field ID in Screen. In this example, we use the Sales Order Document, the field ID is “QRCodeSrc”.
  4. FileContnt : QR Code Image Content.
SAP Business One Tips - Display QR Code in Crystal Report

SAP Business One Tips – Display QR Code in Crystal Report

To print the QR Code in Crystal Report, we can add a command query in Crystal Report like below :

SELECT T1."FileContnt"

FROM ORDR T0

LEFT JOIN OQRC T1 ON T1."SrcObjAbs" = T0."DocEntry" AND T1."SrcObjType" = T0."ObjType"

WHERE T1."FieldName" = 'QRCodeSrc' AND T0."DocEntry" = 2;

Drag the field “FileContnt” from Database Fields into the report designer and QR Code will be showed in Crystal Report.

SAP Business One Tips - Display QR Code in Crystal Report

SAP Business One Tips – Display QR Code in Crystal Report

Also read:

Run Your Business With The Piece of Mind Using SAP Business One

This article was written by PT. Sterling Tulus Cemerlang, SAP Business One GOLD Partner in Indonesia.
More details about SAP Business One,
email to: sales-enquiry@sterling-team.com or call +6221-5806336 or wa +6287786555055

, , , , , , , , , , ,