9 responses to “Accounts Payable Trial Balance – Reconciliation with GL

  1. Hi Nilesh,

    could you please provide me AP -Gl Reco SQl

    Regards
    Amit

    • I would suggest to refer these oracle support document to get better understanding

      SLA: A TECHNICAL PERSPECTIVE OF THE AP TO GL RECONCILIATION [ID 605707.1]

      AP Does Not Balance to GL [ID 344367.1]

  2. Pingback: Top Referred Articles on KnowOracle | Shivmohan Purohit's Oracle Applications Blog

  3. Pingback: Top Articles in Dec – 2010 | Shivmohan Purohit's Oracle Applications Blog

  4. I have devloped few custom report which show all the information of payable R12
    1) Supplier Ledger
    2) Supplier Trial Balance
    3) Supplier Advance(Pre payment) Register
    4) Supplier Advance Adjustment (Pre payment) Register
    5) Supplier Liability Report
    6) Supplier Aging Report
    7) AP Reconciliation Report
    1) Supplier Ledger
    2) Supplier Trial Balance
    3) Supplier Advance(Pre payment) Register
    4) Supplier Advance Adjustment (Pre payment) Register
    5) Supplier Liability Report
    6) Supplier Aging Report
    7) AP Reconciliation Report
    with help of this new develop reports complated your AP reco.and give 100% reco in oracle payable R12
    Supplier Trial Balance (100 $) =
    Supplier Ledger (100$) =
    (Supplier Liability Report (120$)- Supplier Advance Adjustment (Pre payment) Register 20$) =
    Supplier Aging Report (100$)=
    AP Reconciliation Report 100$ (GL(110$) and SLA (100$)
    If GL SLA then display all the information of rest of trans… for 10 $)
    This reports are very accurate (100%) even we can fire with back dated also.

    Nilesh789@yahoo.com

  5. Pingback: KnowOracle – Top Documents – Most Read articles « Oracle Applications – Business & Technology

  6. it is really useful information. but i was woundering if it is differ with R 12i ,at payable trial balance there are 3 columns as the following :

    1- Gl balance

    2- Original amount

    3- Remainaing

    Q what does remain ing means?

    Thanks

  7. hey really useful information…
    thanks a lot… keep blogging…..

  8. I saw the Formula. I need some example how it will calculate the formula for GL.EX Dollars Amount

    “Accounts Payable Trial Balance” as of March 31
    + “Posted Invoice Register” for the period between April 1 and April 30
    - “Posted Payment Register” for the period between April 1 and April 30
    = “Accounts Payable Trial Balance” as of April 30

    Reconciling AP to GL is accomplished with the use of the following reports

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s