{"id":1142,"date":"2026-10-27T12:48:41","date_gmt":"2026-10-27T16:48:41","guid":{"rendered":"https:\/\/deftstrokesdev.com\/?page_id=1142"},"modified":"2026-11-03T14:42:39","modified_gmt":"2026-11-03T19:42:39","slug":"troubleshooting-toolkit","status":"publish","type":"page","link":"https:\/\/deftstrokesdev.com\/index.php\/products\/troubleshooting-toolkit\/","title":{"rendered":"Troubleshooting Toolkit"},"content":{"rendered":"\n<a href=\"\/index.php\/products\/\" class=\"ds-product__back-link\">\u2190 Back to Products<\/a>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-995f960e wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\t\t<div class=\"gutenverse-popup-gallery hidden popup-guten-Tk7rWq\">\n\t\t\t<div class=\"gallery-header\">\n\t\t\t\t<div class=\"left-header\"><\/div>\n\t\t\t\t<div class=\"right-header\">\n\t\t\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\" class=\"icon-fullscreen\"><path d=\"M8 3H5a2 2 0 0 0-2 2v3m18 0V5a2 2 0 0 0-2-2h-3m0 18h3a2 2 0 0 0 2-2v-3M3 16v3a2 2 0 0 0 2 2h3\"><\/path><\/svg>\n\t\t\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\" class=\"icon-minimize hidden\"><path d=\"M8 3v3a2 2 0 0 1-2 2H3m18 0h-3a2 2 0 0 1-2-2V3m0 18v-3a2 2 0 0 1 2-2h3M3 16h3a2 2 0 0 1 2 2v3\"><\/path><\/svg>\n\t\t\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\" class=\"icon-zoom\"><circle cx=\"11\" cy=\"11\" r=\"8\"><\/circle><line x1=\"21\" y1=\"21\" x2=\"16.65\" y2=\"16.65\"><\/line><line x1=\"11\" y1=\"8\" x2=\"11\" y2=\"14\"><\/line><line x1=\"8\" y1=\"11\" x2=\"14\" y2=\"11\"><\/line><\/svg>\n\t\t\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\" class=\"icon-close\"><line x1=\"18\" y1=\"6\" x2=\"6\" y2=\"18\"><\/line><line x1=\"6\" y1=\"6\" x2=\"18\" y2=\"18\"><\/line><\/svg>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t<div class=\"gallery-body\">\n\t\t\t\t<div class=\"images\">\n\t\t\t\t\t<div id=\"guten-Tk7rWq\" class=\"swiper-container\">\n\t\t\t\t\t\t<div class=\"swiper-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"swiper-slide image-list image-list-0\" data-filter=\"One\" data-title=\"One\" data-category=\"\" data-content=\"\" data-index=\"0\">\n\t\t\t\t\t\t\t\t\t<div class=\"content-image swiper-zoom-container\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" class=\"main-image\" src=\"https:\/\/deftstrokesdev.com\/wp-content\/uploads\/2026\/10\/troubleshootingToolkit1.gif\" alt=\"One\" height=\"1140\" width=\"1824\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"swiper-slide image-list image-list-1\" data-filter=\"Two\" data-title=\"Two\" data-category=\"\" data-content=\"\" data-index=\"1\">\n\t\t\t\t\t\t\t\t\t<div class=\"content-image swiper-zoom-container\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" class=\"main-image\" src=\"https:\/\/deftstrokesdev.com\/wp-content\/uploads\/2026\/10\/troubleshootingToolkit2.png\" alt=\"Two\" height=\"1140\" width=\"1824\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"swiper-slide image-list image-list-2\" data-filter=\"Three\" data-title=\"Three\" data-category=\"\" data-content=\"\" data-index=\"2\">\n\t\t\t\t\t\t\t\t\t<div class=\"content-image swiper-zoom-container\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" class=\"main-image\" src=\"https:\/\/deftstrokesdev.com\/wp-content\/uploads\/2026\/11\/toolkit_DynamicSql1.gif\" alt=\"Three\" height=\"1140\" width=\"1824\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"swiper-slide image-list image-list-3\" data-filter=\"Four\" data-title=\"Four\" data-category=\"\" data-content=\"\" data-index=\"3\">\n\t\t\t\t\t\t\t\t\t<div class=\"content-image swiper-zoom-container\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" class=\"main-image\" src=\"https:\/\/deftstrokesdev.com\/wp-content\/uploads\/2026\/11\/toolkit_DynamicSql2.gif\" alt=\"Four\" height=\"1140\" width=\"1824\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"swiper-slide image-list image-list-4\" data-filter=\"Five\" data-title=\"Five\" data-category=\"\" data-content=\"\" data-index=\"4\">\n\t\t\t\t\t\t\t\t\t<div class=\"content-image swiper-zoom-container\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" class=\"main-image\" src=\"https:\/\/deftstrokesdev.com\/wp-content\/uploads\/2026\/11\/toolkit_DynamicSql3.png\" alt=\"Five\" height=\"1140\" width=\"1824\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"swiper-button-prev\"><\/div>\n\t\t\t\t\t\t<div class=\"swiper-button-next\"><\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\t\t\n\t\t<div class=\"gallery-items\" data-loaded=\"5\" data-more=\"2\" data-max=\"5\" >\n\t\t\t\t\t\t\t<div class=\"gallery-item-wrap \" data-index=\"0\" data-control=\"One\">\n\t\t\t\t\t<div class=\"grid-item\"><div class=\"thumbnail-wrap\" style=\"--guten-gallery-thumbnail-ratio:1824 \/ 1140;\"><img decoding=\"async\" class=\"main-image\" src=\"https:\/\/deftstrokesdev.com\/wp-content\/uploads\/2026\/10\/troubleshootingToolkit1.gif\" alt=\"One\" height=\"1140\" width=\"1824\" \/><div class=\"caption-wrap style-overlay overlay-overlay \"><div class=\"item-hover-bg\"><\/div><div class=\"item-caption-over\"><h5 class=\"item-title\">One<\/h5><div class=\"item-content\"><\/div><div class=\"item-buttons\"><div class=\"gallery-link zoom with-text\"><span class=\"item-icon-inner\"><i class=\"fas fa-search-plus\" aria-hidden=\"true\"><\/i><\/span><\/div><a aria-label=\"Link to One\" href=\"\" class=\"gallery-link link with-text\"><span class=\"item-icon-inner\"><i class=\"fas fa-link\" aria-hidden=\"true\"><\/i><\/span><\/a><\/div><\/div><div class=\"caption-head\"><\/div><\/div><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"gallery-item-wrap \" data-index=\"1\" data-control=\"Two\">\n\t\t\t\t\t<div class=\"grid-item\"><div class=\"thumbnail-wrap\" style=\"--guten-gallery-thumbnail-ratio:1824 \/ 1140;\"><img decoding=\"async\" class=\"main-image\" src=\"https:\/\/deftstrokesdev.com\/wp-content\/uploads\/2026\/10\/troubleshootingToolkit2.png\" alt=\"Two\" height=\"1140\" width=\"1824\" \/><div class=\"caption-wrap style-overlay overlay-overlay \"><div class=\"item-hover-bg\"><\/div><div class=\"item-caption-over\"><h5 class=\"item-title\">Two<\/h5><div class=\"item-content\"><\/div><div class=\"item-buttons\"><div class=\"gallery-link zoom with-text\"><span class=\"item-icon-inner\"><i class=\"fas fa-search-plus\" aria-hidden=\"true\"><\/i><\/span><\/div><a aria-label=\"Link to Two\" href=\"\" class=\"gallery-link link with-text\"><span class=\"item-icon-inner\"><i class=\"fas fa-link\" aria-hidden=\"true\"><\/i><\/span><\/a><\/div><\/div><div class=\"caption-head\"><\/div><\/div><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"gallery-item-wrap \" data-index=\"2\" data-control=\"Three\">\n\t\t\t\t\t<div class=\"grid-item\"><div class=\"thumbnail-wrap\" style=\"--guten-gallery-thumbnail-ratio:1824 \/ 1140;\"><img decoding=\"async\" class=\"main-image\" src=\"https:\/\/deftstrokesdev.com\/wp-content\/uploads\/2026\/11\/toolkit_DynamicSql1.gif\" alt=\"Three\" height=\"1140\" width=\"1824\" \/><div class=\"caption-wrap style-overlay overlay-overlay \"><div class=\"item-hover-bg\"><\/div><div class=\"item-caption-over\"><h5 class=\"item-title\">Three<\/h5><div class=\"item-content\"><\/div><div class=\"item-buttons\"><div class=\"gallery-link zoom with-text\"><span class=\"item-icon-inner\"><i class=\"fas fa-search-plus\" aria-hidden=\"true\"><\/i><\/span><\/div><a aria-label=\"Link to Three\" href=\"\" class=\"gallery-link link with-text\"><span class=\"item-icon-inner\"><i class=\"fas fa-link\" aria-hidden=\"true\"><\/i><\/span><\/a><\/div><\/div><div class=\"caption-head\"><\/div><\/div><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"gallery-item-wrap \" data-index=\"3\" data-control=\"Four\">\n\t\t\t\t\t<div class=\"grid-item\"><div class=\"thumbnail-wrap\" style=\"--guten-gallery-thumbnail-ratio:1824 \/ 1140;\"><img decoding=\"async\" class=\"main-image\" src=\"https:\/\/deftstrokesdev.com\/wp-content\/uploads\/2026\/11\/toolkit_DynamicSql2.gif\" alt=\"Four\" height=\"1140\" width=\"1824\" \/><div class=\"caption-wrap style-overlay overlay-overlay \"><div class=\"item-hover-bg\"><\/div><div class=\"item-caption-over\"><h5 class=\"item-title\">Four<\/h5><div class=\"item-content\"><\/div><div class=\"item-buttons\"><div class=\"gallery-link zoom with-text\"><span class=\"item-icon-inner\"><i class=\"fas fa-search-plus\" aria-hidden=\"true\"><\/i><\/span><\/div><a aria-label=\"Link to Four\" href=\"\" class=\"gallery-link link with-text\"><span class=\"item-icon-inner\"><i class=\"fas fa-link\" aria-hidden=\"true\"><\/i><\/span><\/a><\/div><\/div><div class=\"caption-head\"><\/div><\/div><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"gallery-item-wrap \" data-index=\"4\" data-control=\"Five\">\n\t\t\t\t\t<div class=\"grid-item\"><div class=\"thumbnail-wrap\" style=\"--guten-gallery-thumbnail-ratio:1824 \/ 1140;\"><img decoding=\"async\" class=\"main-image\" src=\"https:\/\/deftstrokesdev.com\/wp-content\/uploads\/2026\/11\/toolkit_DynamicSql3.png\" alt=\"Five\" height=\"1140\" width=\"1824\" \/><div class=\"caption-wrap style-overlay overlay-overlay \"><div class=\"item-hover-bg\"><\/div><div class=\"item-caption-over\"><h5 class=\"item-title\">Five<\/h5><div class=\"item-content\"><\/div><div class=\"item-buttons\"><div class=\"gallery-link zoom with-text\"><span class=\"item-icon-inner\"><i class=\"fas fa-search-plus\" aria-hidden=\"true\"><\/i><\/span><\/div><a aria-label=\"Link to Five\" href=\"\" class=\"gallery-link link with-text\"><span class=\"item-icon-inner\"><i class=\"fas fa-link\" aria-hidden=\"true\"><\/i><\/span><\/a><\/div><\/div><div class=\"caption-head\"><\/div><\/div><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h1 class=\"ds-product__title\">Troubleshooting Toolkit<\/h1>\n\n<div class=\"ds-product__pricing\">\n  <div class=\"ds-product__price\"><span class=\"ds-product__price-label\">Starting at<\/span><span class=\"ds-product__price-value\">$999.00\/yr<\/span><\/div>\n  <div class=\"ds-product__tier-table\">\n    <div class=\"ds-product__tier-row\"><span class=\"ds-product__tier-name\">Essentials<\/span><span class=\"ds-product__tier-price\">$999.00\/yr<\/span><\/div>\n    <div class=\"ds-product__tier-row\"><span class=\"ds-product__tier-name\">Select<\/span><span class=\"ds-product__tier-price\">$1,299.00\/yr<\/span><\/div>\n    <div class=\"ds-product__tier-row\"><span class=\"ds-product__tier-name\">Prime<\/span><span class=\"ds-product__tier-price\">$1,499.00\/yr<\/span><\/div>\n    <div class=\"ds-product__tier-row\"><span class=\"ds-product__tier-name\">Enterprise<\/span><span class=\"ds-product__tier-price\">$1,999.00\/yr<\/span><\/div>\n  <\/div>\n  <div class=\"ds-product__tier-note\">as determined by your Acumatica license<\/div>\n  <div class=\"ds-product__pricing-details\">\n    <div class=\"ds-product__pricing-detail\">\n      <span class=\"ds-product__pricing-detail-label\">Releases<\/span>\n      <div class=\"ds-product__pricing-detail-pills\">\n        <span class=\"ds-product__pricing-detail-pill\">26 R2<\/span>\n        <span class=\"ds-product__pricing-detail-pill\">26 R1<\/span>\n        <span class=\"ds-product__pricing-detail-pill\">25 R2<\/span>\n      <\/div>\n    <\/div>\n    <div class=\"ds-product__pricing-detail ds-product__pricing-detail--ui\">\n      <span class=\"ds-product__pricing-detail-label\">UI<\/span>\n      <div class=\"ds-product__pricing-detail-pills\">\n        <span class=\"ds-product__pricing-detail-pill\">Modern<\/span>\n      <\/div>\n    <\/div>\n  <\/div>\n  <a href=\"\/index.php\/contact-us\/\" class=\"ds-product__cta\">Get Started<\/a>\n<\/div>\n\n<hr class=\"ds-product__divider\">\n\n<div class=\"ds-product__description\">\n  <p>A set of admin tools for the jobs Acumatica&#8217;s UI doesn&#8217;t cover \u2014 browsing the server, loading data straight into tables, and querying the database \u2014 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&#8217;s instance as for the admin who runs it.<\/p>\n\n  <p><strong>Server File Explorer<\/strong><\/p>\n  <ul>\n    <li>Browse the site&#8217;s folders and files from the browser<\/li>\n    <li>See which customization package(s) added each file (e.g. *.dll files in <code>\\bin<\/code>)<\/li>\n    <li>Download files (up to 100 MB)<\/li>\n    <li>Deleting is limited to the Toolkit&#8217;s own working folder, so nothing else on the server can be removed<\/li>\n  <\/ul>\n\n  <p><strong>Data Loader<\/strong><\/p>\n  <ul>\n    <li>Import a CSV or Excel (XLSX) file directly into any database table<\/li>\n    <li>Map file columns to table columns, or fill a column with a constant value<\/li>\n    <li>Validate before importing \u2014 Import stays disabled until validation passes<\/li>\n    <li>Bad rows are rejected individually and written to a downloadable file with their original line numbers<\/li>\n    <li>Optionally update existing records with matching keys \u2014 created-by info and NoteIDs are preserved, so notes, attachments, and activities stay attached<\/li>\n    <li>Optionally fill Acumatica system columns (CompanyID, created\/modified audit fields, NoteID)<\/li>\n    <li>Choose all-or-nothing or load-what-passes, commit in batches, enforce constraints, and reset application caches afterward<\/li>\n  <\/ul>\n\n  <p><strong>Dynamic SQL Query<\/strong><\/p>\n  <ul>\n    <li>SQL editor with syntax highlighting and one-click formatting<\/li>\n    <li>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&#8217;s name<\/li>\n    <li>Edit results right in the grid and write them back, with a preview of each change and the generated UPDATE statement before committing<\/li>\n    <li>Write-back is only offered for single-table results with a primary key, and runs as one transaction \u2014 if any row has changed since it was read, the whole batch rolls back<\/li>\n    <li>Hidden by default so it isn&#8217;t stumbled onto \u2014 <a href=\"\/index.php\/contact-us\/\">ask me<\/a> how to enable it<\/li>\n  <\/ul>\n<\/div>\n\n<div class=\"ds-product__effort\">Effort to install \/ configure: \u25cf\u25cc\u25cc\u25cc\u25cc<\/div>\n\n<div class=\"ds-product__subscription-note\">\n  <strong>A power tool:<\/strong> The guardrails above reduce the chance of a mistake, but they don&#8217;t replace a backup. The screen carries a standing notice that by using it you accept the risks and all liability for the outcome \u2014 try it in a sandbox first.<br><br>\n  <strong>Tenant visibility:<\/strong> Dynamic SQL Query and the Data Loader talk to the database directly, which bypasses Acumatica&#8217;s tenant isolation. Anyone with access to this screen in one tenant can use the query to see \u2014 and change \u2014 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.<br><br>\n  Licensed per Acumatica instance and tenant.\n<\/div>\n<\/div>\n<\/div>\n\n","protected":false},"excerpt":{"rendered":"<p>\u2190 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&#8217;s UI doesn&#8217;t cover \u2014 browsing the server, loading data straight into tables, and querying the database \u2014 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":450,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1142","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/deftstrokesdev.com\/index.php\/wp-json\/wp\/v2\/pages\/1142","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/deftstrokesdev.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/deftstrokesdev.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/deftstrokesdev.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/deftstrokesdev.com\/index.php\/wp-json\/wp\/v2\/comments?post=1142"}],"version-history":[{"count":9,"href":"https:\/\/deftstrokesdev.com\/index.php\/wp-json\/wp\/v2\/pages\/1142\/revisions"}],"predecessor-version":[{"id":1164,"href":"https:\/\/deftstrokesdev.com\/index.php\/wp-json\/wp\/v2\/pages\/1142\/revisions\/1164"}],"up":[{"embeddable":true,"href":"https:\/\/deftstrokesdev.com\/index.php\/wp-json\/wp\/v2\/pages\/450"}],"wp:attachment":[{"href":"https:\/\/deftstrokesdev.com\/index.php\/wp-json\/wp\/v2\/media?parent=1142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}