2158803 - Amounts Posted to Unexpected Accounts During G/L Account Balance Migration

SAP Knowledge Base Article - Public

2158803 - Amounts Posted to Unexpected Accounts During G/L Account Balance Migration

Symptom

After performing a migration of G/L Account balances via the migration tool, you notice that some of the balances have been posted to accounts which differ from the ones maintained in the migration template.

Reproducing the Issue

  1. Go to the Business Configuration work center.
  2. Open the activity Migration of Accounting Transaction Data either through the Search function in Overview or an open Implementation/Change Project.
  3. Upload a migration template filled out with G/L Accounts and the corresponding balances.
  4. Follow the steps on screen and execute the migration, making sure that no errors are reported and the data gets carried over completely.
  5. When verifying the results in report G/L Accounts - Line Items (FINGLAU02_Q0001), you notice that amounts related to open purchase orders have been posted to accounts not maintained in the migration template.

Cause

Certain account determination settings automatically redirect migration postings to the maintained balance sheet accounts as long as these have the correct G/L Account type.

Resolution

In order to check the active account determination settings:

  1. Go to the Business Configuration work center.
  2. Open the activity Charts of Accounts, Financial Reporting Structures, Account Determination either through the Search function in Overview or an open Implementation/Change Project.
  3. Open activity Accounts Payable under Account Determination
  4. Check for accounts maintained under the In Transit tab.

The system will look for accounts of type Accruals/Clearings maintained in the Unbilled Payables section of the mentioned tab and redirect any migrated open payables balances there as part of standard system behaviour. 

Keywords

KBA , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions