News and Announcements icon

Dynamics 365 CommunityForums 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) Share

Report

Report

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

All responses Img

All responses (3)

Answers Img

Answers (0)

Carolyn Kolpien on at

Like (0)

Report

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 on at

Like (0)

Report

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 4,763 on at

Like (0)

Report

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.

Helpful resources

News and Announcements

Check out the New Agent Creator Community

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans