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

Tracking Supplier Invoice Payments to Checks

Avatar photoCustomer Questions & Answers 7 replies

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?

7 replies

  • Support Enginatics

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

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

  • Support Enginatics

    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.

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

  • Support Enginatics

    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.

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

  • Support Enginatics

    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.

  • You must be logged in to reply to this post.