SAP Knowledge Base Article - Public

2119683 - 'Account determination missing for item type XYZ' Error Message in General Ledger Overview

Symptom

While opening General Ledger Overview work center view, an error message occurs: 'Account determination missing for item type XYZ' (XYZ means the item type).

The same message is thrown when running the Trial Balance report.

Environment

SAP Business ByDesign

Reproducing the Issue

There are basically two scenarios where this error message is thrown:

A)

  1. Go to General Ledger work center.
  2. Go to Overview view.

The error message is displayed: 'Account determination missing for item type XYZ'

B)

  1. Go to General Ledger work center.
  2. Go to Reports and select List view.
  3. Open the Trial Balance report or the Financial Statements.
  4. Enter selection data and execute the report.

The same error message is displayed.

Cause

The reason for such error message is that Account Determination has not been maintained for the Opening and Closing Balance accounts under General Ledger section of Account Determination, in Business Configuration work center.

During Trial Balance if balance carryforward has not been completed for the previous year, the system automatically simulates balance carryforward (BCF) for the previous year when running the report, and hence these accounts are needed.

The reason why this error message is also displayed in General Ledger Overview is that the report Balances on Favorite Accounts is pre-loaded when we open the Overview and since it uses the same Data Source ID FINGLAU01 as the Trial Balance report the system behavior is the same.

Another reason is account determination of Retained Earnings is missing.

The trial balance report internally triggers a mini BCF if the previous fiscal years have not been closed. This is required to get the correct opening balances without even a BCF being done for previous years. As part of BCF logic it is calculation of profit and loss is being triggered which is then shown as part of Equity accounts.

This is where system finds that account determination of Retained Earnings is missing. Although it seems that in previous years there are no postings on P&L accounts, yet the system is at least checking the system for consistency.

Resolution

Maintain the Opening and Closing Balance accounts, Retained Earnings and other G/L accounts under General Ledger section of Account Determination, in Business Configuration work center:

  1. Go to Business Configuration work center.
  2. Go to Overview view.
  3. Search for activity Charts of Accounts, Financial Reporting Structures, Account Determination.
  4. Click Change Immediately.
  5. Under Account Determination section, click General Ledger.
  6. Maintain the Opening/Closing Balance accounts and Retained Earnings.
  7. Click Save and Close.

After that the error messages won't occur.

Keywords

Trial Balance Report; 试算表; FINGLAU01_Q0001, Opening/Closing Balance, FINGLAU04_Q0001, Itme type 10210 , KBA , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions