Ask the Expert

Bank statements don't match AP, AR transactions

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.

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: