← Back to Products

Troubleshooting Toolkit

Starting at$999.00/yr
Essentials$999.00/yr
Select$1,299.00/yr
Prime$1,499.00/yr
Enterprise$1,999.00/yr
as determined by your Acumatica license
Releases
26 R2 26 R1 25 R2
UI
Modern
Get Started

A set of admin tools for the jobs Acumatica’s UI doesn’t cover — browsing the server, loading data straight into tables, and querying the database — all from one Modern UI screen. No RDP session or SQL Server Management Studio access required, which makes it just as handy for a partner supporting a customer’s instance as for the admin who runs it.

Server File Explorer

  • Browse the site’s folders and files from the browser
  • See which customization package(s) added each file (e.g. *.dll files in \bin)
  • Download files (up to 100 MB)
  • Deleting is limited to the Toolkit’s own working folder, so nothing else on the server can be removed

Data Loader

  • Import a CSV or Excel (XLSX) file directly into any database table
  • Map file columns to table columns, or fill a column with a constant value
  • Validate before importing — Import stays disabled until validation passes
  • Bad rows are rejected individually and written to a downloadable file with their original line numbers
  • Optionally update existing records with matching keys — created-by info and NoteIDs are preserved, so notes, attachments, and activities stay attached
  • Optionally fill Acumatica system columns (CompanyID, created/modified audit fields, NoteID)
  • Choose all-or-nothing or load-what-passes, commit in batches, enforce constraints, and reset application caches afterward

Dynamic SQL Query

  • SQL editor with syntax highlighting and one-click formatting
  • Every query is syntax-checked and risk-rated before it can run; destructive statements require explicit confirmation, and every execution is logged with the user’s name
  • Edit results right in the grid and write them back, with a preview of each change and the generated UPDATE statement before committing
  • Write-back is only offered for single-table results with a primary key, and runs as one transaction — if any row has changed since it was read, the whole batch rolls back
  • Hidden by default so it isn’t stumbled onto — ask me how to enable it
Effort to install / configure: ●◌◌◌◌
A power tool: The guardrails above reduce the chance of a mistake, but they don’t replace a backup. The screen carries a standing notice that by using it you accept the risks and all liability for the outcome — try it in a sandbox first.

Tenant visibility: Dynamic SQL Query and the Data Loader talk to the database directly, which bypasses Acumatica’s tenant isolation. Anyone with access to this screen in one tenant can use the query to see — and change — data in every other tenant on the same instance, and the Data Loader to load rows into any of them. Grant access to this screen accordingly.

Licensed per Acumatica instance and tenant.