Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Answered

Smartlist- Purchase Lines with GL

Posted on by

Hello All,

I am trying to build a Purchase Lines with GL for My Gp 2018, I am looking for the proper tables to link for this to be possible.

Thank you,

Preston Sloan

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Moderator on at
    RE: Smartlist- Purchase Lines with GL

    head over here to eOne Solutions (the creator of SL Builder):

    www.eonesolutions.com/.../

    The entire SL builder documentation can be downloaded from their site, or you can read it online :

    www.eonesolutions.com/.../new_topic.php

  • Spiral02 Profile Picture
    Spiral02 on at
    RE: Smartlist- Purchase Lines with GL

    Wow really! 

    How do I obtain that!!? I wouldn't mind studying that to see how to read it!

    Thanks again!

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Moderator on at
    RE: Smartlist- Purchase Lines with GL

    Great!

    Glad you figured out that you can link tables in SL Builder (which creates a SQL view BTW for you).

  • Verified answer
    Spiral02 Profile Picture
    Spiral02 on at
    RE: Smartlist- Purchase Lines with GL

    image001_5F00_495709757350847.png

    I THINK I FIGURED IT OUT!! THANKS MR. BUCHER! Its just took some time away from thinking about it. 

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Moderator on at
    RE: Smartlist- Purchase Lines with GL

    It might help if you tell us what tools you have at your disposal to tackle this task.. we can't really help by assuming you can use SL Builder or SQL Views if you don't say which ones you know or can use.

  • Spiral02 Profile Picture
    Spiral02 on at
    RE: Smartlist- Purchase Lines with GL

    Hello Mr. Bucher,

    Yes I did review her sql conquest of this and i think it was AP with GL. Also unfortunately I am a measly gp end user with no sql background. I do know enough about the smartlist builder and  tables together. So I just need a little direction to get Account number string tied to the out of the box Purchase Lines. Any help is very much appreciated!

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Moderator on at
    RE: Smartlist- Purchase Lines with GL

    Hi Preston,

    Have you looked over at Victoria Yudin 's blog page ? She has a wealth of SQL views published over the years for all kinds of GP data reporting..

    https://victoriayudin.com/

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans