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 like FBL3N (Display G/L Account Line Items) to review the line items and identify discrepancies.
  Compare the balances in the general ledger with the sub-ledgers (if applicable).
  
  
  
  Review Document Postings:
  
  Look for any missing or incorrectly posted documents. Ensure that all relevant documents are posted correctly and that there are no unposted items.
  Use transaction codes like FB03 (Display Document) to review individual documents.
  
  
  
  Check Configuration:
  
  Verify the configuration settings for the account and company code. Ensure that the account is set up correctly in the chart of accounts and that all necessary settings are in place.
  
  
  
  Adjustments:
  
  If discrepancies are found, make the necessary adjustments to correct the postings. This may involve reversing incorrect entries or posting additional entries to balance the accounts.
  
  
  
  Consult Documentation: 
  
  Refer to SAP documentation or help resources for specific guidance on handling this error message. The SAP Notes and Knowledge Base Articles may provide additional insights.
  
  
  
  Contact Support: 
  
  If the issue persists after performing the above checks, consider reaching out to SAP support for further assistance. They can provide more detailed troubleshooting based on your specific system configuration.
  
  
  
  Related Information:
  
  
  Transaction Codes: Familiarize yourself with relevant transaction codes such as:
  
  FBL3N: Display G/L Account Line Items
  FB03: Display Document
  FAGLB03: Display G/L Account Line Items (New GL)
  
  
  
  SAP Notes: Search for SAP Notes related to error MQ221 for any specific patches or updates that may address known issues.
  
  
  Training and Documentation: Ensure that users involved in financial postings are adequately trained on the processes to minimize errors in data entry and posting.
  
  
  By following these steps, you should be able to identify the cause of the MQ221 error and implement a solution to resolve it.