SAP Knowledge Base Article - Public

3597878 - Error While Uploading Manual Tax Entries via Excel

Symptom

  • An error occurs while uploading manual Tax entries via Excel add-in.
  • The error messages include "Net Amount missing", "Property Movement Direction Code Missing", and "Tax not yet calculated".

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Tax Management work center. 
  2. Go to Manual Tax Entries. 
  3. Click "New" button > Tax Entry from Microsoft Excel. 
  4. Open the provided Excel template.
  5. Go to SAP BUSINESS BYDESIGN Add-in in Excel and Logon to the system.
  6. Fill with the required parameters. 
  7. Click on 'Save Data to'.
  8. Errors are displayed.

"Net Amount missing", "Property Movement Direction Code Missing", and "Tax not yet calculated".

Cause

The Excel template contains entries with zero Debit/Credit amount.

Resolution

To resolve this issue you need to remove all the entries with zero Debit/Credit amount.

  1. Open the Excel template.
  2. Remove entries with zero Debit/Credit amount.
  3. Save the changes to the Excel template.
  4. Retry uploading the manual VAT entries via Excel add-in.

Keywords

Error, uploading, manual VAT entries, Excel, Net Amount missing, Property Movement Direction Code Missing, Tax not yet calculated, zero Debit/Credit amount. , KBA , SRD-FIN-TAX , Tax Management , Problem

Product

SAP Business ByDesign all versions