You open the report All VAT / Sales Tax Items and you expect to see all the data related to Payables and Receivables documents, but when you run the report, you see that in the columns related to Clearing data, just show # instead, and the Status is different from the one in document itself.
You check the Supplier/Customer Account Monitor and search for the documents listed in the report. You can confirm that those documents (e.g. Invoices) that showed # for Clearing ID and Status as Open in the report, are already cleared in Account Monitor. Then the system should show them in the report with Status as Cleared and show their respective IDs.
SAP Business ByDesign
Reproducing the Issue
Go to Tax Management work center.
- Go to Report view.
- Access List subview.
- Select report All VAT / Sales Tax Items.
- Enter meaningful data for your company.
- Press Apply button.
- Go to View tab.
- Add Clearing ID and Clearing Date in Row Fields.
- Then you see that the fields only show #, instead of the correct data.
The Clearing status that you see on report All VAT / Sales Tax Items is different from the Clearing status shown in Document Flow.
This document is related to Payment, is means that the Source Document was paid and cleared.
The Clearing Status that you see on report All VAT / Sales Tax Items indicates that the Tax Liability is cleared. For example, this Status is considered as cleared when this particular Invoice is picked up by a Tax Return and that Return is reported, then the status should change to Cleared, and the ID would be shown.
Hence the Clearing ID shown in the Document flow of the Source Document will not appear in the All VAT / Sales Tax Items report.
The system is working as designed and behavior is correct.
All VAT / Sales Tax Items. Report. Clearing. #. , KBA , SRD-FIN-TAX , Tax Management , How To