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
- Go to Tax Management work center.
- Go to Manual Tax Entries.
- Click "New" button > Tax Entry from Microsoft Excel.
- Open the provided Excel template.
- Go to SAP BUSINESS BYDESIGN Add-in in Excel and Logon to the system.
- Fill with the required parameters.
- Click on 'Save Data to'.
- 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.
- Open the Excel template.
- Remove entries with zero Debit/Credit amount.
- Save the changes to the Excel template.
- 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