Table of Contents

Check systemIDs

In this article, you will learn about how to check and replace the systemID values stored in linked ID fields in the Aident SQL Migration app in Business Central.

What's the purpose of the function?

In some tables, there are ID fields in the number range 8000 that have a table relation to a SystemID field in another master data table. This link is in addition to the link to the primary key field and is used for integration scenarios.

For example table 18 Customer has the following table relations:

  • Field 22 Currency Code: Relation to Table 4 Currency Field 1 Code
  • Field 8001 Currency Id: Relation to Table 4 Currency Field 2000000000 systemId

After migrating records, it is important to ensure that the correct values exist in the appropriate fields for the respective record in the respective company. This means that not only must the code fields be identical, but the values of the systemIDs of the linked records must also match.

For this purpose, there is a function in the Aident SQL Migration App that searches for the corresponding table relations, checks the values of the linked systemID fields and, if necessary, corrects them in the destination table.

Initialize, check and replace systemID relations

Follow these steps to initialize systemID relations:

  1. Navigate to Database Assignments
    • In Business Central, search for and go to the Database Assignments page.
  2. Open Database Assignment
    • Open the database assignment for which the systemIDs should be checked and replaced. The Database Assignment Card page opens.
  3. Open SystemID Relations
    • Click SystemID Relations in the Related action menu. The SystemID Relations page opens and displays all relations that have already been found.
  4. Initialize SystemID Relations
    • Click Initialize systemID Relations in the action bar to update the SystemID relations. The relations found to a SystemID field are then displayed.
  5. Check and Replace systemIDs
    • Click Check and Replace systemIDs in the action bar to check and replace the SystemID values for the records of the found tables.

Next step

Filter Categories