News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) how do I print an expo...

Microsoft Dynamics GP (Archived)

how do I print an exportable list of GL expenses with the associated A/P check number

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

I am going through a Sales & Use tax audit. The auditor asked for a General ledger to pull the list of invoices that she wanted to audit. The G/L smartlist does not show check numbers. We file our checks in check number order, not by vendor. Is there a way to pull the check number related to the G/L expense account?

If I use the Originating Control number, it only pulls the check number for the entries in the A/P and cash accounts.

Thanks for your suggestions.

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Victoria Yudin 22,766 on at

Like (0)

Report

Re: how do I print an exportable list of GL expenses with the associated A/P check number

Thanks for the shout out Leslie V.! :-)

And Leslie O. - using the originating control number from the GL, you can use this view to find what check paid the invoice: victoriayudin.com/.../sql-view-ap-apply-in-gp.
L Vail 65,271 on at

Like (0)

Report

Re: how do I print an exportable list of GL expenses with the associated A/P check number

Take a look at Victoria Yudin' blog. She has TONS of useful scripts for extracting data related to A/P transactions (and others!)

victoriayudin.com/.../payables-sql-code

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans