SAP Knowledge Base Article - Public

3128742 - Tolerance threshold impacted with negative book quantity with a positive value

Symptom

  • The app 'Process Physical inventory Count Results' is considering the difference value as positive when the entered Count Quantity is negative, which is impacting the Physical Inventory Tolerance.
  • Error 'M7777 Amount to High' when posting the Difference for a Physical inventory Document.

Environment

  • SAP S/4HANA Cloud

Reproducing the Issue

Within the SSCUI 102005, Tolerance is maintained as:

Maximum difference amount per physical inventory document = 100,000.00 

Maximum difference amount per phys. inventory document item = 10,000.00

  1. Create a Physical Inventory Document.
  2. Enter the Count for each item.
  3. Enter a Count Quantity which is less then the Book Quantity for one item.
  4. Review the Physical Inventory Document in the app 'Process Physical inventory Count Results'.
  5. Difference Quantity displays the Difference Quantity as negative but the Difference Value is positive.

Cause

The 'Difference Quantity' displays the quantity as negative but the 'Difference Value' is positive. The sum of all the differences together is over the 100,000.00

Process Physical inventory Count Results

PI Doc           Material   Plant   Sloc    Book Qty  Qty Count   Diff Qty           Diff Value

100009610  1   PI1      1010   101A   350.000      50.000  300.000-EA        6,000.00 EUR   <<---
100009610  2   PI10    1010   101A   470.000    900.000    430.000 EA          8,600.00 EUR
100009610  3   PI11    1010   101A   470.000    900.000    430.000 EA          8,600.00 EUR
100009610  4   PI12    1010   101A   480.000    700.000    220.000 EA          4,400.00 EUR
100009610  5   PI13    1010   101A   480.000    800.000    320.000 EA          6,400.00 EUR
100009610  6   PI2      1010   101A   150.000    500.000    350.000 EA          8,750.00 EUR
100009610  7   PI3      1010   101A   400.000    900.000    500.000 EA        10,000.00 EUR
100009610  8   PI4      1010   101A   450.000    900.000    450.000 EA          9,000.00 EUR
100009610  9   PI6      1010   101A   470.000    970.000    500.000 EA        10,000.00 EUR
100009610 10  PI7      1010   101A   470.000    970.000    500.000 EA        10,000.00 EUR
100009610 11  PI8      1010   101A   470.000    970.000    500.000 EA        10,000.00 EUR
100009610 12  PI9      1010   101A   470.000    970.000    500.000 EA        10,000.00 EUR

                                                                                                            101,750.00 EUR   <<---
       

When I try Post the Difference for the Physical Inventory Document, I see the error ‘M7777 Amount to High’

In the debugger, here you can see that the Tolerance is 100,000.00 (T043I-MAXBT) and the Overall Value in the posting is 101750.00 (MAXBT). The error is raised because MAXBT is higher then T043I-MAXBT.

SAPMM07I     / MM07IFI0
FORM            / ISEG_FUELLEN

IF maxbt < 0.                                            " 73726
    maxbt_abs = 0 - maxbt.                        " 73726
  ELSE.                                                     " 73726
    maxbt_abs = maxbt.                             " 73726
  ENDIF.                                                    " 73726
  IF maxbt_abs > t043i-maxbt.                   " 73726
* IF MAXBT > T043I-MAXBT.                       " 73726
*   Differenzbetrag ist zu hoch
    MESSAGE e777 WITH t043i-maxbt t001-waers.
    EXIT.
  ENDIF.
  IF NOT xtoleranz IS INITIAL.
    DESCRIBE TABLE liseg LINES index_i.
    IF xtoleranz = index_i.

 

                               SY-MSGNO                               777
                               T043I-MAXBT                          100000.00
                               T001-WAERS                           EUR
                               MAXBT                                    101750.00

Resolution

If its the case that the Difference cannot be posted due to the tolerance levels.

  1. You can increase the tolerance via the SSCUI 102005.
  2. Alternatively you can adjust the Count Quantity via a Recount in order to lower the value.
  3. Remove / Delete this material from the Physical Inventory Document and create a new PI Document for the material.

See Also

73726 MI10: Tolerance check of the inventory difference

Keywords

Tolerance, 102005, Physical Inventory, PI, Book Quantity, Count, Quantity, BUCHM, Positive, Negative, Value, MI20, Process Physical inventory Count Results, M7777, Amount to High, Difference Value, , KBA , MM-IM-PI-PI , Physical Inventory , How To

Product

SAP S/4HANA Cloud 2111