Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

General Ledger Journal Entry Spreadsheet Template

VIEWS: 2,563 PAGES: 100

General Ledger Journal Entry Spreadsheet Template document sample

More Info
  • pg 1
									                                                                                  9b2d19ce-7ee8-4860-a04a-3133f0208047.xls


                                                                                                               Retest         Retest
Script No.                                                      Scenarios                       Pass/Fail                                                        Comments
                                                                                                              Pass/Fail      Pass/Fail
Online Journal Entry Processing
  GL01     Create an Online Journal using speedtype and all account types.

   GL02       Create an Online Reversing Journal

   GL03       Create an Online Journal which will fail Combo Edit.

   GL04       Delete an Online Journal.

   GL05       Copy an Online Journal and Process in Batch.

   GL06       Create an Online journal in a closed accounting period.

   GL07       Create a Template (Standard) Journal Entry - allow lines to be modified.                                                   Neither Milwaukee or Platteville uses Std Journal Entries
                                                                                                                                         so Tom & Karen did not test. JA advised he would check
                                                                                                                                         with Oshkosh because he thought they might be using this
                                                                                                                                         functionality. If so he would work with them on test
                                                                                                                                         scripts.
  GL08        Create a Recurring (Standard) Journal Entry - no modifications allowed.                                                    Same as GL07
  GL09        Create a Recurring (Standard) Journal Entry - allow lines to be modified.                                                  Same as GL07
  GL10        Create a Spread (Standard) Journal Entry - allow lines to be modified.                                                     Same as GL07
  GL11        Import an External Flat file                                                                                               Not currently using this process - test step GL12a
  GL12        Import Spreadsheet Journals                                                                                                Not currently using this process - test step GL12a
  GL12a       Test SQRs that load journals--GLSQ9043, etc

Open Item Processing
  GL13     Review Status and Reconcile Open Items                                                                                        We do not use Open Items at this time, so a decision was
                                                                                                                                         made to delete this script.
   GL14       Manually reconcile Open items                                                                                              Same as GL13

Process Journals (Batch Journal Processing)
   GL15     Batch process journals

   GL16       Mark Journals for Unposting                                                                                                We do not allow Uposting of Journals, so a decision was
                                                                                                                                         made to delete this script.
   GL17       Posted Journal Summary Report (GLS7009)

Suspense Correction

          File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                                 Last Revised on: 5/12/2005
          Worksheet: GL Script Summary
                                                                             9b2d19ce-7ee8-4860-a04a-3133f0208047.xls


                                                                                                          Retest         Retest
Script No.                                                       Scenarios                 Pass/Fail                                                        Comments
                                                                                                         Pass/Fail      Pass/Fail
  GL18         Suspended Activity Report                                                                                            Suspense function not currently used, so decision was made
                                                                                                                                    to delet the script.
  GL19         Correct Suspense Entries                                                                                             Suspense function not currently used, so decision was made
                                                                                                                                    to delet the script.
  GL20         Review Suspense Cross Reference                                                                                      Suspense function not currently used, so decision was made
                                                                                                                                    to delet the script.
Review Journal/Ledger Data (Inquire on Data)
  GL21     Ledger Inquiry/Drilldown

  GL22         Journal Inquire/Drilldown

  GL23         Ledger Group Inquire/Drilldown



  GL23a        Ledger Period Comparison                                                                                             Could not access Ledger Period Comparison

  GL24         Compare Across Ledgers                                                                                               Suggest this be deleted as our nVision Budget Summary
                                                                                                                                    Reports provide this information in a much better format.

General Reports
  GL25     Detail Ledger Summary Report                                                                                             Focus Group determined that this report is unusable, so a
                                                                                                                                    decision was made to delete this script.
  GL26         General Ledger Activity Report

  GL27         Journal Line/Accounting Reconciliation Report                                                                        Checking with Tina to see if we already have a query which
                                                                                                                                    is used by Campuses.
  GL28         Journal Entry Detail

  GL29         Ledger vs. Journal Integrity Report                                                                                  NOTE: UWSA will review monthly via queries. Test script
                                                                                                                                    deleted.
  GL30         Standard Journal Report

  GL31         Trial Balance Report                                                                                                 Able to run report, need to develop queries to validate data.

Average Daily Balance
  GL32    Monthly Average Daily Balances

GL Close

           File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                             Last Revised on: 5/12/2005
           Worksheet: GL Script Summary
                                                                                9b2d19ce-7ee8-4860-a04a-3133f0208047.xls


                                                                                                             Retest         Retest
Script No.                                                      Scenarios                     Pass/Fail                                                        Comments
                                                                                                            Pass/Fail      Pass/Fail
   GL33       GL Close process.                                                                                                        UWSA will test.

Allocations
   GL34     Copy Type Allocation (Use existing FB or IDC Allocation).




  GL34a       Create a Copy Type Allocation with multi-steps.




   GL35       Multi-step Copy Allocation (Use existing FB or IDC Allocation).

   GL36       Spread Evenly Type Allocation.                                                                                           This type of Allocation is not currently used by anyone, a
                                                                                                                                       decision was made to test at a later time.
   GL37       Fixed Basis Type Allocation.                                                                                             Same as GL36

   GL38       Prorata with Record Basis Type Allocation.                                                                               Same as GL36

   GL39       Arithmetic Operation Type Allocation.                                                                                    Same as GL36

   GL40       Copy Step Utility

   GL41       Allocation Group Report

   GL42       Allocation Calculation Log Report                                                                                        This is included in GL34.

   GL43       Background Process Report                                                                                                Appears to provide same information as Message Log,
                                                                                                                                       decided to delete this script.
Bank Reconciliation
   GL44    Automated Reconciliation.                                                                                                   UWSA does the bank reconciliation
   GL45    Semi-Manual Reconciliation                                                                                                  UWSA does the bank reconciliation
   GL46    Manual Reconciliation.                                                                                                      UWSA does the bank reconciliation
Tree Maintenance
   GL47     Tree Maintenance

   GL48        Tree Viewer


          File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                                Last Revised on: 5/12/2005
          Worksheet: GL Script Summary
                                                                                9b2d19ce-7ee8-4860-a04a-3133f0208047.xls


                                                                                                             Retest         Retest
Script No.                                                      Scenarios                     Pass/Fail                                                       Comments
                                                                                                            Pass/Fail      Pass/Fail
Customizations Review
  GL49
   GL50
   GL51
   GL52
   GL53
   GL54
   GL55
Design Chartfiled
    CF1    Create a SHARE owned chartfield                                                                                             UWSA personnel will test
   CF2        Create a BU(Campus) owned Chartfield                                                                                     Mgr Name is a problem, no longer free form, must be in
                                                                                                                                       "some" table in SFS.

   CF3        Find an existing Combination Template

   CF4        Create a Combination Definition

   CF5        Create a Combination Rule

   CF6        Create a Combination Group & Attach Combo Rules

   CF7        Run the Build Combination Data Process

   CF8        Define a Chartfield Attribute

   CF9        Attach a Chartfiled Attribute to a Department, Project or Class

   CF10       Review Chartfield Combination Editing Group Reprt

   CF11       Review Chartfield Combination Editing Rule Reprt




              Not sure if new but we should look at Alternate & Statutory Accounting in
              Chapter 6-Possible mapping to DOA Accounts


          File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                              Last Revised on: 5/12/2005
          Worksheet: GL Script Summary
                                                            9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

GL Special Instructions:

Task                           Instructions                                             Navigation
Create/Update Online           1. On the Header page, defaults will appear for          Create Journal
Journals                       Ledger, Source, Transaction Code, Fiscal Year,           General Ledger >> Journals >> Journal Entry >> Create
                               Period, and ADB date. Unless otherwise instructed        Journal Entries >> Add a New Value >> Enter Business Unit
                               in the test script, the only data you need to enter on   and a journal date or accept the default of today's date >> click
                               this page is the Header Description.                     on Add

                               2. On the Line page, enter the data for the journal      Update / View Journal
                               line transactions, as instructed in the test script.     General Ledger >> Journals >> Journal Entry >> Create
                               Click on the "+" to add one line at a time.              Journal Entries >> Find an Existing Value Page >> Enter
                                                                                        Business Unit and other criteria for a journal you want to open
                                                                                        >> Click on Search
Save Journal Online            Click on Save push button, bottom left side, on any      Create Journal
                               of the Create Journal Entries Pages                      General Ledger >> Journals >> Journal Entry >> Create
                                                                                        Journal Entries >> Add a New Value >> Enter Business Unit
                                                                                        and a journal date or accept the default of today's date >> click
                                                                                        on Add

                                                                                        Update / View Journal
                                                                                        General Ledger >> Journals >> Journal Entry >> Create
                                                                                        Journal Entries >> Find an Existing Value Page >> Enter
                                                                                        Business Unit and other criteria for a journal you want to open
                                                                                        >> Click on Search




  File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                  Last Revised on: 8/25/03
  Worksheet: GL Special Instructions                                                                                                  Last Printed on: 7/19/2010
                                                          9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

GL Special Instructions:

Task                           Instructions                                           Navigation
Edit Journal Online            Select Edit Journal from the drop down list next to    Create Journal
                               Process push button on the Lines Page. Then click on   General Ledger >> Journals >> Journal Entry >> Create
                               the Process push button to begin the process.          Journal Entries >> Add a New Value >> Enter Business Unit
                                                                                      and a journal date or accept the default of today's date >> click
                                                                                      on Add

                                                                                     Update / View Journal
                                                                                     General Ledger >> Journals >> Journal Entry >> Create
                                                                                     Journal Entries >> Find an Existing Value Page >> Enter
                                                                                     Business Unit and other criteria for a journal you want to open
                                                                                     >> Click on Search
Post Journal Online            Select Post Journal from the drop down list next to   Create Journal
                               Process push button on the Lines Page. Then click on General Ledger >> Journals >> Journal Entry >> Create
                               the Process push button to begin the process.         Journal Entries >> Add a New Value >> Enter Business Unit
                                                                                     and a journal date or accept the default of today's date >> click
                               Both Journal and Budget Status must be Valid (V), on Add
                               bottom right side on the Lines Page, before journal
                               can be posted.                                        Update / View Journal
                                                                                     General Ledger >> Journals >> Journal Entry >> Create
                                                                                     Journal Entries >> Find an Existing Value Page >> Enter
                                                                                     Business Unit and other criteria for a journal you want to open
                                                                                     >> Click on Search
Delete Journal Online          Select Delete Journal from the drop down list next to General Ledger >> Journals >> Journal Entry >> Create Journal
                               Process push button on the Line Page. Then click on Entries >> Find an Existing Value Page >> Enter Business Unit
                               the Process push button to begin the process.         and other criteria for a journal you want to open >> Click on
                                                                                     Search
Print Journal Online           Select Print Journal from the drop down list next to General Ledger >> Journals >> Journal Entry >> Create Journal
                               Process push button on the Line Page. Then click on Entries >> Find an Existing Value Page >> Enter Business Unit
                               the Process push button to begin the process.         and other criteria for a journal you want to open >> Click on
                                                                                     Search

  File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                Last Revised on: 8/25/03
  Worksheet: GL Special Instructions                                                                                                Last Printed on: 7/19/2010
                                                                          SFS 8.8 GL TEST SCRIPT
Test Objective:    Create an Online Journal using speedtype, and all account types.
Scenario: Add a Journal using a liability, an asset account, and a fund equity, and an expense and revenue with a dept. Each transaction line should include any other
chartfield your campus would normally use for the line transaction

                                                                                   Journal Data
                                   Line #
                                    and       Ledger               ADB            Reverse     Reverse
 BU      Jrnl ID     JrnlDate      Descr      Group Source Ref no. Date            Jrnl       Jrnl Dt      Fund         Acct        Dept      Program     Project       Amount



                                  Script Description                                                                       Test Notes                                    Initials
   1    Navigate to: General Ledger>>Journals>>Journal Entry>>Create
        Journal Entries>>Add
   2    Add a Journal with date for fiscal year 2005
   3    Enter transactions as needed to use every Account type
        Use more than one fund.
        Make one Fund out of balance.
   4    Edit online using the Process button.                                                There should be an out of balance error because one fund is not
                                                                                             balanced.
   5    Correct the errors, Edit and Post Journal using the Process button
   6    Select Print from the online journal line page using the Process button.
   7    Click on Process Monitor. Once the process shows Success, Click on
        Details, Click on View Log/Trace, Click on GLC7501 to view and print
        Crystal Report.
   8    Navigate to: Reporting Tools>> Query>> Query Manager>> Find an
        existing Query. Select UW_88_GL_Journals. Run report. Data should match
        the journal detail report.
   9    Navigate to: General Ledger>>General Reports>>Journal Entry Detail.                  Reports should match -verifies reports are in sync.
        Run SQR Report. Print journal. Validate data on Journal Report (FIN2001)
        matches the report in #7.
  10    Repeat 1 thru 9 for Budget Accounts
                                                                                 Expected Results
Journal will edit and post to all correct tables with no errors.

             Overall Script Results                                GL Test Script Sign-Off
        Pass                 Re Test Pass
  X
        Fail                 Re Test Fail                                                                                                                      Date:



File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                        Last Revised on: 4/22/05
Worksheet: GL01                                                                                                                                           Last Printed on: 7/19/2010
                                                                         CFSE 8.8 GL TEST SCRIPT

Test Objective:   Create an Online Reversing Journal
Scenario: Create a Reversing Journal with yesterday's date that will reverse today.


                                                                                   Journal Data
                                   Line #
                                    and       Ledger               ADB            Reverse    Reverse
 BU      Jrnl ID     JrnlDate      Descr      Group Source Ref no. Date            Jrnl      Jrnl Dt   Fund   Acct      Dept   Program   Project       Amount




                                   Script Description                                                           Test Notes                             Initials
   1    Navigate to: General Ledger>>Journals>>Journal Entry>>Create
        Journal Entries. Add journal with yesterday's date
   2    On the Journal Header, click on Reversal and select next day.
   3    Add a Journal with date for fiscal year 2005.
   4    Edit and Post online using the dropdown box on lines page and click Process
        button
   5    Select Print Journal from the online journal line page in the dropdown and
        click on the Process button.
   6    Click on Process Monitor. Once the process shows Success, Click on
        Details, Click on View Log/Trace, Click on GLC7501 to view and print
        Crystal Report.
   7    Navigate to: Reporting Tools>> Query>> Query Manager>> Find an
        existing Query. Select UW_88_GL_Journals. Run report. Data should match
        the journal detail report.

Expected Results
Journal will edit and post to all correct tables with no errors.


             Overall Script Results                                GL Test Script Sign-Off
        Pass                 Re Test Pass
        Fail                 Re Test Fail                                                                                                    Date:




File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                       Last Revised on: 4/22/05
Worksheet: GL02                                                                                                                          Last Printed on: 7/19/2010
                                                                         SFS 8.8 GL TEST SCRIPT

Test Objective:     Enter an Online Journal which will fail Combo Edit.
Scenario: Enter a Journal which will fail Combo Edit, correct the Journal by changing invalid chartfields to valid chartfields, Re- Edit & Post online.
Dependency : Combo Edit which req


                                                                                  Journal Data
                                     Line #
                                      and       Ledger               ADB          Reverse Reverse
 BU    Jrnl ID         JrnlDate      Descr      Group Source Ref no. Date          Jrnl      Jrnl Dt       Fund         Acct         Dept      Program      Project       Amount
UWMIL GL03               11/8/2004                                               See attached reports for details




                                    Script Description                                                                     Test Notes                                      Initial
    1     Navigate to: General Ledger>>Journals>>Journal Entry>>Create                                                                                                  KMG
          Journal Entries>>Add
    2     Create a journal with 2 lines and no funds.                                        Combo Edit requires that all transactions have a fund.                     KMG

    3     Edit the journal online.                                                           Should be in error - combo edit error                                      KMG

    4     Correct the journal. Edit and Post the journal online.                             Should be in error - combo edit error                                      KMG

    5     Navigate to: Reporting Tools>> Query>> Query Manager>> Find an                                                                                                KMG
          existing Query. Select UW_88_GL_Journals. Run report. Data should match
          the journal detail report.

                                                                                    Expected Results
Journal will fail on first edit. After correcting errors, re-editing and posting, Journal Status is P and Budget status is V. Tables are populated correctly and completely.




                 Overall Script Results                            GL Test Script Sign-Off
          Pass                    Re Test Pass
          Fail                    Re Test Fail                                                                                                                  Date:




 File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                        Last Revised on: 12/1/04
 Worksheet: GL03                                                                                                                                           Last Printed on: 7/19/2010
                                                                     SFS 8.8 GL TEST SCRIPT

Test Objective:    Delete an Online Journal
Scenario: From online journal select Deleted Journal from the dropdown list next to Process button..




                                                                              Journal Data
                                     Line #
                                      and       Ledger               ADB       Reverse    Reverse
  BU       Jrnl ID     JrnlDate      Descr      Group Source Ref no. Date       Jrnl      Jrnl Dt      Fund   Acct      Dept   Program    Project       Amount




                                   Script Description                                                           Test Notes                               Initials
   1     Navigate to: General Ledger>>Journals>>Journal Entry>>Create
         Journal Entry>>Add
   2     Create an online journal with 2 lines. Edit online.
         Make a note of the Journal ID for step 4. DO NOT POST!! YOU CANNOT
         DELETE A POSTED JOURNAL
   3     Navigate to: General Ledger>>Journals>>Journal Entry>>Create
         Journal Entry>>Find an Existing Value. Select the journal you created in
         step 2 above.
   3     Select Delete Journal from the online journal line page in the dropdown and
         click on the Process button.
   4     Navigate to: Reporting Tools>> Query>> Query Manager>> Find an
         existing Query. Select UW_88_GL_Journals. Run report. No data should be
         selected because journal doesn't exist.

                                                                            Expected Results
Journal should not be in any of the Journal, Ledger or KK tables


                Overall Script Results                         GL Test Script Sign-Off
         Pass                     Re Test Pass
         Fail                     Re Test Fail                                                                                                 Date:




 File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                      Last Revised on: 12/1/04
 Worksheet: GL04                                                                                                                         Last Printed on: 7/19/2010
                                                                          SFSE 8.8 GL TEST SCRIPT
Test Objective:       Copy an Online Journal and Process in Batch.
Scenario: Copy a Journal. Process a copy of an existing Journal. Go to the Copy Journal page and enter the Journal ID and other applicable criteria. Click on Run to run the copy
process. Verify the journal has been copied correctly. Edit and Post the Journal using the batch Edit Process.


                                           Script Description                                                                   Test Notes                                      Initials
   1       Navigate to: General Ledger>>Journals>>Journal Entry>>Copy Journal Select
           Run Control
   2       Enter criteria for journal you want to copy and the data for the new journal
   3       Click on run to go to the Process Scheduler Request page.
   4       At the Process Scheduler Request page, enter the criteria for running the Copy Process.
           Click OK to begin the process. (Server=PSUNX)
   5       Click on the Process Monitor to verify that the process completed successfully.
   6       Navigate to: General Ledger>>Journals>>Journal Entry>>Create Journal
           Entry>>Find an Existing Value. Verify the existance of the copied journal.
   7       Navigate to: General Ledger>>Journals>>Process Journals>>Edit Journal >> Add
           or Find an Existing Value. Select the Edit Journal run control.
   8       On the Run Request page check, Edit, Post, Re-Edit, Mark to Post and Budget Check the
           journal. Enter criteria for copied journal. Click on the run button.
   9       On Process Scheduler make sure the PSUNX server is selected. Select GL Journal Edit
           and Error Report. Click on OK.
   10      Click on the Process Monitor button. Click on refresh to view the progress.
   11      When the Run Status is Success, Navigate to: General Ledger>>Journals>>Process
           Journals>>Review Journal Status >> Find an Existing Value. Enter the journal ID
           and click Search. The Search results will provide the journal header status and budget
           checking status.
   12      Navigate to: Reporting Tools>> Query>> Query Manager>> Find an existing Query.
           Select UW_88_GL_Journals. Run report. Verify that data was corrected posted.

                                                                                    Expected Results
