Chapter 8.1

Advanced Inventory

Multi-location inventory, bin management, lot/serial tracking, and advanced costing methods.

Multi-Location Inventory

Multi-location inventory tracks stock quantities and values across multiple warehouses, stores, and distribution centers.

Setup â€ē Company â€ē Enable Features â€ē Items & Inventory
Feature Description Use Case
Multi-Location Inventory Track quantities by location Multiple warehouses/stores
Bin Management Track within-location positions Warehouse shelving/racks
Lot Tracking Track items by lot/batch number Food, pharma, chemicals
Serial Number Tracking Track individual units Electronics, high-value items

Bin Management

Bins represent specific storage locations within a warehouse (shelves, racks, zones).

Bin Type Purpose Example
Receiving Initial receipt location Dock staging area
Storage Primary inventory storage Rack locations, shelving
Picking Order fulfillment source Forward pick locations
Shipping Outbound staging Dock staging for shipment
Quarantine Inspection/hold area QC inspection zone
// Common bin naming pattern: ZONE-AISLE-RACK-SHELF-POSITION A-01-02-03-A // Zone A, Aisle 1, Rack 2, Shelf 3, Position A BULK-R05-B12-L3 // Bulk area, Row 5, Bay 12, Level 3 RCV-DOCK-01 // Receiving Dock 1 QC-HOLD-01 // QC Hold Area 1

Lot/Batch Tracking

Lot tracking enables traceability for groups of items manufactured or received together.

👔 Professional Services
Professional Services Consideration
Use lot tracking for component traceability and quality control. Mandatory for regulated industries like food, pharma, and medical devices.
ℹī¸ FEFO vs FIFO
FEFO (First Expired, First Out) picks items closest to expiration first. FIFO (First In, First Out) picks oldest receipt date first. Use FEFO for perishables with expiration dates.

Serial Number Tracking

Serial numbers uniquely identify individual units for warranty tracking, service history, and asset management.

Option When to Use Example
On Sale Only Track after sale for warranty Electronics, appliances
On Receipt Track from receipt through sale High-value items, medical devices
When Order is Committed Assign at pick/pack stage Configured goods

Advanced Costing Methods

Method How It Works Best For
Average Weighted average of all receipts Commodities, high-volume items
FIFO First costs in, first costs out Perishables, rising cost environments
LIFO Last costs in, first costs out Tax optimization (US only)
Standard Predetermined cost with variances Manufacturing, cost control
Specific Actual cost per serial/lot High-value items, vehicles
⚠ī¸ Costing Method Lock
Once an item has inventory transactions, the costing method cannot be changed. Carefully evaluate costing requirements before initial transactions.

Inventory Adjustments

Transaction Purpose GL Impact
Inventory Adjustment Increase/decrease quantity Inventory Asset ↔ Adjustment Account
Inventory Transfer Move between locations No P&L impact (asset relocation)
Bin Transfer Move within location No financial impact
Inventory Count Physical count entry Generates adjustments for variances

Advanced Inventory Checklist

Chapter 8.2

Warehouse Management (WMS)

Mobile warehouse operations, wave management, pick strategies, and real-time inventory control.

WMS Module Overview

NetSuite Warehouse Management System extends core inventory with mobile device support, directed picking/putaway, and real-time inventory updates.

Capability Standard Inventory WMS
Mobile Device Support Limited (browser only) Full mobile app with scanning
Wave Picking Not available Multi-order wave management
Directed Putaway Manual bin selection System-suggested locations
Pick Strategies Basic FIFO Configurable strategies per zone
Real-time Updates Batch processing Immediate transaction posting
Cartonization Not available Automatic packing optimization
ℹī¸ Licensing Note
WMS requires a separate license on top of NetSuite base. Available in two tiers: WMS Lite (basic mobile) and WMS Full (complete functionality including waves, strategies, and cartonization).

WMS Core Processes

Receive
→
Putaway
→
Pick
→
Pack
→
Ship

WMS Setup & Configuration

Enable WMS Feature

Setup â€ē Company â€ē Enable Features â€ē Items & Inventory â€ē Warehouse Management

WMS Feature Enablement

Location Configuration for WMS

Setting Purpose Consideration
Use Bins Enable bin-level tracking Required for WMS
Make Inventory Available Allow inventory transactions Enable for stocking locations
Use WMS Enable WMS mobile operations Per-location setting
Default Receiving Bin Initial receipt location Use staging area (not storage)
Default Shipping Bin Items staged for shipment Near shipping dock

SuiteApp Installation & Prerequisites

NetSuite WMS requires installing two SuiteApps in a specific order. The SCM Mobile bundle provides the mobile device application, while Oracle NetSuite WMS contains the business logic for warehouse processes.

Installation Sequence

Step 1: Enable Advanced Inventory (Setup → Company → Enable Features → Items & Inventory)
→
Step 2: Install SCM Mobile (Bundle ID: 326943, ~3-5 min)
→
Step 3: Install Oracle WMS (Bundle ID: 328497, ~20-30 min)
→
Step 4: Activate WMS Rule (WMS Configuration → System Rules → Set Rule Value = Y)
⚠ī¸ Critical: SuiteApp Deactivation
If the Oracle NetSuite WMS SuiteApp is inactivated or uninstalled, you MUST first inactivate the "Enable Warehouse Management" system rule. Failure to do so will cause issues with order processing in other SCM mobile apps.

WMS Roles & Permissions

Role Purpose Key Permissions
Administrator Initial setup and configuration Enable features, install SuiteApps, manage all records
Mobile – Administrator Mobile process customization Configure mobile processes, printing without full admin
WMS Warehouse Manager Daily operations management Activate system rules, create item aliases, cycle counts, all mobile access
WMS Picker Floor-level operations Mobile picking, putaway, counts (limited UI access)

WMS System Rules Configuration

System rules add capabilities or enable alternate behavior for warehouse processing tasks. Rules can apply to all warehouse locations or specific locations, and some allow you to specify the mobile process for activation.

Key System Rules – Inbound Processing

Rule Value Effect
Enable Receive All option Y/N Display "Receive All" button for lot/serial items on PO Receiving
Autogenerate Lot Numbers? Y/N Auto-generate lot numbers during PO Receiving (requires Lot Auto Numbering SuiteApp)
Autogenerate Serial Numbers? Y/N Auto-generate serial numbers during receiving and work order builds
Stage received items before putting away? Y/N Suggest staging bins first (Y) or storage bins directly (N)
Manually post item receipts? Y/N Single batch receipt (Y) vs individual receipt per item (N)
Enable Tally Scan? Y/N Scan item barcode to increment quantity by 1
Enable Weighing Scale Support Y/N Capture weight from PrintNode-integrated scales during receiving

Key System Rules – Outbound Processing

Rule Value Effect
Manually pack orders? Y/N Y = Manual pack with carton details; N = Auto-pack after picking
Use cartons for single-order picking? Y/N Enable carton entry during single order picks
Use cartons for multi-order picking? Y/N Enable carton entry during multi-order batch picks
Enable Zone Picking for single orders Y/N Pick from one or more zones with merge capability
Enable Zone Picking for multiple orders Y/N Zone picking with optional stage-by-order
Allow picking of expired items? Y/N Include expired lots in pick suggestions
Automatically mark partial picks as Done Y/N Auto-complete pick tasks after partial submission
Enable bulk picking for large pick tasks Y + Line Limit Bulk pick mode for tasks exceeding line threshold (default 50)

Key System Rules – Inventory & Counting

Rule Value Effect
Start and complete counts on app Y/N Allow starting/completing cycle counts via mobile
Change lot entry sequence for counts? Y/N Enter quantities per lot without entering total first
Entry of additional details Y/N Display adjustment reason fields in Create Inventory process
Enable bin reporting and blocking Y/N Enable bin blocking during order picking
Choose bins for reversed pick task items? Y/N Select destination bin when reversing picks

Key System Rules – Barcode & Scanning

Rule Value Effect
Enable Advanced Barcode Scanning? Y + Type Support GS1, HIBC, or Composite barcode formats
Scan bar codes with bulk serial numbers? Y + Delimiter Scan barcodes containing up to 300 serial numbers
Add Date Filtering Y + Months Filter transactions by creation date on Data Table pages
💡 System Rule Activation
Use the WMS Warehouse Manager role to activate rules. Navigate to WMS Configuration → Configure Warehouse → System Rules. Set Rule Value = Y and optionally specify Location for location-specific rules. Some rules require additional configuration in the "Additional Settings" fields.

Zone & Bin Management

Zone Strategy

Zones group bins for pick strategy assignment, reporting, and operational control. Design zones based on physical layout and item characteristics.

A typical warehouse zone layout flows from Receiving Zone (Staging, QC Check) to Bulk Storage Zone (high-volume, full pallets) to Forward Pick Zone (case/each picking) to Shipping Zone (Staging, Packing). Special Zones (Cold Chain, Haz Mat, Returns) branch off the pick area as needed.

Zone Types & Configuration

Zone Type Purpose Pick Strategy
Receiving Inbound staging, QC N/A (putaway only)
Bulk Storage Reserve stock, full pallets FIFO, replenish forward pick
Forward Pick Active pick face, cases/eaches Location sequence, min travel
Shipping Outbound staging, packing N/A (pack/ship only)
Quarantine Hold, damaged, returns Manual release required

Bin Naming Convention

Consistent bin naming enables efficient picking and systematic putaway. Include zone, aisle, rack, level, and position.

Format: [Zone]-[Aisle][Rack][Level][Position]

Examples:
  BULK-A01-B-03    = Bulk zone, Aisle A, Rack 01, Level B, Position 03
  PICK-C05-A-01    = Pick zone, Aisle C, Rack 05, Level A, Position 01
  RECV-STAGE-01    = Receiving zone, Staging area, Position 01
  SHIP-DOCK-02     = Shipping zone, Dock 02

Level Convention:
  A = Floor/Ground level
  B = Second level (easy reach)
  C = Third level (forklift required)
  D = Top level (bulk reserve)

Pick Strategies

Available Pick Strategies

Strategy How It Works Best For
FIFO Pick oldest inventory first (by receipt date) Perishables, lot-controlled items
FEFO Pick earliest expiration first Food, pharmaceuticals
LIFO Pick newest inventory first Non-perishable, cost optimization
Bin Sequence Pick in bin number order Minimize travel distance
Bin Priority Pick from priority bins first Forward pick depletion
Manual Picker selects bin Flexibility, unique situations

Strategy Assignment Hierarchy

Pick strategies resolve in order from most specific to most general:

  1. Item-Location Override — Most specific: strategy set for a particular item at a particular location
  2. Item-Level Strategy — Strategy assigned on the item record
  3. Zone Default Strategy — Default strategy configured on the zone
  4. Location Default Strategy — Most general: fallback strategy on the location record
💡 Pick Path Optimization
Configure bin sequence numbers to create efficient pick paths. Use serpentine patterns: ascending on odd aisles, descending on even aisles to minimize backtracking.

Defining Pick Strategies

Pick strategies define zones where warehouse operators can pick specific items or orders. Create via Lists → Supply Chain → Pick Strategy → New.

Field Purpose Options
Transaction Type Type of order this strategy applies to Sales Order, Transfer Order, Work Order, Replenishment, Vendor Return
Sequence Number Priority ranking (lower = higher priority) Numeric value
Location Warehouse location Select one location
Item Criteria Filter by items and pick decomposition units Item Classification, Family, Group
Order Criteria Filter by order characteristics Rush Order, Order Type, etc.
Pick Zones Zone prioritization (required) Add zones in descending priority order

Defining Putaway Strategies

Putaway strategies define where items should be placed after receipt. NetSuite WMS uses a 7-step sorting process to suggest storage locations:

  1. Retrieve Item Values — Item Group, Family, ABC Velocity, WMS Mix Lot/Item, Preferred Bin
  2. Find Matching Strategies — Match item criteria to strategy criteria
  3. Extract Zone & Sequence — From each matching strategy
  4. Sort Zones — By sequence number (ascending)
  5. Apply Bin Restrictions — Mixed Items? Mixed Lots?
  6. Sort Bins — By putaway sequence (ascending)
  7. Generate Suggestions — Preferred → With Qty → Empty
Item Setting Effect on Putaway Suggestions
Mixed Items Allowed = Y Include all associated bin locations (after empty bins)
Mixed Items Allowed = N Only bins with same item or empty bins
Mixed Lots Allowed = Y Include all associated bin locations
Mixed Lots Allowed = N Only bins with same lot or empty bins
WMS Preferred Bin Always appears first in suggestion list
ℹī¸ Default Putaway Strategy
Always create at least one putaway strategy with the highest sequence number and default zone. This serves as a fallback when items don't match any specific strategy criteria.

Wave Management

Waves group multiple orders for efficient batch picking. Wave releases create coordinated pick tasks across the warehouse.

Wave Configuration Options

Setting Purpose Typical Value
Maximum Orders per Wave Limit wave size 50-100 orders
Maximum Lines per Wave Manage complexity 500-1000 lines
Auto-Release Scheduled wave creation Based on cutoff times
Sort Sequence Order of pick task creation Zone → Aisle → Bin

Pick Types by Wave

Pick Type Description When to Use
Discrete One order per trip Large orders, high-value items
Batch Multiple orders, one item at a time High-velocity SKUs
Cluster Multiple orders on cart simultaneously Small orders, e-commerce
Zone Pickers stay in assigned zone Large warehouse, specialized zones

Mobile Device Operations

WMS Mobile App Functions

Function Process Scan Points
Receiving PO receipt with putaway PO/ASN → Item → Qty → Bin
Putaway Move from staging to storage Source Bin → Item → Dest Bin
Picking Fulfill pick tasks Task → Bin → Item → Qty
Packing Cartonize and label Order → Items → Carton
Shipping Carrier manifest Carton → Manifest → Trailer
Cycle Count Bin-level inventory count Bin → Item → Count
Bin Transfer Move inventory between bins Source → Item → Qty → Dest

Mobile Device Setup

⚠ī¸ Barcode Requirements
WMS requires scannable barcodes on items, bins, and (if used) lots/serials. Plan barcode labeling strategy before go-live. GS1-128 format recommended for compliance.

Inbound Operations

Receiving Workflow

1. Scan PO/ASN
→
2. Scan/Enter Item
→
3. Enter Quantity
→
4. Capture Lot/Serial
→
5. Scan Receiving Bin
→
6. Complete Receipt

Directed Putaway Logic

Putaway Strategy Logic Use Case
Fixed Location Item always goes to same bin Fast movers, dedicated pick face
Random/Floating First available bin in zone Bulk storage, high SKU count
Consolidation Put with existing inventory FIFO compliance, space efficiency
Closest Nearest available bin Minimize travel time

Outbound Operations

Packing & Cartonization

Feature Description Configuration
Carton Types Define box sizes available Dimensions, weight limits, cost
Auto-Cartonize System suggests optimal box Based on item dims/weight
Pack Verification Scan items into carton Prevents mis-ships
Multi-Carton Orders Large orders across boxes Linked to single shipment
💡 Shipping Integration
WMS integrates with carrier systems (UPS, FedEx, etc.) via SuiteBilling or third-party connectors. Configure rate shopping to automatically select optimal carrier/service.

Replenishment

Maintain optimal pick location inventory through automated replenishment from bulk storage.

Replenishment Triggers

Trigger Type When Fires Configuration
Min/Max Qty falls below minimum Set min/max per item-location
Wave-Based Demand exceeds pick location qty Part of wave release process
Scheduled Time-based batch replenishment Nightly or shift-based
Manual Supervisor creates task Ad-hoc needs

Cycle Counting & Inventory Counts

WMS provides comprehensive cycle counting capabilities through cycle count plans, which serve as templates for generating inventory counts with advanced filtering options.

Cycle Count Plan Configuration

Filter Category Options Purpose
Item Filters Item Type, Classification, Family, Group, Individual Item Target specific inventory categories
Item Frequency Use Item Frequency checkbox + date range Count based on next count date on item record
Vendor Filter Vendor name Count items from specific vendor POs/inbound shipments
Bin Filters Zones, Aisle, Individual Bins Target specific warehouse areas
Zero Quantity Count Bin Rows With Zero Quantity checkbox Include zero-qty items in count
Sort Order Sort Rows by Bin checkbox Sort by bin number (vs item name) for area-based counting
💡 Mobile Count Capability
Activate the "Start and complete counts on app" system rule to allow warehouse staff to start and complete cycle counts entirely from the mobile device without supervisor intervention in NetSuite UI.

Inventory Costing Methods

NetSuite supports multiple inventory costing methods that affect how cost of goods sold (COGS) is calculated when inventory is shipped or consumed.

Available Costing Methods

Method How It Works Best For
Average (Default) Calculates weighted average cost across all receipts General use, simplicity, stable pricing
FIFO First-In, First-Out: oldest inventory costed first Perishables, lot-controlled, rising costs
LIFO Last-In, First-Out: newest inventory costed first Tax optimization (not available in AU)
Standard Fixed cost with variance tracking (PPV) Manufacturing, budgeting, cost control
Specific Exact cost of serial/lot number High-value items, serialized inventory
Group Average Average cost across multiple locations in a group Multi-location, intercompany transfers

Costing Method Selection

Set Default Costing Method:
  Path: Setup → Accounting → Preferences → Accounting Preferences
        → Items/Transactions subtab → Default Inventory Costing Method

Per-Item Override:
  Set on item record → Inventory subtab → Costing Method field
  WARNING: CANNOT be changed after item is saved with transactions
⚠ī¸ Costing Method Lock
You cannot change the costing method on an item record after it is saved. To change methods, you must: (1) adjust inventory to zero, (2) inactivate the item, (3) recreate with correct costing method, (4) enter opening balance. Plan costing method carefully before go-live.

Standard Costing & Purchase Price Variance

