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

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

SAP Business ByDesign

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

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)

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)

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