SAP Knowledge Base Article - Public

2842333 - When Exporting Spanish VAT Return to Excel the Total Gross Amount is Incorrect

Symptom

You export the Spanish VAT return to Excel and notice that the Total Gross Amount is being calculated incorrectly.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Tax Management Work Center.
  2. Select the view Tax Returns.
  3. Select the subview VAT Returns.
  4. Select Tax Return ID XXX (XXX represents the exact Tax Return ID).
  5. Click on View.
  6. Navigate to the Tax Return Tab.
  7. Click on Export to Excel.
  8. The Gross Amount Column does not display the correct amounts.

Cause

The Export to Excel is a generic functionality and the excel sheet is not customized according to specific countries, therefore this function is meaningless in this instance.

Resolution

For Spanish VAT Returns the following fields are relevant:

  1. - Tax Payable/ Receivable
  2. - Tax Type
  3. - Tax Event
  4. - Tax Rate
  5. - Tax Base Amount
  6. - Tax Amount

Keywords

Spanish VAT Return Gross Amount, VAT Return Gross Amount, VAT Return Export Excel. , KBA , SRD-FIN-TAX , Tax Management , Problem

Product

SAP BUSINESS BYDESIGN 1611 ; SAP BUSINESS BYDESIGN 1705 ; SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1.0 ; SAP Business ByDesign 1302 ; SAP Business ByDesign 1305 ; SAP Business ByDesign 1308 ; SAP Business ByDesign 1311 ; SAP Business ByDesign 1402 ; SAP Business ByDesign 1405 ; SAP Business ByDesign 1408 ; SAP Business ByDesign 1411 ; SAP Business ByDesign 1502 ; SAP Business ByDesign 1505 ; SAP Business ByDesign 1508 ; SAP Business ByDesign 1511 ; SAP Business ByDesign 1602 ; SAP Business ByDesign 1605 ; SAP Business ByDesign 1608 ; SAP Business ByDesign 1702 ; SAP Business ByDesign 1711 ; SAP Business ByDesign 1802 ; SAP Business ByDesign 1805 ; SAP Business ByDesign 1808 ; SAP Business ByDesign 1811 ; SAP Business ByDesign 1902 ; SAP Business ByDesign 1905 ; SAP Business ByDesign 1908 ; SAP Business ByDesign 1911 ; SAP Business ByDesign 2002 ; SAP Business ByDesign feature pack 2.0 ; SAP Business ByDesign feature pack 2.5 ; SAP Business ByDesign feature pack 2.6 ; SAP Business ByDesign feature pack 3.0 ; SAP Business ByDesign feature pack 3.5 ; SAP Business ByDesign feature pack 4.0