Questions Entity Relationship Diagram?

Rob, I tend to look for a canned report that contains the same data I want to work with and then harvest the schema definition from it as a starting point.

Yes I have done a bit of that as well.  Thanks Shawn

I'd love to find a better documentation for this as well. If you have a locally installed version for test, evaluation, development using SQL Server Express you can also install SQL Server Management Studio. You can then connect from SQL Server Management Studio to the local SQL Server Express and view all the tables and the fields in each table. It is a much more efficient way to view the tables, understand the structure of the database, and determine relationships.

If you have (or are willing to develop) a familiarity with SQL you can also do some initial development of GI's in SQL and then try to recreate then in the GI editor. It's far from perfect with SQL being much more powerful. I can implement a GI logic in SQL in about 10% of my time and then the next 90% is trying to figure out how to duplicate the logic in the GI editor whether it's the object definitions, lack of powerful relationships and queries, etc. 

Admittedly, I need to dig in a learn BQL but the lack of documentation makes this much more difficult then the well documented tables and views that exist naturally through SQL Server Management Studio. 

It's the best method our team has found. Love to hear other suggestions/approaches for developing GIs.

Another thing that would be very helpful would be for the a row count to be returned when Viewing the results of an Inquiry (instead of having to Export to Excel).    I am currently losing rows when performing a LEFT join and do not know why.

I tend to just look at the primary keys on the SQL Tables. Not the best, but it works for me.

In Acumatica 2019 R1 you can display aggregates (SUM, MAX, MIN, etc.) of columns, giving you the totals that you're looking for.