web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

How to find invoices based on a check number?

(0) ShareShare
ReportReport
Posted on by 5

Hello, 

I have looked and can't seem to find this information anywhere - how do I find invoices based on just a check number? 

I have the same question (0)
  • Brian_IL Profile Picture
    719 on at
    RE: How to find invoices based on a check number?

    The payment information is associated with the invoices being paid in the APAdjust table. That information could be retrieved via a SQL query, a Quick Query view, or a Crystal report, depending on the intended use of the information and the knowledge of the end user retrieving that information from the system.

  • Missionsoft Consulting Profile Picture
    30 on at
    RE: How to find invoices based on a check number?

    There should be a "Payment Applications" report option under the AR module. You can simply restrict the report to only display the specific check number by entering that check number under the Select tab of the Report Options screen. The field to use is ardoc.refnbr

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,047

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 885 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 592 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans