Interested in creating and selling training? You pick the price, 50/50 revenue share, and you own the content. Find out more at
I am currently using MR 2012 for my reports for GP 2018, but I was wondering if anyone knows how they are produced and what SQL Queries are used to create the generate the standard Financial Reports, as I was looking at trying to reproduce these in PowerBi and a mini project for myself
Hi BrianHarry - A lot of that info you want to reproduce is encrypted and in the SQL procs/tables. The GL data comes form the GL Summary or GL Detail tables (work, open and history). I couldn't imagine how to pull that off, but I think I see what you are trying to do. For Power BI financial statements, I would recommend instead looking at using the Account Category as the financial reporting driver, and/or making your own "classes" or groups of accounts within the Power BI model itself.