3588641 - Discrepancy in the balance company currency value between G/L Account Line-Item Report and All VAT/Sales Tax Items Report

• A discrepancy is observed in the balance company currency value while comparing the G/L account line-item report with the 'All VAT / Sales Tax Items' report.
• The expectation is that the balance company currency value of the required G/L account should match with the applicable tax amount in the All VAT / Sales Tax Items report.

SAP Business ByDesign

1. Go to the General Ledger work center.
2. Go to the Reports sub view.
3. Search for the report: G/L account Line items.
4. Apply the data selection as follows: Company, set of books, G/L account, Posting date.
5. Give apply and take a note of Balance company currency value.
6. Navigate to the Tax management work center.
7. Go to the Reports sub view.
8. Search for the report: All VAT / Sales Tax Items.
9. Apply the data selection as follows: Company, Tax due date.
10. Give apply and take a note of Applicable Tax amount.
11. Compare the value of Balance Company currency from the G/L account line items report and the value of Applicable tax amount from the All VAT / Sales Tax Items report.

The values do not match.

The discrepancy is caused by the comparison between ledger and subledger. The All VAT / Sales Tax Items report is designed for Tax Lines as per Taxes Due-Date and does not have the option to check the report as per the G/L Accounts.

In the report --> G/L account line items view, the value of balance company currency will be generated with the inputs of below mentioned data

• Company
• Set of Books
• G/L account
• Posting date

But it is not the same case in the report --> All VAT/Sales Tax items with the below mentioned inputs like,

• Company
• Tax due date

Basically, when there is no G/L account field for selection in this report, the data its generating as total applicable tax amount cannot be considered for the comparison with the balances in the G/L account line item generated with the restriction for certain period. Per default the Applicable Tax Amount is the actually posting tax amount with deductibility taken into account and not the balance of G/L accounts.

The System is behaving as expected.

1. Refer to the Tax Line Items Report as it has G/L Account in Data Selection which can demonstrate the Company Currency Balances as per G/L Account.
2. Check the Tax Line Items Report with the same data selection as provided in G/L Line-Item Report.
3. Add the field "Balance Company Currency" to the Column in the Tax Line Items Report.
4. The reports should now be in sync and display the consistent Balances for G/L Accounts

G/L account line items report, All VAT / Sales Tax Items report, discrepancy, balance mismatch, Tax Line Items Report, Balance Company Currency, G/L Accounts. , KBA , SRD-FIN-TAX , Tax Management , Problem