89 results total
Browse practical NetSuite answers in CSV Import & Data Migration, filtered by topic, audience, and difficulty.
Answer
To import transactions when auto-generated numbers are active, provide a unique identifier column in your import file. This can be a 'dummy' column (whose values may be imported…
Read answer→Answer
To import historical trial balance data for NetSuite OneWorld elimination accounts, create non-A/R or A/P intercompany accounts for the initial import. Subsequently, reclassify balances from these temporary accounts…
Read answer→Answer
While direct import of vendor bill expenses through a single file is not supported via the standard import process, NetSuite allows this functionality using the multiple files upload…
Read answer→Answer
NetSuite does not support importing vendors and their associated contacts in a single file. To successfully import both, users must perform two separate imports: first for the vendor…
Read answer→Answer
The Single Inventory Worksheet CSV template is located in NetSuite under Transactions | Inventory | Adjust Inventory Worksheet | Import. This template facilitates bulk inventory adjustments, but it's…
Read answer→Answer
To make Excel use commas as CSV delimiters, adjust your Windows regional settings. Navigate to 'Administrative language settings' (via Control Panel or Settings app), then 'Additional Settings'. Set…
Read answer→Answer
For ongoing bank reconciliation in NetSuite, utilize native tools like 'Match Bank Data' and 'Reconcile Account Statement' to manage timing differences. In specific scenarios, such as data migration…
Read answer→Answer
Mass deleting transactions in NetSuite can be achieved through direct list editing for individual records or via SuiteScript for larger volumes. While in-line editing offers a straightforward approach,…
Read answer→Answer
To link multiple files to NetSuite records, upload them to the File Cabinet. Create custom hyperlink fields on the target record, then use a CSV import to populate…
Read answer→Answer
NetSuite's native mass update functionality does not directly support updating department or class segments on transactions. If the old segment will be inactivated, renaming is an option. Otherwise,…
Read answer→Answer
Migrate intercompany AP/AR balances using NetSuite's Advanced Intercompany Journal Entry. Ensure subsidiary and intercompany partner details are populated, and the 'Eliminate' box is checked. Separate P&L and Balance…
Read answer→Answer
To prevent NetSuite CSV imports from overwriting existing transaction lines, include a 'LineId' column in your CSV file. Leave this column empty for new lines and map it…
Read answer→No answers match those filters.
We use only optional tools to measure site usage and manage HubSpot forms. You can accept, reject, or choose category by category.
Optional tools are off by default. You can change your choice at any time.
Always on. These only remember your consent choice and support site security. No analytics or marketing tool runs in this category.