How To Fix FQ781 - Two items exist with the same date

SAP Error Message - Details

• Message type: E = Error

• Message class: FQ - Payment Requests and Payment Program

• Message number: 781

• Message text: Two items exist with the same date

What causes this issue?

Two items exist with the same date. Either two deferral documents with
the same basic date were entered or deferral interest should be
calculated although this already exists.

System Response

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

How to fix this error?

Check your entries.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message FQ781 - Two items exist with the same date ?

  The SAP error message FQ781, which states "Two items exist with the same date," typically occurs in the context of financial transactions, particularly when dealing with payment processing or document postings in the SAP system. This error indicates that there are multiple entries (such as invoices or payment documents) that share the same date, which can lead to ambiguity in processing.
  Cause:
  
  Duplicate Entries: The most common cause is that there are two or more financial documents (like invoices or payment requests) that have been entered with the same posting date.
  Configuration Issues: Sometimes, the configuration settings in the SAP system may not allow for multiple entries on the same date for certain transactions.
  Data Entry Errors: Manual data entry errors can lead to the creation of duplicate records with the same date.
  
  Solution:
  
  
  Identify Duplicate Entries: 
  
  Use transaction codes like FBL1N (Vendor Line Item Display) or FBL3N (G/L Account Line Item Display) to check for duplicate entries on the specified date.
  Filter the results by date to see if there are multiple entries.
  
  
  
  Adjust or Delete Duplicates:
  
  If duplicates are found, you may need to adjust or delete one of the entries to resolve the conflict. Ensure that you have the necessary authorizations to make these changes.
  If the duplicates are legitimate (e.g., they represent different transactions), consider changing the posting date of one of the entries to avoid the conflict.
  
  
  
  Review Configuration Settings:
  
  Check the configuration settings in the SAP system to see if there are any restrictions on posting multiple entries on the same date. This may involve consulting with your SAP administrator or finance team.
  
  
  
  Consult Documentation:
  
  Review SAP documentation or consult with your SAP support team for specific guidance related to your organization's configuration and processes.
  
  
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes for financial reporting and document management, such as FB03 (Display Document), FB60 (Enter Incoming Invoice), and F-28 (Post Incoming Payments).
  SAP Notes: Check SAP Notes for any known issues or patches related to this error message. SAP Notes can provide additional context or solutions for specific scenarios.
  User Roles and Authorizations: Ensure that users have the appropriate roles and authorizations to view and modify financial documents, as this can impact their ability to resolve the error.
  
  If the issue persists after following these steps, it may be beneficial to escalate the matter to your SAP support team or consult with an SAP expert for further assistance.