Author: Manikandan TM

Drop-ship Purchase Orders.

Drop-ship Purchase Orders can only be created by manually clicking either the Drop Ship or Spec. Ord link on the Sales Order’s line item. Below is a sample code snippet to create it using SuiteScript 2.0.  var salesOrderId = ‘12345’; var entityId = nlapiLookupField(‘salesorder’, salesOrderId, ‘entity’);var vendorId = ‘777’; var params = {‘recordmode’ : ‘dynamic’,‘soid’ :… Continue reading Drop-ship Purchase Orders.

PROPOSAL FOR UPDATING THE AUTOMATIC PURCHASE ORDER CREATION FUNCTIONALITY BASED ON THE ITEM’S PREFERRED VENDORS.

Proposal summary This proposal addresses the creation of automated purchase orders from sales orders based on the preferred vendor for the corresponding items. Requirement  Change the CREATE PO to create POs based on preferred vendor instead of just ZT RMB vendor by default. So if SO has items for 3 different preferred vendors, it will… Continue reading PROPOSAL FOR UPDATING THE AUTOMATIC PURCHASE ORDER CREATION FUNCTIONALITY BASED ON THE ITEM’S PREFERRED VENDORS.

Is there a built-in in Freemarker that allows me to entirely remove HTML tags from a string?

You could use the Freemarker built-in string replace function with the “r” flag to enable regular expressions. Here’s a simple regexp that does the trick: ${page_title?replace(‘<[^>]+>’,”,’r’)} Note that if you use backslashes within the regular expression they must be escaped, as follows (contrived example that removes whitespace): ${page_title?replace(‘\s+’,”,’r’)}

Purchase order’s quantity update by email

Proposal Summary This proposal summarises the email notification of purchase order quantity value modifications. When a user or system changes the item quantity value in a purchase order item line, the system must be notified through email of the revised item data. Requirements  Send an email to acknowledge the quantity update on the purchase order’s… Continue reading Purchase order’s quantity update by email

Multiple Project For Email Automation.

Proposal summary This project proposal covers multiple requests that will help to send the notification for the customers. Based on the different conditions for sales orders and item fulfillment. We have planned to a written a user event script and map/reduce script for sending emails for customers. Requirement  For sending emails to customers Notifying Old… Continue reading Multiple Project For Email Automation.

HUBSPOT DEAL INTEGRATION

Proposal summary This proposal summarizes the functionality for integrating Hubspot deals data with Netsuite. When a deal is created/updated in the closed won stage in Hubspot. We need to create a sales order in Netsuite for the corresponding deals. Requirement  To Integrate Hubspot with Netsuite. When creating a new deal or updating an existing deal… Continue reading HUBSPOT DEAL INTEGRATION

Cash flow planning report

Proposal summary This project proposal describes the scope of creating a custom cash flow planning board report using a suite script. Requirement  Create a custom cash flow planning board report using suite script functionality. The cash flow planning board computation is shown below. LC margin = If the Mode of payment is LC site, LC… Continue reading Cash flow planning report

Assign sales rep to sales order item line.

Automating the value of the sales rep in the sales order item line. The sales rep will be identified based on the customer territory and the item’s brand value setup in the custom record. Requirements Is there any way to automate this using sales rules? The scenario will be the customer is located in a… Continue reading Assign sales rep to sales order item line.