Skip to main content
Answer

Accounts Payable report/ inquiry - Check number and invoice

  • August 25, 2023
  • 4 replies
  • 448 views

Forum|alt.badge.img

Is there a report/ inquiry in Acumatica that shows the check# and invoices it was applied to by vendor?

 

For example:

 

Best answer by dcomerford

Hi you need to base your GI on the APAdjust and APPayment table here is one i mocked up for you which should do the job you can add a filter on it just to get checks

4 replies

Forum|alt.badge.img+2
  • Jr Varsity III
  • August 25, 2023

Enriquey,

Does the Check Register under Accounts Payable | Inquiries work for you?

 


Forum|alt.badge.img
  • Author
  • Freshman I
  • August 25, 2023

@SheriThomas49 I need to show invoice # associated with check#.


dcomerford
Captain II
Forum|alt.badge.img+15
  • Captain II
  • Answer
  • August 25, 2023

Hi you need to base your GI on the APAdjust and APPayment table here is one i mocked up for you which should do the job you can add a filter on it just to get checks


willie98
Jr Varsity II
  • January 14, 2025

We had a modification done for a client where for quick reference from Vendor screen, we added a new tab called Check Inquiry where they can see all Invoices paid on one Payment.

If that works for you, ask your ISV to do.