Copy Sandbox

Updated at June 12th, 2026

Table of Contents

Module Description Setup Creating the queue Rules when Copying Filters on records and fields Manual Execution Tables with permissions Advantages of automatic rules

Module Description

CopySandbox is an app for Business Central that allows you to manage the automatic creation of one or more Sandboxes within the current Tenant through a dedicated interface.
Additionally, the app allows you to define custom rules to delete or modify records and fields in newly generated Sandboxes.

Setup

To set up the app, open the search lens and type Copy Environment Setup . Image containing text, screenshot, character, number AI-generated content may be incorrect.

The setup contains three groups of information:

The Microsoft entra ID: made up of client ID and Secret (to be able to access the API functions for copying and deleting environments);

Environment info: consisting of the environment name only, which will be the new name of the sandbox you want to create;

Job Queue Entry Info: The remaining fields provide information regarding the job queue scheduling for copying the environment. The Execute Now field allows you to execute the copy immediately, but only once.

Creating the queue

The Schedule Copy Environment action generates a job queue that takes care of:

Create a copy of the current environment.
Generate a new Sandbox with the name specified in the setup.

Image containing text, screenshot, character, line AI-generated content may not be correct.

Warning: If a sandbox with the same name already exists, it will be automatically deleted before the new one is created. You must have at least one free sandbox slot in your tenant.

Example: If the name CopiaDev is configured, a Sandbox with that name will be created at the defined times.

Image containing text, screenshot, character, number AI-generated content may be incorrect.

Rules when Copying

During Sandbox generation, you can apply rules to delete or modify data.

To manage these rules:

Open the search lens and type Copy Environment Rules .
The list of configurable rules will be shown.

Rules can be of two types:

Automatic: Run automatically when the Sandbox is created.
Manual: Can be performed manually and affect the current environment.

Note: Automatic rules can also be applied manually, but only on the current environment .

Image containing text, character, line, or number AI-generated content may be incorrect.

Filters on records and fields

Image containing text, screenshot, line, character AI-generated content may not be correct.

Each row represents a table, on which to perform a deletion or modification.

The modification of individual fields can only be applied with the modification operation type.

A filter can be applied to each of the two types of operation.

You can choose whether to apply the rule:

To all companies (specific field Select All Company)
Or only to certain companies (specifying the filter Select All Company).

Image containing text, screenshot, number, character AI-generated content may be incorrect.

Manual Execution

Image containing text, screenshot, character, line AI-generated content may be incorrect.

It is always possible to start any type of rule via the action available in the header.
Manually running rules will only affect the environment currently in use.

A warning message will appear to alert you to this, and will also inform you of the records that will be affected by the manual execution.

Tables with permissions

Sandbox copy operations are also possible on the following “registered” tables:

table "17" "G/L Entry"
table "21" "Cust. Ledger Entry"
table "25" "Vendor Ledger Entry"
table "32" "Item Ledger Entry"
table "96" "G/L Budget Entry"
table "169" "Job Ledger Entry"
table "254" "VAT Entry"
table "265" "Document Entry"
table "271" "Bank Account Ledger Entry"
table "337" "Reservation Entry"
table "454" "Approval Entry"
table "455" "Posted Approval Entry"
table "5802" "Value Entry"
table "5832" "Capacity Ledger Entry"
table "7312" "Warehouse Entry"
table "110" "Sales Shipment Header"
table "111" "Sales Shipment Line"
table "112" "Sales Invoice Header"
table "113" "Sales Invoice Line"
table "114" "Sales Cr.Memo Header"
table "115" "Sales Cr.Memo Line"
table "120" "Purch. Rcpt. Header"
table "121" "Purch. Rcpt. Line"
table "122" "Purch. Inv. Header"
table "123" "Purch. Inv. Line"
table "124" "Purch. Cr. Memo Hdr."
table "125" "Purch. Cr. Memo Line"
table "160" "Res. Capacity Entry"
table "379" "Detailed Cust. Ledg. Entry"
table "380" "Detailed Vendor Ledg. Entry"
table "5601" "FA Ledger Entry"
table "297" "Issued Reminder Header"
table "298" "Issued Reminder Line"
table "253" "G/L Entry - VAT Entry Link"
table "339" "Item Application Entry"
table "45" "G/L Register"
table "5811" "Post Value Entry to G/L"
table "1900" "Cancelled Document"
table "6651" "Return Shipment Line"
table "6650" "Return Shipment Header"
table "5907" "Service Ledger Entry"
table "480" "Dimension Set Entry"
table "203" "Res. Ledger Entry"
table "6660" "Return Receipt Header"
table "6661" "Return Receipt Line"
table "5772" "Registered Whse. Activity Hdr."
table "5773" "Registered Whse. Activity Line"
table "8400" "Record Set Definition"
table "5896" "Inventory Adjmt. Entry (Order)"
table "5625" “Maintenance Ledger Entry”

Advantages of automatic rules

Automatic rules run transparently whenever you create a new Sandbox.
This means that: even if the environment copy is not started via the CopySandbox tool, but via other standard tools or procedures, the automatic rules will still be applied to the new environment, since they are executed immediately after the Environment Cleanup operation.