Skip to main content
Microsoft Dynamics GP forum
Answered

Smartlist- Purchase Lines with GL

editSubscribe (0) ShareShare
ReportReport
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,002 Super User 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,002 Super User 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,002 Super User 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,002 Super User 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/

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,045 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,570 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans