By using this website, you agree to our Terms of Use (click here)
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.
Online Members