GL Query Builder

The GL Query Builder is a tool that enables SedonaOffice Users to create custom reports based on your company’s data that is stored in the SedonaOffice database.  A GL Query Builder report design builds a SQL query behind the scenes to be able to di...

This article will walk through the step by step creation of a simple report query, the printing of the query results and saving the report query design to a file.  The end result of this sample report will be a list containing all A/P Bills entered ...

Fine Tuning Reports If the data returned is not exactly what was expected, additional fields may be added or removed, additional filters and groups may be created until the report returns the desired results.  Each time a change is made to the rep...

Across the bottom of the GL Query Builder Report Designer form are a series of function buttons.  Each function button is described below. SQL Button Clicking the SQL button will display the SQL code that is generated when designing a report q...

Before attempting to design any report query, it is important to understand the structure of the GL Query Builder Design form and how it operates.  The GL Query Builder Report Query Designer is divided into five major elements which are briefly desc...