web

You’re offline. This is a read only version of the page.

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

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Butch Adams 4,763 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Blaine Bryant on at

Like (0)

Report

Last Jedi,

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

Was this reply helpful? Yes No
Carolyn Kolpien on at

Like (0)

Report

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.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans