Add QR Code in Crystal Report - Method 2 - SAP B1 Patch

There is an Option other than SAP Patch - Method 1(Click Here)

Or the Below SAP 10 PL02 Patch method

QR codes became popular also outside the automotive industry, and used in applications to include product tracking, item identification, time tracking, document management, and general marketing.

You just have to scan it. But, before you scan it, you have to generate it… for that, SAP Business One introduces new functionality allowing you to assign QR Codes to marketing documents. Enter all relevant values in the General Settings > QR Codes tab:

In the marketing documents, a new field is added in the Accounting tab, where you can either enter text or use formatted search for generating the required value:

Add QR Code in Crystal Report - Method 1 (Need to Buy the DLL)

There is patch available  in SAP B1 10, which have in-build solution for this process. You can check this HERE (Method 2).

The below method is used for SAP B1 9.3,9.2 all patches. This is a paid method, Client need to buy the required DLL for this method.

Please check the website : https://www.morovia.com/

 After installing the above link software you can follow the below 5 steps :

1. Open the Crystal Report with all the Relevant data and Design.

2. Create a formula Filed and Past the below code

// Crystal Reports impose a constraint on UFL string length: max 255 characters.
// To get around this limit, use the code below
// This workaround requires Crystal Report Version >= 9

StringVar DataToEncode := {BarcodeHD_DTL};

        StringVar CompleteBarcodeString:="";

NumberVar i:=0;
NumberVar Segments:=
QRCodeEncodeSet(DataToEncode, 0, 0);
For i:=0 to Segments Do
(
   CompleteBarcodeString := CompleteBarcodeString +
             QRCodeEncodeGet(i);
);
CompleteBarcodeString

3. Set you filed by replacing BarcodeHD_DTL 

Advertisement