bank setup in r 12.1 - wordpress.com · bank transfer setup in r 12.1.2 jun 16 2010 ... setup bank...

26
BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 Made By Mohamed ELhamy Page 1 Setup Bank Transfer Steps In R12.1.2 And cycle PRERQUISIT: If you are using One legal entity to make the bank transfer From General Ledger Module: Setup > Financial >flex field>Segments A- Balancing Segment : 1- Make it intercompany segment:

Upload: phamtuyen

Post on 04-Jun-2018

217 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 1

Setup Bank Transfer Steps In R12.1.2

And cycle PRERQUISIT: If you are using One legal entity to make the bank transfer

From General Ledger Module:

Setup > Financial >flex field>Segments

A- Balancing Segment : 1- Make it intercompany segment:

Page 2: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 2

2- Go To cash Management Module : Setup>Miscellaneous>Accounting setup manager >Accounting Setups

1- Choose Ledger: < your ledger > Click Update accounting options

Page 3: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 3

2- Click update for Primary Ledger :

A- Enable Intercompany balancing on the ledger in the ledger definition Page Num 2

Page 4: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 4

Page 5: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 5

3- Click on : Intercompany Balancing Rules

Page 6: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 6

a- Click on Define the rule

Page 7: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 7

B- Enter the following parameters : Click on Create rule

Click Create Rules Source: Other Category: Other Balancing Details tab -> Debit balancing Segment Values: All Other Credit balancing Segment Values: All Other Debit Account: the account that you want to be the clearing account Credit Account: the account that you want to be the clearing account

Page 8: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 8

Options tab: Default Options: Manually entered clearing balancing Segment Value Apply Done

Page 9: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 9

Copmlete

4- In System Administrator responsibility assign the CE: Bank Account Transfers system profile to your responsibility in Cash management. Path: Oracle Application Manager / Profile / System. (If not assigned)

5- Login as sysadmin and go to User Management responsibility and setup the UMX Security for Bank Account Transfer module for your specific Legal Entity, this can be Done using the UMX wizard for Cash Management, this wizard can be launched by querying the relevant responsibility you are using from Roles and Responsibilities module. Path: User Management / Roles & Role Inheritance. Create new rule to the bank transfer.

a- Press on Security Wizard : check on the three check boxes in it and press on save and then

Page 10: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 10

Check on the three check boxes in it and press on save and then press on the security wizard

Page 11: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 11

. Run the CE UMX Security Wizard, then you will see a new form called “bank Account

Run the CE UMX Security Wizard, then you will see a new form called “bank Account Security Management, enter the bank account grants for USE, MAINTENANCE and BANK ACCOUNT TRANSFER and clink in the APPLY button

Page 12: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 12

b- Press on USERS TAB to assign the rule to the users : choose the users by user the click on update

Page 13: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 13

c- Click on Assign to assign the rule that you defined

Page 14: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 14

After Finishing all that you have to Run Program named Validate Application Accounting Definitions

Complete the parameters special choose your application Cash management

Page 15: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 15

With that you have finished the prerequisite tasks to start setup bank account transfer.

1- Setup > System > Transaction Subtype

Page 16: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 16

2- Setup> system > Payment Template to but in it the Source bank to destination bank like the screen shot

Page 17: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 17

BANK TRANSFER CYCLE

GO Cash Management:

Bank Account Transfer

- Choose your Transaction Subtype

- Choose you Payment template

- Enter the date

- Enter the amount

- Press on Apply and validate

Page 18: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 18

After pressing on apply and validate you have to see the status is settled

Page 19: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 19

Go to Cash Flows and check the transaction is OUTFLOW and the status is created

Page 20: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 20

Then Go To : Bank Statements > Bank Statements and reconcile and make reconciliation for cash management cash flow in the two banks the source and destination bank

Page 21: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 21

Then go to Program and run:

Create accounting program

Page 22: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 22

Then run program

Transfer Journal Entries to GL

With its exact parameter number 2 tr

Page 23: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 23

THEN IT’S DONE

Note : very important If Error Appears to you like the next screen shot

Page 24: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 24

Go to : Setup > miscellaneous > accounting setups

Sub ledger Accounting Options then click on update then clicks on Update accounting options for cash management module

Page 25: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 25

Confirm that setup in as shown in the next screen shot

Page 26: Bank setup in r 12.1 - WordPress.com · BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010 ... Setup Bank Transfer Steps In R12.1.2 ... Setup>Miscellaneous>Accounting setup manager >Accounting

BANK TRANSFER SETUP IN R 12.1.2 JUN 16 2010

Made By Mohamed ELhamy Page 26

BY THAT YOU HAVE FINISHED FULL CYCLE FOR THE BANK TRANSFER