Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
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

Categories:
  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 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 Super User 2024 Season 1 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 Super User 2024 Season 1 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 Super User 2024 Season 1 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

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

Product updates

Dynamics 365 release plans