Monday, November 23, 2009

R12 Trial Balance report in AP and Reconciling AP to GL

Trial Balance report in AP
In R12, there are 4 Concurrent Programs related to the trial balance.

1.Report Name = "Accounts Payable Trial Balance (Old) "  Short Name = APXTRBAL
 This is the R11i Accounts Payable Trial Balance, it should be disabled in R12.

2.Report Name = "Accounts Payable Trial Balance"  Short Name = APTBRPT
This is the R12 Accounts Payable Trial Balance, this is the correct report name to run if Trial Balance Remodel Phase 4 or higher has been applied.  This report is a modified version of the Open Account Balance Listing report.

3.Report Name = "Open Account Balance Listing"  Short Name = XLATBRPT
This is a Subledger Accounting report.  This report should NOT be used for Payables.  Instead, use the applicable Payables modified version of the report.

4.Report Name = "Open Account AP Balance Listing"  Short Name = XLAAPRPT
This is the subledger Open Account Balance Listing report modified for Payables and should be used with Trial Balance Remodel Phases 1 - 3.

Note: Currently, the Trial Balance documentation and notes refer to the Accounts Payable Trial Balance and Open Account AP Balance Listing report interchangeably.  The name change was due to a change in Phase 1 - 3, going forward all Payables Trial Balance patches should retain the name "Accounts Payable Trial Balance".  Please make sure you run the correct report based on your Trial Balance remodel phase and do NOT run the Open Account Balance Listing report for Payables.

Reconciling AP to GL
1.Run Accounts Payables Trial Balance report for current period with following details:
  • Start Date = Begin Date for first period you started using Oracle (This parameter is hidden as of Trial Balance Remodel phase 4, with default date 01-Jan-1950)
  • As of Date = End Date for Period to be reconciled
  • Show Transaction Detail = Yes
  • Include Write Offs = No
  • Include SLA Manuals/Other Sources = Yes (This parameter is only applicable for the "Group by Account, Summary" template.
     Select report template
  • Accounts Payables Trial Balance - Group by Account, Detail
  • Accounts Payables Trial Balance - Group by Account, Summary

2.Run Invoice and Payment posting reports.
Payables Posted Invoice Register
Payables Posted Payment Register

3.The correct method for reconciling AP to GL is as follows:

Last Months Accounts Payable Trial Balance 
   + This months Payables Posted Invoice Register
        - This months Payables Posted Payment Register
                     = This months Accounts Payable Trial Balance


Note: The Accounts Payable Trial Balance report output shows a GL total. That GL total includes manual and non Liability class entries from the Payables subledger, and non-Payables source entries in GL. Use the given method to reconcile, and the Trial Balance amount remaining total should equal the GL total excluding the manual and non Liability class entries from the Payables subledger, and non-Payables source entries in GL.

Source=>
Refer Note 553484.1 on R12 Steps In Reconciling AP to GL Balance
Refer Note 823043.1 on R12 Steps In Reconciling GL Balance And AP And PO
Related Posts Plugin for WordPress, Blogger...