Free Developer Tools tools
380 templates, calculators, worksheets and reference tables. Each runs in your browser and exports to PDF, Excel, Word or CSV.
Templates and forms
AI Agent ERP Access Request Form Template
A fill-in form that records which ERP roles, objects and limits an AI agent service account needs, with approval signatures.
MCP Server Deployment Runbook Template
A fill-in runbook covering host, secrets, network, health checks, monitoring and rollback for an MCP server in front of an ERP.
WhatsApp Webhook Incident Runbook Template
A fill-in runbook for when WhatsApp messages stop arriving, signatures fail or delivery receipts go missing. Export to PDF or Word.
EDI AS2 Connection Parameters Request Template
A form to exchange AS2 IDs, endpoints, certificates, MDN settings and security options with a trading partner before testing.
Self-Hosted Odoo Private AI Layer Blueprint Generator
Generate a shareable architecture plan for adding a private, on-prem AI assistant to Self-Hosted Odoo, with components, security controls and a three-phase rollout.
Worksheets
MCP Tool Catalog and Risk Worksheet
Register each MCP tool your agent exposes, the ERP object it touches and a computed risk score, then export to Excel.
ERP API Field Mapping Worksheet
Map each ERP API field to the parameter an AI tool exposes, with types, required flags and transform rules, then export to Excel.
Webhook Event Test Case Worksheet
A test plan grid for messaging webhooks: inbound text, status receipts, duplicates, bad signatures and ERP failures. Exports to Excel.
ERP Data Dictionary Worksheet
An editable table to document ERP tables and columns with type, length, null rate, fill rate and owner.
ERP SQL Query Catalog Worksheet
An editable inventory of the queries and reports your team runs, with owner, frequency, runtime and monthly effort.
Scheduled SQL Job Register Worksheet
An editable register of scheduled jobs with daily runtime, dependencies, owners and failure contacts.
SQL Query Tuning Log Worksheet
A tuning log that records the change, before and after runtime and logical reads, and calculates percent improvement.
SQL Query Performance Tuning Log Worksheet
An editable log of slow ERP queries with before and after timings that computes percent improvement and CPU hours saved per day.
Infor M3 MDBREADMI and Custom List API Design Worksheet
Plan each custom M3 read API row by row: which API type, which table and index, which output fields, who calls it and how often, with a warning above 10 output fields.
Calculators and simulators
NetSuite API Retry Backoff Wait Time Calculator
Plan exponential backoff for NetSuite 429 and concurrency errors: delay per attempt, total wait with and without jitter, and worst case duration.
NetSuite OAuth 2.0 Access Token Refresh Calculator
Work out how often your integrations refresh NetSuite OAuth 2.0 access tokens and how many API calls each token serves.
Acumatica API Request Capacity Calculator
Sizes API traffic from integrations, sync frequency and batch size, then checks headroom against your licensed request limit.
ERP API Rate Limit Calculator for AI Agents
Check whether your AI agents will exceed an ERP API rate limit at peak, and how many agents the limit can support.
MCP Tool Schema Token Cost Calculator
Estimate the tokens and monthly cost of tool definitions sent on each request, and how caching or fewer tools changes it.
MCP Tool Definition Context Token Overhead Calculator
Sizes the context window and input cost eaten by MCP tool schemas before the user says a word, and shows the what-if as you add tools.
ERP API Initial Data Sync Duration Calculator
Computes how many pages, how many hours and how many quota days an initial extract from an ERP REST API will take, with a page-size what-if.
Webhook Retry Backoff Window Calculator
Shows how long an exponential retry policy keeps trying and whether it outlasts your receiver's expected outage.
MCP Server End-to-End Availability Calculator
Multiplies component uptimes in the agent request path and shows downtime per month, with a replica what-if for the MCP server.
API Polling vs Webhook Call Budget Calculator
Quantifies how many API calls a polling loop burns versus event delivery, and the latency you trade for it.
WhatsApp Business API Cost Calculator
Model monthly WhatsApp cost by marketing, utility and authentication volume with your own rates, free window share and provider fees.
Messaging Throughput and Rate Limit Headroom Calculator
Estimate peak message rate, how much headroom you have under a rate limit, how many workers you need and how long a burst takes to drain.
Teams Webhook Rate Limit Queue Drain Time Calculator
Calculate how long a burst of alerts takes to drain through a rate limited Teams endpoint, including retries after throttling responses.
Messaging Webhook Retry Backoff Schedule Calculator
Work out how long an exponential backoff retry policy keeps trying before a WhatsApp, Teams or Slack message is parked for review.
EDI Document Size and VAN Kilocharacter Calculator
Estimate characters per X12 document from its structure and project kilocharacters and VAN cost per month.
SQL Server Index Size Estimator Calculator
Estimate how many GB a new nonclustered index will add to your ERP database, and see how fill factor changes the size.
SQL Server Transaction Log Sizing Calculator
Work out how large the transaction log of an ERP database should be, and how log backup frequency changes it.
SQL Server Page Compression Savings Calculator
Estimate the GB, cost and rebuild time of applying page compression to the large tables of an ERP database.
CSV Export File Size and Split Calculator
Estimate the size of an ERP CSV extract and how many files you need to stay under Excel's row limit or an upload size cap.
SyteLine IDO REST Paging Throughput Calculator
Estimate how many REST calls, how much payload and how long a bulk IDO read takes for a given recordcap, and find a page size that avoids timeouts.
SyteLine Large Table Scan Cost Calculator
See why a non-sargable filter on matltran_mst, jobtran_mst or ledger_mst takes seconds while an index seek takes milliseconds.
Infor M3 EXPORTMI Extraction Call Volume Calculator
Plan paged extracts from M3 through EXPORTMI or Lst transactions: calls per run, elapsed minutes and daily call volume under a record cap.
Infor OS ION API and API Flow Payload and Timeout Calculator
Find a records-per-call batch size that stays inside ION API Gateway time-outs and API Flow payload limits, and estimate total run time.
SAP ECC BAPI Mass Load Runtime and Commit Size Calculator
Enter records, measured milliseconds per BAPI call and per commit, records per commit and parallel tasks to estimate load runtime, compare with BDC and size error rework.
Oracle EBS Custom Forms to APEX Migration Effort Calculator
Estimate the hours and cost to rebuild EBS custom Forms as Oracle APEX pages that launch from the EBS menu with EBS authentication.
NetSuite RESTlet Batch Size Calculator
Find the largest safe batch per RESTlet call from usage units, payload size and execution time, plus the number of calls and wall-clock time.
IBM i Journal Receiver Growth and Retention Calculator
Estimate how fast journal receivers grow for a journaled ERP library and how much disk your retention policy needs, from daily row changes, record length, images and entry overhead.
Reference tables
NetSuite SuiteScript Governance Units by Script Type
A lookup of governance unit limits for each SuiteScript script type and the design guidance that follows from them.
HTTP Status Codes for ERP API Agents Reference
Look up an HTTP status code and see what it usually means on an ERP API and whether an agent should retry, fix the request or escalate.
MCP and JSON-RPC Error Codes Reference
A lookup table of JSON-RPC 2.0 error codes and how an MCP server should signal protocol errors versus tool failures.
WhatsApp Cloud API Error Codes Reference
A searchable lookup of common WhatsApp Business Cloud API error codes, what they mean and the first thing to check.
Slack API Rate Limit Tiers Reference
Searchable table of Slack Web API methods with their rate limit tier and how to handle HTTP 429 responses.
Tesseract Page Segmentation Modes and OEM Reference
Look up every Tesseract page segmentation mode (0 to 13) and OCR engine mode (0 to 3), with notes on which to use for invoices, stamps, labels and single fields.
SQL Server, Oracle, PostgreSQL and MySQL Data Type Mapping Reference
A quick lookup of equivalent data types across four databases, with the gotchas that break ERP migrations.
SQL Server Wait Types Reference for ERP Databases
Searchable lookup of common SQL Server wait types with plain-language meaning, typical cause in an ERP workload and the first thing to check.
SQL Data Type Mapping: SQL Server, Oracle, PostgreSQL, MySQL
Searchable table of equivalent data types across SQL Server, Oracle, PostgreSQL and MySQL, with the gotchas that break ERP data loads.
SQL Isolation Levels and Locking Behavior Reference
Compare isolation levels across SQL Server, Oracle, PostgreSQL and MySQL with what each allows and how it affects ERP reports and postings.
Common OT and ICS Protocol Ports Reference
Default TCP and UDP ports used by industrial protocols and the IT services that sit beside them, with a firewall risk note for each.
Windows Security Event ID Reference for Threat Hunting
The event IDs a small security team should log and alert on, from failed logons and new services to cleared logs and PowerShell script blocks.
SyteLine Mongoose Framework Events Reference
Every framework event an application event handler can subscribe to in SyteLine 9/10 and CSI on-prem, with when it fires, what it passes and the traps to avoid.
SyteLine Event Action Types Reference
The 26 action types on the SyteLine Event Actions form, with what each does, the parameters that matter and which ones make a handler wait.
SyteLine Event Action Parameter Functions Reference
The expression functions you use in SyteLine event action parameters, with exact syntax, return type and the events where each one works.
SyteLine WinStudio Standard Form Events Reference
The WinStudio standard events behind open, next, save, refresh, new, delete and close on SyteLine forms, with the sequence each belongs to and where custom handlers are safe.
SyteLine Mongoose API Options Reference
A side-by-side reference of the Mongoose interfaces for SyteLine 9/10 and CSI: endpoint, authentication, operations, best use and the traps in each.
SyteLine SQL User-Defined Data Types Reference
The SQL Server user-defined data types SyteLine uses for columns and stored procedure parameters, with scripts to read exact lengths from your own database.
Infor LN DAL and User Exit Hook Functions Reference
Lookup table of LN DAL object hooks, property hooks, user exit hooks and DAL functions with when they fire, what they return and the common traps.
Infor XA Integration Options Reference (System-Link, IDF, Triggers, ION)
One row per way of getting data into or out of Infor XA on IBM i, with direction, transport, the XA objects involved and the main watch-outs.
Infor Lawson S3 LSF System Utilities and Batch Command Reference
The LSF command-line utilities Lawson admins use for the batch server, job queues and copying data, with purpose, example, where to run and cautions.
Infor Lawson IPA Process Designer Activity Node Reference
Every main Infor Process Designer activity node grouped as in the Infor guide, with what it does, typical S3 use and which nodes are deprecated.
Infor ION Connection Point Types Reference (On-Premises and Cloud)
Compare ION connection point types by edition, how messages move, document types supported, Enterprise Connector need and typical use.
SAP ECC Enhancement Transactions and Exit Tables Reference (SMOD, CMOD, SE18, MODSAP, SXC_EXIT)
Lookup table of the transactions, tables and classes used to find, implement and audit customer exits, BAdIs and enhancement implementations on SAP ECC 6.0.
SAP ECC Data Dictionary and Repository Tables Reference (DD02L, DD03L, T100, E070, TSTC)
Which SAP table holds table names, field lists, domain values, messages, transports and transaction codes, with key fields and join paths.
SAP ECC ABAP Runtime Errors (ST22 Dumps) and Error Log Transactions Reference
The ST22 dumps you meet most in SAP ECC, with the exception class, usual cause and first fix, plus the transactions that show every other error log.
ABAP New Open SQL Syntax Reference by Release (7.40 to 7.58)
Look up each ABAP SQL feature with the classic form, the new syntax and the SAP_BASIS release that first allows it, from 7.40 SP05 to 7.58.
ABAP ALV Layout, Field Catalog and Color Codes Reference
Side by side: how to do checkbox, hotspot, colors, subtotals, toolbar buttons, top of page and refresh in CL_GUI_ALV_GRID and in CL_SALV_TABLE, plus the C1 to C7 color codes.
ABAP CDS Annotations Reference (Common On-Premise Annotations)
The annotations you actually write in on-premise CDS views, with allowed values, scope, effect and the difference between DDIC-based views and view entities.
SAP Business One T-SQL to HANA SQL Query Conversion Reference
Side-by-side lookup of the T-SQL constructs used in SAP Business One queries and formatted searches, their HANA SQL equivalents, a B1 example and the gotcha that breaks the migrated query.
Oracle EBS Public PL/SQL API Reference (OM, INV, PO, AP, AR, TCA, FND)
The public PL/SQL APIs EBS developers call most outside HR, with key parameters, the context each needs and how to read its errors.
Oracle EBS Forms Personalization Tables and Trigger Events Reference
The tables behind Forms Personalization, the trigger events and action types you can use, every common builtin, and the FNDLOAD commands to move rules between instances.
Oracle EBS Forms FRM Error Codes Reference (FRM-92101, FRM-40735)
Searchable list of the FRM errors EBS users actually hit, with the message text, the usual cause in EBS, what to check first and where to find the underlying ORA- error or log.
Oracle EBS XML Publisher RTF Template Syntax Reference
Searchable list of the RTF template tags used in EBS XML Publisher (BI Publisher) reports, with examples for loops, grouping, conditions, date and number formatting, totals, variables and page layout.
NetSuite REST Web Services Headers and Query Parameters Reference
Every request header, response header, query parameter and base endpoint you use with SuiteTalk REST Web Services, with values, defaults and examples in one table.
SuiteScript 1.0 to 2.1 API Mapping Reference for NetSuite
Look up the SuiteScript 2.x module and method that replaces each common nlapi or nlobj call, with governance and behaviour differences to watch during migration.
IBM i Query/400 (WRKQRY) Record Selection Tests and Result Field Reference
Searchable reference for Query for IBM i (Query/400): every record selection test, the result field functions it supports, and practical recipes for dates, RUNQRY and moving to SQL.
IBM i ILE RPG Status Codes and Common Error Messages Reference
Look up ILE RPG program and file status codes with IBM's wording, the MONITOR or %ERROR pattern that traps each one, and the usual fix, plus the CPF and MCH messages behind them.
IBM i Services (QSYS2 and SYSTOOLS) SQL Reference
Searchable list of IBM i Services you can query with SQL from Run SQL Scripts, STRSQL or ODBC, with the CL command each replaces and a ready-to-run statement.
Code and query generators
SAP Sales Order ABAP SELECT Generator (VBAK, VBAP, VBFA)
Fill in sales organization, order type and date range to get a ready ABAP report skeleton that joins VBAK and VBAP and reads VBFA.
SAP Sales Order Create BAPI ABAP Generator (BAPI_SALESORDER_CREATEFROMDAT2)
Fill in order type, sales area, customer, material and quantity to get an ABAP skeleton that creates a sales order through the standard BAPI.
SAP ABAP Open Items SELECT Generator
Fill in company code, vendor range and key date to get a ready-to-edit ABAP report that lists open vendor items with an overdue calculation.
SAP ACDOCA SQL Query Generator
Build SQL over ACDOCA for account balances and line items by ledger, company code, fiscal year and period range.
SAP QM Inspection Lot ABAP SELECT Generator
Fill in plant, inspection type and date range and get a ready ABAP SELECT joining the inspection lot table QALS to the usage decision table QAVE.
SAP Quality Notification Pareto SQL Query Generator
Build a SQL query over QMEL and QMFE that lists quality notifications and counts defects by code group and code, ready for a Pareto chart.
SAP QM Usage Decision BAPI Skeleton
An ABAP skeleton for recording an inspection lot usage decision through the standard BAPI, with error handling and a commit only when no error is returned.
ABAP Custom Exception Class Generator
Fill in a class name, message class and attribute and get a ready-to-paste class-based exception with a TRY/CATCH usage example.
ABAP Unit Test Class Generator
Create the skeleton of an ABAP Unit local test class with setup, a happy-path test, a boundary test and an exception test.
ABAP BAPI Return Handling and Commit Generator
Wrap any BAPI call with BAPIRET2 error checking, message text building and a safe commit or rollback.
SAP ABAP AUTHORITY-CHECK Snippet Generator
Fill in an authorization object, activity and organisational field and get a ready ABAP AUTHORITY-CHECK block with error handling.
SAP B1 SQL Query Generator (OITM, ORDR, RDR1)
Fill in a few filters and get a read-only SQL query over OITM, ORDR and RDR1 to paste into the SAP B1 Query Manager.
SAP B1 Service Layer Sales Order JSON Generator
Fill in server, company database, customer and line details to get ready-to-test Login and sales order POST requests for the Service Layer REST API.
SAP Business One Service Layer Request Builder
Fill in host, company and item details and get ready-to-paste Service Layer requests for login, item query, sales order and production order.
SAP Business One DI API Sales Order Code Generator (C#)
Fill in connection and order details to get a C# DI API skeleton that connects, adds a sales order and reports errors.
SAP Configurable Material Selection ABAP Generator
Fill in plant and material type to get an ABAP report that lists configurable materials and counts them by plant.
Oracle EBS SQL Query Generator for Items and WIP Jobs
Build ready-to-run SELECT statements over MTL_SYSTEM_ITEMS_B, WIP_DISCRETE_JOBS and on-hand quantity tables.
Oracle EBS Onhand Quantity SQL Generator
Fill in organization, item pattern and subinventory to get ready-to-run SQL for onhand by lot, onhand versus reservations, and recent transaction history.
Oracle EBS BOM Explosion SQL Generator
Produces multilevel bill of material explosion and where-used SQL for Oracle EBS using hierarchical queries, with organization, item and effectivity inputs.
Oracle EBS Pending Transactions SQL Generator for Period Close
Builds SQL that counts and lists pending, errored and uncosted transactions in inventory and WIP before you close an Oracle inventory accounting period.
Oracle Fusion REST API URL Builder
Fill in host, version and resource to generate a Fusion Cloud REST URL with query parameters and a ready curl command.
JD Edwards SQL Query Generator (Open Sales Order Lines)
Generates a read-only SQL Server query for open JDE sales order lines, with Julian date conversion, implied decimal handling and branch filters.
JD Edwards F0911 General Ledger SQL Generator
Fill in schema, company, ledger type and a Julian date range to get ready-to-run SQL for F0911 detail and an account summary.
JD Edwards F4801 Work Order SQL Generator
Build SQL for open JDE work orders by branch plant, status and date, plus the parts list for one work order.
IBM i (DB2 for i) SQL Data Extraction Script Generator
Generate DB2 for i SQL to inspect a file, count rows, and extract records with Julian date filters for JD Edwards World or other IBM i data.
Db2 for i SQL Services Query Generator
Fill in a library, object type and subsystem and get a set of QSYS2 SQL services queries for sizes, row counts, jobs, locks and user profiles.
SyteLine IDO REST Request Generator
Fill in host, configuration, IDO, properties and filter to get ready-to-use REST calls for loading, updating and invoking methods on SyteLine IDOs.
SyteLine SQL Query Generator for Item, Job and Order Tables
Fill in site, item prefix, job status and date to produce read-only SQL for item master, jobs and open customer order lines.
SyteLine SQL Blocking and Long Running Query Script Generator
Builds read-only SQL Server diagnostic scripts for blocking, head blockers, open transactions and slow requests on a SyteLine database.
SyteLine Custom Table CREATE Script Generator
Creates a SQL Server CREATE TABLE script for a custom SyteLine table that follows the standard column and key conventions.
Infor VISUAL SQL Query Generator for Work Orders
Build a SQL Server query for open or late VISUAL work orders by filling a few fields, then copy it into your query tool.
VISUAL SQL to CSV PowerShell Export Script Generator
Fill in server, database, query and folder to get a ready PowerShell script that exports VISUAL data to a dated CSV for scheduling.
Infor XA DB2 for i SQL Extract Generator
Fill in library, file, columns and filter to get a limited SELECT, a row count check and a CPYTOIMPF command to produce a CSV.
Business Central AL Extension Skeleton Generator
Fill in publisher, prefix and ID range to get app.json, a table extension, a page extension, an event subscriber codeunit and a permission set.
Business Central AL Event Subscriber Generator
Builds an AL subscriber codeunit for any published event, with the correct attribute syntax and a procedure stub to fill in.
Business Central OAuth Token Request Generator
Builds the client credentials token request for Business Central online plus sample REST and OData calls using the returned token.
NetSuite SuiteScript 2.1 RESTlet Skeleton Generator
Fill in a script name, record type and fields to get a SuiteScript 2.1 RESTlet with GET lookup, POST create, logging and error handling.
Acumatica REST API URL Builder
Generate contract-based REST URLs and the login call for any Acumatica entity, with $filter, $select, $expand, $top and $skip filled in for you.
Acumatica Sales Order REST JSON Template
Generate the PUT request URL and JSON body to create a sales order with two lines through Acumatica's contract-based REST API.
Acumatica OData Generic Inquiry URL Builder
Generate the OData URL for an Acumatica generic inquiry, with $filter, $select, $orderby and $top, ready for Excel, Power BI or a script.
Acumatica REST API Python Script Generator
Produce a ready-to-run Python script for the Acumatica contract-based REST API: login, PUT a record, then logout.
Sage Intacct XML readByQuery Request Generator
Build a ready-to-post XML request for the Sage Intacct web services gateway using readByQuery with your object, fields, query and page size.
IFS Cloud Projection OData URL Builder
Fill in host, realm, projection and entity set to generate the token request and a ready OData GET URL for IFS Cloud projections.
QAD Progress 4GL Query Generator
Fill in domain, site and a part prefix to get ready-to-run, read-only Progress 4GL queries against common QAD EE tables.
QAD Progress Connection Parameter File Generator
Generate .pf parameter files for connecting a Progress client to a remote QAD database over TCP.
IFS Applications Oracle SQL Query Generator
Fill in site and part to get read-only Oracle SQL against common IFS Applications views for shop orders, stock and customer orders.
Job Shop WIP and Late Jobs SQL Query Generator
Fill in your table and column names and get ready-to-run SQL for open jobs, late jobs and hours variance.
Odoo XML-RPC BOM Export Python Script Generator
Fill in your Odoo URL, database and filters to get a ready Python script that exports BOMs and component lines to a CSV file.
ERPNext REST API BOM and Stock Query Generator
Build ERPNext REST requests with correct filters and fields for BOMs, stock bins and work orders, ready to paste into curl or Postman.
Katana MRP API Request Builder for Orders and Inventory
Build Katana Open API GET requests for sales orders, manufacturing orders, products and inventory, as curl commands or a Python snippet.
Tally TDL Report Template Generator
Generate a starting TDL file with a menu item, collection and report layout so you can customise Tally Prime reports faster.
Tally XML Export Request Generator
Fill a few fields and get a ready XML envelope to pull masters or vouchers from Tally Prime over its HTTP server.
Tally XML Ledger Import Generator
Build the Import Data XML that creates a customer or supplier ledger in Tally Prime with GST details.
GSTIN Validator Code Generator
Get a Python function that checks GSTIN structure, state code and the mod 36 checksum character before you save a party.
China ERP CSV GBK to UTF-8 Converter Script Generator
Generates a ready-to-run Python script that converts CSV files between GBK, GB18030 and UTF-8 so Chinese ERP imports and exports do not turn into garbled text.
China GL Voucher Trial Balance SQL Generator
Builds a trial balance SQL query by account from a voucher line table, with opening, period movement and closing columns.
SYSPRO SQL Query Generator
Generate read-only SQL Server queries against common SYSPRO tables. Fill in database and filters, then copy the code.
Sage Evolution SQL Query Generator for Stock and Debtors
Builds read-only SQL queries for stock items and customer accounts in a Sage Evolution company database.
Exact Online REST API URL Builder
Generate Exact Online REST API GET requests with the right regional host, division, entity and OData-style query options.
Priority ERP OData REST URL Builder
Build Priority ERP OData URLs with host, tenant, company, entity, $filter, $select, $expand and $top, ready to paste into a REST client.
ERP Selection Scoring SQL Generator
Creates the tables and weighted-average query needed to rank ERP vendors from committee scores, ready for SQL Server or PostgreSQL.
ERP Cutover Reconciliation SQL Generator
Fill in your table and column names and get ready-to-run comparison queries for legacy versus new ERP balances.
ERP Migration File Reconciliation Python Script Generator
Generate a pandas script that compares two CSV extracts by key and writes missing, extra and mismatch files.
ERP Duplicate Master Record Finder SQL Generator
Fill in your master table and match columns to get a ready-to-run SQL query that groups likely duplicates for review.
ERP Master Data Completeness Profiling SQL Generator
Enter a table and up to four columns to get SQL that reports null, blank and placeholder rates for each field.
Inventory Aging Buckets SQL Generator
Build an inventory aging query with your own table and column names and bucket sizes, ready to paste into SQL Server style SQL.
ERP KPI Snapshot to Excel Python Script Generator
Fill in your CSV file name and column names to get a short pandas script that computes KPIs and saves a dated Excel snapshot.
Open Production Operations Load SQL Query Generator
Fill in your table and column names and get ready SQL for remaining hours, past due operations and weekly load per work center.
Critical Ratio Dispatch List Python Script Generator
Get a small Python script that turns an ERP export of open operations into a ranked dispatch list by critical ratio.
OEE SQL Query Generator
Fill in your table and column names and get a SQL query that calculates availability, performance, quality and OEE per line per day.
OEE Power BI DAX Measures Generator
Enter your table and column names and get DAX measures for availability, performance, quality and OEE that you can paste into a Power BI model.
Lean KPI SQL Query Generator (OEE Downtime Pareto)
Fill in your own table and column names to get a downtime Pareto query and an availability query you can run against an MES or ERP reporting database.
Python SPC X-bar R and Capability Script Generator
Fill in your CSV column, subgroup size and spec limits to get a ready Python script for X-bar and R limits, Cp, Cpk, Pp and Ppk.
SQL X-bar and R Subgroup Control Limits Query Generator
Generate a SQL query that computes subgroup averages, ranges, control limits and out-of-limit flags from a table of measurements.
Gage R&R Python Script Generator (Average and Range)
Fill in the file name, tolerance, and get a plain Python script that computes the average and range gage R&R.
Calibration Due List SQL Query Generator
Fill in your table and column names and get SQL for overdue, due soon and never-calibrated gages.
FMEA Risk Ranking SQL Query Generator
Generates ANSI-style SQL for an FMEA table: open high-risk lines, overdue actions, risk roll-up by process step and a cumulative Pareto of RPN.
PPAP Status Tracker SQL Query Generator
Fill in your table and column names and get SQL queries for overdue, pending and rejected PPAP submissions by supplier.
X-bar and R Control Limits Python Script Generator
Set subgroup size, spec limits and file name and get a short Python script that computes control limits, Cpk and Ppk from CSV data.
NCR Pareto and Repeat Offender SQL Generator
Fill in your NCR table and column names to get ready-to-run SQL for a defect Pareto with cumulative percent and a repeat offender list.
NCR Pareto Chart Python Script Generator
Fill in your CSV file name and column headers to get a Python script that builds a Pareto chart of nonconformances from an ERP or QMS export.
CAPA Record JSON Payload Generator
Build a clean JSON payload for a corrective and preventive action record to test an API, seed a sandbox or define an integration contract.
Inspection Results SQL Query Generator
Fill in your own inspection table and column names to generate SQL for lot reject rate by supplier and top failing characteristics.
Supplier PPM and On-Time Delivery SQL Query Generator
Fill in your receipt table and column names to generate a ready-to-run SQL query for supplier reject PPM and on-time delivery.
EDI X12 850 Purchase Order Skeleton Generator
Fill in the partner IDs, PO number and one line item to generate a valid-looking X12 850 test message in 005010 format.
SQL Days of Supply and Coverage Query Generator
Fill in your table and column names to produce a days of supply and below-safety-stock SQL query for any relational ERP database.
SQL Monthly Demand History Query Generator
Generate SQL that turns order or shipment lines into a clean monthly demand history per item, with gap months filled with zero.
Python Holt-Winters Forecast Script Generator
Generate a short Python script that fits Holt-Winters to monthly demand, tests it on a holdout against a naive baseline and writes the forecast to CSV.
MRP Net Requirements SQL Generator
Fill in your table and column names and get a SQL query that computes projected available balance and the shortage per item and bucket.
BOM Low Level Code Python Script Generator
Fill in your CSV file and column names and get a Python script that assigns low level codes and flags circular BOMs.
WMS Bin Inventory and Aging SQL Generator
Build starter SQL for stock by bin, aging buckets and mixed-item bins against your own inventory table, in three SQL dialects.
X12 856 Advance Ship Notice Generator
Fill in shipment, carrier and item details and get a clean X12 856 skeleton with shipment, order and item hierarchy to use as a test file.
Late Purchase Order Lines SQL Generator
Generates a SQL query that lists open PO lines past their promise date with days late, plus a roll-up by supplier. Table names are yours to fill in.
X12 850 Purchase Order EDI Skeleton Generator
Builds a single-line ANSI X12 850 purchase order with ISA, GS, ST, BEG, N1 and PO1 segments you can use as a test file or mapping reference.
Fanuc Bolt Hole Circle Macro Generator
Fill in center, radius, number of holes and drill cycle values and get a ready to review Fanuc macro for a bolt hole pattern.
CNC Program Header and Safe Start Block Generator
Create a consistent program header with revision comments, a safe start line and a tool change sequence for a mill.
Sheet Metal BOM to Material Demand Python Script Generator
Generates a ready-to-run Python script that totals blank weight and estimated sheet count per material and thickness from an exported part list.
Sheet Metal Job Cost Rollup SQL Query Generator
Builds a job cost rollup query over generic job, operation and material tables, with your table and column names filled in.
Welding WPS and Welder Register SQL Generator
Fill in table names and the expiry window to get create-table, insert and expiry-report SQL for a welding register.
Molding Scrap and Cycle Time SQL Query Generator
Generate generic SQL for molding scrap rate by tool and press, cycle time against standard, and mold shot-count maintenance alerts.
Foundry Heat Traceability SQL Query Generator
Build SQL that traces a melt heat forward to castings and heat treat loads, or a casting serial back to its heat and chemistry.
Dimensional Inspection Out-of-Tolerance SQL Query Generator
Fill in your inspection results table and column names to get SQL that finds out-of-tolerance measurements and summarizes them by characteristic.
Recursive BOM Explosion SQL CTE Generator
Builds a recursive common table expression that explodes a multi-level BOM with extended quantities, plus a where-used query, using your own table and column names.
Item UoM Conversion Integrity SQL Query Generator
Three read-only SQL checks for missing, invalid and non-reciprocal item UoM conversion factors using your own table and column names.
Excel CONVERT Function Engineering Unit Formula Generator
Fill a cell reference and two unit codes to get ready-to-paste CONVERT formulas, plus a torque conversion since CONVERT has no torque units.
BOM Cost Rollup Recursive CTE SQL Generator
Name your BOM and cost tables and get a recursive SQL query that explodes a bill of material and rolls up purchased component cost.
Excel Timesheet and Overtime Formula Generator
Creates ready-to-paste Excel formulas for night-shift hours, unpaid breaks, rounding, daily and weekly overtime, and gross pay.
Environmental Permit Expiry Alert SQL Generator
Fill in your table and column names and get a ready SQL query that flags environmental permits due for renewal, for SQL Server and PostgreSQL.
Controlled Item Foreign Shipment SQL Query Generator
Fill in your table and column names to get three audit queries that catch unclassified items, controlled items on foreign orders and expired licenses.
Electronic Component Lot Traceability SQL Generator
Fill in your table and column names to get forward trace, backward trace and quarantine-scope SQL for a component lot or date code.
Pick and Place Centroid File Converter Script Generator (Python)
Fill a few fields and get a Python script that reads a centroid CSV, applies offsets and writes a machine ready file.
PCBA BOM Staging Table and Validation SQL Generator
Create a staging table and validation queries to clean an electronic BOM before loading it into an ERP.
Component Shortage SQL Query Generator (Open Demand vs Supply)
Generate a SQL query that compares open demand against on-hand and inbound supply and returns the shortage list for buyers.
BOM Scrub Python Script Generator (Duplicate MPN, Missing RefDes, Qty Mismatch)
Generate a Python script that reads a BOM CSV and reports duplicate MPNs, blank part numbers, missing reference designators and quantity versus refdes count mismatches.
Fiber Optic Test Results SQL Schema and Pass/Fail Query Generator
Creates a table for insertion loss and return loss results and queries that find failures and yield by wavelength.
Gaussian Beam Spot Size and Rayleigh Range Python Generator
Fill in laser wavelength, M-squared, focal length and input beam diameter to generate a ready-to-run Python script for focused spot size and depth of focus.
Photonics Lot Yield and Test Results SQL Query Generator
Generate SQL queries for lot-level first-pass yield, fallout by test step and a defect Pareto using your own table and column names.
Semiconductor Lot Yield and Bin Pareto SQL Generator
Fill in your table and column names to get ready-to-run SQL for weekly yield, bin Pareto and lowest-yield lots.
Western Electric Rules SPC Python Script Generator
Creates a standalone Python script that reads a CSV column and flags points breaking the four Western Electric run rules.
MRO Open Work Order Aging SQL Generator
Builds a SQL query that groups open maintenance work orders into aging buckets so planners can see what is stuck.
MRO Component Removal Record JSON Generator
Creates a clean JSON payload for a component removal or installation event with life counters, reason and traceability fields.
GS1 GTIN Check Digit and UDI Element String Python Generator
Fill in your GTIN base, lot, expiry and serial and get a ready Python script that calculates the check digit and prints the GS1 human readable and encoded strings.
Device Lot Genealogy and Traceability SQL Generator
Build recursive lot genealogy queries for backward trace (finished device to components) and forward trace (component lot to shipped devices) using your own table and column names.
Pharma Batch Genealogy SQL Query Generator
Fill in plant, material and batch to produce SQL for forward and backward batch traces on SAP material documents.
GxP Audit Trail Entry JSON Generator
Build a structured audit trail record with user, time, change, reason and signature meaning for a regulated integration.
Food Lot Traceability SQL Query Generator (Forward and Backward)
Fill in your table and column names to get recursive SQL that traces a lot back to suppliers or forward to customers.
Automotive EDI 830 Planning Schedule Skeleton Generator
Generate a sample ANSI X12 830 planning schedule with release number, ship-to, part and firm and planning forecast lines to test an EDI mapping.
Warranty Claims Pareto and Months in Service SQL Query Generator
Build SQL for a warranty claims Pareto by failure mode and a months-in-service (MIS) distribution from your own claim table.
Installed Base Warranty Expiry SQL Query Generator
Build a T-SQL query that finds machines whose warranty ends within a chosen window, ready for service contract outreach.
Open PO Missing Mill Certificate SQL Generator
Generate SQL that finds material receipts requiring an EN 10204 certificate where no certificate record exists, so quality can chase suppliers.
Apparel Style Color Size SKU Matrix SQL Generator
Generate T-SQL that creates every color and size SKU for a style, skips rows that already exist, and checks the result for duplicates.
SSCC-18 Pallet Shipping Label ZPL Generator
Fill in ship-to, PO, GTIN, quantity and SSCC to get ZPL for a 4 x 6 inch GS1-128 pallet label.
GST E-Invoice JSON Payload Generator
Builds a sample e-invoice JSON with the main IRP blocks so developers can map ERP fields and test in the sandbox.
ERP Item Master HSN and GST Rate Audit SQL Generator
Enter your item master and invoice line table and column names to get SQL that finds blank HSN codes, wrong digit counts, items with several rates and invoice lines that disagree with the master.
GSTR-1 HSN Summary Pandas Script Generator
Name the columns in your ERP invoice line export and get a pandas script that rolls them up into an HSN-wise summary with quantity, value, taxable value and taxes.
China Unified Social Credit Code Validator Script Generator
Generates a Python script that validates the 18-character check digit of Chinese company registration codes in your vendor master export.
ERP Foreign Currency Revaluation SQL Generator
Generates SQL that picks the latest closing rate on or before the revaluation date, revalues open foreign currency items and summarises unrealised gain or loss by currency.
Sales Tax Exemption Certificate Expiry SQL Generator
Fill in your table and column names to get ready-to-run SQL for SQL Server, PostgreSQL and Oracle that lists certificates expiring soon or already expired.
State Sales Nexus CSV Checker Python Script Generator
Configure your CSV column names and threshold to get a small Python script that flags states close to or over your nexus level.
CFDI 4.0 XML Skeleton Generator
Fill in a form and get a CFDI 4.0 XML skeleton with the right nodes and attributes, ready to adapt for test stamping with a PAC.
Mexico CFDI 4.0 Invoice XML Skeleton Generator
Fill in a few fields and get a CFDI 4.0 ingreso XML skeleton to test your ERP mapping or a PAC sandbox request.
IMMEX Temporary Import Balance Aging SQL Generator
Build a SQL query that shows open temporary-import quantities by pedimento line, days to deadline and overdue status, from your own staging tables.
EU VIES VAT Number Validation SOAP Request Generator
Builds the SOAP envelope for the EU VIES checkVat service so you can validate customer and supplier VAT numbers from an ERP job or script.
UK Trade Tariff API Commodity Lookup URL Builder
Generates the Trade Tariff API URL, curl command and Python snippet to pull a commodity code, its duties and import measures into your ERP.
BOM Compliance Declaration Gap SQL Query Generator
Builds a SQL query and a summary query that list BOM components without a current compliance declaration for a chosen regulation.
Component Declaration Status Python Script Generator
Creates a standard-library Python script that reads a BOM export and a declarations export and writes a gap report CSV.
Contract Expiry and Notice Deadline SQL Query Generator
Generate a SQL query that finds contracts expiring soon and the last day to send a non-renewal notice, using your table and column names.
X12 855 Purchase Order Acknowledgment Skeleton Generator
Builds a correctly structured X12 855 PO acknowledgment (ISA through IEA) with BAK, PO1 and ACK loops so you can test with a trading partner.
Excel Open Order Aging and Late Line Formula Generator
Tell it which columns hold your due date, quantities and ship date, and it writes the Excel formulas for days past due, aging buckets, open quantity and OTD flags.
vLLM Docker Compose Generator for a Private ERP LLM
Fill in the model, context length and GPU count to get a docker-compose file that serves an OpenAI-compatible endpoint inside your network.
Ollama Modelfile Generator for an ERP Assistant
Build a Modelfile that bakes a grounded, read-only ERP system prompt and sane parameters into a local Ollama model.
ERP AI Agent Read-Only SQL Server Role Generator
Create a least-privilege SQL Server login and role for an AI agent, with table grants, sensitive column denies and a row filter by site.
MCP Server Tool Definition JSON Generator
Fill in a tool name, description and one parameter to get a valid MCP tool definition with an inputSchema and behavior annotations.
Claude Desktop MCP Config JSON Generator
Build the mcpServers entry for claude_desktop_config.json with the right command, arguments and environment variables.
OpenAPI Spec Skeleton Generator for ERP Endpoints
Create an OpenAPI 3.0 YAML starting point for an ERP resource with list and get operations, paging and a record schema.
Webhook Payload Template Generator
Design a consistent JSON webhook payload for ERP events, with an idempotency id, versioning and signature header guidance.
ERP Record JSON Schema Generator
Define an item, order or supplier record as JSON Schema with types, patterns, enums and required fields for validation and AI tool input.
Idempotent ERP API Retry Wrapper Python Generator
Fill in your header names and limits to get a Python function that retries safely with backoff and sends an idempotency key on writes.
Webhook HMAC Signature Verification Node.js Generator
Create an Express endpoint that checks the HMAC of the raw body, rejects stale timestamps and acknowledges quickly for ERP event webhooks.
Paginated OData Fetch Loop Python Generator
Build a Python loop that follows nextLink pages from an OData entity set and writes the result to CSV with a hard row cap.
ERP MCP Server Python Tool Skeleton Generator
Get a runnable Python MCP server with one read-only ERP lookup tool, argument validation and errors that the model can understand.
Agent SQL Read-Only Guard Python Generator
Add a first line of defense before agent-written SQL reaches an ERP database: single statement, SELECT only, allow-listed tables and a row cap.
WhatsApp Template Message Builder
Generates the JSON to create a WhatsApp message template and the JSON to send it, with header, body variables, footer and a quick reply button.
Teams Adaptive Card JSON Generator for Approvals
Creates an Adaptive Card approval message with a fact set, comment input and Approve and Reject actions, wrapped for a Teams webhook or Workflows post.
Slack Block Kit Approval Message Generator
Creates a chat.postMessage body with Block Kit sections, fields and Approve and Reject action buttons for ERP approval workflows.
Webhook Signature Verification Code Generator
Generates an Express.js webhook endpoint with the Meta GET verification handshake and constant time HMAC SHA256 signature checks.
WhatsApp Cloud API Send Template Request Generator
Builds the Graph API request, JSON payload and a Python equivalent for sending an approved template with up to three body variables.
ERP Event Messaging Outbox Table SQL Generator
Creates outbox table DDL, an insert example and a safe worker claim query so ERP events reach messaging channels exactly once in practice.
Tesseract OCR Command Line Generator
Build the exact tesseract command for a single file and a PowerShell loop for a whole folder, with language, page segmentation mode, resolution and output format set from a form.
Invoice Field Regex Generator (Python)
Set the labels your suppliers use and get a Python script with regexes for invoice number, PO number, invoice date and total amount, plus a total check.
Invoice Extraction JSON Schema Generator
Create a JSON Schema that defines and validates the structure of extracted invoice data, including header fields, line items, confidence scores and review flags.
X12 ISA GS Envelope Skeleton Generator
Fill in sender, receiver, qualifiers and control numbers and get a matching envelope to test a translator or a partner connection.
SQL Date Range Filter Generator
Builds a correct half-open date range WHERE clause for four SQL dialects, so month-end and timestamp reports stop dropping the last day.
ERP Data Extract PowerShell to CSV Script Generator
Creates a scheduled-task-ready PowerShell script that runs a read-only SQL query and writes a timestamped CSV with a simple log.
Excel to SQL INSERT Statement Generator
Build INSERT statements from spreadsheet rows, with an Excel formula that creates the value lists and a rollback-safe wrapper.
ERP Incremental Extract Watermark SQL Generator
Generate a T-SQL script that pulls only new and changed ERP rows using a watermark control table.
SQL Running Total and Window Function Query Generator
Fill in your table and column names to get running total, previous-row change and top-N per group queries using window functions.
SQL Server Blocking and Deadlock Diagnostic Script Generator
Generate T-SQL to list blocked sessions, find the head blocker and its SQL text, spot idle open transactions and read recent deadlock graphs.
SQL Monthly Pivot Query Generator (Conditional Aggregation)
Build a month-by-month cross-tab of any ERP amount, such as usage by item or sales by customer, using portable CASE and SUM logic.
SQL Server ERP Backup Script Generator
Fill in the database name, backup folder and retention to get a T-SQL script with checksum, compression, verification and backup history cleanup.
Active Directory Stale Account Report PowerShell Generator
Generate a PowerShell script that finds inactive AD users and computers and accounts with non-expiring passwords, then exports the results to CSV for an access review.
SIEM Failed Logon Detection KQL Query Generator
Fill in a time window and thresholds and get ready-to-paste KQL for Microsoft Sentinel or Log Analytics covering password guessing and common tampering events.
PowerShell Windows Host Security Audit Script Generator
Produce a read-only script that gathers local administrators, listening ports, installed updates and scheduled tasks from a list of servers into CSV files.
Plant Monthly Business Review SQL Generator
Fill in schema and table names and get four SQL queries for monthly review KPIs: on-time delivery, scrap rate, aged WIP and completed units by week.
SyteLine IDO Extension Class Method Generator
Fill in the IDO, method and load details and get a complete C# extension class with a hand-coded method, a request-object variant and the deployment steps.
SyteLine IDO Custom Load Method Generator
Get a working C# custom load method that returns a DataTable of late customer order lines, the IDO metadata steps to expose it, and a REST call to test it.
SyteLine Form Script Generator
Fill in the form, IDO, properties and target variable to get a VB form script method for SyteLine 9/10 that loads related data and shows it on the form.
SyteLine Custom Stored Procedure IDO Method Generator
Build a SyteLine-style stored procedure with typed parameters, @Infobar messaging and a severity return code, then test it and publish it as an IDO method.
SyteLine EXTGEN Stored Procedure Generator
Create a documented extgen_ override for a base SyteLine procedure and audit existing overrides against their base procedures after each update.
SyteLine IDO SOAP Web Service Client Generator
Generate a working C# console client and a PowerShell equivalent for the Mongoose IDO SOAP web service on on-premises SyteLine.
SyteLine ION API IDO Request Generator
Turn a .ionapi backend service file into working PowerShell and curl calls that load SyteLine IDO data through ION API, including bookmark paging.
SyteLine Mongoose .NET Client Generator
Generate an external C# program that logs on through the Mongoose .NET client library and loads SyteLine IDO data, with custom load and nested load options.
SyteLine Material Transaction History Query Generator
Build SQL Server queries over SyteLine material transactions for detail history, monthly usage by item and decoding the transaction codes in your data.
SyteLine Inventory Aging Query Generator
Build a SQL Server inventory aging report for SyteLine 9/10 with your own day buckets, valued at item unit cost, plus a lot-based option.
SyteLine Open Purchase Order Query Generator
Builds a read-only SQL query for open and late PO lines in SyteLine 9/10, with a second query for vendor on-time delivery from PO receipts.
SyteLine Incremental Extract Query Generator
Writes the watermark table, delta SELECT, watermark update, delete detection and MERGE for loading one SyteLine table into a staging database with SSIS or any ETL tool.
SyteLine Background Task History Query Generator
Writes read-only SQL against BGTaskHistory and ActiveBGTasks to find failed reports and tasks, slow tasks, stuck queue entries and submissions that never got a history record.
SyteLine Users and Groups Query Generator
Read-only SQL for SyteLine security reviews: user to group membership, users with no group, group member counts and the authorization rows for one form.
Infor LN 4GL Database Insert/Update Transaction Generator
Fill in table, key and fields to get a Baan/LN function that locks the record, writes it with db.retry, commits, and aborts cleanly on error.
Infor LN 4GL Embedded SQL Select Generator
Fill in a table, columns and a where clause and get a Baan / Infor LN embedded SQL select loop with host variables, index ordering and selectempty and selecterror handling.
Infor LN DAL Script Template Generator
Generate a Data Access Layer (DAL) script skeleton for an LN table with object hooks, a field check hook, a mandatory hook and error message handling.
Infor LN User Exit (UE) DLL Template Generator
Generate a User Exit DLL for an LN table that adds your own logic around the standard save and delete handling, without changing standard code.
Infor LN AFS (stpapi) Session Automation Script Generator
Generate Application Function Server (AFS) functions that insert, update and delete records through a standard LN session without its user interface.
Infor LN Report Script Template Generator
Generate a 4GL report script for an LN report with program sections, layout sections, a suppress condition and a running total.
Infor LN ION API OAuth 2.0 REST Call Generator (Python)
Generate a Python script that authenticates with an ION API .ionapi service account file and calls an LN REST or OData service, with clear error handling.
Infor LN Inbound Process.SalesOrder BOD XML Template
Generate an OAGIS ProcessSalesOrder BOD skeleton with ApplicationArea, ActionCriteria, a sales order header and order lines for testing LN inbound orders.
Infor M3 EXPORTMI Select Query Generator
Fill in table, columns and filter to get a working EXPORTMI Select call for M3 13.x on-prem, plus a Python loop that pages by key range past the 10,000 record cap.
Infor M3 H5 Script TypeScript Template Generator
Generate a starting H5 script class that reads a field on an M3 panel, calls an MI transaction and shows the answer on the panel, on load or before Enter.
Infor M3 ION API Gateway OAuth 2.0 Python Client Generator
Generate a Python script that loads your .ionapi credentials file, gets and reuses an OAuth 2.0 token, and calls an M3 MI transaction through the on-prem ION API Gateway.
Infor M3 CSV to MI API Bulk Loader Script Generator
Generate a Python loader that reads a CSV, maps columns to MI fields, calls one M3 transaction per row and writes a result file with the M3 message for every failed row.
Infor XA IBM i SQL Services Health Query Generator
Fill in your XA library, thresholds and subsystem and get five ready-to-run Db2 for i queries for file size, reorganise candidates, inactive users, active XA jobs and history file growth.
Infor System21 DB2 for i SQL Query Generator (Orders, Stock, Customers)
Fill in your System21 libraries and field names and get read-only SQL for order header to line joins, orders with customer names, stock by stockroom, item lookups and locked records.
Infor LX / BPCS SQL Query Generator (Open Orders, Inventory, History)
Fill in your library, warehouse, item and field names to get ready-to-run Db2 for i SQL for the BPCS reports people ask for most.
Infor Lawson S3 DME Data Query URL Generator
Fill in product line, file, fields, index, key and select condition to get a working Lawson DME data query URL, with curl and PowerShell versions.
Infor Lawson S3 AGS Transaction Call Generator
Fill in the product line, form token, event, function code and form fields to get a Lawson Transaction (AGS) call URL you can test in a non-production product line.
Infor Lawson S3 GLAMOUNTS Trial Balance SQL Generator
Fill in company, fiscal year and period to get ready-to-run SQL for Lawson S3 GL balances from GLAMOUNTS and GLUNITS, with a GLTRANS reconciliation query.
Infor ION API Gateway OAuth Token Request Generator (.ionapi)
Turn the values in a downloaded .ionapi file into code that requests a token from the Infor authorization server, calls the ION API Gateway and revokes the token.
Infor ION BOD XML Shell Generator
Pick a verb and noun and get a correctly structured Infor OAGIS BOD envelope for ION, with the matching Acknowledge and ConfirmBOD skeletons.
Infor Data Lake Compass SQL API Request Generator
Fill in your ION API base URL, tenant and SQL to get working Python and curl code for the Compass v2 job, status and paged result calls.
SAP ECC Background Job History ABAP Query Generator (TBTCO + TBTCP)
Fill in a job name pattern, program, status and date range and get a classic ABAP report that joins TBTCO and TBTCP, computes runtime, reads the job log of cancelled jobs and shows the result in ALV.
SAP ECC Background Job Creation ABAP Generator (JOB_OPEN, SUBMIT, JOB_CLOSE)
Generate working ABAP that opens a job, submits a program with a variant and step user to a spool printer, and releases it immediately, at a date and time, or after an event.
SAP ECC IDoc Segment Data Reader ABAP Generator (EDIDC, EDID4, EDIDS)
Choose a message type, basic type, segment and field, and get an ABAP report that lists IDocs, the value of that segment field and the last status message text.
SAP ECC Custom Inbound IDoc Function Module Skeleton Generator
Generate a ready-to-adapt inbound IDoc function module for a custom message type and segment: standard interface, segment cast, validation, status 51 or 53, workflow return variables and the configuration steps.
SAP ECC BAPI_SALESORDER_CHANGE ABAP Generator
Generate a working ABAP program that updates an SAP sales order with BAPI_SALESORDER_CHANGE, with the correct X structures, schedule line handling, error check and commit or rollback.
SAP ECC BAPI_PO_CHANGE ABAP Generator
Generate a working ABAP program that changes an SAP purchase order item with BAPI_PO_CHANGE, with POITEM/POITEMX, schedule line date conversion, test run and commit handling.
SAP ECC BAPI_MATERIAL_SAVEDATA Material Creation ABAP Generator
Fill in material type, plant, sales and valuation data and get a complete ABAP report that creates the material with BAPI_MATERIAL_SAVEDATA and commits it.
SAP ECC BAPI_ACC_DOCUMENT_POST G/L and Vendor Posting ABAP Generator
Enter company code, dates, accounts and amount to get an ABAP report that checks or posts a G/L or vendor invoice document with BAPI_ACC_DOCUMENT_POST.
SAP ECC Condition Record Query ABAP Generator (Axxx Condition Tables + KONP)
Pick the application, condition table, condition type and key values to get ABAP that returns the valid condition records with rate, unit, validity and scales.
SAP ECC Table Structure and Message Text Query Generator (DD03L, DD04T, T100)
Choose a mode to generate a query that lists a table's fields with labels, finds transparent tables by description, or returns a message text from T100.
SAP ECC Transaction Usage Statistics ABAP Generator (SWNC_COLLECTOR_GET_AGGREGATES)
Generate a report that loops over months, weeks or days of ST03N workload data and ranks transaction codes and reports by steps, users and response time.
SAP ECC Stock/Requirements List ABAP Generator (MD_STOCK_REQUIREMENTS_LIST_API)
Enter material, plant or MRP controller and a horizon to get a report that prints the MD04 stock/requirements list, optionally only lines with exception messages.
SAP ECC Cost Center and Order Plan/Actual Cost ABAP Generator (COSP, COSS)
Enter controlling area, cost center or order, year, periods and version to get a report that sums plan and actual costs per cost element from COSP and COSS.
SAP ECC Cost Center Hierarchy and Group ABAP Generator (SETHEADER, SETNODE, SETLEAF)
Choose set class, controlling area or chart of accounts and the top node to get ABAP that prints the full group tree, expanding cost center ranges with names.
SAP ECC Order System Status ABAP Generator (JEST, TJ02T, STATUS_TEXT_EDIT)
Fill in plant, order type and the statuses to include and exclude, and get a working ABAP report that reads AUFK, JEST, TJ02T and TJ30T and prints the status line with STATUS_TEXT_EDIT.
SAP ECC SD Document Flow ABAP Generator (VBFA, VBUK, VBUP)
Enter a sales order and the follow-on document categories you want, and get an ABAP report that reads VBFA from order to delivery to invoice and goods movement, with VBUK and VBUP status.
SAP ECC BAdI Implementation Method Code Generator (ME_PROCESS_PO_CUST, MB_MIGO_BADI, WORKORDER_UPDATE)
Pick a plant, the field that must be filled and your message class, and get ready-to-paste method code for three common ECC classic BAdIs, with the SE19 steps.
SAP ECC Batch Characteristics Read/Update ABAP Generator (BAPI_OBJCL_GETDETAIL, BAPI_OBJCL_CHANGE)
Enter material, batch, plant, batch class and characteristic, and get an ABAP report that builds the correct MCH1 or MCHA object key, reads the batch classification and optionally changes one value with commit or rollback.
SAP GUI Scripting Script Generator (Python win32com)
Builds a runnable Python script that drives SAP GUI for Windows through the SAP GUI Scripting API: connect, log on to a client, call a transaction, set a field and capture the result.
ABAP Selection Screen and SELECT-OPTIONS Generator
Builds a complete ABAP report with a framed selection screen, two SELECT-OPTIONS, a parameter, radio buttons that hide a field, event blocks, validation, an optional option restriction and an ALV output.
ABAP CDS Table Function with AMDP Generator
Builds the three parts of a CDS table function: the DDL definition with client handling and parameters, the AMDP class with SQLScript, and the ABAP SQL call that consumes it.
SAP Gateway SEGW DPC_EXT CRUD Methods Generator (ABAP)
Fill in your SEGW project, entity set and backend table and get the five redefined DPC_EXT methods for an OData V2 service, with $filter, $top, $skip and $inlinecount handled.
SAP BW Process Chain API ABAP Generator (RSPC_API_CHAIN_START)
Generate an ABAP report that starts a process chain through the RSPC API, polls its status until green or red, interrupts a schedule, or lists scheduled chains.
SAP BW Transformation Routine Generator (Start, End, AMDP)
Generate the body of a BW transformation start routine, end routine with an ADSO lookup, field routine, or the equivalent AMDP SQLScript routines for HANA push-down.
SAP Business One AR Aging SQL Query Generator (SQL Server and HANA)
Generate a customer receivables aging query for SAP Business One Query Manager, with your own bucket days and aging basis, in SQL Server and HANA syntax.
SAP Business One Formatted Search (FMS) Query Generator
Generate ready-to-save formatted search queries for marketing documents: last sale price for this customer and item, available stock in the row warehouse, customer balance and an item UDF default.
SAP Business One Pending Approvals Query Generator (OWDD, WDD1)
Generate a query that lists approval requests waiting on each approver, with the draft, template, stage and age, plus a query that documents your approval templates and stages.
SAP Business One Service Layer $batch Request Generator
Generate the raw HTTP for a Service Layer session: Login, a $batch with a changeset that deletes, updates or creates several records in one transaction, and Logout.
Oracle EBS OE_ORDER_PUB.PROCESS_ORDER Script Generator
Fill in your IDs and get a complete PL/SQL anonymous block that creates a sales order with one line through OE_ORDER_PUB.PROCESS_ORDER, prints every API message and optionally books the order.
Oracle EBS FND_REQUEST.SUBMIT_REQUEST Code Generator
Fill in user, responsibility, program and arguments and get a PL/SQL block that submits a concurrent request from the database, optionally adds an XML Publisher layout and waits for completion.
Oracle EBS PL/SQL Concurrent Program Generator (Package plus FND_PROGRAM Registration)
Generates a PL/SQL concurrent program package (errbuf, retcode, date parameter, CSV output, error backtrace) and the FND_PROGRAM calls that register the executable, program, parameters, request group and incompatibility.
Oracle EBS Concurrent Program Parameters and Responsibility SQL Generator
Three SQL queries for any concurrent program: definition and executable, parameters in order with value sets and defaults, and the request groups and responsibilities that can submit it.
Oracle EBS FND_USER_PKG Script Generator (Create User, Add Responsibility, Reset Password)
Generates four FND_USER_PKG blocks for Oracle EBS R12 (CREATEUSER, ADDRESP, CHANGEPASSWORD, DELRESP) plus SQL to verify the user and responsibility rows.
Oracle EBS Item Import Script Generator (MTL_SYSTEM_ITEMS_INTERFACE and INCOIN)
Generates interface inserts for a master and child organization, the Import Items (INCOIN) submission, error SQL against MTL_INTERFACE_ERRORS and a check query for created items.
Oracle EBS Workflow Error and Notification SQL Generator
Generate the five queries and the PL/SQL retry block a workflow administrator needs: errored activities, open notifications, mailer backlog, deferred queue and retry.
Oracle EBS XML Publisher Data Template Generator
Fill in your query, parameters and elements and get a valid XML Publisher data template, its PL/SQL default package and the registration steps for R12.
Oracle EBS Value Set, Lookup and DFF SQL Generator
Generate the queries that read value set definitions and values, rebuild a table-validated LOV, list FND lookup codes and map DFF segments to ATTRIBUTE columns.
Oracle EBS TCA Customer Creation API Script Generator (HZ V2 APIs)
Generate one PL/SQL block that creates an organization customer with account, address and bill-to and ship-to site uses through the public TCA V2 APIs.
Oracle EBS Integrated SOA Gateway REST Service Call Generator (curl)
Generate working curl commands for a PL/SQL API deployed as a REST service through Oracle EBS 12.2 Integrated SOA Gateway, with the RESTHeader context.
JD Edwards Orchestrator and AIS REST Call Generator
Fill in your AIS host, orchestration name and inputs to get a working Python requests script and curl commands that call a JD Edwards EnterpriseOne 9.2 orchestration.
JD Edwards Orchestrator Groovy Custom Request Script Generator
Generate a Groovy custom service request for JD Edwards Orchestrator that reads delimited text from an input, returns it as an array of rows and logs to the AIS Server log.
JD Edwards UDC Lookup SQL Generator (F0004, F0005)
Generate SQL that lists JD Edwards UDC types and values, decodes a code in a business table with the correct trim on DRKY, and reads alternate language descriptions.
JD Edwards F0911Z1 Journal Entry Batch Input SQL Generator
Generate a balanced pair of F0911Z1 batch journal entry rows with implied decimals handled, a verification query and the processing steps for R09110Z.
JD Edwards Received Not Vouchered SQL Generator (F43121, F4311)
Generate SQL that lists JD Edwards receipts still open for vouchering, with PO line detail, supplier name and supplier totals to reconcile against the AAI 4320 account.
JD Edwards C Business Function Skeleton Generator
Generate the .h and .c skeleton of a JD Edwards EnterpriseOne C business function that reads one table record by key, returns a value and sets an error correctly.
JD Edwards F3002 Multi-Level BOM Explosion SQL Generator
Generate an Oracle recursive SQL query that explodes a JD Edwards bill of material from F3002 level by level, plus a check of a work order parts list in F3111.
JD Edwards World F0011 Batch Control Status SQL Generator (Db2 for i)
Generate Db2 for i SQL that lists F0011 batch headers by type, status and date, decodes status through UDC 98/IC and counts unposted F0911 lines per batch.
PeopleSoft Portal Navigation Path SQL Generator (PSPRSMDEFN)
Generate SQL that walks the portal registry from a component up to the root to print its navigation path, plus queries showing which roles and users can reach it.
PeopleSoft PeopleCode SQLExec, CreateSQL Fetch and Try-Catch Snippet Generator
Fill in a record, key field and message set and get ready-to-paste PeopleCode for SQLExec, CreateSQL Fetch loops, try-catch error handling, MsgGet and rowset loops.
PeopleSoft Component Interface PeopleCode Generator
Generate the standard PeopleCode to open a Component Interface, Get or Create a key, set properties, Save with PSMessages error handling, plus a CallAppEngine example.
PeopleSoft REST Service Operation Request Generator (RESTListeningConnector)
Generate the exact /PSIGW/RESTListeningConnector URL, HTTP request, curl command and OnRequest handler skeleton for a PeopleSoft REST service operation.
Oracle Essbase Calc Script Generator (FIX, AGG, CALC DIM, DATAEXPORT)
Fill in your FIX members, dense and sparse dimensions, threads and export path to get a working block storage calc script with a level-0 DATAEXPORT and the MaxL line that runs it.
Oracle Essbase MDX Query Generator
Generate Essbase MDX queries with column sets, row descendants, a slicer tuple, NON EMPTY suppression and a WITH MEMBER variance, plus ASO member formula patterns.
Oracle Essbase Report Script Generator
Generate a Report Writer script that produces a clean, tab-delimited flat file from Essbase, and the MaxL command that runs it.
Oracle Essbase 21c REST API Request Generator
Fill in host, application, cube, calc script and data file to get ready-to-run REST calls for Essbase 21c: list, upload, calc job, dataload job and status polling.
Oracle Agile PLM SDK Java Snippet Generator (Items and BOM)
Fill in the Agile URL, user and item number to get compilable Java that logs in with AgileSessionFactory, reads an item description and walks its BOM, plus a Process Extension custom action.
Oracle Database 19c AWR Report and Top SQL Generator
Fill in a time window and schema to get a ready SQL*Plus script: AWR HTML report, top SQL, largest segments and monthly growth from DBA_HIST views.
Oracle Database 19c AutoUpgrade Config File Generator
Fill in homes, SID and options to get a working AutoUpgrade config file and the analyze, fixups and deploy commands for a 12c to 19c upgrade.
NetSuite REST API SuiteQL Request Generator
Turn a SuiteQL statement into a ready POST to the REST query/v1/suiteql endpoint, plus curl and a Python script that pages through every result.
NetSuite REST API Sales Order and Journal Entry Request Generator
Fill in IDs and amounts to get correct record/v1 JSON for a sales order, a two-line journal entry, a sales order to invoice transform and a C# call.
NetSuite Token-Based Auth OAuth 1.0 Signature Code Generator
Get dependency-free Python and Node.js code that builds a valid NetSuite TBA Authorization header for a RESTlet or REST web services call, then sends it.
NetSuite OAuth 2.0 Client Credentials (M2M) JWT Code Generator
Generate the openssl commands, the signed JWT client assertion and the token request for NetSuite machine-to-machine OAuth 2.0, in Python and Node.js.
SuiteScript 2.1 Scheduled Script Generator for NetSuite
Generate a restartable scheduled script that processes a saved search in internal ID order, checks remaining usage and resubmits itself before hitting the 10,000-unit limit.
SuiteScript 2.1 Client Script Generator for NetSuite
Generate a working client script for a transaction or customer form: field checks, line validation with a dialog, sublist totals and a save guard, exporting only the entry points you pick.
SuiteScript 2.1 Suitelet Form Generator for NetSuite
Describe the filter fields and a SuiteQL query and get a working Suitelet that renders a NetSuite-styled form, runs the query on submit and lists the results.
NetSuite SuiteScript N/query runSuiteQLPaged Snippet Generator
Paste a SuiteQL statement and get SuiteScript 2.1 code that runs it with bound parameters, single-shot or paged, with a governance check.
NetSuite Workflow Action Script Generator (SuiteScript 2.1)
Generate a working workflow action script that reads a threshold parameter, looks up an approver and returns a value your workflow can store in a field.
IBM i RPGLE Fully Free Program Skeleton Generator (SQL, MONITOR)
Fill in your table and columns and get a complete fully free ILE RPG program that reads rows with an SQL cursor, handles SQL and runtime errors, and compiles with one CRTSQLRPGI command.
IBM i RPGLE Service Program Generator (NOMAIN, Binder Source, CRTSRVPGM)
Generate a complete ILE RPG service program kit: NOMAIN module with exported procedures, prototype copybook, binder source with a signature, binding directory and the CL to build and call it.
Checklists
Messaging Integration Go Live Readiness Checklist
A launch checklist for ERP to WhatsApp, Teams or Slack integrations covering consent, throughput, failure handling, monitoring and support.
ERP Database Health Check Checklist
A quarterly checklist for the database under your ERP: recovery, integrity, performance, capacity, security and operations.
SyteLine Mongoose Customization Deployment Checklist
Dev to test to production promotion checks for Mongoose forms, IDO metadata, extension class assemblies, SQL objects, events and reports on SyteLine 9 and CSI 10.
SyteLine Event System Troubleshooting Checklist
Checks for event handlers in SyteLine 9 and CSI 10 that do not fire, fire twice or hang, from event name and flags to runtime services and action outcomes.
SyteLine IDO API Security Hardening Checklist
Accounts, transport, tokens, request hygiene and monitoring checks for exposing the SyteLine IDO request service (REST and SOAP) to integrations and scripts.
Infor ION On-Premises Grid and Connector Health Checklist
A periodic health check for ION running on the Infor Grid on premises: grid, ION services, monitoring, security and recovery readiness.
SAP ECC User Exit (CMOD/SMOD) Implementation Checklist
Find the right exit, decide between customer exit, form user exit, BAdI or BTE, then implement, activate, transport and test a CMOD project in SAP ECC.
SAP ECC IDoc Extension and Custom Segment Checklist (WE31, WE30, WE82)
Design, build, fill, configure and test a custom IDoc segment in SAP ECC: WE31, WE30, WE82, user exits, WE20 partner profiles and WE19.
SAP Business One DI API Connection Troubleshooting Checklist
Work through installation, Company connection properties, error handling, environment and runtime checks when an SAP Business One DI API Connect call fails.
SuiteScript 1.0 to 2.1 Migration Checklist for NetSuite
A five-stage checklist for moving NetSuite scripts from SuiteScript 1.0 to 2.1: inventory, design, code changes, deployment cutover and testing.
Assessments
ERP Agent API Integration Readiness Assessment
Answer ten questions about APIs, roles, limits and logging to see whether your ERP is ready for an AI agent or MCP integration.
ERP Reporting Query Quality Assessment
Answer 10 questions about how your team writes, tests, documents and runs SQL reports on ERP data, and get a score with recommendations.