Scenario Standard Cost Actual Cost PPV
Receipt 1 $10.00 $9.50 -$0.50 (favorable)
Receipt 2 $10.00 $11.25 +$1.25 (unfavorable)
Sale $10.00 N/A COGS = $10.00
ℹī¸ Cost Timing with Advanced Receiving
With Advanced Receiving enabled, inventory cost is determined at item receipt (not vendor bill). If the vendor bill amount differs from the receipt, the variance posts to the Accrued Purchases account rather than adjusting item cost.

Ship Central Integration

NetSuite Ship Central provides packing and shipping capabilities using kiosk devices. When used with WMS, it enables a complete pick-pack-ship workflow.

WMS + Ship Central Configuration

Setting Consideration
Setup Sequence Complete WMS setup BEFORE Ship Central setup
Packing Capability Do NOT use packing in both WMS and Ship Central simultaneously
Wave Integration Wave functionality enables order search when packing through Ship Central
Pick Cartons Rule If activated in WMS, enables order search for Ship Central packing
Mobile Printing Same PrintNode integration used for both apps
Login URL Same SCM Mobile URL provides access to both WMS and Ship Central
⚠ī¸ Packing Exclusivity
WMS and Ship Central process fulfillment and record updates differently. Using packing capabilities in both apps simultaneously will cause data inconsistencies. Choose one app for packing operations.

Industry-Specific WMS Patterns

E-Commerce / Retail

  • High-volume picking: Cluster picking with multi-order carts
  • Returns processing: Dedicated returns zone with grading workflow
  • Same-day shipping: Priority waves with cutoff times
  • Kitting: Pre-assemble promotional bundles

Food & Beverage

  • Temperature zones: Separate cold chain inventory
  • FEFO enforcement: Mandatory expiration-based picking
  • Lot traceability: Full chain of custody for recalls
  • Allergen separation: Zone segregation for cross-contamination prevention

Manufacturing

  • Raw material staging: Kit to production orders
  • WIP tracking: Move between production stages
  • Finished goods putaway: From production to shipping
  • Quality hold: Quarantine pending QC release

Healthcare / Pharma

  • Serialization: Unit-level tracking (DSCSA compliance)
  • Controlled substances: Restricted access zones
  • Expiration management: Strict FEFO, short-date alerts
  • Audit trail: Full transaction history
👔 Professional Services
Professional Services Consideration
Wave picking significantly improves warehouse throughput for high-volume distributors. Configure waves by carrier, zone, or ship date.

WMS Implementation Checklist

Chapter 8.3

Manufacturing

Bill of materials, work orders, routing, MRP, and production management in NetSuite.

Manufacturing Module Overview

NetSuite Manufacturing supports make-to-stock, make-to-order, and configure-to-order production scenarios integrated with inventory, purchasing, and financials.

ℹī¸ Base vs Advanced Manufacturing

Included in Base NetSuite: Assembly Items with BOM, basic Work Orders, Assembly Builds

Requires Advanced Manufacturing License: Routing and Operations, Work Centers, MRP, Shop Floor Control, Operation-level cost tracking

Enabling Light Manufacturing

Setup â€ē Company â€ē Enable Features â€ē Items & Inventory
Feature What It Enables
Assemblies Assembly Items with Bill of Materials (member items)
Work Orders Work Order transactions to build assemblies

Manufacturing Modes

Mode Description Use Case
Make to Stock (MTS) Build to inventory based on forecasts Standard products, steady demand
Make to Order (MTO) Build against specific customer orders Custom products, high-value items
Assemble to Order (ATO) Combine standard components per order Configurable products
Engineer to Order (ETO) Design and build per customer specs One-off projects, prototypes

Bill of Materials (BOM)

A BOM defines the component structure of an assembly item - what goes into building it.

Component Type Behavior Example
Inventory Component Consumed from stock Raw materials, purchased parts
Assembly Component Sub-assembly (explodes or builds) PCB assembly, sub-module
Phantom Assembly Auto-explodes (no WIP tracking) Logical groupings, kits
Service Component Cost allocation only Labor, machine time
⚠ī¸ BOM Lock Behavior
Once a work order is created, it snapshots the BOM. Changes to the master BOM do not affect existing work orders.

Work Order Lifecycle

Planned
→
Released
→
In Process
→
Built
→
Closed

Work Order Transactions

Transaction Inventory Impact GL Impact
Work Order Issue Components → WIP Dr WIP, Cr Inventory
Work Order Build WIP → Finished Goods Dr FG Inventory, Cr WIP
Work Order Close Clears remaining WIP Variance to COGS/Overhead

Advanced Bill of Materials (Advanced BOM)

Advanced BOM replaces embedded BOMs in assembly items. After enabling, existing BOMs automatically migrate to the new structure. Advanced BOM enables reusable BOMs across assemblies and location-specific configurations.

Enabling Advanced BOM

Setup â€ē Company â€ē Enable Features â€ē Items & Inventory â€ē Advanced Bill of Materials
⚠ī¸ Migration Impact
After enabling, the Assembly/Bill of Materials record is replaced. Existing BOMs convert to read-only "legacy BOM" records automatically.

Advanced BOM Capabilities

Feature Description Use Case
BOM Reusability Single BOM shared across multiple assemblies Common sub-assemblies (e.g., wheel assembly for different bike sizes)
Multiple BOMs per Assembly Different BOMs for same assembly item Engineering BOM, Production BOM, Subcontracting BOM
Location-Specific Default Different default BOM per production location US facility uses BOM-US, Canada uses BOM-CA
Component Yield Define yield percentage at component level Account for material loss during production
BOM Revisions Multiple revisions with effective dates Track BOM evolution, engineering changes

Component Yield Configuration

Component yield accounts for material loss during manufacturing. Define yield at the component level on the BOM revision record.

Example: Component yield at 95% (5% scrap expected)

Standard BOM Qty:    10 units
Required Qty:        10 / 0.95 = 10.53 units (rounds up)
System Orders:       11 units to ensure 10 available

Set on: BOM Revision > Component line > Yield field

BOM Revision Effective Dates

Scenario Effective Start Effective End Behavior
Rev A (Current) Jan 1 Jan 31 Active through January
Rev B (New) Feb 1 (blank) Takes over February onward
⚠ī¸ No Overlapping Revisions
You cannot create overlapping revisions for a BOM. Before creating a new revision with a start date, you must first set the effective end date on the prior revision. Example: To create Rev B starting Feb 1, first update Rev A's end date to Jan 31.

Assembly Item Configuration

Assembly items define finished or semi-finished goods that are manufactured from component items. Proper configuration is critical for accurate costing and production tracking.

Assembly Item Types

Type Tracking Compatible Components
Inventory Assembly Quantity only Inventory, Non-Inventory, Other Charge, Service
Serialized Assembly Serial numbers All above + Serialized Inventory, Lot Numbered
Lot Numbered Assembly Lot numbers All above + Serialized Inventory, Lot Numbered
ℹī¸ Component Restriction
Serialized and lot numbered items can ONLY be members of assemblies if the assembly itself is serialized or lot numbered. Regular (non-tracked) assemblies cannot contain lot or serial components.

Assembly Costing After Build

After an assembly is built, it is treated like an inventory item for costing purposes:

Assembly Cost Calculation:
Component A:  10 units x $5.00  = $50.00
Component B:   5 units x $8.00  = $40.00
Component C:   2 units x $15.00 = $30.00
--------------------------------------
Assembly Cost: $120.00

This becomes the "purchase price" for FIFO/Average calculations

Assembly Item Record Key Fields

Field Location Purpose
Costing Method Inventory subtab Average, Standard, FIFO, Lot, Specific
Build Time Manufacturing subtab Default time to build one unit (for scheduling)
WIP Cost Template Manufacturing subtab GL accounts for WIP transactions
Manufacturing Routing Manufacturing subtab Default routing for production
Phantom Manufacturing subtab If checked, explodes to components (no WIP)
Income Account Accounting subtab Leave blank if NOT sold directly (components only)
💡 Non-Saleable Assemblies
To make an assembly available for production but NOT for direct sale, don't assign an income account. Without an income account, the item won't appear in sales transaction item lists but will be available for work orders. It sells only as part of a higher-level finished goods assembly.

Manufacturing Work In Process (WIP)

WIP tracking separates production into three distinct phases, enabling granular control over inventory movement and GL posting during long manufacturing cycles.

Enabling WIP

Setup â€ē Company â€ē Enable Features â€ē Items & Inventory â€ē Manufacturing Work In Process
ℹī¸ WIP Prerequisites

Feature: Work Orders must be enabled first.

Per Work Order: Check the WIP checkbox on each work order record.

Item Setup: Assembly item must be configured as WIP assembly.

WIP Three-Transaction Process

Transaction Purpose When to Use
Work Order Issue Move raw materials to WIP (material consumption) When components are pulled from stock to production floor
Work Order Completion Record assemblies built and stocked When finished goods are completed
Work Order Close Reconcile variances, clear WIP When production is finalized

WIP General Ledger Impact

WO Issue
Dr: WIP Asset
Cr: Inventory
→
WO Completion
Dr: FG Inventory
Cr: WIP Asset
→
WO Close
Clear WIP
Post Variances
🚨 Critical: WIP Line Location
On ALL WIP transactions (Issue, Completion, Close), you must identify a WIP location for line items. The WIP line location MUST match across all three transactions for the same work order. Mismatched locations will cause GL reconciliation issues.

Backflush vs. Manual Issue

Method How It Works When to Use
Backflush Components auto-consumed at completion based on BOM ratios High-volume, low-variance production
Manual Issue Explicit Work Order Issue transaction for each material pull High-value components, variable consumption
Hybrid Backflush some components, manually issue others Mix of high/low value materials

Manufacturing Routing

Routings define the sequence of operations (steps) required to manufacture an assembly. Each operation links to a work center with associated labor and machine costs.

Routing Structure

Example Routing: LAPTOP-PRO-15

Op#  Operation           Work Center   Setup    Run Time
10   PCB Assembly        SMT-LINE-01   30 min   5 min/unit
20   Burn-In Test        TEST-STATION  0 min    60 min/batch
30   Final Assembly      ASSY-LINE-02  15 min   15 min/unit
40   Quality Inspection  QC-STATION    0 min    10 min/unit
50   Packaging           PACK-AREA     5 min    5 min/unit

Work Center Configuration

Setting Purpose Example
Labor Rate Cost per hour of labor $25/hour
Machine Rate Cost per hour of machine time $50/hour
Overhead Rate Applied overhead per hour $15/hour
Capacity Available hours per day 8 hours, 2 shifts
Efficiency Actual vs planned ratio 85%
ℹī¸ Routing vs BOM
BOM defines WHAT components are needed. Routing defines HOW the product is made. For simple assemblies, routing may be optional. For complex products, routing enables accurate labor costing and capacity planning.

Enabling Manufacturing Routing

Setup â€ē Company â€ē Enable Features â€ē Items & Inventory â€ē Manufacturing Routing and Work Center

Prerequisites: Work Orders feature enabled, Manufacturing Work In Process recommended, Standard or Average costing on assembly items. Routing can only be used with WIP-enabled work orders.

Creating Work Centers

Work centers are employee groups that perform specific manufacturing steps. Create as Static Employee Groups with Manufacturing Work Center settings.

Lists â€ē Relationships â€ē Groups â€ē New 
Step 1: Create Static Employee Group
  - Kind of Group: Static
  - Kind of Members: Employee
  - Name: "Assembly Line 1" or "Quality Control Team"

Step 2: Enable as Work Center
  - Check: Manufacturing Work Center
  - Assign Location(s) where this work center operates
  - For OneWorld: Can assign multiple locations within subsidiary

Manufacturing Cost Template

Cost templates define standard rates for calculating production costs. Assign templates to routing operations.

Cost Category Description Typical Use
Labor Setup Cost of time for labor to set up a run Machine changeover, tooling prep
Labor Run Cost of time for labor during production Operator time per unit
Machine Setup Machine cost for setup time Equipment depreciation during prep
Machine Run Machine cost during production Equipment cost per hour
Overhead Indirect costs applied to production Facility, utilities, supervision

Operation Tasks

When you save a WIP work order with a routing, NetSuite automatically creates operation task records for each routing step. These appear on the work order's Operations subtab.

Task Field Purpose
Sequence Number Order of operations (10, 20, 30...)
Work Center Assigned team/machine group
Setup Time Minutes to prepare for this operation
Run Rate Minutes per unit to complete operation
Planned Start/End Scheduled times (backward scheduled from due date)
Actual Time Recorded when completing operation

Advanced Manufacturing SuiteApp

The Advanced Manufacturing SuiteApp extends core routing capabilities into the Advanced Manufacturing Work Bench, providing enhanced production planning, scheduling, and shop floor management.

Advanced Manufacturing Capabilities

Feature Description
Work Bench Central hub for production management and work order control
Work Instructions Define detailed instructions for each operation
Material Usage Association Link specific materials to specific operations
Resource Supply vs Demand Compare capacity against scheduled work
Planned Start/End Times Detailed scheduling at operation level
Downtime & Loss Tracking Account for production downtime and material loss
Labor Codes Categorize labor activities for reporting
Shop Floor Travelers Generate printed work instructions for production floor

Shop Floor Travelers

A traveler is a system-generated document providing shop floor personnel with manufacturing specifications: process steps, materials, quantities, work instructions, and barcodes for mobile devices.

Traveler Contents:
WORK ORDER TRAVELER                           WO-12345
Assembly: LAPTOP-PRO-15            Qty: 50     Due: 2025-01-15

Op 10: PCB Assembly
  Work Center: SMT-LINE-01
  Materials: PCB-MAIN (50), CPU-CHIP (50), RAM-8GB (100)
  Instructions: Follow SOP-PCB-001

Op 20: Burn-In Test
  Work Center: TEST-STATION
  Instructions: 48-hour burn-in per QA-BURN-001

...continues for all operations...
ℹī¸ SuiteApp Requirement
Advanced Manufacturing requires the Advanced Manufacturing SuiteApp installation. Contact NetSuite Professional Services for implementation support. The SuiteApp is available for accounts with Manufacturing features.

Manufacturing Mobile SuiteApp

Manufacturing Mobile enables production operators to use mobile scanners to report shop floor data. No Advanced Manufacturing or WMS license is required -- included with any NetSuite Manufacturing feature purchase.

Manufacturing Mobile Features

Feature Purpose
Shifts Define manufacturing work shifts for scheduling
Badge IDs Operator identification for labor tracking
Downtime Reason Codes Categorize production downtime (machine, material, etc.)
Scrap Reason Codes Classify defective material reasons
Component Consumption Track raw material usage via scanner
Finished Good Production Record completed units

Shop Floor Process Flow

Manufacturing Mobile 4-Step Process:

1. Material Staging (future)
   Stage materials at work center

2. Component Consumption
   Scan badge > Scan work order > Scan components > Confirm
   Records: Work Order Issue transaction

3. Finished Good Production
   Scan badge > Scan work order > Enter qty built > Confirm
   Records: Work Order Completion transaction

4. Inventory & Financial Updates
   System posts GL entries and updates inventory

Key Benefit: Each step is independent -- data collection separated
from financial/inventory posting for flexibility.

Badge ID Setup

Operators require badge IDs for shop floor transactions. Badges can have effective dates and can be transferred between employees.

Manufacturing Mobile â€ē Administration â€ē Badge IDs 
Badge ID Configuration Fields:
  - Badge Number: Unique identifier (often barcode-friendly)
  - Employee: Assigned operator
  - Effective From/To: Date range for badge validity
  - Transfer: Can reassign to different employee if needed
💡 Dual Functionality
Manufacturing Mobile and WMS can run on the same scanner. Operators can perform both manufacturing and warehouse activities from a single device, switching between apps as needed.

Material Requirements Planning (MRP)

MRP calculates net material requirements by comparing demand (sales orders, forecasts, safety stock) against supply (on-hand, purchase orders, work orders) and generates planned orders to fill gaps.

MRP Planning Parameters

Parameter Description Where Set
Lead Time Days to procure/produce Item record
Safety Stock Minimum inventory buffer Item or Item-Location
Reorder Point Qty that triggers reorder Item or Item-Location
Preferred Stock Level Target inventory level Item or Item-Location
Lot Size Minimum order quantity Item or Vendor-Item
Planning Horizon Days to look ahead MRP setup

MRP Output Actions

Action Meaning Response
Create PO Need to order purchased items Generate purchase order
Create WO Need to manufacture assembly Generate work order
Expedite Existing order needed sooner Move delivery date earlier
Defer Order can be pushed out Move delivery date later
Cancel Order no longer needed Review for cancellation
💡 MRP Enhancements
NetSuite includes enhanced MRP regeneration performance, better handling of phantom BOMs, and improved exception messaging with actionable recommendations.

Supply Planning (MRP)

NetSuite Supply Planning replaces legacy Time-Phased Planning with improved performance and features. Use the Supply Planning Workbench to manage planned orders and balance supply with demand.

Three Key Planning Criteria

Criteria Description Considerations
Planning Horizon Days into future the plan covers Longer horizons = more data; test performance with your volume
Planning Scope Items/locations included in plan Demand sources per location
Planning Rules Transfer rules for supply chain Define how items move between locations

Supply Planning Workbench Actions

Action Description Creates
Firm Planned Order Lock order to prevent replanning Firmed planned order
Release Planned Order Convert to actual transaction Purchase Order, Work Order, or Transfer Order
Change Order Modify existing order dates/qty Updated order
⚠ī¸ Performance Consideration
MRP may fail with 730-day planning horizons and 100,000+ item-locations, but completes successfully at 400 days. Test your planning horizon with your data volume before production use.

Demand Planning

Demand Planning analyzes historical sales data to forecast future demand, enabling proactive inventory management rather than reactive reordering. Generate accurate projections to maintain optimal stock levels, reduce stockouts, and minimize excess inventory carrying costs.

Setup â€ē Manufacturing â€ē Demand Planning Preferences

Demand Planning Prerequisites

Prerequisites

Demand Sources

NetSuite considers multiple demand sources when calculating requirements:

Demand Source Transaction Type When Included
Sales Orders Committed customer demand Open sales orders with unfulfilled quantity
Opportunities Potential demand (weighted) Open opportunities x probability %
Quotes/Estimates Potential demand Open quotes not yet converted
Transfer Orders Inter-location demand Open transfer orders (destination location)
Work Orders Component demand Open work orders for parent assemblies
Sales Forecasts Manual projections Entered sales forecast records
Blanket POs Committed purchase demand Customer blanket POs with release schedules

Projection Methods

Method Algorithm Best For Data Requirement
Linear Regression Least squares fit to historical trend line Items with steady growth or decline 12+ months history
Moving Average Average of last N periods Stable demand with minor variations 3-6 months minimum
Weighted Moving Average Recent periods weighted more heavily Recent trends more relevant than older history 6+ months history
Seasonal Average Averages same period across multiple years Products with predictable seasonal cycles 24+ months history
Seasonal Linear Regression Linear regression with seasonal adjustment Trending items with seasonal patterns 24+ months history
Sales Forecast Uses manually entered forecast records New products, promotions, known events No history needed
Current Demand Uses existing transactions (SO, Opps, Quotes) Known pipeline, make-to-order environments Active transaction data

Projection Method Formulas

MOVING AVERAGE (N periods):
  Forecast = (Period1 + Period2 + ... + PeriodN) / N
  Example (3-month MA): (100 + 120 + 110) / 3 = 110 units

WEIGHTED MOVING AVERAGE:
  Forecast = Sum(Period_i x Weight_i) / Sum(Weights)
  Example: Weight recent month 3x, middle 2x, oldest 1x
  (100x1 + 120x2 + 130x3) / (1+2+3) = 122 units

LINEAR REGRESSION:
  y = mx + b  (where m = slope, b = intercept)
  Example trend: +10 units/month
  Month 6 forecast = 100 + (10 x 6) = 160 units

SEASONAL AVERAGE:
  Forecast(Month) = Avg(Same month from previous years)
  Example: December forecast
  = (Dec 2022 + Dec 2023 + Dec 2024) / 3
  = (500 + 520 + 540) / 3 = 520 units

Demand Plan Configuration

Transactions â€ē Manufacturing â€ē Calculate Demand Plan
Field Options Guidance
Subsidiary Select subsidiary (OneWorld) Demand plans are subsidiary-specific
Location Specific or All Locations Run by warehouse for location-specific forecasts
Projection Method See methods above Can vary by item class or category
Period Type Day, Week, Month Monthly for strategic; weekly for tactical
Historical Periods Number of past periods 12-24 months for seasonal; 6+ for trending
Projection Periods Number of future periods Match your planning horizon (lead time + buffer)
Item Filter Saved Search or criteria Filter by class, category, or department
Include Sales Orders Checkbox Include committed demand in projection
Include Opportunities Checkbox + probability threshold Include at probability x quantity

Forecast Accuracy Metrics

Track forecast accuracy to improve projections over time:

Metric Formula Target Interpretation
MAPE (Mean Absolute % Error) Avg(|Actual - Forecast| / Actual) x 100 < 20% Lower is better; 10-20% is good for most industries
Bias Sum(Forecast - Actual) / Sum(Actual) ±5% Positive = over-forecasting; Negative = under-forecasting
Tracking Signal Cumulative Error / MAD -4 to +4 Outside range indicates systematic bias
Forecast Value Add (FVA) Naive Error - Forecast Error Positive Measures if forecasting adds value vs. naive method
💡 Seasonal Index Calculation
The sum of all 12 seasonal indices should equal 12.0 (averaging to 1.0). NetSuite automatically normalizes indices if they don't sum correctly. For new products without history, copy seasonal profiles from similar items.
ℹī¸ Demand Planning Limits
Demand Planning processes up to 10,000 items per run. For larger item catalogs, run multiple demand plans segmented by item class, category, or location. Schedule staggered runs to avoid system performance impact.
⚠ī¸ Common Demand Planning Pitfalls
  • Insufficient History: Seasonal methods require 2+ years of data; use simpler methods for newer items
  • Ignoring Outliers: One-time bulk orders distort forecasts; cleanse data or exclude
  • Static Methods: Review projection method effectiveness quarterly; demand patterns change
  • Over-Adjustment: Too many manual overrides defeats the purpose; adjust only with documented rationale
  • Misaligned Horizons: Projection period shorter than lead time creates reactive ordering

Industry Applications

👔 Professional Services
Professional Services Consideration
Component Demand: BOM explosion creates dependent demand for raw materials. Production Smoothing: Forecast peak periods and pre-build during slow periods. Capacity Planning: Link demand forecasts to work center capacity requirements.
👔 Professional Services
Professional Services Consideration
Vendor Commitments: Use forecasts to negotiate better pricing with suppliers. Seasonal Stocking: Pre-position inventory before seasonal peaks. ABC Classification: Daily forecasts for A items; monthly for C items.
👔 Professional Services
Professional Services Consideration
Promotion Lifts: Model promotional impact separately from baseline demand. Store-Level Forecasts: Location-specific demand for inventory allocation. Holiday Planning: Start holiday forecasts 4-6 months ahead.

Production Costing

Cost Components

Cost Type Source Calculation
Material BOM components Qty x Component Cost
Labor Routing operations Hours x Labor Rate
Machine Routing operations Hours x Machine Rate
Overhead Work centers Hours x Overhead Rate
Setup Routing operations Setup Time x Rates

Variance Analysis

Variance Type Calculation Cause
Material Usage Actual qty - Standard qty Scrap, yield loss
Material Price Actual price - Standard price Price changes, substitutions
Labor Efficiency Actual hours - Standard hours Training, equipment issues
Labor Rate Actual rate - Standard rate Overtime, different crew
⚠ī¸ Standard Costing Setup
For variance tracking, items must use Standard costing method. Set standard costs before production begins. Update standards periodically (typically annually) through cost rollups.

Shop Floor Control

Production Execution Features

Feature Purpose Configuration
Operation Tracking Track progress per routing step Enable in routing setup
Labor Entry Record actual labor time Time entry or Work Order Completion
Component Substitution Use alternate components Define alternates on BOM
Scrap Tracking Record scrap quantities On Work Order Issue/Build
Batch/Serial Tracking Traceability in production Item-level lot/serial settings

Quality Control Integration

  • Inspection points: Define QC checks at routing operations
  • Hold/Release: Quality hold status on work orders
  • Non-conformance: Track defects and dispositions
  • Certificates: Generate COA/COC documents

Outsourced Manufacturing

Outsourced Manufacturing enables managing production performed by external vendors (subcontractors). Track materials sent to vendors and assemblies returned.

Outsourced Manufacturing Workflow

Outsourced Manufacturing Flow:

1. Create Work Order
   - Assembly item with Outsourced Manufacturing enabled
   - Link to outsource vendor

2. Ship Components to Vendor
   - Create Item Fulfillment to vendor location
   - Components consumed from inventory

3. Vendor Completes Production
   - (External process - vendor manufactures assemblies)

4. Receive Finished Goods
   - Create Item Receipt from vendor
   - Assemblies added to inventory

5. Process Vendor Bill
   - Bill for manufacturing services
   - Post outsourced cost to assembly

When to Use Outsourced Manufacturing

  • Capacity overflow: Internal production cannot meet demand
  • Specialized processes: Vendor has equipment/expertise you lack
  • Cost optimization: Outsourcing is more economical
  • Secondary vendors: Backup manufacturing capability

Engineering Change Orders (ECO)

Engineering Change Orders document and authorize changes to Bill of Materials. Use ECOs to maintain revision history and approval audit trails.

ECO Use Cases

Change Type Description ECO Justification
Component Substitution Replace one component with another Part obsolescence, cost reduction
Quantity Change Modify component quantities Design optimization, yield improvement
Component Addition Add new component to BOM Feature enhancement, quality improvement
Component Removal Remove component from BOM Cost reduction, design simplification
Routing Change Modify manufacturing process Efficiency improvement, equipment change

ECO Workflow

ECO Process:

1. Create ECO Record
   - Document proposed change
   - Identify affected BOMs/assemblies
   - Set effective date

2. Review & Approval
   - Engineering review
   - Cost impact analysis
   - Management approval (workflow)

3. Implementation
   - Update BOM revision (set new effective dates)
   - Update routing if needed
   - Communicate to production

4. Verification
   - Verify changes applied correctly
   - Close ECO record

Industry-Specific Manufacturing Patterns

Discrete Manufacturing

  • Standard BOMs with revision control
  • Detailed routing with operation tracking
  • Serial number tracking for finished goods
  • Configure-to-order with matrix items

Process Manufacturing

  • Formula-based BOMs with yield percentages
  • Batch/lot tracking for ingredients
  • Co-products and by-products
  • Potency and grade tracking

Job Shop

  • Project-linked work orders
  • One-off BOMs per customer order
  • Flexible routing sequences
  • Extensive labor time tracking

Repetitive Manufacturing

  • Backflush material consumption
  • Production line rates vs work orders
  • Kanban-style replenishment
  • Minimal WIP tracking
👔 Professional Services
Professional Services Consideration
For discrete manufacturing, use standard costing with variance analysis. For process manufacturing, consider lot costing with yield tracking.

Manufacturing Implementation Checklist

Chapter 8.4

SuitePeople HR

Human capital management, employee self-service, performance management, and workforce analytics.

SuitePeople HR Overview

SuitePeople HR extends NetSuite's native employee records into a full human capital management (HCM) solution. The module provides core HR functions, workforce management, and employee experience tools integrated with financials.

Component Functionality License
Core HR Employee records, org charts, job management Base SuitePeople
Employee Center Self-service portal for employees Base SuitePeople
Performance Management Goals, reviews, competencies SuitePeople Performance
Workforce Analytics HR dashboards, metrics, trends SuitePeople Analytics
Payroll US payroll processing SuitePayroll (separate)
ℹī¸ SuitePeople vs Standard Employee
Standard NetSuite includes basic employee records. SuitePeople adds comprehensive HR features including position management, onboarding workflows, and employee experience tools. Evaluate which level fits your HR needs.

Core HR Management

Employee Record Structure

EMPLOYEE DATA MODEL

Employee Record
  |-- Personal Information
  |   |-- Name, Address, Contact
  |   |-- Emergency Contacts
  |   +-- Documents (I-9, W-4, etc.)
  |
  |-- Employment Details
  |   |-- Position / Job Title
  |   |-- Department / Class
  |   |-- Supervisor Hierarchy
  |   |-- Location / Work Assignment
  |   +-- Employment Type (FT, PT, Contract)
  |
  |-- Compensation
  |   |-- Salary / Hourly Rate
  |   |-- Pay Frequency
  |   +-- Benefits Elections
  |
  +-- History
      |-- Job History
      |-- Compensation History
      +-- Performance Reviews

Position Management

Concept Description Use Case
Position Specific seat in organization Track vacancies, headcount planning
Job Job description template Standardize titles, compensation bands
Job Family Group of related jobs Career paths, reporting
Grade Level Compensation tier Salary bands, equity

Organization Structure

  • Supervisory hierarchy: Approval routing, organizational chart
  • Departments: Cost center alignment, reporting
  • Locations: Work site, compliance (tax nexus)
  • Classes: Business unit or division segmentation

Employee Lifecycle Management

Lifecycle Stages

Hire
→
Onboard
→
Active
→
Changes
→
Offboard

Onboarding Workflow

Onboarding Tasks

Employment Changes

Change Type Workflow Records Updated
Promotion Approval chain, effective date Position, Title, Compensation
Transfer Manager approval, HR processing Department, Location, Supervisor
Compensation Change Budget approval, HR approval Salary, Pay Frequency
Termination Exit workflow, final pay calc Status, Term Date, Access revoked

Employee Self-Service

Employee Center Features

Feature Employee Actions Manager Actions
Personal Info Update address, phone, emergency contacts View team directory
Time & Attendance Submit timesheets, request time off Approve time, view team calendar
Expenses Submit expense reports Approve expense reports
Pay Stubs View pay history, W-2s N/A
Benefits View/enroll in benefits N/A
Goals/Reviews Set goals, complete self-assessment Set team goals, conduct reviews

Employee Center Configuration

Employee Center Setup

Performance Management

Performance Review Cycle

Annual Performance Cycle:

Q1           Q2           Q3           Q4           Q1 (Next)
Goal         Mid-Year     Progress     Annual       Comp
Setting      Check-in     Update       Review       Planning
  |            |            |            |            |
  v            v            v            v            v
Employee    Manager      Employee    360 Input    Merit/Bonus
Goals       Feedback     Updates     Calibration  Decisions

Performance Review Components

Component Description Configuration
Goals Individual objectives Goal types, templates, cascading
Competencies Skills and behaviors Competency library, job mapping
Self-Assessment Employee reflection Review forms, rating scales
Manager Review Supervisor evaluation Review templates, workflows
360 Feedback Multi-rater input Rater selection, anonymity
Calibration Cross-team consistency Calibration meetings, adjustments
💡 Rating Scale Design
Use clear, behaviorally-anchored rating scales (e.g., 1-5 with descriptions). Avoid forced distribution unless required. Train managers on consistent rating application.

Time & Attendance

Time Tracking Options

Method Description Best For
Weekly Timesheets Standard hours per project/task Professional services, project costing
Time Clock Clock in/out with punch times Hourly workers, manufacturing
Case Time Tracking Time against support cases Support teams, billable hours
Project Time Entry Time against project tasks Consulting, professional services

Time-Off Management

Feature Configuration Notes
Time-Off Types PTO, Sick, Bereavement, etc. Separate accrual tracking per type
Accrual Rules Per pay period, annual, tenure-based Configure per employee class
Carryover Max carryover, use-it-or-lose-it Policy varies by location/type
Blackout Dates Restrict requests during busy periods Optional per department

Workforce Analytics

Key HR Metrics

Metric Calculation Target
Headcount Active employees by period Plan vs actual
Turnover Rate Separations / Avg headcount Industry benchmark
Time to Fill Days from req open to hire < 45 days typical
Cost per Hire Total recruiting costs / Hires Varies by role level
Absenteeism Unplanned absence days / Work days < 3%
Revenue per Employee Total revenue / FTE Industry benchmark

HR Dashboards

  • Executive Dashboard: Headcount trends, cost analysis, turnover
  • Manager Dashboard: Team metrics, pending approvals, open positions
  • HR Operations: Onboarding status, compliance items, case queue
  • Compensation: Salary distribution, merit budgets, equity analysis

HR Compliance

Compliance Areas

Area Requirements NetSuite Support
I-9 Verification Employment eligibility within 3 days Document storage, reminders
EEO Reporting Annual EEO-1 filing (100+ employees) Demographic fields, reports
FLSA Overtime, exempt classification Employee type tracking
ACA Health coverage reporting Hours tracking, 1095-C forms
State Requirements Varies by state (leave, pay) Configurable policies
⚠ī¸ Data Privacy
Employee data is sensitive. Configure field-level permissions, audit trails, and data retention policies. Consider GDPR requirements for international employees.

SuitePeople Implementation Checklist

Chapter 8.5

SuiteCommerce

B2B and B2C e-commerce, web store management, catalog configuration, and omnichannel retail.

SuiteCommerce Overview

SuiteCommerce provides native e-commerce capabilities integrated with NetSuite ERP, supporting B2C retail sites, B2B customer portals, and hybrid scenarios.

Product Description Best For
SuiteCommerce Advanced (SCA) Full-featured, customizable e-commerce Complex B2C, high customization
SuiteCommerce Standard Pre-built templates, faster deployment Simple B2C, quick launch
SuiteCommerce MyAccount Self-service customer portal B2B, customer account management
SuiteCommerce InStore Point-of-sale for retail locations Brick-and-mortar, omnichannel
ℹī¸ Architecture
SuiteCommerce Advanced runs on Node.js with Backbone.js frontend. It uses SuiteScript for backend customization and SCSS for styling.

Web Site Setup

Web Site Record Configuration

Setting Purpose Location
Domain Primary site URL Web Site record
Subsidiary Financial entity for orders Web Site record
Default Location Inventory source for orders Web Site record
Default Currency Pricing display currency Web Site record
Customer Form Registration form template Web Site Setup

Catalog Management

Web Store Item Setup

Field Purpose Best Practice
Display in Web Site Make item visible online Check for all sellable items
Web Store Description Product description HTML SEO-optimized, customer-friendly
Store Display Name Name shown on website Clear, searchable title
Item Images Product photos Multiple angles, consistent size
URL Component URL slug for product page Hyphenated, keyword-rich
Meta Tags SEO title/description Unique per item, include keywords

Category Structure

Category Setup

Matrix Items (Variants)

Matrix items represent products with variations (size, color). Parent item holds common attributes; child items represent specific combinations.

Matrix Example
Matrix Example: T-Shirt
+-- Parent: T-SHIRT-BASIC
    +-- Child: T-SHIRT-BASIC-S-RED
    +-- Child: T-SHIRT-BASIC-M-RED
    +-- Child: T-SHIRT-BASIC-L-RED
    +-- Child: T-SHIRT-BASIC-S-BLUE
    +-- Child: T-SHIRT-BASIC-M-BLUE
    +-- Child: T-SHIRT-BASIC-L-BLUE

Options on Web:
  Size: [S] [M] [L]
  Color: [Red] [Blue]

Pricing & Promotions

Price Level Strategy

Approach Description Use Case
Base Price Standard retail price Anonymous/guest shoppers
Customer Price Levels Tiered pricing by customer group Wholesale, VIP customers
Quantity Pricing Volume discounts Bulk purchase incentives
Customer-Specific Negotiated prices per customer B2B contracts

Promotion Types

Type Example Configuration
Percent Discount 20% off all shirts Promotion record with % rate
Dollar Discount $10 off orders over $50 Minimum order threshold
BOGO Buy 2 get 1 free Buy X Get Y promotion
Free Shipping Free shipping on $75+ Shipping method promotion
Promo Code Enter code SAVE15 Coupon code required
⚠ī¸ Promotion Stacking
Configure promotion rules carefully to prevent unintended discount stacking. Use "Best Discount Only" or set explicit exclusion rules. Test all promotion combinations before launch.

Checkout & Payment Processing

Checkout Flow

Cart
→
Info
→
Shipping
→
Payment
→
Confirm

Payment Gateway Integration

Gateway Features Notes
NetSuite Payment Gateway Native integration, PCI compliant Included with SuiteCommerce
PayPal Express checkout, PayPal Credit Popular for B2C
Stripe Cards, Apple Pay, Google Pay SuiteApp integration
Authorize.net Traditional gateway, CIM Established merchant accounts

Guest vs Registered Checkout

  • Guest: No account required, faster checkout, less friction
  • Registered: Save payment/shipping, order history, reorder
  • Hybrid: Guest checkout with optional account creation post-purchase

B2B Commerce Features

B2B vs B2C Differences

Feature B2C B2B
Pricing Standard retail Customer-specific, contract
Checkout Credit card, PayPal Terms, PO numbers, approval
Catalog Public, full catalog Restricted by customer
Quantities Individual units Bulk, case packs, MOQs
Account Optional/guest Required, multi-user

MyAccount Portal Features

MyAccount Capabilities

SEO & Analytics

SEO Configuration

Element Location Best Practice
Page Titles Item/Category Meta Title Keyword | Brand (60 chars)
Meta Descriptions Item/Category Meta Description Compelling, keyword-rich (160 chars)
URL Structure URL Component field Descriptive, hyphenated slugs
Canonical URLs Site configuration Prevent duplicate content
Sitemap Auto-generated Submit to search engines

Analytics Integration

  • Google Analytics: Track traffic, conversions, user behavior
  • Enhanced E-commerce: Product impressions, cart, checkout funnel
  • Google Tag Manager: Manage tracking tags without code changes
  • NetSuite Reports: Web store sales, conversion rates
👔 Professional Services
Professional Services Consideration
For B2C, optimize mobile experience - over 60% of e-commerce traffic is mobile. Test checkout flow on multiple devices.

SuiteCommerce Implementation Checklist

Chapter 8.6

SuiteProjects

Project accounting, resource management, and professional services automation.

SuiteProjects Overview

SuiteProjects provides comprehensive project management from opportunity through delivery and billing. Essential for professional services firms, agencies, and project-based businesses.

Capability Basic Projects SuiteProjects
Project Records Yes Yes
Task Management Basic Advanced with WBS
Resource Management Limited Full resource allocation
Project Budgeting Basic Advanced with EVM
Revenue Recognition Manual Automated % complete
Gantt Charts No Yes

Project Billing Types

Type Description Use Case
Time & Materials Bill actual hours at agreed rates Consulting, support
Fixed Price Contracted price regardless of effort Defined scope projects
Non-Billable Internal cost tracking only Internal projects, R&D
Milestone Bill at defined deliverables Phase-based projects

Project Structure

SuiteProjects uses a hierarchical structure to organize work:

Project Hierarchy
PROJECT (Job Record)
+-- Project Tasks
|   +-- Task 1: Requirements Phase
|   |   +-- Subtask 1.1: Discovery Workshops
|   |   +-- Subtask 1.2: Document Requirements
|   |   +-- Subtask 1.3: Sign-off
|   |
|   +-- Task 2: Design Phase
|   |   +-- Subtask 2.1: Solution Architecture
|   |   +-- Subtask 2.2: Technical Design
|   |
|   +-- Task 3: Build Phase
|       +-- Subtask 3.1: Configuration
|       +-- Subtask 3.2: Development
|       +-- Subtask 3.3: Testing
|
+-- Project Resources (Assigned Employees)
|   +-- Project Manager
|   +-- Senior Consultant
|   +-- Developer
|
+-- Project Budget
|   +-- Labor Budget
|   +-- Expense Budget
|   +-- Material Budget
|
+-- Billing Schedule
    +-- Milestone 1: Requirements Complete
    +-- Milestone 2: Design Approved
    +-- Milestone 3: Project Go-Live

Project Setup

Setup â€ē Accounting â€ē Project Management
Setting Options Recommendation
Project Type Standard, Template Create templates for repeatable projects
Billing Type Time & Materials, Fixed Price, Non-Billable Align with contract terms
Percent Complete Override Enabled/Disabled Enable for milestone-based rev rec
Project Cost Rules Employee cost, Standard cost, Custom Employee cost for accurate margins
Allow Time Entry Per project Enable on billable projects

Time Tracking

Accurate time tracking is the foundation of project accounting:

Time Entry
→
Approval
→
Costing
→
Billing
→
Revenue

Time Entry Methods

Method Best For Pros Cons
Weekly Timesheet Most employees Grid view, fast entry, copy week Less detail per entry
Time Record Detailed tracking Full detail, notes, memo Slower entry
Employee Center Self-service Easy access, mobile-friendly Limited permissions
Mobile Field workers Real-time entry, location Requires app
💡 Time Approval Workflow
Set up workflow approval for time entries to catch issues before billing. Route by project manager, department head, or threshold amount. Consider same-day approval for accurate WIP reporting.

Resource Management

Match the right resources to projects based on skills, availability, and utilization targets:

Resource Allocation View
Resource         Mon    Tue    Wed    Thu    Fri    Util%
---------------------------------------------------------
Sarah (PM)
  Project A      4h     4h     4h     4h     4h     50%
  Project B      2h     2h     2h     2h     2h     25%
  Admin          2h     2h     2h     2h     2h     25%
                                              TOTAL: 100%

Mike (Sr. Cons)
  Project A      8h     8h     8h     --     --     60%
  Project C      --     --     --     8h     8h     40%
  Bench          --     --     --     --     --      0%
                                              TOTAL: 100%

Lisa (Developer)
  Project B      8h     8h     8h     8h     8h    100%
  Available      --     --     --     --     --      0%
                                              TOTAL: 100%

Target Utilization: 75% (billable)

Resource Management Features

  • Skills Matrix: Track employee certifications, technologies, and expertise levels
  • Availability Calendar: View PTO, training, and existing allocations
  • Utilization Targets: Set billable hour targets by role or department
  • Capacity Planning: Forecast resource needs vs. availability
  • Resource Request: Project managers request resources from resource pool
ℹī¸ Project Manager Role
A dedicated role for project managers provides optimized permissions for project oversight without full accounting access. Includes project dashboard, resource requests, and budget monitoring.

Project Budgeting

Control project profitability with detailed budgets:

Budget Category Components Key Metrics
Labor Budget Hours x Rate by role, Resource assignments ETC (Estimate to Complete), EAC (Estimate at Completion)
Expense Budget Travel, software, subcontractors Spend vs. budget, reimbursable %
Material Budget Items charged to project Markup, pass-through costs
Revenue Budget Milestone amounts, T&M estimates Recognized vs. billed vs. contracted
Project Budget Example
PROJECT: ERP Implementation - Acme Corp
Contract Value: $250,000

LABOR BUDGET
Role              Hours    Rate     Budget     Actual    Var
Project Manager    200    $175    $35,000    $32,000   $3,000
Sr. Consultant     400    $200    $80,000    $72,000   $8,000
Consultant         600    $150    $90,000    $85,000   $5,000
Developer          200    $125    $25,000    $28,000  ($3,000)
Labor Total                       $230,000   $217,000  $13,000

EXPENSE BUDGET
Category                  Budget     Actual    Var
Travel                   $10,000     $8,500   $1,500
Software/Licenses         $5,000     $5,000      $0
Training Materials        $2,500     $1,800     $700
Expense Total            $17,500    $15,300   $2,200

SUMMARY
Contract Value:                    $250,000
Total Costs:                       $232,300
Gross Margin:                       $17,700 (7.1%)
Target Margin:                          10%
Status:                     Below target

Billing Methods

SuiteProjects supports multiple billing approaches:

Time & Materials (T&M)

  • Bill actual hours worked at agreed rates
  • Charge expenses at cost or with markup
  • Create invoices from unbilled time/expenses
  • Best for: Scope-variable projects, ongoing support

Fixed Price

  • Bill predetermined amounts at milestones
  • Track costs internally for margin analysis
  • Revenue recognition based on % complete
  • Best for: Well-defined scope, predictable work

Retainer/Prepaid

  • Collect payment upfront
  • Draw down against time/expenses
  • Alert when retainer runs low
  • Best for: Ongoing services, advisory relationships
⚠ī¸ Revenue Recognition Considerations
Project billing method must align with ASC 606 / IFRS 15 revenue recognition requirements. Fixed price projects typically use percentage-of-completion; T&M recognizes as services delivered. Consult with accounting on appropriate treatment.

Project Financials

Track profitability at every level:

Project Profitability Statement
PROJECT: ERP Implementation - Acme Corp
Period: Q4 2025

REVENUE
  Milestone Billings                         $175,000
  T&M Billings                                $25,000
  Expense Reimbursements                       $8,500
  TOTAL REVENUE                              $208,500

COST OF SERVICES
  Direct Labor (at cost rates)               $145,000
  Contractor Costs                            $15,000
  Travel & Expenses                            $8,500
  Other Direct Costs                           $2,300
  TOTAL COS                                  $170,800

GROSS PROFIT                                  $37,700
Gross Margin %                                 18.1%

KEY METRICS
  Budget Variance:                      $15,200 favorable
  Schedule Variance:                    On track (2 days ahead)
  Scope Changes:                        3 approved (+$12,000)
  Customer Satisfaction:                4.5/5.0

Project Dashboard & Reporting

Report Category Key Reports Audience
Project Health Project Status Summary, Milestone Tracker, Risk Register Project Managers, Executives
Financial Project P&L, WIP Report, Budget vs. Actual Finance, Project Managers
Resource Utilization by Employee, Capacity Forecast, Bench Report Resource Managers, HR
Billing Unbilled Time, Unbilled Expenses, Billing Backlog Finance, Project Managers
Time Timesheet Status, Time by Project/Task, Approval Queue HR, Project Managers

Industry Applications

👔 Professional Services
Professional Services Consideration
Core use case for SuiteProjects. Track client engagements, manage consultant utilization, bill by project/phase/milestone, and measure realization rates. Focus on gross margin by project and practice area.
👔 Professional Services
Professional Services Consideration
Implementation projects for new customers, professional services engagements, and internal development projects. Track billable vs. R&D time, measure implementation margin, and capitalize development costs per ASC 350-40.
👔 Professional Services
Professional Services Consideration
Engineering projects, new product development, capital projects, and plant improvements. Track project costs against capital budgets, manage cross-functional teams, and integrate with work orders.
đŸŽ¯ Consultant Insight
The #1 SuiteProjects implementation challenge is getting employees to enter time accurately and promptly. Build time entry into daily habits: require approval before expenses, tie to performance reviews, and make it as easy as possible. Weekly timesheet view with ability to copy previous week is key for adoption.

SuiteProjects Implementation Checklist

Chapter 8.7

Planning & Budgeting

Financial planning, budgeting, and forecasting with NetSuite Planning and Budgeting (NSPB).

Planning & Budgeting Overview

NetSuite offers native budgeting (included) and NSPB (licensed add-on) for enterprise-grade planning with driver-based modeling, multi-scenario planning, and collaborative workflow.

Capability Native Budgets NSPB
Budget Entry Per account, per period Model-driven with calculations
Scenarios Single version Unlimited what-if scenarios
Driver Models Not available Revenue drivers, headcount, etc.
Forecasting Manual reforecast Rolling forecasts, AI predictions
Consolidation Manual Automated multi-subsidiary

Native Budgeting Setup

Setup â€ē Company â€ē Enable Features â€ē Accounting â€ē Budgets
⚖ī¸ Key Decision

Budget Entry Methods

Budget Categories

Create budget categories to track multiple versions:

COMMON BUDGET CATEGORIES: - Operating Budget: Primary annual budget (Board-approved) - Revised Budget: Mid-year adjustments - Stretch Budget: Aggressive targets for incentives - Forecast: Rolling forecast (monthly updates) - Prior Year: Last year's budget for comparison
💡 Budget Import Best Practice
Use CSV import for initial budget load. Template includes: Year, Account, Department, Period 1-12 amounts. Run import in sandbox first.

Budget Structure

Setup â€ē Accounting â€ē Set Up Budgets
Field Description Best Practice
Year Fiscal year for this budget Create budgets annually; archive prior years
Subsidiary Legal entity (OneWorld) Budget at lowest subsidiary level, roll up for consolidation
Account GL account being budgeted Budget P&L accounts; balance sheet rarely budgeted
Department Cost center (optional) Budget at department level for accountability
Class Product/segment (optional) Use for product-line or business unit budgets
Location Site/facility (optional) Use for location-specific budgets (retail, manufacturing)

CSV Budget Import

Setup â€ē Import/Export â€ē Import CSV Records â€ē Budget
Budget Import Template
Required Columns:
- Year (fiscal year)
- Account (account number or name)
- Period 1, Period 2... Period 12 (amounts by period)

Optional Columns:
- Subsidiary (internal ID or name)
- Department (internal ID or name)
- Class (internal ID or name)
- Location (internal ID or name)
- Budget Category (name)

SAMPLE CSV:
Year,Account,Department,Period 1,Period 2,Period 3,...
2025,4000 Revenue,Sales,100000,110000,120000,...
2025,6100 Salaries,Sales,45000,45000,45000,...
2025,6200 Marketing,Marketing,15000,20000,25000,...

Budget vs. Actual Reporting

Report Navigation Use Case
Budget vs. Actual Reports > Financial > Budget vs. Actual Standard variance report by account
Budget Income Statement Reports > Financial > Income Statement Add budget columns to P&L (customize)
Budget Register Reports > Financial > Budget Register List all budget entries for audit

Variance Analysis in Saved Searches

Budget Variance Formulas
-- Variance (Actual - Budget)
{amount} - {budgetamount}

-- Variance % ((Actual - Budget) / Budget)
CASE WHEN {budgetamount} = 0 THEN NULL
     ELSE ROUND((({amount} - {budgetamount}) / ABS({budgetamount})) * 100, 1)
END

-- Favorable/Unfavorable Flag
CASE
  WHEN {type} IN ('Income','Other Income') AND {amount} >= {budgetamount} THEN 'Favorable'
  WHEN {type} IN ('Income','Other Income') AND {amount} < {budgetamount} THEN 'Unfavorable'
  WHEN {type} IN ('Expense','COGS','Other Expense') AND {amount} <= {budgetamount} THEN 'Favorable'
  WHEN {type} IN ('Expense','COGS','Other Expense') AND {amount} > {budgetamount} THEN 'Unfavorable'
  ELSE 'N/A'
END
đŸŽ¯ Budget Governance
Establish clear budget ownership: each GL account should have one owner responsible for variance explanations. Create a monthly review process where department heads explain variances over 10%. Document explanations in a custom field or attached note for audit trail.

NSPB: Enterprise Planning

For organizations that have outgrown native budgeting, NetSuite Planning and Budgeting (NSPB) provides enterprise-grade capabilities. The following sections cover NSPB-specific functionality.

NSPB Components

Component Purpose Key Features
Models Define data structure and calculations Dimensions, hierarchies, formulas, drivers
Forms Data entry interface Grid-based input, validation rules, spreads
Workflows Approval and task management Task assignment, status tracking, notifications
Reports Analysis and presentation Dashboards, variance analysis, drill-down
Scenarios What-if analysis Base, best case, worst case, working
Integrations Data synchronization NetSuite GL, subledger, external sources

Dimension Design

Dimensions define the granularity and structure of your planning model:

Planning Model Dimensions
REQUIRED DIMENSIONS
  ACCOUNT       TIME          SCENARIO       VERSION
  GL Accounts   Months        Budget         Working
  Hierarchy     Quarters      Forecast       Submitted
  Roll-ups      Years         Best Case      Approved
                Fiscal/Cal    Worst Case     Published

ORGANIZATIONAL DIMENSIONS
  SUBSIDIARY    DEPARTMENT    LOCATION       CLASS
  Legal entities Cost centers  Facilities    Products
  Hierarchy     Roll-up       Geography      Segments
  Elimination   Allocation    Consolidation  P&L split

CUSTOM DIMENSIONS (Examples)
  PRODUCT       CUSTOMER      PROJECT        EMPLOYEE
  Product lines Segments      Capital proj   Headcount
  SKU groups    Key accounts  Initiatives    Roles
  Categories    Territories   Programs       Levels

Driver-Based Planning

Move beyond line-item budgeting to models that calculate from business drivers:

Revenue Drivers

Revenue Model Examples
SUBSCRIPTION REVENUE (SaaS)
  Beginning ARR                           $10,000,000
  + New Logo ARR        Deals x ASP       $2,500,000
  + Expansion ARR       Base x Rate       $1,000,000
  - Churn               Base x Churn %      ($500,000)
  Ending ARR                              $13,000,000

  MRR = ARR / 12                          $1,083,333

PRODUCT REVENUE (Wholesale)
  Units Sold           Customers x Avg Units    100,000
  x Average Price      List - Discount %           $150
  x Seasonal Factor    Index by month             1.15
  Gross Revenue                            $17,250,000
  - Returns            Gross x Return %      ($862,500)
  Net Revenue                              $16,387,500

Expense Drivers

Expense Model Examples
HEADCOUNT-DRIVEN
  Headcount by Role x Salary x Month         = Salaries
  Headcount x Benefits Rate                  = Benefits
  Headcount x Payroll Tax Rate               = Payroll Taxes
  Sales Headcount x Quota x Commission %     = Commissions
  Engineering HC x Tool Cost/Employee        = Software
  Total HC x Rent/Employee                   = Facilities

REVENUE-DRIVEN
  Revenue x COGS %                           = Cost of Goods
  Revenue x Marketing %                      = Marketing
  Revenue x Hosting % (SaaS)                 = Infrastructure
  Revenue x Bad Debt %                       = Bad Debt

ACTIVITY-DRIVEN
  Support Tickets x Cost/Ticket              = Support Costs
  Transactions x Processing Fee              = Payment Fees
  Travel Days x Per Diem                     = Travel
  Shipments x Avg Freight                    = Shipping
ℹī¸ AI-Powered Predictions
NSPB supports AI-powered multivariate predictions. Combine historical data with external factors (seasonality, economic indicators) to generate more accurate forecasts. Models learn from actuals vs. forecast variance to improve over time.

Workflow & Approval

Manage the planning process with structured workflows:

Initialize
→
Input
→
Review
→
Consolidate
→
Approve
Stage Owner Actions
Initialize FP&A Set targets, seed data, open forms
Input Department Heads Enter budget, add notes, submit
Review Finance Business Partners Validate, request changes, approve
Consolidate FP&A Roll up, adjust, model scenarios
Approve CFO / Board Final review, lock, publish

Scenario Analysis

Model multiple outcomes to understand risk and opportunity:

Scenario Comparison
                    Budget      Best Case   Worst Case   Likely
ASSUMPTIONS
  Revenue Growth    15%         25%         5%           18%
  New Customers     50          75          25           55
  Churn Rate        8%          5%          15%          7%
  Headcount Adds    20          25          10           22

RESULTS
  Revenue          $50M        $62M        $41M         $53M
  Gross Margin     65%         68%         58%          66%
  Operating Exp    $35M        $38M        $30M         $36M
  EBITDA           $10M        $15M        $2M          $11M
  EBITDA Margin    20%         24%         5%           21%
  Cash EOY         $25M        $35M        $15M         $27M

PROBABILITY WEIGHTED
  Expected Revenue = (Budget x 40%) + (Best x 20%) + (Worst x 10%) + (Likely x 30%)
                   = $51.5M

Reporting & Analysis

Report Type Purpose Audience
Budget vs. Actual Period performance to budget All managers
Variance Analysis Drill into favorable/unfavorable Finance, department heads
Forecast vs. Prior Forecast Track forecast accuracy FP&A
Scenario Comparison Side-by-side what-if Executive team
Driver Dashboard KPI performance vs. plan Executives, board
Workflow Status Budget completion tracking FP&A

Industry Applications

👔 Professional Services
Professional Services Consideration
Model ARR, MRR, customer cohorts, and unit economics. Plan by customer segment, product line, and geography. Forecast bookings to revenue conversion with proper deferred revenue timing.
👔 Professional Services
Professional Services Consideration
Capacity planning tied to production volume. Model material costs with commodity price assumptions. Workforce planning by shift and skill level. Capital expenditure modeling for equipment and facilities.
👔 Professional Services
Professional Services Consideration
Headcount-driven model with utilization assumptions. Plan revenue by practice area, client, and project type. Model hiring pipeline to meet capacity needs. Forecast bench costs and contractor spend.
⚠ī¸ Common Implementation Pitfalls
  • Over-engineering: Start simple; add complexity only when needed
  • Dimension explosion: Too many dimensions = slow calculations, user confusion
  • Stale actuals: Schedule frequent syncs; outdated actuals undermine trust
  • Unclear ownership: Define who owns each budget line and approval
  • No documentation: Document assumptions, formulas, and processes
đŸŽ¯ Consultant Insight
The biggest NSPB success factor is executive sponsorship. If the CFO does not actively use the system for decision-making, adoption will fail. Start with a high-visibility use case (board deck, investor reporting) that executives care about. Once leadership relies on NSPB for key decisions, department-level adoption follows naturally.

Planning & Budgeting Checklist

Chapter 8.8

Compliance 360

Regulatory compliance, audit management, and governance with NetSuite Compliance 360.

Compliance 360 Overview

NetSuite Compliance 360 provides comprehensive compliance management including control monitoring, audit management, policy enforcement, and regulatory reporting for SOX, GDPR, HIPAA, and other requirements.

Capability Manual Compliance Compliance 360
Control Monitoring Periodic manual testing Continuous automated monitoring
Evidence Collection Spreadsheets, email Centralized, automated capture
Audit Preparation Weeks of gathering On-demand reporting
Issue Tracking Manual follow-up Workflow-driven remediation

Control Types

Type Description Examples
Preventive Stop issues before they occur Approval workflows, segregation of duties
Detective Identify issues that occurred Exception reports, variance analysis
Corrective Remediate identified issues Adjusting entries, process fixes
ℹī¸ SOX Compliance
For public companies, Compliance 360 maps controls to SOX 404 requirements. Automate evidence collection for internal control over financial reporting (ICFR).

Control Mapping

Map each control to the regulatory requirements it satisfies. A single control may address multiple frameworks.

Control-to-Regulation Mapping Example
CONTROL: Vendor Invoice Three-Way Match

Description: System requires match of PO, receipt, and invoice
             before payment approval

Frequency:   Continuous (automated)
Type:        Preventive / Application Control
Owner:       Accounts Payable Manager

REGULATORY MAPPING:
  Framework   | Requirement  | Description
  SOX         | Section 404  | Financial reporting controls
  COSO        | Control Act. | Transaction authorization
  COBIT       | BAI06        | IT change management
  ISO 27001   | A.12.1.2     | Change management

TEST PROCEDURE:
1. Generate report of invoices processed in period
2. Sample 25 invoices (statistical sample)
3. Verify PO, receipt, and invoice match for each
4. Document any exceptions
5. Assess control effectiveness

Automated Testing

Configure automated control tests that run continuously:

Test Type Mechanism Example
Transaction Tests Saved search with criteria Identify invoices without PO approval
Access Reviews Role/permission analysis Users with conflicting duties
Threshold Monitoring Value-based alerts Purchases over limit without approval
Trend Analysis Period-over-period comparison Unusual expense patterns
Configuration Checks System setting validation Password policy compliance

Audit Management

Streamline internal and external audit processes:

Plan
→
Request
→
Collect
→
Review
→
Report

Audit Workflow

Phase Activities Compliance 360 Support
Planning Define scope, timeline, team Audit project templates, risk-based scoping
Information Request Auditor requests (PBC list) Request management, assignment tracking
Evidence Collection Gather supporting documentation Automated evidence capture, secure portal
Testing Control testing, substantive tests Test results documentation, exception tracking
Findings Issue identification, remediation Issue workflow, remediation tracking
Reporting Opinion, management letter Report generation, status dashboards

Risk Assessment

Risk Scoring Matrix
                    IMPACT
           |  Low   Medium   High   Critical
    -------+----------------------------------
    High   |   M       H       C       C
LIKELIHOOD |
    Medium |   L       M       H       C
           |
    Low    |   L       L       M       H

L = Low Risk (Accept/Monitor)
M = Medium Risk (Mitigate)
H = High Risk (Priority Mitigation)
C = Critical Risk (Immediate Action)

RISK FACTORS:
  Financial Impact:     Dollar value at risk
  Regulatory Impact:    Fines, sanctions exposure
  Operational Impact:   Business disruption
  Reputational Impact:  Brand/customer trust
  Control Effectiveness: Existing mitigation strength

Regulatory Frameworks

Compliance 360 includes pre-built frameworks for common regulations:

Framework Scope Key Requirements
SOX (Sarbanes-Oxley) Public companies Section 302/404, internal controls over financial reporting
GDPR EU data subjects Data protection, consent, right to erasure, breach notification
HIPAA Healthcare (US) PHI protection, access controls, audit trails
PCI-DSS Payment card data Cardholder data security, network controls
SOC 2 Service organizations Trust services criteria (Security, Availability, etc.)
CCPA/CPRA California residents Consumer privacy rights, opt-out, data access

Segregation of Duties

Monitor and enforce separation of conflicting responsibilities:

Segregation of Duties Matrix
                          CREATE   APPROVE   POST   RECONCILE
------------------------------------------------------------
Vendor Master              X         X        --        --
Purchase Orders            X         X        --        --
Vendor Bills               --        X        X         --
Payments                   --        X        X         X
Bank Reconciliation        --        --       --        X

X = Conflicting duties (cannot be same person)

CONFLICT MONITORING:
  Role Analysis:        Review permission combinations
  Transaction Monitor:  Same user on conflicting steps
  Exception Reporting:  Override and emergency access
  Periodic Review:      Quarterly SoD assessment
⚠ī¸ Common SoD Violations
  • Same user creates and approves purchase orders
  • AP clerk has vendor master edit access
  • Payroll admin can edit own compensation
  • IT admin has production and development access
  • Single user for journal entry creation and posting

Industry Applications

👔 Professional Services
Professional Services Consideration
HIPAA compliance for protected health information (PHI). Track access to patient data, monitor for unauthorized disclosure, manage business associate agreements, and maintain breach notification procedures.
👔 Professional Services
Professional Services Consideration
SOC 2 and ISO 27001 for customer trust. Demonstrate security, availability, and confidentiality controls to enterprise customers. Document change management, access controls, and incident response.
👔 Professional Services
Professional Services Consideration
SOX compliance for public companies, export controls (ITAR/EAR), and environmental regulations (EPA). Quality management system controls for ISO 9001. Supply chain compliance for conflict minerals.
👔 Professional Services
Professional Services Consideration
Single Audit (Uniform Guidance) for federal grant recipients. Fund accounting controls, cost allocation compliance, and donor restriction monitoring. Grant-specific reporting and compliance attestation.

Reporting & Dashboards

Report Purpose Audience
Control Effectiveness Test results and exceptions by control Compliance team, auditors
Risk Heat Map Visual risk distribution Executive team, board
Issue Aging Open findings by severity and age Compliance, management
SoD Violations Conflicting access/actions IT security, audit
Audit Status Request fulfillment, timeline Compliance team, auditors
Policy Attestation Employee acknowledgment tracking HR, compliance
đŸŽ¯ Consultant Insight
The ROI of Compliance 360 comes from audit preparation time savings. Companies typically spend weeks gathering evidence for external audits. With proper setup, this drops to days. Start by mapping your most frequent audit requests to automated evidence capture.

Compliance Implementation Checklist

Chapter 8.9

Advanced Revenue Management (ARM)

ASC 606 and IFRS 15 compliant revenue recognition, performance obligations, and contract revenue automation.

ARM Overview

NetSuite ARM automates revenue recognition in compliance with ASC 606 (US GAAP) and IFRS 15 (International), handling complex scenarios that manual processes struggle to manage.

ℹī¸ When to Use ARM
  • Bundled sales: Multiple products/services sold together
  • Subscription businesses: SaaS with multiple performance obligations
  • Long-term contracts: Multi-year arrangements with variable pricing
  • Audit requirements: Public companies or those preparing for IPO

ASC 606 Five-Step Model

Identify Contract
→
Identify POs
→
Determine Price
→
Allocate Price
→
Recognize Revenue

Key ARM Components

Revenue Elements

Revenue Elements define how each item type should be recognized:

Setup â€ē Accounting â€ē Revenue Recognition â€ē Revenue Elements
Field Purpose Example
Recognition Method How revenue is recognized Point in time, Over time (straight-line), Over time (% complete)
SSP Method How to determine standalone selling price List price, Adjusted market, Cost plus margin
Revenue Account GL account for recognized revenue 4100 - Software Revenue
Deferred Revenue Account GL account for unrecognized revenue 2300 - Deferred Revenue
Recognition Period Duration for over-time recognition 12 months, 36 months

Revenue Arrangements

Revenue Arrangements are automatically created from source transactions and contain the allocation calculations:

Revenue Arrangement Structure
REVENUE ARRANGEMENT #RA-00125
Source: Sales Order #SO-50234
Customer: Acme Corporation
Arrangement Date: 2025-01-15
Total Value: $150,000

REVENUE ELEMENTS
Element          | Quantity | Price   | SSP     | Allocated
Software License |    1     | $80,000 | $90,000 | $81,818
Implementation   |    1     | $50,000 | $45,000 | $40,909
Year 1 Support   |    1     | $20,000 | $30,000 | $27,273
TOTAL            |          |$150,000 |$165,000 | $150,000

Allocation Method: Relative SSP
Discount: $15,000 allocated proportionally

Standalone Selling Price (SSP)

SSP is the price at which you would sell the good or service separately. ARM supports multiple methods:

SSP Method When to Use Calculation
Observable Price Item sold separately frequently Use actual selling price from standalone sales
Adjusted Market Assessment Competitor pricing available Market price adjusted for entity-specific factors
Expected Cost Plus Margin No market price available Expected costs + appropriate margin
Residual Approach Highly variable/uncertain SSP Total price minus SSP of other elements
⚠ī¸ SSP Documentation Required

Auditors require documentation supporting your SSP methodology. Maintain evidence of:

  • Standalone sales data (prices, volumes, customer types)
  • Market research for adjusted market approach
  • Cost buildup and margin analysis for cost-plus approach
  • Annual SSP review and update procedures

Recognition Methods

Point in Time

Revenue recognized when control transfers (typically delivery or acceptance):

  • Product shipment/delivery
  • License effective date
  • Customer acceptance
  • Title transfer

Over Time

Revenue recognized as performance obligation is satisfied over a period:

Method Measure Use Case
Straight-Line Equal amounts each period Support contracts, SaaS subscriptions
Input Method (Cost) Costs incurred / Total expected costs Implementation services, consulting
Input Method (Hours) Hours worked / Total expected hours Fixed-fee professional services
Output Method Units delivered / Total units Milestone-based projects

Contract Modifications

ARM handles changes to existing contracts systematically:

Contract Modification Treatment
SCENARIO 1: SEPARATE CONTRACT
Criteria: Additional distinct goods/services at SSP
Treatment: Account as separate contract
Example: Customer adds users at list price

SCENARIO 2: TERMINATION + NEW CONTRACT
Criteria: Remaining goods/services distinct from delivered
Treatment: Terminate old, create new arrangement
Example: Major scope change mid-project

SCENARIO 3: CUMULATIVE CATCH-UP
Criteria: Remaining goods/services NOT distinct
Treatment: Update allocation, adjust revenue cumulatively
Example: Change order on percentage-of-completion project

Variable Consideration

ARM handles pricing that may change based on future events:

Type Example Estimation Method
Discounts/Rebates Volume discount at year-end Expected value or most likely amount
Performance Bonuses Bonus for on-time delivery Probability-weighted scenarios
Penalties Late delivery penalty Expected value of penalty risk
Right of Return 30-day money-back guarantee Expected returns based on history
Price Concessions Expected negotiated reduction Historical concession rates
💡 Constraint on Variable Consideration
Include variable consideration only to the extent it's highly probable that a significant reversal won't occur. Be conservative -- it's better to recognize additional revenue later than to reverse recognized revenue.

GL Impact

ARM GL Flow Example
SCENARIO: $120,000 annual SaaS contract, billed upfront
Recognition: Straight-line over 12 months

INITIAL INVOICE (January 1):
   Dr: Accounts Receivable      $120,000
   Cr: Deferred Revenue                   $120,000

MONTHLY RECOGNITION (January 31):
   Dr: Deferred Revenue         $10,000
   Cr: Revenue - SaaS                     $10,000

BALANCE SHEET (January 31):
   Deferred Revenue (Current):   $110,000
   (Remaining 11 months)

Industry Applications

👔 Professional Services
Professional Services Consideration
Most complex ARM use case. Bundle typically includes: perpetual or term license, implementation services, training, and ongoing support. Each element requires separate SSP and recognition treatment. SaaS is usually straight-line; implementation may be percentage-of-completion. Track renewal rates for contract asset/liability presentation.
👔 Professional Services
Professional Services Consideration
Equipment + installation + warranty bundles. Equipment recognized at delivery (point in time), installation as services performed, warranty over coverage period. Extended warranties sold separately should match SSP to standalone warranty pricing.
👔 Professional Services
Professional Services Consideration
Fixed-fee projects with multiple deliverables. Use percentage-of-completion based on hours or costs. Track estimates-to-complete carefully -- overruns can cause revenue reversals. Milestone-based recognition requires defined, measurable milestones.
👔 Professional Services
Professional Services Consideration
Device companies with implants + follow-up care. Medical device at delivery, follow-up services over care period. Track contractual adjustments (insurance reimbursement differences) as variable consideration.
đŸŽ¯ Consultant Insight
ARM implementations fail most often due to incomplete SSP analysis. Before configuring ARM, spend significant time gathering historical standalone sales data and documenting your methodology. The configuration is straightforward once you've solved the accounting policy questions. Also plan for the data conversion -- you'll need to determine treatment for in-flight contracts at go-live.
ℹī¸ Deep Dive Available
For comprehensive ARM configuration, SSP calculation methods, fair value hierarchies, and complex scenario handling, see Appendix L: Advanced Revenue Management Deep Dive.

ARM Implementation Checklist

Chapter 8.10

Fixed Assets Management (FAM)

Asset lifecycle management, depreciation, and fixed asset accounting with NetSuite FAM.

FAM Overview

NetSuite Fixed Assets Management tracks the complete lifecycle of capital assets from acquisition through disposal, automating depreciation calculations and maintaining accurate book and tax records.

Asset Lifecycle

Acquire
→
Capitalize
→
Depreciate
→
Transfer
→
Dispose

