Transcript Banner Finance 103 Internet Native Banner Training Penney Doughtie Banner Finance Trainer Revised 11/26/2014 Banner Finance 103 Internet Native Banner Training includes: • • • • Log into INB – Internet Native.

Banner Finance 103
Internet Native Banner
Training
Penney Doughtie
Banner Finance Trainer
Revised 11/26/2014
1
Banner Finance 103
Internet Native Banner
Training includes:
•
•
•
•
Log into INB – Internet Native Banner
Perform Basic Banner Navigation
Perform Searches in the FOAP tables
View various inquiry screens including:
•
Balances on Organizational Budget Status
•
Detailed Transaction Activity by FOAP
•
Detailed Encumbrance Activity by FOAP
•
Document Look-up
2
To view a screen, enter the six alpha
character screen name in the
“Go To” field then press enter.
3
“My Banner” Folder is used to list Form Names for quick access.
Click On “My Banner” Folder ~ Click “Organize My Banner” GUAPMNU
Select Desired Banner Forms to be listed in “My Banner” Folder
Press “F10” to save changes
4
Go to GUAUPRF, check “Display Form name” and
check “Include Header Row in Data Extract”
Press F10 to save changes
5
Basic Navigation Training
for INB
6
Record Function Keys for Data
Entry
•
•
•
•
•
•
F6
- Insert Record
F4
- Duplicate Record
Shift + F4 - Clear Record
Shift + F6 - Delete Record
Down Arrow - Next Record
Up Arrow - Previous Record
7
Block Function Keys
Click the “Next Block” icon
• Click “Block” on the menu, then click “Next”
• Crtl + Page Down
- Next Block
• Crtl + Page Up
- Previous Block
•
Field Function Keys
•
Tab
• Shift + Tab
- Next Field
- Previous Field
8
Form Function Keys
•
Shift + F7
• Ctrl + Q
• F10
- Clear Form / Rollback
- Exit form
- Save
Query Function Keys
•
F7 - Start Query
• F8 - Execute Query
• F5 - Start a New Screen
9
Other Helpful Hints
•
Double click drop down arrow to search
•
•
List of Values (LOV) Button
Wildcard characters for querying: “%”
10
Banner Questions
11
Each chart element of the FOAPAL
has a table that lists information
about the field.
•
•
•
•
•
•
FTVFUND
FTVORGN
FTVACCT
FTVPROG
FTVACTV
FTVLOCN
Fund
Organization
Account
Program
Activity
Location
12
Exercise 1. FUND Inquiry (Look-up)
Type FTVFUND in the Go To Box and
press Enter
13
FUND Inquiry Look-up (Cont.)
•
•
•
Press F7 to start a new query
In the Title field enter a word that would be
in the description using the % as the
wildcard. The search is case sensitive.
(for example %Instruction%)
F8 to execute the query
14
In the Title field enter
%Instruction%, press F8
15
FUND numbers that contain
“Instruction” in the Title will populate
automatically
16
Exercise 2. ORGN Inquiry (Look-up)
Type FTVORGN in the Go To Box and
press Enter
17
To Look-up an ORGN, use the
same function keys as explained
for the FUND query
•
•
•
Press F7 to start a new query
In the Title field enter a word that would be
in the description using the % as the
wildcard. The search is case sensitive.
(for example %History%)
Press F8 to execute the query
18
In the Title field enter %History%,
press F8
19
ORGN numbers that contain “History”
in the Title will populate automatically
20
Banner Questions
21
FGIBAVL
22
Banner FGIBAVL displays the
Organizational Budget
Balance by Pool Accounts.
This screen query requires the
Banner FUND, ORGN, and
ACCT.
•To
view revenues use 50000 as the ACCT.
•To view expenses use 60000 as the ACCT.
23
Enter the Fund, Organization, and Account
(always use 60000) then press the Control
key and Page Down key simultaneously
24
FGIBDST
25
Banner FGIBDST displays
the Organizational Budget
Status. This screen query
requires the Banner FUND
and ORGN.
26
Enter the Organization and the Fund, then
press the Control key and Page Down key
simultaneously
NOTE: Uncheck “Include Revenue Accounts” if revenue lines are not needed
27
Select the desired row, click
Options, select “Transaction Detail
Information (FGITRND)
28
The data will populate
automatically.
29
To download Internet Native Banner
data/report into Excel
•
•
•
•
Click Help
Click Extract Data No Key
Click Open
The data will display into an Excel worksheet reflecting current
posted data
PLEASE NOTE:
Google pop-ups, Internet Explorer pop-ups and other pop-ups may
interfere with this process. If you receive error messages indicating
these pop-ups please contact the ITCS Help Desk @ 328-9866 and
request assistance with the pop-up blockers settings on your PC.
30
Banner Questions
31
FGITRND
32
Banner FGITRND displays
the Detailed Transaction
Activity. This screen query
requires the Banner FUND
and ORGN (ACCT is optional).
33
Enter the Fund and the Organization, then
press the Control key and Page Down key
simultaneously, then press F8
34
Query within a Query
Press F7 (to start query)
Tab to the desired field, type in info
(for example, go to Type cell,enter J63)
35
Press F8 to Execute the Query
36
To download report into Excel
•
•
•
•
Click Help
Click Extract Data No Key
Click Open
The data will display into an Excel worksheet reflecting current
posted data
PLEASE NOTE:
Google pop-ups, Internet Explorer pop-ups and other pop-ups may
interfere with this process. If you receive error messages indicating
these pop-ups please contact the ITCS Help Desk @ 328-9866 and
request assistance with the pop-up blockers settings on your PC.
37
Banner Questions
38
FGIGLAC
39
Banner FGIGLAC. This
query requires only the
Banner FUND.
Note:
This query will retrieve only “GL” type
transactions. Acct is optional.
40
Enter the FUND, then next block.
41
To download report into Excel
•
•
•
•
Click Help
Click Extract Data No Key
Click Open
The data will display into an Excel
worksheet reflecting current posted data
42
Banner Questions
43
FGIENCD
44
Banner FGIENCD displays
the Detailed Encumbrance
Activity. This screen query
requires the encumbrance
number.
(example Purchase Order #P1011734)
45
Enter the Purchase Order, then
press the Control key and Page
Down key simultaneously
46
To download report into Excel
•
•
•
•
Click Help
Click Extract Data No Key
Click Open
The data will display into an Excel worksheet reflecting current
posted data
PLEASE NOTE:
Google pop-ups, Internet Explorer pop-ups and other pop-ups may
interfere with this process. If you receive error messages indicating
these pop-ups please contact the ITCS Help Desk @ 328-9866 and
request assistance with the pop-up blockers settings on your PC.
47
Banner Questions
48
FGIOENC
49
Banner FGIOENC displays
the Organizations
Encumbrance List. This
screen query requires the
Banner FUND and ORGN.
50
Enter the Organization and the Fund, then
press the Control key and Page Down key
simultaneously
51
To view the purchase order details, select the
desired purchase order, then click “Options”,
then click “Query Detail Encumbrance”.
This Banner form (FGIENCD) provides the
detailed liquidation information by each item
number.
To view the next item, press the arrow down
key.
52
Closely review all open encumbrances to determine if a manual
liquidation is needed in PORT.
Contact Materials Management to request “manual liquidation” in
PORT and Banner Finance.
Log onto OneStop
Select “PORT”
Select desired Purchase Order
Click “Available Action” (on the top right)
Click “Add a Comment”
Type an explanation in the comment box including the reason why
manual liquidation is needed.
You may also call Materials Management at 328-6434 or Systems
Coordination at 328-2706.
53
Banner Questions
54
FGIDOCR
55
Banner FGIDOCR performs a
search by Document number
This query will search by:
•
Purchase Orders
• Invoices
• Journal Vouchers
• AP Checks
56
Enter the Document Number including the
Alpha prefix, then press the Control key and
Page Down key simultaneously
57
This is an example of a
Journal Voucher
58
To download report into Excel
•
•
•
•
Click Help
Click Extract Data No Key
Click Open
The data will display into an Excel worksheet reflecting current
posted data
PLEASE NOTE:
Google pop-ups, Internet Explorer pop-ups and other pop-ups may
interfere with this process. If you receive error messages indicating
these pop-ups please contact the ITCS Help Desk @ 328-9866 and
request assistance with the pop-up blockers settings on your PC.
59
Banner Questions
60
To Request Security Access
The following website provides detailed
instructions on how to request Banner
Finance Security Access.
http://www.ecu.edu/cs-admin/financial_serv/Securityindex.cfm
If you have questions regarding this
security form, please contact Penney
Doughtie [email protected]
or 328-2706.
61
INB Banner Log in
•
•
•
•
•
•
•
Go to ECU Homepage
http://www.ecu.edu/
Click “Banner” (under Quick Links)
Click “Internet Native Banner Prod”
Click “Production – Internet Native Banner”
Enter Banner userid and password
Enter desired screen name in the “Go To” field
Press Enter
62
Connecting to Banner from your
Desktop the First Time

Every Banner user will need to install Sun Java Plug-In

Go to the following website

When finished the installation, restart your computer
http://www.java.com/en/index.jsp
63
Helpful Information
64
Helpful Rule Codes
(also called Transaction Type)
Rule Code
ADEI
BD01
B22
CORD
D44
E090
HGRB
HGRS
INEI
INNI
J51
J63
PORD
R30
SI1
SI3
SI5
XYZ
Description
Additional charges on Invoice
Original Budget
Temporary budget transfer
Purchase Order Change
Disbursement adjustment
Year End Encumbrance Accrual
HR Benefit Transactions
HR Salary Payroll Transactions
Invoice with encumbrance (purchase order)
Invoice without encumbrance (no purchase order)
Internal Sales (ECU departments billings within ECU
ID Charge / Journal Entry
Purchase Order
Cash Receipt
Medical Supplies Storeroom
Office Supplies Storeroom
Maintenance Supplies Storeroom
Miscellaneous Cash Receipt
65
BANNER OPERATING BUDGET ACCOUNTS
Also known as Budget Pool Accounts
72000
72350
72400
73000
73200
73400
73600
73700
73800
73950
74060
75000
Supplies Budget
Library Books Budget
Equipment Budget
Contractual Services Budget
Travel Budget
Current Services Budget
Fixed Charges Budget
Other Expenses & Adjust Budget
Undistributed Budget
Grants and Aides
Education Awards
Utilities Budget
BANNER SALARY BUDGET ACCOUNTS
60000
60100
60150
60200
60250
61200
Miscellaneous Salary Budget
EPA Non Teaching Salary Budget
EPA Faculty Salary Budget
SPA Staff Salary Budget
SPA LEO Salary Budget
Benefits Budget
66
Create a Banner Shortcut on your
PC Desktop
•
•
Close all opened windows (Excel, Word, Outlook, etc.)
Go to ECU Homepage http://www.ecu.edu
• Click ‘Banner under’ MyLinks
• Scroll down and click ‘Internet Native Banner Prod’ in
purple font
• Click ‘Production – Internet Native Banner’
• Minimize the window
• A blank window should be displayed with the following
web address - https://inbbanner.ecu.edu/forms/frmservlet?config=pban
• Click on the Internet Explorer icon beside the web
address and drag it to your desktop
67
To Change the ICON
•
•
•
•
•
•
•
•
•
•
Right Click on the new Internet Explorer Icon on your PC
desktop
Click Properties
Click Change Icon
Click Browse
Scroll right and select file “shell32.dll”
Click Open
Select the desired Icon
Click OK
Click Apply
Click OK
68
Thank you for your time!
I hope you enjoyed Banner Finance Training!
•Please
contact any of the
Systems Coordination staff located at
http://www.ecu.edu/syscoord/
•Other
Banner Training Courses located on the OneStop
under “University Training”
Banner 101/102 – Self-Service Banner
•e~Print Report Training
•ODS – Operational Data Store
•Monthly Departmental Review of Financial Transactions
Guidelines
•
69