SAP Knowledge Base Article - Public

3523930 - Incorrect Mapping of Fields in Excel Template File for Manual VAT Entries

Symptom

In the excel file template used for uploading manual VAT entries, two headers are incorrectly mapped: the value set in the file for the field Posting Date goes to the field Tax Due Date in the manual VAT entry, and the value set in Account Assignment Type goes to Posting Date in the manual VAT entry.

Environment

SAP Business ByDesign 2408

Reproducing the Issue

A) Download the excel template file for uploading manual VAT entries:

  1. Go to the Tax Management work center.
  2. Go to the Manual Tax Entries view, VAT Entries subview.
  3. Click New, Tax Entry from Microsoft Excel®.
  4. Select Template Name Manual Tax Entries Upload and click Download.

B) Open the excel template file and enter data:

  1. Open the excel template file.
  2. Enter mandatory data and values in the fields Posting Date (enter a date) and Account Assignment Type (enter a date).
  3. Upload the file to the system.
  4. Check the VAT entry created in the system: the value entered for Posting Date in the excel file is reflected in the field Tax Due Date in the manual VAT entry, and the value entered for Account Assignment Type in the excel file is reflected in the field Posting Date in the manual VAT entry.

Cause

The issue is caused by incorrect mapping of Excel cells in the standard Microsoft Excel template Manual Tax Entries Upload.

Resolution

A permanent fix will be created, tested, and delivered by SAP in a future SAP Business ByDesign release. Meanwhile, the following workaround can be used:

  1. Download the Excel file in English language.
  2. Change the Header names: change Posting Date by Tax Due Date; change Account Assignment Type by Posting Date.
  3. Save the file.
  4. To upload the modified file, go to work center Application and User Management, view Microsoft Office® Template Maintenance.
  5. Select Template Group: Manual Tax Entries Upload.
  6. Find the template for language English.
  7. Click Upload and click Replace Existing Language Variant.
  8. Select the new template file and click ok.
  9. Click Publish.
  10. Now, the new template variant will be downloaded when clicking New, Tax Entry from Microsoft Excel® and selecting Manual Tax Entries Upload in Tax Management work center, Manual Tax Entries view, VAT Entries subview.

See Also

Keywords

Excel, Manual VAT Entries, Incorrect Mapping, Tax Management, Posting Date, Account Assignment Type, Tax Due Date, JIRA Item BYDDEV-13501, Workaround, Office Template Maintenance, Upload , KBA , SRD-FIN-TAX , Tax Management , Problem

Product

SAP Business ByDesign 2408