Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Where do I find the Ch...
Microsoft Dynamics SL (Archived)

Where do I find the Check #, Check Date and Check Amount fields in the database

(0) ShareShare
ReportReport
Posted on by Last Jedi 80
I have a report and I need to pull the Check #, Check Date and Check Amount fields into the report.
 
 I Currently have the reference number from ARDoc table.

Which tables can I pull these fields from?

*This post is locked for comments

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    RE: Where do I find the Check #, Check Date and Check Amount fields in the database

    Hello Jedi,

    I assume these are AP checks?  If so, then the information you are looking for is in APdoc.  The refnbr field will contain the check number, the OrigDocAmt will contain the Amount, and the DocDate will contain the date.  There could be the same Refnbr for different checking accounts or a voucher could have the same refnbr.  So you also want to make sure the item has a DocClass of C to make sure you are pulling the info for a check document.  

    Let me know if you have additional questions.

  • Blaine Bryant Profile Picture
    Blaine Bryant on at
    RE: Where do I find the Check #, Check Date and Check Amount fields in the database

    Last Jedi,

    Let me do some research on this and get back to you.

  • Butch Adams Profile Picture
    Butch Adams 4,757 on at
    RE: Where do I find the Check #, Check Date and Check Amount fields in the database

    That info is in APAdjust.

    This is off the top of my head, but AdjGRefnbr is the check number and AdjDRefnbr is the APDoc refnbr to do your join on.

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

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans