Data Flow Map Overview
Comprehensive view of how data flows through NetSuite - from inventory and GL to revenue recognition, currency, and intercompany transactions.
In This Section
| Flow Map | What It Shows |
|---|---|
| Inventory Flow Map | All physical inventory movements |
| GL Flow Map | All financial/accounting entries |
| Transaction Linkage | How transactions connect via createdfrom |
| Cash Flow Map | Money movement - inflows and outflows |
| Intercompany Flow | Cross-subsidiary transactions and eliminations |
| Revenue Flow Map | Revenue recognition, deferred revenue, ASC 606 |
Data Conversion Maps
| Conversion Map | What It Shows |
|---|---|
| Currency Conversion | Multi-currency, revaluation, FX gains/losses |
| Unit of Measurement (UoM) | UOM conversions across transactions |
Why Data Flow Matters
Understanding the big picture helps you:
- Debug issues - Trace where inventory went or why GL is off
- Plan integrations - Know which transactions affect what
- Train users - Show how everything connects
- Design reports - Understand data relationships
- Audit transactions - Follow the complete trail
Master Data Flow Diagram
NETSUITE DATA FLOW OVERVIEW
═══════════════════════════════════════════════════════════════════════════════
NETSUITE CORE
┌─────────────────────────────────────────────────────────────────────────────┐
│ │
│ ┌───────────┐ ┌───────────┐ ┌───────────┐ ┌───────────┐ ┌───────────┐│
│ │ INVENTORY │ │ GL │ │ CASH │ │ REVENUE │ │ CURRENCY ││
│ │ LEDGER │◄─┤ LEDGER │◄─┤ LEDGER │◄─┤ SCHEDULE │◄─┤ RATES ││
│ │ │ │ │ │ │ │ │ │ ││
│ │ Qty/Item │ │ $/Account │ │ Bank Bal │ │ Deferred │ │ FX Impact ││
│ │ Location │ │ Period │ │ Deposits │ │ Recognized│ │ Reval ││
│ └───────────┘ └───────────┘ └───────────┘ └───────────┘ └───────────┘│
│ ▲ ▲ ▲ ▲ ▲ │
└────────┼──────────────┼──────────────┼──────────────┼──────────────┼───────┘
│ │ │ │ │
└──────────────┴──────────────┴──────┬───────┴──────────────┘
│
│
┌─────────────────────────────────────────────┴───────────────────────────────┐
│ TRANSACTIONS │
│ │
│ ┌─────────┐ ┌─────────┐ ┌─────────┐ ┌─────────┐ ┌─────────┐ ┌───────┐│
│ │ SALES │ │PURCHASE │ │MANUFACT │ │INVENTORY│ │FINANCIAL│ │ BANK ││
│ │ SO→INV │ │ PO→Bill │ │ WO→Comp │ │ Adjust │ │ Journal │ │Deposit││
│ │ Payment │ │ Payment │ │ Assembly│ │ Transfer│ │ Interco │ │Payment││
│ │ Returns │ │ Returns │ │ │ │ Count │ │ Rev Rec │ │Reconc ││
│ └─────────┘ └─────────┘ └─────────┘ └─────────┘ └─────────┘ └───────┘│
│ │
└─────────────────────────────────────────────────────────────────────────────┘
│
┌───────────────────────┼───────────────────────┐
│ │ │
▼ ▼ ▼
┌─────────────────┐ ┌─────────────────┐ ┌─────────────────┐
│ INTERCOMPANY │ │ CURRENCY │ │ REVENUE │
│ │ │ │ │ │
│ Linked Trans │ │ FX Conversion │ │ Recognition │
│ Eliminations │ │ Revaluation │ │ Schedules │
│ Consolidation │ │ Gain/Loss │ │ Deferred │
└─────────────────┘ └─────────────────┘ └─────────────────┘
Transaction Impact Summary
Which Transactions Affect Inventory?
| Transaction | Inventory Impact | Direction |
|---|---|---|
| Item Fulfillment | Yes | OUT |
| Cash Sale | Yes | OUT |
| Invoice (Direct) | Yes | OUT |
| Item Receipt | Yes | IN |
| Vendor Bill (Direct) | Yes | IN |
| Customer Return | Yes | IN |
| Vendor Return | Yes | OUT |
| Work Order Issue | Yes | OUT (components) |
| Work Order Completion | Yes | IN (finished goods) |
| Assembly Build | Yes | IN/OUT |
| Inventory Adjustment | Yes | IN or OUT |
| Inventory Transfer | Yes | Move between locations |
| Transfer Order (Fulfill) | Yes | OUT from source |
| Transfer Order (Receive) | Yes | IN to destination |
Which Transactions Affect GL?
| Transaction | GL Impact | Creates Liability/Asset |
|---|---|---|
| Invoice | Yes | A/R (Asset) |
| Cash Sale | Yes | Cash (Asset) |
| Customer Payment | Yes | Clears A/R |
| Customer Refund | Yes | Reduces Cash |
| Vendor Bill | Yes | A/P (Liability) |
| Item Receipt | Yes | IRNB (Liability) |
| Vendor Payment | Yes | Clears A/P |
| Vendor Refund | Yes | Increases Cash |
| Inventory Adjustment | Yes | Adjustment account |
| Deposit | Yes | Bank account |
| All Manufacturing | Yes | WIP, Variances |
| Expense Report | Yes | A/P Employee (Liability) |
| Expense Payment | Yes | Clears A/P Employee |
| Journal Entry | Yes | Per entry lines (any account) |
| Intercompany Journal | Yes | Balances across subsidiaries |
| Currency Revaluation | Yes | Unrealized FX Gain/Loss |
| Revenue Recognition | Yes | Deferred → Recognized |
Flow Map Quick Reference
Core Flows
| If You Need To... | Use This Map |
|---|---|
| Track physical inventory | Inventory Flow Map |
| Understand accounting entries | GL Flow Map |
| Find linked transactions | Transaction Linkage |
| Track money movement | Cash Flow Map |
Specialized Flows
| If You Need To... | Use This Map |
|---|---|
| Handle multi-subsidiary | Intercompany Flow |
| Understand rev rec | Revenue Flow Map |
Data Conversions
| If You Need To... | Use This Map |
|---|---|
| Handle foreign currency | Currency Conversion |
| Work with multiple units | UoM Conversion |
Next Steps
Start with the most relevant flow for your needs:
- Inventory Issues? → Inventory Flow Map
- GL/Accounting Questions? → GL Flow Map
- Need Transaction Links? → Transaction Linkage
- Cash Position? → Cash Flow Map
- Multi-Subsidiary? → Intercompany Flow
- Revenue Recognition? → Revenue Flow Map
- Multi-Currency? → Currency Conversion
- Unit Conversions? → UoM Conversion