Add Special Instructions to a NetSuite Order Line

This article is relevant to you if you are running your business on Oracle NetSuite and would like to add an isolated custom note on a transaction line. This article demonstrates a simple end to end architecture to customize and extend the capabilities of NetSuite.

...
Jack Ring
Share:

A Business Case

One of our clients offered a special order item for which they wanted to provide detailed measurements and instructions for sizing and artwork. A requirement was to maintain native item descriptions on the flow across sales transactions while also preserving native vendor descriptions on the purchase order. The special instructions needed to maintain formatting as entered and could be several lines in length.

We overcame this challenge by utilizing a custom transaction body field, assigning proper transaction types, optimizing positioning it in "Transaction Form Sublists", and adding conditional freemarker in Advanced PDF / HTML Template files.

Build the Custom Transaction Body Field

...

Customization > Lists, Records & Fields > Transaction Line Fields.
We use a standardized naming convention, configured Text Area as Type, assigned Sales and Purchase for Applies To.

Arrange the Transaction Form Sublist Position.

...

Customization > Forms & Transaction Forms.
Edit the Sublist Fields subtab for the default transaction forms [ Estimate, Sales Order, Invoice, Cash Sale & Purchase Order ]. Drag to a position end users can easily see.

Add Freemarker Logic to the PDF Templates

...

Customization > Forms & Advanced PDF/HTML Templates.
Shown here are a few things.

  1. We added the special instructions as an entire row. Line 388.
  2. We show the special instructions on the PDF only if the field has data. Line 387.
  3. When there are alternating row colors, we add the special instructions as the same color as if attached to the relevant transaction line. Lines 361 & 388.



Schedule a Conversation

Let's talk. • (724) 816-1000 • info@leftledger.com


Latest Stories

Here's what we've been up to recently.





Join our mailing list

From us to your inbox.



Schedule a Conversation

Let's talk. • (724) 816-1000 • info@leftledger.com