TE040 on FA ... Test Script on Fixed AssetsFull description
Sample General ledgers from our article in BusinessTips.PhFull description
SAP General Ledger End User ManualFull description
Descrição: Introduction to Migration to New General Ledger
SCRIPT SQL PARA BASE DE DATOSDescripción completa
Descripción completa
test generalDescripción completa
Descripción: test
Full description
SAP Test Script Template_PP
Mental Bank Ledger
rppl
Descrição completa
ok
Descripción: Prueba de confrontación, especialmente la que se emplea en pedagogía, psicotecnia, medicina, etc., para evaluar el grado de inteligencia, la capacidad de atención u otras aptitudes o conductas.
test
worksheetFull description
Descripción: Test del Título III de la ley 14/1986, 25 abril, General de Sanidad
Geology related objective questions, mostly asked during tests.
AIM
TE.040 S YSTEM TEST SCRIPT General Ledger Implementation
Author: Creation Date: Last Updated: Document Ref: Version:
Approvals:
TE.040 System Test Script
Doc Ref: Error: Reference source not found
Document Control Change Record 1
Date
Author
Versio n
Change Reference
Reviewers
Name
Position
Distribution
Copy No.
Name
Location
1 2 3 4 5
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.
General Ledger Implementation File Ref: 23219853.doc
Document Control ii
TE.040 System Test Script
Doc Ref: Error: Reference source not found
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 Specifications < Define New Accounting Periods >........... ....5 System Test Specifications < Define Conversion Rates >..........................6 System Test Test Specifications Specifications < Open / Close GL Accounting 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 Specifications < General Ledger Interface Interface >..................... ..13 System Test Specifications < Consolidation Run >..................................15 System Test Specifications < Period End Revaluation >..........................16 System Test Specifications Specifications < Reporting Reporting >............. >...............................................17 ..................................17 Defect Log.................................................................................................18 Open And Closed Issues For This Deliverable...........................................19 Open Issues.........................................................................................19 Closed Issues.......................................................................................19
General Ledger Implementation File Ref: 23219853.doc
Document Control ii
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 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
Century Date Compliance In the past, two character date coding was an acceptable convention due to perceived costs associated with the additional disk and memory storage requirements of full four character date encoding. As the year year 2000 approached, it became evident that a full four character coding scheme was more appropriate. In the context of the Application Implementation Method (AIM), the convention Century Date or C/Date support rather than Year2000 or Y2K support is used. It is felt that coding for any future Century Date is now the modern business and technical convention. Every applications implementation team needs to consider the impact of the Century Date Date on their implementation project. As part of the implementation effort, all customizations, legacy data conversions, and custom interfaces need to be reviewed for Century Date compliance. Testing activities need to make sure that all interfaces and application extensions are coded for Century Date compliance. System test scripts should include steps for testing Century Date compliance.
Document Control ii File Ref: 23219853.doc
Doc Ref:
System Test Sequences Sequenc e# 1.
2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14.
General Ledger Test Name
Maintaining Cross Validation rules Define New Ac Account Fl Flexfield Va 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 Ne New Ac Account Fl Flexfield Va Values Define New Accounting Periods Define Conversion Rates Open / Close GL Accounting Pe 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
Pass/Fail
Notes
Active Active Active Active Active Active Active Active Active Active Active Active Active Active
Document Control ii File Ref: 23219853.doc
Doc Ref:
System Test Specifications < Maintaining Cross Validation rules > Scenari o Step
1.1
Even t
Test Step
Role
Action or Path
Expected Results
Actual Results
Status
Test Step Details
Maintaining Cross Validation Rules
GL Supervisor
(N) Setup > Financials > Flexfields > Key > Rules
(M) View > Find… Search for your accounting flexfield structure Enter the validation Rule Name and Description. Enter the Error Message that to be used to guide the user on his journal entry accounting Flexfield to correct and validate combination. Enter the Error segment that shows the user what segment to update. It leaves the cursor in this segment whenever a segment combination violates this crossvalidation rule. Enter the Cross Validation Rule Elements: First Select Include for all the accounting range: From: 00-0000-000000-0000-0000-0000 99-9999-999999-9999-9999-9999 To: Second Select Exclude for the invalid combinations that Violates this Cross Validation rule. Save your Work.
- During the Journal entry only accounting Valid combinations is accepted by the system, and any accounting combinations that violates any of the Cross validation rules, the rule error message appears to the user.
Document Control ii File Ref: 23219853.doc
Doc Ref:
System Test Specifications < Define New Account COA Values > Scenari o Step
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 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 added to the Chart of Accounts and appears in the list of values showing the accounting values During the Journal Entry.
-
The COA value is deactivated. The list of values is not showing the deactivated value during the Journal Entry.
Document Control ii File Ref: 23219853.doc
Doc Ref:
System Test Specifications < Define New Accounting Periods > Scenari o Step
3.1
Even t
Test Step
Role
Action or Path
Expected Results Test Step Details
Defining New Accounting Periods
GL Supervisor
(N) Setup> Financials > Calendar > Accounting
(M) View > Find… (Select appropriate calendar) Enter the New Period Prefix Select the Period Type Enter the Year this Period Related to Enter the Sequence of this Period in its Year Enter the Quarter Number where this Period Belongs to Enter the Starting Calendar day where this Period Starts Enter the Ending Calendar day where this Period Ends Mark for the Adjusting period Check Box, Only if this period is an adjusting period Save your Work
-
-
Actual Results
Status
A new period is added to the company accounting periods The new defined periods its status is closed and can be opened later on.
Document Control ii File Ref: 23219853.doc
Doc Ref:
System Test Specifications < Define Conversion Rates > Scenari o Step
Even t
Test Step
Role
Action or Path
Expected Results
Actual Results
Status
Test Step Details
4.1
Defining Daily Conversion Rates
GL Supervisor
(N) Setup> Currencies > Rates > Daily
4.2
Defining Period Conversion Rates
GL Supervisor
(N) Setup> Currencies > Rates > Period
(B) Press “Enter by date range” Select the Currency you want to enter its conversion rate Enter the Date Range From Date and To Date for this conversion rate Select the Type as “Corporate” Enter the Conversion Rate (B) Apply (to apply this rates to the date range specified) Save your work Use the revaluation rate to revalue account balances that are denominated in a fo reign currency at the end of period Select the Currency you want to enter its conversion rate Select the Balance Type you want to revaluate with this period conversion rate (Actual / Budget) Select the accounting Period to which the rates apply. For actual balances, you can select any open, future-enterable, or closed accounting period. For budget balances, you can select any period up to the last period of the latest open budget year Enter the revaluation rate. Enter the rate that you multiply your foreign currency amount by to determine the functional currency equivalent Save your work -
-
-
Foreign currency journals can be entered and uses the specified corporate conversion rates
You can run revaluation using this period conversion rates
Document Control ii File Ref: 23219853.doc
Doc Ref:
System Test Specifications < Open / Close GL Accounting Periods > Scenari o Step
5.1
Test Step
Role
Action or Path
Event
PR_GL_01 EV_GL_02 Close / Open Period
5.2
5.3
Expected Results Test Step Details
Open First Accounting Period
GL Mana Manage gerr
Closing Accounting Period
GL Mana Manage gerr
Opening Next Accounting Period
GL Mana Manage gerr
(N) (N) Setu Setup> p> Open/Close
-
(N) (N) Setu Setup> p> Open/Close
-
(N) (N) Setu Setup> p> Open/Close
-
Choose the first period to open from List of Values (B) Press Open Period
Choose the Period you want to close Select from list of values to change it’s Status to Closed (B) Open Next Period in order to open the next period You can select Open from the list of values to open any closed period
-
-
-
-
Actual Results
Status
First Accounting period is Opened The Request Completed Normal The Period is Closed and no one can enter, post or update Journals in to this Period After the request completed, the Period is opened for Entry and Posting The following 1 period is opened as Future – Entry Period
Document Control ii File Ref: 23219853.doc
Doc Ref:
System Test Specifications < Enter Functional Currency Journals > Scenari o Step
6.1
Test Step
Role
Action or Path
Event
PR_GL_02 EV_GL_0 3 Source documen t arrival
Expected Results
Actual Results
Status
Test Step Details
Entering Functional Currency Journals
GL Accountan t
(N) Journal > Enter (B) New Journal
Enter Journal Header Information: Enter Journal Name: (Can be Characters, Numbers or Both, or you can leave it empty) Journal Period: (The Default period is Last Open Period / Batch period) Journal Date: (The effective date for the Journal) Journal Category: Journal Description: (This description will default to all journal lines) Control Amount: (Optional, used to control the total of your journal lines) Note: If Journal Name is not Specified the System Automatically gives the Journal a name Enter Lines Information: Line Number: Line Account: Line Amount: (Debit) Line Description: (Defaulted (Defaulted from the Journal Description) Line Amount: (Credit) Line Description: (Defaulted (Defaulted from the Journal Description) Enter all required journal lines: Save your Journal You Can Query on Entered Journals by the Following Attributes: Journal Name & Batch Name Period Category Currency Journal Source (Manual / Other Modules) Posting Status (Posted, Unposted, or Error) Document Numbers (From / To) Creation Dates (From / To) Chose the report name as (Journal – General (132 Char) Report, for unposted journals) Enter parameters for the journal entry recorded in step 6.1: (Journal Name, Currency, Period) Submit the Request with no of Copies equal 1 -
-
The Journal Saved The Document Number Created
6.2
Journal Inquiry
GL Accountan t
(N) Inquiry > Journal
-
Journal Entries that was recorded in step 6.1 could be retrieved for revision or correction
6.3
Printing the Journal Voucher
GL Accountan t
(N) Other > Report > Run (B) Single Request
-
-
Request Completed Normal and the Report Printed Data output is accurate and reflects actual data entered
Document Control ii File Ref: 23219853.doc
Doc Ref:
System Test Specifications Specifications < Enter Foreign Currency Journals > Scenari o Step
7.1
Test Step
Role
Action or Path
Event
PR_GL_02 EV_GL_0 3 Source documen t arrival
Expected Results
Actual Results
Status
Test Step Details
Entering Foreign Currency Journals
GL Accountan t
(N) Journal > Enter (B) New Journal
-
Perform the same steps of Entering Functional Journals as mentioned in senario step 6.1 Select the Foreign Currency Select the Date for conversion rate Select the conversion Type and Rate. Example:
Curren rrenc cy Rate Rate Type Type Rate
7.2
Journal Inquiry
GL Accountan t
(N) Inquiry > Journal
7.3
Printing the Journal Voucher
GL Accountan t
(N) Other > Report > Run (B) Single Request
-
-
-
USD User User 1. 229
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 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: All Journals and Batches o Single Batch o Single Journal o Submit the Request with no of Copies equal 1
-
-
-
The Foreign amount Converted to the Functional Amount Based on the Rate The Journal Saved The Document Number Created
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
Document Control ii File Ref: 23219853.doc
Doc Ref:
System Test Specifications < Journal Revision And Posting > Scenari o Step
8.1
Test Step
Role
Action or Path
Event
PR_GL_03 EV_GL_0 2
8.2
Expected Re Results Test Step Details
Printing the unposted Journal Voucher Posting the Journals
GL Supervisor
GL Manager
(N) Other > Report > Run (B) Single Request (N) Journals > Post
-
8.3
8.4
Account Inquiry
Account Balances Reports
GL Supervisor
GL Supervisor
(N) Inquiry > Account
(N) Other > Report > Run (B) Single Request
Chose the report name as (Journal – General (132 Char) Report, for unposted journals) Enter parameters for the journal entry recorded in step 6.1: (Journal Name, Currency, Period) Submit the Request with no of Copies equal 1 Select the required period, balance type (Actual), required batch name or leave blank to retrieve all unposted batches (B) Find to retrieve required unposted batches Mark the Check Box for the batches you want to post You can review any batch before posting (B) Post Batch status is “Posting”
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 p ressing (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 -
-
-
-
-
-
-
Actual Results
Status
Request Completed Normal and the Report Printed The request completes with no errors (the batch posted) The Accounts balances reflected in the Trial Balance Standard Report The Account Balance is correct The Variance is Calculated correct
Report output is consistent with actual data
Document Control ii File Ref: 23219853.doc
Doc Ref:
System Test Specifications < Define / Generate Recurring Journals > Scenari o Step
9.1
Test Step
Role
Action or Path
Event
PR_GL_07 EV_GL_0 7
9.2
Test Step Details
Define Recurring Journals
GL Supervisor
(N) Journals > Define > Recurring
Generate Recurring Journals
GL Supervisor
(N) Journals > Generate > Recurring
Enter a unique Name and optional Description for the batch (B) AutoCopy… (If you want to copy entries from an existing recurring journal batch Note: You should group your recurring entries into one batch to speed processing. Enter the recurring journal entry Name: Select the recurring journal entry Category: Select the recurring journal entry Currency: Optionally enter a range of Active Dates to limit the use of the recurring entry to a specific time (B) Press Lines (to enter the recurring journal lines information) Enter a Line number: Select the recurring journal line GL Account: Enter an optional Line Description: Enter a Formula for the line if this is a formula recurring entry. Otherwise, enter enter an amount for standard entries Note: you can leave the Formulas blank to create skeleton journal entries Note: If the formula amount is positive, your account will be debited. If the formula amount is negative, your account will be credited Formula Operators: Associate an operator with each step of the formula (Use Enter to store the associated number or Use (+) to add, (-) to subtract, (*) to multiply, (/) to divide the associated associated number into the most recently stored number) Enter all remaining lines for the recurring journal entry Save your work Select the Recurring Batch you want to generate Select the Accounting Period to create an unposted journal batch (B) Press Generate A concurrent request submitted to create the unposted journal batches (The resulting journal batch is named :