Journal is copied, edited, and posted successfully. The tables are successfully updated.


                  Overall Script Results                      GL Test Script Sign-Off
           Pass                    Re Test Pass
           Fail                    Re Test Fail                                                                                                                      Date:




        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                Last Revised on: 4/22/05
        Worksheet: GL05                                                                                                                                   Last Printed on: 7/19/2010
                                                                      SFS 8.8 GL TEST SCRIPT

Test Objective:     Create an Online Journal in a closed accounting period
Scenario: Create journal entry with closed period journal date (Fiscal Year 2003). Online Edit fails because of an invalid date/closed period.




                                                                                Journal Data
                                     Line #
                                      and       Ledger               ADB        Reverse     Reverse
  BU       Jrnl ID     JrnlDate      Descr      Group Source Ref no. Date        Jrnl       Jrnl Dt      Fund         Acct        Dept     Program    Project       Amount




                                   Script Description                                                                    Test Notes                                Initials
    1     Navigate to: General Ledger>>Journals>>Journal Entry>>Create                                                                                            KMG
          Journal Entry>>Add
    2     Add a Journal with date for fiscal year 2003.                                                                                                           KMG
    3     An error message should appear.                                                                               See attached.                             KMG

                                                                              Expected Results
You will get an error message when adding a journal for a closed period.




               Overall Script Results                          GL Test Script Sign-Off
          Pass                  Re Test Pass
          Fail                  Re Test Fail                                                                                                              Date:




 File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                  Last Revised on: 12/1/04
 Worksheet: GL06                                                                                                                                     Last Printed on: 7/19/2010
                                                                          SFS 8.8 GL TEST SCRIPT

Test Objective:       Create a Template (Standard) Journal Entry - copy journal lines and allow lines to be modified.
Scenario: Define a Standard Template Journal Entry - allow lines to be modified. Select a schedule and date range. Create journals using the Template. Use Review
Journals to verify journals were create. Open one of the standard template journals, m


                                                                                Journal Data
                                     Line #
                                      and       Ledger               ADB        Reverse   Reverse
  BU       Jrnl ID     JrnlDate      Descr      Group Source Ref no. Date        Jrnl     Jrnl Dt   Fund        Acct       Dept      Program     Project       Amount




                                   Script Description                                                             Test Notes                                   Initials
    1     Add a Journal with date for fiscal year xxxx.
    2     Enter an SJE ID for your Standard Journals.
    3     Under SJE Detail, select SJE Type Template
    4     Under Standard Journal section, select a Journal ID and date and check the
          box for 'Allow Lines to be Modified'
    5     Under Standard Journal Section, use the default name or enter a name for the
          Standard Template Journal.
    6     Under the Create Standard Journals Section, select a Schedule, a From Date
          and To Date and the number of lead days (more than the number of months
          date range you have entered) you would like to create standard journals in
          advance. Leave blank to create

    7     Save
    8     Navigate to: General Ledger>>Journals>>Standard Journals>>Create
          Standard Journals>>Update
    9     Enter Always as the Processing Frequency, a BU, your template name in the
          From and To SJE and a description.
   10     Click on Run.
   11     Click on OK
   12     Click on Process Monitor until the process status is Success.

 File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                            Last Revised on: 10/21/04
 Worksheet: GL07                                                                                                                                Last Printed on: 7/19/2010
                                                                       SFS 8.8 GL TEST SCRIPT

Test Objective:       Create a Template (Standard) Journal Entry - copy journal lines and allow lines to be modified.
Scenario: Define a Standard Template Journal Entry - allow lines to be modified. Select a schedule and date range. Create journals using the Template. Use Review
Journals to verify journals were create. Open one of the standard template journals, m


                                                                                Journal Data
                                     Line #
                                      and       Ledger               ADB        Reverse       Reverse
  BU       Jrnl ID     JrnlDate      Descr      Group Source Ref no. Date        Jrnl         Jrnl Dt   Fund         Acct        Dept       Program    Project       Amount




                                 Script Description                                                                     Test Notes                                   Initials
   13     Add a process withcompleted go to step #14
          When Journal has date for fiscal year xxxx.
   14     Navigate to: General Ledger>>Journals>>Standard Journals>>Review
          Journals >>Update
   15     Click on Search.
   16     Click on the BU hyperlink next to the template for journals you have just
          created to verify journals were created for each time period within the From
          and To dates.
   17     Navigate to: General Ledger>>Journals>>Journal Entry>>Create
          Journal Entries >>Update
   18     Open one of the journals just created and verify that lines can be modified.    See Special Instructions tab - Edit Journal Online.
          Edit the journal to save the changes.

                                                                              Expected Results
Journals will be created for the date range you selected based on the template you defined.


               Overall Script Results                          GL Test Script Sign-Off
          Pass                  Re Test Pass
          Fail                  Re Test Fail                                                                                                               Date:




 File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                  Last Revised on: 10/21/04
 Worksheet: GL07                                                                                                                                      Last Printed on: 7/19/2010
                                                                     SFSE 8.8 GL TEST SCRIPT

Test Objective:    Create a Recurring (Standard) Journal Entry - no modifications allowed
Scenario: Define a Recurring (Standard) Journal Entry - no modifications allowed. Create Recurring Journals and Review Journals created.



                                                                               Journal Data
                                     Line #
                                      and       Ledger               ADB       Reverse   Reverse
  BU       Jrnl ID     JrnlDate      Descr      Group Source Ref no. Date       Jrnl     Jrnl Dt    Fund        Acct       Dept      Program    Project       Amount




                                   Script Description                                                              Test Notes                                 Initials
    1     Navigate to: General Ledger>>Journals>>Standard Journals>>Define
          Journal Entries>>Add
    2     Add a Journal with date for fiscal year xxxx.
    3     Under SJE Detail, select SJE Type Recurring from the dropdown list.
    4     Under Model Journal section, select a Journal ID and date
    5     Under Standard Journal Section, use the default name or enter a name for the
          Standard Template Journal and uncheck the box for 'Allow Lines to be
          Modified'.
    6     Under the Create Standard Journals Section, select a Schedule, a From Date
          and To Date and the number of lead days (more than the number of months
          date range you have entered) you would like to create standard journals in
          advance. Leave blank to create

    7     Save
    8     Navigate to: General Ledger>>Journals>>Standard Journals>>Create
          Standard Journals>>Update
    9     Enter Always as the Processing Frequency, a BU, your template name in the
          From and To SJE and a description.
   10     Click on Run.
   11     Click on OK
   12     Click on Process Monitor until the process status is Success.
   13     When process has completed go to step #14


 File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                           Last Revised on: 10/21/04
 Worksheet: GL08                                                                                                                               Last Printed on: 7/19/2010
                                                                       SFSE 8.8 GL TEST SCRIPT

Test Objective:    Create a Recurring (Standard) Journal Entry - no modifications allowed
Scenario: Define a Recurring (Standard) Journal Entry - no modifications allowed. Create Recurring Journals and Review Journals created.



                                                                                 Journal Data
                                     Line #
                                      and       Ledger               ADB         Reverse    Reverse
  BU       Jrnl ID     JrnlDate      Descr      Group Source Ref no. Date         Jrnl      Jrnl Dt      Fund         Acct        Dept       Program    Project       Amount




                                Script Description                                                                       Test Notes                                   Initials
   14     Navigate to: General Ledger>>Journals>>Standard Journals>>Define
                                                          Journals>>Review
          Journal Entries>>Add
          Journals
   15     Click on Search.
   16     Click on the BU hyperlink next to the template for journals you have just
          created to verify journals were created for each time period within the From
          and To dates.
   17     Navigate to: General Ledger>>Journals>>Journal Entry>>Create
          Journal Entries >>Update
   18     Open one of the journals just created and verify that lines can be modified.     See Special Instructions tab - Edit Journal Online.
          Edit the journal.

                                                                              Expected Results
Journals will be selected for the date range you selected. No data should have been posted to the KK_Ledger tables for the unposted journals.


               Overall Script Results                           GL Test Script Sign-Off
          Pass                  Re Test Pass
          Fail                  Re Test Fail                                                                                                                Date:




 File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                   Last Revised on: 10/21/04
 Worksheet: GL08                                                                                                                                       Last Printed on: 7/19/2010
                                                                          SFS 8.8 GL TEST SCRIPT

Test Objective:    Create a Recurring (Standard) Journal Entry - allow lines to be modified.
Scenario: Define a Recurring (Standard) Journal Entry - modifications allowed. Create Recurring Journals and Review Journals created.
Dependencies: A Schedule must be set up before a Standard Journal can be created.


                                                                                Journal Data
                                     Line #
                                      and       Ledger               ADB        Reverse   Reverse
  BU       Jrnl ID     JrnlDate      Descr      Group Source Ref no. Date        Jrnl     Jrnl Dt   Fund        Acct       Dept         Program    Project       Amount




                                   Script Description                                                              Test Notes                                    Initials
    1     Navigate to: General Ledger>>Journals>>Standard Journals>>Define
          Journal Entries>>Add
    2     Add a Journal with date for fiscal year xxxx.
    3     Under SJE Detail, select SJE Type Recurring
    4     Under Model Journal section, select a Journal ID and date.
    5     Under Standard Journal Section, use the default name or enter a name for the
          Standard Recurring Journal and check the box for 'Allow Lines to be Modified'

    6     Under the Create Standard Journals Section, select a Schedule, a From Date
          and To Date and the number of lead days (more than the number of months
          date range you have entered) you would like to create standard journals in
          advance. Leave blank to create


    7     Save
    8     Navigate to: General Ledger>>Journals>>Standard Journals>>Create
          Standard Journals>>Update
    9     Enter Always as the Processing Frequency, a BU, your template name in the
          From and To SJE and a description.
   10     Click on Run.
   11     Click on OK
   12     Click on Process Monitor until the process status is Success.

 File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                              Last Revised on: 10/21/04
 Worksheet: GL09                                                                                                                                  Last Printed on: 7/19/2010
                                                                      SFS 8.8 GL TEST SCRIPT

Test Objective:    Create a Recurring (Standard) Journal Entry - allow lines to be modified.
Scenario: Define a Recurring (Standard) Journal Entry - modifications allowed. Create Recurring Journals and Review Journals created.
Dependencies: A Schedule must be set up before a Standard Journal can be created.


                                                                                Journal Data
                                     Line #
                                      and       Ledger               ADB        Reverse    Reverse
  BU       Jrnl ID     JrnlDate      Descr      Group Source Ref no. Date        Jrnl      Jrnl Dt      Fund         Acct        Dept       Program    Project       Amount




                                Script Description                                                                      Test Notes                                   Initials
   13     When process General Ledger>>Journals>>Standard Journals>>Define
          Navigate to: has completed go to step #14
   14     Journal Entries>>Add
          Navigate to: General Ledger>>Journals>>Standard Journals>>Review
          Journals >>Update
   15     Click on Search.
   16     Click on the BU hyperlink next to the template for journals you have just
          created to verify journals were created for each time period within the From
          and To dates.
   17     Navigate to: General Ledger>>Journals>>Journal Entry>>Create
          Journal Entries >>Update
   18     Open one of the journals just created and verify that lines can be modified.    See Special Instructions tab - Edit Journal Online.
          Edit the journal.
   19     Repeat steps 6-18: Specify From/To Date 12/01/03 - 01/31/04. Writes 1 new       See Special Instructions tab - Edit Journal Online.
          journal for REGR_GL091 01/31/04.

                                                                          Expected Results
Journals should have been created for each time period within the FROM and TO dates. Each journal will have the same Journal ID, but different dates.




               Overall Script Results                          GL Test Script Sign-Off
          Pass                  Re Test Pass

 File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                  Last Revised on: 10/21/04
 Worksheet: GL09                                                                                                                                      Last Printed on: 7/19/2010
                                                                   SFS 8.8 GL TEST SCRIPT

Test Objective:    Create a Recurring (Standard) Journal Entry - allow lines to be modified.
Scenario: Define a Recurring (Standard) Journal Entry - modifications allowed. Create Recurring Journals and Review Journals created.
Dependencies: A Schedule must be set up before a Standard Journal can be created.


                                                                            Journal Data
                                     Line #
                                      and       Ledger               ADB    Reverse    Reverse
  BU       Jrnl ID     JrnlDate      Descr      Group Source Ref no. Date    Jrnl      Jrnl Dt      Fund        Acct       Dept         Program    Project       Amount




                               Script Description                                                                  Test Notes                                    Initials
                              Ledger>>Journals>>Standard Journals>>Define
          Navigate to: GeneralRe Test Fail
          Fail                                                                                                                                         Date:
          Journal Entries>>Add




 File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                              Last Revised on: 10/21/04
 Worksheet: GL09                                                                                                                                  Last Printed on: 7/19/2010
                                                                      SFS 8.8 GL TEST SCRIPT

Test Objective:   Create a SJE Spread type Standard Journal Entry.
Scenario: Define an SJE Type of Spread for Standard Journal Entry. Create Standard Journals. Verify Spread Standard Journals were created for the date range
selected.


                                                                               Journal Data
                                     Line #
                                      and       Ledger               ADB       Reverse   Reverse
  BU       Jrnl ID     JrnlDate      Descr      Group Source Ref no. Date       Jrnl     Jrnl Dt   Fund        Acct       Dept     Program      Project       Amount




                                Script Description                                                                Test Notes                                  Initials
    1     Navigate to: General Ledger>>Journals>>Standard Journals>>Define
          Journal Entries>>Add
    2     Add a Journal with date for fiscal year xxxx.
    3     Under SJE Detail, select SJE Type Spread
    4     Under Model Journal section, select a Model Journal ID and date
    5     Under Standard Journal Section, use the default name or enter a name for the
          Standard Spread Journal and check the box for 'Allow Lines to be Modified'.

    6     Under the Create Standard Journals Section, Enter fiscal year-period
          information for the from/to period. The journal creation lead days must be
          greater than the number of days within the from/to period relative to the
          current date. Specify the date of t

    7     Save
    8     Navigate to: General Ledger>>Journals>>Standard Journals>>Create
          Standard Journals>>Update

    9     Enter Always as the Processing Frequency, a BU, your template name in the
          From and To SJE and a description.
   10     Click on Run.
   11     Click on OK


 File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                           Last Revised on: 10/21/04
 Worksheet: GL10                                                                                                                               Last Printed on: 7/19/2010
                                                                     SFS 8.8 GL TEST SCRIPT

Test Objective:   Create a SJE Spread type Standard Journal Entry.
Scenario: Define an SJE Type of Spread for Standard Journal Entry. Create Standard Journals. Verify Spread Standard Journals were created for the date range
selected.


                                                                              Journal Data
                                     Line #
                                      and       Ledger               ADB      Reverse    Reverse
  BU       Jrnl ID     JrnlDate      Descr      Group Source Ref no. Date      Jrnl      Jrnl Dt      Fund         Acct        Dept     Program     Project       Amount




                                 Script Description                                                                   Test Notes                                  Initials
   12     Navigate to: General Ledger>>Journals>>Standard Journals>>Define
          Click on Process Monitor until the process status is Success.
   13     Journal Entries>>Add
          When process has completed go to step #14
   14     Navigate to: General Ledger>>Journals>>Standard Journals>>Review
          Journals >>Update
   15     Click on Search.
   16     Click on the BU next to the name of the Spread SJE you have just defined and
          created to verify journals were created for each time period within the From
          and To dates.
   17     Navigate to: General Ledger>>Journals>>Journal Entry>>Create
          Journal Entries >>Update
   18     Open one of the journals just created and verify that lines can be modified. See Special Instructions tab - Edit Journal Online
          Edit the journal to save the changes.


                                                                          Expected Results
Journals should have been created for each time period within the FROM and TO dates. Each journal will have the same Journal ID, but different dates.




                 Overall Script Results                       GL Test Script Sign-Off
          Pass                    Re Test Pass
          Fail                    Re Test Fail                                                                                                          Date:
 File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                               Last Revised on: 10/21/04
 Worksheet: GL10                                                                                                                                   Last Printed on: 7/19/2010
                                                                     9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:   Import an External Flat file
Scenario: Import a file from an External source. Verify Journal and KK tables are complete and correct.




                                                                                       Journal Data
                                    Line #
                                     and       Ledger               ADB           Reverse    Reverse                                                                     Open
  BU       Jrnl ID     JrnlDate     Descr      Group Source Ref no. Date           Jrnl      Jrnl Dt      Fund         Acct        Dept      Program       Project     Item Key       Amount




                                    Script Description                                                                          Test Notes                                             Initials
   1     Create a journal flat file using the definition specified in PepoleSoft 8.4        An alternative method is to use the JRNL1.xls to create the flat file (see GL12 for
         General Ledger People Book                                                         instruction).




   2     Navigate to: General Ledger>>Journals>>Import
         Journals>>Spreadsheet Jounals>>Add or Use existing Run Control
   3     Enter the following run control information:
         Attached file: Click on the PaperClip push button to browse for the
               JRNL1.xml file
         Character Set = ISO_8859-1 (system default)
         Journal ID Mask = Campus Specific (see People Book for more information)

   4     Click on Run > Select PSUNX as the server

   5     Click on OK

   6     Click on (make sure server = PSUNX in Step 4) the Process Monitor until the
         process completes.
   7     Click on Detail hyperlink, click on Message Log. Read message to verify that
         0001 (one) journal was created.

       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                       Last Revised on: 8/25/03
       Worksheet: GL11                                                                                                                                          Last Printed on: 7/19/2010
                                                                     9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:   Import an External Flat file
Scenario: Import a file from an External source. Verify Journal and KK tables are complete and correct.




                                                                                        Journal Data
                                     Line #
                                      and       Ledger               ADB           Reverse    Reverse                                                                     Open
  BU        Jrnl ID     JrnlDate     Descr      Group Source Ref no. Date           Jrnl      Jrnl Dt      Fund         Acct        Dept       Program      Project     Item Key       Amount




                                     Script Description                                                                          Test Notes                                             Initials
   8      Create a journal flat fileLedger>>Journals>>Journalin PepoleSoft 8.4
          Navigate to: General using the definition specified Entry>>Create                  An alternative method istab use the JRNL1.xls to create the flat file (see GL12 for
                                                                                             See Special Instructions to - Create/Update Journal Online
          General Ledger People Book
          Journal Entries>>Find an Existing value                                            instruction).
   9      Review uploaded journal entry.

   10     Process Journal Edit and Post                                                      See Special Instructions - Edit and Posting Journals Online.

   11     Run queries to verify data has posted correctly to the correct tables.             See Special Instructions - Validation Queries..



                                                                                      Expected Results




                 Overall Script Results                          GL Test Script Sign-Off
          Pass                    Re Test Pass
          Fail                    Re Test Fail                                                                                                                 Date:




        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                       Last Revised on: 8/25/03
        Worksheet: GL11                                                                                                                                          Last Printed on: 7/19/2010
                                                                    9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:       Import a Spreadsheet Journal
Scenario: Create a journal spreadsheet in the PeopleSoft delivered file JRNL1.xls. Import the spreadsheet to create a flatfile with extension .xml. Load the file into PeopleSoft, access
the journal, and edit and post online. Run queries to verify data is correct in all correct Journal and KK tables.


                                                                                      Journal Data
                                    Line #
                                     and       Ledger               ADB          Reverse      Reverse                                                                     Open
  BU      Jrnl ID     JrnlDate      Descr      Group Source Ref no. Date          Jrnl        Jrnl Dt      Fund         Acct         Dept      Program      Project     Item Key       Amount




                                     Script Description                                                                           Test Notes                                            Initials
   1     Navigate to: c:\temp\JRNL1.xls                                                      Three PS delivered Excel files (JRNL1.xls; JRNLLOG.xls; JRNLMCRO.xla) are
         Open JRNL1.xls. Click Setup. Verify the Address under Online Import Control         needed to complete this test. They are dependent on each other, although only the
         is set to "http://cmsdev-fs.calstate.edu:0000/xmllink/xxxxxxxx/", where the 0000    JRNL1.xls will be used.
         denote the port number for the database and xxxxxxxx is the database name.
         Please verify the web address with campus DBA Group. Enter the rest of the          User will be asked to enter User ID/Password when processing the Spreadsheet
         infromation for the Spreadsheet Journal Options and Defaults. Click on OK to        Journal import. It is okay to click "Yes" to confirm the setup.
         save. Click on Yes if system prompts "This is not a secured web address. Use it
         any way?"
   2     Click New to create a spreadsheet journal. Enter the Journal Sheet Name when
         prompt by the system.

   3     To verify where the flatfile (with extension .xml), will be created when creating
         import spreadsheet flat file, click on Tools, Options, General and note the
         Default File Location. The default/delivered filename is JRNL1.xml.

   4     Click on the "+" bush button in the Header section to enter/modify the Journal      If Journal Header default information is entered in Step 1, it will be entered
         Header information.                                                                 automatically. However, Journal ID and Jouranl Date and Deacription
                                                                                             information is still required.

   5     Click on the "+" or "+…" bush buttons in the Line section to create journal line    Enter debit amount as positive number and credit amount as negative number.
         information.                                                                        Make sure total debit/credit is equal.




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                        Last Revised on: 8/25/03
       Worksheet: GL12                                                                                                                                           Last Printed on: 7/19/2010
                                                                     9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:       Import a Spreadsheet Journal
Scenario: Create a journal spreadsheet in the PeopleSoft delivered file JRNL1.xls. Import the spreadsheet to create a flatfile with extension .xml. Load the file into PeopleSoft, access
the journal, and edit and post online. Run queries to verify data is correct in all correct Journal and KK tables.


                                                                                        Journal Data
                                     Line #
                                      and       Ledger               ADB          Reverse        Reverse                                                                  Open
  BU       Jrnl ID     JrnlDate      Descr      Group Source Ref no. Date          Jrnl          Jrnl Dt      Fund        Acct        Dept      Program     Project     Item Key       Amount




                                      Script Description                                                                           Test Notes                                           Initials
   6      Navigate to: c:\temp\JRNL1.xls
          With the spreadsheet still open, click on the Import Now Icon (blue drum) to          Three PS delivered Excel files (JRNL1.xls; JRNLLOG.xls; JRNLMCRO.xla) are
                                                                                                For Spreadsheet Journal containing more than 50 journal lines, it is recommended
          initiate the online Click or click on the Home push button, then click on Control
          Open JRNL1.xls. importSetup. Verify the Address under Online Import the               needed to complete this test. They are dependent on each other, although only the
                                                                                                to process the journal via flat file upload.
          is set to "http://cmsdev-fs.calstate.edu:0000/xmllink/xxxxxxxx/", where thethe
          Write File push button to create the flat file. The data file will be saved to 0000   JRNL1.xls will be used.
          denote the port number for the database and xxxxxxxx is the database name.
          directory specify in Step 3.
          Please verify the web address with campus DBA Group. Enter the rest of the            User will be asked to enter User ID/Password when processing the Spreadsheet
   7      infromation for the Spreadsheet Journal Options and Defaults. Click contained
          Navigate to the directory to verify that JRNL1.xml file is created and on OK to       Journal import. It is okay to click "Yes" to confirm the setup.
          the journal data.
          save. Click on Yes if system prompts "This is not a secured web address. Use it
          any way?"
   8      Navigate to: General Ledger>>Journals>>Import Journals>>Spreadsheet
          Journals>>Add or Find an Exist Value

   9      Enter the following run control information:
          Number of Data files = Single Data file
          Attached file: Click on the PaperClip push button to browse for the
                 JRNL1.xml file
          Character Set = ISO_8859-1 (system default)
          If Journal already exists = Abort
          If Journal is Invalid = Abort
          Click on Run
          Click on OK
          Click on Process Monitor until process completes with Success status.
   10     Click on Detail hyperlink, click on Message Log. Read message to verify that
          0001 (one) journal was created.

   11     Navigate to: General Ledger>>Journals>>Journal Entry>>Create Journal
          Entries>>Find and Existing Value

        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                       Last Revised on: 8/25/03
        Worksheet: GL12                                                                                                                                          Last Printed on: 7/19/2010
                                                                     9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:       Import a Spreadsheet Journal
Scenario: Create a journal spreadsheet in the PeopleSoft delivered file JRNL1.xls. Import the spreadsheet to create a flatfile with extension .xml. Load the file into PeopleSoft, access
the journal, and edit and post online. Run queries to verify data is correct in all correct Journal and KK tables.


                                                                                        Journal Data
                                     Line #
                                      and       Ledger               ADB          Reverse      Reverse                                                                 Open
  BU       Jrnl ID     JrnlDate      Descr      Group Source Ref no. Date          Jrnl        Jrnl Dt      Fund         Acct         Dept     Program   Project     Item Key       Amount




                                      Script Description                                                                          Test Notes                                         Initials
   12     Navigate to: c:\temp\JRNL1.xls
          Review uploaded journal entry.                                                     Three PS delivered Excel files (JRNL1.xls; JRNLLOG.xls; JRNLMCRO.xla) are
          Open JRNL1.xls. Click Setup. Verify the Address under Online Import Control        needed to complete this test. They are dependent on each other, although only the
          is set to "http://cmsdev-fs.calstate.edu:0000/xmllink/xxxxxxxx/", where the 0000   JRNL1.xls will be used.
   13     Process Journal Edit and Post
          denote the port number for the database and xxxxxxxx is the database name.         See Special Instructions - Edit and Posting Journals Online.
          Please verify the web address with campus DBA Group. Enter the rest of the         User will be asked to enter User ID/Password when processing the Spreadsheet
          infromation for the Spreadsheet Journal Options and Defaults. Click on OK to       Journal import. It is okay to click "Yes" to confirm the setup.
   14     Run queries to verify data has posted correctly to the correct tables.             See Special Instructions - Validation Queries..
          save. Click on Yes if system prompts "This is not a secured web address. Use it
          any way?"

                                                                                        Expected Results
The .xml file is created, loaded into PeopleSoft journal tables, the journal is edited and posted. KK tables are correctly updated.


               Overall Script Results                          GL Test Script Sign-Off
          Pass                  Re Test Pass
          Fail                  Re Test Fail                                                                                                                 Date:




        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                    Last Revised on: 8/25/03
        Worksheet: GL12                                                                                                                                       Last Printed on: 7/19/2010
                                                                    9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:       Review Status and Reconcile Open Items
Scenario: Post journals with Open Item account transactions. Include Open Item transactions that will reconcile and close Open Item Keys when the Reconciliation process is run.
Review Open Items accounts before and after the Reconciliation process is run. Run the Open Item Listing Report and compare to the online information.
Dependencies: The box next to Skip Open Item Reconciliation under Set Up Financials/Supply Chain>>Common Definitions>>User Preferences>>General Ledger must be checked on.
This configuration allows users to control when Open Item transactions will be reconciled, a more efficient use of system resources.

                                                                                    Journal Data
                                     Line #
                                      and       Ledger               ADB       Reverse    Reverse                                                                    Open
  BU       Jrnl ID     JrnlDate      Descr      Group Source Ref no. Date       Jrnl      Jrnl Dt      Fund         Acct       Dept      Program       Project     Item Key       Amount




                                     Script Description                                                                       Test Notes                                          Initials
   1      Navigate to: General Ledger>>Open Items>>Review Status Online
          Accept defaults or enter criteria for the Open Item Accounts which you want to
          review. Review with "Open" reconciliation status selected. Click on Search to
          see listing of unreconciled Open Item transactions by Open Item Key.
   2      Add a Journal with date for fiscal year xxxx.
   3      Navigate to: General Ledger>>Journal>>Journal Entry>>Create Journal See Special Instructions tab - Create/Update Journal Online
          Entries>>Add
          Create a journal with the Open Item chartfields and an offsetting amount that  See Special Instructions tab - Edit and Post Journal Online
          will reconcile and close the open item noted in #2. Edit and post the journal.
   3A     Run the Open Item Listing Report and compare the results to the online
          information.
   4      Navigate to: General Ledger>>Open Items>>Process Reconciliation.
          On the Open Item Recon page, click on Always, enter a description, a business
          unit and the date as of the journal posted in step #3. Click on Run. Click on
          OK. Click on the Process Monitor until the process completes with Success
   5      Navigate to: General Ledger>>Open Items>>Review Status Online.
          Review with "Closed" reconciliation status selected.

                                                                                  Expected Results
Open Item with open status in #2 should show closed status in #5.

               Overall Script Results                         GL Test Script Sign-Off
          Pass                  Re Test Pass

        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                 Last Revised on: 8/25/03
        Worksheet: GL13                                                                                                                                    Last Printed on: 7/19/2010
                                                                 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:       Review Status and Reconcile Open Items
Scenario: Post journals with Open Item account transactions. Include Open Item transactions that will reconcile and close Open Item Keys when the Reconciliation process is run.
Review Open Items accounts before and after the Reconciliation process is run. Run the Open Item Listing Report and compare to the online information.
Dependencies: The box next to Skip Open Item Reconciliation under Set Up Financials/Supply Chain>>Common Definitions>>User Preferences>>General Ledger must be checked on.
This configuration allows users to control when Open Item transactions will be reconciled, a more efficient use of system resources.

                                                                                 Journal Data
                                    Line #
                                     and       Ledger               ADB     Reverse    Reverse                                                                 Open
  BU      Jrnl ID     JrnlDate      Descr      Group Source Ref no. Date     Jrnl      Jrnl Dt      Fund        Acct       Dept     Program      Project     Item Key       Amount




         Fail                     Re Test Fail                                                                                                      Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                            Last Revised on: 8/25/03
       Worksheet: GL13                                                                                                                               Last Printed on: 7/19/2010
                                                                    9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:       Maintain/Manually reconcile Open items
Scenario: Manually reconcile or Re-Open Open Items grouped by Open Item Keys or one at a time.
Note: This manual reconciliation process does not have any impact on the Actuals Ledger. This process is simply for tracking and internal reporting of open and closed Open Item
Account balances, for example employee travel advances. If an item is not closed in the Open Item Reconciliation Process, because there is no journalized offset or if it falls outside the
tolerance amounts, they can be manually reconciled under Open Item>>Maintenance.

                                                                                      Journal Data
                                     Line #
                                      and       Ledger               ADB        Reverse      Reverse                                                                   Open
  BU        Jrnl ID     JrnlDate     Descr      Group Source Ref no. Date        Jrnl        Jrnl Dt      Fund        Acct        Dept      Program      Project     Item Key       Amount




                                   Script Description                                                                          Test Notes                                            Initials
    1     Navigate to: General Ledger>>Journal>>Journal Entry>>Create                       See Special Instructions - Create/Update Jounral Online
          Journal Entries>>Add a New Value
    2     Add a Journal with date for fiscal year xxxx.
    3     Navigate to: General Ledger>>Open Items>>Maintenance
    4      Enter:
          BU=xxxxx
          Ledger=Actuals
          Inquire=Open
          Journal Date to and From = 01/01/1900 to today's date
          Account=A00021 ( Open Item test account)
          All other fields can be left open
    5     To manually reconcile, click on Search to get a list of open/unreconciled Open
          Item Keys status and amounts. If the summary rows net to a zero balance or
          meet your tolerance amount test for one item, check the boxes next to the rows.
          Click Reconcile. The item will disappear from the page.
          View Closed items and check the boxes of Open Items you want to Re-Open.
          The status will change to Open.
    6     Navigate to: General Ledger>>Open Items>>Open Item Listing Report



        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                    Last Revised on: 8/25/03
        Worksheet: GL14                                                                                                                                       Last Printed on: 7/19/2010
                                                                    9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:       Maintain/Manually reconcile Open items
Scenario: Manually reconcile or Re-Open Open Items grouped by Open Item Keys or one at a time.
Note: This manual reconciliation process does not have any impact on the Actuals Ledger. This process is simply for tracking and internal reporting of open and closed Open Item
Account balances, for example employee travel advances. If an item is not closed in the Open Item Reconciliation Process, because there is no journalized offset or if it falls outside the
tolerance amounts, they can be manually reconciled under Open Item>>Maintenance.

                                                                                      Journal Data
                                     Line #
                                      and       Ledger               ADB        Reverse     Reverse                                                                    Open
  BU        Jrnl ID     JrnlDate     Descr      Group Source Ref no. Date        Jrnl       Jrnl Dt      Fund         Acct        Dept      Program      Project     Item Key       Amount




                                  Script Description                                                                           Test Notes                                            Initials
    7     Navigate to: Item Listing report and verify the data Entry>>Create
          Run the Open General Ledger>>Journal>>Journalon the report is correct            See Special Instructions - Create/Update Jounral Online
          Journal Entries>>Add a New Value
          and complete


                                                                              Expected Results
Report shows Open Item Keys for Open Item Accounts with same status shown online and based on the steps in the script.




                 Overall Script Results                        GL Test Script Sign-Off
          Pass                    Re Test Pass
          Fail                    Re Test Fail                                                                                                               Date:




        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                    Last Revised on: 8/25/03
        Worksheet: GL14                                                                                                                                       Last Printed on: 7/19/2010
                                                                       SFS 8.8 GL TEST SCRIPT

Test Objective:    Batch process journals
Scenario: Create and Save Several Journals online.

                                                                                Journal Data
                                     Line #
                                      and       Ledger               ADB        Reverse    Reverse
  BU       Jrnl ID     JrnlDate      Descr      Group Source Ref no. Date        Jrnl      Jrnl Dt      Fund        Acct        Dept      Program        Project       Amount




                                   Script Description                                                                  Test Notes                                      Initials
    1     Navigate to: General Ledger>>Journals>>Journal Entry>>Create                    See Special Instructions tab -Create/Update Journal Online.
          Journal Entries>>Add a New Journal
    2     Add three journals with date for fiscal year 2005.
    3     Navigate to: General Ledger>>Journals>>Process Journals>>Edit
          Journals>>Select a Run Control
    4     Enter parameters/criteria for several journals. Check Edit, Post, Re-Edit,
          Mark to Post and Budget Check boxes. Click on Run.
    5     Select PS/GL Journal Edit. Click on Ok
    6     Click on Process Monitor. Once the process shows Success, Click on
          Details, Click on GLJEDERR, GLS7011, View Log/Trace, gls7011 to view
          report. Report should have no data because your journals had no errors.
    7     Navigate to: General Ledger>>Journals>>Journal Entry>>Create
          Journal Entries>>Find an Existing Journal
    8     Enter parameters/criteria to list the journals just posted
    9     Verify journals have a Posted Journal status and a Valid Budget Status

                                                                              Expected Results
Journal Status is P (Posted) and Budget Status is V (Valid)




               Overall Script Results                          GL Test Script Sign-Off
          Pass                  Re Test Pass
          Fail                  Re Test Fail                                                                                                                 Date:

 File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                     Last Revised on: 12/2/04
 Worksheet: GL15                                                                                                                                        Last Printed on: 7/19/2010
                                                                  9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:     Mark Journals for Unposting
Scenario: Enter data of journal you want to unpost. Verify Journal Header and Journal Lines pages show correct status and other data before unposting.




                                                                                   Journal Data
                                    Line #
                                     and       Ledger               ADB       Reverse    Reverse                                                                   Open
  BU       Jrnl ID     JrnlDate     Descr      Group Source Ref no. Date       Jrnl      Jrnl Dt      Fund        Acct        Dept      Program     Project      Item Key       Amount




                                  Script Description                                                                       Test Notes                                            Initials
   1     Navigate to: General Ledger>>Journals>>Process Journals>>Mark
         Journals for Unposting>>Add or Find an Existing Value
   2     Add a Journal with date for fiscal year xxxx.
   3     Select journals for unposting
   4     Click on Unpost Selected Journals to run process
   5     Verify journals are unposted in all tables

                                                                                 Expected Results
Status of original and unposted Journals are P and U.




              Overall Script Results                         GL Test Script Sign-Off
         Pass                  Re Test Pass
         Fail                  Re Test Fail                                                                                                              Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                 Last Revised on: 8/25/03
       Worksheet: GL16                                                                                                                                    Last Printed on: 7/19/2010
                                                                           SFS 8.8 GL TEST SCRIPT

Test Objective:     Posted Journal Summary Report (GLS7009)
Scenario: Enter data of journal you want to review. Journal Header and Journal Lines pages show correct status and other data.




                               Script Description                                                                           Test Notes                                           Initials
   1     Navigate to: General Ledger>>Journals>>Process Journals>>Posted
         Journal Summary Report>>Add or Find an Existing Run Control

   2     Specify parameters on the Run Control page. Begin/End Process are required.      You will need the instance number for the journal you want to review or you can
         Select how you want data summarized, Journal ID or Chartfield. If you select     enter 1 and 999999999 and use date criteria and User ID to select data. You can
         Chartfield, then click the 'Refresh' button so you can select data elements to   also specify Ledger Group and Ledger if you prefer to restrict output to ACTUALS
         display/summarize by.                                                            vs STD_BUDGET.

   3     Click Run. Set Server as PSUNX and Click OK. Click on Process
         Monitor. Once the process shows Success, Click on Details, Click on View
         Log/Trace, Click on the GLS7009 PDF File
   4     View Report and verify data




                                                                                  Expected Results
Report is generated for review and data matches journals posted.




              Overall Script Results                          GL Test Script Sign-Off
         Pass                  Re Test Pass
         Fail                  Re Test Fail                                                                                                             Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                Last Revised on: 05/20/05
       Worksheet: GL17                                                                                                                                    Last Printed on: 7/19/2010
                                                                       SFS 8.8 GL TEST SCRIPT

