How To Fix MQ221 - Sum of document differences in company code & for account & : &

SAP Error Message - Details

• Message type: E = Error

• Message class: MQ - Messages for Euro Changeover Package

• Message number: 221

• Message text: Sum of document differences in company code & for account & : &

What causes this issue?

The cause of this message is to be found in one or more documents that
were posted in document currency EUR prior to the conversion. For
example, you have a purchase order in EUR for a standard price material.
A goods receipt is posted before the conversion. The price in the
material master is maintained in local currency. As a result, there are
differences between the local currency amount that was posted to the
inventory account, and the foreign currency amount. This means that when
you display the value of the inventory posting in local currency in the
original accounting document for this goods receipt, then translate this
value into document currency, you do not obtain the value that has been
entered in the accounting document as the inventory posting foreign
currency amount. (For an explanation of the posting logic for foreign
currency purchase orders, see SAP Note 191927.)

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

During the euro conversion phase, the local currency amounts for the
accounting document were overwritten by the foreign currency amounts if
the document had been posted in EUR. If a difference existed, as in the
example above, this was stored in table EWUFI_CDOC.
The total of these differences should amount to the difference
determined by report EWUMMBST(_40), and is corrected by report EWUMFPST
in the POST phase. This difference was stored in in table EWUMMFI by
report EWUMMBST_40. You can use report ZASEWUFI to find these documents.
See SAP Note 213669. The adjustment posting made by report EWUMFPST
corrects the foreign currency amount, that was originally considerably
different. This posting is correct even if the amount is greater than
the value that is obtained for the maximum rounding difference under the
following formula:
Maximum size of small differences per account =
(Number of valuated materials for the inventory account) x (0.005 Eur)

System Response

How to fix this error?

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message MQ221 - Sum of document differences in company code & for account & : & ?

  The SAP error message MQ221 indicates that there is a discrepancy in the document differences for a specific company code and account. This error typically arises during the reconciliation process or when trying to post documents that do not match the expected balances in the system.
  
  Cause:
  
  
  Document Differences: The sum of the differences between the debits and credits for a specific account in a company code does not match the expected total. This can happen due to:
  
  Incorrect postings in the general ledger.
  Missing or unposted documents.
  Manual adjustments that were not properly recorded.
  Data entry errors.
  
  
  
  
  Configuration Issues: There may be issues with the configuration of the account or company code settings that lead to discrepancies.
  
  
  Timing Issues: If documents are posted in different periods or if there are open periods that are not properly closed, this can lead to differences.
  
  
  
  Solution:
  
  
  Reconcile Accounts: 
  
  Check the account balance for the specified company code and account. Use transaction codes