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:
- Enter mandatory data (for example, Company, Posting Date, etc.).
- Enter Journal Entry Type ABC.
- Go to SAP BUSINESS BYDESIGN Excel tab.
- 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:
- Click the cell below Journal Entry Type field.
- Go to SAP BUSINESS BYDESIGN Excel tab.
- Under Workbook section, click Lookup button.
- 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
SAP Knowledge Base Article - Public