1. View GL Accounts
1.1. Prerequisites for View GL Accounts

Users MUST have full rights to the "View GL Activity/Reports" in Accounting Security .   Users with “Accounting Security Supervisor” rights will automatically have access.
1.2. Introduction for View GL Accounts

This screen shows all the GL # and the end balance of every period for the current fiscal year, and for two prior fiscal years for comparison.  It is designed to allow a quick inquiry as to the balance of one or a series of accounts. 
1.3. Fields & Defintions for View GL Accounts
1.3.1. G/L Balances

 
 
 

User has the ability to sort the grid on the top (with account numbers) by all the columns. The RED letters in the caption of the column indicate that the information is sorted by the data in that column. 

Type

 2 or 3 character alph abbreviation for the type of account, such as CAS for Cash.
Type Description

Type of Account, such as Cash, etc.
Account Number

The G/ L account number.
Description Description for the account.
Status  This is the status of the G/L account number, active or inactive.
FISCALYR The current fiscal year, and two prior fiscal years. 
PERIOD_1 thru PERIOD_12

These columns show the end balance of every period for the current fiscal year, and for two prior fiscal years for comparison. 

 

Depressing this button will display any notes regarding this account.
Re-Set Filter Check this box to re-set filter

 
Selecting the "Filter by GL Type"  will display a pulldown that will allow the user to find account status  by General Ledger Type.

Selecting the ‘Exit’ button will return the user to the previous menu level.
 

 
 
1.3.2. G/L Activity
1.3.2.1. G/L Activity


User has the ability to sort the grid on the top (with account numbers) by all the columns. The RED letters in the caption of the column indicate that the information is sorted by the data in that column.

Beginning Period FY

This will display the beginning period and fiscal year of records to be displayed in screen below.
Ending Period FY

This will display the Ending period and fiscal year of records to be displayed in screen below. 
Period

The period being displayed.
FY

The fiscal year being displayed.

The general ledger account number
GL Description

The description of the account.
Type 2 or 3 character alph abbreviation for the type of account, such as CAS for Cash
Type Description

Type of Account, such as Cash, etc.
Beginning Balance

This period’s beginning balance.
Debit

The total debits posted this period.
Credit

The total credits posted this period. 
Ending Balance

The balance through today’s posting.

 
This will allow user to enter the beginning and ending FiscalYear/Period and then request information.

1.3.2.2. G/L Detail
 

User has the ability to sort the grid on the top (with account numbers) by all the columns. The RED letters in the caption of the column indicate that the information is sorted by the data in that column.

 
Beginning Period FY

This will display the beginning period and fiscal year of records to be displayed in screen below.
Ending Period FY

This will display the Ending period and fiscal year of records to be displayed in screen below.
Header

This is the account number and title highlighted in the G/L Account Activity tab.  
Period

This is the period being displayed.
FY

This is the fiscal year being displayed.
Trans Date

This is the date of the detail transaction.
Trans No

This is the number assigned to the transaction.
Transaction Source

This is the source of the entry, such as Cash Journal with the Check Number.
 Debit/Credit

This signifies that the entry was posted as either a debit or credit to the account.
 Totals This displays the calculated totals for the debit and credit columns

This will allow user to enter the beginning and ending Fiscal Year/Period and then request information

 
 
1.4. How To ..... for View GL Accounts
1.4.1. Find G/L Balances

Enter the SQLMANEX.EXE (within the ManEx root directory)
This action will then prompt the user for a password

The following screen will be displayed, select Accounting/General Ledger/View GL Accounts/G/L Balances    

The following screen will be displayed:   This screen shows all the GL # and the end balance of every period for the current fiscal year, and for two prior fiscal years for comparison.


 
To find a specific record by GL Type, depress the pulldown arrow next to the "Filter by GL Type" box and the following list will appear:
 
 
 
Highlight a GL Type and the screen will populate with the account information for that GL Type.

User has the ability to sort the grid on the top (with account numbers) by all the columns. The RED letters in the caption of the column indicate that the information is sorted by the data in that column.

 
 
 
 
1.4.2. Find G/L Activity

Enter the SQLMANEX.EXE (within the ManEx root directory)
This action will then prompt the user for a password

The following screen will be displayed, select Accounting/General Ledger/View G/L Accounts/G/L Activity  

The following screen will be displayed:

You can sort by all of the Headers. 

To view other periods than the Current Period, change the Beginning and/or Ending Period at the top of the screen and depress the "Apply Filter" button.
 
Detail will be available when highlighting an account with amounts in the Debit or Credit columns. Select the GL Detail Tab. Note:  that the detail will only show a summary line if the company chose to Post In Summary in the accounting setup. If the company chose to Post In Detail (General Ledger Defaults setup) each transaction that affects the balance of the selected account (selected on the summary screen) for the Period(s) selected will be shown.
 
 
 

 

You can sort by: Trans.Date.(default) Trans.No,  Debit, or Credit by depressing the appropriate button.

To view other periods than the Current Period, change the Beginning and/or Ending Period at the top of the screen.
 
Note:  The Transaction Number showing the entire entry can be accessed via G/L Reports Transaction Inquiry.