You are executing Manual Reconciliation Run and comparing the results with the Automatic Reconciliation Run executed by the ByDesign system.
SAP Business ByDesign
Reproducing the Issue
- Go to the General Ledger work center.
- Click on Reconciliation.
- Click on the New -> Reconciliation.
- Fill the data and execute the Run.
- When you open the Log Result then you can see the multiple errors. For example -
- Calculated tax amount differs from posted tax amount for journal entry.
For the subledgers (tax, materials), when you execute a manual Reconciliation Run, you get the balance data along with the the VAT/Sales Tax Calculation details report data.The Automatic Reconciliation Run always run on the TBT (Totals and Balances) data - they do not execute the VAT/Sales Tax Calculation details report and so no data will ever be filled for this tab - This is a system behavior.
Only if the overall balances have an issue, then a healthcheck would be raised by the system to SAP for investigation on why the balances shows difference. The healtcheck incidents are only for the totals and balances data.
It is highly recommended that you perform a reconciliation run manually before each year-end closing to avoid such inconsistencies.
Automatic Reconciliation Run, Manual Reconciliation Run, Reconciliation Health check incident , KBA , manual reconciliation run , reconciliation health check incident , automatic reconciliation run , AP-ACC , Business ByDesign: Financial Accounting , Problem