Asset Types

Asset Types define default accounting and depreciation settings:

Setup â€ē Accounting â€ē Fixed Assets â€ē Asset Types
Asset Type Typical Life Method Examples
Buildings 39 years (US) Straight-line Office buildings, warehouses
Building Improvements 15 years Straight-line HVAC, roofing, renovations
Machinery & Equipment 5-7 years MACRS/Straight-line Production equipment, tools
Furniture & Fixtures 7 years Straight-line Desks, chairs, shelving
Vehicles 5 years MACRS Trucks, cars, forklifts
Computer Equipment 3-5 years Straight-line Servers, workstations, network
Software 3 years Straight-line Purchased software licenses
Leasehold Improvements Lease term Straight-line Tenant improvements

Depreciation Methods

FAM supports standard depreciation methods for both book and tax purposes:

Method Formula Use Case
Straight-Line (Cost - Salvage) / Life Most common, even expense allocation
Declining Balance Book Value x Rate Accelerated, higher early expense
Double Declining Balance Book Value x (2 / Life) More aggressive acceleration
Sum-of-Years-Digits Depreciable Base x (Remaining Life / SYD) Accelerated, less aggressive than DDB
Units of Production (Cost - Salvage) x (Units / Total Units) Based on usage, not time
MACRS (US Tax) IRS tables by property class US federal tax depreciation
Depreciation Calculation Example
ASSET: Production Equipment
Cost: $100,000
Salvage Value: $10,000
Useful Life: 5 years
Method: Straight-Line

ANNUAL DEPRECIATION:
($100,000 - $10,000) / 5 years = $18,000 per year

MONTHLY DEPRECIATION:
$18,000 / 12 months = $1,500 per month

DEPRECIATION SCHEDULE:
Year | Beginning    | Depreciation | Accumulated  | Ending
     | Book Value   |   Expense    | Depreciation | Book Value
  1  |   $100,000   |    $18,000   |   $18,000    |  $82,000
  2  |    $82,000   |    $18,000   |   $36,000    |  $64,000
  3  |    $64,000   |    $18,000   |   $54,000    |  $46,000
  4  |    $46,000   |    $18,000   |   $72,000    |  $28,000
  5  |    $28,000   |    $18,000   |   $90,000    |  $10,000

Multiple Depreciation Books

FAM supports parallel depreciation books for different reporting requirements:

Book Purpose Method Example
Primary (GAAP) Financial statements Straight-line, 7 years
Tax (Federal) US tax returns MACRS, 5-year property
State Tax State-specific rules May differ from federal
AMT Alternative Minimum Tax 150% declining balance
IFRS International reporting May include revaluation
Management Internal analysis Economic life basis
💡 Book-Tax Differences
Different depreciation lives and methods create temporary differences between book and tax income. Track these for deferred tax calculations. FAM reports show book vs. tax depreciation side-by-side for tax provision purposes.

Asset Transactions

Acquisition from Vendor Bill

Create assets directly from vendor bills for automatic cost capture:

  1. Enter vendor bill for asset purchase
  2. Use Fixed Asset item type on bill line
  3. FAM creates asset record automatically
  4. Asset linked to source transaction for audit trail

Capital Improvements

Add costs to existing assets when improvements extend life or add capability:

Capital Improvement Example
Original Asset: Delivery Truck
Original Cost: $50,000
Accumulated Depreciation: $20,000 (2 years)
Net Book Value: $30,000

Improvement: New engine installation
Improvement Cost: $8,000
Effect: Extends useful life by 2 years

TREATMENT:
New Cost Basis: $50,000 + $8,000 = $58,000
Remaining Life: Original 3 years + 2 years = 5 years
New Annual Depreciation: ($30,000 + $8,000) / 5 = $7,600

Asset Disposal

FAM calculates gain or loss and generates appropriate journal entries:

Asset Disposal Example
ASSET: Office Furniture
Original Cost: $25,000
Accumulated Depreciation: $20,000
Net Book Value: $5,000
Sale Proceeds: $3,000

GAIN/LOSS CALCULATION:
Proceeds:                    $3,000
Less: Net Book Value:       ($5,000)
Loss on Disposal:           ($2,000)

JOURNAL ENTRY:
   Dr: Cash                         $3,000
   Dr: Accumulated Depreciation    $20,000
   Dr: Loss on Disposal             $2,000
   Cr: Fixed Asset - Furniture              $25,000

Depreciation Processing

Fixed Assets â€ē Process Depreciation

Monthly depreciation workflow:

  1. Preview: Run depreciation preview report
  2. Review: Check for new assets, disposals, changes
  3. Process: Generate depreciation journal entries
  4. Post: Review and post journals to GL
  5. Reconcile: Verify GL balances to FAM reports
⚠ī¸ Depreciation Timing
Run depreciation BEFORE period close. Once a period is closed, you cannot post depreciation to it. Build depreciation processing into your month-end close checklist with adequate buffer time.

Key Reports

Report Purpose Audience
Asset Register Complete listing of all assets Auditors, asset managers
Depreciation Schedule Projected depreciation by period Finance, budgeting
Book vs. Tax Comparison Differences for tax provision Tax department
Asset Additions New assets in period Finance, auditors
Asset Disposals Disposed assets and gains/losses Finance, auditors
NBV Summary Net book value by category Management, auditors

Industry Applications

👔 Professional Services
Professional Services Consideration
Heavy equipment, production machinery, and tooling require careful tracking. Use units-of-production depreciation for equipment where wear correlates to usage. Track maintenance costs separately from capital improvements. Consider component depreciation for complex machinery with parts having different useful lives.
👔 Professional Services
Professional Services Consideration
Warehouse equipment, forklifts, racking systems, and delivery vehicles. Fleet management integration tracks vehicle costs and depreciation together. Leasehold improvements for warehouse spaces require tracking against lease terms.
👔 Professional Services
Professional Services Consideration
Store fixtures, POS systems, and leasehold improvements across multiple locations. Track assets by location for accurate store-level P&L. Impairment testing for underperforming locations may require write-downs.
👔 Professional Services
Professional Services Consideration
IT infrastructure, office furniture, and leasehold improvements. Lower asset intensity but important for office buildouts. Computer equipment typically 3-5 year life. Consider immediate expensing under Section 179 or bonus depreciation for tax purposes.
👔 Professional Services
Professional Services Consideration
Grant-funded assets may have restrictions on disposal. Track funding source on assets for compliance reporting. Some grants require return of proceeds on disposition. Donated assets require fair value determination at acquisition.
đŸŽ¯ Consultant Insight
The most common FAM implementation mistake is incomplete historical asset data. Before go-live, reconcile your asset register to the GL fixed asset accounts. Every dollar on the balance sheet needs a corresponding asset record. Clean up fully depreciated assets that are still in use -- they need records even with zero book value. Budget significant time for data cleanup.
ℹī¸ Deep Dive Available
For detailed FAM configuration, tax depreciation tables, impairment testing, component depreciation, and lease accounting (ASC 842), see Appendix M: Fixed Assets Management Deep Dive.

FAM Implementation Checklist

Chapter 8.11

CPQ (Configure, Price, Quote)

Product configuration, dynamic pricing, and guided selling with NetSuite CPQ.

CPQ Overview

NetSuite CPQ enables sales teams to configure complex products, apply appropriate pricing, and generate professional quotes efficiently while enforcing business rules.

CPQ Core Capabilities

Capability Description Benefit
Product Configuration Guided selection of options and features Error-free configurations
Pricing Rules Dynamic pricing based on configuration Accurate quotes, margin protection
Quote Generation Professional documents with terms Faster sales cycles
Approval Workflows Route discounts for approval Margin governance

Product Configuration

CPQ product configuration allows customers and sales reps to build valid product combinations through a guided process, preventing invalid configurations and automatically calculating pricing.

Configuration Model Types

Model Type Description Example
Option-Based Select from predefined options per attribute Laptop: RAM (8GB/16GB/32GB), Storage (256/512/1TB)
Rule-Based Options constrained by business rules If GPU = "High-end", then Power Supply must be 750W+
BOM-Based Configuration generates specific bill of materials Custom furniture with dimensions, materials, finishes
Bundle-Based Group products/services with quantity rules Software suite: Base + 2-5 modules + support tier

Configurable Item Setup

Lists â€ē Accounting â€ē Items â€ē New â€ē Select Configurable Type
Configurable Product Structure
EXAMPLE: Custom Server Configuration

Base Product: Server-Config-Base
  Attribute Group: Processor
    Option: Intel Xeon Silver (+ $0)
    Option: Intel Xeon Gold (+ $800)
    Option: Intel Xeon Platinum (+ $2,400)

  Attribute Group: Memory
    Option: 32GB DDR4 (+ $0)
    Option: 64GB DDR4 (+ $400)
    Option: 128GB DDR4 (+ $1,200)
    Option: 256GB DDR4 (+ $3,000)

  Attribute Group: Storage
    Option: 1TB SSD (+ $0)
    Option: 2TB SSD (+ $300)
    Option: 4TB SSD RAID (+ $1,200)
    Option: 8TB SSD RAID (+ $3,500)

  Attribute Group: Support
    Option: Standard (1yr) (+ $0)
    Option: Extended (3yr) (+ $1,500)
    Option: Premium 24/7 (3yr) (+ $4,000)

CONFIGURATION RULES:
Rule 1: IF Processor = "Platinum" THEN Memory minimum = 128GB
Rule 2: IF Storage = "8TB RAID" THEN Processor cannot = "Silver"
Rule 3: IF Support = "Premium" THEN include Monitoring-Service

Configuration Rules

Rules enforce valid configurations and guide users to appropriate choices:

Rule Type Purpose Example
Constraint Prevent invalid combinations Cannot select 4K monitor with basic GPU
Requirement Force selection when condition met Outdoor unit requires weatherproofing package
Recommendation Suggest options (non-blocking) With this printer, most customers add extra toner
Default Pre-select common options Standard warranty pre-selected
Calculation Compute derived values Total rack units = sum of component U heights

Pricing Engine

CPQ's pricing engine handles complex pricing scenarios that go beyond standard NetSuite price levels.

Pricing Methods

Method Description Use Case
List Price Base catalog price Starting point for all calculations
Price Matrix Multi-dimensional lookup table Price varies by size, material, quantity
Volume Tiered Price breaks at quantity thresholds 1-99: $10, 100-499: $8, 500+: $6
Cost-Plus Margin applied to calculated cost BOM cost + 35% markup
Customer-Specific Negotiated rates per customer Contract pricing for key accounts
Subscription Recurring charges with terms Monthly/annual SaaS pricing

Discount Rules

Discount Hierarchy (Applied in Order)
1. CONTRACT DISCOUNTS (Customer-specific agreements)
   Customer ABC Corp: 15% off list on all products

2. PROMOTIONAL DISCOUNTS (Time-limited campaigns)
   Q4 Promo: 10% off Product Category X (expires 12/31)

3. VOLUME DISCOUNTS (Quantity-based)
   Order > $50,000: Additional 5% off

4. BUNDLE DISCOUNTS (Package deals)
   Buy Base + 3 modules: 20% off modules

5. PAYMENT TERM DISCOUNTS
   Prepay annual: 2 months free (16.7% effective discount)

FLOOR PRICE PROTECTION:
Minimum margin: 25% above cost
Approval required if: Discount > 30% OR margin < 30%
Auto-reject if: Price < cost

Guided Selling

Guided selling helps sales reps and customers navigate complex product catalogs through a question-and-answer workflow that recommends appropriate products.

Guided Selling Example: IT Infrastructure
STEP 1: Business Requirements
  What is your primary use case?
    - Web/Application Server
    - Database Server
    - File Storage
    - Virtualization Host
    - High-Performance Computing
         [Selection: Database Server]

STEP 2: Scale Requirements
  Expected database size?
    - Small (< 100 GB)
    - Medium (100 GB - 1 TB)
    - Large (1 TB - 10 TB)
    - Enterprise (> 10 TB)
         [Selection: Large]

STEP 3: Performance Requirements
  Transaction volume?
    - Standard (< 1,000 TPS)
    - High (1,000 - 10,000 TPS)
    - Ultra (> 10,000 TPS)
         [Selection: High]

STEP 4: Recommendations Generated
  RECOMMENDED CONFIGURATION:
  Server-DB-Pro (Best Match - 94% fit)
    Xeon Gold / 256GB RAM / 4TB NVMe RAID
    Price: $12,400

  Server-DB-Standard (Budget Option - 78% fit)
    Xeon Silver / 128GB RAM / 2TB SSD RAID
    Price: $7,200

Needs Assessment Questions

Build guided selling flows with these question types:

Question Type Format Use Case
Single Select Radio buttons Mutually exclusive choices
Multi-Select Checkboxes Multiple features needed
Numeric Input Number field Quantities, dimensions, budgets
Range Slider Slider control Performance levels, priorities
Conditional Dynamic based on prior answers Branch logic for different paths

Quote Management

CPQ transforms the quoting process from manual document creation to automated, accurate quote generation with built-in approval workflows.

Quote Workflow

Quote Lifecycle
[Opportunity] => [Configure] => [Price] => [Quote] => [Approval] => [Present] => [Order]

QUOTE STATUSES:
Draft           - Being configured, not yet submitted
Pending Review  - Awaiting internal review
Pending Approval- In approval workflow (discount/margin)
Approved        - Ready to present to customer
Presented       - Sent to customer
Accepted        - Customer agreed, ready to convert
Expired         - Past validity date
Rejected        - Customer declined
Converted       - Turned into Sales Order

Quote Document Generation

Transactions â€ē Sales â€ē Create Quote â€ē Actions â€ē Generate PDF

CPQ generates professional quote documents with:

  • Cover page: Company branding, customer info, executive summary
  • Configuration summary: Selected options with descriptions
  • Pricing breakdown: Line items, discounts, totals
  • Terms and conditions: Standard or custom T&Cs
  • Validity period: Quote expiration date
  • Signature block: For customer acceptance

Quote Approval Workflow

Approval Matrix
DISCOUNT-BASED APPROVAL:
Discount Level   | Approver Required
0% - 15%         | None (auto-approved)
16% - 25%        | Sales Manager
26% - 35%        | Sales Director
36% - 50%        | VP Sales
> 50%            | CFO

MARGIN-BASED APPROVAL:
Gross Margin     | Approver Required
> 40%            | None (auto-approved)
30% - 40%        | Sales Manager
20% - 30%        | Sales Director + Finance
< 20%            | VP Sales + CFO

DEAL SIZE APPROVAL:
Deal Value       | Approver Required
< $50,000        | Sales Manager
$50K - $250K     | Sales Director
$250K - $1M      | VP Sales
> $1M            | VP Sales + CEO

CPQ Integration Points

CRM Integration

CPQ to CRM Data Flow
OPPORTUNITY => CPQ:
  Customer information
  Contact details
  Expected close date
  Competitor information
  Budget range

CPQ => OPPORTUNITY:
  Quote amount
  Product mix
  Discount levels
  Win probability adjustment
  Forecast category

QUOTE => SALES ORDER:
  All line items and configurations
  Pricing and discounts
  Terms and conditions
  Shipping information
  Payment terms

SuiteCommerce Integration

CPQ can be exposed through SuiteCommerce for self-service configuration:

Feature Internal CPQ SuiteCommerce CPQ
User Sales rep Customer self-service
Pricing visibility Full (cost, margin) Customer pricing only
Discount authority Per role permissions Customer contract only
Quote vs Order Generate quotes Direct to cart/order
Guided selling Full questionnaire Simplified wizard

Manufacturing Integration

CPQ to Manufacturing Flow
1. CONFIGURATION COMPLETE
   CPQ validates all options selected

2. BOM GENERATION
   Configuration rules generate specific BOM
   Routing determined based on options

3. QUOTE APPROVED
   Customer accepts quote

4. SALES ORDER CREATED
   SO created with configured item

5. WORK ORDER GENERATED
   WO created with configuration-specific BOM
   Routing steps assigned
   Materials allocated

6. PRODUCTION
   Build to configuration spec
   QC checkpoints per options selected

Example:
  Quote: Custom Cabinet - Oak, 36"W, Soft-Close, Glass Doors
    BOM Generated:
    - Oak Panel 36" (2)
    - Oak Frame 36" (1)
    - Soft-Close Hinges (4)
    - Glass Door Panel (2)
    - Hardware Kit - Premium
    Routing: Cut => Assemble => Finish => Glass Install => QC => Pack

Industry Applications

👔 Professional Services
Professional Services Consideration
Configure-to-Order (CTO): Build custom products from standard components. CPQ manages valid configurations, generates accurate BOMs, and calculates lead times based on component availability. Critical for furniture, machinery, electronics, and industrial equipment manufacturers. Integration with MRP ensures materials are planned for configured orders.
👔 Professional Services
Professional Services Consideration
Subscription Bundles: Configure software packages with base products, add-on modules, user tiers, and support levels. CPQ handles complex subscription pricing -- monthly vs. annual, per-user vs. flat-rate, tiered usage. Quote renewals with price escalation. Integrate with ARM for revenue recognition compliance.
👔 Professional Services
Professional Services Consideration
Volume Pricing & Kitting: Complex pricing matrices based on customer tier, order volume, and product mix. CPQ automates contract pricing, rebate calculations, and promotional pricing. Kit configuration for pre-assembled bundles. Integration with inventory for availability-based quoting.
👔 Professional Services
Professional Services Consideration
Scope-Based Quoting: Configure service packages based on project scope, team composition, and deliverables. CPQ calculates resource requirements and generates Statements of Work. Integration with SuiteProjects for resource planning and project setup upon order conversion.
👔 Professional Services
Professional Services Consideration
Regulated Configurations: Configure medical equipment with compliance requirements. CPQ enforces valid combinations (e.g., device + required accessories), tracks regulatory certifications per configuration, and generates compliance documentation with quotes. Audit trail for all configuration decisions.

