Skip to main content
Question

Invoice payment details in AP Generic Inquiry

  • April 7, 2026
  • 3 replies
  • 23 views
T
Freshman I

Hi everyone,

 

I wanted to check if there is an existing standard report or Generic Inquiry that allows users to search vendor or sub contractor invoices and view related payment details, specifically:

  • Amount paid
  • Payment date
  • Associated cheque number or EFT reference

If not available out of the box, I would appreciate guidance on:

  • Which tables or data sources to use (e.g., APInvoice, APPayment, etc.)
  • Any recommended approach to linking invoices to payments within a GI

Thank you in advance for your help!

      3 replies

      F
      Jr Varsity III
      Forum|alt.badge.img
      • FarhanaM60
      • Jr Varsity III
      • April 7, 2026

      You can build a custom GI using:

      • APInvoice (invoice data)
      • APPayment (payment data)
      • APAdjust (link between invoice and payment)

      Join using:

      • APInvoice → APAdjust (AdjdDocType / AdjdRefNbr)
      • APAdjust → APPayment (AdjgDocType / AdjgRefNbr)

      Use:

      • APAdjust.CuryAdjdAmt → Amount Paid
      • APPayment.DocDate → Payment Date
      • APPayment.ExtRefNbr → Check/EFT Reference

      Best practice is to use APAdjust as the primary table in the GI.

        T
        Freshman I
        • theoolaleye00
        • Author
        • Freshman I
        • April 7, 2026

        ​@FarhanaM60

        Thanks 

        Deeply appreciate  

          Laura03
          Captain II
          Forum|alt.badge.img+20
          • Laura03
          • Captain II
          • April 8, 2026

          ​@theoolaleye00 ,

          Did you notice this prior post where the exact same question was asked and answered yesterday in Financials forum?

          Hope this helps.

          Laura

          ~ Laura Barber, WM Synergy
            Terms & ConditionsCookie settingsAccessibility statement
            About Acumatica ERP system
            Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
            © 2008 — 2024  Acumatica, Inc. All rights reserved