Project Management

Get Involved. Join the Conversation.

Topic

    Avesh Ganodwala
    General Ledger - Project Reconciliatoin report
    Topic posted September 6, 2018 by Avesh GanodwalaSilver Medal: 2,000+ Points, tagged Project Billing & Revenue, Project Contracts, Project Costing, Project Management, Project Performance Reporting, Project Planning & Scheduling 
    309 Views, 6 Comments
    Title:
    General Ledger - Project Reconciliatoin report
    Summary:
    We are trying to reconcile between Projects and General Ledger
    Content:

    Hi,

    we need a project to general ledger reconciliation report,is their any seeded report report available for reconciliation. However i could see a Project Cost Account Reconciliation report(analysis) but this shows only costing entries but not the revenue entries.

     

    Any suggestions to create the reconciliation report from analysis would be much appreciated.

    Regards,

    Avesh Ganodwala

    Version:
    R13

    Comment

     

    • Perry Unrau

      No, there is not a seeded revenue account reconciliation report, but you should be able to fairly easily create one.  Suggest you follow the project cost account reconciliation analysis pattern, selecting the equivalent columns from the equivalent folders in the Project Billing - Revenue Real Time subject area and building the equivalent filters.

      Perry

       

    • Avesh Ganodwala

      Hi Perry,

       

      Could you please let me know how do i view the columns of the analysis as i think i cannot view the columns of seeded analysis (project cost account reconciliation analysis)  or where i can see the columns of the project cost account reconciliation analysis.

       

      Regards,

      Avesh Ganodwala

      • Evan Danek

        If you're building an analysis (OTBI) then you're going to have all necessary roles, and data access for those roles, to view any results. So that would be a couple of the Contract roles and a role for Project Billing, as well as data access for all of them (accessed through setup and maintenance).

        Also, make sure you are using the "Real Time" subject areas. They are the only ones that will return results from a fusion datasource.

    • Evan Danek

      This is something that the accounting department at my company has struggled with for some time as well. We have had a vendor build out a reconciliation report in BIP, and also created some of the above mentioned analyses in OTBI to cover the project revenue/ project billing components (we are not live on those yet).

      It would be great if Oracle could provide a reconciliation out of the box!

    • Avesh Ganodwala

      Hi Evan,

       

      Is it possible for you to tell the columns to be selected to create the project revenue reconciliation analysis.

       

      Regards,

      Avesh Ganodwala

      • Evan Danek

        I can't find the one I created previously, but I definitely used subject areas Project Billing - Invoices Real Time and Project Billing - Revenue Real Time. Might be best to create a dashboard out of 2 analyses.