Smartlist- Purchase Lines with GL

(0) Share

Report

Posted on by Spiral02

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:

Microsoft Dynamics GP

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

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/

Was this reply helpful? Yes No
Spiral02 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Spiral02 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

Great!

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

Was this reply helpful? Yes No
Spiral02 on at

Like (0)

Report

Wow really!

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

Thanks again!

Was this reply helpful? Yes No
Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No