Test Objective:    Suspended Activity Report
Scenario: Run Suspended Activity Report to view detailed information on suspended journals.




                                    Script Description                                                                  Test Notes                                     Initials
    1     Navigate to: General Ledger>>Journals>>Suspense
          Correction>>Suspensed Activity Report>>Add or Find and Existing
          Value
    2     Select a range of journal dates.                                                More specific criteria will narrow the scope of the search, and also the
                                                                                          results.
    3     Click on Process Monitor. Once the process shows Success, Click on
          Details, Click on View Log/Trace, Click on gls7515 to view and print report.

                                                                                Expected Results
Review list of all journal activities that are suspended. Take appropriate action.




                 Overall Script Results                        GL Test Script Sign-Off
          Pass                    Re Test Pass
          Fail                    Re Test Fail                                                                                                               Date:




 File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                    Last Revised on: 10/21/04
 Worksheet: GL18                                                                                                                                        Last Printed on: 7/19/2010
                                                                         SFS 8.8 GL TEST SCRIPT

Test Objective:      Correct Suspense Entries
Scenario: Create a journal to correct/reverse the suspense lines on a posted suspense journal.
Dependencies: Journal with suspense lines most be created and posted.


                                                                                 Journal Data
                                     Line #
                                      and       Ledger               ADB         Reverse     Reverse
  BU       Jrnl ID     JrnlDate      Descr      Group Source Ref no. Date         Jrnl       Jrnl Dt      Fund         Acct        Dept     Program    Project       Amount




                                   Script Description                                                                     Test Notes                                 Initials
    1     Navigate to: General Ledger>>Journals>>Suspense Correction>>Correct
          Suspense Entries
    2     Enter the Business Unit; additional information is optional. Click on Search
          and select the suspense journal you want to correct
    3     Click on the hyperlink Go to Journal Entry/Suspense to review the original
          suspense journal to verify correction lines are correct..
    4     Correct and save the journal. Note the journal now has a Journal ID .
    5     Click on the hyperlink Go to Journal Entry/Correction which takes you to the
          Journal entry page. Finalize and edit and post the correction/reversal journal.

    6     Run queries to validate journal posted correctly to all journal and KK            See Special Instructions - Validation Queries
          tables.
    7     Verify correction journal is reversed/corrected correctly.

    8     Verify journal status of online correction/reversal journal is P.


                                                                               Expected Results
Journal posted in step #4 reverses and corrects the suspense line.


               Overall Script Results                            GL Test Script Sign-Off
          Pass                  Re Test Pass
          Fail                  Re Test Fail                                                                                                               Date:



 File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                  Last Revised on: 10/21/04
 Worksheet: GL19                                                                                                                                      Last Printed on: 7/19/2010
                                                                  9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Review Suspense Cross Reference
Scenario: Run report to view suspensed journals with corresponding corrections journal




                                                                                    Journal Data
                                    Line #
                                     and       Ledger               ADB       Reverse    Reverse                                                       Open
  BU       Jrnl ID     JrnlDate     Descr      Group Source Ref no. Date       Jrnl      Jrnl Dt     Fund   Acct     Dept       Program   Project    Item Key       Amount




                                  Script Description                                                               Test Notes                                        Initials
   1     Navigate to: General Ledger>>Journals>>Suspense
         Correction>>Suspense Cross Ref Report
   2     Add a Journal with date for fiscal year xxxx.
   3     Click on the flashlight.
   4     Click on the hyperlinks Journal Status and Suspense Journals Status to review
         and verify the correction transactions have corrected/reversed the suspended
         transactions.

                                                                                  Expected Results
Suspense Journal corrections are correct




              Overall Script Results                         GL Test Script Sign-Off
         Pass                  Re Test Pass
         Fail                  Re Test Fail                                                                                                  Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                     Last Revised on: 8/25/03
       Worksheet: GL20                                                                                                                        Last Printed on: 7/19/2010
                                                                  9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:     Ledger Inquiry/Drilldown
Scenario: Inquire on a ledger by: chartfield and period of a valid account.
Click on the View Ledger Summary Magnifying Glass Icon. Click the return to Inquiry Icon and then Click on the View Ledger Detail Magnifying Glass Icon.




                                  Script Description                                                                     Test Notes                                          Initials
   1     Navigate to: General Ledger>>Review Financial Information>>Ledger
         Select "Add a New Value" and create an Inquiry Name of LEDGER_INQ ,
         then hit the ADD button.
   2     Your BU should default in. Select a Ledger, Year and Period
         Currency should be USD
   3     Select hyperlink Sum by Period, Account.
         Drilldown to next level of data.
   4     Repeat #2-#3 for various inquiries and drilldowns.


                                                                                 Expected Results
For each GL or subsystem inquiry you are able to drilldown to the source pages and information.




              Overall Script Results                          GL Test Script Sign-Off
         Pass                  Re Test Pass
         Fail                  Re Test Fail                                                                                                          Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                             Last Revised on: 5/20/05
       Worksheet: GL21                                                                                                                                Last Printed on: 7/19/2010
                                                                    9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:     Journal Inquire/Drilldown
Scenario: Journal Inquire: Enter the Journal criteria on the Journal Criteria page. Inquire on a Journal by ID. Click on the Flashlight Icon for the detail.




                                 Script Description                                                                            Test Notes                                              Initials
    1     Navigate to: General Ledger>>Review Financial Information>>Journal
          Select "Add a New Value" and create an Inquiry Name of JRNL_INQ , then
          hit the ADD button.
    2     Your BU should default in. Enter criteria for a Journal with date in fiscal
          year=2005, Period= your choice. Hit the search button.
    3     Drilldown to Jrnl Header and Lines. Click on Journal ID hyperlink.

    4     Repeat #2-#3 for various inquiries and drilldowns
    5     Run Queries to validate data                                                     Run UW_88_GL_JOURNAL, at the prompt enter your BU, Journal ID and Journal
                                                                                           Date

                                                                                  Expected Results
For each GL or subsystem journal you are able to drilldown to the source pages and information.




                 Overall Script Results                        GL Test Script Sign-Off
          Pass                    Re Test Pass
          Fail                    Re Test Fail                                                                                                                 Date:




        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                      Last Revised on: 5/20/05
        Worksheet: GL22                                                                                                                                         Last Printed on: 7/19/2010
                                                                 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Ledger Group Drilldown
Scenario: Ledger Group Drilldown using various criteria




                                    Script Description                                                                  Test Notes                              Initials
   1     Navigate to: General Ledger>>Review Financial Information>>Ledger             Basically gives the same data as found in GL21
         Group
   2     Enter criteria to find a Journal in Period=1 for fiscal year 2004.
   3     Select Search button
   4     Drilldown to Journal Line
   5     Repeat #2-#4 for various inquiries and drilldowns


                                                                                  Expected Results
For each GL or subsystem journal you are able to drilldown to the source pages and information.




              Overall Script Results                         GL Test Script Sign-Off
         Pass                  Re Test Pass
         Fail                  Re Test Fail                                                                                             Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                Last Revised on: 5/20/05
       Worksheet: GL23                                                                                                                   Last Printed on: 7/19/2010
                                                                              UW 8.8 - Gl Test Scripts.xls
Test Objective:    Ledger Period Comparison
Scenario: Ledger Period Comparison using various criteria




                                    Script Description                                                                           Test Notes                       Initials
    1     Navigate to: General Ledger>>Review Financial Information>>Ledger                  COULD NOT ACCESS
          Period Comparison
    2     Enter BU, Ledger=ACTUALS, Year=2004, Currency=USD and criteria to
          search for transactions in a DeptID for periods = 1 thru 6.
    3     Select Search button
    4     Select tabs to view period groups or select button to view all periods requested
          at once.
    5     Highlight the output with your cursor and copy the data(CTRL-C). Paste the
          copied data into an Excel spreadsheet for analysis. Note: You may have to do
          multiple copies if you have more than 25 lines of data returned.
    6     Run Queries to validate data                                                       See Special Instructions - Validation Queries


                                                                                       Expected Results
For selected criteria, you are able to produce comparative reporting data by period.




               Overall Script Results                          GL Test Script Sign-Off
          Pass                  Re Test Pass
          Fail                  Re Test Fail                                                                                                    Date:




   File Name:9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                         Last revised on: 12/15/2004
   Worksheet: GL23a                                                                                                                            Last Printed on: 7/19/2010
                                                                 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Compare Across Ledgers
Scenario: Inquire on Ledger for Comparison, i.e., Actuals to Budget.




                                                                                 Journal Data

                                  Script Description                                                      Test Notes                                         Initials
   1     Navigate to: General Ledger>>Review Financial Information>>Compare nVision Budget Summary Reports provide the same information in a more
         Across Ledgers                                                     usable format.
   2     Enter Criteria for Ledger Comparison inquiry.
   3     Scroll down to view data retrieved at bottom of page.
   4     Repeat #2-#3 for various inquiries and drilldowns
   5     Run Queries to validate data


                                                                               Expected Results
Ledger Data will appear in 2 columns with a variance.




              Overall Script Results                         GL Test Script Sign-Off
         Pass                  Re Test Pass
         Fail                  Re Test Fail                                                                                          Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                             Last Revised on: 5/20/05
       Worksheet: GL24                                                                                                                Last Printed on: 7/19/2010
                                                                    SFS 8.8 GL TEST SCRIPT

Test Objective:    Detail Ledger Summary Report
Scenario: Run the General Ledger Summary Report to retrieve a summary of each detail ledger definition.




                                     Script Description                                                         Test Notes                   Initials
    1     Navigate to: General Ledger>>General Reports>> Ledger Summary                     TEST SCRIPT DELETED
          >>Add or Find an Existing Value
    2     Enter parameter/criteria for report request. If you desire more detail than line,
          description, reference, currency, debits and credits; Click Refresh and then
          select additional fields for output data. Click Run. Verify that server =
          PSUNX. Click OK.
    3     Click on Process Monitor. Once the process shows Success, Click on
          Details, Click on View Log/Trace, Click on the GLS7003 PDF File
    4     Navigate to: Reporting Tools>> Query>> Query Manager>> Find an
          existing Query. Select UW_88_DETAIL_LEDGER_DATA. Run report.
          Data should match the journal detail report.

                                                                          Expected Results
Report should be created with information requested


                 Overall Script Results                     GL Test Script Sign-Off
          Pass                    Re Test Pass
          Fail                    Re Test Fail                                                                                    Date:




 File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                               Last revised: 5/20/05
 Worksheet: GL25                                                                                                             Last Printed on: 7/19/2010
                                                                             9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:     General Ledger Activity Report
Scenario: Run the General Ledger Activity Report with various account balances with selected combination of chartfields entry details. Run report using various parameter/criteria scenarios.




                                       Script Description                                                                                        Test Notes                                            Initials
   1     Navigate to: General Ledger>>General Reports>>General Ledger Activity>>Add or Find an
         Existing Value
   2     Enter parameter/criteria for report request. Be sure to check All Values. Click Run. Verify that
         server = PSUNX. Click OK.
   3     Click on Process Monitor. Once the process shows Success, Click on Details, Click on View
         Log/Trace, Click on the GLS7002 PDF File
   4     Navigate to: Reporting Tools>> Query>> Query Manager>> Find an existing Query. Select
         UW_88_DETAIL_LEDGER_DATA. Run report. Data should match the journal detail report.

                                                                                             Expected Results
Report should be created with information requested


                  Overall Script Results                                 GL Test Script Sign-Off
         Pass                     Re Test Pass
         Fail                     Re Test Fail                                                                                                                                Date:




         File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                                Last Revised on: 12/14/2004
         Worksheet: GL26                                                                                                                                                      Last Printed on: 7/19/2010
                                                                    9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:     Journal Line/Accounting Reconciliation Report
Scenario: Run the Journal Line/Accounting Reconciliation Report verify there are no differences between GL and AP




                               Script Description                                                                              Test Notes                                         Initials
   1     Navigate to: General Ledger>>General Reports>>Journal Line/Acctg                    Check with Tina to see if we already have a query which handles this.
         Reconcile>>Add or Find an Existing Value

   2     Enter parameter/criteria for report request. If you desire more detail than line,
         description, reference, currency, debits and credits; Click Refresh and then
         select additional fields for output data. Click Run. Verify that server =
         PSUNX. Click OK.
   3     Click on Process Monitor. Once the process shows Success, Click on
         Details, Click on View Log/Trace, Click on the GLS8012 PDF File
   4     Run Queries to validate data



                                                                                    Expected Results
Report should be created indicating differences or "no differences". (Queries not recommended as the data is not easily identifiable.)


                Overall Script Results                          GL Test Script Sign-Off
         Pass                    Re Test Pass
         Fail                    Re Test Fail                                                                                                             Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                  Last Revised on: 8/25/03
       Worksheet: GL27                                                                                                                                     Last Printed on: 7/19/2010
                                                                    9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:     Journal Entry Detail
Scenario: Run the Journal Entry Detail Report listing journal entry details. Run report using various parameter/criteria scenarios.


                                                                                       Journal Data

                                    Script Description                                                                         Test Notes                           Initials
   1     Navigate to: General Ledger>>General Reports>>Journal Entry Detail
         Report>>Add or Find an Existing Value
   2     Enter parameter/criteria for report request. If you desire more detail than line,
         description, reference, currency, debits and credits; Click Refresh and then
         select additional fields for output data. Click Run. Verify that server =
         PSUNX. Click OK.
   3     Click on Process Monitor. Once the process shows Success, Click on
         Details, Click on View Log/Trace, Click on the FIN2001 PDF File
   5     Navigate to: Reporting Tools>> Query>> Query Manager>> Find an
         existing Query. Select UW_88_GL_Journals. Run report. Data should match
         the journal detail report.


                                                                                     Expected Results
Report should be created with information requested


                Overall Script Results                          GL Test Script Sign-Off
         Pass                    Re Test Pass
         Fail                    Re Test Fail                                                                                               Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                  Last Revised on: 12/7/2004
       Worksheet: GL28                                                                                                                       Last Printed on: 7/19/2010
                                                                    9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Ledger vs. Journal Integrity Report
Scenario: Run the Ledger vs. Journal Integrity Report to list any discrepancies between Ledger and Journal tables.




                                    Script Description                                                                         Test Notes                             Initials
    1     Navigate to: General Ledger>>General Reports>>Ledger vs. Journal                 DELETE-UWSA will review monthly via queries.
          Integrity Report>>Add or Find an Existing Value
    2     Enter parameter/criteria for report request.
    3     Add a Journal with date for fiscal year xxxx. Edit/BCM. Do not post. Run
          Report.
    4     Any differences noted on the report should be researched and corrected.
    5     Run Queries to validate data                                                     See Special Instruction tab - Validation Queries

                                                                                    Expected Results
Report will indicate whether there are any differences between the posted ledger transactions and the journal line and header transactions.


                 Overall Script Results                        GL Test Script Sign-Off
          Pass                    Re Test Pass
          Fail                    Re Test Fail                                                                                                Date:




        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                     Last Revised on: 8/25/03
        Worksheet: GL29                                                                                                                        Last Printed on: 7/19/2010
                                                                   9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:     Standard Journal Report.
Scenario: Run the Standard Journal Report defined for a Ledger and Business Unit.




                                   Script Description                                                         Test Notes                           Initials
   1     Navigate to: General Ledger>>General Reports>>Standard
         Journals>>Add or Find an Existing Value
   2     Enter parameter/criteria for report request.

   3     Enter parameter/criteria for report request. Be sure to check All Values. Click
         Run. Verify that server = PSUNX. Click OK.
   4     Click on Process Monitor. Once the process shows Success, Click on
         Details, Click on View Log/Trace, Click on the GLS7001 PDF File


                                                                                   Expected Results
Report should be created with information requested and match the query data


                Overall Script Results                        GL Test Script Sign-Off
         Pass                    Re Test Pass
         Fail                    Re Test Fail                                                                              Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                   Last Revised on: 5/20/05
       Worksheet: GL30                                                                                                      Last Printed on: 7/19/2010
                                                                  9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Trial Balance Report .
Scenario: Run the Trial Balance Report.


                                                                                  Journal Data

                                   Script Description                                                        Test Notes                           Initials
   1     Navigate to: General Ledger>>General Reports>>Trial Balance >>Add
         or Find an Existing Value
   2     Enter parameter/criteria for report request.
   3     Click on Process Monitor. Once the process shows Success, Click on
         Details, Click on View Log/Trace, Click on the GLS7012 PDF File


                                                                                Expected Results
A Trial Balance Report should be created with parameters/criteria requested.


                Overall Script Results                        GL Test Script Sign-Off
         Pass                    Re Test Pass
         Fail                    Re Test Fail                                                                             Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                  Last Revised on: 5/20/05
       Worksheet: GL31                                                                                                     Last Printed on: 7/19/2010
                                                                    9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:   Monthly Average Balances
Scenario: Run Monthly Average Balances with Calculation Log selected. . Run query to verify data correctly posted to ADB tables. Verify Calculation is correct.




                               Script Description                                                                         Test Notes                                           Initials
   1     Navigate to: General Ledger>>Journals>>Processing Journals>>Process
         Posting>>Add or Find an Existing Value
   2     At the Run Journal Post run control page:
         Click on Always
         Enter a Description, Business Unit, Ledger Group and a date range you want
         daily balances posted based on the journal data in the Actuals Ledger.
         Click on Skip Open Item Reconciliation and Skip Summary Ledger Update
         Click on Save
         Click on Run

   3     At the Process Scheduler Request page,
         Select Server PSUNX
         Check the box next to PS/GL Post Daily Balances (GL_ADB_POST).
         Click on OK
         Back at the Run Journal Post page, Click on the Process monitor
         When status is success, verify the job processed successfully.
         Run a Query on Ledger_ADB table to verify the updates were made today.
   4     Navigate to: General Ledger>>Average Daily Balance>>ADB
         Process>>Add or Find an Existing Value
   5     Enter parameter/criteria for report request.




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                               Last Revised on: 8/25/03
       Worksheet: GL32                                                                                                                                  Last Printed on: 7/19/2010
                                                                  9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:   Monthly Average Balances
Scenario: Run Monthly Average Balances with Calculation Log selected. . Run query to verify data correctly posted to ADB tables. Verify Calculation is correct.




                                     Script Description                                                                       Test Notes                                       Initials
   6      Click on to: General to go to the Process Scheduler page .
          Navigatethe Run buttonLedger>>Journals>>Processing Journals>>Process
          Posting>>Add or Find page select PSNT
          At the Process Scheduleran Existing Value for all Crystal Reports and
          PSUNX for all other processes or reports.
          Click on OK.
          Back at the Run Control Request page, click on the Process Monitor until the
          process status is Success.
          Click on Detail hyperlink.
          Click on Message hyperllink to verify process completed successfully or if in
          error, why it ended in error.
          If it is a PDF report, click on View Trace/Log.
          Click on Message to view additional messages about the process results.
          Click on the PDF file to view the report.
          Print the report using the print icon

   7      Run ADB queries to verify ADB tables were populated                             See Special Instruction tab - Validation Queries
   8      Navigate to: General Ledger>>Average Daily Balance>>ADB
          Calculation Report>>Add or Find an Existing Value
   9      Enter parameter/criteria for report request.
   10     Click on the Run button to go to the Process Scheduler page .
          At the Process Scheduler page select PSNT for all Crystal Reports and
          PSUNX for all other processes or reports.
          Click on OK.
          Back at the Run Control Request page, click on the Process Monitor until the
          process status is Success.
          Click on Detail hyperlink.
          Click on Message hyperlink to verify process completed successfully or if in
          error, why it ended in error.
          If it is a PDF report, click on View Trace/Log.
          Click on Message to view additional messages about the process results.
   11     Click on the PDF file to view the report.
          Print the report using the print icon


        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                              Last Revised on: 8/25/03
        Worksheet: GL32                                                                                                                                 Last Printed on: 7/19/2010
                                                                 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:   Monthly Average Balances
