web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Assistance with creating smartlist and Payables data

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • Suggested answer
    KirkLivermont Profile Picture
    5,985 on at

    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

  • Suggested answer
    soma Profile Picture
    24,410 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans