Transaction Form Fundamentals

Each transaction type (Sales Order, Invoice, Purchase Order, etc.) can have multiple custom forms. Users select forms based on their role, transaction type, or business scenario.

Form Customization Scope

Creating Custom Transaction Forms

Role-Based Form Assignment

Assign different forms to different roles to streamline their experience.

Form Assignment Methods

Control which forms are available to which users through role restrictions and preferred form settings.

Mandatory Fields Strategy

Making fields mandatory enforces data quality but can frustrate users if overdone.

Mandatory vs. Workflow Validation

Form Layout and Tabs

NetSuite transaction forms organize fields into tabs and subtabs. Customize which tabs appear and their order to create an intuitive flow.

Standard Transaction Tabs

• Primary Information: Main header fields (customer, date, status)
• Items: Line item sublist
• Shipping: Ship-to address and shipping method
• Billing: Bill-to address and payment terms
• Accounting: GL impact, posting period
• Communication: Notes, messages, attached files
• Custom: Custom fields grouped into custom tabs

Field Configuration

Each field on a transaction form has multiple configuration options that control its behavior and appearance.

Field Display Options

• Label: Change the field label displayed to users
• Help: Add field-level help text (appears on hover)
• Default Value: Pre-populate field with specified value
• Display Type: Normal, Inline Text, Hidden
• Break Before: Start new column before this field

Field Sourcing and Defaults

Fields can be sourced from related records or set with defaults:

• Sourced Fields: Auto-populated from parent record (customer defaults to sales rep)
• Static Defaults: Fixed value for all new transactions
• Dynamic Defaults: Value based on user, date, or formula (requires scripting)

Print and Email Templates

Transaction forms include settings for printing and emailing. Link custom PDF templates to forms for professional document output.

Print Settings

• Linked Form: Associate Advanced PDF template for printing
• Print Button: Show/hide print button on form
• Email Button: Show/hide email button on form
• PDF Format: Portrait or landscape orientation

Transaction Form Best Practices

Design Principles

• Less is More: Show only fields users actually need
• Logical Flow: Arrange fields in the order users think about them
• Group Related Fields: Use tabs and sections to organize
• Consistent Layout: Similar transactions should have similar layouts
• Meaningful Defaults: Pre-populate wherever possible

Common Mistakes to Avoid

• Making too many fields mandatory (slows data entry)
• Creating too many forms (maintenance burden)
• Not testing forms with actual users
• Forgetting to assign forms to roles
• Not documenting customizations

Entity Form Customization

Entity forms follow similar customization principles to transaction forms but apply to master data records like customers, vendors, and employees.

Common Entity Form Types

Creating Custom Entity Forms

Custom entity forms allow you to tailor the user experience for different roles, customer segments, or business processes.

Customer Form Design Considerations

Customer forms are among the most frequently accessed. Design them for both quick initial creation and comprehensive ongoing management.

Customer Form Subtab Organization

Vendor Form Considerations

Vendor forms must balance ease of use with compliance requirements, especially for 1099 reporting.

Vendor Form Tabs

Critical Vendor Fields

• Legal Name: Must match IRS records exactly for 1099
• Tax ID: EIN or SSN for US vendors
• 1099 Eligible: Flag for year-end reporting
• W-9 on File: Custom field to track compliance
• Payment Method: Check, ACH, wire preferences
• Banking Info: For electronic payments (secure storage)

Employee Form Security

Employee forms often contain sensitive information. Use form customization to restrict access.

Employee Form Variants

Common Employee Form Tabs

Contact Form Configuration

Contacts represent individual people associated with customers, vendors, or other entities.

Field Configuration on Entity Forms

Address Book Configuration

The Address Book sublist on entity forms manages multiple addresses per record.

Address Configuration Options

• Default Shipping: Pre-selected on transactions
• Default Billing: Pre-selected for invoices
• Residential Flag: Affects shipping carrier rates
• Address Label: User-friendly identifier ("Main Office", "Warehouse 2")
• Attention: Contact name for deliveries

Form Assignment for Entities

Industry-Specific Entity Form Patterns

Entity Form Best Practices

Sublist Types

NetSuite forms contain different types of sublists, each serving different purposes.

Line Item Configuration

The Items sublist on transactions is the most heavily used. Optimize it for fast, accurate entry.

Essential vs. Optional Columns

Recommended Column Order (Sales Order)

Column Width Optimization

Set column widths to match content. Narrow columns for codes, wider for descriptions.

Matrix Sublist Configuration

Matrix items display in a special grid format showing size/color combinations.

Custom Column Sublists

Add custom columns to sublists for business-specific data.

Common Custom Line Fields

• Commission Rate Override: Per-line commission for special deals
• Customer PO Line: Reference to customer's line item number
• Delivery Date: Requested delivery per line item
• Warehouse Notes: Special handling instructions
• Cost Center: Departmental allocation per line

Expense Sublist Configuration

The expense sublist appears on purchase orders, vendor bills, and expense reports. Configure it for accurate cost allocation.

Key Expense Sublist Fields

• Category: Expense category (maps to GL account)
• Amount: Expense amount
• Department: Cost center allocation
• Class: Business segment classification
• Location: Physical location
• Customer: For billable expense tracking
• Billable: Flag for client billing

Sublist Filtering and Sourcing

Control which items appear in sublist dropdowns to speed data entry and prevent errors.

• Item Sublist Filter: Limit items to specific types or categories on the form
• Vendor Item Sourcing: Show only items linked to the selected vendor
• Location Filter: Restrict to items available at selected location
• Custom Filters: Script-based filtering for complex rules

Related Records Sublists

Related records sublists display linked transactions and activities, providing context without leaving the record.

• Transactions subtab: Shows related sales orders, invoices, payments
• Activities subtab: Calls, tasks, events linked to the record
• Communication subtab: Emails, messages, attached files
• Custom subtabs: Saved searches displayed as record subtabs

Inline Editing Configuration

Inline editing on list views and sublists allows quick updates without opening the full record.

Industry-Specific Sublist Patterns

Performance Optimization

Large sublists with many columns or rows can slow form loading.

• Limit visible columns to reduce rendering time
• Use saved search sublists instead of loading all related records
• Paginate large sublists where supported
• Disable unused sublists on the form to prevent unnecessary data loading

Search-Driven UI Elements

Saved searches can populate multiple UI components beyond just report results.

List Portlet Searches

List portlets display saved search results as scrollable lists on dashboards.

List Portlet Best Practices

KPI Scorecard Searches

KPI portlets display single metrics or comparison values. The search design differs from list portlets.

Common KPI Searches

Trend Graph Searches

Trend graphs visualize data over time. The search must be structured to support chart rendering.

Trend Search Requirements

• Time Dimension: Include date field grouped by period (day, week, month)
• Measure Column: Numeric value to plot (amount, count, quantity)
• Optional Dimension: Category for multi-series charts (product line, region)
• Sorting: Sort by date ascending for proper chart rendering

Search Performance Optimization

Searches driving UI elements need to be highly optimized since they run frequently.

Performance Best Practices

Search Security and Sharing

Control who can access searches and what data they see.

Audience Configuration

• Public: All users can see (use cautiously)
• Role-Based: Specific roles have access
• Employee-Based: Specific employees only
• Owner Only: Private to creator

Searches as Form Subtabs

Saved searches can appear as subtabs on record forms, showing related data without custom scripting.

Adding Search Subtabs

Dynamic Dropdown Sources

Saved searches can power dropdown fields, providing filtered or calculated options.

Use Cases for Search-Driven Dropdowns

Implementation Methods

Inline Editing with Searches

Saved search results can support inline editing, allowing users to modify data directly from search results.

Inline Editing Considerations

• Field Support: Not all fields support inline editing; test each column
• Permissions: User must have edit permission on underlying records
• Validation: Field validations still apply; errors shown inline
• Performance: Each edit triggers save; batch edits via CSV may be faster for bulk changes

Industry Applications

Advanced PDF/HTML Templates Overview

NetSuite's Advanced PDF/HTML templates transform transaction data into professionally formatted documents for printing, emailing, and archiving. Understanding the underlying technologies—BFO (Big Faceless Organization) rendering engine and FreeMarker templating—is essential for effective customization.

Template Types and Navigation

Standard Template Categories

Template Structure

Advanced PDF templates follow a standard HTML structure with special BFO and FreeMarker elements.

Accessing Record Data

FreeMarker provides access to all record fields through the ${record} object.

Common Field Access Patterns

Conditional Logic

FreeMarker conditionals control what content appears based on field values.

Common Conditional Patterns

Page Layout and CSS

BFO supports a subset of CSS with special extensions for PDF features.

Essential BFO CSS

Images and Logos

Include company logos, product images, and other graphics in templates.

Image Sources

• File Cabinet: Reference uploaded images via URL
• Company Logo: ${companyinformation.logourl}
• Item Images: ${item.imageurl} in line item loop
• External URLs: Full https:// paths (not recommended)

