Date: 11/18/2021

Technologies: Advanced PDF, WMS, NetSuite

Team: Emile Le Saux-Racette

Our client’s often request that we help them insert a scannable bar code or QR code referencing the item UPC or alias into NetSuite transaction PDF templates for documents such as sales order confirmations, pick tickets, packing slips, and invoices. This blog outlines the two quick steps you can take to add a custom item bar code to your NetSuite advanced templates. This may or may not be the best solution for your requirement, so feel free to connect with me and the team at Bryant Park Consulting to discuss your specific barcode printing use case.

Step 1: Source the item UPC into a custom transaction column field.

Since the item’s UPC code resides on the item record, you can add a custom column field that sources the item’s UPC code into the transaction line. The field should be field type of free-form text, shouldn’t store value, and on the Sourcing and Filtering Tab you can configure the field to source the UPC code (Source From) the Item (Source List). Once you’ve added the field to the appropriate form, create a test transaction to see the UPC source into the custom transaction line field.

Step 2: Add this field to the Advanced PDF/HTML Template and display as barcode.

Navigate to open the Advanced PDF/HTML Template that you want to add the item barcoding to (Customization > Forms > Advanced PDF/HTML Templates). Edit the desired template and switch to the source code view, instead of the WISYWIG editor, to incorporate your new field data and display it as a barcode by using a string similar to the one below. Note that the full list of supported bar code algorithms (codetype=) can be found in SuiteAnswers ID#26486 and that you likely need to adjust the alignment and size of the barcode in the string below to suit your specific layout. Finally, preview and save the template and print the document to see the newly added bar code or QR code that you have added.

Find the <#if record.item?hascontent> section of the Advanced PDF/HTML Template and insert the following string within that table replacing YOUR_FIELD with your field ID:

<td align="center" colspan="5" style="width: 215px;"><#if item.YOUR_FIELD?has_content><barcode style="width: 100%;" codetype="code128" showtext="true" value="${item.YOUR_FIELD}"/></#if></td>

At Bryant Park Consulting we help companies implement, optimize, and streamline complex supply chain and inventory management requirements with NetSuite. If you are looking for expert advice to help you maximize returns on your NetSuite investment, please get in touch with us today.