System Administration: Population of Values in Custom Columns

In MYOB Acumatica 2024.1, for snapshots that have been restored by using the MYOB Acumatica ERP Configuration Wizard, the system populates the custom columns in a destination tenant with values from the source tenant.

Restoration of a Snapshot with Custom Column Values

A system administrator might need to modify an MYOB Acumatica instance by adding custom columns to a database table and filling in these columns with certain values. (For example, these changes might be made to support the addition of a new tab to a form and the addition of new boxes to this tab.) The administrator might also need to create a snapshot in a tenant that has such modifications. The administrator can then restore this snapshot in one of the following ways:

• By using the Tenants (SM203520) form.

  The administrator opens the Upload Snapshot Package dialog box and selects the Include Data From Custom Columns check box.

  This approach is suitable for snapshots whose size does not exceed 1 gigabyte.

• By using the MYOB Acumatica ERP Configuration Wizard.

  The administrator copies the file with the snapshot to the Acumatica ERP\Database\Data folder, creates a tenant in the same instance or another instance, and selects the copied file as a dataset.

  This approach is suitable for snapshots of any size.

In previous versions of MYOB Acumatica, if the administrator restored a snapshot with custom columns by using the MYOB Acumatica ERP Configuration Wizard, these columns were empty in the destination tenant.

In MYOB Acumatica 2024.1, the administrator can use this approach for large snapshots that contain custom database columns with values.