Query General Ledger Transactions {FGLO-8} 


This option allows for on-line General Ledger queries and is available on all financial sub-systems.   

Two types of  queries can be performed namely, actual or budget query. Ledger entries are referred to as actuals and the query will return the balance per GLA per input  criteria. Budget transactions are referred to as budget and the query will return the GLA's and budget amounts per input criteria.


On execution of this option, the user is requested to enter the Cost Centre and Account: the Potential Commitment is optional.  The system will default the remaining parameters to calculate the appropriate budget totals. The following fields are displayed on the screen:

NB: If the system displays the Available Amount as equal to 1.00 and the remaining amount fields are either NULL or zero, then there is NO BUDGET CONTROL on the GLA entered, or Budget Control is switched off.

Users are restricted to the detail they may view through the restrictions placed on the user, refer users restriction function FGLB.


A query in the option is initiated through the New Query button on the toolbar which will open the fields to enter the query criteria.  Type of query will default to "Actual"


The following are prerequisites to querying  the ledger in this option.

Panel Box 1:  Query GL Information
Field Type
&
Length
Description
New Query Button

Initiates a query which opens the fields to enter the query criteria.

Cancel Query Button

Clears the current query criteria to enter a new query or clear query criteria to exist the screen.

Submit Button Execute the query.
Submit and Show Report Button Execute the query and open the batch prompter to view the Cost Centre repot.
Type of Query A1  Valid values are Actual or Budget.

Actual  - Ledger entries are referred to as actuals and the query will return the balance per GLA per query criteria.
Budget - Budget transactions are referred to as budget and the query will return the GLA's and budget amounts per query criteria.

Cost Centre

A4
Actual

  • Query on Cost Centre - Enter only the cost centre and Submit.  Only Detail cost centres are allowed.

Budget
  • Cost Centre - is required on a budget query.
Account A8 Actual

  • Query on Account -  Leave the cost centre blank and enter the account and Submit. Only Detail accounts are allowed.  
  • Query GL-Allocation - Enter both a cost centre and account and Submit.
Budget
  • Account - is required on a budget query.  
Budget Level Budget Level is dependant on the budget flags of the Cost Centre and Account of tenh query and displays the budget rule that applies to the GLA .

CC Account Display
N Ignore Budget Control is switched off on the GLA
A N Budget Control is switched off on the GLA
C N Budget Control is switched off on the GLA
A A Budget Control is on Account Level
A C Budget Control is on Account Category Level
C Ignore Cost Centre Including Salaries
Then Budget control is done in total for all accounts linked to Account Categories 000 to 739 but at account level for all accounts linked to categories 740 to 999.
S Ignore Cost Centre Excluding Salaries
Then Budget control is done in total for all accounts linked to Account Categories 000 to 309 and 330 to 739 but at account level for all accounts linked to categories 740 to 999.  Salary Categories 310 to 329 are specifically excluded.




Financial Year N4
Year will default to the current financial year as per  sub-system GL, but the user may change the value.
Start Cycle N2 The start cycle of  transactions to be included in the query.
End Cycle N2 The up to cycle of  transactions to be included in the query.
Cycle 13 A1 Actual
Must transactions from cycle 13 be (I)ncluded or (E)xcluded in the query.  Cycle 13 is a GL cycle used for year-end adjustments.

Budget
Cycle 13 is Excluded  when performing a budget query.

Cycle 14 A1 Actual
Must transactions from cycle 14 be (I)ncluded or (E)xcluded in the query. Cycle 14 is the cycle in to which opening balances are written by the GL year-end program.

Budget
Cycle 14 is Included when performing a budget query.
Potential Commitment N 15.2 If a budget query is done, the user may enter a value equal to the amount  the user wishes to spend: this will be added to the calculations that represent future commitment.
Budget N15.2  
Actual
Commitments

Budget Level

Display the budget rule that applies to the GLA entered.



Budget Control Switched Off (On/Off):  If Budget Control is switched on, then the System Operational Definition Code BA will be set to Yes, if not then it will be set to No


Panel Box 2:  GLA Totals

The table displays the GLA totals.


Field Type
&
Length
Description
GLA  A4 + A8  Displays the Cost Centres and Accounts returned by the query.

Actual
List the Cost Centres and Accounts returned by the query.

Budget
List all the accounts  used in the budget rule applied on the GLA entered in  the query above.

Budget

N15.2

Displays the total actual, budget and  commitment the value for the GLA.
Actual 
Commitments

Panel Box 3:  Transactions per GLA

The table displays the detail ledger transactions relating to the active GLA in GLA totals table above. The table will only display records if the type of query executed is an Actual query.

Field Type
&
Length
Description
Transaction Date DD-MON-YYYY  Displays the process date of the transaction.
Transaction Type N4 The transaction type of the posting or transaction.
Originating Subsystem A2 The subsystem from which the posting to the ledger occurred.
Document Number  A12

The document of reference number depending of the type of posting.

General Ledger Note A30 The GL note as entered on the transaction if the posting to the GL was a detail posting.
Budget
N15.2
Depending on the whether the posting is actual, budget or commitment the value will reflect in the appropriate column.
Actual
Commitment


Example:

Example of fglo-8b1

 

Processing
Rules
 
  No special processing rules


See Also:



History of Changes

Date System Version By Whom Job Description
14-May-2007 v01.0.0.0 Amanda Nell t130145 New manual format.
14-Jan-2009 v01.0.0.1 Marchand Hildebrand t152121 proof Read System Owner.
26-May-2009 v01.0.0.2 Charlene van der Schyff t158348 Edit language obtained from proof read language Juliet Gillies.
18-Dec-2012
v02.0.0.0
Marchand Hildebrand
t183060
Add finance permissions
30-JUN-2016 v04.0.0.0 Marchand Hildebrand t214792