Home › Discussions › Questions & Answers › Tracking Supplier Invoice Payments to Checks

Tracking Supplier Invoice Payments to Checks

Avatar photoCustomer July 15, 2024 at 1:41 am

We need a report detailing supplier invoice payments, specifically designed to handle situations where one check pays multiple invoices, or where an invoice has multiple payments. How can I ensure correct reconciliation figures?

Viewing 6 reply threads
  • Author
    Replies
    • Support July 16, 2024 at 6:39 am  

      Use the AP Invoice Payments report. It provides supplier invoice payment details and includes logic to allow reconciling payment with invoices and checks.

    • Avatar photoCustomer July 16, 2024 at 3:59 pm  

      In the case where multiple payments exist for one invoice, how are the check and invoice level amounts displayed to avoid duplication?

    • Support July 18, 2024 at 11:25 am  

      To prevent reconciliation confusion, the invoice and check level amounts are shown only on the last payment record associated with the transaction, and are blank for multiple/duplicate records.

    • Avatar photoCustomer July 18, 2024 at 11:31 pm  

      If I need a summary of posted payments categorized by GL account, is there a related report for that?

    • Support July 19, 2024 at 10:46 am  

      Yes, you can use the AP Posted Payment Register report. It offers templates, such as ‘Pivot: Summary by Account’, which is equivalent to the standard report in ‘Summarize Report = Yes’ mode.

    • Avatar photoCustomer July 19, 2024 at 10:32 pm  

      If I need to track the status of large payment processes managed by the Payment Manager, which report should I use?

    • Support July 21, 2024 at 3:50 am  

      For payment process requests, run the IBY Payment Process Request Details report. This shows details including statuses, paid or rejected documents, amounts, and rejection error messages.

  • Author
    Replies
Viewing 6 reply threads
  • You must be logged in to reply to this post.

Login with:
Popular Posts
How to track master data changes using Oracle EBS Audit function and Blitz Report™ 123806

Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8 19953

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14682

How to check if a patch is applied in Oracle EBS 12.2 14435

Oracle Discoverer 11.1.1.7 installation and integration with Oracle EBS R12.1.3 14123

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 11999

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 9945

Migration to Java Web Start in Oracle EBS 12.2 instance 9938

Securing sensitive data with Oracle VPD 7864

EBS 12.1.3 BI Publisher Excel templates generate XLS instead of XLSX and limit row number to 65,536 6490

Blog Archive
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
Recent Events
2026
2025
2024
2023
2022
2021
2020
2019
2018