Q

Bank statements don't match AP, AR transactions

This Content Component encountered an error
This Content Component encountered an error
We are running Oracle 11.5.8 on Sun Solaris for two months and we built the financial environment as multi-org. We faced one problem that the bank statement received doesn't match with AP, AR transactions since AP and AR are divided in multi-operating units. The bank statement has transactions for all of the operating units.

We have a huge number of accounts to consolidate and we can't open different accounts for each operating unit. In short, dealign with banks is a centralized function from the head office and AR, AP is centralized too but on Oracle they are divided into operating units. This situation make the cash management module not functining at all. Please help. This is an example of why implementation is a planning intensive task. Cash management...

relies on a series of setups in General Ledger. You indicate that you are having bank statement reconciliation problems.

The reconciliation process uses the basic accounting structure and various rules relating to how the various parts of the business inter-relate, as defined how the accounting structure maps between various businesses.

1. Review your basic accounting structure.
2. Review your hierarchies of values, and your rollup groups.
3. Review your flexfield cross validation rules.
4. Review your intercompany accounts
5. Review the transaction codes and setups for reconciliation as defined in your Cash Management setup.
6. Review the setup of your global consolidation system. This is the mapping rules which allow consolidation across all companies to one set of books.
7. Review your elimination sets (elimination sets reference accounts in one set of books).

This was first published in January 2004

Dig deeper on Oracle E-Business Suite

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close