SAP Knowledge Base Article - Public

3267065 - Unexpected Tax Condition value in item of Sales document or Billing document - S/4HANA Cloud

Symptom

  • In saved sales document or billing document, the tax condition has unexpected value.
  • In the condition detail screen (double click condition element) the system shows the field a value on 'Cond.rounding diff.'
  • This behavior also occurs before save the document, after display the header condition screen.
  • It does not affect only tax conditions, but all percentage conditions with flag 'Group condition' in 'Set Condition Types for Pricing' Configuration Activity (101120 on Manage Your Solution).

Environment

SAP S/4HANA Cloud All Versions

Reproducing the Issue

  1. Go to Create Sales Order and create a document with two items having:
    ItemNet valueTax value (20%)
    104,190,84
    208,381,68
  2. Display Header condition screen (Top menu path: Go to -> Header -> Conditions).
  3. Check the Condition screen of item 20 at item level (Top Menu path: Go to -> Item -> Conditions).
  4. Now the Tax will have condition value 1,67. In the condition details it will have 'Cond.rounding diff.' = 0,01-.

Cause

When displaying the header condition screen (or when saving the document) the system executes a function where group condition functionality is performed. As part of this functionality the system determines the condition value at header level. In our example 20% of (4,19 + 8,38) = 2,51. The sum of item tax values is 0,84 + 1,68 = 2,52. There is a rounding difference between sum of item tax values and header tax value. To make header value = sum of item values, the system assigns the difference to item 20.

Resolution

This is standard system behaviour. 

If you set the group indicator for a condition type and do NOT use a group condition routine, the system responds as follows in the standard system:

  1. To calculate the scale base value of the condition, the scale base values for all items that have a condition record with the same condition type and with the same variable key are added AND
  2. For percentage conditions, a rounding distribution is performed so that the value calculated for the entire document matches the total of the item values. To achieve this, a difference that may exist is added to the item that has the largest amount.

Consulting SAP note 1158475 gives more details.

Keywords

Rounding, Sales, Billing, Tax, Inconscistent, wrong, value, rounding, same, material, different, values, quantity , KBA , SD-BF-PR , Pricing , SD-BF-PR-2CL , Pricing (Public Cloud) , How To

Product

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