Using QR codes in Produmex WMS reports

In our example we are going to create QR code for our SSCC using the DefaultProductionLabel.rpt as the base.

Prerequisites:

1. Working with QR-Codes needs a special font
   

   Take the Aztec font-file bcsqrcode.ttf and copy it directly into folder: C:\Windows\Fonts
   
   

2. Installation of required libraries so that Crystal Report can generate QR codes

   
   

   Libs:

   cruflBcs.dll

   cruflBcs_x64.dll 

   These libraries are to be copied into the following directories:

   • cruflBcs.dll file to c:\Windows\SysWoW64
   • cruflBcs_x64.dll to c:\Windows\System32
     
     

   Register the Libraries in Window system (via "cmd"-tool as administrator):

   %systemroot%\SysWoW64\regsvr32.exe  %systemroot%\SysWoW64\cruflBcs.dll
   %systemroot%\SysWoW64\regsvr32.exe  %systemroot%\SysWoW64\cruflBcs_x64.dll
   %systemroot%\System32\regsvr32.exe  %systemroot%\SysWoW64\cruflBcs.dll
   %systemroot%\System32\regsvr32.exe  %systemroot%\\System32\cruflBcs_x64.dll

    

   Hint:

   The Root-directory could have a different name as windows (Check first and then adjust if necessary)
   
   Latest Libraries and the Font can be found on the web for download.
   

   
   
3. Copy the dll files to Produmex WMS add-on and Mobile Client installation folders
   
   Add-on folder:
   C:\Program Files\SAP\SAP Business One\AddOns\PMX\Produmex Add-On Loader 22
   Mobile Client install folder:
   C:\Program Files\Produmex\Produmex Fat Client
   
   
   
4. Design the report file:
   Open the standard DefaultProductionLabel.rpt and rename it to DefaultProductionLabel_SSCC_QRCODE.rpt
   
   
5. Create a new formula for the QR code field
   
   
   
   
6. Choose the newly registered functions and the data you want to encode
   In our example we are encoding pmx_sp_productionlabel stored procedure SSCC field.
   Add the 00 as AI code to the SSCC code you want to encode
   
   Formula:
   BCSQRCodeEncode ('00'+{pmx_sp_productionlabel;1.SSCC})
   
   
   
   
   
7. Place the formula to the report set the font to BcsQrCode and save the report.
   
   
   Hint: you may need to try combination of different font size and alignment to make the barcode fully visible and readable.
   
   
8. Test your report
   
   Printout from Crystal Reports
   
   
   Printout from the Add-on
   
   
   
   Printout from Mobile Client
   

• bcsqrcode.ttf80 KB