Contents Index FIS Home Previous Next UC Santa Cruz Home Contents Index FIS Home Previous Next Top
UCSC FIS Training Manual

Detail Transaction Activity

FGITRND

The FGITRND Detail Transaction Activity form provides a detailed list of all transactions associated with specific FOAPAL values. You can use the form to search for transaction detail for Fiscal Year, Fund, Organization, Account and Activity codes, and Posting (Month) Period. The form can be used as a Stand-Alone form (entered directly from the Go To... field of the Banner Menu Form), or it can be called from within the FGIBDST Organization Budget Status form.


FGITRND Stand-Alone Form

FGITRND Viewed From FGIBDST


FGITRND Stand-Alone

  1. In the Go to... field on the Banner Menu Form, type FGITRND <return>.
     
  2. Cursor appears in the COA field. Accept default value X.
     
  3. <TAB> to Fiscal Year field. Current FY will default. Change if required.

  4. <TAB> to INDEX. Leave blank.
     
  5. <TAB> to FUND. If desired, enter a Fund code or type [F9] List Field Values to lookup and retrieve a specific Fund code.
     
  6. <TAB> to ORGANIZATION. If desired, enter an Organization code or type [F9] List Field Values to lookup and retrieve a specific Org code.
     
  7. <TAB> to ACCOUNT. If desired, enter an Account code or type [F9] List Field Values to lookup and retrieve a specific account code.
     
  8. <TAB> to PROGRAM. Leave blank.
     
  9. <TAB> to ACTIVITY. Field is optional. If desired, enter an Activity code or type [F9] List Field Values to lookup and retrieve a specific Activity code.
     
  10. <TAB> to LOCATION. Leave blank.
     
  11. <TAB> to POSTING PERIOD. If desired, enter a specific two digit Posting Period code (01=July, 02=Aug ... 11=Nov, 12=Dec). This will limit your detail results to transactions for a specific month.

  12. <TAB> to QUERY TYPE. R or S will default. Do not change.

  13. <TAB> to COMMIT TYPE. Leave blank.
     
  14. Type [control page down] Next Block to the Transaction Detail block. The Transaction Detail Block will appear in query mode with no visible detail.

  15. Type [F8] Execute Query. Transaction Detail for the specific codes entered will appear.

 

  1. Use the arrow keys <up arrow> <down arrow> or the scroll bar to navigate through the Transaction detail records. Use the <TAB> key to navigate through a specific record for more detail.

  2. To view the originating document of a specific record, clicking on the Account code of the desired document (under Account on the left side of the screen), then select Query Document [By Type] from the Options Menu, Right Click-Query Document [By Type]or type [F3]. After the originating document opens, use [control page down] Next Block and <down arrow> Next Record to navigate within the form. Type [control q], click on in the toolbar or Right Click-Exit when you are ready to return to FGITRND.
  3. To start a new query, click the Rollback icon or Right Click-Rollback.

  4. To exit FGITRND and return to the Banner Menu Form, click on the Exit icon or Right Click - Exit.

FGITRND Viewed From FGIBDST

You can access FGITRND from within FGIBDST to view specific transaction details in FGIBDST’s Adjusted Budget, YTD Activity and Commitments columns. You can also view all combined (Budget+YTD+Commitments) detail.

Adjusted Budget Transaction Detail

YTD Activity Transaction Detail

Commitments Transaction Detail

Combined (All) Transaction Detail


Adjusted Budget Transaction Detail:

  1. Navigate to the lower block of FGIBDST by typing [control page down] Next Block. The cursor will appear in the Account field of the first row.

  2. Use the arrow keys <up arrow> <down arrow> to navigate to a specific Account (e.g. 000010 - Supplies-Other, 000030 - Office Supplies, etc.).

  3. <TAB> to the Adjusted Budget field.




  1. Key [F3]. FIS Banner will display the FGITRND screen with specific Budget Transactions for your Fiscal Year, Fund, Organization, Account and Activity Code settings from FGIBDST.


    Note: If your Adjusted Budget field is zero (0.00), FGITRND will display a Hint Text message "Query caused no records to be retrieved."



  1. Use the arrow keys <up arrow> <down arrow> or the scroll bar to navigate through the Transaction Detail records. Use the <TAB> key to navigate through a specific record for more detail.

  2. To view the originating document of a specific record, clicking on the Account code of the desired document (under Account on the left side of the screen), then select Query Document [By Type] from the Options Menu, Right Click-Query Document [By Type]or type [F3]. After the originating document opens, use [control page down] Next Block and <down arrow> Next Record to navigate within the form.



  1. Type [control q], click on in the toolbar or Right Click-Exit when you are ready to return to FGITRND.

  2. To exit FGITRND and return to FGIBDST, click on the Exit icon or Right Click - Exit.


