News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Assistance with creati...

Microsoft Dynamics GP (Archived)

Assistance with creating smartlist and Payables data

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

I'm trying to create a smartlist report that incorporates all purchases for a year to include purchase order information as well tied to the payables invoice. This is mainly for a sales tax audit. Here is some of the fields I need if someone has anything close to it please share. Mainly, looking for the payables invoice link to the purchase order detail.

 Vendor name

 Accounting Date/GL date

Payables Invoice #

Shipment/Invoice #

 Location indicator (State/County/City)

 Cost price

 Extended cost

 Item description/Item code

 Cost Center

 PO Number/Description

 Expense Account (if you can incorporate it)

 Expense Account Description (if you can incorporate it)

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

soma 24,406 on at

Like (0)

Report

RE: Assistance with creating smartlist and Payables data

Yes the join operation on the post from Victoria Yudin victoriayudin.com/.../sql-view-for-payables-invoices-originating-from-pop-in-dynamics-gp will help you to understand the payable invoices to purchase orders.
Suggested answer

KirkLivermont 5,985 on at

Like (0)

Report

RE: Assistance with creating smartlist and Payables data

Take a look at this view by Victoria Yudin. http://goo.gl/eryjMW

Your should be able to use it and SmartlistBuilder to get all of the information you need.

Regards.

Kirk Livermont

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