Release Forms for Spa

Description

Release Forms for Spa document sample

Shared by: kds21334
Categories
Tags
-
Stats
views:
16
posted:
8/2/2011
language:
Hungarian
pages:
26
Document Sample
scope of work template
							  FORM                                TEST                                USER
                                      Transactions
        Account Detail -Refunds (Title IV), CLFD, BDPY, HADD,
TSAAREV WTRS, Apply/Unapply                                      Barbara/Angie
TGRAPPL Apply Process - Run on whole population                  Angie
TGRUNAP Student Unapplication of Process                         Angie
        Mass Data Entry Form - List of transactions added to
TSAMASS accounts                                                 Babara
        Student Account Detail - check student account
TSADETL transactions                                             Angie
        Account Review Form/Collection Status - make sure
TSAACCT don't appear on bills if Bill Code Exists                Angie/Bertha
TSICSRV Customer Service Inquiry                                 Barbara
TGIACCD Accound Detail Query                                     Barbara
TSIAPPL Payment Review/Compare charge to payment                 Angie
                                       Registration

SOATERM Term Control - Create Effective Date/Cutoff Date for term Angie
        Registration Fee Assessment Rules - Tuiton/Fees and
SFARGFE Waivers                                                   Angie
SFRFASC Tution Re-assess - Re-calc account updates                Angie

SFARSTS   Refund Rules - Set up MD, WD, WA and WC percentages    Angie
SFAREGS   Test Student Registration Refund/Fee Calc.             Angie
SFAREGF   Check on the correct refund that is made.              Angie
TSRCBIL   SCHEDINV mode                                          Angie
                                           Holds
TGAHOLD   Make sure criteria is set for different AR holds.      Angie
          Hold Process (ARRH/ARPD) - Run for registration and
TGPHOLD   degree/transcript                                      Angie
SOAHOLD   Remove Hold/Add Individual hold                        Angie
                                      Disenrollment
SFRRNOP   Disenrollment Process                                  Angie
SFAREGS   Status - None, Accept, Confirm (TSASPAY, ICT Feed)     Angie
                                           Billing
          Run bills with monthly billing parameters (Access to
TSRCBIL   select and Crystal Reports to Print)                   Angie
                                        Third Party
TSACONT   Authorize Contract                                     Diana
TSACONP   Contract Person Authorization                          Diana
TSASPAY   Payment                                                Diana
TSAADSP   Distribution of Single Payment                         Diana
TGACREV   Cashier Session Review                                 Diana
TSRCBIL   Apply Credit Mode                                      Angie
TSRROLL   Contract Exemption Roll                                Angie
                                         1098 Tax
TSATAXN   Student Tax Notification                               Brian
TSP1098   Tax Notification                                       Brian
 TSR1098    Tax Report                                              Brian
                                      Waivers
 SGASADD Student Attributes (Dependent Waivers)                     Angie/Diana
 TSAEXPT Staff                                                      Angie/Diana
 TSRCBIL Apply Credit Mode                                          Angie
                                  Installment Plan
 TSAISTC Set up Installment Codes                                   Angie
 TSAISTR Set up Installment Rules                                   Angie
 Appworx Run Installment                                            Angie
 TSPISTT Create Installment Transactions                            Angie
                                  Cashier Sessions
         Cashier Supervisory (Individuals, RFND, other auto close
         sessions) - make sure process runs with daily check
 TGACSPV process                                                    Angie
 TGACREV Cashier Session Review                                     Angie/Barbara
 Appworx Run UAR_STUDENT_DAILY after FA disbursement                Angie
                                     Collections




                                        AppWorx
Chain/Module                          Test                                  User
           Assign students to correct plan
 AR_TBRISTL_INSERT                                                  Angie
           TGRAPPL, TSRRFND, TGRUNAP, TGRCLOS - setting up
           Financial Aid
 UAR_STUDENT_DAILY refunds                                          Angie
 AR_CUST_ACCOUNTS_PROCESS
 AR_EMPL_DROP_PROCESS

          AR Transaction Feed (Athletic
 AR_TBRACCD_LOAD_EXTERNAL_CHAIN Aid, Art & Music Fees)              Angie




                                       Reports
 TGRAGES Balances                                                   Barbara/Angie
 TGRRCON A/R Reconciliation Report                                  Angie
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                                         Suzanna
4     IDC Rates                    FTMINDR              be 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
13    Proposal                     FRAPROP              be 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
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

                                                        Budgets can be entered
                                                        and modifications can
                                   FRABUDG              be made                     SPA-014e         SPA             Thanh Nguyen
                                                        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                                            Suzanna
16    Xtender                      FRAGRNT              can be uploaded             SPA-016a         SPA             Burlingham
                                                        Xtender Documents                                            Suzanna
                                   FRAGRNT              can 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
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
                                   FRA270B              and printed               SPA-020c         SPA             Crystal Luchini
                                                        Invoice can be viewed
                                   FRA272B              and printed               SPA-020d         SPA             Crystal Luchini
                                                        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
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
                                                        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
                                                        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             Kathy Montoya
                                                        Cashier sessions can
2     Close Cashier Sessions       TGACREV              be 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 run and saved
                                   TGRCSHR              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
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
                                                        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


                                                        Veiw system control
5     System Control Form          FRASYSC              settings               SPA-036             SPA             Kathy Montoya
                                   FRRGRNT              Reports can be
                                   FRRBILL              processed, viewed, and
6   Reports                        FRRBEXC              printed                SPA-037             SPA             Kathy Montoya
AppWorx Processes
                                                        Sweep the Fiscal
                                                        Monitor assigned to the
                                                        Grant, Fund, and
                                                        Events based on the
1     FIN_SPA_FIMSMGR_MOD          FRAGRNT              Fund Code Level 2.      SPA-038a           SPA             Kathy Montoya
                                   FTMFUND                                      SPA-038b           SPA             Kathy Montoya
                                   FRAEVGA                                      SPA-038c           SPA             Kathy Montoya
                                                        Sweep the Billing
                                                        Period Date on
                                                        FRABDCN for a
2     FIN_SPA_FRRBDET_BILL         FRABDCN              specified Fund          SPA-039            SPA             Kathy Montoya
                                                        Sweep the Status on
                                                        FRABDCN for a
3   FIN_SPA_FRRBDET_HOLD           FRABDCN              specified Fund          SPA-040            SPA             Kathy Montoya
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
New Mexico State University                                                                                                                                      Revised 8/2/20117:03 PM
                                                            Upgrade:             Instance:
Finance Test Plan - Accounts Payable                             Version 8.x              UBN8               * Result Good = no, explain in Problems section

Sub-Module/Process                                                 Metrics           Assigned to:    Date     * Result Initials                        Problems or Comments
                                                                                                    Tested   Good? Y/N
4. Accounts Payable
    Maintenance & Validation forms set up
        FTMDISC (Discount codes)                                can enter data            AP                     NA                Not used
        FTMTRAT (Tax rate codes)                                can enter data            AP                     NA                Not used
        FTMTGRP (Tax group codes)                               can enter data            AP                     NA                Not used
    Vendor Payments (FAAINVE)                                   can enter data            AP
        Purchase Orders - Regular pymt entry                    can enter data            AP
        Purchase Orders - Pre-paid - Regular pymt entry         can enter data            AP
        Vouchers - Direct payment / reimbursements entry        can enter data            AP
        Vouchers - Reimbursements - Direct pymt entry           can enter data            AP
        Vendor pymts issuing separate checks                    can enter data            AP
        Vendor pymts made by wire transfer                      can enter data            AP
        Credit Memo entry                                       can enter data            AP
        Recurring vendor pymt (FAAINVE)                         can enter data            AP                     NA                Not used
        Set frequency for Recurring payable using FAARUIV       can enter data            AP                     NA                Not used
        Vouchers - PCard - Direct payment entry                 can enter data            AP                     NA                Not used
    Changing a vendor pymt due date (FAAPAYC)                   can enter data            AP
    Delete an incomplete invoice documents (FAAINVE)            can enter data            AP
    Cancel completed invoice documents (FAAINVD)                can enter data            AP
    IRS 1099:
        Additions/deletions/adjustments (FAA1099)               can enter data            AP
        processing & printing (FAM1099)                         can enter data            AP
        Run FAT1099 (1099 test print pattern)                   can enter data            AP
        Run FAB1099 (1099 forms print)                          can enter data            AP




     40c54515-759e-4b7d-ae12-43f3f02e366b.xls
     Tab AP Accounts Payable                                                           8 of 26                                                                                  8/2/2011
New Mexico State University                                                                                                                                  Revised 8/2/20117:03 PM
                                                      Upgrade:               Instance:
Finance Test Plan - Accounts Payable                       Version 8.x                UBN8               * Result Good = no, explain in Problems section

Sub-Module/Process                                            Metrics            Assigned to:    Date     * Result Initials                        Problems or Comments
                                                                                                Tested   Good? Y/N
    Queries:
          FOIDOCH (Document history)                       can view data              AP
          FAICHKH (Check payment history)                  can view data              AP
          FAIINVE (Invoice/CM query)                       can view data              AP
          FAIINVL (Invoice/CM list)                        can view data              AP
          FAIOINF (Open invoices by FOAPAL)                can view data              AP                     NA                Not used
          FAIVHIS (Vendor history)                         can view data              AP
          FAIVINL (Vendor invoice list)                    can view data              AP
          FAIVINV (Vendor invoice query)                   can view data              AP
          FAIVNDH (Vendor detail history)                  can view data              AP
          FAIIREC (Receiving/matching status)              can view data              AP                     NA                Not used
          FTVDISC (Discount term codes)                    can view data              AP                     NA                Not used
          FTVFTRM (Freight term codes)                     can view data              AP                     NA                Not used
          FTVTGRP (Sales/use tax group codes)              can view data              AP                     NA                Not used
          FTVTRAT (Tax rate codes)                         can view data              AP                     NA                Not used
    Reports & processes:
          Run FARIAGE (Invoice aging)                     data is accurate            AP
          Run FARINVA (Invoice activity)                  data is accurate            AP
          Run FARIREC (Invoices awaiting receivers)       data is accurate            AP
          Run FAROINV (Open invoices)                     data is accurate            AP
          Run FARVHST (Vendor history)                    data is accurate            AP
          Run FARVNUM (Vendor list)                       data is accurate            AP
          Run FARWHLD (1099 withholding status)           data is accurate            AP
          Run FARWHLY (1099 audit report)                 data is accurate            AP
    Cancel a check (FAACHKS)
          Re-establish the invoice (FAACHKS)              can enter data              AP
    Initiate a check run
          FABMATC (Receiving matching process)             process runs               AP
          Run FARINVS (Invoice selection)                   completes                 AP
          FAABATC (Batch Check Print Form)                  completes                 AP
          FABCHKS (Batch Check Process)                     completes                 AP
          FABCHKP (Check Printing Process)                  completes                 AP




     40c54515-759e-4b7d-ae12-43f3f02e366b.xls
     Tab AP Accounts Payable                                                       9 of 26                                                                                  8/2/2011
New Mexico State University                                                                                                                               Revised 8/2/20117:03 PM
                                                              Upgrade:              Instance:
Finance Test Plan - Cash Management                                Version 8.x              UBN8                * Result Good = no, explain in Problems section

Sub-Module/Process                                                   Metrics            Assigned to:    Date     * Result Initials                  Problems or Comments
                                                                                                       Tested   Good? Y/N
2. Cash Management
    Claim on Cash balance
         Run FGRBIEX (bank cash interfund exception) DAILY        no exceptions                 FIP
         Run FGRCASH (bank interfund account control) DAILY      funds in balance               FIP
    Cancel a check (FAACHKS)
         Re-establish the invoice (FAACHKS)                       can enter data                AP
    Initiate a check run
         FURFEED (Finance Sweep Process)                            completes                   FIP
         FURAPAY (Refund Interface)                                 completes                   FIP
         FGRTRNI (Interface Process)                                completes                   FIP
         FGRTRNR (Transaction Error Report)                         completes                   FIP
         FABMATC (Receiving matching process)                     process runs                  AP
         Run FARINVS (Invoice selection)                         data is accurate               AP
         FAABATC (Batch Check Print Form)                           completes                   AP
         FABCHKS (Batch Check Process)                              completes                   AP
         FABCHKP (Check Printing Process)                           completes                   AP
         FABCHKR (Batch Disbursement Register)                      completes                   AP
         EVISIONS INTELLECHECK PROCESS                              completes                   AP
         FABCHKA (Posting Process to Accounting)                    completes                   AP
         FARCHKR (Disbursement Report)                              completes                   AP
         FTICHKS (Check number validation)                        can view data                 AP
         Run FATCHKS (Check print pattern)                          completes                   AP
    Manual checks entry & printing (FAAONLC)
         FAAONLC (Generate manual / online checks)                  completes                   AP
         Print checks with IntelliCheck (Evision) template          completes                   AP
    Bank tape table load                                            completes                   AP
    Bank Reconciliation:
         Check data entry (FAABREC) COA = N                       can enter data            CAR
         Run FARBREC (Bank recon report)                            completes               CAR
         FOIDOCH (Document history form - checks)                 can view data             CAR
         Run FARAAGE (Bank reconciliation activity aging)        data is accurate           CAR
         Run FARCSHR (Cash requirements report)                  data is accurate           CAR                                       Not used?
         Run FGRTOFR (due to/from control)                       data is accurate           CAR                                       Not used?
