QR Code needed to be printed Job traveler

Epicor ERP 10
,
1

Hello,

We are looking to get a QR code printed on each operation of a Job Traveler. This QR code will be linked to our internal server to pull up detailed manufacturing/assembly instructions on each operation for the production operator to refer to.

I found a Image Maintenance module where the QR code images can be stored. It can also be stored on any other database if needed where it can be pulled from.

We need a different QR code for each operation of every part, so it would need to reference the part number and operation number of he job traveler to pull the right image (ideally).

Can you please guide me if this is possible with our current 10.2.500.19 version.

Thank you

Sid Desai
SS White Technologies

2

QR Codes are similar to barcodes in that you create them using a special font. The QR Code can be any text but most commonly they are web addresses (eg https:\mycompany.com\jobDetails). Typically you would store the text of the code in the database not the image and generate the image from the text as needed in reports etc.

If your detailed instructions are stored in such a way they can be accessed via a URL then you can store that URL with the part/job/operation (maybe a UD column is required) and reference that in the job traveler report.

Brett

3

Thanks you for the response Brett. Can you point out how do I activate this QR code feature to be printed on the job traveler? Also how do I link the job traveler to the database of QR code text. Sorry for the specific question, but our IT Manager who knew all the details quit and this has come upon me. I am more of the BA/SME for Epicor optimization rather than the backend programmer.
Thanks
Sid

4

In crystal or SSRS land I use a small web service we host that runs a single PHP script. We just return image document headers and the generated image for 2d codes. For the image location object in crystal or SSRS we just use a URL like this https://mybarcodehost.local/?code=PDF417,4&data=SomeBarcodeData

This is the entire index.php file just requires that tcpdf library. Example 050 : 2D barcodes (QR-Code, Datamatrix ECC200 and PDF417) · TCPDF

<?php
require_once ("tcpdf_barcodes_2d.php");

$code = $_GET["data"];
$type = $_GET["code"];

$barcodeobj = new TCPDF2DBarcode($code, $type);

$barcodeobj->getBarcodePNG();

?>

It’s fairly old PHP code, but for a quick internal service to give me 2d barcodes anywhere it’s good enough.

Here is a real life result of that system from a report of our as a QRCode

image
image978×399 19.9 KB

Copy pasted version of the generated image as QRCode H
image