Client would like to customize a PDF item label in NetSuite and add a QR code, you will need to follow these steps:
- Determine the information you want to include in the QR code, such as the item’s name or ID.
- Generate the QR code image using a QR code generator tool, such as a free online QR code generator.
- Modify the existing PDF item label template to include the QR code image.
- This can be done by going to Customization > Forms > Advanced PDF/HTML Templates and selecting the appropriate form to modify.
- Test the new item label by printing it out and scanning the QR code with a QR code scanner app on a smartphone or tablet.
Proposal summary
The proposal describes the process of customizing the item label PDF. On clicking the Print Label button in the item record, item label pdf will be printed.
Requirement
eVersum-Austria-NS would like to implement customizations in item label PDF. The client has shared the Bunning item label as a reference for the fields to be required in the PDF.
They would like to create an item label pdf in the below format.
Our Solution
The requirement can be achieved by adding a custom button in the item record and on clicking the button the item label will be printed.
In the NetSuite standard, we are unable to generate the custom printout for the Item Label using these details. The advanced item Label pdf has some limitations in including these fields.
This can be achieved by creating a script for adding a custom button named Print Label in the Item record for printing the Item label. On clicking the button, the custom script will generate custom pdf template and will generate the corresponding printout of the item label.
“Print Label” Button in Item record.
We will be implementing a custom button “Print Label” in the item record by using custom scripts. When the user clicks on the button, the item label will be printed irrespective of the forms. We will design a custom print for the item label and it will be printed on the “Print Label” button action.
We will use the following Design
Bulk print page
Standard Method
We can print the item labels in bulk by navigating to
Transaction->Print Checks and Forms->item labels.
In this page we can select the necessary fields according to our requirement and the we can choose the items for bulk printing. After checking the checkbox for bulk printing we can hover to the action menu click Print
Custom Method
We can bring flexibility in printing the item labels through a custom solution.
In order to print the item labels in bulk using the revised pdf format, we will be implementing a custom page that resembles the standard print item labels page. We will be creating a custom script that will create the Print Item Labels page. Selecting the items from the list and clicking the custom button in the custom page the item labels will be printed in bulk.
Print Item Label Details:
PRINT NAME/NUMBER BAR CODE, PRINT DISPLAY NAME/NUMBER,
PRINT SERIAL NUMBER BAR CODE, PRINT EXPIRATION DATE, PRINT SALES PRICE, CURRENCY, STARTING LABEL, PRICE LEVEL
On clicking the Print button by selecting the items from the page the, the item labels will be printed with the details.
Assumption
- We will follow the below mapping
1) Number: Display Name/Number
2)Description: Purchase description
3)Vendor Id: Preferred vendor id from the vendor subtab of item record
4)Bin Number: Bin number from the Bin Number subtab of item record.
5)QR code: Encrypted item name/Number
- Item name/ Number will be encoded in the QR code
- The price level will be base price
- Pdf Specifications and Dimensions
Label is 50mm x 30mm.
Left right bottom top is 5mm margin from edge of label and this black box.
Then from top down are:
Number
Description / name of item
vendor ID / Supplier ID
BIN
QR code on the right side
Field mapping are provided as below:
| Field in the packing slip PDF | NetSuite Field |
| Number | Display Name/ Number |
| Description | Purchase description |
| Vendor id | Preferred vendor id. If there is no preferred vendor then this field will be blank. |
| Bin number | Bin number corresponding to location |
Risks
- We can get data only from the current record. If any data needs to be populated from record with more than one join, then that needs to be populated to a custom field on the corresponding transaction by sourcing or scripting. This is not included in the current scope
- There may be additional modifications to the dimension or specifications of the template to ensure that the QR code image is displayed properly and at the correct size.
- If any of the fields are kept blank it will not be printed in the item label pdf
- Advanced pdf template has limitations in bringing custom fields datas . So, we cannot customize the Item Label Adv pdf and apply it for different forms.
- The vendor in the item label will be the preferred vendor.
- Bin number corresponds to the preferred bin number of the item.