SAP Knowledge Base Article - Public

2007470 - Functional Area Incorrect in Journal Entry of Expense Report

Symptom

The functional area displayed in journal entry of expense report is incorrect.

Environment

SAP Business ByDesign

Reproducing the Issue

You create an expense report in cost center XYZ (XYZ means the Cost Center ID). But the journal entry of the expense report does not show the functional area which is linked to the cost center.

Cause

We need to ensure that both master data setup and business configuration are maintained correctly before the creation time of the journal entry.

  • Master Data Setup
    1. Go to the Organization Management work center.
    2. Select common task Edit Org Structures.
    3. Go to tab Definitions, select the cost center type ABC (ABC means the Cost Center Type) for the cost center XYZ.
    4. Select Save.
  • Business Configuration
    1. Go to the Business Configuration work center and Implementation Projects view.
    2. Select the implementation project and select Open Activity List.
    3. Open activity Settings for Income Statements by Function of Expense and Earned Profit Analysis.
    4. Select sub-activity Edit functional area determination.
    5. Select the related Accounting Principles.
    6. In tab Determination Using Cost Center Types, assign cost center type ABC to Functional Area DEF (DEF means the Functional Area ID).
    7. Save your settings.

You can create an expense report with cost assignment to the cost center. In this way, the functional area assigned to the cost center type should show in the journal entry.

All the master data setup and configuration should be done before you post the expense report. Otherwise, the journal entry does not show the correct functional area, this is the root cause in this case.

Resolution

You need to check both the change log of cost center and configuration.

  • Change log of cost center can be found in tab Changes of the org unit.
  • Change log of configuration can be found in following steps:
    1. Go to the Business Configuration work center and Reports view.
    2. Select report Configuration Change History.
    3. Go to tab Fine-Tuning Settings.
    4. Select the activity Settings for Income Statements by Function of Expense and Earned Profit Analysis and select View Change Details. Change details will be exported to excel file.

Either the assignment of cost center XYZ to cost center type ABC or the configuration setup is later than the creation time of journal entry, functional area in journal entry will not show as DEF.

In order to correct the posted journal entry to the incorrect functional area, please follow the steps below:

  1. Go to the General Ledger work center, and create a new Journal Entry Voucher.
  2. In the new Journal Entry Voucher, maintain the necessary information, and add a row.
  3. If there is debit balance on the concerned account, then in this new row, enter the exact same debit amount for this account, the system automatically derives the latest functional area assignment for this line item. 
  4. Add another row to have a credit posting for the same account and amount.
  5. For the credit line item, check Change Functional Area, and select the old Functional Area assignment of the account in order to balance the previous debit posting with the old functional area assignment. If there is no functional area assignment before, then you need to leave Functional Area blank here.
  6. Choose Post.  

Keywords

functional area; G/L account; cost center type; accounting principle; org structures; , KBA , csg_q , cost center type , org structures , accounting principle , g/l account , functional area , cost center , SRD-FIN-COR , Cost & Revenue , How To

Product

SAP Business ByDesign all versions