Additional:




      40c54515-759e-4b7d-ae12-43f3f02e366b.xls
      Tab AP - CAR Checks & Recon                                                    10 of 26                                                                            8/2/2011
New Mexico State University                                                                                                                            Revised 8/2/20117:03 PM
                                                    Upgrade:             Instance:
Finance Test Plan - Purchasing & Receiving                     8.x                UBN8               * Result Good = no, explain in Problems section

Sub-Module/Process                                         Metrics           Assigned to:    Date     * Result Initials                     Problems or Comments
                                                                                            Tested   Good? Y/N
3. Purchasing
    Maintenance & Validation forms set up:
        FTMBUYR (Buyer codes)                           can enter data        Purchasing
        FTMVEND (Vendor codes)                          can enter data        Purchasing
        FTMCOMM (Commodity codes)                       can enter data        Purchasing
        FTMCRSN (Cancellation codes)                    can enter data        Purchasing
        FTMFOBS (FOB codes)                             can enter data        Purchasing
        FTMPCLS (PO classes)                            can enter data        Purchasing
        FTMSHIP (Ship to codes)                         can enter data        Purchasing
        FTMUOMS (Unit of measurement codes)             can enter data        Purchasing
        FOACLAU (Clause codes)                          can enter data        Purchasing
        FTVFTRM (Freight term codes)                    can enter data        Purchasing                                  Not used
        FTMEQUL (Equivalency codes)                     can enter data        Purchasing                                  Not used
    Purchase Requisition entry: (FPAREQN)
        Commodity level acctg entry                     can enter data        Purchasing
        Document level acctg entry                      can enter data        Purchasing
        Delete Requisition (FPAREQN)                    can enter data        Purchasing
        Cancel Requisition (FPARDEL)                    can enter data        Purchasing
        Manual Buyer Assignment (FPAABUY)               can enter data        Purchasing
        Close Requisition (FPAEOCD)                     can enter data        Purchasing
    Automatic Buyer assignment (FTMBUYR)                can enter data        Purchasing                                  Not used - Buyers are assigned manually
    Purchase Order entry:
        Regular PO document level entry (FPAPURR)       can enter data        Purchasing
        Regular PO commodity level entry                can enter data        Purchasing
        Regular PO two way match entry                  can enter data        Purchasing
        Regular PO three way match entry                can enter data        Purchasing
        Regular PO specifying freight amount            can enter data        Purchasing
        Standing Order (encumber funds)                 can enter data        Purchasing
        FOAIDEN - Change a vendor name or id            can enter data        Purchasing
        From a Requisition (FPAPOAS)                    can enter data        Purchasing
        Delete PO                                       can enter data        Purchasing
        Cancel PO (FPAPDEL)                             can enter data        Purchasing
        Purchasing text entry (FOAPOXT)                 can enter data        Purchasing
        Close PO (FPAEOCD)                              can enter data        Purchasing
        Open a closed PO (FPAEOCD)                      can enter data        Purchasing
    Change Orders (FPACHAR)                             can enter data        Purchasing
        Change Orders Cancel (FPACDEL)                  can enter data        Purchasing




     40c54515-759e-4b7d-ae12-43f3f02e366b.xls
     Tab CPO - PO & Requisitions                                               11 of 26                                                                               8/2/2011
New Mexico State University                                                                                                                                  Revised 8/2/20117:03 PM
                                                         Upgrade:              Instance:
Finance Test Plan - Purchasing & Receiving                          8.x                 UBN8               * Result Good = no, explain in Problems section

