SAP Knowledge Base Article - Public

2499953 - Journal Entry Voucher Excel Upload Error: Business Transaction Type Journal Entry Voucher Does not Match Document Type

Symptom

While uploading a Journal Entry Voucher from Microsoft Excel you get the following error message:

'Business transaction type Journal Entry Voucher does not match document type ABC' (ABC represents the Journal Entry Type).

Environment

SAP Business ByDesign

Reproducing the Issue

In the Journal Entry Voucher Excel file:

  1. Enter mandatory data (for example, Company, Posting Date, etc.).
  2. Enter Journal Entry Type ABC.
  3. Go to SAP BUSINESS BYDESIGN Excel tab.
  4. Click Save data to button.

A pop-up is thrown with the following error message:

'Business transaction type Journal Entry Voucher does not match document type ABC'.

Cause

You have selected a Journal Entry Type which is not supported in the Journal Entry Voucher from Microsoft Excel, for example 00085 - Manual Entry for Accounts Receivable.

There are three Journal Entry Types currently supported for this functionality:

00047 - Manual Posting - Journal Entry Voucher
00079 - Data Migration
00103 - Manual Posting - JEV with Offset Entry

The supported types can be seen if you do the following:

  1. Click the cell below Journal Entry Type field.
  2. Go to SAP BUSINESS BYDESIGN Excel tab.
  3. Under Workbook section, click Lookup button.
  4. Click Search button.

The three types will be displayed and you can select one of those.

Resolution

If you want to use a Journal Entry Type different than those you need to create the Journal Entry Voucher via User Interface (UI).

Keywords

Journal Entry Voucher from Microsoft Excel; Upload Journal Entry Vocuher; Journal Entry Type; , KBA , journal entry voucher from microsoft exc , upload journal entry vocuher , journal entry type , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions