SAP Knowledge Base Article - Public

2150990 - G/L Account Balances Migration Errors

Symptom

The migration of General Ledger Account Balances is not successful due to numerous errors:

For gen. Ledger Purposes, At Least One Debit And Credit Line Required.

Accnt Conversion: A/P Open Items In Chart Of Accounts XYZ Not Permitted For Posting Using Journal Entry Voucher.

Accnt PCA Balancing Dr/Cr In CoA XYZ Not Permitted For Posting Using Journal Entry Voucher.

XYZ means the Chart of Accounts.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Configuration work center.
  2. Select the Implementation Projects view.
  3. Select your implementation project and click Open Activity List.
  4. Search and open the activity Migration of Accounting Transaction Data.
  5. Click Migrate accounting transaction data using the migration tool.
  6. Process the file and during simulate import you get the errors.

Cause

ERROR 1: For gen. Ledger Purposes, At Least One Debit And Credit Line Required.

Migration of a G/L Accnt with zero balance is not possible.

ERROR 2: Accnt Conversion: A/P Open Items In Chart Of Accounts  XYZ Not Permitted For Posting Using Journal Entry Voucher.

If there is a posting block for the G/L Accnt then you get the ERROR 2.

ERROR 3: Accnt PCA Balancing Dr/Cr In CoA XYZ Not Permitted For Posting Using Journal Entry Voucher.

If the account type of the G/L Accnt is for example: PCCLEA - Profit center or segment clearing then you get ERROR 3.

Resolution

ERROR 1: For gen. Ledger Purposes, At Least One Debit And Credit Line Required.

When you enter the G/L accounts in the template the amount in currency should not be zero for this account, if you have any G/L accounts with such line delete it or add an amount for it.

ERROR 2: Accnt Conversion: A/P Open Items In Chart Of Accounts  XYZ Not Permitted For Posting Using Journal Entry Voucher.

  1. Go to Business Configuration work center.
  2. Go to Implementation Projects view.
  3. Select the project and open activity list.
  4. Open activity Charts of Accounts, Financial Reporting Structures, Account Determination.
  5. Click link Edit chart of accounts.
  6. Select a G/L in question and go to the view G/L Account Posting Block and select All Postings Allowed from the dropdown.
  7. Save.

ERROR 3: Accnt PCA Balancing Dr/Cr In CoA XYZ Not Permitted For Posting Using Journal Entry Voucher.

The G/L Accounts in migration depend upon the settings in the system. However the most prominent account types that you cannot use in migration are:

- OCLSBS - Opening or closing - balance sheet
- OCLSPL - Opening or closing - income statement
- PCCLEA - Profit center or segment clearing
- Migration clearing accounts

You cannot make manual postings to G/L accounts of the following account types: OCLSPL - Opening or Closing Income Statement, OCLSBS - Opening or Closing Balance Sheet, and PCCLEA- Profit Center or Segment Clearing.
These accounts are only used in the balance carry forward run for balance carry forward postings only.

Once you correct these then the above errors would not appear during migration of G/L balances.

Keywords

G/L balances; migration; JEV; journal entry voucher , KBA , SRD-CC , Cross Components , How To

Product

SAP Business ByDesign all versions