SAP Knowledge Base Article - Public

3634279 - Tax amount, discount amount and invoice amount calculation scenarios

Symptom

Tax amount, discount amount or invoice amount are not calculated as expected when posting an invoice.

Environment

SAP S/4HANA Cloud Public Edition.

Cause

Configuration for the "Tax base is net Value" and "Discount base is net Value" indicators.

Resolution

Check the "Tax base is net Value" and "Discount base is net Value" indicators in the following configurations:

  • Company code master data  in SSCUI 100135
  • "Define Countries/Regions" in SSCUI 104076
  • "Edit Tax Information for Company Codes" under SSCUI 105675

Ensure these indicators set up according to the desired behavior.

Calculation examples for "Tax base is net Value" and "Discount base is net Value" combinations:

Below, an example is given for each possible combination. In each case, the material value is 100.00, the possible discount percentage 3.00 %, and the tax percentage 10.00 %.

  1. Gross tax base, Gross discount base
       Tax base 100.00       ==> Tax amount   10.00
       Possible discount amount (3.00 % of 110.00)   3.30
       Invoice amount 110.00
  2. Gross tax base, Net discount base
       Tax base 100.00       ==> Tax amount   10.00
       Possible discount amount (3.00 % of 100.00)   3.00
       Invoice amount 110.00
  3. Net tax base, Net discount base
       Tax base 97.00       ==> Tax amount    9.70
       (Tax base = Value of goods - Possible discount = 100.00 - 3.00)
       Possible discount amount (3.00 % of 100.00)   3.00
       Invoice amount 109.70
  4. Extremely rare case (only permitted when jurisdiction code is used)
       Net tax base, Gross discount base
       The value of the goods is not 100 but 100.30 so that the figures in this case
       can be compared to those in the other cases.
       Tax base 97.00       ==> Tax amount    9.70
       (Net value of goods + Tax = 97.00 + 9.70 = 106.70)
       Since the discount base is gross, this value represents 97%
       of the gross invoice amount.
       Invoice amount = 110.00
       Possible discount amount (3.00% of 110.00)    3.30

For further details, check the "Help" information by right-clicking on the "Tax base is net Value" and "Discount base is net Value".

Keywords

Discount, tax amount, invoice amount, calculation of sales tax, net value , KBA , FI-FIO-AP-2CL , Fiori UI for Accounts Payable (Public Cloud) , FI-FIO-AR-2CL , Fiori UI for Accounts Receivable (Public Cloud) , FI-GL-GL-F-2CL , Value Added Tax (VAT) (Public Cloud) , How To

Product

SAP S/4HANA Cloud Public Edition all versions