SAP Knowledge Base Article - Public

2722439 - Error During Migration of G/L Account Balances

Symptom

You are migrating General Ledger Account Balances and received the below error messages:

'Item X: A profit center must be provided in set of books PQRS'
'No functional area could be assigned'
'Derivation for acc.principle YYYY, chart of accts PQRS, G/L account 123, Nonsales Object'
'Journal entry voucher cannot be posted'

(PQRS represents the set of books)

(123 represents the G/L account)

(YYYY represents the acc.principle)

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 below errors.

'Item X: A profit center must be provided in set of books PQRS (PQRS represents Set of Books ID)'
'No functional area could be assigned'
'Derivation for acc.principle YYYY, chart of accts PQRS, G/L account 123, Nonsales Object (123 represents G/L account ID)'
'Journal entry voucher cannot be posted'

Cause

You have not maintained the Default profit center and default functional area.

Since you have selected the reporting principle which supports Income Statement by Function of Expense. For Instance: Function of expense: the system tries and assign a functional area when it is hitting the gl-account 123 which is another operational expenses. However - the system failed to assign since it could not find a default functional area for nonsales object or a functional area assigned to this G/L account in particular in the activity Settings for Income Statements by Function of Expense and Earned Profit Analysis.

Resolution

You need to follow the below 3 steps to set the configuration:

Step 1:

  1. Go to the Business Configuration work center and Implementation Projects view.
  2. Select the project, and select Open Activity List.
  3. Go to the tab Fine-Tuning Activities.
  4. Select Fine Tuning activity Profit Center Derivation.
  5. Select Edit Default Profit Center.
  6. Click Add Row.
  7. Enter required data and specify Profit Center for each Subledger.
  8. Choose Save.

Step 2:

  1. Go to Business Configuration work center and Implementation Projects view.
  2. Select the project, and select Open Activity List.
  3. Go to tab Fine-Tuning Activities.
  4. Select activity Settings for Income Statements by Function of Expense and Earned Profit Analysis.
  5. Select Functional Areas.
  6. Select Functional Area and select Default check box
  7. Select Save.

Step 3:

  1. Go to Business Configuration work center and Implementation Projects view.
  2. Select the project, and select Open Activity List.
  3. Go to tab Fine-Tuning Activities.
  4. Select activity Settings for Income Statements by Function of Expense and Earned Profit Analysis.
  5. Select Functional Area Determination.
  6. Select Add Row in tab Determination Using G/L Accounts.
  7. Input the G/L account 123, and select Functional Area.
  8. Select Save.

Now you are able to migrate the G/L account balances.

See Also

2761711 - Error While Migration G/L Account Balances: 'G/L Account as Chart of Accounts Item 'CAIA SAKOMIG' not found'

Keywords

Migration of G/L account balances, Profit center, functional area, Derivation for acc.principle , KBA , AP-FMD , Business ByDesign: Financial Accounting Masterdata , How To

Product

SAP Business ByDesign all versions