Blog
358 articles about NetSuite, SuiteQL, AI, and software development.
Latest Posts
March 12, 2026 — I gave my virtual SuiteScript developer a real client integration task — build a RESTlet that accepts Shopify orders and creates sales orders in NetSuite. Here's a walkthrough of what it produced.
March 6, 2026 — Lightsail's pricing is built on predictability, and data transfer is the most common place that predictability breaks down. Here's what creates the risk and how to mitigate it.
March 3, 2026 — A system prompt that turns AI into a senior NetSuite finance consultant — handling configuration, accounting guidance, process design, and troubleshooting with native-first recommendations and compliance awareness.
Archived Posts
2026 (43 posts)
March 12, 2026 — I gave my virtual SuiteScript developer a real client integration task — build a RESTlet that accepts Shopify orders and creates sales orders in NetSuite. Here's a walkthrough of what it produced.
March 6, 2026 — Lightsail's pricing is built on predictability, and data transfer is the most common place that predictability breaks down. Here's what creates the risk and how to mitigate it.
March 3, 2026 — A system prompt that turns AI into a senior NetSuite finance consultant — handling configuration, accounting guidance, process design, and troubleshooting with native-first recommendations and compliance awareness.
March 2, 2026 — Every slash command, CLI flag, and keyboard shortcut in Claude Code, grouped from daily essentials to the hidden gems most developers never discover.
March 1, 2026 — I built an AI agent named SuiteStepBot and set it loose on Moltbook, a social network built exclusively for AI agents.
February 23, 2026 — I built a system prompt that transforms any major AI model into a production-ready SuiteScript developer — with governance awareness, security-first behavior, and native-first decision making.
February 20, 2026 — Lightsail's container service lets you deploy Docker containers without touching VPCs, IAM execution roles, or task definitions. Here's what it handles, where it has limits, and when it makes sense.
February 18, 2026 — How I turned nine independent prompts for website development into an orchestrated AI team — with a project manager agent, file-based communication, dependency mapping, and human checkpoints.
February 15, 2026 — How building a virtual team of 34 specialized AI agents creates a time dilation effect — compressing weeks of work into hours through parallelism, combinatorial workflows, and organizational compression.
February 13, 2026 — How I used prompt engineering to build a credible, ethical AI loss prevention consultant — with structured reasoning, hard ethical guardrails, and graceful degradation — in a couple of hours.
February 12, 2026 — Lightsail's built-in load balancer handles traffic distribution, health checks, and SSL termination at a flat monthly price. Here's when it's the right choice and where it has limits.
February 10, 2026 — Instead of deploying OpenClaw, I built a team of 34 specialized AI agents using Claude Code — trading always-on autonomy for on-demand leverage with structural security.
February 8, 2026 — A snapshot of what I'm working on, building, and watching as of February 2026.
February 7, 2026 — Mindfulness in AI isn't about slowing down for the sake of it — it's about being deliberate with a tool that's becoming part of how we all work.
February 6, 2026 — Lightsail's managed databases give you dedicated compute, automatic backups, and optional high availability at a flat monthly price, without the operational surface area of RDS.
February 4, 2026 — How I used a highly optimized prompt — with a 5-level certainty system, anti-hallucination safeguards, and live web research — to generate a verifiable ERP market intelligence report.
February 2, 2026 — Every NetSuite environment accumulates technical debt. The problem isn't carrying debt — it's not knowing how much you're carrying or where it's concentrated.
January 30, 2026 — The latest beta adds extensibility through a plugin architecture, data visualization with charts, clickable record links, and dozens of refinements.
January 28, 2026 — A follow-up exploring the practical realities of operating multiple NetSuite environments — the logistical, business, technical, and AI challenges.
January 28, 2026 — A professional prompt that transforms Claude into a senior PHP architect who generates complete, working automation scripts with proper error handling, security controls, and documentation.
January 27, 2026 — An exploration of functional, technical, and techno-functional roles in the NetSuite ecosystem — what the labels mean, how skills develop, and practical advice for building your career.
January 25, 2026 — A comprehensive guide to using AI for revenue recognition in NetSuite environments, covering contract intelligence, SSP estimation, anomaly detection, and implementation strategies.
January 24, 2026 — Why billing schedules only exist on Sales Orders in NetSuite, and four approaches for managing billing schedule assignment when your process starts with Estimates.
January 23, 2026 — The next beta release of SuiteQL Query Tool will include a comprehensive Plugin Architecture that allows developers to extend the tool's functionality without modifying the core script.
January 22, 2026 — ServiceNow has become a model for developer experience, workflow orchestration, and embedded AI. Here's what NetSuite could adopt from their playbook.
January 21, 2026 — As AI adoption accelerates in the NetSuite ecosystem, what's being sold as an "agent" isn't always what most of us mean when we talk about true, autonomous AI.
January 20, 2026 — Two native approaches for applying a single credit memo across multiple invoices in NetSuite, with guidance on when to use each.
January 19, 2026 — A comprehensive guide to recognizing when your organization might need multiple NetSuite instances, common business triggers, warning signs, and questions to ask before committing.
January 18, 2026 — Why talented NetSuite professionals leave, how role scope creep creates invisible pressure, and what organizations can do to improve retention before it's too late.
January 17, 2026 — Learn how to speed up complex tasks in Claude Code by using parallel sub-agents for research, codebase exploration, and multi-part analysis.
January 16, 2026 — A reusable AI prompt that transforms prospect research from hours of manual work into minutes of strategic analysis.
January 15, 2026 — A comparison of NetSuite's SuiteCloud Developer Assistant and general-purpose AI tools like Claude Code for SuiteScript and SDF development.
January 14, 2026 — A practical walkthrough of NetSuite's 3-way matching process, from enabling the right features to configuring variance accounts and approval workflows.
January 11, 2026 — A snapshot of what I'm working on, watching, and thinking about as we head into 2026.
January 10, 2026 — Introducing the Learning Edition of the SuiteQL Query Tool — a fully commented codebase for learning SuiteScript.
January 9, 2026 — Announcing a major upgrade to the SuiteQL Query Tool.
January 8, 2026 — How to create Advanced Intercompany Journal Entries through NetSuite's REST API, including authentication, request structure, and the silent failure risk with due to/due from fields.
January 7, 2026 — 10 detailed AI prompts for job seekers covering resume tailoring, interview prep, salary negotiation, and more.
January 6, 2026 — How to override VAT amounts on NetSuite invoices, with approaches for both the Legacy Tax and SuiteTax engines.
January 5, 2026 — A review of Roger Bootle's The AI Economy — a grounded, practical perspective on AI that focuses on economic realities rather than hype.
January 4, 2026 — EC2 is powerful but complex. For many businesses, AWS Lightsail offers predictable pricing, simpler operations, and a built-in graduation path when you actually need more.
January 3, 2026 — There's a known bug that prevents OAuth authentication from completing when connecting the NetSuite AI Connector to Claude Code. Here's what's happening and your workaround options.
January 2, 2026 — How to change a primary key column from INT to VARCHAR in MySQL, including handling foreign key relationships.
2025 (97 posts)
December 23, 2025 — An honest assessment of NetSuite's native demand planning and MRP capabilities, where they fall short for growing manufacturers and distributors, and which third-party platforms are worth evaluating.
December 22, 2025 — A prompt that generates pre-sales intelligence briefs — so you walk into discovery meetings informed.
December 21, 2025 — Insights from a CIO roundtable on pursuing AI without destabilizing enterprise systems.
December 20, 2025 — LLMs have made expressing intent trivially easy. Validating that intent is as hard as ever.
December 18, 2025 — A guide to global climate disclosure requirements and how NetSuite can help your organization prepare, from California SB 253 and the EU CSRD to carbon accounting SuiteApps.
December 17, 2025 — A comprehensive guide to the warning signs that hide in your NetSuite data — and how to catch them before they compound.
December 17, 2025 — An AI prompt designed to help controllers with year-end close — catching issues before they become problems.
December 15, 2025 — As AI platforms mature, ERP is consolidating around its original mandate: transactional integrity and authoritative data. The insight function is migrating to AI agents and analytics layers built for reasoning.
December 12, 2025 — A practical guide to AI pilots that actually stick — designed with clear ownership, earned trust, and thoughtful process fit.
December 11, 2025 — Why NetSuite's official AI Connector makes most third-party AI solutions unnecessary.
December 9, 2025 — When a Map/Reduce script skips the map function, NetSuite passes raw input data directly to reduce. Here's exactly what that looks like and when skipping map is the right call.
December 7, 2025 — How to build governance — lineage, validation, risk checks, and auditability — into AI prompts.
December 5, 2025 — Recursive CTEs have been available in Oracle since 11g Release 2. If you've been avoiding them because you thought Oracle didn't support them, it's time to update that assumption.
December 4, 2025 — The patterns and land grabs in AI chat clients are a replay of the browser wars — with higher stakes.
December 2, 2025 — A practical guide to transferring files between your Mac and a remote Windows session using Parallels Client.
December 1, 2025 — A comprehensive walkthrough of NetSuite's tax management options, from the legacy tax engine and SuiteTax to Avalara and Vertex integrations, with guidance on which approach fits your situation.
November 27, 2025 — The most common and most misdiagnosed problem in Oracle development. The SQL is identical, the indexes exist, the schema matches, and production is crawling. Here's why.
November 24, 2025 — A practical guide to understanding the difference between MES and ERP in manufacturing, where they overlap, how they integrate, and when you need both.
November 20, 2025 — A comprehensive guide to intercompany accounting in NetSuite OneWorld, covering transactions, eliminations, netting, transfer pricing, and consolidated reporting.
November 16, 2025 — A prompt that generates structured sales scripts for NetSuite — with objection handling and persuasion techniques.
November 15, 2025 — How AI can transform NetSuite assembly management by uncovering recoverable components and alternative pathways.
November 13, 2025 — A prompt that transforms generic headlines into sharp, high-engagement versions using specificity, curiosity, and emotion.
November 12, 2025 — What the Packages sublist on a NetSuite Item Fulfillment does, how it gets populated, what it feeds into, and how to work with it in SuiteScript.
November 11, 2025 — Why single complex prompts fail at scale — and how to create trustworthy AI systems.
November 10, 2025 — A comparison of GPT-4o and Claude 3.5 for NetSuite financial analysis — and when to use each.
November 8, 2025 — Ten future applications of AI in ERP — from intent-driven queries to autonomous agents.
November 7, 2025 — The dot-com boom changed where we sold. AI is changing everything.
November 3, 2025 — A comprehensive guide to revenue recognition in NetSuite, covering the ASC 606 framework, ARM configuration, SSP allocation, contract modifications, and when native capabilities need to be extended.
October 28, 2025 — Understanding when legacy electronic data interchange still makes sense, when modern alternatives are better, and how to navigate the transition.
October 24, 2025 — A practical guide to building RESTlets for NetSuite integrations, covering when to choose RESTlets over SuiteTalk REST, with a production-ready example.
October 21, 2025 — An AI-generated Customer Retention Strategy Template for NetSuite account representatives.
October 20, 2025 — Exploring the massive untapped market between QuickBooks and full NetSuite.
October 19, 2025 — Five key strategies NetSuite needs to keep growing and leading in the AI-driven ERP era.
October 17, 2025 — An AI prompt that generates complete Sales Enablement Playbooks — objection handling, battlecards, ROI toolkits.
October 17, 2025 — A comprehensive field guide for executives on building AI strategy, governance, security, and ROI measurement.
October 15, 2025 — How to find, understand, and fix problems in your NetSuite scripts, from log.debug all the way to the Script Debugger.
October 13, 2025 — What phantom assemblies are, how they behave in MRP, work orders, and costing, when to use them, and when they're the wrong choice.
October 12, 2025 — Seven lessons from Morgan Stanley, Klarna, Lowe's and others on implementing AI — and how to apply them to your NetSuite environment.
October 11, 2025 — Like SuiteQL transformed data access, prompt engineering is becoming the new superpower for NetSuite professionals.
October 10, 2025 — NetSuite is betting big on agentic AI — and for the first time, competing with ecosystem developers.
October 9, 2025 — Reflections on patience, persistence, and pragmatism from years of NetSuite development.
October 7, 2025 — Covers potential data filtering issues when running reports via the NetSuite AI Connector.
October 6, 2025 — A practical guide to body fields, sublists, and subrecords in SuiteScript 2.1, with code examples and a mental model for working with NetSuite record data.
October 4, 2025 — A practical guide to item masters, bills of materials, routings, and work centers, covering what each one controls, how they work together, and why master data governance matters.
October 2, 2025 — Practical ways to apply AI during budget season — from automating tasks to smarter forecasting.
October 1, 2025 — Understanding the difference between chatbots and AI agents, and why agents that act autonomously are the real game-changer.
September 30, 2025 — Learn how to use NetSuite's MCP Standard Tools SuiteApp to generate 12-month rolling financial forecasts.
September 25, 2025 — Explores the possibility of using small language models (SLMs) in NetSuite AI agents.
September 23, 2025 — Answers common questions about NetSuite AI Agents.
September 23, 2025 — NetSuite's AI Connector supports ChatGPT, giving businesses more choice and flexibility.
September 22, 2025 — A case study of an Accounts Receivable AI Agent built for a client.
September 20, 2025 — Why getting the general ledger right during a NetSuite implementation is critical.
September 17, 2025 — What to do when your NetSuite Sandbox shows "currently unavailable" after a refresh — and when to contact Support.
September 17, 2025 — Discover what makes AI agents different and how they fit into NetSuite.
September 15, 2025 — How to control access to custom records by role in NetSuite, from the Access Type setting on the record definition to role permissions, record-level security, and common mistakes.
September 12, 2025 — A deep dive into how FileMaker's OAuth/OIDC authentication works, configuration requirements on both the server and identity provider side, common failure modes, and a systematic approach for troubleshooting.
September 9, 2025 — Best practices for using Claude and the NetSuite AI Connector in financial analysis.
September 8, 2025 — Why AI literacy matters for NetSuite users and how business leaders can build the skills to leverage AI responsibly.
September 5, 2025 — A detailed look at why FileMaker WebDirect performance degrades as concurrent users grow, how to diagnose the root causes, and the layout design, scripting, and infrastructure techniques that produce genuinely fast WebDirect experiences.
September 3, 2025 — Generate Flux Analysis Reports automatically using Claude and the NetSuite AI Connector.
August 30, 2025 — Key opportunities for developers, consultants, and partners in NetSuite AI.
August 29, 2025 — A review of NetSuite for Consultants, Third Edition by Peter Ries.
August 28, 2025 — Generate professional Trend & Growth Analysis Reports with Claude and NetSuite.
August 22, 2025 — A deep dive into how FileMaker container field strategy goes wrong, why those mistakes are so expensive to fix, and how to design container storage correctly from the start.
August 20, 2025 — Introducing the Current User Tool for the NetSuite AI Connector.
August 19, 2025 — Discover how NetSuite AI can deliver instant financial insights.
August 18, 2025 — Information about the NetSuite AI Connector and shifting focus to SuiteReports.
August 17, 2025 — How to enhance the AI Connector's capabilities with SuiteScript Custom Tools.
August 15, 2025 — Unlock powerful insights by pairing SuiteQL with Claude.
August 13, 2025 — Updates on SuiteAnalyzer, Suite.js, and upcoming AI services.
August 11, 2025 — Comparing GPT-4.1 and GPT-5 performance in SuiteAnalyzer.
August 6, 2025 — A deep dive into the FileMaker separation model: why it exists, how file references work under the hood, seven common deployment failure modes, and how to build the operational infrastructure that makes a separated solution genuinely maintainable.
August 4, 2025 — New tools to overcome AI integration challenges with NetSuite.
July 31, 2025 — An overview of challenges when integrating AI with NetSuite.
July 28, 2025 — A thorough look at FileMaker's record locking model, the failure modes that hurt production solutions, and the scripting patterns and design principles that make your solution resilient in a concurrent environment.
July 15, 2025 — A thorough look at why Perform Script on Server (PSOS) fails silently in FileMaker, covering the seven categories of context blindness, how to diagnose them, and how to architect scripts that are genuinely PSOS-safe.
June 24, 2025 — A deep dive into why FileMaker's ExecuteSQL function is fragile, how schema changes silently break queries, and practical strategies for making your SQL queries maintainable and resilient.
June 10, 2025 — A deep dive into FileMaker relationship graph bloat: what it is, why it happens, how context confusion creates hard-to-find bugs, and how to design your way out of it.
June 3, 2025 — A comprehensive guide to commission management in NetSuite, covering the native module, productive workarounds, third-party platforms like CaptivateIQ and Xactly, and when a custom SuiteScript engine is the right call.
May 28, 2025 — A practical guide to using Declares in Xojo to call native OS APIs on macOS, Windows, and Linux, covering data type mapping, real-world examples, cross-platform patterns, and when to choose plugins instead.
May 7, 2025 — A practical guide to threading in Xojo, covering the Thread and Timer pattern, shared data safety, cancellation, progress reporting, and common mistakes to avoid.
May 4, 2025 — A comprehensive guide to AP/AR netting in NetSuite, covering intercompany netting in OneWorld, vendor-customer netting with clearing accounts, multi-currency considerations, 1099 reporting, and month-end close best practices.
April 20, 2025 — How to make custom portlets available in the Employee Center.
April 17, 2025 — A technique for redirecting users to alternative dashboards.
April 16, 2025 — Attach and retrieve user notes programmatically.
April 9, 2025 — A practical guide to Xojo database best practices, covering PreparedStatements, error handling with Try...Catch, transactions, and separating your data layer from your UI.
April 7, 2025 — A SuiteScript snippet showing how to cancel a transaction.
March 10, 2025 — A practical look at cross-platform development in Xojo, covering where the framework handles platform differences for you, where you need to pay attention, and how to design apps that feel native on macOS, Windows, and Linux.
March 2, 2025 — Adds support for generative AI-related procedures.
February 19, 2025 — SuiteQL queries for finding frequently returned items.
February 16, 2025 — SuiteQL query for cross-selling opportunities.
February 10, 2025 — A query returning price information including price levels.
February 5, 2025 — Understanding what changed in Xojo's 2019r2 API rename, why it matters, and how to work cleanly within one API generation.
January 30, 2025 — An example Suite.js app for inventory inquiries.
January 28, 2025 — How to diagnose the EntityOrRoleDisabled status in NetSuite's Login Audit Trail, what triggers it, and why it matters for both security and operations.
January 26, 2025 — New version of the open source alternative Web API.
January 13, 2025 — Xojo is a cross-platform RAD tool that compiles native desktop, web, mobile, and console apps from a single codebase. Here's an honest look at what it does, who it's for, and where it fits.
2024 (34 posts)
December 14, 2024 — Query transactions posted to specific GL accounts.
December 9, 2024 — Query customer deposit information.
November 13, 2024 — Query company contact information.
November 11, 2024 — Query invoices within a date range.
November 04, 2024 — Query payment application details.
October 30, 2024 — Query item types and their counts.
September 2, 2024 — A web API leveraging SuiteAnalytics Connect.
April 24, 2024 — Overview of the Transaction table.
April 17, 2024 — Q&A about SuiteBrowser.
April 3, 2024 — Export dataset SuiteQL queries.
April 2, 2024 — Query multiple select fields.
March 20, 2024 — Working with item groups in SuiteQL.
February 27, 2024 — Query Avalara AvaTax data.
February 14, 2024 — Query phone call records.
February 11, 2024 — Track inventory quantity changes.
February 5, 2024 — Query accounting list data.
February 3, 2024 — Query PO related transactions.
February 2, 2024 — Query inbound shipment data.
February 2, 2024 — Use SOUNDEX in SuiteQL.
January 31, 2024 — Query aggregate item data.
January 30, 2024 — Query upsell opportunities.
January 29, 2024 — Analyze item returns.
January 28, 2024 — Query item vendor information.
January 26, 2024 — Create customer ledgers.
January 25, 2024 — Query company contacts.
January 21, 2024 — Query balances by sales rep.
January 17, 2024 — Case-insensitive keyword searches.
January 14, 2024 — Xojo-based SuiteBrowser app.
January 13, 2024 — Remote app support preview.
2023 (26 posts)
December 22, 2023 — Hardware, software, and services I use.
October 22, 2023 — Generate PDFs programmatically.
October 1, 2023 — Query customers by address and history.
August 21, 2023 — Review of Xojo 2023r2.
August 13, 2023 — Generate Excel files with Aloe.js.
July 19, 2023 — Query purchasing info by location.
July 12, 2023 — Query budget data.
July 9, 2023 — Query lot/serial items.
June 7, 2023 — Query locations and bins.
May 21, 2023 — Assist sales order entry.
March 6, 2023 — Hybrid app case study.
February 21, 2023 — Review of Augmented Lean.
February 16, 2023 — Analyze transaction volume.
February 14, 2023 — Find recently updated scripts.
January 29, 2023 — Custom order status app.
2022 (50 posts)
December 8, 2022 — SuiteConsole preview.
December 5, 2022 — Query tool pagination.
November 30, 2022 — Use cookies in Suitelets.
November 29, 2022 — JavaScript libraries in Xojo.
October 30, 2022 — Integrate NetSuite with Xojo.
September 19, 2022 — Fix Zebra printer issues.
September 13, 2022 — Query accounting periods.
August 28, 2022 — Enhanced external ID search.
August 18, 2022 — Link vendor bills to POs.
August 15, 2022 — GL impact analysis.
August 11, 2022 — Query transaction relationships.
June 27, 2022 — Query shipment tracking.
June 12, 2022 — Introduction to SuiteFrame.
May 11, 2022 — Custom tabs for results.
May 8, 2022 — Tulip query tool.
May 5, 2022 — Find overdue customers.
May 2, 2022 — Tables and permissions.
April 24, 2022 — Inventory transactions.
2021 (47 posts)
December 12, 2021 — Alternative pagination.
December 11, 2021 — Sales reports with SuiteQL.
December 5, 2021 — SuiteQL Query API RESTlet.
November 16, 2021 — Related transactions.
October 29, 2021 — License usage analysis.
September 29, 2021 — Sync utility preview 2.
September 25, 2021 — Sync utility preview.
September 12, 2021 — SuiteQL in Map/Reduce.
August 23, 2021 — Custom records and fields.
August 21, 2021 — Multiple subsidiaries.
August 17, 2021 — Generate maps.
August 4, 2021 — Generate charts.
July 25, 2021 — Query Tool Beta 2.
July 14, 2021 — Query Tool Beta 1.
May 18, 2021 — Currency exchange rates.
April 20, 2021 — Serialized and expiring items.
March 16, 2021 — Query Tool update.
2020 (43 posts)
December 17, 2020 — Transaction queries.
December 7, 2020 — Return authorization analysis.
November 23, 2020 — Fulfillments and Pacejet.
November 10, 2020 — AP aging analysis.
November 6, 2020 — AR aging analysis.
November 5, 2020 — Inventory history lookup.
November 4, 2020 — Sales-related queries.
November 2, 2020 — Employee queries.
October 27, 2020 — Query Tool update.
August 19, 2020 — SuiteQL RESTlet.
August 6, 2020 — Original Query Tool.
July 16, 2020 — Transaction statuses.
July 15, 2020 — PromoStandards integration.
May 21, 2020 — SuiteQL with REST.
May 18, 2020 — ServiceNow case study.
May 5, 2020 — Airtable forms.
April 23, 2020 — ServiceNow integration.
March 11, 2020 — ServiceNow Table API.
2019 (16 posts)
October 8, 2019 — My 2019 setup.
August 26, 2019 — File Cabinet RESTlet.
July 26, 2019 — Config RESTlet follow-up.
July 25, 2019 — Configuration RESTlet.
2018 (1 posts)
January 15, 2018 — PromoStandards resources.
2017 (1 posts)
August 1, 2017 — Why PromoStandards matters.