NetSuite: Import GL Detail
Description
Section titled “Description”Imports general ledger transaction-line detail from NetSuite over your NetSuite connection into a project table — the posting-level lines behind your balances, for reconciliation, drill-down, or a detailed P&L. Pick the connection, name a target table, and set the period and subsidiary; the step pulls the lines and writes them, with no SuiteQL to author or maintain.
This is one of the canned NetSuite import steps. Each runs on a shared read layer that refreshes the OAuth token, pages through large results, and retries transient errors for you, so a full-period pull comes back complete without hand-tuning. For period balances rather than lines, use NetSuite: Import Balances.
Configuration
Section titled “Configuration”| Field | Required | Notes |
|---|---|---|
| NetSuite Connection | Yes | The NetSuite connection to read through, filtered to connections of type NetSuite. |
| Target Table | Yes | The project table the transaction lines are written to. It is overwritten in full on every run. |
| Start Date | No | The earliest transaction date to include, YYYY-MM-DD, inclusive. Leave blank for no lower bound. |
| End Date | No | The latest transaction date to include, YYYY-MM-DD, inclusive. Leave blank for no upper bound. |
| Subsidiary | No | A NetSuite subsidiary internal ID to restrict the pull to one subsidiary. Leave blank for all subsidiaries. |
Related
Section titled “Related”- NetSuite Steps
- Import NetSuite Financials — step-by-step walkthrough
- Connect to NetSuite
- NetSuite REST Connector