CPQ Best Practices

Implementation Tips

  • Start with top products: Configure your 20% of products that drive 80% of revenue first
  • Document all rules: Business rules should be documented outside CPQ for maintenance
  • Test edge cases: Invalid configurations should fail gracefully with clear messages
  • Train sales team: CPQ only helps if reps actually use it -- invest in adoption
  • Monitor quote metrics: Track quote-to-order conversion, time-to-quote, discount trends
  • Regular rule review: Pricing and configuration rules need periodic updates
đŸŽ¯ Consultant Insight
The biggest CPQ implementation risk is over-engineering the configuration model. Start with the minimum viable configuration that covers 80% of scenarios. Add complexity only when sales demonstrates clear need. A simple CPQ that gets used beats a sophisticated one that gets bypassed. Also, get Sales involved early -- if the workflow doesn't match how they actually sell, adoption will fail.

CPQ Implementation Checklist

Chapter 8.12

Field Service Management (FSM)

Work order management, scheduling, dispatch, and mobile field operations.

FSM Overview

NetSuite Field Service Management coordinates service delivery from customer request through technician dispatch, work completion, and billing.

FSM Workflow

Request
→
Schedule
→
Dispatch
→
Execute
→
Invoice

Key FSM Capabilities

Capability Description Benefit
Work Order Management Create and track service jobs Complete job history
Scheduling Optimize technician assignments Higher utilization
Mobile App Technician access to job details Real-time updates
Parts Management Track inventory on trucks First-time fix rate
Service Contracts Manage SLAs and warranties Entitlement tracking

Scheduling Optimization

Factor Consideration Configuration
Skills Match technician to job requirements Skill matrix on employee records
Location Minimize drive time Territory assignments, routing
Availability Consider existing appointments Calendar integration
SLA Meet response time commitments Priority and escalation rules
👔 Professional Services
Professional Services Consideration
Track first-time fix rate (FTFR) as a key metric. Target 80%+ FTFR by ensuring technicians have parts and information before dispatch.

FSM in NetSuite: Your Options

NetSuite provides field service capabilities through native features and SuiteApp extensions. Understanding your options is critical for choosing the right approach.

FSM Solution Comparison

Capability Native NetSuite NextService (Recommended)
Case Management ✓ Support Cases ✓ Enhanced with FSM workflow
Work Orders ✓ Manufacturing WO only ✓ Service Work Orders
Dispatch Board ✗ ✓ Drag-and-drop scheduling
Mobile App ✗ (NetSuite app is limited) ✓ Full-featured iOS/Android
Route Optimization ✗ ✓ Google Maps integration
Technician Skills ✗ ✓ Skill-based assignment
Equipment Tracking Basic (Serial Numbers) ✓ Full installed base
Service Contracts Basic (via Projects) ✓ SLA management
Parts from Truck Manual inventory adjust ✓ Mobile consumption
Digital Signatures ✗ ✓ On mobile device
Offline Mode ✗ ✓ Full offline support
đŸŽ¯ Consultant Insight: When to Use Each
  • Native NetSuite: In-office service, simple case tracking, <5 field techs with basic needs
  • NextService: True field service operations, mobile workforce, route optimization, SLA tracking
  • Oracle Field Service Cloud: Enterprise 500+ technicians, complex scheduling algorithms

For most mid-market companies with field technicians, NextService is the recommended solution due to its native NetSuite integration and comprehensive feature set.

FSM Solution Architecture

Layer Components Role
Native NetSuite Support Cases, Projects, Project Tasks, Time Tracking, Inventory Core ERP foundation for service management
NextService SuiteApp Service Work Orders, Dispatch Board, Mobile App, Equipment Records, Service Contracts, Route Optimization Extended FSM capabilities layered on NetSuite
Integration Layer Customer Record, Service Items, Employee/Resource, Locations (Truck Stock) Shared data connecting native and FSM records

Key data flows: Cases escalate to Work Orders → Dispatch Board schedules to technicians → Mobile App enables field execution → Parts consumed from Inventory → Time posted back to NetSuite. Contracts and Equipment records feed into Work Order creation.

Native NetSuite Service Capabilities

Before implementing a SuiteApp, understand what native NetSuite offers for service management.

Support Cases

Support â€ē Cases â€ē New Case

Cases are the foundation of NetSuite's native service management:

Field Purpose FSM Use
Company/Contact Links to customer Service location
Item Product/service reference Equipment being serviced
Serial Number Specific unit Equipment identification
Assigned To Employee owner Technician assignment
Priority High/Medium/Low SLA indicator
Status Open/In Progress/Closed Workflow state

Native Case-to-Service Flow

Customer Call
→
Create Case
→
Needs Site Visit?
→
Create Project Task
→
Assign to Tech
→
Perform Work
→
Log Time
→
Close Case
→
Invoice Customer

If the case can be resolved remotely, skip directly from "Create Case" to "Close Case."

Using Projects for Service Work

Projects â€ē Projects â€ē New Project

For recurring service or multi-visit jobs, create a Project:

  • Project Template: "Service Visit" template with standard tasks
  • Project Tasks: Each site visit becomes a task
  • Resource Allocation: Assign technician to task
  • Time Tracking: Technician logs time against task
  • Expense Tracking: Parts and mileage on project
⚠ī¸ Native Limitations

Native NetSuite service features lack:

  • Visual dispatch board (Gantt-style scheduling)
  • Mobile app designed for field technicians
  • Route optimization and GPS tracking
  • Skill-based automatic assignment
  • Customer signature capture
  • Offline capability for remote areas

For true field service operations, NextService or similar SuiteApp is required.

NextService: The Leading NetSuite FSM SuiteApp

NextService is a Built for NetSuite (BFN) certified SuiteApp that extends NetSuite with comprehensive field service management capabilities.

NextService Installation

Customization â€ē SuiteBundler â€ē Search & Install Bundles â€ē Search 'NextService'
ℹī¸ NextService Licensing
  • Pricing Model: Per-user/per-month (dispatcher + technician seats)
  • Bundle ID: Search SuiteApp Marketplace for current version
  • Trial: Contact NextService for sandbox trial
  • Implementation: Typically 4-8 weeks for full deployment

NextService Record Types

Record NetSuite Path Purpose
Service Work Order NextService → Work Orders → New Primary service transaction
Equipment NextService → Equipment → List Customer installed base
Service Contract NextService → Contracts → New SLA and coverage terms
Resource NextService → Resources → List Technician with skills
Skill NextService → Setup → Skills Certification/capability
Territory NextService → Setup → Territories Geographic service area

NextService Work Order Flow

Work Order Creation: Customer requests arrive via phone (manual entry), case conversion, scheduled PM from contracts, or customer self-service portal → Work Order is created.

Customer Request
→
Work Order Created
→
Dispatch Board
→
Assign Tech
→
Push to Mobile
→
Tech Accepts
Travel to Site
→
GPS Check-in
→
Perform Work
→
Log Time/Parts
→
Customer Signature
→
Complete WO

Billing: Completed work orders sync to NetSuite. T&M jobs generate an Invoice, contract work requires no invoice, and warranty jobs create a warranty claim.

NextService Dispatch Board

NextService â€ē Dispatch Board

The Dispatch Board is a visual Gantt-style interface for scheduling and managing technician assignments.

Dispatch Board Features

Feature Description
Unassigned Queue Left panel showing work orders needing assignment
Resource Calendar Day/week view of technician schedules
Drag-and-Drop Drag work orders to technician time slots
Color Coding Status colors (unassigned, scheduled, in progress, complete)
Skill Filtering Show only techs with required skills
Territory View Filter by geographic service area
Map View Google Maps showing job locations and tech positions

Scheduling Best Practices

💡 Dispatcher Tips
  • Morning huddle: Review unassigned queue at day start
  • Skill match first: Ensure tech has required certifications
  • Geographic clustering: Group nearby jobs to minimize travel
  • Buffer time: Add 15-30 min between jobs for travel/overrun
  • SLA monitoring: Watch response time countdown on urgent jobs
  • Truck stock check: Verify tech has required parts before dispatch

NextService Mobile App

Technicians use the NextService mobile app (iOS/Android) for all field operations.

Mobile App Workflow

Start of Day:

Open App
→
View Today's Jobs
→
Check Truck Stock

Job Execution:

Select Job
→
Start Travel
→
GPS Navigation
→
Arrive (GPS Check-in)
→
View Job Details
→
View Equipment History
→
Perform Work

Job Completion:

Add Parts Used
→
Log Labor Time
→
Take Photos
→
Add Notes
→
Customer Signature
→
Complete & Auto-sync

Mobile App Capabilities

Feature Description Syncs To
Job Queue Today's assigned work orders Real-time from dispatch
Navigation Turn-by-turn to customer site Google/Apple Maps
Check-in/Out GPS timestamp on arrival/departure Work Order timestamps
Equipment History View past service on this unit Equipment record
Parts Consumption Scan barcode or select part Inventory adjustment
Time Entry Start/stop timer or manual entry Time record in NetSuite
Photos Before/after, damage documentation File cabinet attachment
Signature Customer signs on screen PDF attachment
Offline Mode Works without connectivity Syncs when online

Offline Mode

⚠ī¸ Offline Considerations

NextService caches data for offline use, but plan for these scenarios:

  • Pre-download: Ensure techs sync before entering dead zones
  • Conflict resolution: If dispatcher changes job while tech offline, sync resolves on reconnect
  • Photo uploads: Large photos queue until strong connection
  • New jobs: Cannot receive new dispatches while offline

Equipment & Installed Base

NextService â€ē Equipment â€ē New Equipment

Track customer equipment (installed base) for warranty, service history, and PM scheduling.

Equipment Record Fields

Field Description
Customer Link to NetSuite customer record
Location Site address (from customer addresses)
Item NetSuite inventory item (product sold)
Serial Number Unique unit identifier
Install Date When equipment was installed
Warranty End Warranty expiration date
Service Contract Link to active contract covering this unit
PM Schedule Preventive maintenance frequency
Service History Sublist of all work orders on this unit

Equipment Lifecycle

Sales Order
→
Ship to Customer
→
Create Equipment Record
→
Installation WO
→
Warranty Period
PM Visits
↔
Break/Fix Service
→
Warranty Expires
→
Renew Contract or T&M
→
End of Life / Decommission

Service Contracts

NextService â€ē Contracts â€ē New Contract

Service contracts define coverage terms, SLAs, and billing for ongoing service relationships.

Contract Types

Type Coverage Billing SLA
Warranty Parts & labor (defects) Included in sale Best effort
Extended Warranty Parts & labor (all failures) Upfront or monthly Defined response
Maintenance Scheduled PM visits Annual/quarterly Scheduled windows
Full Service PM + break/fix + parts Monthly subscription 4-hour response
Managed Service Full operational responsibility Monthly fixed fee Uptime guarantee

Contract-to-Work Order Flow

A service contract contains the covered equipment list, PM schedule, and SLA terms. Work orders are triggered in two ways:

  • Scheduled PM Due: Auto-creates a PM Work Order → No customer invoice (covered by contract)
  • Customer Reports Issue: System checks contract coverage → If covered, creates a Contract WO (no invoice); if not covered, creates a Billable WO → Invoice customer

FSM Accounting Overview

Field service accounting is complex because it involves multiple revenue streams, cost types, and timing considerations. Proper FSM accounting ensures accurate job costing, appropriate revenue recognition, and meaningful profitability analysis.

đŸŽ¯ Consultant Insight: FSM Accounting Complexity

FSM accounting is often underestimated. Unlike simple product sales, field service involves:

  • Mixed billing models: Same customer may have contract work, T&M, and warranty on one visit
  • Real-time cost capture: Labor and parts consumed in the field must flow to GL immediately
  • Deferred revenue: Prepaid contracts require monthly recognition
  • WIP tracking: Multi-day jobs need work-in-progress accounting
  • Warranty reserves: Accrued warranty obligations for equipment sold

Get the accounting structure right before go-live--retrofitting is painful.

ℹī¸ NetSuite + NextService GL Integration

NextService creates native NetSuite transactions for all financial events:

  • Work Order Completion: Generates Invoice or Credit Memo in NetSuite
  • Parts Consumption: Creates Inventory Adjustment or Item Fulfillment
  • Time Entry: Posts to NetSuite Time records for payroll/job costing
  • Contract Billing: Uses NetSuite's billing schedules for recurring invoices

Navigation: NextService → Settings → GL Mapping to configure account assignments.

FSM Chart of Accounts

A well-designed COA for FSM operations enables job costing, service line profitability, and proper revenue/expense matching.

Recommended FSM Account Structure

FSM CHART OF ACCOUNTS
═══════════════════════════════════════════════════════════════

REVENUE ACCOUNTS (4xxx)
├── 4100 Service Revenue
│   ├── 4110 T&M Labor Revenue
│   ├── 4120 T&M Parts Revenue
│   ├── 4130 Flat Rate Service Revenue
│   ├── 4140 Installation Revenue
│   └── 4150 Emergency/After-Hours Revenue
│
├── 4200 Contract Revenue
│   ├── 4210 Maintenance Contract Revenue
│   ├── 4220 Full Service Contract Revenue
│   ├── 4230 Managed Services Revenue
│   └── 4240 Extended Warranty Revenue
│
├── 4300 Other Service Revenue
│   ├── 4310 Travel/Trip Charges
│   ├── 4320 Diagnostic Fees
│   └── 4330 Training Revenue
│
└── 4900 Contra Revenue
    ├── 4910 Service Discounts
    ├── 4920 Contract Adjustments
    └── 4930 Warranty Allowances

COST OF SERVICES (5xxx)
├── 5100 Direct Labor Cost
│   ├── 5110 Technician Wages
│   ├── 5120 Technician Benefits
│   ├── 5130 Overtime Premium
│   └── 5140 Contractor/Subcontractor Labor
│
├── 5200 Parts & Materials Cost
│   ├── 5210 Parts Consumed - Billable
│   ├── 5220 Parts Consumed - Warranty
│   ├── 5230 Parts Consumed - Contract
│   └── 5240 Consumables & Supplies
│
├── 5300 Direct Service Costs
│   ├── 5310 Vehicle Fuel
│   ├── 5320 Vehicle Maintenance
│   ├── 5330 Tools & Equipment
│   └── 5340 Subcontractor Services
│
└── 5400 Warranty Costs
    ├── 5410 Warranty Labor Cost
    ├── 5420 Warranty Parts Cost
    └── 5430 Warranty Reserve Adjustment

DEFERRED REVENUE (2xxx Liabilities)
├── 2400 Deferred Service Revenue
│   ├── 2410 Deferred Contract Revenue
│   ├── 2420 Deferred Warranty Revenue
│   └── 2430 Customer Deposits - Service
│
└── 2500 Warranty Obligations
    ├── 2510 Warranty Reserve - Current
    └── 2520 Warranty Reserve - Long-term

WORK IN PROGRESS (1xxx Assets)
├── 1600 Service WIP
│   ├── 1610 WIP - Labor
│   ├── 1620 WIP - Parts
│   └── 1630 WIP - Subcontractor

Account Mapping by Transaction Type

Transaction Debit Credit
T&M Invoice - Labor Accounts Receivable 4110 T&M Labor Revenue
T&M Invoice - Parts Accounts Receivable 4120 T&M Parts Revenue
Parts Consumed (Billable) 5210 Parts Consumed - Billable Inventory
Contract Prepayment Received Cash 2410 Deferred Contract Revenue
Monthly Contract Recognition 2410 Deferred Contract Revenue 4210 Maintenance Contract Revenue
Warranty Work Performed 5410 Warranty Labor + 5420 Warranty Parts Payroll Liability + Inventory
Warranty Reserve Release 2510 Warranty Reserve 5430 Warranty Reserve Adjustment

Labor Costing

Accurate labor costing is critical for FSM profitability. Labor costs include not just wages but also burden (benefits, taxes) and must be allocated correctly to jobs.

Labor Rate Components

TECHNICIAN LABOR RATE BUILDUP
═══════════════════════════════════════════════════════════════

EXAMPLE: Senior HVAC Technician - John Smith
──────────────────────────────────────────────────────────────

BASE COMPENSATION
├── Hourly Wage:                          $35.00/hr
├── Benefits (30% of wages):              $10.50/hr
├── Payroll Taxes (7.65% FICA + FUTA):     $3.00/hr
└── Workers Comp (5%):                     $1.75/hr
                                          ─────────
    FULLY BURDENED LABOR COST:            $50.25/hr

RATE VARIATIONS
├── Regular Time (M-F 8am-5pm):           $50.25/hr
├── Overtime (1.5x base wage):            $67.75/hr
│   └── Calculation: ($35 x 1.5) + $10.50 + $3.00 + $1.75
├── Double Time (holidays):               $85.25/hr
│   └── Calculation: ($35 x 2.0) + $10.50 + $3.00 + $1.75
└── On-Call Premium:                      $15.00/hr (standby)

BILLABLE RATES (customer-facing)
├── Standard Rate:                        $125.00/hr
├── After-Hours Rate:                     $175.00/hr
├── Emergency Rate:                       $200.00/hr
└── Contract Rate (discounted):           $100.00/hr

LABOR MARGIN ANALYSIS
├── Standard: $125 - $50.25 =             $74.75 (59.8% margin)
├── After-Hours: $175 - $67.75 =          $107.25 (61.3% margin)
├── Emergency: $200 - $85.25 =            $114.75 (57.4% margin)
└── Contract: $100 - $50.25 =             $49.75 (49.8% margin)

Labor Time Tracking

