SAP Knowledge Base Article - Public

3093465 - Migration Clearing Account for Fixed Assets is derived for Migration of G/L Account Balances

Symptom

In the Migration of Accounting Transaction Data activity you prepare the migration of G/L Account Balances.

The G/L accounts maintained are not used for any subledger migration (such as payables, receivables, fixed assets, cash, tax, inventory).

You therefore expect the system to directly migrate all values to the defined accounts. 
When verifying the posting preview you notice that the Migration Clearing Account for Fixed Assets is also derived balancing to a Local Currency amount of 0,00, even though you have not migrated any values to G/L accounts of type Fixed Asset or any other subledgers.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Access the Migration of Accounting Transaction Data activity. 
  2. Select Migrate accounting transaction data using the migration tool. 
  3. In the new window, select the respective migration unit and press Cross-Check Balances Preview. 
  4. Press Execute Migration. 
  5. In the next window, for step 1-Process Files, select the G/L Account Balances file and press Process File.
  6. Press Next until you reach step 1d-Verify Posting Preview.
  7. You notice that beside the defined G/L accounts also the Migration Clearing Account for Fixed Assets is derived, displaying a Local Currency value of 0,00. 

Cause

For the migration of G/L account balances, not involved in any sub-ledger postings, the system automatically creates one journal entry per balance, and an offsetting entry. The account used for this offsetting entry is SAKOMIG (Sachkonto Migration - data carryforward account for G/L account balances). Usually, the Migration Clearing Account for Fixed Assets is derived as SAKOMIG account.

Resolution

When using the migration tool the G/L account balances are offset with the SAKOMIG account.

In the migration tool it is possible to offset the G/L account balances with a different account:

  1. During the Process Files activity navigate to step 1b-Convert Values.
  2. Select the Edit Value Conversion for G/L Account link. 
  3. In the Value Conversion for G/L Account table find the G/L account defined as SAKOMIG under Source Value. 
  4. Use the G/L Account value help under Target Value to change the account. 

Please note: The SAKOMIG account is not derived when manually migrating balances: In the Migration of Accounting Transaction Data use the Manually enter G/L account balances link.

See Also

Configuration: Migration of G/L Account Balances

Keywords

KBA , SRD-FIN-GL , General Ledger , Problem

Product

SAP Business ByDesign all versions