Has anyone built a SQL Query that relates G/L transactions back to Customer(s)?
I have created some queries in IDO's for some custom forms where we did that. What I do is study the IDO then find all the columns that need to be filtered to get the type of G/L data I need. You can see in the data tool I created below (you can use an DataView as well) how I filtered to a customer number (which is shared by vendors too) and you can see other columns that need to be filtered to get your desired result. After that you can check the table structure in the IDO to create your query. Hope that helps if not let us know more specifically what you are trying to accomplish. I am sure someone will be able to help.
I forgot to mention my example is for Syteline.
Thanks so much. I'll give that a try. I also discovered the ledger all table does not have the vendor/customer number; however, the site table does. Thanks again.