Time Category Billable? Cost Treatment Example
Direct Work Time Yes Job Cost - Direct Labor Repairing equipment
Travel Time Sometimes Job Cost or Overhead Driving to customer site
Diagnostic Time Yes (usually) Job Cost - Direct Labor Troubleshooting issue
Documentation Time No (usually) Overhead Writing service report
Training Time No Overhead Certification courses
Warranty Work No Warranty Cost Covered repair
Contract Work Covered Contract Cost Pool PM under contract

Labor Journal Entries

LABOR ACCOUNTING EXAMPLES
═══════════════════════════════════════════════════════════════

EXAMPLE 1: T&M Service Call (4 hours regular)
──────────────────────────────────────────────────────────────
When work performed:
   DR  5110 Technician Wages              $140.00
   DR  5120 Technician Benefits            $42.00
       CR  2100 Wages Payable                      $140.00
       CR  2150 Benefits Payable                    $42.00
   (To record labor cost on WO-1042)

When invoiced to customer:
   DR  1200 Accounts Receivable           $500.00
       CR  4110 T&M Labor Revenue                  $500.00
   (To record billable labor at $125/hr x 4 hrs)

EXAMPLE 2: Contract PM Visit (2 hours)
──────────────────────────────────────────────────────────────
When work performed:
   DR  5230 Parts Consumed - Contract      $45.00
   DR  5110 Technician Wages              $70.00
   DR  5120 Technician Benefits           $21.00
       CR  1400 Inventory                           $45.00
       CR  2100 Wages Payable                       $70.00
       CR  2150 Benefits Payable                    $21.00
   (To record cost of contract service - no customer invoice)

EXAMPLE 3: Warranty Repair (3 hours + parts)
──────────────────────────────────────────────────────────────
When work performed:
   DR  5410 Warranty Labor Cost          $150.75
   DR  5420 Warranty Parts Cost          $275.00
       CR  2100 Wages Payable                      $105.00
       CR  2150 Benefits Payable                    $45.75
       CR  1400 Inventory                          $275.00
   (To record warranty service cost - no customer invoice)

Release warranty reserve:
   DR  2510 Warranty Reserve             $425.75
       CR  5430 Warranty Reserve Adjustment        $425.75
   (To release reserve for warranty claim)

Parts & Inventory Accounting

FSM inventory flows differ from standard sales because parts are consumed in the field, often from technician truck stock, and may be billable, warranty, or contract-covered.

Truck Stock Management

TRUCK STOCK INVENTORY FLOW
═══════════════════════════════════════════════════════════════

CENTRAL WAREHOUSE                    TECHNICIAN TRUCKS
┌─────────────────────┐              ┌─────────────────────┐
│ Main Inventory      │              │ John's Truck (Loc)  │
│                     │  Transfer    │                     │
│ Part: Compressor    │─────────────▶│ Part: Compressor    │
│ Qty: 50             │   -2         │ Qty: 2              │
│ Value: $12,500      │              │ Value: $500         │
└─────────────────────┘              └─────────────────────┘
                                              │
                                              │ Consume on
                                              │ Work Order
                                              ▼
                                     ┌─────────────────────┐
                                     │ WO-1042 (Customer)  │
                                     │                     │
                                     │ Part: Compressor    │
                                     │ Qty: 1              │
                                     │ Cost: $250          │
                                     │ Billable: Yes       │
                                     └─────────────────────┘

LOCATION HIERARCHY:
├── Warehouse: Central (default receiving)
├── Location: Truck-John (linked to employee)
├── Location: Truck-Maria (linked to employee)
├── Location: Truck-Tom (linked to employee)
└── Location: Returns-Defective (for warranty parts)

Parts Consumption Scenarios

Scenario Cost Account Revenue Account Markup
T&M - Billable Parts 5210 Parts Consumed - Billable 4120 T&M Parts Revenue Cost + 50-100%
Contract - Covered Parts 5230 Parts Consumed - Contract None (contract revenue) N/A
Warranty - Covered Parts 5420 Warranty Parts Cost None (warranty claim) N/A
Warranty - Recovery Reduce 5420 or credit COGS Vendor credit/reimbursement At cost
Consumables 5240 Consumables & Supplies Often included in labor rate N/A

Parts Journal Entries

PARTS CONSUMPTION JOURNAL ENTRIES
═══════════════════════════════════════════════════════════════

EXAMPLE 1: Billable Part ($250 cost, $450 customer price)
──────────────────────────────────────────────────────────────
When consumed from truck stock:
   DR  5210 Parts Consumed - Billable     $250.00
       CR  1400 Inventory (Truck-John)             $250.00

When invoiced:
   DR  1200 Accounts Receivable           $450.00
       CR  4120 T&M Parts Revenue                  $450.00

Gross Profit on Part: $200 (44.4% margin)


EXAMPLE 2: Contract-Covered Part ($150 cost, no charge)
──────────────────────────────────────────────────────────────
When consumed:
   DR  5230 Parts Consumed - Contract     $150.00
       CR  1400 Inventory (Truck-Maria)            $150.00

No invoice (covered by prepaid contract)


EXAMPLE 3: Warranty Part with Vendor Recovery
──────────────────────────────────────────────────────────────
When consumed for warranty repair:
   DR  5420 Warranty Parts Cost           $275.00
       CR  1400 Inventory (Truck-John)             $275.00

When vendor credit received:
   DR  2000 Accounts Payable              $275.00
       CR  5420 Warranty Parts Cost                $275.00
   (Net zero cost for valid warranty claim)

Service Contract Revenue Recognition

Prepaid service contracts must be recognized over the contract period using an appropriate method--typically straight-line for maintenance contracts or as services are delivered for consumption-based models.

Revenue Recognition Methods

Method When to Use Example
Straight-Line Services delivered evenly over time Annual maintenance contract: 1/12 per month
Per-Visit Specified number of visits included 4 PM visits/year: 25% per visit
Consumption-Based Usage determines delivery Prepaid service hours: $ per hour used
Milestone Deliverables define progress Installation project: % complete

Contract Revenue Recognition Example

ANNUAL MAINTENANCE CONTRACT - REVENUE RECOGNITION
═══════════════════════════════════════════════════════════════

Contract: SC-2025-0042
Customer: Midwest Manufacturing Co.
Annual Value: $48,000 (prepaid January 1)
Term: 12 months
Recognition: Straight-line monthly

INITIAL RECEIPT (January 1, 2025)
──────────────────────────────────────────────────────────────
   DR  1000 Cash                        $48,000.00
       CR  2410 Deferred Contract Revenue          $48,000.00
   (To record prepayment for annual service contract)


MONTHLY RECOGNITION (Each Month-End)
──────────────────────────────────────────────────────────────
   DR  2410 Deferred Contract Revenue    $4,000.00
       CR  4210 Maintenance Contract Revenue        $4,000.00
   (To recognize 1/12 of annual contract value)


BALANCE SHEET PRESENTATION (After June 30)
──────────────────────────────────────────────────────────────
Deferred Contract Revenue:
├── Recognized (Jan-Jun):               $24,000 → 4210 Revenue
└── Remaining (Jul-Dec):                $24,000 → 2410 Liability

Income Statement (6 months):
├── Contract Revenue:                   $24,000
├── Contract Costs Incurred:           ($12,500) → 5xxx
└── Contract Gross Profit:              $11,500 (47.9% margin)

ASC 606 Considerations for FSM

⚠ī¸ Revenue Recognition Complexity

Under ASC 606, service contracts may contain multiple performance obligations:

  • Stand-ready obligation: Availability/response time commitment
  • Distinct PM visits: Each scheduled maintenance may be separate PO
  • Parts coverage: May be separate performance obligation
  • Training included: Distinct if customer can benefit separately

Work with your auditors to determine if your contracts require SSP allocation across multiple obligations. Many maintenance contracts qualify for practical expedients allowing straight-line recognition.

Warranty Accounting

Warranty obligations require accrual at the time of sale based on estimated future claims. As warranty work is performed, costs are charged against the reserve.

Warranty Reserve Calculation

WARRANTY RESERVE METHODOLOGY
═══════════════════════════════════════════════════════════════

STEP 1: Analyze Historical Warranty Claims
──────────────────────────────────────────────────────────────
Product: Industrial HVAC Unit Model 5000
Warranty Period: 3 years parts & labor

Historical Data (per 100 units sold):
├── Year 1 Claims: 8 units (8%)
│   └── Avg Claim Cost: $425
├── Year 2 Claims: 12 units (12%)
│   └── Avg Claim Cost: $550
├── Year 3 Claims: 15 units (15%)
│   └── Avg Claim Cost: $625
└── Total Expected Claims: 35%
    └── Weighted Avg Cost: $541

STEP 2: Calculate Reserve per Unit Sold
──────────────────────────────────────────────────────────────
Expected Warranty Cost per Unit:
├── Year 1: 8% x $425 =                   $34.00
├── Year 2: 12% x $550 =                  $66.00
├── Year 3: 15% x $625 =                  $93.75
└── Total Reserve per Unit:              $193.75

STEP 3: Apply to Current Period Sales
──────────────────────────────────────────────────────────────
Q4 2025 Sales: 50 units @ $8,500 each
Total Sales Revenue: $425,000

Warranty Reserve Accrual:
50 units x $193.75 = $9,687.50

Journal Entry at Sale:
   DR  5400 Warranty Expense             $9,687.50
       CR  2510 Warranty Reserve - Current         $6,500.00
       CR  2520 Warranty Reserve - Long-term       $3,187.50

Warranty Reserve Roll-Forward

WARRANTY RESERVE RECONCILIATION - Q4 2025
═══════════════════════════════════════════════════════════════

Beginning Balance (Oct 1):              $45,250.00
├── Current Portion:                    $18,500.00
└── Long-term Portion:                  $26,750.00

Add: New Accruals (Q4 sales)            $9,687.50

Less: Claims Paid/Incurred
├── October Claims:                    ($3,425.00)
├── November Claims:                   ($4,150.00)
└── December Claims:                   ($2,875.00)
    Subtotal Claims:                  ($10,450.00)

Adjustments:
├── Expired Warranties (release):      ($2,100.00)
└── Reserve True-up (increase):         $1,500.00
                                       ───────────
Ending Balance (Dec 31):                $43,887.50
├── Current Portion:                    $17,200.00
└── Long-term Portion:                  $26,687.50

Claims Paid Journal Entry Example:
   DR  2510 Warranty Reserve             $3,425.00
       CR  5410 Warranty Labor Cost                $1,800.00
       CR  5420 Warranty Parts Cost                $1,625.00
   (Actual warranty claim - already expensed, now reduce reserve)
💡 Warranty Reserve Best Practices
  • Track by product line: Different products have different warranty profiles
  • Update estimates annually: Refine based on actual claim experience
  • Separate current/long-term: Proper balance sheet classification
  • Document methodology: Auditors will ask for support
  • Link to equipment records: Track claims against serial numbers

Work-in-Progress (WIP) for Service Jobs

Multi-day or multi-visit service jobs require WIP tracking to properly match costs with revenue recognition, especially for fixed-price projects.

Service WIP Scenarios

Scenario WIP Required? Revenue Recognition
Same-day T&M No Invoice on completion
Multi-day T&M Optional Invoice daily or on completion
Fixed-price Installation Yes % complete or on completion
Project-based Service Yes Milestone or % complete
Month-end Unbilled Accrual Accrue unbilled revenue

WIP Journal Entry Flow

SERVICE WIP ACCOUNTING EXAMPLE
═══════════════════════════════════════════════════════════════

PROJECT: HVAC System Installation
Customer: TechStart Inc.
Fixed Price: $25,000
Estimated Cost: $18,000 (labor $12,000 + parts $6,000)
Duration: 3 days

DAY 1 - Costs Incurred (no billing)
──────────────────────────────────────────────────────────────
Labor (8 hrs x $50.25 burden):
   DR  1610 WIP - Labor                  $402.00
       CR  2100 Wages Payable                      $280.00
       CR  2150 Benefits Payable                   $122.00

Parts installed:
   DR  1620 WIP - Parts                $2,000.00
       CR  1400 Inventory                        $2,000.00

DAY 2 - Additional Costs
──────────────────────────────────────────────────────────────
Labor (10 hrs including OT):
   DR  1610 WIP - Labor                  $536.00
       CR  2100 Wages Payable                      $385.00
       CR  2150 Benefits Payable                   $151.00

Parts installed:
   DR  1620 WIP - Parts                $3,500.00
       CR  1400 Inventory                        $3,500.00

DAY 3 - Project Complete & Billed
──────────────────────────────────────────────────────────────
Final labor (6 hrs):
   DR  1610 WIP - Labor                  $301.50
       CR  2100 Wages Payable                      $210.00
       CR  2150 Benefits Payable                    $91.50

Transfer WIP to COGS on completion:
   DR  5110 Technician Wages           $1,239.50
   DR  5210 Parts Consumed - Billable  $5,500.00
       CR  1610 WIP - Labor                      $1,239.50
       CR  1620 WIP - Parts                      $5,500.00

Invoice customer:
   DR  1200 Accounts Receivable       $25,000.00
       CR  4140 Installation Revenue            $25,000.00

PROJECT PROFITABILITY:
Revenue:                               $25,000.00
Cost of Services:                     ($6,739.50)
Gross Profit:                         $18,260.50 (73.0% margin)

FSM Financial Reporting

FSM-specific reports enable management to monitor service profitability, technician productivity, contract performance, and warranty exposure.

Key FSM Metrics & Reports

Report Key Metrics Frequency
Service P&L by Type Revenue, COGS, margin by service type Monthly
Technician Productivity Billable %, revenue per tech, jobs/day Weekly
Contract Profitability Revenue vs cost per contract Monthly
Warranty Claims Analysis Claims by product, cost trends, reserve adequacy Monthly
Deferred Revenue Roll Beginning, additions, recognition, ending Monthly
First-Time Fix Rate % jobs completed on first visit Weekly
Parts Margin Analysis Cost vs billing, margin by category Monthly

Service P&L Report Structure

SERVICE OPERATIONS P&L - NOVEMBER 2025
═══════════════════════════════════════════════════════════════

                          T&M        Contract    Warranty     TOTAL
                       ──────────   ──────────   ──────────   ──────────
REVENUE
  Labor Revenue        $125,400                               $125,400
  Parts Revenue         $67,200                                $67,200
  Contract Revenue                   $48,000                   $48,000
  Trip Charges          $12,500                                $12,500
                       ──────────   ──────────   ──────────   ──────────
  Total Revenue        $205,100     $48,000          $0      $253,100

COST OF SERVICES
  Technician Labor     ($52,100)   ($18,400)   ($12,300)    ($82,800)
  Parts Consumed       ($33,600)    ($8,200)   ($15,400)    ($57,200)
  Subcontractors        ($4,500)    ($1,200)                 ($5,700)
  Vehicle Costs         ($8,400)    ($3,600)    ($1,800)    ($13,800)
                       ──────────   ──────────   ──────────   ──────────
  Total COS            ($98,600)   ($31,400)   ($29,500)   ($159,500)

GROSS PROFIT           $106,500     $16,600    ($29,500)     $93,600
  Margin %               51.9%        34.6%        N/A         37.0%

WARRANTY ANALYSIS
  Warranty Reserve Accrual                                    $18,500
  Warranty Claims Incurred                                   ($29,500)
  Net Warranty Impact                                        ($11,000)
  Reserve Balance                                             $43,887

Technician Productivity Report

TECHNICIAN PRODUCTIVITY - WEEK OF DEC 15, 2025
═══════════════════════════════════════════════════════════════

Technician    Jobs   Billable  Total   Bill%   Revenue   Rev/Job
              Comp    Hours    Hours
──────────────────────────────────────────────────────────────
John S.        12      32.0    40.0    80.0%   $4,200    $350
Maria R.       14      36.5    40.0    91.3%   $5,100    $364
Tom K.         10      28.0    40.0    70.0%   $3,400    $340
Sarah L.       11      30.0    40.0    75.0%   $3,850    $350
Mike P.         8      24.0    40.0    60.0%   $2,600    $325
──────────────────────────────────────────────────────────────
TEAM TOTAL     55     150.5   200.0    75.3%  $19,150    $348

TARGET: 75% billable utilization, $350 revenue per job
STATUS: On target for utilization, slightly under on revenue

NON-BILLABLE BREAKDOWN:
├── Travel:           22.0 hrs (11.0%)
├── Admin/Docs:       12.0 hrs (6.0%)
├── Training:          8.0 hrs (4.0%)
├── Warranty Work:     5.5 hrs (2.8%)
└── Callbacks:         2.0 hrs (1.0%)

Industry-Specific FSM Considerations

👔 Professional Services
Professional Services Consideration
Manufacturing FSM:
  • Equipment complexity: Multi-level BOMs for industrial equipment service
  • Planned maintenance: PM schedules tied to operating hours or production cycles
  • Spare parts planning: Critical spares inventory at customer sites
  • Uptime SLAs: Production downtime costs drive response requirements
👔 Professional Services
Professional Services Consideration
HVAC/Mechanical Services:
  • Seasonal demand: Heating/cooling peaks require flexible staffing
  • Refrigerant tracking: EPA compliance for refrigerant handling
  • Certification requirements: Trade licenses by jurisdiction
  • Emergency service: 24/7 availability with premium billing
👔 Professional Services
Professional Services Consideration
Technology/IT Services:
  • Remote + on-site: Hybrid service delivery model
  • Asset management: Hardware lifecycle and refresh tracking
  • Managed services: Per-device or per-user pricing models
  • Security compliance: Access controls and audit trails
👔 Professional Services
Professional Services Consideration
Healthcare/Medical Equipment:
  • Regulatory compliance: FDA, HIPAA requirements for medical devices
  • Calibration schedules: Mandatory calibration with documentation
  • PM documentation: Detailed records for accreditation
  • Emergency response: Life-safety equipment priority

FSM Implementation Checklist