Solution Below given a sample XML body From this, we can extract data using the below sample code var fileContent = fileObj.getContents(); //if xml data is in file //Parse XML to a variable var xmlObj = xmlMod.Parser.fromString({ text: fileContent }); //Getting values from 945 XML file //Traverse to each node var orderheader = xmlMod.XPath.select ({… Continue reading Extract data from XML body
Author: Hari Krishnan
Proposal for Adrenalin-Netsuite Integration
Proposal Summary Neutrinos would like to integrate Netsuite Employees Record with employee data in Adrenalin Requirement Neutrinos needs to integrate the Master Data Employees from Adrenalin to Netsuite. Also would like to migrate existing employee records from Adrenalin to NetSuite. Our Solution Employee Integration from Adrenalin to Netsuite Prerequisites We will provide the consumer key,… Continue reading Proposal for Adrenalin-Netsuite Integration
Proposal for Invoice Templates
Proposal Summary Neutrinos would like to have different invoice templates Requirement Neutrinos would like to have different Invoice Templates – Product Subscription, Product Implementation Fixed Bid and Time and Material (TnM). They have the following suggestions about the invoices. Product Subscription Invoice While raising this invoice, we should be able to capture the customer’s name… Continue reading Proposal for Invoice Templates
Proposal for Inventory Count and Adjustment Enhancement
Proposal Summary Flowco needs to have enhancements on Inventory Count and Inventory Adjustments. Requirement Flowco needs to have the following enhancements on Inventory Count and Inventory Adjustments. Currently, the Inventory Adjustment is not having reference to the corresponding Inventory Count. So they need to have a hyperlink on the Inventory Adjustment record back to the… Continue reading Proposal for Inventory Count and Adjustment Enhancement
Proposal for PDF Template – Commercial Invoice
Proposal Summary Magswitch would like to have a new Advanced PDF Template – Order Confirmation for MTE Sales Orders Requirement MTE is currently using the standard form as the USA. So, they want a new Advanced PDF template – Order Confirmation. Auto-Population Discount Unit Price and Net Price needs to be Calculated Layout Our Solution… Continue reading Proposal for PDF Template – Commercial Invoice
Proposal for Viton Seal Calculator
Proposal Summary Flowco would like to automatically calculate the Viton seals on the Sales order Requirement Flowco has items that require Viton Seals/washers. So, they need to automatically calculate the number of Seals required for replacement based on the item record(V1 size, V1 Qty, V2 size, V2 Qty) and need to add additional lines to… Continue reading Proposal for Viton Seal Calculator
Proposal for Packing Slip Enhancement
Proposal Summary Flowco would like to have enhancement on the existing Packing Slip. Requirement Flowco is having the following mentioned issues • The Backorder column doesn’t populate correctly on the Packing Slip until order is fulfilled. The calculation of the backorder column is customized on the PDF/HTML coding – Waterworks New Packing Slip PDF/HTML Template… Continue reading Proposal for Packing Slip Enhancement
Proposal for Picking Ticket Enhancement
Proposal Summary Flowco would like to have enhancement on the Picking Ticket PDF Requirement Flowco needs to calculate the picking quantities correctly in the Picking Ticket in order to avoid confusion for Warehouse employees. For example, A Customer ordered x5 qty of SSBN25 and was dispatched x3 qty and x2 qty was placed on backorder. … Continue reading Proposal for Picking Ticket Enhancement
Online Case form Template using Bootstrap and validation using DOM
Solution <!DOCTYPE html><Head><meta charset=”utf-8″><Title>Revo Online Case Form</Title><meta name=”viewport” content=”width=device-width, initial-scale=1.0″> <link href=”https://netdna.bootstrapcdn.com/twitter-bootstrap/2.3.2/css/bootstrap-combined.min.css” rel=”stylesheet”><link rel=”stylesheet” href=”https://fonts.googleapis.com/css?family=Work Sans” type=”text/css”><style>input[type=”text”]{width:67%;font-size:14px;display:block;}.control-label{font-size:13px;display:block;} select { display block;font-size:14px; width:70%;}.btn{font-size:14px;padding:8px;margin-bottom:100px;}textarea{width:67%;height:32px;display:block;font-size:22px;}option { font-size: 14px; font-weight: normal; line-height: 0px;}body{letter-spacing:.07em;font-family:Work Sans;}</style><script type=”text/javascript”>if(performance.getEntriesByType(“navigation”)[0].type == “back_forward”){ location.reload();}function getData(){var title=document.getElementById(‘title’).value;var fname=document.getElementById(‘firstname’).value;var lname=document.getElementById(‘lastname’).value;var email=document.getElementById(’email’).value;var adrs=document.getElementById(‘address1’).value;var state=document.getElementById(‘state’).value;var city=document.getElementById(‘city’).value;var item=document.getElementById(‘custevent_jj_prdt_num_brl_57’).value;var ctgry=document.getElementById(‘category’).value;var msg=document.getElementById(‘incomingmessage’).value;var year=document.getElementById(‘custevent_jj_year_brl_43’).value;var zip=document.getElementById(‘zipcode’).value;var d = new Date(); var n = d.getFullYear();var… Continue reading Online Case form Template using Bootstrap and validation using DOM
Generating passwordGUID and hostkey for connecting external servers via suitelet
Solution var HTTPSMODULE, SFTPMODULE, SERVERWIDGETMODULE;var HOST_KEY_TOOL_URL = ‘https://ursuscode.com/tools/sshkeyscan.php?url=’;/** *@NApiVersion 2.x *@NScriptType Suitelet *@NModuleScope Public */define([“N/https”, “N/sftp”, “N/ui/serverWidget”], runSuitelet);//********************** MAIN FUNCTION **********************function runSuitelet(https, sftp, serverwidget){ HTTPSMODULE= https; SERVERWIDGETMODULE= serverwidget; SFTPMODULE= sftp; var returnObj = {}; returnObj.onRequest = execute; return returnObj;}function execute(context){ var method = context.request.method; var form = getFormTemplate(method); if (method == ‘GET’) { form =… Continue reading Generating passwordGUID and hostkey for connecting external servers via suitelet