NetSuite Script and Workflow Inventory Worksheet
After a few years most NetSuite accounts hold dozens of scripts, workflows and bundles that nobody fully remembers. An inventory is the first step to cleaning them up, documenting them and knowing what a release might break.
| Name | Type | Record or purpose | Trigger or schedule | Owner | Runs per day | Average run time (min) | Daily run minutes | Risk | Documented | |
|---|---|---|---|---|---|---|---|---|---|---|
6 | ||||||||||
35 | ||||||||||
4 | ||||||||||
2 | ||||||||||
30 |
Fill from Customization, Scripting, Scripts and Customization, Workflow in your account. Run counts and times can come from the Script Execution Log or script deployment statistics. This is a planning aid and is not connected to your account.
Get help documenting NetSuite customizations
Optional: we can discuss an AI-assisted review of your scripts, workflows and bundles.
Optional. The tool and every export work without this. No spam.
How to use the inventory
Walk through the script list and workflow list in the Customization menu and enter one row per item. Add the owner, the trigger and an estimate of runs per day and average run time. Flag risk honestly: anything touching posting, inventory or approvals is at least Medium. Export to Excel and filter on Documented equal to No to find the biggest knowledge gaps first.
- Include bundles, not only your own scripts
- Capture the person who can explain the logic
- Flag undocumented items that change financial data
- Review the list each quarter
Reading the results
Daily run minutes help you see which automations consume the most processing time. A map/reduce job taking 35 minutes a day is not a problem on its own, but several heavy jobs scheduled in the same window can delay each other. Compare the totals to the schedule so heavy jobs do not all start at the same hour, and look at slow user events that run on every save.
Using it for release and upgrade planning
Before a NetSuite release, the inventory tells you which customizations to test in release preview. Items that touch work orders, assembly builds or inventory transactions deserve a regression check. Before a migration to another ERP, the same list becomes a scope document showing which logic must be rebuilt, replaced by standard features or retired.
Common mistakes
Listing only active scripts, ignoring workflows because they are point and click, and not recording the owner. Orphaned scripts keep running after their author has left. Another common issue is duplicate logic: a workflow and a script both setting the same field, with whichever runs last winning.
Frequently Asked Questions
Where do I find the list of scripts?
Use the Customization menu: Scripting, Scripts for script records and their deployments, and Workflow, Workflows for workflows. Saved searches on script and deployment records can also give a fuller export.
How do I get run times?
The Script Execution Log and the script deployment status pages show run history. For an estimate, sample a typical day and enter the average. Precision is less important than finding outliers.
What counts as high risk?
Anything that posts or edits financial or inventory records, drives approvals, or integrates with outside systems. Also rate undocumented logic higher because it is harder to fix when it breaks.
Should unused scripts be deleted?
Disable first, observe for a cycle such as a month-end, then remove. Keep the source in version control so you can restore it if needed.
If you need a faster way to document existing customizations, Netray can discuss an AI-assisted review of your scripts and workflows.
Related Tools
NetSuite SuiteScript Deployment Handover Template
A handover document for a SuiteScript customization: what it does, where it is deployed, dependencies, how to roll it back and who supports it.
NetSuiteNetSuite Sandbox and Release Change Log Worksheet
An editable log of NetSuite changes across sandbox, release preview and production, with test status and hours spent, exportable to Excel.
NetSuiteNetSuite Custom Record Design Spec Template
A design spec for a new NetSuite custom record type: purpose, fields, relationships, access and reporting, ready to approve before anyone builds it.
NetSuiteNetSuite User Access Request Form Template
A fill-in access request form for new, changed or removed NetSuite users, with role, subsidiary, segregation of duties review and approval lines.
More NetSuite tools
See all- NetSuite Saved Search Formula Generator
- NetSuite CSV Import Template Guide
- NetSuite Role Permission Matrix Worksheet
- NetSuite Inventory Costing Method Reference
- NetSuite Month End Close Checklist
- NetSuite License Cost Estimator
- NetSuite SuiteQL Transaction Query Generator
- NetSuite Transaction Type Codes Reference
- SuiteQL Query Generator
New to NetSuite? Start with the NetSuite guide and toolkit, or plan with NetSuite Cost Calculator, Training Path Builder, ERP Certification Study Planner.
Keep exploring
Free tools
- NetSuite Script Deployment Inventory WorksheetKeep an inventory of every SuiteScript and deployment with its owner, status and review date, and export it to Excel.
- SuiteScript Scheduled Script Run Count CalculatorEstimate total governance units, records per run, number of reschedules and total runtime for a scheduled script before you write it.
- NetSuite Script Deployment Fields and Status ReferenceWhat each field on a Script Deployment record does, which script types have it, and the setting to use for testing and for production.
ERP fixes and how-tos
- How to build a workflow in NetSuite with SuiteFlowStep-by-step guide to building a NetSuite SuiteFlow workflow: record type, trigger, states, transitions, actions, and why workflows silently do not fire.
- How NetSuite scheduled script queueing actually worksUnderstand why NetSuite Scheduled Scripts sit in Queued or Pending status, how account-level concurrency limits and deployment priority affect start time, and how to design self-rescheduling scripts that do not compound the queue.
- NetSuite Quality Management: Incoming Inspection and QuarantineNetSuite has no full QMS, but inventory status, workflows and custom records give incoming inspection, quarantine and NCR tracking. Setup steps and limits.
Runs with your ERP
- NetSuite Quality Management SuiteApp: inspections and nonconformanceWhat the NetSuite Quality Management SuiteApp does: inspection specs, queues, sampling and nonconformance workflows. Setup, pitfalls, alternatives and AI uses.
- BlackLine and Oracle NetSuite: Account Reconciliation ConnectorHow BlackLine pulls NetSuite balances, GL and bank transactions and saved searches for account reconciliation and matching, with setup steps and pitfalls.
- PlanetTogether APS with Oracle NetSuite: finite schedulingHow PlanetTogether APS connects to NetSuite: imports of work orders, BOMs, routings and items, and schedules written back. Setup, data flows and pitfalls.
AI on your ERP
- NetSuite Inventory and Demand Planning With AI That Checks Your Reorder LogicAI for NetSuite inventory and demand planning: review reorder points, safety stock, item demand plans and stockouts using SuiteQL on private infrastructure.
- AI for NetSuite Order to Cash: Find Where Every Order and Dollar Is StuckAI for the NetSuite order to cash cycle: sales orders, item fulfillment, invoicing and collections. Ask where an order is stuck and why cash is late.
Integrations
- How to use ChatGPT with Oracle NetSuiteConnect ChatGPT to Oracle NetSuite: custom GPT actions, exports versus live access, enterprise data controls, and when a private model is the safer choice.
- How to use Claude with Oracle NetSuiteUse Claude with Oracle NetSuite through MCP connectors, the Anthropic API, AWS Bedrock or Vertex, plus the on-prem alternative for controlled data.