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.
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
Budget
|
||||||||||||||||||||||||||||||
Account | A8 |
Actual
|
||||||||||||||||||||||||||||||
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 .
|
|||||||||||||||||||||||||||||||
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. |
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 |
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 |
|
Processing Rules |
|
---|---|
No special processing rules |
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 |