Oracle Receivables R12: AR to GL Reconciliation


Here is small brief on AR Reconciliation. At moment, we may not have good example on reconciliation but this will give your some brief on how this works.

Navigation – Control > Accounting > AR to GL Reconciliation Report

AR to GL Reconciliation Report

The AR to GL Reconciliation report compares the account balances in Oracle Receivables to those in Oracle General Ledger, and highlights journal sources where discrepancies might exist. This report simplifies the reconciliation process by comparing Receivables and General Ledger account balances in a single place.

Run the AR to GL Reconciliation report:

  1. After the Submit Accounting program in Receivables has completed, and
  2. You have reviewed the Unposted Items report to confirm that all journal entries have posted, and
  3. You have used the posting execution reports to confirm that the journal entries exported from Receivables match those posted in General Ledger.

The AR to GL Reconciliation report prints by ledger and organizes data first by company segment, then account type (assets, liabilities, income, and expense).

This report will show a difference between Receivables and GL account balances only if items did not successfully post to GL accounts. The Difference column indicates that the activity in Receivables compares to the journal source of Receivables in the general ledger. If the actual balance of a specific account is different in Receivables than in the general ledger, then the following columns highlight the type of journals that affect the account balances:

  • GL Source Manual: Manual journal entries made in the general ledger.
  • GL Subledgers Not AR: Journal entries posted to the general ledger from other subledgers, such as Oracle Payables or a legacy feeder system.
  • Unposted in GL: Unposted journals in the general ledger.

If manual journal entries exist in the general ledger, then you might need to reverse these journal entries if corrections were already made in Receivables.

If other subledgers post to these accounts, then you might need to make corrections in those subledgers, make manual corrections in the general ledger, or reconcile your other feeder systems separately.

After taking the required corrective actions, run the AR to GL Reconciliation report again to confirm that AR and GL accounts are now in balance.

Oracle R12 : Converting Number into words ( trick )


This is not very regular but kind of very good trick. How to Convert number into strings.  Here is a standard Oracle Package , generally used in AP side but can be use in your code also.

Solution:
SELECT ap_amount_utilities_pkg.ap_convert_number(12345) AS amt_in_words    FROM dual;

Output:
AMT_IN_WORDS

———————
Twelve thousand three hundred forty-five

We used this in some localized reports  and check printing.