2744158 - All VAT / Sales Tax Items With Journal Entry Details Report Shows Duplicated Journal Entry Items

• You are using the report 'All VAT / Sales Tax Items with Journal Entry Details' (FINTAXU10_Q0001).
• All Journal Entry Items have two entries in the report (one Receivable and one Payable).
• You notice that for Journal Entry Item XX the report is displaying four entries (two Receivable and two Payable). (XX represents the relevant Journal Entry Item ID)

SAP Business ByDesign

1. Go to the Business Analytics work center.
2. Go to the Design Reports view.
3. Find the report called 'All VAT / Sales Tax Items with Journal Entry Details' (FINTAXU10_Q0001)
4. Enter the relevant Selection.
5. Arrange the Journal Entry Item ID column by order (Number Ascending).
   Note: All Journal Entry Items have two entries in the report however, there are four entries for Journal Entry Item XX. 

• You have added the Tax Amount Overridden to the Row Fields in the report.
• In this case the Tax Amount was overridden for Journal Entry Item XX, therefore the report is showing the Tax Amount and the Overridden Tax Amount which results in four entries for Journal Entry Item XX.

You can un-select the Tax Amount Overridden from the Row Fields following the steps below:

1. Click on View.
2. Click on the + sign next to Row Fields.
3. Type in Tax Amount Overridden in the Search Box.
4. Un-select the Tax Amount Overridden.
5. Click Ok.
   Note: Now the report is only showing two entries for the Journal Entry Item XX.

For further information regarding this report, please refer to the built-in document called ''All VAT / Sales Tax Items with Journal Entry Details'' that you can find in the Help Center.

VAT; Report; Sales; Tax; Journal; Entry; Details; Duplicate; Items; Overridden , KBA , SRD-FIN-TAX , Tax Management , Problem