Skip to main content

NetSuite Python Report Development

Welcome to the comprehensive documentation for NetSuite Python Report Development. This guide covers everything you need to know to develop, debug, and deploy Excel reports using Python, Pandas, XlsxWriter, and Pyodide within the NetSuite environment.

What This Section Covers​

Getting Started​

Everything you need to set up your development environment:

Development Guides​

In-depth guides for developing NetSuite reports:

Technical Reference​

Comprehensive reference materials:

Architecture Overview​

NetSuite Python reports follow this data flow:

┌─────────────────┐     ┌──────────────┐     ┌─────────────────┐     ┌──────────────┐
│  NetSuite SQL   │ ──► │  JavaScript  │ ──► │  Pyodide/Python │ ──► │  Excel File  │
│  (SuiteQL)      │     │  (JSON data) │     │  (pandas)       │     │  (download)  │
└─────────────────┘     └──────────────┘     └─────────────────┘     └──────────────┘

Key Components​

  1. Suitelet (JavaScript): Fetches data via SuiteQL, passes JSON to HTML template
  2. HTML Template: Contains Pyodide Python code for Excel generation
  3. Python (Pyodide): Processes data with pandas, generates Excel with xlsxwriter

Quick Start​

  1. Set up your environment - Follow the Windows Setup Guide
  2. Understand the workflow - Read the Development Guide
  3. Start developing - Use the Debug Cheatsheet as a quick reference
  4. Learn the tools - Reference the Pandas Guide and XlsxWriter Guide

Development Philosophy​

Key Principle: Always develop and debug Python code locally in Jupyter first, then port to Pyodide once working. This saves significant debugging time.

PhaseToolPurpose
Data ExtractionNetSuite Debug FilesGet real data structure
DevelopmentJupyter NotebookInteractive debugging
TestingLocal PythonVerify Excel output
IntegrationBrowser ConsoleDebug Pyodide issues
ProductionNetSuite SuiteletFinal deployment

Need Help?​