SAP Knowledge Base Article - Public

3500747 - Mandatory account assigment for mapped item X is missing: Cost Center

Symptom

Error occurs when trying to upload the Journal Entry Voucher via MS Excel Add-in

Mandatory account assigment for mapped item XX is missing: Cost Center (XX represents the item number).

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Open the Upload Journal Entry Voucher template with the Microsoft Excel
  2. Go to SAP Business ByDesign tab and click Logon
  3. Enter the credentials
  4. Click Save data to
  5. Error:

    Mandatory account assigment for item XX is missing: Cost Center

Cause

The Account Assignment Type 'Cost Center' is maintained as mandatory for the G/L Account

Following the below steps to check the settings for account assignment type CC - Cost Center:

  1. Go to the Business Configuration work center.
  2. Go to Overview.
  3. Search for the activity Mandatory Account Assignments.
  4. Click Edit Mandatory Account Assignments for G/L Accounts.
  5. Select the respective Chart of Accounts.
  6. Filter for G/L account ABC and see that the Account Assignment Type is CC - Cost Center.
    (ABC means the G/L Account number)

Resolution

There are two options to solve this error:

Option 1

Include the Cost Center for the G/L Account ABC in your template file.

Option 2

Delete the mandatory assignment for the G/L Account ABC

  1. Go to the Business Configuration work center.
  2. Go to Overview.
  3. Search for the activity Mandatory Account Assignments.
  4. Click Edit Mandatory Account Assignments for G/L Accounts.
  5. Select the respective Chart of Accounts.
  6. Filter for G/L account ABC and delete the Account Assignment Type: CC - Cost Center.

    (ABC means the G/L Account number)

Keywords

Mandatory account assignment, journal entry voucher, add-in, excel, upload , KBA , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions