BANK SETUP IN R 12.1.
2 May 13, 2010
Setup Bank Step In R12.1.2
From payables Module:
Setup > Payment > Payment Administrator
A- Format :
1- Check Format :
2- Wire Format :
Made By Mohamed ELhamy Page 1
BANK SETUP IN R 12.1.2 May 13, 2010
3- Cash
Made By Mohamed ELhamy Page 2
BANK SETUP IN R 12.1.2 May 13, 2010
1- Stand on the format page and choose task status (Completed) and click on Apply
button
2- Go to Payment Process Profiles
Made By Mohamed ELhamy Page 3
BANK SETUP IN R 12.1.2 May 13, 2010
3- Create Payment Profile name and code and assign some properties as
shown and in payment methods choose check and Bill Payable to enable
the bill payable on the payables
But to Enable the bills payable payment method just activate it from
Payment Method
Made By Mohamed ELhamy Page 4
BANK SETUP IN R 12.1.2 May 13, 2010
Then go to payment method Defaulting rules and define it for payables
Made By Mohamed ELhamy Page 5
BANK SETUP IN R 12.1.2 May 13, 2010
Then choose it as shown
Made By Mohamed ELhamy Page 6
BANK SETUP IN R 12.1.2 May 13, 2010
Go to tab Payment Instruction Creation
Made By Mohamed ELhamy Page 7
BANK SETUP IN R 12.1.2 May 13, 2010
Then Tab Payment Instruction Format: Choose your Format that created before
Made By Mohamed ELhamy Page 8
BANK SETUP IN R 12.1.2 May 13, 2010
Made By Mohamed ELhamy Page 9
BANK SETUP IN R 12.1.2 May 13, 2010
To Define Bank Account owner
1- Go to User Management Responsibility by SYSADMIN User
2- Click on Role & Role Inheritance
1- Click on Create Role Button
2- Select Miscellaneous Category and insert the following information as follows
Made By Mohamed ELhamy Page 10
BANK SETUP IN R 12.1.2 May 13, 2010
1- Click on Security Wizard Button
2- Choose (CE UMX Security Wizard) and click on Run Wizard as shown
Made By Mohamed ELhamy Page 11
BANK SETUP IN R 12.1.2 May 13, 2010
1- Select your legal entity and click on (Use), (Bank Account Grant Maintenance) & (Bank Account Transfers)
Check Boxed as shown
Made By Mohamed ELhamy Page 12
BANK SETUP IN R 12.1.2 May 13, 2010
1- Click on Apply Button
2- Then Click on Save & Apply Button
3- Go to Users Tab
4- Select your user Name and Click GO Button
5- Click on Assign Role Button and
Choose your Role & Responsibility (e.g.: @Payables) as shown
Made By Mohamed ELhamy Page 13
BANK SETUP IN R 12.1.2 May 13, 2010
Define Bank and branches And Bank Account
Made By Mohamed ELhamy Page 14
BANK SETUP IN R 12.1.2 May 13, 2010
1- Define Bank & Bank Branch
(N) Payables > Setup > Payment > Bank & Bank Branches
1- Click On create
2- Click Save and next
3- Click On create address
Made By Mohamed ELhamy Page 15
BANK SETUP IN R 12.1.2 May 13, 2010
4- Click on apply then after save and next then finish
5- Click on create branch
Made By Mohamed ELhamy Page 16
BANK SETUP IN R 12.1.2 May 13, 2010
Made By Mohamed ELhamy Page 17
BANK SETUP IN R 12.1.2 May 13, 2010
6- Click On continue
Made By Mohamed ELhamy Page 18
BANK SETUP IN R 12.1.2 May 13, 2010
7- Click save and next
8- Then click finish
Made By Mohamed ELhamy Page 19
BANK SETUP IN R 12.1.2 May 13, 2010
Define Bank Accounts
(N) Payables > Setup > Payment > Bank Accounts
o Click on Create Account
o Click on continue
• Select Bank Account Owner (Saudi Cement Company)
• Select Account Use (Payable & Receivables)
Made By Mohamed ELhamy Page 20
BANK SETUP IN R 12.1.2 May 13, 2010
- Click on next
Made By Mohamed ELhamy Page 21
BANK SETUP IN R 12.1.2 May 13, 2010
- Click on next
- YOU MUST DEFINE THE CLEARING ACCOUNT IF CHOOSE IN PAYABLES
OPTIONS THAT THE PAYMENY ISSUE WHEN PAYMENT CLEARS IF YOU NOT
DO IT ,, IT WILL COUSE ERROR IN CREATING ACCOUNTING ONLINE
Made By Mohamed ELhamy Page 22
BANK SETUP IN R 12.1.2 May 13, 2010
Made By Mohamed ELhamy Page 23
BANK SETUP IN R 12.1.2 May 13, 2010
- Click on Next
- Click ADD Organization Access
Made By Mohamed ELhamy Page 24
BANK SETUP IN R 12.1.2 May 13, 2010
Made By Mohamed ELhamy Page 25
BANK SETUP IN R 12.1.2 May 13, 2010
- Click on continue
Made By Mohamed ELhamy Page 26
BANK SETUP IN R 12.1.2 May 13, 2010
- Click On apply to finish bank
Made By Mohamed ELhamy Page 27
BANK SETUP IN R 12.1.2 May 13, 2010
Payment Document Serial Check or Non Serial
1- Click on manage payment document
2- Name the Payment Document (Serial Check) as (CORP _ SEN CHECK )
3- Select Paper Stock type as “Prenumbered Stock” that’s for serial document if not serial and draft
choose “blank stock “
4- Select “SCC_Check” Format
5- Insert First Available Document Number & Last Available Document Number as shown that’s for
serial document if not serial and draft chose Insert First Available Document Number
6- Note That the wire like draft check
Made By Mohamed ELhamy Page 28
BANK SETUP IN R 12.1.2 May 13, 2010
Made By Mohamed ELhamy Page 29
BANK SETUP IN R 12.1.2 May 13, 2010
VI Note
When you define the bank Multicurrency bank you have to go to
ledger and define the following account it dummy account for oracle
setup only coz if you don’t define it will case an error in the following
case :
When you make payment In USD from bank and the bank main
currency is EGP you will not be enable to create accounting coz the
Made By Mohamed ELhamy Page 30
BANK SETUP IN R 12.1.2 May 13, 2010
system needs to define dummy account in the ledger to complete the
creating accounting for the payment
The solution:-
Go to the General Ledger Module > press on |(CTRL+L) find
accounting Setup manager main page
Search for your ledger go to > Define and update the journal
processing options for your ledger.
In Page 1
Made By Mohamed ELhamy Page 31
BANK SETUP IN R 12.1.2 May 13, 2010
Define the account shaded in the last Pic and be that is non used
account coz it will used only for system purpose
Made By Mohamed ELhamy Page 32