Skip to main content
Question

AP Generic Inquiry for Invoice Payment Details (Amount Paid, Payment Date, Check/EFT

  • April 7, 2026
  • 4 replies
  • 19 views
T
Freshman I

Hi everyone,

I’m new to Acumatica and currently exploring the Accounts Payable module and Generic Inquiries.

I wanted to check if there is an existing standard report or Generic Inquiry that allows users to search vendor 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!

      4 replies

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

      Hello ​@theoolaleye00 ,

      APAdjust table holds fields relating Bills to their Payments. Suggested Join is shown below. Good luck!

       

      ~ Laura Barber, WM Synergy
        T
        Freshman I
        • theoolaleye00
        • Author
        • Freshman I
        • April 7, 2026

        Thanks Laura for prompt response .

        Was this a customised for your team? . I cant see this inquiry on our GI 

         

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

          Also can you please send me screenshots of data source , parameters , conditions , Groupings etc so that i can build a new one ?

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

          Yes, I showed a custom generic inquiry - I don’t know of any standard GI in AP that shows the Bills connected to Payments (though we can see payments on the Applications tab of paid bills simply by opening the Bills to the screen).

          Vendor Balance report can be printed with Payment applications, out of the box.

          I showed the hard part:  which tables and the join.  You are free to create your own parameters & conditions as needed:  my GI has no parameters or conditions other than what I started with, a copy of AP Bills & Adjustments GI.

           

          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