PT Sterling Tulus Cemerlang
www.sterling-team.com

Phone
+62-877-8655-5055
+62 (21) 580-6055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower 18th
Jl Jend. Sudirman kav 45-46
Jakarta 12930 - Indonesia

450+ 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.

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

SAP Business One Tips - Display QR Code in Crystal Report

SAP Business One Tips – Display QR Code in Crystal Report

Untuk mencetak QR Code di Crystal Report, kita bisa menambahkan command query di Crystal Report seperti di bawah ini :

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

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

, , , , , , , , , , ,