NetSuite Development Notes: Sample Code to Generate a PDF File Using nlapiXMLtoPDF

Duration: 6 minutes

The following set of instructions shows how to create a PDF file that can be called with a click of a button. A button is first added to a form. Clicking the button retrieves the necessary data from the current record and creates a PDF file. The created PDF file will then be shown by using a Suitelet.

1. Create a Suitelet with the following code. This will create the PDF file using nlapiXMLToPDF in conjunction with Big Faceless Organization (BFO). Note that the internal id of the current record that is passed as a parameter will be used to load the record.

function printItemBarcode(request, response){ //retrieve the record id passed to the Suitelet var recId = request.getParameter('id'); //load the record var recPO = nlapiLoadRecord('purchaseorder', recId); //check the number of line items var lineCount = recPO.getLineItemCount('item'); //create a table to present the line items var strName = "<table width=\"400\">"; strName += "<tr>"; strName += "<td width=\"20\%\"><b>Item</b></td>"; strName += "<td width=\"15\%\"><b>Rate</b></td>"; strName += "<td width=\"30\%\" align=\"center\"><b>Barcode</b></td>"; strName += "<td width=\"15\%\"><b>Quantity</b></td>"; strName += "<td width=\"20\%\" align=\"center\"><b>Amount</b></td>"; strName += "</tr>"; //iterate through each item for (var x = 1; x <= lineCount; x++) { strName += "<tr><td>"; // note the use of nlapiEscapeXML to escape any special characters, // such as an ampersand (&) in any of the item names strName += nlapiEscapeXML(recPO.getLineItemText('item', 'item', x)); strName += "</td>"; strName += "<td>"; strName += recPO.getLineItemValue('item','rate', x); strName += "</td>"; strName += "<td>"; strName += "<barcode codetype=\"code128\" showtext=\"true\" value=\""; strName += recPO.getLineItemValue('item','rate', x); strName += "\"/>"; strName += "</td>"; strName += "<td align=\"center\">"; strName += recPO.getLineItemValue('item','quantity', x); strName += "</td>"; strName += "<td align=\"right\">"; strName += recPO.getLineItemValue('item','amount', x); strName += "</td></tr>"; } strName += "</table>"; // build up BFO-compliant XML using well-formed HTML var xml = "<?xml version=\"1.0\"?>\n<!DOCTYPE pdf PUBLIC \"-//big.faceless.org//report\" \"report-1.1.dtd\">\n"; xml += "<pdf>\n<body font-size=\"12\">\n<h3>Purchase Order Items with Barcode</h3>\n"; xml += "<p></p>"; xml += strName; xml += "</body>\n</pdf>"; // run the BFO library to convert the xml document to a PDF var file = nlapiXMLToPDF( xml ); // set content type, file name, and content-disposition (inline means display in browser) response.setContentType('PDF','PO_Item_Barcode.pdf', 'inline'); // write response to the client response.write( file.getValue() ); }

Suitelet Script Deployment:

2. Create a Client script that will call the Suitelet. In this script, the internal id of the current record is being passed to the Suitelet. Note the deployment settings of this script wherein no function is specified. This is because the function will only be called by the User Event script on Click of the custom button.

Client Script Deployment:

3. Create a User Event script that will add a custom Button on a form. This will be triggered on Before Load function. Note that the function name of the Client script is specified. The Client script is then set using "setScript".

User Event Script Deployment:
This sample shows a custom button on the Purchase Order record labeled as "Print Item Barcode".

On load of the Purchase Order record, the button "Print Item Barcode" is immediately displayed. Clicking this button will generate the PDF file which contains all the Items contained under the Items tab > Items subtab. The PDF file will display 5 columns which are Item, Rate, Barcode, Quantity and Amount.

1. View a Purchase Order
2. Click the button "Print Item Barcode"
3. A window opens containing the PDF file that was generated. It contains the data from Items on the Purchase Order record

NetSuite Development Notes

Sunday, October 21, 2018

Sample Code to Generate a PDF File Using nlapiXMLtoPDF

No comments:

Post a Comment

How to write SuiteScript script elegantly with VS CODE