Administration Tools
The Administration Tools app gives implementers and super users a set of practical tools to accelerate Business Central implementations and simplify day-to-day system administration. Rather than building one-off workarounds or relying on a consultant for every routine task, the app packages commonly needed capabilities directly into Business Central so super users can act independently.
Why Use Administration Tools?
- Faster implementations — automate repetitive setup tasks like sandbox initialisation, data masking, and posting configuration so consultants can focus on higher-value work.
- Empowers super users — put safe, well-guarded bulk operations in the hands of the people who need them, without requiring developer access.
- Reduces risk — built-in guardrails, confirmation prompts, and audit logs mean power users can act confidently without fear of making irreversible mistakes by accident.
- Works at scale — bulk delete, bulk rename, batch posting, and data export tools are designed to handle volumes that would be impractical to manage manually or that cause timeouts in the standard application.
- Keeps environments clean — tools for sandbox initialisation, cleanup, data masking, and email deletion help teams maintain well-managed test environments.
Features
The availability of the features below depends on your subscription plan. All features are available to implementation partners irrespective of the subscription plan.
Productivity & Administration
| Feature | Description |
|---|---|
| Run Object | Run any table, page, report, codeunit, query, or XML Port directly — including in a different company — without needing a role centre link. |
| Find and Replace | Find and replace field values across records with a preview step before committing any changes. One of the most frequently used tools in the app. |
| Set Default User Personalisation | Apply default user settings (language, role, etc.) to multiple users in one step. |
| Access Control | View, import, and export the permission sets assigned to each user. Handles Security ID differences between environments. |
| Change Log Analysis | Analyse change log entry volume by table and change type to help optimise change log settings and manage database size. |
| Detailed Fields List | View all fields in the environment with extra details not shown on standard pages. Useful for reporting and integrations. |
Implementation & Sandbox
| Feature | Description |
|---|---|
| Sandbox Initialisation | Step-by-step guide to disable job queues, anonymise emails, and configure company settings in a sandbox after copying from production. |
| Cleanup Sandbox | Removes transactional data from a sandbox so it can be reused as a clean environment without recreating it. |
| Data Masking | Replaces sensitive data (names, addresses, contact details) in a sandbox with masked values to protect privacy during testing. |
| Copy Data | Copies setup and master data from one company to another. Useful when creating new companies or synchronising setups. |
| Migrating from Implementation Tools | Step-by-step guide for customers moving from the Theta Implementation Tools PTE to this app. |
Bulk Operations
| Feature | Description |
|---|---|
| Bulk Delete | Delete large numbers of records from any table using filters. Useful for clearing documents or catching up on retention policies. |
| Bulk Delete Emails | Delete accumulated sent and outbox emails in bulk to reclaim database space. |
| Bulk Rename | Rename (renumber) multiple master data records from a CSV file. Useful for chart of accounts restructures and customer/vendor renumbering. |
| Bulk Cancel Reservations | Cancel item reservations in bulk, including identification of orphaned reservations. |
| Bulk Release Sales/Purchase Documents | Bulk-release open sales and purchase documents. Useful after bulk-importing orders via a configuration package. |
| Configuration Package Multi-Table Selection | Select multiple tables when working with configuration packages instead of adding them one at a time. (Documentation coming soon) |
| Reopen Finished Production Order | Reopen finished production orders in bulk so corrections can be made. Can reopen multiple times, unlike the native BC action. |
Item Journal Batch Tools
| Feature | Description |
|---|---|
| Item Journal Batch Delete | Delete item journal lines in bulk, bypassing the per-line confirmation that Business Central requires when lines have item tracking. Available directly from the Item Journal and Item Reclass. Journal. |
| Batch Post Item Journal | Post large item journals in configurable sub-batches to release locks between commits and allow valid lines to post past errors. Available directly from the Item Journal and Item Reclass. Journal. |
Historical Data & Dimension Updates
| Feature | Description |
|---|---|
| Item Sales History | Import and post historical item sales so you have comparative reporting data from day one in Business Central. |
| Archive & Revert Posting Setup | Temporarily routes all inventory postings through a single account so the net G/L effect is zero. Used during take-on when the general ledger has been imported separately. |
| Historical Dimension Update | Update dimensions on posted entries (sales, purchases, jobs) to reflect current master data dimension values. |
Data & Integration
| Feature | Description |
|---|---|
| Data Upload & Archiving | Export Business Central table data to Azure Table Storage on a schedule, with optional deletion of source records after upload. |
| Configuration Package Excel API | Import and apply Excel-based configuration packages via API, enabling automated data migration without manual intervention. |
| General Journal Import | Bulk-import G/L, customer, vendor, bank, and fixed asset journal lines via XML Port. |
| Fixed Asset Journal Import | Bulk-import fixed asset journal lines via XML Port, including FA opening balances. |
| Generate API Page | Generates ready-to-use AL source code for an API page from any table's fields. |
| SQL Script Generator | (Partner only) Generates SQL scripts to copy data from custom NAV C/AL fields into BC extension fields during a NAV-to-cloud migration, eliminating the need to step through intermediate upgrade versions. |
Job Queue & System Health
| Feature | Description |
|---|---|
| Managed Job Queues | Manage job queue entries with additional controls, scheduling rules, and visibility not available in the standard job queue. |
| Reset Failed Job Queue Entries | Reset transient job queue failures and send email notifications when queues remain failed beyond a configurable threshold. |
| Run Adjust Cost per Item | Run the Adjust Cost - Item Entries batch job per item in low-level code sequence, committing after each item to reduce lock contention on high-volume environments. |
| System Status | Role centre cues showing expiry notification status and job queue health at a glance. |
| System Telemetry | Extensible framework for running periodic background checks (e.g., G/L consistency) after login without impacting user experience or requiring a job queue. |
| Expiry Notifications | Configure email and in-app notifications to be sent before a specified expiry date, schedulable via the job queue. |
note
Most features are accessible from the Run Object page. Search for it using Tell Me.
