Query Transaction / Update Secondary Note {FGLO-22}


This Option provides a facility whereby: firstly, any transaction processed on any of the financial systems can be queried and: secondly, a secondary note (the only field that can be updated) can be added to describe the transaction in more detail. 



Fields in the option:

Block 1:  Query Trans. / Update Secondary Note

This option consists of the following: 


Field Type
&
Length
Description
Transaction Code N4  Supply the Transaction Type used in the transaction that is to be queried. 
Subsystem A2 This is a display field only.
Financial Field A1 This is a display field only.
Reference Number A12 Supply the reference number used in the transaction that is to be queried.
Reference Date (DD-MON-YYYY) Supply the reference date used in the transaction that is to be queried.
Processed Date (DD-MON-YYYY) Supply the date on which the transaction that is to be queried was processed.
Debit/Credit A1 This is a display field only.
Journal Number N6 Supply the journal number, if applicable, for the transaction that is to be queried.
Audit Date (DD-MON-YYYY) Supply the date on which the transaction that is to be queried appeared on an audit trail.
Cost Centre A4 Supply the Cost Centre to which the transaction that is to be queried was processed.
Account A8 Supply the Account to which the transaction that is to be queried was processed.

This field has a pop up menu to query and view approval status of the transaction.
To activate the pop up right click with the mouse on the field.
Fin. Year YYYY Supply the financial year to which the transaction that is to be queried was processed.
Fin. Cycle N2 Supply the financial cycle year to which the transaction that is to be queried was processed.
VAT Report Cycle N6 The cycle where the VAT is reported.
Value N17.2 Supply the value of the transaction that is to be queried.
GL Note A30 Supply the GL Note that was supplied with the transaction that is to be queried.
Second GL Note A30 Supply the secondary note for this transaction. This is the only field that may be updated. However, once a note is supplied in this field and the <COMMIT> function has been executed, update is not allowed thereafter.
Description A30 Supply the description that was supplied with the transaction that is to be queried.
User A8 This is a display field only and it indicates the user who processed the transaction that is queried.

Example:

Example of ...fglo-22b1



Import / Export Functionality Import / Export Functionality
The generic Integrator export functionality is available on this option, however the import functionality is not available as the user is not allowed to create GL journals in this option. To import GL journals the option Batch Journal Transactions {FGLO-2} should be used.



History of Changes

Date System Version By Whom Job Description
11-Jan-2007 v01.0.0.0 Charlene van der Schyff t133782 New manual format.
24-Mar-2009              v01.0.0.1 Ernie van den Berg t157063 Add link approval status on account fields.
26-May-2009 v01.0.0.2 Charlene van der Schyff t158348 Edit language obtained from proof read language Juliet Gillies.
30-JAN-2013
v03.0.0.0
Marchand Hildebrand
t187315
Add export functionality
02-Dec-2016 V04.0.0.0 Ntshabele Morgan T208911 Removed Investment Number Field
26-Jul-2020
v04.1.0.0
Ndivhanga Mushando
t244649
Update manual to INT 4.1