SAP Knowledge Base Article - Public

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

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

  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: &".

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

Product

SAP S/4HANA Cloud all versions