Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Newbie Question about Custom Report in GP 2016

Posted on by Microsoft Employee

Hello, I am very new to Microsoft Dynamics GP. My company is using the 2016 version. Most of my work involves entering invoices. We've noticed that we have a lot of vendors who were entered with no standard purchasing terms. I'd like to create a list of everyone who is active but who isn't on Net30, so I can go in and change them.

How do I create such a report?

It would need to be restricted to active vendors, and I'd like to see their Class ID, their code and name, and the amounts they have invoiced us for over the last two year. And, of course, I need to see their standard Payment Terms.

I can see how to call up various reports that either came loaded on the program or that perhaps my predecessor designed. But how do I start from scratch and design my own?

*This post is locked for comments

  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 3,141 on at
    RE: Newbie Question about Custom Report in GP 2016

    As previously mentioned, SmartList is the way to go.  You'll find this in GP 2016 at Microsoft Dynamics GP > SmartList.

    Once SmartList opens, navigate to the Purchasing > Vendors folder.  From here, pick any default favorite and then use the Columns button to add any the additional information (like Payment Terms ID) and then the Search button to add a Search for Payment Terms ID is not equal to Net30.

    Spending some time watching the videos/reading the blogs users mentioned are a great use of your time.  SmartList is very powerful, user-friendly, and easily sends data to Excel.  You'll find in GP that it is a simple way to handle most user-requested reporting that involves rows of data.

  • tjr2jtr2 Profile Picture
    tjr2jtr2 105 on at
    RE: Newbie Question about Custom Report in GP 2016

    or - you could look up videos on you tube - there is a lot of info out there

  • tjr2jtr2 Profile Picture
    tjr2jtr2 105 on at
    RE: Newbie Question about Custom Report in GP 2016

    www.advantage.co.uk/.../

    This page has all the basics!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Newbie Question about Custom Report in GP 2016

    Could you explain to me the basic steps involved in creating a smartlist report?

  • tjr2jtr2 Profile Picture
    tjr2jtr2 105 on at
    RE: Newbie Question about Custom Report in GP 2016

    you should be able to create a smartlist report pulling this info

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans