Every question your ERP should be able to answer
50 guides written for the people who actually have to produce the number — controllers, analysts, planners and NetSuite admins. Formulas you can check, queries you can run, and no vendor gloss.
Start here
Why AI chatbots hallucinate on ERP data
Why AI hallucinates on ERP data: the mechanism behind confident wrong numbers, and the four controls that stop it — grounding, validation, shown queries.
What is grounded ERP AI?
Grounded ERP AI defined: four testable properties — per-account dictionary, schema validation, shown queries, refusal — and how to test a vendor on each.
What is a data dictionary in ERP?
What a data dictionary is in ERP terms: record types, custom fields, join paths, observed status values — and why AI answers need a per-account one.
50 guides
NetSuite reporting
Getting real answers out of NetSuite — reports, dashboards and the questions behind them.
- How to run an AR aging report in NetSuiteHow to run an AR aging report in NetSuite: the standard report's limits, the saved search and SuiteQL versions, and the traps that make the buckets wrong.
- NetSuite top customers by revenue: building a report that holds upBuild a top customers by revenue report in NetSuite, and see why revenue, invoiced and collected give three different rankings of the same customers.
- NetSuite inventory valuation report: why it won't tie to the GLHow the NetSuite inventory valuation report is built, how costing method changes the number, and why it won't tie to your inventory GL account.
- NetSuite open sales orders report: getting the backlog rightHow to build an open sales orders report in NetSuite: what each status means, how to catch partially fulfilled lines, and where backorders hide.
- Reporting on NetSuite custom fields: why they disappearWhy NetSuite custom fields disappear from reports: store value, applies-to, field type and role access, plus how to query custbody and custcol fields.
- NetSuite consolidated multi-subsidiary reporting, explainedHow NetSuite consolidated multi-subsidiary reporting works: consolidated exchange rates, elimination subsidiaries, CTA, and the subsidiary-context traps.
- NetSuite dashboard best practices that survive MondayNetSuite dashboard best practices from real cleanups: portlet budgets, KPI selection, refresh and caching reality, and publishing dashboards by role.
- NetSuite month-end close checklistAn ordered NetSuite month-end close checklist: 14 steps with the period-locking, inventory-costing, revenue and intercompany gotchas that break a close.
- NetSuite purchase order status report: building one that is rightBuild a NetSuite purchase order status report that holds up: PO lifecycle statuses, line-level open commitment, three-way match and late-supplier data.
- NetSuite item profitability report: margin by item that ties outBuild a NetSuite item profitability report that ties out: estimated versus actual COGS, landed cost allocation, and why item margin never equals GL margin.
- How to build a NetSuite budget vs actual reportBuild a NetSuite budget vs actual report that reconciles: budget loading, period alignment, variance columns and department dimensions.
- NetSuite saved search limitations, and what to use insteadThe real ceilings of NetSuite saved searches: join depth, summary maths, row limits and performance, plus the right tool to use for each one.
SuiteQL
Query craft for NetSuite: joins, dates, performance and the errors that stop you.
- SuiteQL tutorial for beginners: your first eight queriesA SuiteQL tutorial for beginners: where to run queries, how the tables map to records, and eight worked queries you can paste in today.
- SuiteQL join examples that cover most real queriesWorked SuiteQL join examples: transaction to transactionline to customer, item and custom record joins, plus when left joins change the answer.
- SuiteQL date functions: the ones you actually needSuiteQL date functions explained: TO_DATE, TRUNC, ADD_MONTHS and MONTHS_BETWEEN, with period filters and the timezone traps that skew totals.
- SuiteQL vs saved search: which one should you use?SuiteQL vs saved search in NetSuite: what each does better, a side-by-side table, where saved searches still win, and how to port one to SQL.
- SuiteQL transaction queries: a working cookbookEight SuiteQL transaction queries you can run today: AR aging, open orders, revenue by customer, PO status, item margin — each with its assumptions stated.
- SuiteQL performance tips that change the runtimeSuiteQL performance tips: filter on native columns, keep functions out of WHERE, page with a keyset cursor, and aggregate server-side.
- Common SuiteQL errors, and what they actually meanCommon SuiteQL errors in one table: unknown identifier, ambiguous column, GROUP BY, invalid number, date format and REST header failures, plus the fix.
- How to query NetSuite custom records with SuiteQLQuery NetSuite custom records with SuiteQL: find the customrecord_ table name, discover custrecord_ fields, and join to customers and transactions.
Grounded ERP AI
How AI over ERP data actually works — grounding, dictionaries, security, agents.
- Why AI chatbots hallucinate on ERP dataWhy AI hallucinates on ERP data: the mechanism behind confident wrong numbers, and the four controls that stop it — grounding, validation, shown queries.
- What is grounded ERP AI?Grounded ERP AI defined: four testable properties — per-account dictionary, schema validation, shown queries, refusal — and how to test a vendor on each.
- What is a data dictionary in ERP?What a data dictionary is in ERP terms: record types, custom fields, join paths, observed status values — and why AI answers need a per-account one.
- AI + ERP security checklist: 18 questions to askAn AI and ERP security checklist: 18 questions on access, retention, tenancy, writes, audit and model hosting — with good and bad answers for each.
- Text-to-SQL accuracy: why benchmark scores don't survive your ERPText-to-SQL accuracy on academic benchmarks collapses on real ERP schemas. The six causes, and the five mechanisms that raise it in production.
- MCP for ERP: connecting AI agents to your ERP safelyWhat Model Context Protocol is, why an ERP MCP server needs governance, and how read and write tools should differ. A practical guide for ERP admins.
- AI agents for finance teams: what works and what doesn'tFive realistic AI agent jobs for finance teams: collections triage, close prep, variance drafting, exception monitoring. Plus the guardrails each needs.
- Self-hosted AI for ERP: who needs it, and what it costs youWho genuinely needs self-hosted AI for ERP, what local models give up against frontier models, what fits on modest hardware, and the air-gapped case.
Finance metrics
The working-capital and margin numbers finance teams are asked for, explained properly.
- What is DSO — and how do you actually bring it down?DSO explained plainly: the formula, the three variants people confuse, realistic benchmarks by industry, and the seven levers that actually move it.
- Cash conversion cycle explained, with a worked exampleThe cash conversion cycle explained: CCC = DIO + DSO − DPO, a full worked example at 65 days, and how to cut each leg without breaking the other two.
- DPO explained: days payable outstanding, and when to stretch itDPO explained: the days payable outstanding formula, a worked example at 36.5 days, and where stretching supplier terms starts to cost you money.
- AR aging buckets explained: 30/60/90 and what to do with themAR aging buckets explained: why 30/60/90, how to compute weighted average days overdue, and how to set a bad debt reserve from the bucket mix.
- Collection effectiveness index (CEI): formula, targets and why it beats DSOCollection effectiveness index (CEI) explained: the formula, a worked example at 70.4%, realistic targets, and why CEI beats DSO for judging collections.
- Is a 2/10 net 30 discount worth it? Both sides of the mathsIs 2/10 net 30 worth it? The annualised cost is about 37%. Worked maths for buyers taking a discount and sellers offering one, against cost of capital.
- Margin vs markup: the difference, and the conversion tableMargin vs markup, settled: both formulas, a checked conversion table, and the pricing error that quietly costs you dollars per unit.
- Break-even analysis: the formula, worked step by stepBreak-even analysis explained with real numbers: contribution margin, break-even units and revenue, margin of safety, and the multi-product trap.
- Price volume mix analysis: why you grew but margin fellPrice volume mix analysis with a fully worked example: an additive decomposition where price, volume and mix sum exactly to the revenue change.
- Budget vs actual variance analysis that survives a board meetingBuild a budget vs actual variance analysis that holds up: materiality thresholds, price/volume/mix drivers, and timing versus permanent.
Inventory & operations
Stock, supply and shop-floor metrics — formulas, benchmarks and failure modes.
- Safety stock formulas compared: four methods, one data setFour safety stock formulas on one data set, from 543 to 6,120 units: what each assumes, the z values, and service level versus fill rate.
- Reorder point: the formula, and how to set it properlyThe reorder point formula worked end to end: demand during lead time, safety stock, lead-time variability, review periods and the ERP min/max fields.
- EOQ explained: the trade-off, the maths, and when to ignore itEOQ explained with a worked example: the square-root formula, why ordering and holding cost are equal at the optimum, and the assumptions that break.
- Inventory turnover: how to read turns, and why higher is not betterInventory turnover explained: the COGS formula, days of inventory, GMROI, directional ranges by business type, and why chasing turns can cost you margin.
- ABC analysis: ranking inventory by value and setting policy from itABC analysis step by step: rank items by annual usage value, cut classes at 80% and 95% cumulative value, then set count, review and buffer policy per class.
- OEE explained: three factors, six losses, and the 85% rule of thumbOEE explained with full arithmetic: availability, performance and quality defined, the six big losses, TEEP, and why performance over 100% is a data fault.
- Landed cost: what to include and how to allocate itWhat belongs in landed cost — freight, duty, insurance, brokerage — the three allocation methods, and how the choice moves item margin by points.
- Purchase price variance explained: why favourable isn't good newsPurchase price variance explained: the formula, why a favourable PPV often signals a stale standard or over-buying, and who should actually own the number.
ERP strategy
Business cases, implementations and migrations, without the vendor gloss.
- How to build an ERP ROI business case a CFO will approveBuild an ERP ROI business case a CFO will approve: benefit categories with named owners, payback and NPV mechanics, and honest sensitivity analysis.
- What does an ERP implementation cost?What drives ERP implementation cost: scope multipliers, services-to-licence ratios, the internal time nobody budgets, and what to ask an integrator.
- ERP data migration guide: sequence, cleansing and cutoverERP data migration guide: the object load sequence, cleansing before mapping, how many mock loads are realistic, reconciliation and cutover.
- ERP reporting tools compared: native, queries, BI and AIERP reporting tools compared: native reports, saved searches, a BI stack and conversational AI — with the real weaknesses of each, including ours.
Your ERP already knows. Start asking.
ERPray computes answers like these live from your own ERP account and shows the exact query behind every number. Early access is open for NetSuite teams — free plan at launch.