Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Help ASAP

Posted on by Microsoft Employee

Hi

 

does anyone know how to print a report showing account numbers and account type for every payables transaction?

I am working in version 10.

 

all cash accounts should be have an account type as cash, a lot of times the girls hit pay, and I have to go through every transaction to find out which one, having a report would help a lot when reconciling.

 

thank you

*This post is locked for comments

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: Re: Re: Help ASAP

    Hi Patricia,

    There is no one answer to your question.  A lot depends on the reports you will need and what you already own.  Another critical component will be what resources you have available. 

    For example, if you own SmartList Builder, you can easily use the code in the blog post I pointed you to to create a custom SmartList.  Here is a blog post going through this: http://victoriayudin.com/2009/04/20/how-to-use-a-sql-view-in-smartlist-builder/.  Steve Chapman also has a video on this: http://www.youtube.com/watch?v=sAnz1gzZHnk.

    Another example - you have an internal resource that is familiar with SQL Server, but not so much with GP...they can run the SQL code provided and export the data to Excel for you.  If this is something you need to run all the time, they can create an Excel report for you that you can run without them.

    These are just two of many possibilities.  You may want to discuss this with your Dynamics GP partner so they can get the whole picture of what you're looking to do and recommend the best solution for you. 

    Hope that helps.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Help ASAP

    Hi again Victoria

     

    I hate to ask this questions but, I have been using GP for years we are on version 10, no one has ever set up reports so I am about to begin, what do we need with GP10 to start this we do not have crystal reports, your blog shows codes so I got confused I know that we need and will use custom reports.  If I know what I need that would be great.

     

    I thank you very much

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Help ASAP

    Hi Victoria

     

    I thank you very much I will go to your blog.

     

    again thank you

     

    Pat

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: Help ASAP

    If you're looking to write a custom report, I have code for this posted on my blog: http://victoriayudin.com/2008/11/28/sql-view-to-show-all-gl-distributions-for-ap-transactions/.

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: Re: Help ASAP

    Richard's approach is correct too... however, you will have to implement a gigantic case statement for the account type since column only stores a numeric equivalent in SQL. You can take a look at the SDK for the numeric equivalent to PURCH, CASH, PAY, etc...

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Help ASAP

    To get a simple clean report like you want you would need to print a custom report.  If you have SmartList Builder, I would suggest using that or Excel Report Builder (included with SLB) as your report can be quickly sorted and sifted on screen.

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: Re: Re: Help ASAP

    Have you tried Reports > Purchasing > Posting Journals? These all print for a date range with the account type on them.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Help ASAP

    Hi Mariano

     

    thank you for your reply. Yes I know they print out on the edit list, I quess the best way to explain is what I need is the print edit list but one huge file for a month at a time, this way I may look fast or sort them and know right away if one was not recorded correctly.

     

     

     

    Pat

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: Help ASAP

    Are you specifically referring to the account type on the posting journal and/or edit list? If so, the account type already prints on these reports. PURCH for purchasing, CASH for cash, PAY for payables and so on. If this is not what you are looking for please post back.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans