2761711 - Migration of G/L Account Balances - Error Detected in Source Record - Value Conversion Missing - G/L Account as Chart of Accounts Item not Found

You migrate G/L Account balances using the Migration tool. You execute the migration. In step 1c - Simulate Import errors appear, such as

• 'Error detected in source record XXXX&sep&YYYY&sep&&sep&&sep&&sep&&sep&&sep&sep&'
• 'G/L Account as Chart of Accounts Item 'CoA SAKOMIG' not found' (CoA stands for the respective Chart of Accounts ID).

SAP Business ByDesign

1. Go to the Business Configuration work center.
2. Go to the Implementation Projects view.
3. Open the Activity List and navigate to the Integrate and Extend phase.
4. Find the Migration of Accounting Transaction Data activity and open it.
5. In the new screen press Migrate accounting transaction data using the migration tool.
6. Select the migration unit and press Execute Migration.
7. In step 1- Process Files select the G/L Account Balances Migration Object and press Process File.
8. Go through step 1a- Validate File and step 1b- Convert Values.
9. Press Next again to go to step 1c-Simulate Import.
10. The the errors appear:

• 'Error detected in source record XXXX&sep&YYYY&sep&&sep&&sep&&sep&&sep&&sep&sep&'
• 'G/L Account as Chart of Accounts Item 'CAIA SAKOMIG' not found'

There can be several reasons why the Import simulation does not work. However, if the system is not able to derive the SAKOMIG account, the data carryforward account for G/L account balances, it is possible that there is an inconsistency between the Company validity start date and the maintained Migration posting date. If the Company used for Migration is valid from a date before the Migration Posting date it is not possible to identify the migration relevant setting of this Company.

You have to either change the Migration Posting Date or change the validity of the respective Company, say Company ABC.

First check the validity start date of Company ABC used for the Migration:

1. In the Organizational Management work center go to the Org Structures view.
2. Find company ABC and select it.
3. Navigate to the Timelines tab in the Details section.
4. Under Definitions find the attribute Company.
5. Check the Valid From date.

To check/ change the Migration Posting Date:

1. Go to the General Ledger work center.
2. Navigate to the Master Data - Companies view. 
3. In the view find Company ABC.
4. Here, in the column Posting Date for Migration check if this date is after the validity start date of company ABC.
5. If you decide to change this date, select company ABC and press Actions - Set Posting Date for Migration.
6. Update the Migration Posting Date to a date on or before the Valid From date of Company ABC.

2722439 - Error During Migration of G/L Account Balances

Migration, G/L Account Balances , KBA , SRD-FIN-GL , General Ledger , How To