YTD Activity Transaction Detail:

  1. Navigate to the lower block of FGIBDST by typing [control page down] Next Block. The cursor will appear in the Account field of the first row.

  2. Use the arrow keys <up arrow> <down arrow> to navigate to a specific Account (e.g. 000010 - Supplies-Other, 000030 - Office Supplies, etc.).

  3. <TAB> to the YTD Activity field.





  1. Key [F3]. FIS Banner will display the FGITRND screen with specific YTD Transactions for your Fiscal Year, Fund, Organization, Account and Activity Code settings from FGIBDST.


    Note: If your YTD Activity field is zero (0.00), FGITRND will display a Hint Text message "Query caused no records to be retrieved."


  1. Use the arrow keys <up arrow> <down arrow> or the scroll bar to navigate through the Transaction Detail records. Use the <TAB> key to navigate through a specific record for more detail.

  2. To view the originating document of a specific record, clicking on the Account code of the desired document (under Account on the left side of the screen), then select Query Document [By Type] from the Options Menu, Right Click-Query Document [By Type]or type [F3]. After the originating document opens, use [control page down] Next Block and <down arrow> Next Record to navigate within the form.




  1. Type [control q], click on in the toolbar or Right Click-Exit when you are ready to return to FGITRND.

  2. To exit FGITRND and return to FGIBDST, click on the Exit icon or Right Click - Exit.


Commitments Transaction Detail:

  1. Navigate to the lower block of FGIBDST by typing [control page down] Next Block. The cursor will appear in the Account field of the first row.

  2. Use the arrow keys <up arrow> <down arrow> to navigate to a specific Account (e.g. 000010 - Supplies-Other, 000030 - Office Supplies, etc.).

  3. <TAB> to the Commitments field.




  1. Key [F3]. FIS Banner will display the FGITRND screen with specific Commitments for your Fiscal Year, Fund, Organization, Account and Activity Code settings from FGIBDST.


    Note: If your Commitments field is zero (0.00), FGITRND will display a Hint Text message "Query caused no records to be retrieved."


  1. Use the arrow keys <up arrow> <down arrow> or the scroll bar to navigate through the Transaction Detail records. Use the <TAB> key to navigate through a specific record for more detail.

  2. To view the originating document of a specific record, clicking on the Account code of the desired document (under Account on the left side of the screen), then select Query Document [By Type] from the Options Menu, Right Click-Query Document [By Type]or type [F3]. After the originating document opens, use [control page down] Next Block and <down arrow> Next Record to navigate within the form.




  1. Type [control q], click on in the toolbar or Right Click-Exit when you are ready to return to FGITRND.

  2. To exit FGITRND and return to FGIBDST, click on the Exit icon or Right Click - Exit.


Combined (Budget+YTD+Commitments) Transaction Detail:

  1. Navigate to the lower block of FGIBDST by typing [control page down] Next Block. The cursor will appear in the Account field of the first row.

  2. Use the arrow keys <up arrow> <down arrow> to navigate to a specific Account (e.g. 000010 - Supplies-Other, 000030 - Office Supplies, etc.).




  1. Key [F3]. FIS Banner will display the FGITRND screen with ALL transaction detail for your Fiscal Year, Fund, Organization, Account and Activity Code settings from FGIBDST.


  1. Use the arrow keys <up arrow> <down arrow> or the scroll bar to navigate through the Transaction Detail records. Use the <TAB> key to navigate through a specific record for more detail.

  2. To view the originating document of a specific record, clicking on the Account code of the desired document (under Account on the left side of the screen), then select Query Document [By Type] from the Options Menu, Right Click-Query Document [By Type]or type [F3]. After the originating document opens, use [control page down] Next Block and <down arrow> Next Record to navigate within the form.



  1. Type [control q], click on in the toolbar or Right Click-Exit when you are ready to return to FGITRND.

  2. To exit FGITRND and return to FGIBDST, click on the Exit icon or Right Click - Exit.


Comments to fisTraining@ucsc.edu | Content rev. 5 February 2008 | Page modified 5 February 2008