Example Query Parameters

Example of GL Query definition and parameters

Here is an example of the conditions of a GL query entered by the user. The Ledger or Set of Books is given from the Front Page as well as fiscal year.

The query parameters or conditions are the following: Beginning Balance, Period Net and Ending Balance for Parent account and Costcenter where Parent accounts starting with 4 and Costcenter = 140 and Period = 12. Furthermore, we want the descriptions of Parent Accounts and Costcenter. At last we want to see the Account Types and compare Actual numbers with Budget and Prior Year.