Symptom
During upload of excel template in App Import Supplier Invoices error "Balance not zero: & debits: & credits: &" occurs.
Environment
SAP S/4HANA Cloud
Reproducing the Issue
- Enter App Import Supplier Invoices.
- Import template file. The file contains tax code (column BT) and the G/L Accounts (column BP) are relevant to tax (Tax category is not empty in G/L master).
- Check the error after the import: "Balance not zero: & debits: & credits: &".
Cause
'Gross Invoice Amount in Document Currency' in column K in the template file is filled incorrectly.
Resolution
Tax calculation logic is based on the followings:
Gross Invoice Amount in Document Currency = Amount in Document Currency' + Amount in Document Currency * Tax rate.
For example:
Amount in Document Currency (column BS) = 100 EUR.
Tax code is maintained with 10% rate.
Calculation of Gross Amount = 100 EUR + (100 EUR*0,1) = 110 EUR
So in the Gross Invoice Amount in Document Currency 110 EUR should be added.
Keywords
import, supplier, invoice, balance mismatch, M8534, gross, document currency, F3 041, F3041, balance not zero , KBA , FI-FIO-AP-TRA-2CL , Transaction Apps: Public Cloud , Problem