2150990 - G/L Account Balances Migration Errors

SAP Knowledge Base Article - Public

2150990 - G/L Account Balances Migration Errors

Symptom

You are migrating General Ledger Account Balances 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.

 

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 gl accounts with such line delete it or add a 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 depends upon the settings in the system. However the most prominent account types that you can not 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 gl balances.

Keywords

KBA , SRD-CC , Cross Components , How To

Product

SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1502 ; SAP Business ByDesign 1505 ; SAP Business ByDesign 1508 ; SAP Business ByDesign 1511 ; SAP Business ByDesign 1711