Project Management

Get Involved. Join the Conversation.

Posts

  • 1-3 of 3
  • gabriel kinovisques
    How to Incur Accruals for Indirect Projects1
    Topic posted November 12, 2019 by gabriel kinovisquesRed Ribbon: 250+ Points, tagged Project Billing & Revenue, Project Contracts, Project Costing, Project Management, Project Performance Reporting, Project Planning & Scheduling, Project Planning, Budgeting, & Forecasting, Project Resource Management, Reports, Sample Reports, Tip 
    Title:
    How to Incur Accruals for Indirect Projects
    Summary:
    Expense Accruals for indirect Projects
    Content:

    Hello :

    We have a business requirement :

    The company provide one benefit to the employee called Mobile Phone for Managers up to 200 USD per Month.

    At the end of the Month the carrier i.e. ATT send the invoice to be paid for example 10,000 USD for all the mobiles phones and the AP invoice is fully paid to ATT.

    Once the ATT invoice has been paid Finance team review the invoice for each employee in order to check review the 200 USD threshold, so for example one manager spend 250 USD instead of 200 USD.

    In this case the manager owes 50 USD for the difference and this amount will be deducted from his payroll.

    Finance teams wants to book and expense accrual through Projects

    Debit Expense

    Credit Accrual

    This journal will be send to Payroll in order to deduct this amount for his payroll, and once they process the monthly Payroll they will send a Journal to be posted in General Ledger in order to confirm that 50 USD were deducted from his Payroll.

    Debit Accural 50

    Credit Banks or Wedge deductions 50

    Can we book those Expense Accruals troughs Projects or shall we book them trough GL instead ? If we book through GL we do not have a segment called Project.

    Please Advise

     

     

     

     

     

     

     

  • Dustin Grabowski
    Sample Report: Project Financial Management Cloud: Cost...5.0
    Topic posted November 4, 2016 by Dustin GrabowskiGold Medal: 3,500+ Points, tagged Fusion Project reporting, OBIEE Answers, OTBI, Reports, Sample Reports 
    Title:
    Sample Report: Project Financial Management Cloud: Cost Transaction Import Summary
    Content:

    This dashboard displays a summary of the cost transactions that have been successfully imported after a specific date.  The default is the last 7 days, and this can be changed in the dashboard prompts.  Additional filters can be supplied as needed to further refine the results by Business Unit, Transaction Source or Expenditure Batch.  The view selector allows for various charts and graphs to be displayed

     

    A detailed listing of the transactions is also provided.  The prompts and sections of the detail table can be changed in the base analysis.

    This data is applicable to Project Accountants that have been granted access to at least one Business Unit's project cost data.

    To add this report to your environment:

    1. Save the catalog to a local folder

    2. Unarchive it to the OTBI web catalog under Shared Folders - Custom - Projects

    3. In the folder called 'Cost Transaction Import Summary', open the dashboard called 'Cost Transaction Import Summary'

     

    Fusion Applications: 11.1.1.11.0+

    Subject areas used: Project Costing - Actual Costs Real Time

    5 minutes to copy into your environment.

    Image:
  • Dustin Grabowski
    Sample Report: Grants Management Cloud: Federal Awards...5.0
    Topic posted October 26, 2016 by Dustin GrabowskiGold Medal: 3,500+ Points, tagged Fusion Project reporting, OBIEE Answers, OTBI, Reports, Sample Reports 
    Title:
    Sample Report: Grants Management Cloud: Federal Awards without CFDA Number
    Summary:
    This analysis displays Federal Awards that do not have a CFDA Number assigned.
    Content:

    The attached sample analysis displays a summary and list of Federal Awards that do not have a CFDA Number assigned.  There are two analysis' included, the first (Federal Awards with CFDA) returns all Federal Awards with a CFDA Number assigned, and the main analysis (Federal Awards without CFDA) returns all Federal Awards that are not returned by the prior analysis, limiting the results to only those where a CFDA Number is not assigned.

    To add this report to your environment:

    1. Save the catalog to a local folder

    2. Unarchive it to the OTBI web catalog under Shared Folders - Custom - Projects

    3. In the folder called ''Federal Awards without CFDA', open the analysis called 'Federal Awards without CFDA'

     

    Fusion Applications: 11.1.1.11.0+

    Subject areas used: Projects - Grants Management - Award Funding Real Time

    5 minutes to copy into your environment.

    Image: