3461796 - "Balance not zero: & debits: & credits: &"  error in App Import Supplier Invoices - S/4HANA Cloud

During upload of excel template in App Import Supplier Invoices error "Balance not zero: & debits: & credits: &" occurs.

SAP S/4HANA Cloud

1. Enter App Import Supplier Invoices.
2. 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).
3. Check the error after the import: "Balance not zero: & debits: & credits: &".

'Gross Invoice Amount in Document Currency' in column K in the template file is filled incorrectly.

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.

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

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions