Reporting and Analytics for ERP

Get Involved. Join the Conversation.


    Elliot Hall-Walker
    Accounts Receivable Reconciliation Report
    Topic posted August 20, 2019 by Elliot Hall-WalkerGreen Ribbon: 100+ Points, last edited August 20, 2019, tagged BI Publisher, Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Reports 
    66 Views, 3 Comments
    Accounts Receivable Reconciliation Report


    I am looking to build a reconciliation focusing on the Accounts receivable transactions, I want to show the number of Accounts Receivable transactions that are currently unreconcilled:

    1. Does anyone know if this can be done in OTBI or is it a BI Publisher report?

    2. Has anyone built one successfully 

    OTBI on Cloud



    • Amar

      Did you check "Receivables to Ledger Reconciliation Report" from receivables?

      • Sudhakara Rao Kovuru

        Seeded Reports are available in the system so please check them and let me know.


        Receivables to Ledger Reconciliation
        Bank Statements and Reconciliation
        --> Cash to General Ledger Reconciliation Report
      • Elliot Hall-Walker

        Hi guys,

        I've checked the seeded reports and they aren't suitable to requirements, I am looking to reconcile the AR transactions to cash balances 

        i've attached  a screenshot of the AP version we built in OTBI for reference, however this cannot be replication for AR, so hoping ot build a BIP equivalent