te040 r12 cash management test scripts
TRANSCRIPT
Cash Management v1.0
USER ACCEPTANCETEST SCRIPTS
User Acceptance Test ScriptsCash Management
TABLE OF CONTENTSSECTION 1 PRE-REQUISITE STEPS OVERVIEW..........................................................................1
1.1 UAT SEQUENCE SUMMARY....................................................................................................................200.0 PRE-REQUISITE STEPS...........................................................................................................................3
00.1 Cash Management System Parameter..............................................................................................300.2 Define Banks.....................................................................................................................................500.3 Bank Statement Mapping................................................................................................................1100.4 Bank Transaction Codes.................................................................................................................1200.5 Bank Account Transfer Sub-Type...................................................................................................15
SECTION 2 MANAGE BANK STATEMENTS OVERVIEW.........................................................16
2.1 UAT SEQUENCE SUMMARY..................................................................................................................1710.0 MANAGE BANK STATEMENTS.............................................................................................................18
10.1 Manually Enter Bank Statements...................................................................................................1810.2 Uploading of Bank Statements.......................................................................................................20
SECTION 3 MANAGE BANK RECONCILIATION OVERVIEW................................................24
3.1 UAT SEQUENCE SUMMARY..................................................................................................................2520.0 MANAGE BANK RECONCILIATION......................................................................................................26
20.1 Manual Reconciliation...................................................................................................................2620.2 AutomaticReconciliation................................................................................................................2820.3 Reconciling Items...........................................................................................................................31
SECTION 4 MANAGE INTER-BANK ACCOUNT TRANSFERS OVERVIEW..........................34
4.1 UAT SEQUENCE SUMMARY..................................................................................................................3530.0 MANAGE INTER-BANK ACCOUNT TRANSFERS...................................................................................36
30.1 Initiate Inter-Bank Account Transfers............................................................................................3630.2 Validate Inter-Bank Account Transfers..........................................................................................3830.3 Authorize Inter-Bank Account Transfers........................................................................................3930.4 Create Accounting Inter-Bank Account Transfers.........................................................................40
SECTION 5 MANAGE PETTY CASH FUND OVERVIEW............................................................43
5.1 UAT SEQUENCE SUMMARY..................................................................................................................4440.0 MANAGE PETTY CASH FUND..............................................................................................................45
40.1 Request for Petty Cash Fund..........................................................................................................4540.2 Setup Petty Cash Fund...................................................................................................................4640.3 Petty Cash Fund Replenishment.....................................................................................................4940.4 Petty Cash Liquidation...................................................................................................................54
User Acceptance Test ScriptsCash Management
Section 1 Pre-requisite Steps Overview
This Test Scripts documents the steps needed to demonstrate the functionality of Oracle Cash Management.
DEMO’s numerous banks will be maintain in the cash management module. Banks should be define in order to make check payments in Oracle Payables, issue receipts in Oracle Receivables and reconcile cash in Oracle Cash Management.
This UAT Session will include the following processes:
Cash Management System Parameter
Define Banks
Bank Statement Mapping
Bank Transaction Codes
1
User Acceptance Test ScriptsCash Management
1.1 UAT Sequence Summary
Sequence #
Ref Date Time Process Name Description Participant UAT Status
Result Remarks
00.0 Pre-requisite Steps00.1 CM FS 1.01 Cash Mgt. System Parameter00.2 CM FS 1.01 Setup Banks00.3 CM FS 1.02 Define Bank Statement
Mapping00.4 CM FS 1.03 Define Bank Transaction
Codes00.5 CM FS 5.0.2 Bank Transfer Sub-Type10.0 Manage Bank Statements20.0 Manage Bank Reconciliation30.0 Manage Inter-Bank Account
Transfer40.0 Manage Petty Cash Fund
For Testers to Confirm UAT Results at each UAT Session Close:
UAT Tester Name & Signature: _______________________
UAT Lead Name & Signature: ________________________
UAT Date & Time of Certification: _____________________
2
User Acceptance Test ScriptsCash Management
00.0 Pre-requisite StepsBusiness Flow: Cash Management Pre-requisite Steps
Summary Process: Process of setting up Cash Management
Process:
00.1 Cash Management System Parameter
Description:
Process of setting up CM system paramters
ScenarioStep
Business Process Name Participant Action or Path Input Data Expected Results
Actual Results Status Remarks
00.1.1 Login/ Choose Responsibility
Browse to Application URL. http://oracle-uat-1.DEMOproj.com:8006
Enter your:
Click on Login.
Select as applicable:HO – DEMO CM Super UserPDO – VIS CM Super UserPMO – ILO CM Super User
Username: Your UsernamePassword: Your Password
Please note: If this is the first time you are logging in as this user, login with the default password of Welcome, and change the default password to your password.
Navigator will display.
00.1.2 Define System Parameters
Navigate to the Setup pageMenu: Setup > System > System Parameters
Enter the following information
Under the System Controls TabReconciliation Controls Region
Signing Authority Approval Region
Archive/Purge Region
DON’T UPDATE(Ctrl F11 to view)
Legal Entity: Your Company LELedger: Your CompanyBegin Date: 01-Jan-1920
Show Cleared Transactions: Show Void Payments: Allow Adding Lines to Imported Statements: Workflow Enabled: Manually Controlled:
Purge: Archive: Lines Per Commit: Leave Blank
System Parameters window is displayed
3
User Acceptance Test ScriptsCash Management
ScenarioStep
Business Process Name Participant Action or Path Input Data Expected Results
Actual Results Status Remarks
Under Cash Management Transactions Tab
Accounting Region
Bank Account Transfer
Exchange Rate Type: CorporateBank Statement Cashflow Rate Date: Cashflow DateBank Transfer Rate Date: Transfer Date
Authorization: RequiredSystem Parameter has been setup
4
User Acceptance Test ScriptsCash Management
Process:
00.2 Define Banks
Description:
Process of defining Bank Names, Bank Branches and Bank Accounts.
ScenarioStep
Business Process Name Participant Action or Path Input Data Expected Results
Actual Results Status Remarks
00.2.1 Login/ Choose Responsibility
Browse to Application URL. http://oracle-uat-1.DEMOproj.com:8006
Enter your:
Click on Login.
Select as applicable:HO CM Super UserPDO CM Super UserPMO CM Super User
Username: Your UsernamePassword: Your Password
Please note: If this is the first time you are logging in as this user, login with the default password of Welcome, and change the default password to your password.
Navigator will display.
00.2.2 Define Bank Name
Navigate to the Manage Banks and Branches window, Menu: Setup > Banks > Banks
1.Click Create button
Bank Information
Select Create a new bank
Enter (Optional)
Select Save and Next to enter Bank Address information.
Bank Address
Click Create button.
Enter the following information
Country Name: Your ChoiceBank Name: Your (Surname) Bank
Alternative Bank Name: Your (Surname) BankShort Bank Name: Your InitialsBank Number: Leave BlankDescription: Create your ownTaxpayer ID: Leave BlankTax Registration Number: Create Your Own
Country: Phlippines
Manage Banks and Branches window is displayed
Bank Address window appeared
5
User Acceptance Test ScriptsCash Management
Select Apply to save the address.
Click Save and Next to enter Bank Contact Information.
Contact Information
Click Create Contact
Enter Contact Information.
Optionally enter
Select Apply to save the contact.
Select Finish to complete the bank creation.
Then click the
Address: Create Your Own
First Name: Your First NameLast Name: Your Last NameRegistry ID: Any NumberStart Date: Current DateEmail: Your Email AddressPhone no: Any NumberAddress: Create Your Own
Bank Contact Information window appeared
Bank Name created & saved
00.2.3 Define Bank Branch
Pre-requisite: Bank Name has been defined.
Navigate to the Manage Banks and Branches window
Menu: Setup > Banks > Banks
Go to the Bank Branches Tab.
Click the Create button
Create Bank Branch
Click Continue
Bank Branch Information
Enter the following information
Country: Your ChoiceBank Name: Your Created Bank
Branch Options: Create New BranchBranch Name: Your (Surname) BranchAlternate Branch Name: Your (Surname) BranchBranch Number: Create Your Own
Manage Banks and Branches window is displayed
6
User Acceptance Test ScriptsCash Management
Click Save and Next to enter Bank Branch Address information.
Bank Branch Address
Click Create button.
Select Apply to save the address.
Select Save and Next to enter Bank Branch Contact Information.
Contact Information
Click Create Contact
Enter Contact Information.
Optionally enter
Select Apply to save the contact.
Select Finish to complete the bank creation.
Then click the
BIC: Leave BlankBranch Type: OthersEDI Location: Leave BlankEFT Number: Leave BlankDescription: Create Your OwnRFC Identifier: Leave BlankInactive Date: Leave Blank
Country: Your ChoiceAddress: Create Your Own
First Name: Your First NameLast Name: Your Last NameRegistry ID: Any NumberStart Date: Current DateEmail: Your Email AddressPhone no: Any NumberAddress: Create Your Own
Bank Branch Address window appeared
Bank Branch Contact Information window appeared
Bank Branch created & saved
00.2.4 Define Bank Account
Pre-requisite: Bank Name & Bank Branch has been defined.
Navigate to Manage Bank Accounts window.
Menu: Setup > Banks> Bank Accounts
Click the Create button
Create Bank Account
Click Continue
Select
Country: Your ChoiceBank Name: Your Created BankBranch Name: Your Created Bank BranchBank Account Owner: Your Company
Manage Banks and Branches window is displayed
Create Bank Account window appeared
7
User Acceptance Test ScriptsCash Management
Types of functions that this bank account is going to be used for:
For Disbursement Account = Payables
For Depository Account = Receivables
Click Next to enter the Account Information.
Click Save and Next for the Account Controls.
Enter the following information
General Controls
Cash Management Controls
Payables: Payroll: Receivables: Treasury:
Account Name: Your (Surname) Bank AccountAlternate Account Name: BlankShort Account Name: Your InitialsAccount Number: Any NumberCurrency: SGDMultiple Currencies Allowed: IBAN: Leave BlankAccount Type: OthersAccount Suffix: Leave BlankEFT Number: Leave BlankSecondary Account Reference: Leave BlankAccount Holder: DEMOAlternate Account Holder: BlankDescription: Leave BlankStard Date: Leave BlankEnd Date: Leave Blank
Cash: Your OU code-0000-Cash Account-0000000-0000-0000Example: 1100-0000-11102103-0000000-0000-0000Bank Charges: Your OU code-0000-65060100-0000000-0000-0000Foreign Exchange Charges: Leave BlankNetting Account: Leave BlankCash Clearing: Leave BlankBank Errors: Leave BlankAgency Location Code: Leave Blank
Minimum Target Balance: Leave BlankMaximum Target Balance: Leave BlankMinimum Payment Amount: Leave BlankMaximum Receipt Amount: Leave Blank
Account Information window is displayed
Account Controls window appeared
8
User Acceptance Test ScriptsCash Management
Receivable Controls
Payable Controls
Reconciliation Controls
Foreign Currency Bank
Open Interface Controls
Manual Reconciliation Tolerances
Auto Reconciliation Tolerances
Receipts
Payments
Cashflows
Rounding Factor: Leave BlankCash Flow Display Order: Leave BlankRounding Rule: Leave Blank
Multiple Currency Receipts:
Multiple Currency Payments: Pooled Amount: Minimum Payment: Allow Zero Payments: Maximum Outlay: Leave BlankMaximum Payment: Leave Blank
Payables Matching Order 1: TransactionPayables Matching Order 2: BatchFloat Handling: IgnoreRecievable Matching Order: Transaction
Exchange Rate Type: Leave BlankExchange Rate Date: Statement Line Date
Use Reconciliation Open Interfaces: Float Status: Leave BlankOpen Interface Matching Criteria: Transaction NumberClear Status: Leave Blank
Tolerance Amount: Leave BlankTolerance Percentage: Leave Blank
Tolerance Amount: 0Foreign Tolerance Differences: Leave BlankTolerance Percentage: 0
Tolerance Amount: 0Foreign Tolerance Differences: Leave BlankTolerance Percentage: 0Tolerance Differences: Leave Blank
Tolerance Amount: 0Foreign Tolerance Differences: Leave Blank
9
User Acceptance Test ScriptsCash Management
Open Interface
Click Click Save and Next for the Account Access tab.
Click Add Organization Access
Choose the following Account Use
Click the Continue Button
Click Apply
Click Create Contact
Enter Contact Information.
Optionally enter
Select Apply to save the contact.
Select Finish to complete the bank creation.
Then click the
Tolerance Percentage: 0Tolerance Differences: Leave Blank
Tolerance Amount: 0Tolerance Percentage: 0
Payables: Payroll: Receivables: Treasury: Organization: Your Operating Unit
End Date: Leave Blank
First Name: Your First NameLast Name: Your Last NameRegistry ID: Any NumberStart Date: Current DateEmail: Your Email AddressPhone no: Any NumberAddress: Create Your Own
Account Access window appeared
Account Contact window is displayed
Bank Account created & saved
10
User Acceptance Test ScriptsCash Management
Process:
00.3 Bank Statement Mapping
Description:
Process of mapping the bank statement to DEMO’s required format.
ScenarioStep
Business Process Name Participant Action or Path Input Data Expected Results
Actual Results Status Remarks
00.3.1 Login/ Choose Responsibility
Browse to Application URL. http://oracle-uat-1.DEMOproj.com:8006
Enter your:
Click on Login.
Select as applicable:HO CM Super UserPDO CM Super UserPMO CM Super User
Username: Your UsernamePassword: Your Password
Please note: If this is the first time you are logging in as this user, login with the default password of Welcome, and change the default password to your password.
Navigator will display.
00.3.2 Bank Statement Mapping
Navigate to the Bank Statement Mapping windowMenu: Setup > Banks > Bank Statement Mappigns
Search window appears, Click Cancel
Enter the following information
Click the Populate button
Under the Headers Tab
DON’T UPDATE(Ctrl F11 to view)
Name: DEMO_STMTEnable: Description: Mapping TemplateControl File: DEMO_BankStmt.ctlPrecision: Leave BlankDate Format: YYMMDDTimestamp Format: Leave BlankBank File Format Type: DEMO_STMT
STATEMENT_NUMBER: 28 ; 1BANK_ACCOUNT_NUM: 25 ; 1STATEMENT_DATE: 62; 3BANK_NAME: Leave BlankBANK_BRANCH_NAME: Leave BlankCONTROL_BEGIN_BALANCE: 60 ;
Bank Statement Mapping widow is displayed
11
User Acceptance Test ScriptsCash Management
Under the Lines Tab
Click the Save Icon
Then click the Close Form Icon
5CONTROL_END_BALANCE: 62 ; 5CONTROL_TOTAL_DR: Leave BlankCONTROL_TOTAL_CR: Leave BlankCONTROL_DR_LINE_COUNT: Leave BlankCONTROL_CR_LINE_COUNT: Leave BlankCONTROL_LINE_COUNT: Leave BlankCURRENCY_CODE: 60 ; 4CHECK_DIGITS: Leave BlankPRECISION: Leave BlankAVAILABLE_BALANCE: 64 ; 4VALUE_DATE_BALANCE: 64 ; 4
STATEMENT_NUMBER: Leave BlankBANK_ACCOUNT_NUM: Leave BlankLINE_NUMBER: Leave BlankTRX_DATE: 61 ; 1TRX_CODE: 61 ; 8EFFECTIVE_DATE: Leave BlankAMOUNT: 61 ; 5CURRENCY_CODE: Leave BlankUSER_EXCHANGE_RATE_TYPE: Leave BlankEXCHANGE_RATE_DATE: Leave BlankEXCHANGE_RATE: Leave BlankTRX_TEXT: 61 ; 9INVOICE_TEXT: Leave BlankBANK_TRX_NUMBER: 61 ; 7ORIGINAL_AMOUNT: Leave BlankCHARGES_AMOUNT: Leave BlankCUSTOMER_TEXT: Leave BlankBANK_ACCOUNT_TEXT: Leave BlankPRECISION: Leave Blank
Bank Statement mapped
Process:
00.4 Bank Transaction Codes
Description:
Process of defining Bank Transaction Codes.
12
User Acceptance Test ScriptsCash Management
ScenarioStep
Business Process Name Participant Action or Path Input Data Expected Results
Actual Results Status Remarks
00.4.1 Login/ Choose Responsibility
Browse to Application URL. http://oracle-uat-1.DEMOproj.com:8006
Enter your:
Click on Login.
Select as applicable:HO CM Super UserPDO CM Super UserPMO CM Super User
Username: Your UsernamePassword: Your Password
Please note: If this is the first time you are logging in as this user, login with the default password of Welcome, and change the default password to your password.
Navigator will display.
00.4.2 Define Bank Transaction Codes
Navigate to the Bank Transaction Codes windowMenu: Setup > Banks > Bank Transaction Codes
Click the Find Icon
Search for Your Created Bank Account
Enter the following information1st Row
2nd Row
Type: PaymentCode: WDRAWDescription: WITHDRAWALEffective Start Date: 01-Jan-2000Effective End Date: Leave BlankFloat Days: Leave BlankTrans Source: AP PaymentsReconciliation Sequence: 1Payroll Payment Format: Leave BlankPayroll Matching Order: Leave BlankMatching Against: Leave BlankCorrection Method: Leave BlankCreate: Leave BlankActivity: Leave BlankReceipt Method: Leave Blank
Type: Receipt
Bank Transaction Code window is displayed
Search window appeared
13
User Acceptance Test ScriptsCash Management
Click the Save Icon
Then click the Close Form Icon
Code: DEPDescription: DEPOSITEffective Start Date: 01-Jan-2000Effective End Date: Leave BlankFloat Days: Leave BlankTrans Source: AR ReceiptsReconciliation Sequence: 1Payroll Payment Format: Leave BlankPayroll Matching Order: Leave BlankMatching Against: Leave BlankCorrection Method: Leave BlankCreate: Leave BlankActivity: Leave BlankReceipt Method: Leave Blank
Bank Transaction Code Saved
14
User Acceptance Test ScriptsCash Management
Process:
00.5 Bank Account Transfer Sub-Type
Description:
Process of defining Bank Account Transfer Sub-type.
ScenarioStep
Business Process Name Participant Action or Path Input Data Expected Results
Actual Results Status Remarks
00.5.1 Login/ Choose Responsibility
Browse to Application URL. http://oracle-uat-1.DEMOproj.com:8006
Enter your:
Click on Login.
Select as applicable:HO CM Super UserPDO CM Super UserPMO CM Super User
Username: Your UsernamePassword: Your Password
Please note: If this is the first time you are logging in as this user, login with the default password of Welcome, and change the default password to your password.
Navigator will display.
00.5.2 Define Bank Account Transfer Sub-type
Navigate to the Bank Transaction Codes windowMenu: Setup > System > Transaction Subtype
Click the Create button
Enter the following information
Click Apply
Then click the
Subtype Name: Your (Surname) TransferShort Name: Your InitialsSubtype Parent Name: Leave BlankDescription: Your (Surname) Transfer
Transaction Subtype window appeared
Created Transaction Subtype.
15
User Acceptance Test ScriptsCash Management
Section 2 Manage Bank Statements Overview
This Test Scripts documents the steps needed to demonstrate the functionality of Oracle Cash Management.
Bank Statements can be manually encoded in the system or can be uploaded using the standard functionality of Oracle Cash Management.
This UAT Session will include the following processes:
Manually enter Bank Statement Header
Manually enter Bank Statement Lines
Load Bank Statement
Import Bank Statement
16
User Acceptance Test ScriptsCash Management
1.2 UAT Sequence Summary
Sequence #
Ref Date Time Process Name Description Participant UAT Status
Result Remarks
00.0 Pre-requisite Steps
10.0 Manage Bank Statements
10.1 CM FS 2.01 to 2.02
Manually Enter Bank Statements
10.2 CM FS 2.03 to 2.04
Upload Bank Statements
20.0 Manage Bank Reconciliation30.0 Manage Inter-Bank Account
Transfer40.0 Manage Petty Cash Fund
For Testers to Confirm UAT Results at each UAT Session Close:
UAT Tester Name & Signature: _______________________
UAT Lead Name & Signature: ________________________
UAT Date & Time of Certification: _____________________
17
User Acceptance Test ScriptsCash Management
10.0 Manage Bank StatementsBusiness Flow: Manage Bank Statements
Summary Process: Process of entering or uploading Bank Statements.
Process:
10.1 Manually Enter Bank Statements
Description:
Process of manually encoding the Bank Statement to the system.
ScenarioStep
Business Process Name Participant Action or Path Input Data Expected Results
Actual Results Status Remarks
10.1.1 Login/ Choose Responsibility
Browse to Application URL. http://oracle-uat-1.DEMOproj.com:8006
Enter your:
Click on Login.
Select as applicable:HO CM Super UserPDO CM Super UserPMO CM Super User
Username: Your UsernamePassword: Your Password
Please note: If this is the first time you are logging in as this user, login with the default password of Welcome, and change the default password to your password.
Navigator will display.
10.1.2 Manually Enter Bank Statement Header
Navigate to Bank Statements window
Menu: Bank Statements > Bank Statements and Reconciliation
Click New button
Enter the following bank header information:
Account Number: Your created Bank Account NumberAccount Name: Your Bank Account NameBank Name: Your Bank NameBank Branch: Your Bank BranchDate: Current Date
Bank Statement window is displayed
18
User Acceptance Test ScriptsCash Management
ScenarioStep
Business Process Name Participant Action or Path Input Data Expected Results
Actual Results Status Remarks
Optionally, enter in the
Control Totals:
Line Totals
Click the Save Icon
Then click the Close Form Icon
Currency: SGDDocument Number: Leave BlankStatement Number: Your Bank Statement NumberGL Date: CurrentCheck Digits: Leave Blank
Opening Balance: Any amountReceipts: Leave BlankReceipt Lines: Leave BlankPayments: Leave BlankPayment Lines: Leave BlankClosing Balance: Leave BlankAvailable Balance: Leave BlankValue Dated Balance: Leave Blank1 Day Float: Leave Blank2 Day Float: Leave Blank
Opening Balance: DefaultedReceipts: DefaultedReceipt Lines: DefaultedPayments: DefaultedPayment Lines: DefaultedClosing Balance: DefaultedUnreconciled: DefaultedComplete:
Bank Statement Header created
10.1.3 Entering Bank Statement Lines
Navigate to Bank Statements window
Menu: Bank Statements > Bank Statements and Reconciliation
Query the earlier created Bank Statement Header
Statement Number: Your Bank Statement Number
Bank Statement window is displayed
19
User Acceptance Test ScriptsCash Management
ScenarioStep
Business Process Name Participant Action or Path Input Data Expected Results
Actual Results Status Remarks
Click the Lines button
Under the Amounts Tab
1st Row
2nd Row
Click the Save Icon
Then click the Close Form Icon
Line: 1Type: PaymentCode: WDRAWNumber: Check NumberTranscation Date: Current DateValue Date: Leave BlankAmount: Check AmountAmount Reconciled: DefaultedCharges: Leave BlankStatus: Defaulted “Unreconciled”
Line: 2Type: ReceiptCode: DEPNumber: Receipt NumberTranscation Date: Receipt DateValue Date: Leave BlankAmount: Receipt AmountAmount Reconciled: DefaultedCharges: Leave Blank
Status: Defaulted “Unreconciled”
Bank Statement Line appeared
Bank Statement Lines created
Process:
10.2 Uploading of Bank Statements
Description:
Process of uploading bank statements.
20
User Acceptance Test ScriptsCash Management
ScenarioStep
Business Process Name Participant Action or Path Input Data Expected Results
Actual Results Status Remarks
10.2.1 Login/ Choose Responsibility
Browse to Application URL. http://oracle-uat-1.DEMOproj.com:8006
Enter your:
Click on Login.
Select as applicable:HO CM Super UserPDO CM Super UserPMO CM Super User
Username: Your UsernamePassword: Your Password
Please note: If this is the first time you are logging in as this user, login with the default password of Welcome, and change the default password to your password.
Navigator will display.
10.2.2 Load Bank Statement Pre-requisites:
1. Create a SQL*Loader script for the format of your bank statement file, if it is neither BAI2 nor SWIFT940.
2. Fill up the mapping template for the format of your bank statement file.
3. Place your bank statement file in a directory
Navigate to the Submit Requests window.
Menu: View > Request > Submit Request
Submit a concurrent request
MISD Process
Name: Bank Statement Loader ProgramOptions: LoadMapping Template: DEMO_STMTFilename: Your Bank Statement file saved in the DatabasePath: Path where you save the fileBank Branch Name: Your Bank
Submit new Request is displayed
21
User Acceptance Test ScriptsCash Management
Submit the program.
Check the SQL*Loader log file and the Bank Statement Loader Execution Report to see any exceptions generated during the loading process.
Then click the Close Form Icon
BranchBank Account Number: Your Bank Account NumberGL Date: Current DateReceivable Activity: Leave BlankNSF Handling: Leave BlankPayment Method: Leave Blank
Bank Statement Loaded
10.2.3 Import Bank Statement Navigate to the Submit Request
window.
Menu: View > Request > Submit Request
Run Request
Submit your request.
Review and correct any import validation errors, then repeat the steps above.
Then click the Close Form Icon
Name: Bank Statement Import programBank Account Number: Your Bank Account NumberStatement Number From: Your Bank StatementStatement Number To: Your Bank StatementStatement Date From: Leave BlankStatement Date To: Leave BlankGL Date: Current Date
Submit new Request is displayed
Bank Statement Imported
10.2.4 Run NGAS – Cash in Bank Register Report
Navigate to the Request page.Menu: View > Requests
Select “Single Request” and click OK
Submit Request window is displayed
22
User Acceptance Test ScriptsCash Management
Choose Report Name
Enter parameters
Click the Submit button
Submit a New Request? Click NO
Click the Find button
Click the Referesh button and monitor request status: Completed Normal
Click View Output
Reveiw output file.
Name: DEMO Cash in Bank RegisterOperating Unit: Your Operating UnitDisbursing Officer: Your UsernameBank Account Number: Your Created Bank Number (the one you used to pay your invoices or record your deposits)Date From: 01-Jan-2009Date To: Current Date
Find Request window is displayed
23
User Acceptance Test ScriptsCash Management
Section 3 Manage Bank Reconciliation Overview
This Test Scripts documents the steps needed to demonstrate the functionality of Oracle Cash Management.
Bank Reconciliation is the process of matching transactions recorded in the books against the uploaded Bank Statement. In Oracle Cash Management we have two ways to do reconciliation, automatic & manual reconciliation.
This UAT Session will include the following processes:
Automatic Reconciliation Manual Reconciliation Reconciling Items
24
User Acceptance Test ScriptsCash Management
1.3 UAT Sequence Summary
Sequence #
Ref Date Time Process Name Description Participant UAT Status
Result Remarks
00.0 Pre-requisite Steps10.0 Manage Bank Statements
20.0 Manage Bank Reconciliation
20.1 CM FS 3.02 Manual Reconciliation20.2 CM FS 3.01 Automatic Reconciliation20.3 CM FS 4.01 Reconciling Items30.0 Manage Inter-Bank Account
Transfer40.0 Manage Petty Cash Fund
For Testers to Confirm UAT Results at each UAT Session Close:
UAT Tester Name & Signature: _______________________
UAT Lead Name & Signature: ________________________
UAT Date & Time of Certification: _____________________
25
User Acceptance Test ScriptsCash Management
20.0 Manage Bank ReconciliationBusiness Flow: Manage Bank Reconciliation
Summary Process: Process of matching transactions recorded in the books against the uploaded bank statement.
Process:
20.1 Manual Reconciliation
Description:
Process of manually reconciling transactions.
ScenarioStep
Business Process Name Participant Action or Path Input Data Expected Results
Actual Results Status Remarks
20.1.1 Login/ Choose Responsibility
Browse to Application URL. http://oracle-uat-1.DEMOproj.com:8006
Enter your:
Click on Login.
Select as applicable:HO CM Super UserPDO CM Super UserPMO CM Super User
Username: Your UsernamePassword: Your Password
Please note: If this is the first time you are logging in as this user, login with the default password of Welcome, and change the default password to your password.
Navigator will display.
20.1.2 Run Transactions Available for Reconciliation Report
Navigate to the Submit Request window.
Menu: View > Requests
Run Request and enter the following parameters
Name: Transactions Available for Reconciliation ReportTransaction Type: ARTreasury Legal Entity: Leave Blank
Submit a new Request window is displayed
26
User Acceptance Test ScriptsCash Management
Submit your Request
When the concurrent request is finished or the status: Completed/Normal
Review the Transactions Available for Reconciliation Report by clicking the View Output button. Take note of a transaction to be reconciled.
Then click the Close Form Icon
Payroll Business Group: Leave BlankAP/AR Operating Unit: Your Operating UnitBank Account Number: Your Bank Account NumberOrder By: Date
20.1.3 Manual Reconciliation
Navigate to Bank Statements and Reconciliation window.Menu: Bank Statements > Bank Statements and Reconciliation
Search the Bank statement to reconcile
Click the Find button
Then click the Lines button
Select the transaction to reconcile
Then click the Available button
Enter in the Find Transactions window
For Receipts
Account Number: Your Bank Account NumberStatement Number: Your Bank Statement Number
Note: The more precise your search criteria the more specific your search result
Number: Your noted Receipt No.Reference Type: Leave BlankReference Number: Leave Blank
Reconcile Bank Statement window is displayed
Bank Statement Lines appeared
Find Transaction window is displayed
27
User Acceptance Test ScriptsCash Management
Click the Find button
Select the transaction that match your search and click the Reconcile button
Click the Save Icon
Then click the Close Form Icon
Receipt Class: Leave BlankPayment Method: Leave BlankDeposit Dates: Leave Blank
Note: The more precise your search criteria the more specific your search result Manually reconciled
receipts
Process:
20.2 AutomaticReconciliation
Description:
Process of automatically reconciling transactions.
ScenarioStep
Business Process Name Participant Action or Path Input Data Expected Results
Actual Results Status Remarks
20.2.1 Login/ Choose Responsibility
Browse to Application URL. http://oracle-uat-1.DEMOproj.com:8006
Enter your:
Click on Login.
Select as applicable:HO CM Super UserPDO CM Super UserPMO CM Super User
Username: Your UsernamePassword: Your Password
Please note: If this is the first time you are logging in as this user, login with the default password of Welcome, and change the default password to your password.
Navigator will display.
20.2.2 Auto-Reconciliation
Navigate to the Submit Request window.
Menu: View > Requests
Name: AutoReconciliation
Submit a new Request window is displayed
28
User Acceptance Test ScriptsCash Management
ScenarioStep
Business Process Name Participant Action or Path Input Data Expected Results
Actual Results Status Remarks
Run Request and enter the following parameters
Submit your Request
When the concurrent request is finished or the status: Completed/Normal
Review the AutoReconciliation Execution Report for reconciliation errors by clicking the View Output button
Then click the Close Form Icon
ProgramBank Branch Name: Your Bank Branch NameBank Account Number: Your Bank Account NumberStatement Number From: Your created Statement NumberStatement Number To: Your created Statement NumberStatement Date From: Leave BlankStatement Date To: Leave BlankGL Date: Current DateOrganization: Your Operating UnitReceivable Activity: Leave BlankPayment Method: Leave Blank
Automatically reconciled transactions
20.1.3 Run Bank Reconciliation Report
Navigate to the Submit Request window.
Menu: View > Requests
Run Request and enter the following parameters
Name: Bank Reconciliation ReportOperating Unit: Your Operating UnitBank Name: Your Bank NameBank Branch Name: Your Bank Branch NameBank Account Name: Your Bank Account Name
Submit a new Request window is displayed
29
User Acceptance Test ScriptsCash Management
ScenarioStep
Business Process Name Participant Action or Path Input Data Expected Results
Actual Results Status Remarks
Submit your Request
When the concurrent request is finished or the status: Completed/Normal
Review the Bank Reconciliation Report by clicking the View Output button
Then click the Close Form Icon
Bank Statement Number: Your Bank Statement NumberPrepared By: Create Your OwnOfficial Designation: Create Your OwnCertified Correct: Create Your OwnOfficial Designation: Create Your OwnApproved By: Create Your OwnOfficial Designation: Create Your Own
30
User Acceptance Test ScriptsCash Management
Process:
20.3 Reconciling Items
Description:
Process of recording reconciling items by using a Journal Entry in the General Ledger.
ScenarioStep
Business Process Name Participant Action or Path Input Data Expected Results
Actual Results Status Remarks
20.3.1 Login/ Choose Responsibility
Browse to Application URL. http://oracle-uat-1.DEMOproj.com:8006
Enter your:
Click on Login.
Select as applicable:HO CM Super UserPDO CM Super UserPMO CM Super User
Username: Your UsernamePassword: Your Password
Please note: If this is the first time you are logging in as this user, login with the default password of Welcome, and change the default password to your password.
Navigator will display.
20.3.2 Create Journal Entry for the Reconciling Items
Navigate to Enter Journals window
Menu: Journals > Enter
Click New Journal Button
Under the Journals Header Journal: Your (Surname) JournalDescription: Create Your OwnLedger: DefaultedCategory: Manual HOPeriod: Current PeriodEffective Date: Current DateBalance Type: ActualDocument Number: Leave BlankClearing Company: Leave BlankTax: Not RequiredControl Total: Leave Blank
Enter Journal window is displayed
31
User Acceptance Test ScriptsCash Management
ScenarioStep
Business Process Name Participant Action or Path Input Data Expected Results
Actual Results Status Remarks
Under the Journal Lines
If you are booking for a Bank Charge amounting to 1000.00 SGD, choose your appropriate OU & RC codes.
Under Other Information
Click Save
Then Post your created Journal Entry by clicking the Post button
Line: 1Account: 1100-H1000-(Cash Account)-0000000-0000-0000The Cash Account should be exactly the same as the one you have setup in your Bank AccountDebit: 1,000.00Credit: Leave BlankDescription: Bank Charges for the period______
Line: 2Account: 1100-H1000-65060100-0000000-0000-0000Debit: Leave BlankCredit: 1,000.00Description: Bank Charges for the period______
Source: ManualReference: Leave BlankReference Date: Leave BlankReconciliation Reference: Leave Blank
Journa Entry created & saved
Journal Entry posted
20.3.3 Manual Reconciliation for the created Journal Entry
Pre-requisite: Only Posted Journal Entry can be match
Navigate to Bank Statements and Reconciliation window.Menu: Bank Statements > Bank Statements and Reconciliation
Reconcile Bank Statement window is displayed
32
User Acceptance Test ScriptsCash Management
ScenarioStep
Business Process Name Participant Action or Path Input Data Expected Results
Actual Results Status Remarks
Search the Bank statement to reconcile
Click the Find button
Then click the Lines button
Select the transaction to reconcile
Then click the Available button
Enter in the Find Transactions window
For Journals
Click the Find button
Select the transaction that match your search and click the Reconcile button
Click the Save Icon
Then click the Close Form Icon
Account Number: Your Bank Account NumberStatement Number: Your Bank Statement Number
Note: The more precise your search criteria the more specific your search result
Period Name: Period when you created your JEJournal Entry Name: Your created JE Batch NameDocument Number: System generated JEV numberLine Number: Leave Blank
Note: The more precise your search criteria the more specific your search result
Bank Statement Lines appeared
Find Transaction window is displayed
Manually reconciled receipts
33
User Acceptance Test ScriptsCash Management
Section 4 Manage Inter-Bank Account Transfers Overview
This Test Scripts documents the steps needed to demonstrate the functionality of Oracle Cash Management.
Bank to Bank transfers between different Operating Units across the entire company or DEMO, will be handled by the standard functionality of Oracle Cash Management
This UAT Session will include the following processes:
Initiate Inter-Bank Account Transfers
Validate Inter-Bank Account Transfers
Authorized Inter-Bank Account Transfers
Create Accounting for Inter-Bank Account Transfers
34
User Acceptance Test ScriptsCash Management
1.4 UAT Sequence Summary
Sequence #
Ref Date Time Process Name Description Tester UAT Status
Result Remarks
00.0 Pre-requisite Steps10.0 Manage Bank Statements20.0 Manage Bank Reconciliation
30.0 Manage Inter-Bank Account Transfer
30.1 CM FS 5.0.9.1 Initiate Inter-Bank Account Transfers
30.2 CM FS 5.0.9.2 Validate Inter-Bank Account Transfers
30.3 CM FS 5.0.9.3 Authorize Inter-Bank Account Transfers
30.4 CM FS 5.0.9.4 Create Accounting for Inter-Bank Account Transfers
40.0 Manage Petty Cash Fund
For Testers to Confirm UAT Results at each UAT Session Close:
UAT Tester Name & Signature: _______________________
UAT Lead Name & Signature: ________________________
UAT Date & Time of Certification: _____________________
35
User Acceptance Test ScriptsCash Management
30.0 Manage Inter-Bank Account TransfersBusiness Flow: Manage Inter-Bank Account Transfers
Summary Process: Process of initiating, validating & authorizing inter-bank account transfers between different operating units.
Process:
30.1 Initiate Inter-Bank Account Transfers
Description:
Process of creating an Inter-Bank Account Transfers.
ScenarioStep
Business Process Name Tester Action or Path Input Data Expected Results
Actual Results Status Remarks
30.1.1 Login/ Choose Responsibility
Browse to Application URL. http://oracle-uat-1.DEMOproj.com:8006
Enter your:
Click on Login.
Select as applicable:HO CM Super UserPDO CM Super UserPMO CM Super User
Username: Your UsernamePassword: Your Password
Please note: If this is the first time you are logging in as this user, login with the default password of Welcome, and change the default password to your password.
Navigator will display.
30.1.2 Initiate Inter-Bank Account Transfers
Navigate to Bank Account Transfers window Menu: Bank Account Transfers
Click the Create button
Enter the following informationGeneral Information Tab Settle Transactions Through
Oracle Payments: NoTransaction Subtype: Choose the appropriate subtype:
Authority to Pay Notice of Budget Allocation Remittance to Head Office Request for Refund Petty Cash Fund Other Transfers
Payment Template: Leave Blank
Bank Account Transfer window is displayed
36
User Acceptance Test ScriptsCash Management
Source Bank Account RegionSource Bank Account
Destination Bank Account
Click Apply button
Then click the
Bank Reference Number: Any nubmerStatus: NewTransfer Date: Current DateCurrecy: SGDTransfer Amount: Any AmountComments: Additional information you want to include
Bank Account Number: Your Bank Account NumberBank Account Name: DefaultedBranch Name: DefaultedBank Name: DefaultedLegal Entity: Defaulted
Bank Account Number: Use other Bank Account NumberBank Account Name: DefaultedBranch Name: DefaultedBank Name: DefaultedLegal Entity: Defaulted
Confimation that bank account transfer No.___ has been created.
37
User Acceptance Test ScriptsCash Management
Process:
30.2 Validate Inter-Bank Account Transfers
Description:
Process of validating the encoded information of an Inter-Bank Account Transfers.
ScenarioStep
Business Process Name Tester Action or Path Input Data Expected Results
Actual Results Status Remarks
30.2.1 Login/ Choose Responsibility
Browse to Application URL. http://oracle-uat-1.DEMOproj.com:8006
Enter your:
Click on Login.
Select as applicable:HO CM Super UserPDO CM Super UserPMO CM Super User
Username: Your UsernamePassword: Your Password
Please note: If this is the first time you are logging in as this user, login with the default password of Welcome, and change the default password to your password.
Navigator will display.
30.2.2 Validate Inter-Bank Account Transfers
Navigate to Bank Account Transfers window Menu: Bank Account Transfers
Select & Enter
Click GO button
Under the Validate column
Click the Validate Icon
Then click the
Search: Transfer NumberTransfer Number: Your Created Inter-Bank Account Transfer Number
Bank Account Transfer window is displayed
Confimation that bank account transfer No.___ has been validated.
38
User Acceptance Test ScriptsCash Management
Process:
30.3 Authorize Inter-Bank Account Transfers
Description:
Process of authorizing or approving an Inter-Bank Account Transfers.
ScenarioStep
Business Process Name Tester Action or Path Input Data Expected Results
Actual Results Status Remarks
30.3.1 Login/ Choose Responsibility
Browse to Application URL. http://oracle-uat-1.DEMOproj.com:8006
Enter your:
Click on Login.
Select as applicable:HO CM Super UserPDO CM Super UserPMO CM Super User
Username: Your UsernamePassword: Your Password
Please note: If this is the first time you are logging in as this user, login with the default password of Welcome, and change the default password to your password.
Navigator will display.
30.3.2 Authorize Inter-Bank Account Transfers
Navigate to the Authorize Bank Account TransfersMenu: Authorize Bank Account Transfers
Click the to expand the transfer transaction or click the transfer number to view the details of the inter-bank account transfer.
Under the Select column, put a on the transfer you want to authorize
Click the Authorize Transfers button
Authorize Bank Account Transfer window is displayed
Confimation that bank account transfer No.___ has been authorized.
30.3.3 Reject Inter-Bank Account Transfers
Navigate to the Authorize Bank Account TransfersMenu: Authorize Bank Account Transfers
Click the to expand the transfer
Authorize Bank Account Transfer window is displayed
39
User Acceptance Test ScriptsCash Management
ScenarioStep
Business Process Name Tester Action or Path Input Data Expected Results
Actual Results Status Remarks
transaction or click the transfer number to view the details of the inter-bank account transfer.
Under the Select column, put a on the transfer you want to authorize
Click the RejectTransfers buttonConfimation that bank account transfer No.___ has been rejected.
Process:
30.4 Create Accounting Inter-Bank Account Transfers
Description:
Process of creating the accounting entriesof Inter-Bank Account Transfers.
ScenarioStep
Business Process Name Tester Action or Path Input Data Expected Results
Actual Results Status Remarks
30.4.1 Login/ Choose Responsibility
Browse to Application URL. http://oracle-uat-1.DEMOproj.com:8006
Enter your:
Click on Login.
Select as applicable:HO CM Super UserPDO CM Super UserPMO CM Super User
Username: Your UsernamePassword: Your Password
Please note: If this is the first time you are logging in as this user, login with the default password of Welcome, and change the default password to your password.
Navigator will display.
30.4.2 Create Acconting Entries Inter-Bank Account Transfers
Navigate to the Submit Request window.
Menu: View > Requests
Run Request and enter the following Name: Create AccountingLedger: Philippine Port Authority
Submit new Request window is displayed
40
User Acceptance Test ScriptsCash Management
ScenarioStep
Business Process Name Tester Action or Path Input Data Expected Results
Actual Results Status Remarks
parameters
Submit your Request
When the concurrent request is finished or the status: Completed/Normal
Review the Create Accounting Report by clicking the View Output button
Then click the Close Form Icon
Process Category: Leave BlankEnd Date: Period end dateMode: Leave BlankErrors Only: NoReport: DetailTransfer to General Ledger: YesPost in General Ledger: NoGeneral Ledger Batch Name: Leave BlankInclude User Transaction Identifiers: No
30.4.3 Run Cash Collection Disbursement Transfer Report
Navigate to the Submit Request window.
Menu: View > Requests
Run Request and enter the following parameters
Name: Cash Collection Disbursement Transfer ReportOperating Unit: Your Operating UnitTransfer Date From: 01-Jan-2008Transfer Date To: Current Date
Submit new Request window is displayed
41
User Acceptance Test ScriptsCash Management
ScenarioStep
Business Process Name Tester Action or Path Input Data Expected Results
Actual Results Status Remarks
Submit your Request
When the concurrent request is finished or the status: Completed/Normal
Review the Cash Collection Disbursement Transfer Report by clicking the View Output button
Then click the Close Form Icon
42
User Acceptance Test ScriptsCash Management
Section 5 Manage Petty Cash Fund Overview
This Test Scripts documents the steps needed to demonstrate the process of handling Petty Cash Fund.
Petty Cash Fund setup, replenishment & liquidation would handled by Oracle Payables, Receivables and Cash Management.
This UAT Session will include the following processes:
Request for Petty Cash Fund
Setup Petty Cash Fund
Petty Cash Fund Replenishment
Petty Cash Fund Liquidation
43
User Acceptance Test ScriptsCash Management
1.5 UAT Sequence Summary
Sequence #
Ref Date Time Process Name Description Participant UAT Status
Result Remarks
00.0 Pre-requisite Steps10.0 Manage Bank Statements20.0 Manage Bank Reconciliation30.0 Manage Inter-Bank Account
Transfer
40.0 Manage Petty Cash Fund
40.1 Request for Petty Cash Fund40.2 Setup Petty Cash Fund40.3 Petty Cash Fund
Replenishment40.4 Petty Cash Fund Liquidation
For Testers to Confirm UAT Results at each UAT Session Close:
UAT Tester Name & Signature: _______________________
UAT Lead Name & Signature: ________________________
UAT Date & Time of Certification: _____________________
44
User Acceptance Test ScriptsCash Management
40.0 Manage Petty Cash FundBusiness Flow: Manage Petty Cash Fund
Summary Process: Process of setting up, replenishment & liquidation of Petty Cash fund
Process:
40.1 Request for Petty Cash Fund
Description:
Process of requesting from Head Office intended for the Petty Cash Fund
ScenarioStep
Business Process Name Participant Action or Path Input Data Expected Results
Actual Results Status Remarks
40.1.1 Login/ Choose Responsibility
Browse to Application URL. http://oracle-uat-1.DEMOproj.com:8006
Enter your:
Click on Login.
Select as applicable:HO CM Super UserPDO CM Super UserPMO CM Super User
Username: Your UsernamePassword: Your Password
Please note: If this is the first time you are logging in as this user, login with the default password of Welcome, and change the default password to your password.
Navigator will display.
40.1.2 Inter-Bank Account Transfer – Petty Cash Fund
Please refer to Test Script 30.0 Manage Inter-Bank Account Transfers
45
User Acceptance Test ScriptsCash Management
Process:
40.2 Setup Petty Cash Fund
Description:
Process of setting up Petty Cash Fund to the custodian.
ScenarioStep
Business Process Name Participant Action or Path Input Data Expected Results
Actual Results Status Remarks
40.2.1 Login/ Choose Responsibility
Browse to Application URL. http://oracle-uat-1.DEMOproj.com:8006
Enter your:
Click on Login.
Select as applicable:HO CM Super UserPDO CM Super UserPMO CM Super User
Username: Your UsernamePassword: Your Password
Please note: If this is the first time you are logging in as this user, login with the default password of Welcome, and change the default password to your password.
Navigator will display.
40.2.2 Create Prepayment for the Petty Cash Fund
Navigate to AP Invoice Workbench
Menu: Invoices > Entry > Invoices
Enter the following information
Under the Invoice Header Operating Unit: Your Operating UnitCustomer Taxpayer ID: Leave BlankType: PrepaymentPO Number: Leave BlankTrading Partner: Your Created Supplier EmployeeSupplier Num: DefaultedSupplier Site: DefaultedInvoice Date: Current DateInvoice Num: Petty Cash 1Invoice Currency: SGDInvoice Amount: Any AmountTax Amount: Leave BlankTax Control Amount: Leave BlankWithheld Amount: Leave BlankPrepaid Amount: Leave BlankGL Date: Current DatePayment Curr: Leave BlankPayment Rate Date: Leave Blank
Invoice Workbench is displayed
46
User Acceptance Test ScriptsCash Management
Under the Invoice Line
Click Distribution button and enter the
Payment Rate Type: Leave BlankPayment Rate: Leave BlankDistribution Set: Leave BlankDecription: Create Your OwnQuick Credit: Leave BlankCredit Invoice: Leave BlankMatch Action: Leave BlankProject: Leave BlankTask: Leave BlankExpenditure Item Date: Leave BlankExpenditure Type: Leave BlankExpenditure Organization: Leave BlankRate Type: Leave BlankExchange Date: Leave BlankTerms Date: Leave BlankTerms: IMMEDIATEPayment Method: Leave BlankPay Group: Leave BlankPrepayment Type : Temporary
All other columns: Leave Blank
Num: 1Type: LineAmount: Same amount as the Invoice HeaderPO Number: Leave BlankPO Release: Leave BlankPO Line: Leave BlankPO Shipment: Leave BlankMatch Basis: Leave BlankPO Distribution: Leave BlankReceipt Number: Leave BlankReceipt Line: Leave BlankQuantity Invoiced: Leave BlankUOM: Leave BlankUnit Price: Leave BlankDescription: Create Your OwnFinal Match: Leave BlankRequester: Leave BlankGL Date: Current Date
All other columns: Leave Blank
Num: 1Type: Line
Distribution window appeared
47
User Acceptance Test ScriptsCash Management
following
Choose your appropriate OU & RC codes
Click Save
Click the ( x ) button to close
Click Action…1 button
Click OK button
Under Payment window
Amount: Same amount as the Invoice HeaderGL Date: Current DateAccount: 1100-H1000-11101003-0000000-0000-0000Asset Book: Leave BlankDescription: Create Your Own
All other columns: Leave Blank
Validate: Validate Related Invoices: Cancel Invoices: Apply/Unapply Prepayment: Pay in Full: Create Accounting:
Draft: Final: Final Post:
Stop Approval: Release Holds: Print Notice:
Type: ManualOperating Unit: Your Operating UnitTrading Partner: DefaultedSupplier Number: DefaultedSupplier Site: DefaultedTrading Partner Address: DefaultedPayee Country: Leave BlankPayment Date: Current DatePayment Amount: DefaultedBank Account: Select appropriate Bank Account NumberAccount Currency: SGDPayment Currency: SGDPayment Method: Select appropriate Payment MethodPayment Document: Select appropriate Payment DocumentDocument Number: Leave BlankPayment Process Profile: DEMO Standard Check FormatRemit to Account: Leave Blank
Action window is displayed
Payment workbench appeared
48
User Acceptance Test ScriptsCash Management
Click Save
All other columns: Leave BlankPrepayment created & paid
Process:
40.3 Petty Cash Fund Replenishment
Description:
Process of replenishing the Petty Cash Fund.
ScenarioStep
Business Process Name Participant Action or Path Input Data Expected Results
Actual Results Status Remarks
40.3.1 Login/ Choose Responsibility
Browse to Application URL. http://oracle-uat-1.DEMOproj.com:8006
Enter your:
Click on Login.
Select as applicable:HO CM Super UserPDO CM Super UserPMO CM Super User
Username: Your UsernamePassword: Your Password
Please note: If this is the first time you are logging in as this user, login with the default password of Welcome, and change the default password to your password.
Navigator will display.
40.3.2 Prepare Expense Report
Navigate to AP Invoice Workbench
Menu: Invoices > Entry > Invoices
Enter the following information
Under the Invoice Header Operating Unit: Your Operating UnitCustomer Taxpayer ID: Leave BlankType: Expense ReportPO Number: Leave BlankTrading Partner: Your Created Supplier EmployeeSupplier Num: DefaultedSupplier Site: DefaultedInvoice Date: Current Date
Invoice Workbench is displayed
49
User Acceptance Test ScriptsCash Management
Invoice Amount should be lower than the Prepayment Amount
Under the Invoice Line
Invoice Num: Expense Report 1Invoice Currency: SGDInvoice Amount: Any AmountTax Amount: Leave BlankTax Control Amount: Leave BlankWithheld Amount: Leave BlankPrepaid Amount: Leave BlankGL Date: Current DatePayment Curr: Leave BlankPayment Rate Date: Leave BlankPayment Rate Type: Leave BlankPayment Rate: Leave BlankDistribution Set: Leave BlankDecription: Create Your OwnQuick Credit: Leave BlankCredit Invoice: Leave BlankMatch Action: Leave BlankProject: Leave BlankTask: Leave BlankExpenditure Item Date: Leave BlankExpenditure Type: Leave BlankExpenditure Organization: Leave BlankRate Type: Leave BlankExchange Date: Leave BlankTerms Date: Leave BlankTerms: IMMEDIATEPayment Method: Leave BlankPay Group: Leave BlankPrepayment Type : Temporary
All other columns: Leave Blank
Num: 1Type: LineAmount: Same amount as the Invoice HeaderPO Number: Leave BlankPO Release: Leave BlankPO Line: Leave BlankPO Shipment: Leave BlankMatch Basis: Leave BlankPO Distribution: Leave BlankReceipt Number: Leave BlankReceipt Line: Leave BlankQuantity Invoiced: Leave BlankUOM: Leave BlankUnit Price: Leave BlankDescription: Create Your Own
50
User Acceptance Test ScriptsCash Management
Click Distribution button and enter the following
Choose your appropriate OU & RC codes
You can have as many Line distributions but your disctribution total should be the same as your Invoice Line Total.
Click Save
Click the ( x ) button to close
Click Action…1 button
Final Match: Leave BlankRequester: Leave BlankGL Date: Current Date
All other columns: Leave Blank
Num: 1Type: LineAmount: Any Amount as your Petty Expenses GL Date: Current DateAccount: 1100-H1000-(Expense Account)-0000000-0000-0000Asset Book: Leave BlankDescription: Create Your Own
All other columns: Leave Blank
Validate: Validate Related Invoices: Cancel Invoices: Apply/Unapply Prepayment: Pay in Full: Create Accounting:
Draft: Final: Final Post:
Stop Approval: Release Holds: Print Notice:
Apply:
Distribution window appeared
Action window is displayed
Apply/Unapply prepayment window appeared
51
User Acceptance Test ScriptsCash Management
Click OK button
Select the appropriate Prepayment
Apply Prepayment to Expense Report
Under Apply Check Box
Click Apply/Unapply button
Click Save40.3.3 Create a New
Prepayment Navigate to AP Invoice Workbench
Menu: Invoices > Entry > Invoices
Enter the following information
Under the Invoice Header Operating Unit: Your Operating UnitCustomer Taxpayer ID: Leave BlankType: PrepaymentPO Number: Leave BlankTrading Partner: Your Created Supplier EmployeeSupplier Num: DefaultedSupplier Site: DefaultedInvoice Date: Current DateInvoice Num: Petty Cash 2Invoice Currency: SGDInvoice Amount: Same Amount as your Expense ReportTax Amount: Leave BlankTax Control Amount: Leave BlankWithheld Amount: Leave BlankPrepaid Amount: Leave BlankGL Date: Current DatePayment Curr: Leave BlankPayment Rate Date: Leave BlankPayment Rate Type: Leave BlankPayment Rate: Leave BlankDistribution Set: Leave BlankDecription: Create Your OwnQuick Credit: Leave BlankCredit Invoice: Leave BlankMatch Action: Leave BlankProject: Leave Blank
Invoice Workbench is displayed
52
User Acceptance Test ScriptsCash Management
Under the Invoice Line
Click Distribution button and enter the following
Choose your appropriate OU & RC codes
Task: Leave BlankExpenditure Item Date: Leave BlankExpenditure Type: Leave BlankExpenditure Organization: Leave BlankRate Type: Leave BlankExchange Date: Leave BlankTerms Date: Leave BlankTerms: IMMEDIATEPayment Method: Leave BlankPay Group: Leave BlankPrepayment Type : Temporary
All other columns: Leave Blank
Num: 1Type: LineAmount: Same amount as the Invoice HeaderPO Number: Leave BlankPO Release: Leave BlankPO Line: Leave BlankPO Shipment: Leave BlankMatch Basis: Leave BlankPO Distribution: Leave BlankReceipt Number: Leave BlankReceipt Line: Leave BlankQuantity Invoiced: Leave BlankUOM: Leave BlankUnit Price: Leave BlankDescription: Create Your OwnFinal Match: Leave BlankRequester: Leave BlankGL Date: Current Date
All other columns: Leave Blank
Num: 1Type: LineAmount: Same amount as the Invoice HeaderGL Date: Current DateAccount: 1100-H1000-11101003-0000000-0000-0000Asset Book: Leave BlankDescription: Create Your Own
All other columns: Leave Blank
Distribution window appeared
53
User Acceptance Test ScriptsCash Management
Click Save
Click the ( x ) button to close
Click Action…1 button
Click OK button
Under Payment window
Click Save
Validate: Validate Related Invoices: Cancel Invoices: Apply/Unapply Prepayment: Pay in Full: Create Accounting:
Draft: Final: Final Post:
Stop Approval: Release Holds: Print Notice:
Type: ManualOperating Unit: Your Operating UnitTrading Partner: DefaultedSupplier Number: DefaultedSupplier Site: DefaultedTrading Partner Address: DefaultedPayee Country: Leave BlankPayment Date: Current DatePayment Amount: DefaultedBank Account: Select appropriate Bank Account NumberAccount Currency: SGDPayment Currency: SGDPayment Method: Select appropriate Payment MethodPayment Document: Select appropriate Payment DocumentDocument Number: Leave BlankPayment Process Profile: DEMO Standard Check FormatRemit to Account: Leave Blank
All other columns: Leave Blank
Action window is displayed
Payment workbench appeared
Prepayment created & paid
Process:
40.4 Petty Cash Liquidation
Description:
Process of liquidating the Petty Cash Fund.
54
User Acceptance Test ScriptsCash Management
ScenarioStep
Business Process Name Participant Action or Path Input Data Expected Results
Actual Results Status Remarks
40.4.1 Login/ Choose Responsibility
Browse to Application URL. http://oracle-uat-1.DEMOproj.com:8006
Enter your:
Click on Login.
Select as applicable:HO CM Super UserPDO CM Super UserPMO CM Super User
Username: Your UsernamePassword: Your Password
Please note: If this is the first time you are logging in as this user, login with the default password of Welcome, and change the default password to your password.
Navigator will display.
40.4.2 Return of Unused Petty Cash Fund
Navigate to FIRST Receipting WindowMenu: Receipting
Click Create Receipt button
Enter the following information
Under Additional Receipt ItemsClick Add Row
Receipt Invoice: NoBank Account Number: Select appropriate Bank Account NumberReceipt Category: Other ReceiptDebtor Code: Your Created CustomerDebtor Name: DefaultedTIN: DefaultedAddress: DefaultedTerminal Code: DefaultedPreprinted OR No: Any NumberReceipt Date: Defaulted to Current DateReceipt Amount: DefaultedStatus: Defaulted to “New Receipt”Computation Sheet No: Leave Blank
Line Items: PETTY CASH FUNDOUM: LotQuantity: 1Unit Price: Any AmountAmount: Defaulted
FIRST Receipting window is displayed
55
User Acceptance Test ScriptsCash Management
Under Payment ModeClick Add Row
Click Save button
Then click Print Button
Tax Code: Leave BlankVat: DefaultedRemarks: Create Your Own
Line No: Line No. above generated by the systemPayment Mode: CASHReference No: Leave BlankReference Date: Leave BlankBank: Leave BlankAmount: The same as the amount above
Receipt Saved & Printed
40.4.3 Prepare Expense Report for Liquidation
Navigate to AP Invoice Workbench
Menu: Invoices > Entry > Invoices
Enter the following information
Under the Invoice Header Operating Unit: Your Operating UnitCustomer Taxpayer ID: Leave BlankType: Expense ReportPO Number: Leave BlankTrading Partner: Your Created Supplier EmployeeSupplier Num: DefaultedSupplier Site: DefaultedInvoice Date: Current DateInvoice Num: Expense Report 2Invoice Currency: SGDInvoice Amount: Amount should be equal to your Total Petty Cash FundTax Amount: Leave BlankTax Control Amount: Leave BlankWithheld Amount: Leave BlankPrepaid Amount: Leave BlankGL Date: Current DatePayment Curr: Leave BlankPayment Rate Date: Leave BlankPayment Rate Type: Leave BlankPayment Rate: Leave BlankDistribution Set: Leave BlankDecription: Create Your OwnQuick Credit: Leave BlankCredit Invoice: Leave BlankMatch Action: Leave BlankProject: Leave Blank
Invoice Workbench is displayed
56
User Acceptance Test ScriptsCash Management
Under the Invoice Line
Click Distribution button and enter the following
Choose your appropriate OU & RC codes
You can have as many Line distributions but your disctribution total should be the same as your Invoice
Task: Leave BlankExpenditure Item Date: Leave BlankExpenditure Type: Leave BlankExpenditure Organization: Leave BlankRate Type: Leave BlankExchange Date: Leave BlankTerms Date: Leave BlankTerms: IMMEDIATEPayment Method: Leave BlankPay Group: Leave BlankPrepayment Type : Temporary
All other columns: Leave Blank
Num: 1Type: LineAmount: Same amount as the Invoice HeaderPO Number: Leave BlankPO Release: Leave BlankPO Line: Leave BlankPO Shipment: Leave BlankMatch Basis: Leave BlankPO Distribution: Leave BlankReceipt Number: Leave BlankReceipt Line: Leave BlankQuantity Invoiced: Leave BlankUOM: Leave BlankUnit Price: Leave BlankDescription: Create Your OwnFinal Match: Leave BlankRequester: Leave BlankGL Date: Current Date
All other columns: Leave Blank
Num: 1Type: LineAmount: Any Amount as your Petty Expenses GL Date: Current DateAccount: 1100-H1000-(Expense Account)-0000000-0000-0000Asset Book: Leave BlankDescription: Create Your Own
Distribution window appeared
57
User Acceptance Test ScriptsCash Management
Line Total.
Click Save
Click the ( x ) button to close
Click Action…1 button
Click OK button
Select the appropriate Prepayment
Apply Prepayment to Expense Report
Under Apply Check Box
Click Apply/Unapply button
Click Save
All other columns: Leave Blank
Num: 2Type: LineAmount: Amount of Returned Petty Cash Fund GL Date: Current DateAccount: 1100-H1000-21100321-0000000-0000-0000Asset Book: Leave BlankDescription: Create Your Own
All other columns: Leave Blank
Validate: Validate Related Invoices: Cancel Invoices: Apply/Unapply Prepayment: Pay in Full: Create Accounting:
Draft: Final: Final Post:
Stop Approval: Release Holds: Print Notice:
Apply:
Action window is displayed
Apply/Unapply prepayment window appeared
58
User Acceptance Test ScriptsCash Management
59
User Acceptance Test ScriptsCash Management
60