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
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
head over here to eOne Solutions (the creator of SL Builder):
The entire SL builder documentation can be downloaded from their site, or you can read it online :
Wow really!
How do I obtain that!!? I wouldn't mind studying that to see how to read it!
Thanks again!
Great!
Glad you figured out that you can link tables in SL Builder (which creates a SQL view BTW for you).
I THINK I FIGURED IT OUT!! THANKS MR. BUCHER! Its just took some time away from thinking about it.
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.
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!
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..
André Arnaud de Cal...
294,261
Super User 2025 Season 1
Martin Dráb
233,013
Most Valuable Professional
nmaenpaa
101,158
Moderator