In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
#AcumaticaTnT SQL Behind Customers (AR3030PL) Screen
How can you find the SQL Query or Database Source behind the Customers (AR3030PL) screen?
I got this question via a private message so I'm posting my response here in case anyone else has the same question.
You have two options:
1. On the Customers (AR3030PL) screen, go to CUSTOMIZATION -> Edit Generic Inquiry. Note that you must have Access Rights to the Generic Inquiry (SM208000) screen to see this option.
You won't see SQL in the Generic Inquiry (SM208000) screen, but you'll see the what you would need in order to write a SQL statement, with the tables listed on the TABLES tab, the joins listed on the RELATIONS tab, and the fields selected on the RESULTS GRID tab:
2. On the Customers (AR3030PL) screen, go to TOOLS -> Trace... (1st screenshot) and you'll get a pop-up window, then click the down arrow next to Details (2nd screenshot) to see the SQL code in the yellow area. Note that the SQL code will likely look pretty ugly since any software application (not just Acumatica) tends to generate messy SQL code. I recommend copying and pasting into Notepad++ and inserting line breaks to make it more legible.