Tables and Line Items

Proper table formatting is critical for professional-looking documents.

Table CSS Tips

Number and Date Formatting

Control how numbers, currencies, and dates display in templates.

Formatting Functions

Template Assignment

Control which templates are used for different scenarios.

Assignment Methods

• Transaction Form: Link template to specific transaction form
• Print/Email Actions: Different templates for print vs. email
• Subsidiary: Different templates per subsidiary (multi-subsidiary)
• Language: Localized templates for multi-language
• Scripted: Dynamically select template via SuiteScript

Industry-Specific Template Patterns

Testing and Debugging

Email Template Overview

NetSuite email templates automate customer and vendor communications with dynamically merged data. Unlike PDF templates that use FreeMarker, email templates use a simpler merge field syntax, making them more accessible to non-technical users while still providing powerful personalization capabilities.

Template Structure

Email templates consist of several components that work together to create personalized communications:

Merge Field Syntax

Email templates use a simple merge field syntax to insert dynamic data from records:

Creating Transaction Email Templates

Sample Email Template

<!-- Subject: Invoice ${transaction.tranid} from ${company.companyname} -->

<div style="font-family: Arial, sans-serif; max-width: 600px; margin: 0 auto;">
    <!-- Header with logo -->
    <div style="background-color: #f8f9fa; padding: 20px; text-align: center;">
        <img src="${company.logo}" alt="${company.companyname}" style="max-height: 60px;">
    </div>

    <!-- Main content -->
    <div style="padding: 30px;">
        <p>Dear ${entity.firstname},</p>

        <p>Please find attached Invoice <strong>${transaction.tranid}</strong>
           dated ${transaction.trandate}.</p>

        <!-- Invoice summary box -->
        <div style="background-color: #f0f7ff; padding: 15px; border-radius: 5px; margin: 20px 0;">
            <p style="margin: 5px 0;"><strong>Amount Due:</strong> ${transaction.total}</p>
            <p style="margin: 5px 0;"><strong>Due Date:</strong> ${transaction.duedate}</p>
            <p style="margin: 5px 0;"><strong>Terms:</strong> ${transaction.terms}</p>
        </div>

        <p>If you have any questions, please contact us at ${company.email}
           or ${company.phone}.</p>

        <p>Thank you for your business!</p>

        <p>Best regards,<br>
        ${user.firstname} ${user.lastname}<br>
        ${company.companyname}</p>
    </div>

    <!-- Footer -->
    <div style="background-color: #333; color: #fff; padding: 15px; text-align: center; font-size: 12px;">
        <p>${company.mainaddress}</p>
    </div>
</div>

Advanced Merge Features

Accessing Related Records

<!-- Primary contact on entity -->
${entity.contact.firstname}
${entity.contact.email}

<!-- Sales rep on transaction -->
${transaction.salesrep.firstname}
${transaction.salesrep.email}
${transaction.salesrep.phone}

<!-- Subsidiary information -->
${transaction.subsidiary.name}
${transaction.subsidiary.mainaddress}

<!-- Custom fields -->
${transaction.custbody_field_id}
${entity.custentity_field_id}

Conditional Content (Using SuiteScript)

Marketing Email Templates

Marketing templates are designed for campaigns and include special features for tracking and compliance:

Workflow Email Actions

Workflows can send emails using templates at any point in the process:

Scenario                          Trigger                      Template
-------------------------------------------------------------------------------
Sales order confirmation          SO saved, status Pending     Order Confirmation
Approval request                  Pending Approval state       Approval Request
Approval granted                  Approved state               Approval Notification
Past due reminder                 Scheduled, daysoverdue > 0   Past Due Reminder
Quote follow-up                   Scheduled, 3 days after      Quote Follow-up
Welcome new customer              Customer created             Welcome Email

Email Delivery Configuration

Domain Authentication

Send From Configuration

Case Management Templates

Support cases have specialized template features:

<!-- Case information -->
${case.casenumber}            <!-- Case number -->
${case.title}                 <!-- Case subject -->
${case.status}                <!-- Current status -->
${case.priority}              <!-- Priority level -->
${case.createddate}           <!-- Date opened -->

<!-- Assigned employee -->
${case.assigned.firstname}    <!-- Assigned rep name -->
${case.assigned.email}        <!-- Rep email -->

<!-- Customer self-service link -->
${case.externalcaseurl}       <!-- Link to customer portal -->

<!-- Conversation history -->
${case.messages}              <!-- Full message thread -->

Auto-Response Templates

Best Practices

Industry-Specific Patterns

Testing and Troubleshooting

Dashboard Architecture Overview

NetSuite dashboards serve as the primary workspace for users, displaying real-time information tailored to their role. Well-designed dashboards reduce clicks, surface actionable insights, and drive user adoption. Each dashboard is a combination of portlets organized into a customizable layout.

Portlet Types

Portlets are the building blocks of dashboards. Each portlet type serves a different purpose:

Published Dashboards

Published dashboards are administrator-controlled layouts that cannot be modified by users. Use them for:

• Standardized role-based views
• Compliance-required metrics visibility
• Executive dashboards with consistent KPIs
• Onboarding dashboards for new users

KPI Portlets

KPI portlets display key metrics in a scorecard format with comparison values, trends, and conditional highlighting.

Standard vs. Custom KPIs

Reminder Portlets

Reminders alert users to items requiring action. NetSuite includes built-in reminders plus custom reminder searches.

Built-in Reminders

Custom Reminders

Create custom reminders using saved searches with the "Available as Reminder" option:

Reminder                    Saved Search Criteria
-------------------------------------------------------------------------------
Quotes Expiring Soon        Estimate: Status=Open, Valid Through within 7 days
Contracts Expiring          Customer: Contract End Date within 30 days
Low Stock Items             Item: Available < Reorder Point
Invoices Over 60 Days       Invoice: Days Overdue > 60
Projects Over Budget        Project: Actual Hours > Estimated Hours
Unapplied Payments          Payment: Unapplied Amount > 0
Pending Time Approval       Time Entry: Approval Status = Pending

Shortcuts Portlet

Shortcuts provide one-click access to frequently used transactions, records, and reports. Effective shortcuts reduce navigation time significantly.

Shortcut Types

Role-Based Dashboard Strategy

Different roles have different information needs. Design dashboards that answer "What do I need to do?" and "How am I performing?"

Sample Dashboard Layouts

+-----------------------------------+-----------------------------------+
|  REMINDERS                        |  SHORTCUTS                        |
|  - Invoices to Create (12)        |  - New Invoice                    |
|  - Payments to Apply (8)          |  - New Payment                    |
|  - Deposits to Make (3)           |  - Customer Lookup                |
|  - Customers to Call (5)          |  - AR Aging Report                |
+-----------------------------------+-----------------------------------+
|  KPIs                                                                 |
|  Open AR: $1.2M | Overdue: $245K | DSO: 38 days | MTD Cash: $156K    |
+-----------------------------------+-----------------------------------+
|  OVERDUE INVOICES                 |  RECENT PAYMENTS                  |
|  [Saved search results]           |  [Saved search results]           |
|  Customer | Amount | Days         |  Customer | Amount | Date         |
+-----------------------------------+-----------------------------------+

+---------------------------------------------------------------------+
|  KPI SCORECARD                                                       |
|  Pipeline: $4.5M | MTD Rev: $890K | Win Rate: 32% | Forecast: $1.2M |
+-----------------------------------+---------------------------------+
|  PIPELINE BY STAGE                |  REVENUE TREND                  |
|  [Trend Graph]                    |  [Trend Graph]                  |
|  Prospecting > Negotiation > Close|  Jan Feb Mar Apr May Jun        |
+-----------------------------------+---------------------------------+
|  TEAM PERFORMANCE                 |  APPROVALS NEEDED               |
|  Rep     | Pipeline | MTD         |  - Sales Orders (3)             |
|  Jones   | $1.2M    | $245K       |  - Discounts > 20% (2)          |
|  Smith   | $980K    | $312K       |  - New Customer Credits (1)     |
+-----------------------------------+---------------------------------+

Dashboard Performance

Optimization Strategies

Industry-Specific Dashboard Patterns

Custom Portlets (SuiteScript)

When standard portlets don't meet requirements, custom portlets can display virtually any content:

/**
 * @NApiVersion 2.1
 * @NScriptType Portlet
 */
define(['N/search', 'N/ui/serverWidget'], function(search, serverWidget) {
    function render(params) {
        var portlet = params.portlet;
        portlet.title = 'My Custom Portlet';

        // Add form fields
        portlet.addField({
            id: 'custpage_kpi',
            type: serverWidget.FieldType.TEXT,
            label: 'Key Metric'
        }).defaultValue = calculateKPI();

        // Or add HTML content
        portlet.html = '<div>Custom HTML content</div>';
    }

    return { render: render };
});

Dashboard Deployment Checklist