Tax amount is showing worng in the line item level.
SAP Business ByDesign
Reproducing the Issue
In this case we are using Customer Invocie as example.
- Go to Customer Invoicing work center.
- Go to Invoice Documents view.
- Edit the Invoice ABC and click on View All. (ABC represents the Invoice ID)
- Navigate to Items tab.
- Select the line item and go to Taxes sub tab.
- Tax Amount is showing wrong when compared to the Tax Rate and Tax Base Amount.
Tax Amount difference is showing due to the Tax Difference Distribution as mentioned in the blog Rules of Tax Difference Distribution in SAP Business ByDesign
We will explain the same with the below sample Document.
The Invoice ABC is having 2 line items each having List Price 3,354.54, Quantity 1 and Tax is 23 (%)
Therfore the Total Item Net Value is 6,709.08
Total Tax = 6,709.08 * 23/100 = 1543.0884
The amount will round to two digits after decimal, therefore it becomes 1543.09
So now we need to split the 1543.09 equally to all line items.
Since there are 2 line items with value 1543.09/2 = 771.545
The line item amount 771.545 need to be rounded to two digits after decimal, but need to make sure the total of line item amount should be same as total header amount.
Therefore to achieve this at line item level we need to maintain as below
Tax for Line item 10: 771.55
Tax for Line item 20: 771.54
Tax for Line items 771.55 + 771.54 = Total tax 1,543.09
This is standard system behavior.
[Enter your See Also here...]
Tax Amount varies; variation in tax amount; , KBA , AP-PRC-PC , Calculation , Problem