Excel reports and Power BI are extremely powerful tools in Dynamics GP. Here are some SQL queries for Dynamics GP (Great Plains) I have used for reporting. If you can’t find the query you are looking for or have any questions please comment or contact me. I do custom reporting.