Sub-Module/Process                                              Metrics            Assigned to:    Date     * Result Initials                     Problems or Comments
                                                                                                  Tested   Good? Y/N
    Queries:
         FPICOMS (Requisition commodity summary)             can view data          Purchasing
         FPIOPOB (Open PO's by buyer)                        can view data          Purchasing
         FPIOPOF (Open PO's by FOAPAL)                       can view data          Purchasing
         FPIOPOV (PO's by vendor)                            can view data          Purchasing
         FPIORQF (Open requisition by FOAPAL)                can view data          Purchasing
         FPIPOHD (PO validation)                             can view data          Purchasing
         FPIPORS (PO suspense list)                          can view data          Purchasing
         FPIPURR (PO query)                                  can view data          Purchasing
         FPIREQN (Requisition query)                         can view data          Purchasing
         FOICLAU (Clause list)                               can view data          Purchasing
         FOICOMM (Commodity for review)                      can view data          Purchasing
         FOIDOCH (Document history - RP's & PO's)            can view data          Purchasing
         FOIVEND (Vendor list)                               can view data          Purchasing
         FTIIDEN (Vendor search)                             can view data          Purchasing
         FPIREQS (Requisition suspense)                      can view data          Purchasing
         FPIRQST (Requisition validation)                    can view data          Purchasing
         FTVCOMM (Commodity codes)                           can view data          Purchasing
         FTVSHIP (Ship to)                                   can view data          Purchasing
         FTVAPPQ (Approval queues)                           can view data          Purchasing                                  Purchasing does not have access - FSA only?
         FOICACT (Requisition accounting review)             can view data          Purchasing                                  Not used - should departments be using this?
    Reports & Processes
         Run FPACORD (Change order form)                    data is accurate        Purchasing
         Run FPAPORD (PO form)                              data is accurate        Purchasing
         FPTPORD (Print PO test pattern)                    data is accurate        Purchasing                                  Is this used?
         FPTRQST (Print Requisition test pattern)           data is accurate        Purchasing                                  Is this used?
         Run FPARQST (Requisition form)                     data is accurate        Purchasing
         Run FPROPNP (Open PO's)                            data is accurate        Purchasing
         Run FPRPURA (PO Activity)                          data is accurate        Purchasing
         Run FPROPNR (Open Requisitions)                    data is accurate        Purchasing
         Run FGRIDOC (Incomplete documents)                 data is accurate        Purchasing
         Run FGROPNE (Open encumbrances)                    data is accurate        Purchasing
         Run FARVALP (Vendor alpha list)                    data is accurate        Purchasing
         Run FARVALN (Vendor Numeric List)                  data is accurate        Purchasing
3. Central Receiving
    Maintenance & Validation forms set up
         FTMRCMT (Receiving method codes)                    can enter data          Receiving
         FTMRRSN (Return reason codes)                       can enter data          Receiving
    Receiver entry: (FPARCVD)                                can enter data          Receiving
         FPCRCVP (Receiving goods PO item selection)         can enter data          Receiving
         Enter a delivery (FPADELV)                          can enter data          Receiving
         Enter return goods as an adjustment (FPARCVD)       can enter data          Receiving
         FPARRIM (Receipt Required Indicator)                can enter data          Receiving
    Queries:
         FOIDOCH (Document history - receivers)              can view data           Receiving
         FPIIREC (Receiving/matching detail)                 can view data           Receiving
         FPIPKSL (Receiver/packing slips validation)         can view data           Receiving
         FPIRCVD (Receiving goods)                           can view data           Receiving
         FPIRTRN (Returned goods validation)                 can view data           Receiving
    Reports & processes:
         Run FPRDELV (Delivery log)                         data is accurate         Receiving                                  Not used
         Run FPRRCDL (Receiving & delivery report)          data is accurate         Receiving                                  Not used
         Run FPRRCST (Receiving status)                     data is accurate         Receiving                                  Not used
Additional:
      40c54515-759e-4b7d-ae12-43f3f02e366b.xls
      Tab CPO - PO & Requisitions                                                    12 of 26                                                                               8/2/2011
New Mexico State University                                                                                                                         Revised 8/2/20117:03 PM
                                                Upgrade:              Instance:
Finance Test Plan - Purchasing & Receiving                 8.x                 UBN8               * Result Good = no, explain in Problems section

Sub-Module/Process                                     Metrics            Assigned to:    Date     * Result Initials                     Problems or Comments
                                                                                         Tested   Good? Y/N
        Run FPPPOBC (PO batch close process)       data is accurate            FIP




     40c54515-759e-4b7d-ae12-43f3f02e366b.xls
     Tab CPO - PO & Requisitions                                            13 of 26                                                                               8/2/2011
New Mexico State University                                                                                                                                   Revised 8/2/20117:03 PM
                                                      Upgrade:                 Instance:
Finance Test Plan - General Accounting                     Version 8.x                     UBN8                 * Result Good = no, explain in Problems section

Sub-Module/Process                                           Metrics                 Assigned to:       Date     * Result Initials                   Problems or Comments
                                                                                                       Tested   Good? Y/N
1. General Accounting
    Maintenance & Validation forms set up
         Chart of Accounts - FTMACCT COA = N              can enter data                   FIP
         Chart of Accounts - FTMATYP COA = N              can enter data                   FIP
         Chart of Accounts - FTMFUND COA = N              can enter data                   FIP
         Chart of Accounts - FTMORGN COA = N              can enter data                   FIP
         Chart of Accounts - FTMPROG COA = N              can enter data                   FIP
         Chart of Accounts - FTMSDAT COA = N              can enter data                   FIP
         Chart of Accounts - FTMACTL COA = N              can enter data                   FIP
         Chart of Accounts - FTMCOAS COA = N              can enter data                   FIP
         Chart of Accounts - FTMFTYP COA = N              can enter data                   FIP
         Chart of Accounts - FTMACTV COA = N              can enter data                   FIP
         Chart of Accounts - FTMACCI COA = N              can enter data                   FIP
         FTMATTS (Attribute type sets maintenance)        can enter data                   FIP
         FTMATTT (Attributes type maintenance)            can enter data                   FIP
         FTMATTV (Attribute value maintenance)            can enter data                   FIP
         FTMFATA (FOAPAL attribute association)           can enter data                   FIP
    Journal Entries -
    Journal Entries - JE05 (FGAJVCD)                  can enter data & posts             AFR
    Journal Entries - JE15 (FGAJVCD)                  can enter data & posts              FIP
    Journal Entries - CR05 (FGAJVCD)                  can enter data & posts              FIP
    Journal Entries - JE16 (FGAJVCD)                  can enter data & posts              FIP
    Journal Entries - Various (IDV, TS, CR05, etc.)   can enter data & posts              FIP
    Budget Entries - BD01, BD02, BD04 (FGAJVCD)       can enter data & posts         FIP / Various
    Interfaces
         FUPLOAD process                                completes & posts                 FIP
         Payroll & PSL feed - JV (FURFEED)              review FGRTRNR                FIP / Payroll
         A/R feed - JV (FURFEED)                        review FGRTRNR                    FIP
         Student refund feed (FURAPAY)                  review FGRTRNR                    FIP
         Review FGRTRNR (transaction errors)                completes                     FIP
         Review FGRTRNI (interface process)                 completes                     FIP
         Review FGRTRNH (daily transactions)                completes                     FIP
         Run GURDETL to view GURFEED documents              completes                     FIP
         Run GURTEXT (doc code report)                      completes                     FIP
         Run GURPDED (data element dictionary)              completes                     FIP
         Run GURDELT to delete GURFEED document             completes                     FIP
         Run GZRSHOB (show jobs running)                    completes                     FIP




      40c54515-759e-4b7d-ae12-43f3f02e366b.xls
      Tab FIP - GL                                                                          14 of 26                                                                         8/2/2011
New Mexico State University                                                                                                                                     Revised 8/2/20117:03 PM
                                                             Upgrade:            Instance:
Finance Test Plan - General Accounting                            Version 8.x                UBN8                 * Result Good = no, explain in Problems section

Sub-Module/Process                                                  Metrics            Assigned to:       Date     * Result Initials                   Problems or Comments
                                                                                                         Tested   Good? Y/N
    Posting & Reconciliation
        PO posting (FGRACTG - sleep/wake)                          completes            FIP / CPO
        Invoice posting (FGRACTG - sleep/wake)                     completes             FIP / AP
        JV posting (FGRACTG - sleep/wake)                          completes               FIP
        Fixed assets posting (FGRACTG - sleep/wake)                completes            FIP / CAR
    Queries
        FGIBAVL (Budget availability status)                     can view data               FIP
        FGIBDSR (Executive summary)                              can view data               FIP
        FGIBDST (Budget status)                                  can view data               FIP
        FGIBSUM (Organization budget summary)                    can view data               FIP
        FGIDOCR (Document retrieval)                             can view data               FIP
        FGIENCB (Encumbrance list)                               can view data               FIP
        FGIENCD (Detail encumbrance activity)                    can view data               FIP
        FGIGLAC (G/L activity)                                   can view data               FIP
        FGIJSUM (JV summary)                                     can view data               FIP
        FGIJVCD (List of suspended JV's)                         can view data               FIP
        FGIOENC (Encumbrance list)                               can view data               FIP
        FGIRCLE (Reclassification query)                         can view data               FIP
        FGITBAL (G/L trail balance)                              can view data               FIP
        FGITBSR (Trial balance summary)                          can view data               FIP
        FGITRND (Detail transaction activity) Query = F8         can view data               FIP
        FTIACTH (Account hierarchy)                              can view data               FIP
        FTIFATA (FOAPAL attribute association)                   can view data               FIP
        FTIFNDH (Fund hierarchy)                                 can view data               FIP
        FTILOCH (Location hierarchy)                             can view data               FIP
        FTIORGH (Organization hierarchy)                         can view data               FIP
        FTIPRGH (Program hierarchy)                              can view data               FIP
        FTVACCI (Account index codes)                            can view data               FIP
        FTVACCT (Account codes)                                  can view data               FIP
        FTVACTV (Activity codes)                                 can view data               FIP
        FTVATYP (Account type)                                   can view data               FIP
        FTVCOAS (COA)                                            can view data               FIP
        FTVEELI (External report codes - attributes)             can view data               FIP
        FTVEELT (External report translation - attributes)       can view data               FIP
        FTVFSYR (Fiscal year)                                    can view data               FIP
        FTVFTYP (Fund types)                                     can view data               FIP
        FTVFUND (Fund codes)                                     can view data               FIP
        FTVLOCN (Location codes)                                 can view data               FIP
        FTVORGN (Organization code)                              can view data               FIP
        FTVPROG (Program codes)                                  can view data               FIP
        FTVSDAT (System data)                                    can view data               FIP
        FGIAUTO (List of auto JV)                                can view data               FIP




      40c54515-759e-4b7d-ae12-43f3f02e366b.xls
      Tab FIP - GL                                                                            15 of 26                                                                         8/2/2011
New Mexico State University                                                                                                                                           Revised 8/2/20117:03 PM
                                                             Upgrade:                  Instance:
Finance Test Plan - General Accounting                            Version 8.x                      UBN8                 * Result Good = no, explain in Problems section

Sub-Module/Process                                                  Metrics                  Assigned to:       Date     * Result Initials                   Problems or Comments
                                                                                                               Tested   Good? Y/N
    Reports
       Run FGRACTH (account hierarchy) COA = N                    data is accurate                 FIP
       Run FGRORGH (org hierarchy) COA = N                        data is accurate                 FIP
       Run FGRFNDH (fund hierarchy) COA = N                       data is accurate                 FIP
       Run FGRPRGH (program hierarchy) COA = N                    data is accurate                 FIP
       Run FGRLOCH (location hierarchy) COA = N                   data is accurate                 FIP
       Run FGRCSRP (cash receipts)                                data is accurate                 FIP
       Run FGRBDSC (budget status)                                data is accurate                 FIP
       Run FGRBLSH (balance sheet)                                data is accurate                 FIP
       Run FGRFAAC (fund/acct activity)                           data is accurate                 FIP
       Run FGRFBAL (fund balance account)                         data is accurate                 FIP
       Run FGRFITD (inception to date)                            data is accurate                 FIP
       Run FGRFPSN (financial position)                           data is accurate                 FIP
       Run FGRGLTA (G/L transaction activity)                     data is accurate                 FIP
       Run FGRJVLR (journal voucher listing)                      data is accurate                 FIP
       Run FGRODTA (organization detail activity)                 data is accurate                 FIP
       Run FGROPNE (open encumbrances)                            data is accurate                 FIP
       Run FGRPDTA (program detail activity)                      data is accurate                 FIP
       Run FGRTAXR (stmt of taxes)                                data is accurate                 FIP
       Run FGRIDOC (incomplete documents) DAILY                      list of docs                  FIP
       Run FGRTRNH (transaction report) DAILY                   list of trans errors               FIP
       Run FGRTRNI (interface process) DAILY                         completes                     FIP
       Run FGRTBAL (trial balance) AS NEEDED                   list of transactions                FIP
       Run FGRTBEX (trial balance exceptions) DAILY                no exceptions                   FIP
       Run FGRCTRL (G/L - subsidiary ledger control) DAILY           in balance                    FIP
       Run FGRTOFR (due to/from control) DAILY                       in balance                    FIP
       Run FGRREOB (stmt of rev, exp, other)                         completes                     FIP
       Run FGRREOC (stmt of rev, exp, other)                         completes                     FIP
       Run FGRCHNA (stmt of changes in net assets)                   completes                     FIP
       Run FGRCUNA (stmt of rev, exp, net assets)                    completes                     FIP
       Run FGRCBSR (combining balance sheet)                         completes                     FIP


Additional:




      40c54515-759e-4b7d-ae12-43f3f02e366b.xls
      Tab FIP - GL                                                                                  16 of 26                                                                         8/2/2011
          New Mexico State University
                                                                               Upgrade:                 Instance:
          Finance Test Plan - TGRFEED                                          Version 8.x              UBN8                                 * Result Good = no, explain in Problems section

          Sub-Module/Process                                                            Metrics              Assigned to:            Date     * Result     Initials                 Problems or Comments
                                                                                                                                    Tested   Good? Y/N
          1. Daily TGRFEED (UC4 / ePrint)
                  TGRFEED                                                                                           FIP
                          Printer = DATABASE                                   completes no errors
                          Parameter 01 = Sysdate                               creates TGRFEED report
                          Parameter 02 = 1MA
                          Parameter 02 = 2AD
                          Parameter 02 = 3BI
                          Parameter 02 = 4BU
                  GXADIRD                                                      update data                          FIP
                        update invalid direct deposit records
                  FIN_GXRDIRD_AP_IND (UC4)                                     completes no errors                  FIP
                        run in update mode
                  FURAPAY                                                      completes no errors                  FIP
                          Printer = DATABASE
                          Parameter 01 = Bank Code = 74
                  TRRRCON                                                      completes no errors                  FIP
                          Printer = pb_fd                                      report sent to ePrint
                          Parameter 01 = 1
                          Parameter 02 = Sysdate
                          Parameter 03 = 3
                  TRRRCON                                                      completes no errors                  FIP
                          Printer = pb_fd                                      report sent to ePrint
                          Parameter 01 = 4
                          Parameter 02 = Sysdate
                          Parameter 03 = 3
                  FGRTRNI                                                      completes no errors                  FIP
                          Printer = DATABASE
                  FGRTRNR                                                      completes no errors                  FIP
                          Printer = DATABASE
                  FAIINVL                                                      can view data                        FIP
                          (select suspense, next blk, query S% to get vendor ID)
                  FURFEED                                                      completes no errors                  FIP
                          Printer = DATABASE                                   creates FURFEED report
                          Parameter 01 = S to update
                          Parameter 02 = ACTRECV
                  FGRTRNI                                                      completes no errors                  FIP
                          Printer = DATABASE
                  FGRTRNR                                                      completes no errors                  FIP
                          Printer = DATABASE
                  FGAJVCD                                                      can edit data
                          Fix Suspended Documents
                  TRRRCON                                                      completes no errors                  FIP
                          Printer = pb_fd                                      report sent to ePrint
                          Parameter 01 = 2
                          Parameter 02 = Sysdate
                          Parameter 03 = 3
                  TRRRCON                                                      completes no errors                  FIP
                          Printer = pb_fd                                      report sent to ePrint
                          Parameter 01 = 3
                          Parameter 02 = Sysdate
                          Parameter 03 = 3



40c54515-759e-4b7d-ae12-43f3f02e366b.xls
Tab FIP - Daily TGRFEED                                                                                             Page 17 of 26                                                                          8/2/2011
        New Mexico State University
                                                                 Upgrade:               Instance:
        Finance Test Plan - FURFEED                              Version 8.x            UBN8                         * Result Good = no, explain in Problems section

        Sub-Module/Process                                                Metrics            Assigned to:    Date     * Result    Initials                 Problems or Comments
                                                                                                            Tested   Good? Y/N
        1. Daily Finance Sweep (UC4 / ePrint)
                FIN_DAILY_10PM (UC4)                           completes no errors                  FIP
                      UAR manual checks report                 review emailed report
                      GURFEED report                           review emailed report
                      Daily / unscheduled system feeds         test feed list
                             AFRLES - ARROWHEAD LEASES
                             APMISC - ACCOUNTS PAYABLE
                             BOOKSTDT - BOOKSTORE-STUDENT
                             BOOKSTOR - BOOKSTORE-OTHERS
                             CAMANCK - CARLSBAD MANUAL CHECKS
                             CASHNET - CASHNET
                             CASHOFF - CASHOFF
                             CEVFEED - MISC CASH ENTRY FEED
                             DWCCFEED - DWCCFEED
                             ENGICR - ENGINEERING ICR
                             FDNPROG - FOUNDATION PROGRAM COVER
                             FUEL - FUEL
                             GRMANCK - GRANTS MANUAL CHECKS
                             JVFEED - MISCELLANEOUS JV FEED
                             MAINBGT - BUDGET FRINGE FILE
                             OFSIDV - OFS IDV BILLING
                             PAYROLL - PAYROLL
                             PROCURE - PROCURE
                             PSLFEED - PSL IDV BILLING
                             PURSPEC - SPECIALTY UNDERWRITERS
                             SPABDGT - GIFT BUDGET - SPA
                             TELEPHNE - TELECOMM
                             UARMANCK - UAR MANUAL CHECKS
                FIN_AFR_DAILY (UC4 to ePrint)                  completes no errors                  FIP
                      FGRBIEX                                  review ePrint reports
                      FGRCASH
                      FGRCTRL
                      FGRTBEX
                FURFEED                                        completes no errors                  FIP
                      Printer = DATABASE                       creates FURFEED report
                      Parameter 01 = S to update
                      Parameter 02 = ALL
                FGRTRNI                                        completes no errors                  FIP
                      Printer = DATABASE
                FGRTRNR                                        completes no errors                  FIP
                      Printer = DATABASE
                FGAJVCD                                        can edit data                        FIP
                      Fix Suspended Documents
                FIN_FUPLOAD_FEED_CHAIN (UC4)                   completes no errors                  FIP
                      Feeds using system ID
                FURFEED                                        completes no errors                  FIP
                      Printer = DATABASE                       creates FURFEED report
                      Parameter 01 = S to update
                      Parameter 02 = SYSTEM_ID
                FGRTRNI                                        completes no errors                  FIP
                      Printer = DATABASE
                FGRTRNR                                        completes no errors                  FIP
                      Printer = DATABASE




40c54515-759e-4b7d-ae12-43f3f02e366b.xls
Tab FIP - Daily Fin Sweep - Feeds                                                           Page 18 of 26                                                                         8/2/2011
   New Mexico State University
                                                                 Upgrade:                      Instance:
   Finance Test Plan - Month End Close                           Version 8.x                   UBN8                         * Result Good = no, explain in Problems section

   Sub-Module/Process                                                       Metrics                 Assigned to:    Date     * Result    Initials                 Problems or Comments
                                                                                                                   Tested   Good? Y/N
   1. Month End Close (UC4 / ePrint)
           FTMFSYR                                               can open new fiscal period                FIP
                   F7 to enter query mode
                   COA = N
                   Fiscal Year = 10
                   F8 to run query
                   Next Block (CTRL PGDN)
                   Go to Fiscal Period to open
                   Status = O (open)
                   F10 Save
           FURFEED (to post payroll items)                       completes no errors                       FIP
                   Printer = DATABASE                            creates FURFEED report
                   Parameter 01 = S to update
                   Parameter 02 = ALL
           FGRTRNI                                               completes no errors                       FIP
                   Printer = DATABASE
           FGRTRNR                                               completes no errors                       FIP
                   Printer = DATABASE
           FGRACTG                                               posting completes                         FIP
                   Printer = DATABASE
           FGAJVCD                                               can edit data                             FIP
                   Fix Suspended Documents
           FIN_PSL_MOD (UC4)                                     completes no errors                       FIP
                   Creates PSL ADL feed                          verify feed file creation
                   Creates PSL CLC feed                          verify feed file creation
                   Creates PSl Leave Rate feed                   verify feed file creation
           FURFEED (to post PSL payroll items)                   completes no errors                       FIP
                   Printer = DATABASE                            creates FURFEED report
                   Parameter 01 = S to update
                   Parameter 02 = ALL
           FGRTRNI                                               completes no errors                       FIP
                   Printer = DATABASE
           FGRTRNR                                               completes no errors                       FIP
                   Printer = DATABASE
           FGRACTG                                               posting completes                         FIP
                   Printer = DATABASE
           FGAJVCD                                               can edit data                             FIP
                   Fix Suspended Documents
           NMSU_FIN_SW_OFF (UC4)                                 turns posting off                         FIP
                   Verify that posting is off (review FOIAPPD)
           FRRGRNT                                               completes no errors                       FIP
                   Printer = pban_fd                             review ePrint costshare rpt
                   Recalculation: N
                   Date To: (end of month date)
                   Chart of Accounts: N
                   Fund Option: W
                   Fund: _5%
                   Posting Date: (end of month date)
                   Execution Mode: U
                   Report Type: D



40c54515-759e-4b7d-ae12-43f3f02e366b.xls
Tab FIP - Month End Close                                                                          Page 19 of 26                                                                         8/2/2011
   New Mexico State University
                                                                 Upgrade:                  Instance:
   Finance Test Plan - Month End Close                           Version 8.x               UBN8                         * Result Good = no, explain in Problems section

   Sub-Module/Process                                                       Metrics             Assigned to:    Date     * Result    Initials                 Problems or Comments
                                                                                                               Tested   Good? Y/N
   1. Month End Close (UC4 / ePrint)
           FGRTRNI                                               completes no errors                   FIP
                   Printer = DATABASE
           FGRTRNR                                               completes no errors                   FIP
                   Printer = DATABASE
           FGRACTG                                               posting completes                     FIP
                   Printer = DATABASE
           FGAJVCD                                               can edit data                         FIP
                   Fix Suspended Documents
           NMSU_FIN_SW_ON (UC4)                                  turns posting on                      FIP
                   Verify that posting is on (review FOIAPPD)
           FIN_FUPLOAD_FEED_CHAIN (UC4)                          completes no errors                   FIP
                   SYSTEM_ID: COSTSHAR
                   MODE: U
           FIN_GURFEED_TRANSDATE (UC4)                           completes no errors                   FIP
                   Document Code: CS######
                   Transaction Date: (end of month date)
           FURFEED (to post costshare feed)                      completes no errors                   FIP
                   Printer = DATABASE                            creates FURFEED report
                   Parameter 01 = S to update
                   Parameter 02 = COSTSHAR
           FGRTRNI                                               completes no errors                   FIP
                   Printer = DATABASE
           FGRTRNR                                               completes no errors                   FIP
                   Printer = DATABASE
           FGRACTG                                               posting completes                     FIP
                   Printer = DATABASE
           FGAJVCD                                               can edit data                         FIP
                   Fix Suspended Documents
           NMSU_FIN_SW_OFF (UC4)                                 turns posting off                     FIP
                   Verify that posting is off (review FOIAPPD)
           Finance GL Control Reports                            completes no errors                   FIP
                   FGRBIEX                                       review DATABASE reports
                   FGRCASH
                   FGRCTRL
                   FGRTBEX
           FRRGRNT (after cost share has posted)                 completes no errors                   FIP
                   Printer = pban_fd                             review ePrint report
                   Recalculation: N
                   Date To: (end of month date)
                   Chart of Accounts: N
                   Fund Option: A
                   Fund: _5%
                   Posting Date: (end of month date)
                   Execution Mode: U
                   Report Type: D
           FGRTRNI                                               completes no errors                   FIP
                   Printer = DATABASE
           FGRTRNR                                               completes no errors                   FIP
                   Printer = DATABASE



40c54515-759e-4b7d-ae12-43f3f02e366b.xls
Tab FIP - Month End Close                                                                      Page 20 of 26                                                                         8/2/2011
   New Mexico State University
                                                                 Upgrade:                      Instance:
   Finance Test Plan - Month End Close                           Version 8.x                   UBN8                         * Result Good = no, explain in Problems section

   Sub-Module/Process                                                       Metrics                 Assigned to:    Date     * Result    Initials                 Problems or Comments
                                                                                                                   Tested   Good? Y/N
   1. Month End Close (UC4 / ePrint)
           FGRACTG                                               posting completes                         FIP
                   Printer = DATABASE
           FGAJVCD                                               can edit data                             FIP
                   Fix Suspended Documents
           FOIAPPD                                               nothing left to post                      FIP
                   Posting queue table review
           FTMFSYR                                               can close old fiscal period               FIP
                   F7 to enter query mode
                   COA = N
                   Fiscal Year = 10
                   F8 to run query
                   Next Block (CTRL PGDN)
                   Go to Fiscal Period to open
                   Status = C (close)
           FIN_EOM_REPORT (UC4)                                  completes no errors                       FIP
                   First of month: (first day of the month)      review emailed report
                   email: fip@nmsu.edu
           FIN_EOM_update (UC4)                                  completes no errors                       FIP
                   First of month: (first day of the month)      review emailed report
                   email: fip@nmsu.edu
           FIN_EOM_REPORT (UC4)                                  completes no errors                       FIP
                   First of month: (first day of the month)      review report (no rows)
                   email: fip@nmsu.edu
           NMSU_FIN_SW_ON (UC4)                                  turns posting on                          FIP
                   Verify that posting is on (review FOIAPPD)
           FIN_MONTHCLOSE (UC4)                                  completes no errors                       FIP
                   Fiscal Year: (current FY)                     review ePrint reports
                   Chart of Accounts: N
                   From Date (first day of the month)
                   To Date (last day of the month)
                   As of Date (last day of the month)
                   Beginning of Fiscal Year: (first day of FY)




40c54515-759e-4b7d-ae12-43f3f02e366b.xls
Tab FIP - Month End Close                                                                          Page 21 of 26                                                                         8/2/2011
New Mexico State University                                                                                                                                    Revised 8/2/20117:03 PM
                                                          Upgrade:             Instance:
Finance Test Plan - Rules, Security & Approvals                Version 7.4             UBAN               * Result Good = no, explain in Problems section

Sub-Module/Process                                               Metrics       Assigned to:       Date     * Result Initials                         Problems or Comments
                                                                                                 Tested   Good? Y/N
5. Rules, Security & Approvals
    Finance module set up
         Purchasing controls (FOASYSC)                        can enter data            ICT
         Fixed Assets controls (FOASYSC)                      can enter data            ICT
         A/P controls (FOASYSC)                               can enter data            ICT
         Grants controls (FOASYSC)                            can enter data            ICT
         Security controls (FOASYSC)                          can enter data            ICT
         GUAINST (Institutional Banner Version control)       can enter data            ICT
         GUACURR (Currency control)                           can enter data            FIP
         GXRBANK COA = N                                      can enter data            FIP
         GXADIRD (Direct deposit - Financial Aid)             can enter data            FIP
         FTMFMGR (Financial Manager Maintenance)              can enter data            FIP
         FTMFSYR (Fiscal Year Maintenance)                    can enter data            FIP
         FOAIDEN (Person ID form)                             can enter data            FIP
         FOAPERS (Finance general person)                     can enter data            FIP
         FOASEQN (Sequence number maintenance)                can enter data            FIP
         FOATELE (Telephone information)                      can enter data            FIP
         FOATEXT (General text entry)                         can enter data            FIP
         FOICOMP (Finance Non-person search)                  can enter data            FIP
         FOIIDEN (Finance person search)                      can enter data            FIP
         FOQADDR (Address information)                        can enter data            FIP
    Validation forms:
         FUVPROF (User profile list)                          can enter data            ICT
         FTVFMGR (Financial manager)                          can enter data            FIP
    Rule Classes set up (FTMRUCL)
         FTMRUCL                                              can enter data            FIP
    Security maintenance & validation forms set up
         FOMPROF (User Profile Maintenance)                   can enter data            ICT
         GSASECR (Form Process Security)                      can enter data            ICT




      40c54515-759e-4b7d-ae12-43f3f02e366b.xls
      Tab ICT - Security & Queues                                                     22 of 26                                                                                8/2/2011
New Mexico State University                                                                                                                                 Revised 8/2/20117:03 PM
                                                       Upgrade:             Instance:
Finance Test Plan - Rules, Security & Approvals             Version 7.4             UBAN               * Result Good = no, explain in Problems section

Sub-Module/Process                                            Metrics       Assigned to:       Date     * Result Initials                         Problems or Comments
                                                                                              Tested   Good? Y/N
    Approval Queue entry:
       Queue set up:
       FTMAPPQ (Approval queues)                           can enter data            ICT
       FOMAQRC (Queue routing)                             can enter data            ICT
       Approval Queue routing (FORAPPL - sleep/wake)       can enter data            ICT
       Requisition approval (FOAUAPP)                      can enter data            ICT
       Requisition disapproval (FOAUAPP)                   can enter data            ICT
       Requisition approval (FOAAINP)                      can enter data            ICT
       Requisition disapproval (FOAAINP)                   can enter data            ICT
       Requisition approval by user (FOADOCU)              can enter data            ICT
       View approval message (FOIAINP)                     can enter data            ICT
       View disapproval notification (FOIAINP)             can enter data            ICT
       Run FZRAQRC (approval queue routing)                                          ICT
       Run FZRAQUS (approval queues)                                                 ICT
       Run FZRPERR (error reports)                                                   ICT
    Approval Queries:
       FOIAPPH (Document approval history)                 can view data             FIP
       FOIAPHT (Approval history)                          can view data             FIP
       FOIDOCH (Document inquiry)                          can view data             FIP

Additional:




     40c54515-759e-4b7d-ae12-43f3f02e366b.xls
     Tab ICT - Security & Queues                                                   23 of 26                                                                                8/2/2011
New Mexico State University                                                                                                                                                 Revised 8/2/20117:03 PM
                                                                        Upgrade:              Instance:
Finance Test Plan - Fixed Assets                                             Version 8.x                     UBN8                 * Result Good = no, explain in Problems section

Sub-Module/Process                                                               Metrics                  Assigned to:    Date     * Result     Initials             Problems or Comments
                                                                                                                         Tested   Good? Y/N
6. Fixed Assets
    Maintenance & Validation forms set up:
        FTMACCT (Account codes for fixed assets)                        data is accurate                     CAR
        FTMFUND (Plant Fund codes)                                      data is accurate                     CAR
        FFASYSC (Fixed Assets control)                                  auto capitalization                  CAR
        FFVSDAT (Fixed assets unique codes)                             can enter data                       CAR
        FTMLOCN (Location codes)                                        data is accurate                     CAR
        FFVACON (Condition codes)                                       can enter data                       CAR
        FFVACQM (Acquisition codes)                                     can enter data                       CAR
        FFVDISP (Disposition codes)                                     can enter data                       CAR
        FTMASTY (Fixed assets type codes)                               data is accurate                     CAR
        FFVTTST (Fixed assets title codes)                              can enter data                       CAR
        FTMDEPR (Depreciation method codes)                             data is accurate                     CAR
    Enter a Capital Projects asset (FFAMAST)                            can enter data                       CAR

    Convert a temp tag on a capital asset (>$5k) to permanent (FFAMAST)can enter data                        CAR
    Convert a temp tag on a small & attractive asset to perm (FFAMAST) can enter data                        CAR
    Enter a gift/donated asset (FFAMAST)                               can enter data                        CAR
    Review Automatic Capitalization entry created when invoice posts   data is accurate                      CAR
    Adjustment entries & auto JV (FFAADJF):                                                                  CAR
        Sale of Asset                                                  can update data                       CAR
        Write Off of Asset                                             can update data                       CAR
        Write up/down adjustments                                      can update data                       CAR
        Permanent tag capitalization                                   can update data                       CAR
        Origination tag capitalization                                 can update data                       CAR
        Depreciation adjustment                                        can update data                       CAR
        Record Past Depreciation                                       can update data                       CAR
        GL Change Asset Account                                        can update data                       CAR
        GL Change Equity Account                                       can update data                       CAR
        GL Change Fund Code                                            can update data                       CAR
        GL Change Fund & Equity                                        can update data                       CAR
        GL Change Cap amount/account                                   can update data                       CAR
    Transfer an asset (FFATRAN)                                        can update data                       CAR
    Delete temporary tags (FFAFDEL)                                    can update data                       CAR
    Review converted legacy assets data on FFAMAST                     data is accurate                      CAR
    Review legacy accumulated depreciation                             data is accurate                      CAR




   40c54515-759e-4b7d-ae12-43f3f02e366b.xls
   Tab CAR - Fixed Assets                                                                         24 of 26                                                                                 8/2/2011
New Mexico State University                                                                                                                         Revised 8/2/20117:03 PM
                                                   Upgrade:           Instance:
Finance Test Plan - Fixed Assets                        Version 8.x                  UBN8                 * Result Good = no, explain in Problems section

Sub-Module/Process                                         Metrics                Assigned to:    Date     * Result     Initials             Problems or Comments
                                                                                                 Tested   Good? Y/N
    Queries:
       FFIMAST (Fixed assets master)               can view data                     CAR
       FFIFALV (Fixed assets list)                 can view data                     CAR
       FFIPROC (Fixed assets procurement)          can view data                     CAR
       FFIADJF (Fixed assets adjustments)          can view data                     CAR
       FFIADJH (Fixed assets adjustment history)   can view data                     CAR
       FFIADJL (Fixed assets adjustments list)     can view data                     CAR
       FFVTTST (Fixed assets title to list)        can view data                     CAR
       FTVASTY (Fixed asset type codes)            can view data                     CAR
       FTVDEPR (Depreciation codes)                can view data                     CAR
    Reports & Processes:
       Run FFPOEXT (O-tag extraction)              data is accurate                  CAR
       Run FFRAGRP (Asset group report)            data is accurate                  CAR
       Run FFRMAST (Asset master record report)    data is accurate                  CAR
       Run FFRPROC (Asset procurement report)      data is accurate                  CAR
       Run FFRPROP (Asset property report)         data is accurate                  CAR
       Run FFPDEPR (Depreciation)                  data is accurate                  FIP

Additional:




   40c54515-759e-4b7d-ae12-43f3f02e366b.xls
   Tab CAR - Fixed Assets                                                 25 of 26                                                                                 8/2/2011
New Mexico State University                                                                                                                        Revised 8/2/20117:03 PM
                                               Upgrade:             Instance:
Finance Test Plan - Web for Finance                 Version 8.x              UBN8                * Result Good = no, explain in Problems section

Sub-Module/Process                                    Metrics            Assigned to:    Date     * Result Initials                    Problems or Comments
                                                                                        Tested   Good? Y/N
8. Web for Finance
    GATEWAY WEB Budget Queries                     can view data
    GATEWAY WEB Approvals                          can enter data
    GATEWAY WEB Purchase Requisition entry                                                                             Not used?
    GATEWAY WEB Purchase Order entry                                                                                   Not used?
    GATEWAY WEB Budget Entries                                                                                         Not used?
Additional:




    40c54515-759e-4b7d-ae12-43f3f02e366b.xls
    Tab Finance - SSB                                               26 of 26                                                                                      8/2/2011

						
Related docs
Other docs by kds21334
San Technology
Views: 2  |  Downloads: 0
Release Back to Work Form - Excel
Views: 26  |  Downloads: 0
Release of Liability Forms Homeowner
Views: 161  |  Downloads: 0
Release Form for Publishing
Views: 14  |  Downloads: 0
Samples of Completed Performance Evaluations
Views: 16  |  Downloads: 0
Samples of Employee Letter of Appreciation
Views: 176  |  Downloads: 1
Release Landlord Tenant
Views: 14  |  Downloads: 0
Release of Contracted Services
Views: 2  |  Downloads: 0