SAP Knowledge Base Article - Public

3437753 - The Lookup Button in the Microsoft Excel Template 'Journal Entry Voucher for Sales from Microsoft Excel®'

Symptom

When clicking the Lookup button in the Microsoft Excel Template 'Journal Entry Voucher for Sales from Microsoft Excel®', the Journal Entry Type '00088' is not the list.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the General Ledger work center.
  2. Go to the Journal Entry Vouchers view.
  3. Click New->Journal Entry Voucher for Sales from Microsoft Excel® and you will download the template.
  4. Open the excel template.
  5. In the template, click the cell below Journal Entry Type field.
  6. Go to SAP BUSINESS BYDESIGN Excel tab.
  7. Under Workbook section, click Lookup button.
  8. Click Search button.
  9. Journal Entry Type 00088 is not in the list.

Cause

Since 'Journal Entry Voucher for Sales from Microsoft Excel®' is a specific template for Journal Entry Document type 00088, the lookup button is not applicable here. 

Resolution

For template 'Journal Entry Voucher for Sales from Microsoft Excel®', the lookup button will get disabled in the future.

See Also

Upload a Journal Entry Voucher | SAP Help Portal

Keywords

Journal Entry Voucher for Sales from Microsoft Excel®, Journal Entry Type '00088', Manual Journal Voucher , KBA , SRD-FIN-GL , General Ledger , Problem

Product

SAP Business ByDesign all versions