Symptom
When running the Purchase Register - India report, key figure for Product Tax Base Amount in report shows wrong results when adding posting date either in selection or in characteristics as a column.
Environment
SAP Business ByDesign.
Reproducing the Issue
- Go to Business Analytics work center.
- Go to Design Reports view.
- Open the Purchase Register - India report.
- In the selection parameters, give an invoice ID.
- Run the report.
- Refer to Product Tax Base Amount key figure and note the presented amounts.
- In the selection parameters, give the invoice posting date as selection and/or add the Posting Date characteristic to the report.
Observe that the Product Tax Base Amount doubled/tripled once the posting date was added.
Cause
The company for the respective invoice has multiple set of books, hence the amount is multiplied by the number of set of books since it is not being shown as a characteristic nor used as a selection parameter in the report.
Resolution
To display the correct amount, either: Use Set of Books as a selection parameter, or Add the Set of Books characteristic to the report.
Keywords
Purchase Register, India, Set of Books. , KBA , SRD-FIN-GLO-TAX , GLO - Tax Declaration , How To
SAP Knowledge Base Article - Public