Scenario: Run Monthly Average Balances with Calculation Log selected. . Run query to verify data correctly posted to ADB tables. Verify Calculation is correct.




                                  Script Description                                                                      Test Notes                                           Initials
         Navigate to: General Ledger>>Journals>>Processing Journals>>Process     Expected Results
         Posting>>Add or Find an Existing Value
Data correctly posted to ADB tables correctly and ADB Calculation Log is correct


                Overall Script Results                       GL Test Script Sign-Off
         Pass                    Re Test Pass
         Fail                    Re Test Fail                                                                                                         Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                               Last Revised on: 8/25/03
       Worksheet: GL32                                                                                                                                  Last Printed on: 7/19/2010
                                                                   9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    GL Close process
Scenario: Run Close Trial balance before and after the Close process is run. Verify data rolled forward correctly, based on Closing rules setup and queries.
Note: ChartField Value Sets and Closing rules have already been set up. Feel Free to review them for completeness.




                                    Script Description                                                                       Test Notes                                               Initials
   1     Navigate to: General Ledger>>Close Ledgers>>Closing Trial
         Balance>>Add or Find an Existing Value
   2     Click on the Run button to go to the Process Scheduler page .
         At the Process Scheduler page select PSNT for all Crystal Reports and
         PSUNX for all other processes or reports.
         Click on OK.
         Back at the Run Control Request page, click on the Process Monitor until the
         process status is Success.
         Click on Detail hyperlink.
         Click on Message hyperllink to verify process completed successfully or if in
         error, why it ended in error.
         If it is a PDF report, click on View Trace/Log.
         Click on Message to view additional messages about the process results.
         Click on the PDF file to view the report.
   3     Review data on reports. Print a report for use later.

   4     Navigate to: General Ledger>>Request Ledger Close>>Add or Find an
         Existing Value




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                      Last Revised on: 8/25/03
       Worksheet: GL33                                                                                                                                         Last Printed on: 7/19/2010
                                                                   9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    GL Close process
Scenario: Run Close Trial balance before and after the Close process is run. Verify data rolled forward correctly, based on Closing rules setup and queries.
Note: ChartField Value Sets and Closing rules have already been set up. Feel Free to review them for completeness.




                                    Script Description                                                                       Test Notes                                               Initials
   5     Navigate to: General Ledger>>Close Ledgers>>Closing Trial
         Enter parameter/criteria for Close request.
         Balance>>Add or Find an Existing Value
         Under Process Request Parameters section:
         -Process Frequency=Always
         -Close Request Type=Close
         -Fiscal Year=xxxx
         -Business Unit Prompting=xxxxx
         -Check only, Do not Process=leave box unchecked
         -Closing Rule=YE200x
         -Ledger Grp=Actuals
         -Ledger=Blank
         Under Closing Date Option section:
         -click on radio button for As of Date
         -Specify=06/30/20xx
         Under Selections section:
         -Click on radio button for Selected Detail Values
         Under Business Unit to Close section:
         -Select Value=xxxxx
   6     Click on the Run button to go to the Process Scheduler page .
         At the Process Scheduler page select PSUNX for all other processes other than
         Crystal reports.
         Click on OK.
         Back at the Run Control Request page, click on the Process Monitor until the
         process status is Success.
         Click on Detail hyperlink.
         Click on Message hyperllink to verify process completed successfully or if in
         error, why it ended in error.
         If it is a PDF report, click on View Trace/Log.
         Click on Message to view additional messages about the process results.
         Click on the PDF file to view the report.
   7     Print and review report.

   8     Navigate to: General Ledger>>Close Ledgers>>Closing Trial
         Balance>>Add or Find an Existing Value

       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                      Last Revised on: 8/25/03
       Worksheet: GL33                                                                                                                                         Last Printed on: 7/19/2010
                                                                   9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    GL Close process
Scenario: Run Close Trial balance before and after the Close process is run. Verify data rolled forward correctly, based on Closing rules setup and queries.
Note: ChartField Value Sets and Closing rules have already been set up. Feel Free to review them for completeness.




                                    Script Description                                                                       Test Notes                                               Initials
   9      Navigate to: General Ledger>>Close Ledgers>>Closing Trial
          Enter parameter/criteria for report request:
          Balance>>Add or Find an Existing Value
          Unit=xxxxx
          Ledger=ACTUALS
          Fiscal Year=xxxx

   10     Click on the Run button to go to the Process Scheduler page .
          At the Process Scheduler page select PSUNX for all processes other than
          Crystlal reports.
          Click on OK.
          Back at the Run Control Request page, click on the Process Monitor until the
          process status is Success.
          Click on Detail hyperlink.
          Click on Message hyperlink to verify process completed successfully or if in
          error, why it ended in error.
          If it is a PDF report, click on View Trace/Log.
          Click on Message to view additional messages about the process results.
          Click on the PDF file to view the report.
          Print the report using the print icon
   11     To View Close Rules:
          Navigate to: General Ledger>>Close Ledgers>>Closing Rules
          To View ChartField Value Sets included in Close Rules:
          Navigate to: Set Up Financials/Supply Chain>>Common
          Definitions>>Design Chartfields>>ChartField Value Sets




        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                     Last Revised on: 8/25/03
        Worksheet: GL33                                                                                                                                        Last Printed on: 7/19/2010
                                                                   9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    GL Close process
Scenario: Run Close Trial balance before and after the Close process is run. Verify data rolled forward correctly, based on Closing rules setup and queries.
Note: ChartField Value Sets and Closing rules have already been set up. Feel Free to review them for completeness.




                                  Script Description                                                                         Test Notes                                               Initials
   12     Navigate to: Generalshows account balances were rolled forward from
          Verify data on reports Ledger>>Close Ledgers>>Closing Trial
          Balance>>Add or 0 of an Existing according to the Close Rules.
          Period 12 to PeriodFind the next year Value


                                                                                   Expected Results
Report generated correct data and FY rolled forward correctly to Period 0 of the next FY




               Overall Script Results                         GL Test Script Sign-Off
          Pass                  Re Test Pass
          Fail                  Re Test Fail                                                                                                              Date:




        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                     Last Revised on: 8/25/03
        Worksheet: GL33                                                                                                                                        Last Printed on: 7/19/2010
                                                                    9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:     Copy Type Allocation.
Scenario: Process a Copy Type Allocation (Use your campus IDC or FB Allocation) . Run an Allocation Request. Verify Journal was created and posted and is correct and
complete. Verify data updated correct tables with correct data.
Dependencies: Verify that the GL includes chartfield data used in the allocation. You may need to create journals for this test.

                                   Script Description                                                                 Test Notes                                           Initials
   1      Navigate to: Allocations>>Define and Perform Allocations>>Define
          Allocation Step>>Find an Existing Value or Add
          SetID=UWXXX
          Process Step=Select your campus IDC or FB Allocation (they should have
          been copied from production).
          Review setup on each tab.
          Use this information to verify results after the Copy Allocation and the
          Allocation Log have been run.
   2      Navigate to: Allocations>>Define and Perform Allocations>>Request
          Allocation>>Find Exisitng Value (Run Control ID)
   3      Enter data for an Allocation Request for a Copy Type Allocation.
          Running this request will generate an allocation journal.
   4      Click on the Run button.
          Verify that PSUNX is the seletced server.
          Click on OK.
   5      Click on Process Monitor. Once the process shows success you can view the
          journals which were created. Make note of the Process Instance for use in step
          11 below.
   6      Navigate to: General Ledger >>Journals>>Journal Entry>>Create
          Journal Entries >>Find an Existing Value
   7      To view the Copy Allocation Journal just created, enter the Business Unit of
          the allocation journal,the appropriate Journal ID field, and the journal date,
          and click on Search.
   8      Double click on the Allocation Journal ID to open the journal.
   9      Edit and Post the Copy Type Allocation Journal
   9      Print to review and compare journal to the Calculation Log printed in
          Step #12.
   10     Navigate to: Allocations>>Reports>>Allocation Calculation Logs>>Add
          a New Value (Run Control ID) for this report



        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                       Last Revised on: 12/10/2004
        Worksheet: GL34                                                                                                                             Last Printed on: 7/19/2010
                                                                  9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:     Copy Type Allocation.
Scenario: Process a Copy Type Allocation (Use your campus IDC or FB Allocation) . Run an Allocation Request. Verify Journal was created and posted and is correct and
complete. Verify data updated correct tables with correct data.
Dependencies: Verify that the GL includes chartfield data used in the allocation. You may need to create journals for this test.

                                    Script Description                                                                      Test Notes                                           Initials
   11     Navigate to: Allocations>>Define and Perform Allocations>>Define
          At the Calculation Log page, enter:
          Allocation Step>>Find an Existing Value or Add
          SetID=XXXXX
          SetID=UWXXX had run
          Allocation Step you
          Process Step=Select your campus IDC or FB Allocation (they should have
                   Instance= (see Step #5)
          been copied from production).
          Click on the Refresh button
          Check Fund and each tab.
          Review setup on Account
   12     Use this information toprocessing thisafter the Copy Allocation and the
          Click on Run to begin verify results report request                            Report did not appear in Process Monitor or in the Report Manager.
          Allocation LogScheduler page select PSUNX.
          At the Process have been run.
          Click on OK.
          Click on the Process Monitor when the process status is Success, Click on
          Detail.
          Click on View Trace/Log.
          Click on GL6002 to view report.
          Print the report using the print icon
   13     The Calculation Log report data should match the Pool and Target chartfields Ledger=Actuals
          and the chartfields and amounts should match the allocation journal printed in
          Step #12

                                                                                   Expected Results
The Allocation Journal was successfully created, posted and matches with the Calculation Log Report chartfields and amounts.
The chartfields in the Pool and Target match and reconcile to the Allocation Journal and the Calculation Log Report.


               Overall Script Results                         GL Test Script Sign-Off
          Pass                  Re Test Pass
          Fail                  Re Test Fail                                                                                                            Date:




        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                             Last Revised on: 12/10/2004
        Worksheet: GL34                                                                                                                                   Last Printed on: 7/19/2010
                                                                   9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Copy Type Allocation.
Scenario: Create a Copy Type Allocation. Run the Allocation Request. Verify Journal was created and posted and is correct and complete. Verify data updated correct tables with
correct data.
Dependencies: Verify that the GL includes chartfield data used in the allocation. You may need to create journals for this test.

                                 Script Description                                                                            Test Notes                                             Initials
   1     Navigate to: Allocations>>Define and Perform Allocations>>Define                 Create a second Step which creates the Cash side of the allocation, this is similar to
         Allocation Step>>Add a new value                                                 what you have created for your fringes or IDC alloactions in production. Name it
         SetID=UWXXX                                                                      TESTALLOC$. You can Copy TESTALLOC, and make the required changes to
         Process Step=TESTALLOC                                                           provide the cash lines.                                    Make sure to name your
         Review setup on each tab and enter required data. Save the Allocation Step.      journal mask something other than one you already use in your other allocations.

   2     Navigate to: Allocations>>Define and Perform Allocations>>Define
         Allocation Group>>Add a new value
   3     SetID=UWXXX
         Allocation Group=TESTALLOC
         Attach the TESTALLOC and TESTALLOC$ Step to the Group and Save.
   4     Navigate to: Allocations>>Define and Perform Allocations>>Request
         Allocation>>Add a new value
         Enter a Run Control Id of TESTALLOC and Save.
         Enter the required information on the Allocation Request panel and Save.
         Click on the Run button.
         Verify that PSUNX is the seletced server.
         Click on OK.
   5     Click on Process Monitor. Once the process shows success you can view the
         journals which were created. Make note of the Process Instance for use in step
         11 below.
   6     Navigate to: General Ledger >>Journals>>Journal Entry>>Create
         Journal Entries >>Find an Existing Value
   7     To view the Copy Allocation Journal just created, enter the Business Unit of
         the allocation journal,the appropriate Journal ID field, and the journal date,
         and click on Search.
   8     Double click on the Allocation Journal ID to open the journal.
   9     Edit and Post the Journal that was created.
   9     Print to review and compare journal to the Calculation Log printed in
         Step #12.


       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                   Last Revised on: 12/10/2004
       Worksheet: GL34a                                                                                                                                        Last Printed on: 7/19/2010
                                                                   9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Copy Type Allocation.
Scenario: Create a Copy Type Allocation. Run the Allocation Request. Verify Journal was created and posted and is correct and complete. Verify data updated correct tables with
correct data.
Dependencies: Verify that the GL includes chartfield data used in the allocation. You may need to create journals for this test.

                                   Script Description                                                                           Test Notes                                             Initials
   10                    Allocations>>Define and Perform Calculation Logs>>Add
          Navigate to: Allocations>>Reports>>AllocationAllocations>>Define                 Create a second Step which creates the Cash side of the allocation, this is similar to
          Allocation Step>>Add a new value
          a New Value (Run Control ID) for this report                                     what you have created for your fringes or IDC alloactions in production. Name it
          SetID=UWXXX                                                                      TESTALLOC$. You can Copy TESTALLOC, and make the required changes to
   11     At the Calculation Log page, enter:
          Process Step=TESTALLOC                                                           provide the cash lines.                                    Make sure to name your
          SetID=XXXXX
          Review setup on each tab and enter required data. Save the Allocation Step.      journal mask something other than one you already use in your other allocations.
          Allocation Step you had run
          Process Instance= (see Step #5)
          Click on the Refresh button
          Check Fund and Account
   12     Click on Run to begin processing this report request                             Report did not appear in Process Monitor or in the Report Manager.
          At the Process Scheduler page select PSUNX.
          Click on OK.
          Click on the Process Monitor when the process status is Success, Click on
          Detail.
          Click on View Trace/Log.
          Click on GL6002 to view report.
          Print
   13     The Calculation Log report data should match the Pool and Target chartfields     Ledger=Actuals
          and the chartfields and amounts should match the allocation journal printed in
          Step #12

                                                                                   Expected Results
The Allocation Journal was successfully created, posted and matches with the Calculation Log Report chartfields and amounts.
The chartfields in the Pool and Target match and reconcile to the Allocation Journal and the Calculation Log Report.


               Overall Script Results                          GL Test Script Sign-Off
          Pass                  Re Test Pass
          Fail                  Re Test Fail                                                                                                                  Date:




        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                   Last Revised on: 12/10/2004
        Worksheet: GL34a                                                                                                                                        Last Printed on: 7/19/2010
                                                                     9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:     Process a multi-step Copy Allocation.
Scenario: Process a Multi-step Copy Allocation. (Note: if the allocation you ran for GL34 contained multi-steps it is not necessary to run the test script GL35.) Set up Allocation
Request. Verify data on allocation journal is correct before and after posting.
Dependencies: Verify that the GL includes chartfield data used in the allocation. You may need to create journals for this test.


                                  Script Description                                                                           Test Notes                                            Initials
    1     Navigate to: Allocations>>Define and Perform Allocations>>Define
          Allocation Group>>Find an Existing Value
          SetID=UWXXX
          Allocation Step =Select your campus IDC or FB Allocation (they should have
          been copied from production).
          Review steps.
    2     Navigate to: Allocations>>Define and Perform Allocations>>Define
          Allocation Group>>Find an Existing Value
          SetID=UWXXX
          Allocation Group=Select your campus IDC or FB Allocation (they should have
          been copied from production).
          Select As of Date.
    3     Click on the Run button.
          Verify that PSUNX is the seletced server.
          Click on OK.
    4     Click on Process Monitor. Once the process shows success you can view the
          journals which were created. Make note of the Process Instance for use in step
          11 below.
    5     Navigate to: General Ledger>>Journals>>Journal Entry>>Create
          Journal Entries >>Find an Existing Value
    6     To view the Copy Allocation Journal just created, enter the Business Unit of
          the allocation journal, enter the Journal ID field, and the date , and click on
          Search.
    7     Select and double click on the Allocation Journal ID to open the journal you
          have just created.
    8     Edit and Post the Multi-step Copy Type Allocation Journal
    9     Print to review and compare journal to the Calculation Log printed in
          Step #16.
   10     Navigate to: Allocations>>Reports>>Allocation Calculation Logs>>Add
          a New Value (Run Control ID) for this report


        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                 Last Revised on: 12/14/2004
        Worksheet: GL35                                                                                                                                       Last Printed on: 7/19/2010
                                                                    9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:     Process a multi-step Copy Allocation.
Scenario: Process a Multi-step Copy Allocation. (Note: if the allocation you ran for GL34 contained multi-steps it is not necessary to run the test script GL35.) Set up Allocation
Request. Verify data on allocation journal is correct before and after posting.
Dependencies: Verify that the GL includes chartfield data used in the allocation. You may need to create journals for this test.


                                     Script Description                                                                        Test Notes                                            Initials
   11     Navigate to: Allocations>>Define and Perform Allocations>>Define
          At the Calculation Log page, enter:
          Allocation Group>>Find an Existing Value
          SetID=XXXXX
          SetID=UWXXX of your Process Step
          Process Step=Name
          Process Instance= (see your campus IDC or FB Allocation (they should have
          Allocation Step =SelectStep #4)
          been copied from production).
          Click on the Refresh button
          Review steps. Account
          Check Fund and
          Save
   12     Click on Run to begin processing this report request
          At the Process Scheduler page select PSUNX .
          Click on OK.
          Click on the Process Monitor when the process status is Success, Click on
          Detail.
          Click on Message hyperlink to verify process completed successfully or if in
          error, why it ended in error.
          If it is a PDF report, click on View Trace/Log.
          Click on report gls6002 file to view the report.
          Print the report using the print icon
   14     The Calculation Log report data should match the Pool and Target chartfields
          and amounts should match the Multi-step (Step 1=xxxx; Step 2=xxxx) Copy
          Allocation Journal printed in Step #12

                                                                                   Expected Results
The Allocation Journal was successfully created, posted and matches with the Calculation Log Report chartfields and amounts.
The chartfields in the Pool and Target match and reconcile to the Allocation Journal and the Calculation Log Report.


                 Overall Script Results                        GL Test Script Sign-Off
          Pass                    Re Test Pass
          Fail                    Re Test Fail                                                                                                              Date:




        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                 Last Revised on: 12/14/2004
        Worksheet: GL35                                                                                                                                       Last Printed on: 7/19/2010
                                                                    9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Process a Spread Evenly Type Allocation.
Scenario: Process a Spread Evenly Type Allocation. Set up an Allocation Request. Verify data on allocation journal is correct before and after posting.
Dependencies: Spread Evenly Type Allocation Step (Spread) and Group (Sprd Group) have been set up for this test and data populated in the chartfields used in the allocation.



                                   Script Description                                                                           Test Notes                                       Initials
   1      Navigate to: Allocations>>Define and Perform Allocations>>Define
          Allocation Step>>Add a new Value
          Your BU should default in, then enter a Process Step
          Review setup on each tab.
          Use this information to verify results after the Spread Allocation and the
          Allocation Log have been run.
   2      Navigate to: Allocations>>Set Up and Perform Allocations>>Define
          Allocation Group>>Add an New Value
          Create a New Allocation Group and attaach the Allocation Rule you just
          created to it.
   3      Navigate to: Allocations>>Set Up and Perform Allocations>>Request                 Process Frequency=Always
          Allocation>>Add an New Value                                                      Business Unit=xxxxx
                                                                                            Process Group=Sprd Group
                                                                                            Req Date Optn=Process Date
                                                                                            Output Options=Create Calc Log and Output
   4      Click on Process Monitor. Once the process shows Success, Click on
          Details, Click on View Log/Trace, Click on the ??????? PDF File
   5      Navigate to: General Ledger>Journals>Journal Entry>Create Journal
          Entries >Find an Existing Value

   6      To view the Spread Allocation Journal just created, enter the Business Unit of
          the allocation journal, enter Journal ID field, and the date (should be today's
          date), and click on Search.
   7      Double click on the Allocation Journal ID to open the journal.
   8      Edit and Post the Spread Type Allocation Journal
   9      Print to review and compare journal to the Calculation Log printed in Step        See Special Instructions tab - Print Journal Online
          #13.
   10     Navigate to: Allocations>>Reports>>Allocation Calculation Logs>>Add
          or Find an existing value




        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                              Last Revised on: 5/12/2005
        Worksheet: GL36                                                                                                                                   Last Printed on: 7/19/2010
                                                                    9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Process a Spread Evenly Type Allocation.
Scenario: Process a Spread Evenly Type Allocation. Set up an Allocation Request. Verify data on allocation journal is correct before and after posting.
Dependencies: Spread Evenly Type Allocation Step (Spread) and Group (Sprd Group) have been set up for this test and data populated in the chartfields used in the allocation.



                                   Script Description                                                                      Test Notes                                            Initials
   11     Navigate to: Allocations>>Define and Perform Allocations>>Define
          At the Calculation Log page, enter:
          Allocation Step>>Add a new Value
          SetID=XXXXX
          Your BU should default in, then enter a Process Step
          Process Step=xxxxx
          Review setup on each tab. #4)
          Process Instance= (see Step
          Use this information to verify results after the Spread Allocation and the
          Click on the Refresh button
          Allocation Log have been run.
          Check Fund and Account
          Save
   12     Click on Process Monitor. Once the process shows Success, Click on
          Details, Click on View Log/Trace, Click on the GLS6002 PDF File
   13     Print the Calculation Log Report using the print icon.

   14     The Calculation Log report data should match the Pool and Target chartfields Ledger for Pool, Basis and Target=Actuals
          and the chartfields and amounts should match the allocation journal printed in
          Step #13

                                                                                   Expected Results
The Allocation Journal was successfully created, posted and matches with the Calculation Log Report chartfields and amounts.
The chartfields in the Pool and Target match and reconcile to the Allocation Journal and the Calculation Log Report.

                 Overall Script Results                         GL Test Script Sign-Off
          Pass                    Re Test Pass
          Fail                    Re Test Fail                                                                                                          Date:




        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                              Last Revised on: 5/12/2005
        Worksheet: GL36                                                                                                                                   Last Printed on: 7/19/2010
                                                                    9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Fixed Basis Type Allocation.
Scenario: Process a Fixed Basis Type Allocation. Set up an Allocation Request. Verify data on allocation journal is correct before and after posting.
Dependencies: Fixed Type Allocation Step (Fixed) and Group (FixedGrp) have been set up for this test and data populated in the chartfields used in the allocation.



                                   Script Description                                                                          Test Notes                                          Initials
   1      Navigate to: Allocations>>Set Up and Perform Allocations>>Request
          Allocation>>Find an Existing Value
          SetID=xxxxx
          Process Step=xxxxx
          Review setup on each tab.
          Use this information to verify results after the Fixed Allocation and the
          Allocation Log have been run.
   2      Enter data for an Allocation Request for a Fixed Type Allocation                Process Frequency=Always
                                                                                          Business Unit=XXXXX
                                                                                          Process Group=xxxxx
                                                                                          Req Date Optn=Process Date
                                                                                          Output Options=Create Calc Log and Output
   3      Enter parameter/criteria for Process Scheduler request.
   4      Click on OK
   5      Click on Process Monitor
   6      Click on Refresh until process finishes
   7      Click on Detail and then on Message Log. Verify the Message Log says a          Note Process Instance for Step #15
          journal was created.
   8      Navigate to: General Ledger>>Journals>>Journal Entry>>Create                    See Special Instruction tab - Create/Update Journal Online
          Journal Entries >>Find an Existing Value
   9      To view the Fixed Allocation Journal just created, enter the Business Unit of
          the allocation journal, ALO in the Journal ID field, and the date (see output
          options), and click on Search.
   10     Double click on the Allocation Journal ID to open the journal.
   11     Edit and Post the Fixed Type Allocation Journal                                 See Special Instructions - Edit Journal Online and Post Journal Online
   12     Print to review and compare journal to the Calculation Log printed in           See Special Instructions - Print Journal Online
          Step #15.
   13     Navigate to: Allocations>>Reports>>Allocation Calculation Logs>>Add
          a New Value (Run Control ID) for this report


        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                  Last Revised on: 8/25/03
        Worksheet: GL37                                                                                                                                     Last Printed on: 7/19/2010
                                                                   9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Fixed Basis Type Allocation.
Scenario: Process a Fixed Basis Type Allocation. Set up an Allocation Request. Verify data on allocation journal is correct before and after posting.
Dependencies: Fixed Type Allocation Step (Fixed) and Group (FixedGrp) have been set up for this test and data populated in the chartfields used in the allocation.



                                   Script Description                                                                       Test Notes                                           Initials
   14     Navigate to: Allocations>>Set Up and Perform Allocations>>Request
          At the Calculation Log page, enter:
          Allocation>>Find an Existing Value
          SetID=XXXXX
          SetID=xxxxx
          Process Step=xxxx
          Process Step=xxxxx Step #5)
                  Instance= (see
          Review setup on each tab.
          Click on the Refresh button
          Use this information to verify results after the Fixed Allocation and the
          Check Fund and Account
          Allocation Log have been run.
          Save
   15     Click on Run to begin processing this report request
          At the Process Scheduler page select PSUNX for all processes and PSNT for
          all Crystal' reports.
          Click on OK.
          Back at the Run Control Request page, click on the Process Monitor until the
          process status is Success.
          Click on Detail hyperlink.
          Click on Message hyperlink to verify process completed successfully or if in
          error, why it ended in error.
          If it is a PDF report, click on View Trace/Log.
          Click on Message to view additional messages about the process results.
          Click on the PDF file to view the report.
   16     Print the Calculation Log Report using the print icon.




        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                Last Revised on: 8/25/03
        Worksheet: GL37                                                                                                                                   Last Printed on: 7/19/2010
                                                                  9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Fixed Basis Type Allocation.
Scenario: Process a Fixed Basis Type Allocation. Set up an Allocation Request. Verify data on allocation journal is correct before and after posting.
Dependencies: Fixed Type Allocation Step (Fixed) and Group (FixedGrp) have been set up for this test and data populated in the chartfields used in the allocation.



                                   Script Description                                                                      Test Notes                                            Initials
  17     The Calculation Log report data Up and Perform Allocations>>Request
         Navigate to: Allocations>>Set should match the Pool and Target chartfields Ledger for Pool, Basis and Target=Actuals
         Allocation>>Find an amounts should
         and the chartfields andExisting Value match the allocation journal printed in
         SetID=xxxxx
         Step #12.
         Process Step=xxxxx
         Review setup on each tab.                                                 Expected Results
         Use this information to verify results after the Fixed Allocation and the
The Allocation Journal was successfully created, posted and matches with the Calculation Log Report chartfields and amounts.
         Allocation Log have been run.
The chartfields in the Pool and Target match and reconcile to the Allocation Journal and the Calculation Log Report.


              Overall Script Results                          GL Test Script Sign-Off
         Pass                  Re Test Pass
         Fail                  Re Test Fail                                                                                                              Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                 Last Revised on: 8/25/03
       Worksheet: GL37                                                                                                                                    Last Printed on: 7/19/2010
                                                                    9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Prorata with Record Basis Type Allocation.
Scenario: Process a Prorata with Record Basis Type Allocation. Set up an Allocation Request and run Process Scheduler. Verify data on allocation journal is correct before and after
posting.
Dependencies : Prorata with Record Basis Type Allocation Step (ProrataRe) and Group (Prorat Grp) have been set up for this test and data populated in the chartfields used in the

                                   Script Description                                                                            Test Notes                                     Initials
   1      Navigate to: Allocations>>Set Up and Perform Allocations>>Define
          Allocation Step>>Find an Existing Value
          SetID=XXXXX
          Process Group="PRORATA RE"
          Review setup on each tab.
          Use this information to verify results after the Prorata Re Allocation and the
          Allocation Log have been run.
   2      Navigate to: Allocations>>Set Up and Perform Allocations>>Define
          Allocation Step>>Find an Existing Value
          SetID=xxxxx
          Process Step="PRORAT GROUP"
          Review setup. Note there is one step for processing this allocation.
          Use this information to verify results after the Prorata Re Allocation has been
          run and the Allocation Log have been run..
   3      Enter data for an Allocation Request for a Prorata with Record Type               Process Frequency=Always
          Allocation                                                                        Business Unit=XXXXX
                                                                                            Process Group=XXXXXXXXXXX
                                                                                            Req Date Optn=Process Date
                                                                                            Output Options=Create Calc Log and Output
   4      Enter parameter/criteria for Process Scheduler request. Click OK.
   5      Click on Process Monitor
   6      Click on Refresh until process finishes
   7      Click on Detail and then on Message Log. Verify the Message Log says a            Note Process Instance for Step #17
          journal was created.
   8      Navigate to: General Ledger>>Journals>>Journal Entry>>Create                      See Special Instruction tab - Create/Update Journal Online
          Journal Entries >>Find an Existing Value
   9      To view the Prorata Allocation Journal just created, enter the Business Unit of
          the allocation journal,the Journal ID field, and the date (see output options),
          and click on Search.
   10     Double click on the Allocation Journal ID to open the journal.


        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                               Last Revised on: 8/25/03
        Worksheet: GL38                                                                                                                                  Last Printed on: 7/19/2010
                                                                    9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Prorata with Record Basis Type Allocation.
Scenario: Process a Prorata with Record Basis Type Allocation. Set up an Allocation Request and run Process Scheduler. Verify data on allocation journal is correct before and after
posting.
Dependencies : Prorata with Record Basis Type Allocation Step (ProrataRe) and Group (Prorat Grp) have been set up for this test and data populated in the chartfields used in the

                                    Script Description                                                                         Test Notes                                       Initials
   11     Edit and to: Allocations>>Set Up and Journal Allocations>>Define
          NavigatePost the Prorata Type AllocationPerform-- Edited and posted when
          Allocation Step>>Find an
          the allocation is processed. Existing Value
   12     SetID=XXXXX compare journal to the Calculation Log printed in
          Print to review and                                                              See Special Instructions - Print Journal Online
          Process Group="PRORATA RE"
          Step #16.
          Review setup on each tab.
   13     Navigate to: Allocations>>Reports>>Allocation Calculation Logs>>Add
          Use this information to verify results after the Prorata Re Allocation and the
          a New Value (Run Control ID) for this report
          Allocation Log have been run.
   14     At the Calculation Log page, enter:
          SetID=XXXXX
          Process Step="Prorata Re"
          Process Instance= (see Step #8)
          Click on the Refresh button
          Check Fund and Account
          Save
   15     Click on Run to begin processing this report request.
          At the Process Scheduler page select PSUNX for all processes and PSNT for
          all Crystl reports.
          Click on OK.
          Back at the Run Control Request page, click on the Process Monitor until the
          process status is Success.
          Click on Detail hyperlink.
          Click on Message hyperlink to verify process completed successfully or if in
          error, why it ended in error.
          If it is a PDF report, click on View Trace/Log.
          Click on Message to view additional messages about the process results.
          Click on the PDF file to view the report.
   16     Print the Calculation Log Report using the print icon.




        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                               Last Revised on: 8/25/03
        Worksheet: GL38                                                                                                                                  Last Printed on: 7/19/2010
                                                                  9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Prorata with Record Basis Type Allocation.
Scenario: Process a Prorata with Record Basis Type Allocation. Set up an Allocation Request and run Process Scheduler. Verify data on allocation journal is correct before and after
posting.
Dependencies : Prorata with Record Basis Type Allocation Step (ProrataRe) and Group (Prorat Grp) have been set up for this test and data populated in the chartfields used in the

                                   Script Description                                                                      Test Notes                                           Initials
  17     Navigate to: Allocations>>Set should match the Pool and Target chartfields
         The Calculation Log report data Up and Perform Allocations>>Define
         Allocation Step>>Find an Existing Value
         and the chartfields and amounts should match the allocation journal printed in
         SetID=XXXXX
         Step #16
         Process Group="PRORATA RE"
         Review setup on each tab.                                                   Expected Results
         Use this information to verify results after the Prorata Re Allocation and the
The Allocation Journal was successfully created, posted and matches with the Calculation Log Report chartfields and amounts.
         Allocation Log have been run.
The chartfields in the Pool and Target match and reconcile to the Allocation Journal and the Calculation Log Report.




              Overall Script Results                         GL Test Script Sign-Off
         Pass                  Re Test Pass
         Fail                  Re Test Fail                                                                                                             Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                Last Revised on: 8/25/03
       Worksheet: GL38                                                                                                                                   Last Printed on: 7/19/2010
                                                                  9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Arithmetic Operation Type Allocation.
Scenario: Process an Arithmetic Operation Type Allocation. Set up an Allocation Request and run Process Scheduler. Verify data on allocation journal is correct before and after
posting.
Dependencies: Arithmetic Operation Type Allocation Step (Math) and Group (Math Grp) have been set up for this test and data populated in the chartfields used in the allocation.

                                  Script Description                                                                            Test Notes                                      Initials
   1     Navigate to: Allocations>>Set Up and Perform Allocations>>Request
         Allocation>>Find an Existing Value
         SetID=XXXXX
         Process Step=XXXX
         Review setup on each tab.
         Use this information to verify results after the Math Allocation and the
         Allocation Log have been run.

   2     Navigate to: Allocations>>Set Up and Perform Allocations>>Request
         Allocation>>Find an Existing Value (Run Control ID)
   3     Enter data for an Allocation Request for a Arithmetic Operation Type              Process Frequency=Always
         Allocation                                                                        Business Unit=XXXXX
                                                                                           Process Group=xxxxGRP
                                                                                           Req Date Optn=Process Date
                                                                                           Output Options=Create Calc Log and Output
   4     Click on the Run button to go to the Process Scheduler page .                     Note Process Instance for Step #12
         At the Process Scheduler page select PSUNX for all processes and PSNT for
         all Crystal Reports.
         Click on OK.
         Back at the Run Control Request page, click on the Process Monitor until the
         process status is Success.

   5     Click on Detail hyperlink and then on Message Log. Verify the Message Log
         says a journal was created.

   6     Navigate to: General Ledger>>Journals>>Journal Entry>>Create                      See Special Instruction tab - Create/Update Journal Online
         Journal Entries >>Find an Existing Value
   7     To view the Arithmetic Allocation Journal just created, enter the Business Unit
         of the allocation journal, enter the Journal ID field, and the date (should be
         today's date), and click on Search.
   8     Double click on the Allocation Journal ID to open the journal.



       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                Last Revised on: 8/25/03
       Worksheet: GL39                                                                                                                                   Last Printed on: 7/19/2010
                                                                    9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Arithmetic Operation Type Allocation.
Scenario: Process an Arithmetic Operation Type Allocation. Set up an Allocation Request and run Process Scheduler. Verify data on allocation journal is correct before and after
posting.
Dependencies: Arithmetic Operation Type Allocation Step (Math) and Group (Math Grp) have been set up for this test and data populated in the chartfields used in the allocation.

                                   Script Description                                                                            Test Notes                                           Initials
   9      NavigatePost the Arithmetic Type Allocation Journal
          Edit and to: Allocations>>Set Up and Perform Allocations>>Request                  See Special Instructions - Edit Journal Online and Post Journal Online
          Allocation>>Find an Existing Value
   10     SetID=XXXXX compare journal to the Calculation Log printed in
          Print to review and                                                                See Special Instructions - Print Journal Online
          Step #14.
          Process Step=XXXX
   11     Review setup on each tab.
          Navigate to: Allocations>>Reports>>Allocation Calculation Logs>>Add
          Use this informationControl ID) for this report Allocation and the
          a New Value (Run to verify results after the Math
          Allocation Log have been run.
   12     At the Calculation Log page, enter:
          SetID=XXXXX
          Process Step=xxxx
          Process Instance= (see Step #4)
          Click on the Refresh button
          Check Fund and Account
          Save
   13     Click on Run to begin processing this report request
          At the Process Scheduler page select PSUNX for all process and PSNT for all
          Crystal Reports
          Click on OK.
          Back at the Run Control Request page, click on the Process Monitor until the
          process status is Success.
          Click on Detail hyperlink.
          Click on Message hyperlink to verify process completed successfully or if in
          error, why it ended in error.
          If it is a PDF report, click on View Trace/Log.
          Click on Message to view additional messages about the process results.
          Click on the PDF file to view the report.
   14     Print the Calculation Log Report using the print icon.

   15     The Calculation Log report data should match the Pool and Target chartfields
          to the right and the chartfields and amounts should match the allocation journal
          printed in Step #6.

                                                                                    Expected Results

        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                     Last Revised on: 8/25/03
        Worksheet: GL39                                                                                                                                        Last Printed on: 7/19/2010
                                                                  9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Arithmetic Operation Type Allocation.
Scenario: Process an Arithmetic Operation Type Allocation. Set up an Allocation Request and run Process Scheduler. Verify data on allocation journal is correct before and after
posting.
Dependencies: Arithmetic Operation Type Allocation Step (Math) and Group (Math Grp) have been set up for this test and data populated in the chartfields used in the allocation.

                                   Script Description                                                                      Test Notes                                           Initials
         Navigate to: Allocations>>Set Up and Perform Allocations>>Request
The Allocation Journal was successfully created, posted and matches with the Calculation Log Report chartfields and amounts.
         Allocation>>Find an Existing Value
The chartfields in the Pool and Target match and reconcile to the Allocation Journal and the Calculation Log Report.
         SetID=XXXXX
         Process Step=XXXX
         Review setup on each tab.
               Overall Script Results                           GL Test Script Sign-Off
         Use this information to verify results after the Math Allocation and the
         Pass                    Re run.
         Allocation Log have beenTest Pass
         Fail                    Re Test Fail                                                                                                           Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                Last Revised on: 8/25/03
       Worksheet: GL39                                                                                                                                   Last Printed on: 7/19/2010
                                                                  9b2d19ce-7ee8-4860-a04a-3133f0208047.xls


Test Objective:      Copy Step Utility
Scenario: Copy an Allocation Step. Configure a run control that copies that Allocation Step. Verify allocation step is copied and correct .
Rename an Allocation Step. Configure a run control that renames that Allocation Step. Verify allocation step is renamed and correct.
Delete an Allocation Step. Configure a run control that deletes that Allocation Step. Verify allocation step is deleted.

                                   Script Description                                                                       Test Notes                               Initials
   1      Navigate to: Allocations>>Define and Perform
          Allocations>>Copy/Rename/Delete Step>>Add or Find an Existing Value
   2      Enter parameter/criteria for copy request.
   3      Click on the Run button to go to the Process Scheduler page .
          At the Process Scheduler page select PSUNX. Click OK.
   4      Click on Process Monitor. When the process shows Success verify the
          eistance of the new allocation Step.
   5      Navigate to: Allocations>>Define and Perform Allocations>>Define
          Allocation Step >> Find an Existing Value.
          Verify allocation step is copied and correct .
   6      Navigate to: Allocations>>Set Up and Perform
          Allocations>>Copy/Rename/Delete Step>>Add or Find an Existing Value
   7      Enter parameter/criteria for rename request.
   8      Repeat 3 & 4 above.
   8      Navigate to: Allocations>>Define and Perform
          Allocations>>Copy/Rename/Delet Step>> Find an Existing Value.
          Verify allocation step is renamed and correct .
   10     Enter parameter/criteria to delete a step.
   11     Repeat 3 & 4 above.
   11     Navigate to: Allocations>>Define and Perform
          Allocations>>Copy/Rename/Delete Step>> Find an Existing Value.
          Click on Search. Deleted Steps should not be listed.

                                                                                  Expected Results
Allocation steps are correctly and completely copied, renamed and deleted.

               Overall Script Results                         GL Test Script Sign-Off
          Pass                  Re Test Pass
          Fail                  Re Test Fail                                                                                                  Date:




File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                   Last Revised on: 5/23/2005
Worksheet: GL40                                                                                                                                       Last Printed on: 7/19/2010
                                                                  9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Allocation Group Report
Scenario: Run the Allocation Group Report for a specific process group. Verify data on allocation group report is correct.




                                   Script Description                                                                        Test Notes                           Initials
   1     Navigate to: Allocations>> Reports>>Allocation Group>>Find an
         Existing Value
   2     Enter parameter/criteria for report request.
         Click Run.
   3     Click on Process Monitor. Once the process shows Success, Click on
         Details, Click on View Log/Trace, Click on the GLS6001 PDF File

                                                                                  Expected Results
Report should be created with information requested


              Overall Script Results                          GL Test Script Sign-Off
         Pass                  Re Test Pass
         Fail                  Re Test Fail                                                                                               Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                Last Revised on: 5/24/2005
       Worksheet: GL41                                                                                                                     Last Printed on: 7/19/2010
                                                                    9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Allocation Calculation Logs
Scenario: Run the Allocation Calculation Log for a specific process step and a specific process instance range. Verify data on allocation report is correct.




                                     Script Description                                                                         Test Notes                                            Initials
    1     Navigate to: Allocations>>Set Up and Perform Allocations>>
          Reports>>Allocation Calculation Logs>>Add or Find an Existing Value
    2     Click on the Run button to go to the Process Scheduler page .
          At the Process Scheduler page select PSUNX for all processes and reports and
          PSNT for all Crystal Reports.
          Click on OK.
          Back at the Run Control Request page, click on the Process Monitor until the
          process status is Success.
          Click on Detail hyperlink.
          Click on Message hyperlink to verify process completed successfully or if in
          error, why it ended in error.
          If it is a PDF report, click on View Trace/Log.
          Click on Message to view additional messages about the process results.
          Click on the PDF file to view the report.

    3     Print and review report.




        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                     Last Revised on: 8/25/03
        Worksheet: GL42                                                                                                                                        Last Printed on: 7/19/2010
                                                                    9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Allocation Calculation Logs
Scenario: Run the Allocation Calculation Log for a specific process step and a specific process instance range. Verify data on allocation report is correct.




                                     Script Description                                                                         Test Notes
                                                                                    Expected Results
Report should be created with information requested




               Overall Script Results                          GL Test Script Sign-Off
          Pass                  Re Test Pass
          Fail                  Re Test Fail                                                                                                                   Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                       Last Revised on: 8/25/03
       Worksheet: GL42                                                                                                                                          Last Printed on: 7/19/2010
                                                                   9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Background Process Report
Scenario: Run the Background Process Reports with a specific process name and instance. Verify data on reports is correct.


                                   Script Description                                                                        Test Notes                           Initials
   1     Navigate to: Background Processes>>Review Message Log
   2     Enter Process Instance # and click Search
   3     Verify that process instance entered in Step #2 is in the Message Log - Search
         page. Click Search again to display the message detail online.
   4     Navigate to: Background Processes>>Print Process Report
   5     Select/create a run control. Enter same process instance entered in step #2.

   6     Click on the Run button to go to the Process Scheduler page .
         At the Process Scheduler page select PSUNX for all process and reports except
         PSNT for all Crystal Reports.
         Click on OK.
         Back at the Run Control Request page, click on the Process Monitor until the
         process status is Success.
         Click on Detail hyperlink.
         Click on Message hyperllink to verify process completed successfully or if in
         error, why it ended in error.
         If it is a PDF report, click on View Trace/Log.
         Click on Message to view additional messages about the process results.
         Click on the PDF file to view the report.
         Print the report using the print icon

                                                                                   Expected Results
Reports should be created with information requested




              Overall Script Results                          GL Test Script Sign-Off
         Pass                  Re Test Pass
         Fail                  Re Test Fail                                                                                               Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                  Last Revised on: 8/25/03
       Worksheet: GL43                                                                                                                     Last Printed on: 7/19/2010
                                                                  9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:   Automated Reconciliation.
Scenario: Load Bank file and Process Automated Reconciliation. Verify reconciliation is complete and all reconciliation items are corrected or noted as reconciling items.




                               Script Description                                                                           Test Notes                                           Initials
   1      Navigate to: Banking>>Bank Accounts>>External Account
   2      Click on Search push button and select the appropriate External Bank
          Account (typically it is the DVP bank account) and navigate to the Account
          Reconciliation tab.
   3      Verify that the Recon Method for the bank account is set to Automatic .       SOSS recommends the bank Reconciliation Method be set to Automatic.
   4      Down load bank file from the Teale Data Center and renamed the file to        Please contact the FSSR Department at the Chancellor's Office to obtain an access
          "CSUBankin.txt "                                                              ID.
   5      Upload the bank file to the appropriate database directory.                   SSH Secure FTP is the recommended software to perform the file upload
                                                                                        processes. The upload directory/path is /opt/apps/fspsoft/xfer/in/fxxftp/ where
                                                                                        xx is the campus initials .
   6      Navigate to: PeopleTools>>EdI Manager>>Monitor EDI
          Processing>>Schedule Inbound EC Agent>>Add or Update/Display to
          select a Run Control ID
   7      At the Run Control Parameters, input required information:                    Enter CSUBankin.txt in the Single File Name field. It is very important to use
          - Run Option = Single File (radio button)                                     the same run control ID for all the bank reconciliation related processes.
          - Single File Path = /opt/apps/fspsoft/xfer/in/fxxftp
          - Single File Name = CSUBankin.txt
          - Force Profile = Force with Map Information (998)
          - EC Map ID = CSUBSP
          - EC Profile ID = BSP
          Save
   8      Click on Run. At the Process Scheduler Request enter the following:
          - Server Name = PSUNX
          - Select CSU Bank Reformat EDI job
          Click on OK
    9     Click on the Process Monitor hyperlink to view the progress.
   10     When the job is completed successfully, click on the Go back to Inbound EC
          Agent hyperlink to return to the same run control page.




        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                Last Revised on: 8/25/03
        Worksheet: GL44                                                                                                                                   Last Printed on: 7/19/2010
                                                                  9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:   Automated Reconciliation.
Scenario: Load Bank file and Process Automated Reconciliation. Verify reconciliation is complete and all reconciliation items are corrected or noted as reconciling items.




                                    Script Description                                                                        Test Notes                                           Initials
   11                                      Accounts>>External Account
          Navigate to: Banking>>Bank input required information:
          At the Run Control Parameters,                                                    Replace the Single File Name to CSUBankout.txt
          - Run Option = Single File (radio button)
          - Single File Path = /opt/apps/fspsoft/xfer/in/fxxftp
          - Single File Name = CSUBankout.txt
          - Force Profile = Force with Map Information (998)
          - EC Map ID = CSUBSP
          - EC Profile ID = BSP
          Save
   12     Click on Run. At the Process Scheduler Request enter the following:
          - Server Name = PSUNX
          - Select Inbound EC Agent job
          Click on OK
   13     Click on the Process Monitor hyperlink to view the progress.
   14     Navigate to: PeopleTools>>EDI Manager>>View EDI Audit
          Trail>>Business Document Summary
   15     At the Business Document Summary page click on the Search push button.
          Click on the last EC Business Document ID to view the file.
   16     The file status should be Loaded without any errors. If the file status is error,
          review the error message and contact SOSS-CMS for assistant.
   17     Navigate to: Banking>>Bank Statement>>Load Electronic Statement
   18     Add a new run control. At the prompts:                                        If selecting an existing run control, simply click on the Search push button
          Enter your User ID
          Enter a new Run Control ID
          Enter TR_BSP_LOAD
   19     In the Electronic Statement Load page, enter:
          Process Frequency = Always
          Market = U.S.
          As of Date = blank
   20     In the Process Scheduler Request page, enter:
          Server Name = PSUNX
          Select TR_BSP_LOAD
          Click OK to submit the job



        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                  Last Revised on: 8/25/03
        Worksheet: GL44                                                                                                                                     Last Printed on: 7/19/2010
                                                                   9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:   Automated Reconciliation.
Scenario: Load Bank file and Process Automated Reconciliation. Verify reconciliation is complete and all reconciliation items are corrected or noted as reconciling items.




                                  Script Description                                                                         Test Notes                                           Initials
   21               to: Banking>>Bank Accounts>>External Account
          Navigatethe Process Monitor hyperlink in the Electronic Statement Load page
          Click on
          to view the progress. When the job run successfully, click on the Go back to
          Electronic Statement Load page. The system will update the page with a new
          Process Instance number and the job status.
   22     Navigate to: Banking>>Reconcile Statements>>Automatic Reconciliation

   23     At the AutoRecon Manager page, enter:                                           Statement status should be Appl Loaded .
          BankID = %
          Account # = %
          Unit = XXCMP (where XX is campus initials)
          From/Thru Dates = Enter the date when bank statement is loaded
          Click on Search
   24     To process the Bank Reconciliation:
          Select the loaded bank statement
          Select the same Run Control used in Step 3
          Click on the Recon push button
   25     Click on the New Windows hyperlink to open a new browser window to view
          job status by navigating to:
          PeopleTools >>Process Scheduler>>Process Monitor
   26     When the job is completed successfully, the statement status should be          If there is AutoRecon Exceptions transaction, proceed with Steps 24 ~ 26 .
          Completed in the AutoRecon Manager page. If the status is Ready , click on
          the Exception hyperlink view the outstanding transaction(s).
   27     To reconcile AutoRecon Exception transactions, navigate to:                     This method should only be used to "force" reconcile minor amount differences
          Banking>>Analyze Exceptions>>Resolved Exceptions                                between the bank paid/system amounts (due to data processing errors at the bank
                                                                                          side).
   28     At the AutoRecon Exception page, enter:
          Bank ID = Campus Specific
          Account # = Campus Specific
          Stmt ID = Select the statement with "Ready" status
          Click on the Search push button
   29     To "forced" reconcile, check-off the transactions in the display grid. System
          will display a warning error indicating "No Statement Activity Type has been
          Defined for this Type of Transaction" error. Click OK to confirm.

        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                 Last Revised on: 8/25/03
        Worksheet: GL44                                                                                                                                    Last Printed on: 7/19/2010
                                                                    9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:   Automated Reconciliation.
Scenario: Load Bank file and Process Automated Reconciliation. Verify reconciliation is complete and all reconciliation items are corrected or noted as reconciling items.




                                  Script Description                                                                         Test Notes                                           Initials
   30                   Banking>>Bank Accounts>>External Account
          Navigate to: confirm the "forced" reconciliation. System will display another A journal entry is required to record the adjustment. Other exceptions will require
          Click Save to
          warning message to indicate the reconciled amount.                            detail research involving the Accounts Payable department.
   31     To print a Register report for the statement, in the AutoRecon Manager page
          and enter:
          BankID = %
          Account # = %
          Unit = XXCMP (where XX is campus initials)
          From/Thru Dates = Enter the date when bank statement is loaded
          Click on Search push button
          Select the desired statement
          Reports = Register
          Click on OK push button
   32     Click on the New Windows hyperlink to open a new browser window to view
          job status by navigating to:
          PeopleTools >>Process Scheduler>>Process Monitor
   33     When the job is completed successfully, click on the Details hyperlink, then
          the View Log/Trace hyperlink. The Register Report (FIN3000, Crystal
          Report ) should be under the FIN3000-_0000.PDF (where 0000 = Process
          Instance) hyperlink.

                                                                                     Expected Results
Reconciliation is completed with all reconciliation items corrected or noted as reconciling items for audit purposes.




                 Overall Script Results                         GL Test Script Sign-Off
          Pass                    Re Test Pass
          Fail                    Re Test Fail                                                                                                            Date:




        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                 Last Revised on: 8/25/03
        Worksheet: GL44                                                                                                                                    Last Printed on: 7/19/2010
                                                                  9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Semi-Manual Reconciliation.
Scenario: Process Semi-Manual Reconciliation. Verify reconciliation is complete and all reconciliation items are fixed or noted as reconciling items.
Dependencies : External Bank page for Reconciliation Method is set as Semi-Manual.


                                                                                    Journal Data
                                    Line #
                                     and       Ledger               ADB       Reverse     Reverse                                                                      Open
  BU       Jrnl ID     JrnlDate     Descr      Group Source Ref no. Date       Jrnl       Jrnl Dt      Fund         Acct         Dept      Program       Project     Item Key       Amount




                              Script Description                                                                              Test Notes                                             Initials
   1     Navigate to: Banking>>Bank Accounts>>External Account
   2     Click on Search push button and select the appropriate External Bank
         Account (typically it is the DVP bank account) and navigate to the Account
         Reconciliation tab.
   3     Verify that the Recon Method for the bank account is set to Semi Man (Semi- SOSS recommends the bank Reconciliation Method be set to Automatic.
         Manual) .
   4     Navigate to: Banking>>Bank Statements>>Enter Bank Statements>>                 Bank statement flat file can also be created via flat file upload. Please refer to
         Find an Existing Value tab                                                     Steps 4 ~ 21 in Script # GL44 for processing details.
   5     Click on Search push button and note down the last bank statement ID number
         in the system.
   6     Navigate to the Add a New Value tab and enter:
         External Bank ID = select value by clicking on the Magnifying Glass
         Bank Account # = select value by clickingo n the Magnifying Glass
         Statement ID = add one to the statement ID number obtained from Step 4
         Click on Add push button




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                     Last Revised on: 8/25/03
       Worksheet: GL45                                                                                                                                        Last Printed on: 7/19/2010
                                                                  9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Semi-Manual Reconciliation.
Scenario: Process Semi-Manual Reconciliation. Verify reconciliation is complete and all reconciliation items are fixed or noted as reconciling items.
Dependencies : External Bank page for Reconciliation Method is set as Semi-Manual.


                                                                                       Journal Data
                                     Line #
                                      and       Ledger               ADB       Reverse     Reverse                                                                     Open
  BU        Jrnl ID     JrnlDate     Descr      Group Source Ref no. Date       Jrnl       Jrnl Dt      Fund         Acct         Dept      Program      Project     Item Key       Amount




                                   Script Description                                                                          Test Notes                                            Initials
   7      Navigate to: Banking>>Bank Accounts>>External Account
          At the Bank Statement Entry page, Statement Information tab, enter:
          Cycle Status = Appl Loaded (system default)
          Bank Stmt Date = Bank Statement Date
          Reference = Check Number (must be entered to match system format)               Check Number is a 6-digit numeric field in PeopleSoft.
          Bank Date = entry date of the transaction (system default to current date)
          Transaction Amount = obtain from bank statement
          Value Date = date the bank recorded the transaction
          Trans Code = see People Books for detail information                            Typical Trans Code value used is CHK (check) .
          Recon Status = typical value is UNR (unreconciled)
   8      Misc. Statement Information tab is optional. Please refer to People Books       This setup will allow system to create accounting entries for all "force" reconciled
          for more information.                                                           bank transactions during the AutoRecon processes.
   9      Once the statement is created, navigate to:
          Banking>>Reconcile Statements>>Semi-Manual Reconciliation
   10     At the Semi Manual Reconciliation page, enter:
          Bank ID = select value by clicking on the Magnifying Glass
          Account # = select value by clickingo n the Magnifying Glass
          Stmt ID = select value by clickingo n the Magnifying Glass
          From Date / Thru Date = Campus specific                                         The From/Thru Dates are the actual check dates , not the "cleared" dates.
          Recon Status = Unreconciled
          Click on the Search push button


        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                    Last Revised on: 8/25/03
        Worksheet: GL45                                                                                                                                       Last Printed on: 7/19/2010
                                                                   9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Semi-Manual Reconciliation.
Scenario: Process Semi-Manual Reconciliation. Verify reconciliation is complete and all reconciliation items are fixed or noted as reconciling items.
Dependencies : External Bank page for Reconciliation Method is set as Semi-Manual.


                                                                                       Journal Data
                                     Line #
                                      and       Ledger               ADB        Reverse    Reverse                                                                   Open
  BU        Jrnl ID     JrnlDate     Descr      Group Source Ref no. Date        Jrnl      Jrnl Dt     Fund        Acct        Dept      Program        Project    Item Key       Amount




                                   Script Description                                                                       Test Notes                                             Initials
   11     Navigate to: Banking>>Bank Accounts>>External Account 8 and
          System will retrieve information based on criteria entered in Step
          display them in two separate columns. The left column will display the
          transactions from the bank statement and the right column will display the
          transactions from the system (from the PS_PAYMENT_TBL ).
   12     To reconcile the transactions, select the matched transactions from both the    In Semi-Manual reconciliation, only one bank transaction can be reconciled at a
          Bank Transactions and the System Transactions columns and click on the          time .
          Reconcile push button. Continue the process until all the transactions from the
          bank statement are reconciled.
   13     Navigate to: Banking>>Reports>>Account register>>Add (or select an
          existing) Run Control

   14     In the Account Register page, enter:
          Language = English (system default)
          Bank ID = select value by clicking on the Magnifying Glass
          Bank Account # = select value by clickingo n the Magnifying Glass
          Recon Status = % (system default; % = all transactions)
          From / Thru = enter desire date ranges
          Click on Run push button




        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                  Last Revised on: 8/25/03
        Worksheet: GL45                                                                                                                                     Last Printed on: 7/19/2010
                                                                  9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Semi-Manual Reconciliation.
Scenario: Process Semi-Manual Reconciliation. Verify reconciliation is complete and all reconciliation items are fixed or noted as reconciling items.
Dependencies : External Bank page for Reconciliation Method is set as Semi-Manual.


                                                                                    Journal Data
                                     Line #
                                      and       Ledger               ADB       Reverse    Reverse                                                                    Open
  BU        Jrnl ID     JrnlDate     Descr      Group Source Ref no. Date       Jrnl      Jrnl Dt      Fund         Acct        Dept      Program       Project    Item Key       Amount




                                  Script Description                                                                         Test Notes                                            Initials
   15     Navigate to: Banking>>Bank Accounts>>External Account
          In the Process Scheduler Request page, enter:
          Server Name = PSNT (for all Crystal Report jobs)
          Select Account Register Report (FIN3004, Crystal Report)
          Click OK push button to submit the job


                                                                                     Expected Results
Reconciliation is completed with all items reconciled, corrected or noted as reconciling items. The Reports are correct and complete and match the data reconciled and unreconciled
using the semi-manual process.




               Overall Script Results                         GL Test Script Sign-Off
          Pass                  Re Test Pass
          Fail                  Re Test Fail                                                                                                               Date:




        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                  Last Revised on: 8/25/03
        Worksheet: GL45                                                                                                                                     Last Printed on: 7/19/2010
                                                                  9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Manual Reconciliation.
Scenario: Process Manual Reconciliation. Verify reconciliation is complete and all reconciliation items are fixed or noted as reconciling items.
Dependencies : External Bank page for Reconciliation Method is set as Manual.


                                                                                    Journal Data
                                    Line #
                                     and       Ledger               ADB        Reverse    Reverse                                                                 Open
  BU       Jrnl ID     JrnlDate     Descr      Group Source Ref no. Date        Jrnl      Jrnl Dt      Fund         Acct        Dept      Program    Project    Item Key       Amount




                              Script Description                                                                             Test Notes                                         Initials
   1     Navigate to: Banking>>Bank Accounts>>External Account

   2     Click on Search push button and select the appropriate External Bank
         Account (typically it is the DVP bank account) and navigate to the Account
   3     Verify that the tab.
         Reconciliation Recon Method for the bank account is set to Manual .             SOSS recommends the bank Reconciliation Method be set to Automatic.

         Navigate to: Banking>>Reconcile Statements>>Manual Reconciliation

   4     At the Manual Reconciliation page, enter:                                       If t he Recon Method for the external bank is set to Automatic , the system will
         Bank ID = select value by clicking on the Magnifying Glass                      display "This bank account is defined to use Automatic Reconciliation " warning
         Account # = select value by clickin go n the Magnifying Glass                   error message. Click OK to proceed.
         From Date / Thru Date = Campus specific
         Payment Method = select value from the drop-down menu
         Recon Status = Unreconciled
         Click on the Search push button
   5     Using the paper bank statement, check-off each cleared transactions one-by- Value Date = date the bank recorded the transaction
         one . Enter the Value Date . Click on the Reconcile push button to update the
         Recon Status for the transactions. When all transactions are reconciled, click
         Save push button.




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                Last Revised on: 8/25/03
       Worksheet: GL46                                                                                                                                   Last Printed on: 7/19/2010
                                                                  9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Manual Reconciliation.
Scenario: Process Manual Reconciliation. Verify reconciliation is complete and all reconciliation items are fixed or noted as reconciling items.
Dependencies : External Bank page for Reconciliation Method is set as Manual.


                                                                                    Journal Data
                                    Line #
                                     and       Ledger               ADB        Reverse    Reverse                                                                   Open
  BU       Jrnl ID     JrnlDate     Descr      Group Source Ref no. Date        Jrnl      Jrnl Dt      Fund         Acct        Dept      Program     Project     Item Key       Amount




                                  Script Description                                                                         Test Notes                                           Initials
   6     Navigate to: Banking>>Bank Accounts>>External AccountManual
         To print a Register report for the reconciled transactions, in the
         Reconciliation page:
         Select the desired transaction(s)
         Reports = Register
         Click on OK push button
   7     Click on the New Windows hyperlink to open a new browser window to view
         job status by navigating to:
         PeopleTools >>Process Scheduler>>Process Monitor
   8     When the job is completed successfully, click on the Details hyperlink, then
         the View Log/Trace hyperlink. The Register Report (FIN4004, Crystal
         Report ) should be under the FIN4004-_0000.PDF (where 0000 = Process
         Instance) hyperlink.


                                                                                     Expected Results
Reconciliation is completed with all items reconciled, corrected or noted as reconciling items. The Reports are correct and complete and match the data reconciled and unreconciled
using the manual process.

              Overall Script Results                          GL Test Script Sign-Off
         Pass                  Re Test Pass
         Fail                  Re Test Fail                                                                                                               Date:


       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                  Last Revised on: 8/25/03
       Worksheet: GL46                                                                                                                                     Last Printed on: 7/19/2010
                                                                        9b2d19ce-7ee8-4860-a04a-3133f0208047.xls
  Test Objective:    Tree Maintenance
  Scenario: Use Tree Maintenance to create new trees or to update/maintain existing trees.
                                            Script Description                                                                        Test Notes                  Initials
      1      Navigate to: Tree Manager>> Tree Manager
             Select tab "Create a new Tree" and add new tree called "TESTTREE88"
      2      Set Structure ID = FUND_DTL                                                                 Leave the audit box alone.
             Enter Effective Date of 01/01/1900
             Status = Active
             Description = Test Tree in 8.8
             Category = Default
             Use of Levels = Strictly Enforced
             Performance Methods = accept defaults
             SetID = enter your BU [xxxxx]
             Click OK
      3      At the Enter Root Node page click on Add Level.
             Add a level named "Funds"
             Enter same Effective date as the tree = 01/01/1900
             Enter a Description and a Short Description
             Add another 2 more levels = "Fund" and "Detail"
      4      At the Root Node field, enter or select "ALL_FUNDS" Click OK
      5      Highlight the Root Node at the next page.
      6      Click on the Child Node icon and enter a Node Name=GPR
      7      Click on the Child Node icon again and enter Node Name=PR
      8      Highlight the node GPR and click on the leaf (detail) icon and enter a valid GPR fund
             or fund range
      9      Highlight the node PR and click to add detail - a valid PR fund or range of funds
     10      Save your tree. Tree will not save if invalid. If the tree is invalid you will get an error
             message. Correct and save.
     11      Navigate to: Tree Manager>>Tree Manager
             Select tab "Finding an existing Tree" and locate the tree you created above.
     12      Click on the Tree Definition to view tree information
     13      Click on the 2 hyperlinks to maintain tree levels or performance methods, or update the
             information in the Audit section.
     14      Click on OK to save any changes. If errors, correct and save.
     15      Click on a node to see edit icons appear. Use these icons to move or add a value. Click
             on "SAVE". If errors, correct and save.
                                                                                         Expected Results
  Tree was created and updated with no errors.

                    Overall Script Results                         GL Test Script Sign-Off
             Pass                    Re Test Pass
             Fail                    Re Test Fail                                                                                                  Date:




File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                  Last Revised on: 5/23/2005
Worksheet: GL47                                                                                                                                       Last Printed on: 7/19/2010
                                                                   9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Tree Viewer
Scenario: Open Tree Viewer to view and verify certain nodes and chartfields on the trees.


                               Script Description                                                             Test Notes                           Initials
   1     Navigate to: Tree Manager>> Tree Viewer
         Using Advanced Search enter criteria to find one of your trees to view.
   2     Click on the 'Display Options' if you wish to modify the viewing options.
   3     If you want to print the entire tree in detail click on Expand All, if you want
         summary levels only click on Collapse All, or if you want the detail of selected
         levels open those levels.
   4     When you have what you want to print on the screen, close the PS menu on the
         right and click on the print icon on your menu bar.

                                                                                     Expected Results
Data on tree is accessed and reviewed with no error messages and can be printed.




              Overall Script Results                           GL Test Script Sign-Off
         Pass                  Re Test Pass
         Fail                  Re Test Fail                                                                                Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                 Last Revised on: 5/24/2005
       Worksheet: GL48                                                                                                      Last Printed on: 7/19/2010
                                                                 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:     Create a Share Chartfield
Scenario: Create a new fund, program or account. This test script will have to be completed by UWS staff due to exisitng security.

                               Script Description                                                                       Test Notes                           Initials
   1     Navigate to: Set Up Financials/Supply Chain>>Common Definitions>>
         Design Chartfields>>Define Values>>Chartfield Values>>Add a new
         Value
   2     Select Account
         SetID should be SHARE
         Enter the new account


                                                                                Expected Results
A new fund, program, or account was successfully added.


                Overall Script Results                       CF Test Script Sign-Off
         Pass                    Re Test Pass
         Fail                    Re Test Fail                                                                                        Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                           Last Revised on: 5/24/2005
       Worksheet: CF1                                                                                                                 Last Printed on: 7/19/2010
                                                                     9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Create a BU (Campus) owned Chartfiled
Scenario: Create a new Department, Project, Class

                                Script Description                                                                            Test Notes                                           Initials
   1     Navigate to: Set Up Financials/Supply Chain>>Common Definitions>>
         Design Chartfields>>Define Values>>Chartfield Values>>Add a new Value

   2     Select Department
         SetID should be your BU
         Enter the new department
         Click on Add
   3     Enter the effective date, description, short description, Manager ID and           If you enter a Manager ID from the drop down menu the Manager Name will
         Manager Name as appropriate for your BU                                            fill in when you tab out of Manager ID Is this a problem, do all managers have
                                                                                            to be users of SFS?
   4     Click Save
   5     Repeat steps 1 and 2 to add a class
         Enter the effective date, description and short description as approiate for
         your BU
   6     Click Save
   7     Repeat steps 1 and 2 to add a project                                              This a problem, because all managers have to be users of SFS and PI's are
         On the Project Panel, enter the effective date, description, start and end dates   generally not users.
         as approiate for your BU
         In the Project Manager section enter an effective date and a project Manager
         ID
         In the Project Status section enter an effective date and a project status
         (Budgeted, Closed, Hold, Open, Proposed)
         On the Description panel, enter additional description information as
         appropriate for your BU
   8     Click Save


                                                                                        Expected Results
A new department, project/grant and class were successfully added.



                Overall Script Results                         CF Test Script Sign-Off
         Pass                    Re Test Pass
         Fail                    Re Test Fail                                                                                                           Date:


       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                                   Last Revised on: 4/22/05
       Worksheet: CF2                                                                                                                                       Last Printed on: 7/19/2010
                                                                 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Find an Existing a Combination Template
Scenario: Find an existing Combo Edit Template

                               Script Description                                                           Test Notes                           Initials
   1     Navigate to: Set Up Financials/Supply Chain>>Common Definitions>>
         Design Chartfields>>Combination Editing>>Chartfield Editing
         Template>>Find an Existing Value
   2     Click Search
         Select Template

                                                                                Expected Results
Review existing Combination Editing Templates


              Overall Script Results                         CF Test Script Sign-Off
         Pass                  Re Test Pass
         Fail                  Re Test Fail                                                                              Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                               Last Revised on: 4/22/2005
       Worksheet: CF3                                                                                                     Last Printed on: 7/19/2010
                                                                    9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:     Create a Combination Definition
Scenario: Create a new Combo Edit Definition

                                Script Description                                                             Test Notes                           Initials
   1     Navigate to: Set Up Financials/Supply Chain>>Common Definitions>>
         Design Chartfields>>Combination Editing>>Combination
         Definition>>Add a new Value
   2     Your BU should default in, enter a definition name, Click OK
   3     Enter a Description for the Chartfield Combination Editing Definition
         Enter the chartfields required for the definition, make sure to enter your anchor
         chartfield in the first row, when you save the defintion the anchor field box will
         be checked

                                                                                     Expected Results
A new Combination Edit Definition was successfully created.




              Overall Script Results                           CF Test Script Sign-Off
         Pass                  Re Test Pass
         Fail                  Re Test Fail                                                                                 Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                  Last Revised on: 5/24/2005
       Worksheet: CF4                                                                                                        Last Printed on: 7/19/2010
                                                                  9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:     Create a Combination Rule
Scenario: Create a new Combo Edit Rule

                               Script Description                                                            Test Notes                           Initials
   1     Navigate to: Set Up Financials/Supply Chain>>Common Definitions>>
         Design Chartfields>>Combination Editing>>Combination Rule>>Add a
         new Value

   2     Your BU should default in, enter a rule name, Click OK
   3     On the Rule Definition panel add a description, effective date, and a
         combination definition
         Complete the Chartfield combination panel as appropriate for your rule.
   4     Save the Combination Rule

                                                                                   Expected Results
A new Combination Edit Rule was successfully created.




              Overall Script Results                         CF Test Script Sign-Off
         Pass                  Re Test Pass
         Fail                  Re Test Fail                                                                               Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                  Last Revised on: 5/12/05
       Worksheet: CF5                                                                                                      Last Printed on: 7/19/2010
                                                                 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:     Create a Combination Group and attach combination rules
Scenario: Create a new Combo Edit Group and attach combination rules

                                Script Description                                                          Test Notes                           Initials
   1     Navigate to: Set Up Financials/Supply Chain>>Common Definitions>>
         Design Chartfields>>Combination Editing>>Combination Group>>Add a
         new Value
   2     Your BU should default in, enter a rule name, Click OK

   3     Enter a Description for the Chartfield Combination Editing Group
         Select the Defintion and Combination Rule that you created in CF4 and CF5
   4     Save the Combination Group


                                                                                Expected Results
A new Combination Edit Group was successfully created and rules were attached as required.




              Overall Script Results                         CF Test Script Sign-Off
         Pass                  Re Test Pass
         Fail                  Re Test Fail                                                                              Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                               Last Revised on: 5/24/2005
       Worksheet: CF6                                                                                                     Last Printed on: 7/19/2010
                                                                    9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Run the Build Combination Data Process
Scenario: Create a Run Control to run the Build Combo Data process

                                Script Description                                                                       Test Notes                                          Initials
   1     Navigate to: Set Up Financials/Supply Chain>>Common Definitions>>
         Design Chartfields>>Combination Editing>>Build Combination
         Data>>Add a new Value
   2     Your BU should default in, enter TCOMBIBUILD for the Run Control ID.          Make sure that you "attach" this new Combo Edit Group to your BU before
         Click Save                                                                    running the Combo Build Process.
   3     Enter the Process request Parameters (make sure to update "as of Date) and
         Save.
         Run the process.
   4     Click on Process Monitor. Once the process shows Success, Review
         Combination Data
   5     Navigate to: Set Up Financials/Supply Chain>>Common Definitions>>
         Design Chartfields>>Combination Editing>>Review Combination Data
   6     Enter the Combination Group and Rule and the BU. Click Search.
   7     Review data and verify that output is what you expected.

                                                                                Expected Results
The Combo Build Process was successfully run and data was verified.




              Overall Script Results                         CF Test Script Sign-Off
         Pass                  Re Test Pass
         Fail                  Re Test Fail                                                                                                         Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                           Last Revised on: 5/24/2005
       Worksheet: CF7                                                                                                                                 Last Printed on: 7/19/2010
                                                                    9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Define a Chartfield Attribute
Scenario: Define a chartfield attribute

                                Script Description                                                             Test Notes                           Initials
   1     Navigate to: Set Up Financials/Supply Chain>>Common Definitions>>
         Design Chartfields>>Configure>>Attributes>>Chartfield Attributes>>Add a
         new Value

   2     Enter your SetID, the Fieldname (which actaully the chartfield you wish to
         attach the attribute to, and the Chartfield Atrribute
         Click Add
   3     Enter a description for your Attribute, then enter the detail values and Save

                                                                                    Expected Results
A Chartfiled Attribute was successfully created.




              Overall Script Results                           CF Test Script Sign-Off
         Pass                  Re Test Pass
         Fail                  Re Test Fail                                                                                 Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                    Last Revised on: 5/12/05
       Worksheet: CF8                                                                                                        Last Printed on: 7/19/2010
                                                                    9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Attach a Chartfield Attribute to a Department, Project or Class
Scenario: Attach a Chartfield Attribute to a Department, Project or Class

                                Script Description                                                                            Test Notes                           Initials
    1     Navigate to: Set Up Financials/Supply Chain>>Common Definitions>>
          Design Chartfields>>Define Values>>Chartfield Values>>Select
          Department, Project or Class>> Find Existing Value

    2     Select the Department, Project, or Class to which you want to attach an           Make sure to check the "Correct History" box
          Attribute
    3     Click on the Attribute Hyperlink and attach the Attributes as desired and Save.


                                                                                    Expected Results
A Chartfiled Attribute was successfully attached to a Chartfield.


               Overall Script Results                          CF Test Script Sign-Off
          Pass                  Re Test Pass
          Fail                  Re Test Fail                                                                                               Date:




        File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                                Last Revised on: 5/24/2005
        Worksheet: CF9                                                                                                                      Last Printed on: 7/19/2010
                                                                  9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Review Chartfileld Editing Combination Group Report
Scenario: Create and review GLC4003.

                               Script Description                                                            Test Notes                           Initials
   1     Navigate to: Set Up Financials/Supply Chain>>Common Definitions>>
         Design Chartfields>>Combination Editing>>Combination Group
         Report>>Combination Rule
   2     Add a new run control or use one that you have already set up. (I used
         ALLCRYSTAL).

   3     Your BU should have defaulted in. Click on Run.
   4     Click on Process Monitor. Once the process shows Success, Click on
         Details, Click on View Log/Trace, Click on the GLC4003 PDF File


                                                                                  Expected Results
Report GLS4002 was successfully created.




                Overall Script Results                       CF Test Script Sign-Off
         Pass                    Re Test Pass
         Fail                    Re Test Fail                                                                             Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                Last Revised on: 5/24/2005
       Worksheet: CF10                                                                                                     Last Printed on: 7/19/2010
                                                                  9b2d19ce-7ee8-4860-a04a-3133f0208047.xls

Test Objective:    Review Chartfileld Combination Rule Reports
Scenario: Create and review GLS4002.

                               Script Description                                                            Test Notes                           Initials
   1     Navigate to: Set Up Financials/Supply Chain>>Common Definitions>>
         Design Chartfields>>Combination Editing>>Combination Rule
         Report>>Combination Rule
   2     Add a new run control or use one that you have already set up. (I used
         ALLJOBS).

   3     Your BU should have defaulted in. Select a the new Combo Rule you created
         for review. Then click on Run.
   4     Click on Process Monitor. Once the process shows Success, Click on Details,
         Click on View Log/Trace, Click on the GLS4002 PDF File


                                                                                  Expected Results
Report GLS4002 was successfully created.




              Overall Script Results                         CF Test Script Sign-Off
         Pass                  Re Test Pass
         Fail                  Re Test Fail                                                                               Date:




       File Name: 9b2d19ce-7ee8-4860-a04a-3133f0208047.xls                                                                Last Revised on: 5/24/2005
       Worksheet: CF11                                                                                                     Last Printed on: 7/19/2010

								
To top