NMSU
Sponsored Project Accounting
Banner Upgrade Test Plan - Accounts Receivable
As of August 2009
Actual Results /
ID# Business Scenario Form / Process Name Business Requirement Test Case No. Testing Owner Tester Test Date Pass / Fail
FAIL Notes
System Administration
Billing Codes and
formats can be created
1 Billing Codes FTMBFRM and modified SPA-001 SPA Mickey Duttle
Event codes can be
2 Event Codes FRVEVNT created and modifed SPA-002 SPA Mickey Duttle
IDC and CS Basis
codes can be created Suzanna
3 Basis Codes FTMBASI and modified SPA-003 SPA Burlingham
IDC Rates codes can be Suzanna
4 IDC Rates FTMINDR created and modified SPA-004 SPA Burlingham
IDC Charge Account
codes can be created Suzanna
5 IDC Accounts FTMINDA and modified SPA-005 SPA Burlingham
IDC Distribution codes
can be created and Suzanna
6 IDC Distribution FTMINDD modified SPA-006 SPA Burlingham
CS Rate codes can be Suzanna
7 CS Rates FTMCSTR created and modified SPA-007 SPA Burlingham
CS Charge Account
codes can be created Suzanna
8 CS Accounts FTMCSTA and modified SPA-008 SPA Burlingham
CS Distribution codes
can be created and Suzanna
9 CS Distribution FTMCSTD modified SPA-009 SPA Burlingham
PMS codes can be Suzanna
10 PMS Codes FTMPMSC created and modified SPA-010 SPA Burlingham
Agency codes can be Suzanna
11 Agency Codes FTMAGCY created and modified SPA-011 SPA Burlingham
Set up Financial Manager FM's can be created Suzanna
12 (FM) FTMFMGR and modified SPA-012 SPA Burlingham
Proposal records can be
13 Proposal FRAPROP created and modified SPA-013 SPA Thanh Nguyen
Grant records can be
14 Grant FRAGRNT created and modifed SPA-014a SPA Thanh Nguyen
FC4 and FC5 fund
records can be created
and modified and
FTMFUND/FRMFUND assigned to a Grant SPA-014b SPA Thanh Nguyen
Events can be attached
FRAEVGA to a grant and modified SPA-014c SPA Thanh Nguyen
Text for Entities can be
FOAETXT created and modifed. SPA-014d SPA Thanh Nguyen
Budgets can be entered
and modifications can
FRABUDG be made SPA-014e SPA Thanh Nguyen
NMSU
Sponsored Project Accounting
Banner Upgrade Test Plan - Accounts Receivable
As of August 2009
Actual Results /
ID# Business Scenario Form / Process Name Business Requirement Test Case No. Testing Owner Tester Test Date Pass / Fail
FAIL Notes
Text for grants and
funds can be created
FOATEXT and modified. SPA-014f SPA Thanh Nguyen
Budget distribution for a
specfic grant and
budget entry can be
15 Grant Queries FRIBDSG viewed SPA-015a SPA Jill Williams
Budget Codes can be
FRIBUDG viewed SPA-015b SPA Jill Williams
Budget totals by
account code for a
specfic grant and
budget entry can be
FRIBUTG viewed SPA-015c SPA Jill Williams
Inquiries can be
performed on various
FRIGRNT fields to find grants SPA-015d SPA Jill Williams
The history of grant
FRIGRST status can be viewed SPA-015e SPA Jill Williams
Entries in the memo
FRIMEMO ledger can be viewed SPA-015f SPA Jill Williams
Inquiries can be
performed on various
FRIKGNT fields to find grants SPA-015g SPA Jill Williams
Xtender Documents can Suzanna
16 Xtender FRAGRNT be uploaded SPA-016a SPA Burlingham
Xtender Documents can Suzanna
FRAGRNT be veiwed SPA-016b SPA Burlingham
Monitoring and Billing
Transactions can be
reveiwed by month,
fiscal year, grant year,
1 View Transactions FRIGITD and complete project SPA-017a SPA Maggie Fraga
Transactions can be
reveiwed by month,
fiscal year, grant year,
FRIGTRD and complete project SPA-017b SPA Maggie Fraga
Transactions can be
viewed and placed on
hold and unhold as
2 Hold/Release Transactions FRABDCN necessary SPA-018 SPA Crystal Luchini
All unbilled transactions
can be billed for a
3 Bill Transactions FRRBILL specified time frame SPA-019 SPA Crystal Luchini
Invoice can be viewed
4 View and Print Invoices FRAGENB and printed SPA-020a SPA Maggie Fraga
Invoice can be viewed
FRA134B and printed SPA-020b SPA Maggie Fraga
Invoice can be viewed
FRA270B and printed SPA-020c SPA Crystal Luchini
Invoice can be viewed
FRA272B and printed SPA-020d SPA Crystal Luchini
NMSU
Sponsored Project Accounting
Banner Upgrade Test Plan - Accounts Receivable
As of August 2009
Actual Results /
ID# Business Scenario Form / Process Name Business Requirement Test Case No. Testing Owner Tester Test Date Pass / Fail
FAIL Notes
Invoice can be viewed
FRRGENB and printed SPA-020e SPA Maggie Fraga
Invoice can be viewed
FRR134B and printed SPA-020f SPA Maggie Fraga
Invoice can be viewed
FRR270B and printed SPA-020g SPA Crystal Luchini
Invoice can be viewed
FRR272B and printed SPA-020h SPA Crystal Luchini
FRIGENB Invoice can be viewed SPA-020i SPA Maggie Fraga
FRI134B Invoice can be viewed SPA-020j SPA Maggie Fraga
FRI270B Invoice can be viewed SPA-020k SPA Crystal Luchini
FRI272B Invoice can be viewed SPA-020l SPA Crystal Luchini
Invoices can be
5 Reverse billing FRRBREV reversed and rebilled SPA-021 SPA Maggie Fraga
An event can be
manually cancelled or
6 Event Action FRAEVNG satisfied. SPA-022 SPA Crystal Luchini
Grants for a specific
8 Grant Queries FRIASTG Agency can be veiwed SPA-023a SPA Maggie Fraga
Grants for a specific
FRIPSTG person can be viewed SPA-023b SPA Maggie Fraga
Grants for a specifice
orgranization can be
FRIORGH viewed SPA-023c SPA Crystal Luchini
Events for a grant or
responsible person can
FRIEVNG be viewed SPA-023d SPA Crystal Luchini
Billing Summaries can
be viewed and can drill
down to the detail via
FRIBDET the options menu. SPA-023e SPA Maggie Fraga
Report can be run,
9 Reports FRRGITD viewed, and printed SPA-024a SPA Tina Hales
Report can beviewed
FRAGENR and modified SPA-024b SPA Tina Hales
Report can beviewed
FRA269R and modified SPA-024c SPA Tina Hales
Report can beviewed
FRA272R and modified SPA-024d SPA Tina Hales
Report can beviewed
FRAFFRR and modified SPA-024e SPA Tina Hales
Report can beviewed
FRAGENR and modified SPA-024b SPA Tina Hales
Report can be run,
FRR269R viewed, and printed SPA-024c SPA Tina Hales
Report can be run,
FRR272R viewed, and printed SPA-024d SPA Tina Hales
Report can be run,
FRRFFRR viewed, and printed SPA-024e SPA Tina Hales
FRIGENR Report can be viewed SPA-024f SPA Tina Hales
Accounts Receivable and Special Projects
NMSU
Sponsored Project Accounting
Banner Upgrade Test Plan - Accounts Receivable
As of August 2009
Actual Results /
ID# Business Scenario Form / Process Name Business Requirement Test Case No. Testing Owner Tester Test Date Pass / Fail
FAIL Notes
Grant payments can be
1 Payments FRAAREV entered SPA-025a SPA Olga Ostos
Payments can be
entered using the PMS
code and distributed to
grants associated with
FRAAREV the PMS code SPA-025b SPA Olga Ostos
Cashier sessions can be
2 Close Cashier Sessions TGACREV closed SPA-026 SPA Olga Ostos
Cashier sessions can be
finialized by a
3 Approve Cashier Sessions TGACSPV supervisor SPA-027a SPA Kelly Woods
Report detailing Cashier
Session entries can be
TGRCSHR run and saved as PDF. SPA-027b SPA Kelly Woods
Process to apply
payments entered in
FRAAREV can be run
4 Apply payments TRRAPPL without error SPA-028 SPA Kelly Woods
Payments entered in
FRAAREV can
5 Unapply Payments FRAUNAP unapplied SPA-029 SPA Olga Ostos
Payment applications
can be viewed for a
6 Grant Queries FRIAPPL specfic grant SPA-030a SPA Olga Ostos
A summary of billing
activity can be veiwed
FRIGSUM for a specific grant SPA-030b SPA Olga Ostos
Invoices and payments
can be viewed for a
FRIBILL specific grant SPA-030c SPA Olga Ostos
Steps from the Term
Checklist that involve
Banner Forms or
Reports can be
7 Terming VARIOUS completed SPA-031 SPA Crystal Luchini
Research Management
User defiend fields can
1 User Defined Fields FRVSDAT be created and modifed SPA-032 SPA Kathy Montoya
CFDA numbers can be
2 CFDA Numbers FRVCFDA entered and modified SPA-033 SPA Kathy Montoya
Finance Detail codes
can be entered and
3 Detail Codes TFADETC modified SPA-034 SPA Kathy Montoya
Process can be run to
recognize Revenue and
A/R and to calculate
4 Deferred Grant FRRGRNT IDC and CS amounts SPA-035 SPA Kathy Montoya
NMSU
Sponsored Project Accounting
Banner Upgrade Test Plan - Accounts Receivable
As of August 2009
Actual Results /
ID# Business Scenario Form / Process Name Business Requirement Test Case No. Testing Owner Tester Test Date Pass / Fail
FAIL Notes
Veiw system control
5 System Control Form FRASYSC settings SPA-036 SPA Kathy Montoya
Reports can be
processed, viewed, and
5 Reports printed SPA-037 SPA Kathy Montoya
AppWorx Processes
Sweep the Fiscal
Monitor assigned to the
Grant, Fund, and Events
based on the Fund
1 FIN_SPA_FIMSMGR_MOD FRAGRNT Code Level 2. SPA-038a SPA Mickey Duttle
FTMFUND SPA-038b SPA Mickey Duttle
FRAEVGA SPA-038c SPA Mickey Duttle
Sweep the Billing Period
Date on FRABDCN for a
2 FIN_SPA_FRRBDET_BILL FRABDCN specified Fund SPA-039 SPA Maggie Fraga
Sweep the Status on
FRABDCN for a
3 FIN_SPA_FRRBDET_HOLD FRABDCN specified Fund SPA-040 SPA Crystal Luchini
PSL Mods (SPA)
Test the following TABS
on Form: Main form,
SCA Rates form,
Composite Labor form,
Enter CLC rates for PSL & Labor Code Rates
1 contracts ZPAPSLC form. PSL-001 SPA Jill Williams
2 Feed Payroll PSL-002 PAYROLL
Run the CLC Mod for a
given PICT Code for
Verify CLC Mod for a given Payroll data and verify
PICT Code for Payroll data is the transactions are
3 complete and correct ZPPPSLC placed into GURFEED PSL-003 PAYROLL
Run the ADL Mod for a
given PICT Code for
Verify ADL Mod for a given Payroll data and verify
PICT Code for Payroll data is the transactions are
4 complete and correct ZPPPSLA placed into GURFEED PSL-004 PAYROLL
Postings to GURFEED Verify postings to
are complete and GURFEED are
5 Verify Postings are correct correct complete and correct PSL-005 SPA Tina Hales
New Processes