TE040 Test Script GL
TE040 Test Script GL
TE040 Test Script GL
Author: Creation Date: Last Updated: Document Ref: Version: May 30, 2005 February 10, 2006
Approvals:
Doc Ref:
Document Control
Change Record
1
Date
Author
Versio n
Change Reference
Reviewers
Name
Position
Distribution
Copy No. 1 2 3 4 5
Name
Location
Note To Holders: If you receive an electronic copy of this document and print it out, please write your name on the equivalent of the cover page, for document control purposes. If you receive a hard copy of this document, please write your name on the front cover, for document control purposes.
Doc Ref:
Contents
Document Control.......................................................................................ii Overview.....................................................................................................1 Century Date Compliance.....................................................................1 System Test Sequences..............................................................................2 System Test Specifications < Maintaining Cross Validation rules >...........3 System Test Specifications < Define New Account COA Values >..............4 System Test Specifications < Define New Accounting Periods >...............5 System Test Specifications < Define Conversion Rates >..........................6 System Test Specifications < Open / Close GL Accounting Periods >........7 System Test Specifications < Enter Functional Currency Journals >..........8 System Test Specifications < Enter Foreign Currency Journals >...............9 System Test Specifications < Journal Revision And Posting >..................10 System Test Specifications < Define / Generate Recurring Journals >.....11 System Test Specifications < Reverse Journal Entries >..........................12 System Test Specifications < General Ledger Interface >.......................13 System Test Specifications < Consolidation Run >..................................15 System Test Specifications < Period End Revaluation >..........................16 System Test Specifications < Reporting >...............................................17 Defect Log.................................................................................................18 Open And Closed Issues For This Deliverable...........................................19 Open Issues.........................................................................................19 Closed Issues.......................................................................................19
Doc Ref:
Overview
This System Test Script documents the steps needed to test the integration of application extensions with the target application system with respect to the General Ledger process. System testing measures the quality of the entire application system, using system test sequences and scripts. You must create scripts for all business processes based on the Mapped Business Requirements (BR.030); however, the focus of business solution testing is confirming individual business processes, while business system testing focuses on confirming the collective application system. This system test will include the following types of testing: Integrated Business Processes Security Testing
Doc Ref:
General Ledger Test Name Maintaining Cross Validation rules Define New Account Flexfield Values Define New Accounting Periods Define Conversion Rates Open / Close GL Accounting Periods Enter Functional Currency Journals Enter Foreign Currency Journals Journal Revision And Posting Reverse Journal Entries Enter Budget Journals General Ledger Interface Consolidation Run Period End Revaluation Reporting
Description Maintaining Cross Validation rules Define New Account Flexfield Values Define New Accounting Periods Define Conversion Rates Open / Close GL Accounting Periods Enter Functional Currency Journals Enter Foreign Currency Journals Journal Revision And Posting Reverse Journal Entries Enter Budget Journals General Ledger Interface Consolidation Run Period End Revaluation Reporting
Test er
Test Status Active Active Active Active Active Active Active Active Active Active Active Active Active Active
Pass/Fail
Notes
Doc Ref:
Doc Ref:
System Test Specifications < Define New Account COA Values >
Scenari o Step 2.1 Even t Test Step Defining New Chart of Accounts segment Values Role GL Supervisor Action or Path Test Step Details (N) Setup > Financials > Flexfields > Key > Values Select Application: (Oracle General Ledger) Select Title: (Accounting Flexfield) Select Structure Select the segment that you want to add to it a new value (B) Find Move to Values section (M) File > New Enter the new value Enter the new value description Only if entering a value for the Natural account Segment, you must specify the qualifier Account type (Asset, Liability, Expense, Revenue, Ownership/Stockholder's Equity) Save your Work Select Application: (Oracle General Ledger) Select Title: (Accounting Flexfield) Select Structure Select the segment that you want to add to it a new value (B) Find Move to Values section (M) View > Find, to search for the value you want to deactivate Uncheck the Enabled check box, in order to deactivate the COA vaule Save your Work - New value is added to the Chart of Accounts and appears in the list of values showing the accounting values During the Journal Entry. Expected Results Actual Results Status
2.2
GL Supervisor
(N) Setup > Financials > Flexfields > Key > Values
The COA value is deactivated. The list of values is not showing the deactivated value during the Journal Entry.
Doc Ref:
Doc Ref:
4.2
GL Supervisor
Doc Ref:
5.2
5.3
Doc Ref:
6.2
Journal Inquiry
GL Accountan t
Journal Entries that was recorded in step 6.1 could be retrieved for revision or correction
6.3
GL Accountan t
Request Completed Normal and the Report Printed Data output is accurate and reflects actual data entered
Doc Ref:
Save your Journal Query on the entered Journals from the Journals window itself, using the same search components as in scenario step 6.2 Suggestion: Query on the Foreign Currency Journals by selecting the required currency Select the report from the list of values Select Journals Foreign Currency (132 Char) to review Foreign Currency Journals According to the report parameters you can print the following data: o All Journals and Batches o Single Batch o Single Journal Submit the Request with no of Copies equal 1
7.3
GL Accountan t
Foreign Currency Journal Entries that was recorded in step 7.1 could be retrieved for revision or correction Request Completed Normal and the Report Printed Data output is accurate and reflects actual data entered
Doc Ref:
8.2
GL Manager
8.4
GL Supervisor
Select the Accounting Periods you want to inquire the Account in it Choose if you want to inquire for the Account balance on a Single Currency (Select the Currency) or All Currencies Choose the Primary Account Balance Type you want to inquire (Actual / Budget / Encumbrance) Press Tabs till you reach to the Find Accounts Popup window Enter from: Accounts To: Accounts you want to inquire about (B) Show Balances (B) Journal Details if you want more details You can query the original journal entry by pressing (B) show full journal In case of this Account Journals entered in AP or AR or Assets, you can press (B) Drilldown to review the Sub ledger Details In case there is a budget amount on this Account Choose the Secondary Account Balance Type as Budget and enter the Budget Name then Press (B) Show Variance Account Balance information appears Select your reports from the List of Values, to view the Accounts Movements and Balances run the following reports: - Account Analysis (132 / 180 Char) - General Ledger (132 /180 Char) - Trail Balance Report
Doc Ref:
9.2
GL Supervisor
Doc Ref:
10.2
GL Supervisor
Reversed Journals posted The Account Balance for these transactions net to Zero balance again
Doc Ref:
11.2
GL Supervisor
11.3 Correctin g Imported Journals Viewing Imported Journals Posting Imported Journals Account Inquiry GL Supervisor 11.7 Account Reports GL Supervisor (N) Other > -
(N) Journals > Import > Correct (N) Journals > Enter (N) Journals > Post (N) Inquiry > Accounts
(B) Press Find to view all your requests Find your Import request by request number If the request Completed Normal press view output Button The output file is an execution report showing if there is any error in the journals you are importing, error lines and the error code for each line (like EF04). At the end of this report there is an Error Key to find out the error code meaning (Like EF04: These segment values are not a valid account. Check your cross validation rules) If the request Completed with error press Log File Button, In this case you should inform your System Administrator Find the required journal from the Journal Source Correct the journal lines Save your work (B) Press Import (repeat step 12.1) Query the Imported Journal Batch Review the Journal Header Information Review the Journal Lines Information Query the required batch Mark the Check Box (B) Press Post Select the Period range you want to inquire for it Select the Currency Press Tabs till you reach the Find Accounts Popup window Enter From: Accounts To: Accounts you need to inquire (B) Press Show Balance (B) Press Journal Details if you want more details (B) Press Show full Journal to view the original journal entry Print Account Balance Reports (General Ledger) to review the account balance
The request exist The Output File Viewed The Log File Viewed Note: the request may complete with status Normal but when you view the output file the journals may have errors. This different than the request Completed with Error
11.4
11.5
When you save the correction the line status will change to Corrected The required journal imported & can be posted The Document Number Created All Imported Journals Information exists and correct The Batch Posted The Account balances updated The Account Balance is Correct
11.6
The report completed Normally The Account Balance is Correct Open And Closed Issues For This Deliverable
Doc Ref: Scenari o Step Test Step Event Report > Run Action or Path Test Step Details
Role
Expected Results
Actual Results
Status
Doc Ref:
The Doc. # Created All created Journals Information correct The Batch Posted The Account balances updated The report completed Normally The Account Balance is Correct
12.3
12.4
Doc Ref:
13.2
GL Superviso r
The period end financial reporting correct and reflects the fluctuation in the exchange rate
13.3
GL Superviso r
(N) Journal > Enter (B) Find (B) Review Journal (B) More Details
Reversal Request completes normal The Revaluation Journals batch reversed and posted in the next period The Account Balance for these transactions net to Zero balance again
Doc Ref:
14.2
GL Supervisor
The request completes with no errors The FSG Reports generated consistent with the data
Doc Ref:
Defect Log
Defect ID Number Test Step Referenc e Module Name Defect Description Resolution Re-Test By Re-Test Date Pass/Fail Status (open, closed, in process)
Doc Ref:
ID
Issue
Resolution
Responsibility
Target Date
Impact Date
Closed Issues
ID
Issue
Resolution
Responsibility
Target Date
Impact Date