News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Creating A/P Repor...

Microsoft Dynamics GP (Archived)

Creating A/P Report with Vendor Data in GP 10.0

(0) Share

Report

Report

Posted on by Anne Bronchetti

170

Can someone help me to create or locate an A/P report from GP which will include the following data: GL (Expense) Account, Transaction Date, Vendor Name, Amount? We need to be able to choose the expense account as the basis for the rest of the data. We need this for an audit and have been unable to capture this info via a canned report or smart list - the one smart list we did create provides these fields of data, but does not produce a complete set of data (i.e. we know of expenses that were charged there that do not show up on the report).

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Victoria Yudin 22,766 on at

Like (0)

Report

Re: Creating A/P Report with Vendor Data in GP 10.0

Hi Anne,

This might save you some time from having to create this yourself:

http://victoriayudin.com/2008/11/28/sql-view-to-show-all-gl-distributions-for-ap-transactions/

It doesn't have the Vendor Name, but that should be easy to add.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2

Martin Dráb 231,409 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans