Project Management

Get Involved. Join the Conversation.

Posts

  • Paul Fernandez
    How to prevent an expenditure being charged to an...2
    Topic posted August 5, 2019 by Paul FernandezBlue Ribbon: 750+ Points, tagged Grants Management, Project Costing 
    Title:
    How to prevent an expenditure being charged to an award/contract temporarily in Projects/Grants?
    Summary:
    How to prevent an expenditure being charged to an award/contract temporarily in Projects/Grants?
    Content:

    Client would like to prevent any expenditure from being charged to a contract/award temporarily if there is any issue with the contract.  They would like to do it by controlling the contract and not the project because the project is funded by other awards/contracts as well.

    How can we do it?

    I tried putting the contract on hold as well as putting it in amended status. Both do not prevent expenditures from being charged to the award/contract.

    Is there a way to do it and if so how? Any input/suggestion appreciated

    Thanks and regards

    --Paul

  • Amit Mishra
    Update Contracts and Project DFF via Excel2
    Topic posted August 6, 2019 by Amit MishraRed Ribbon: 250+ Points, tagged Project Billing & Revenue, Project Contracts, Project Costing, Project Management, Project Performance Reporting, Project Planning & Scheduling, Project Planning, Budgeting, & Forecasting 
    Title:
    Update Contracts and Project DFF via Excel
    Summary:
    Can we update contract and project attributes using an excel utility (ADFDI or FBDI etc.) ?
    Content:

    Hi All,

    We have recently opened a couple of new DFFattributes on contract, contract line, project and task levels. We need to update the values in those attributes for all the active contracts and projects. What is the simplest way to update those attributes without having any technical development like web services etc.?

    Appreciate your help !!!

    Thanks/Amit

     

    Version:
    19B
  • Dave McKenna
    Baselined Budget Security and Control
    Topic posted August 15, 2019 by Dave McKennaBlue Ribbon: 750+ Points 
    Title:
    Baselined Budget Security and Control
    Summary:
    Financial Plan restrict updates to budgets once baselined
    Content:

    We have two similar requirements for research grant funded project, dont beleive we can do this but wanted to check.  We are creatin Financlai Plans for Sponsored budgets and have two requirements.

    1 Once a Budget is baselined for the first time it should lock any further updates to the budget and not allow movement of budget between Project tasks and resources.

    2 Once a budget is baselined only certain tasks and resources are allowed to have movement and transfers.

    Is there any controls we can out in place except for workflow approval and the approver checking.

     

    Version:
    19c
  • kent steckbeck
    Reclassing an Expenditure type1
    Topic posted August 12, 2019 by kent steckbeckRed Ribbon: 250+ Points, tagged Payables, Project Costing, Project Planning & Scheduling 
    Title:
    Reclassing an Expenditure type
    Summary:
    I'm trying to reclass or add to an expenditure type without affecting the GL.
    Content:

    How to add or reclass costs coded or miscoded to an expenditure type without affecting the G/L or having to invoice through Accounts Payable.

    Version:
    Oracle Cloud R13 19B
  • Madhav Jupalli
    Control account restriction on Project miscellaneous costs
    Topic posted August 14, 2019 by Madhav JupalliGreen Ribbon: 100+ Points, tagged Accounting Hub Cloud Service, Project Costing 
    Title:
    Control account restriction on Project miscellaneous costs
    Summary:
    Control account restriction on Project miscellaneous costs 19B vs 19C
    Content:

    Any natural account designated as "Restrict GL Manual Journals" is not allowed to be used in Capture Costs (ADFDI) in 19B, but in 19C this restriction is removed and users can use these control accounts. Even though we use SLA to derive raw cost debit account users are allowed to specify the credit account in the spreadsheet and now that these control accounts are allowed is going to create some reconciliation issues. Wondering if anyone tested this and any thoughts from development.

  • Caio
    Restrict project values of project field for specific users...85.0
    Topic last edited July 19, 2019 by CaioGold Medal: 3,500+ Points 
    Title:
    Restrict project values of project field for specific users on Self Service Procurement
    Summary:
    Restrict project values of project field for specific users
    Content:

    When a user is creating a requisition for an specific project, is it possible to ensure that the project values available to the user on the project field, are only the projects that the respective user is allowed to view ?

  • Udit Manchanda
    ADFDI /FBDI template to Load Data in Parties Tab in Project
    Topic posted August 13, 2019 by Udit ManchandaBlue Ribbon: 750+ Points, tagged Project Costing, Project Management 
    Title:
    ADFDI /FBDI template to Load Data in Parties Tab in Project
    Summary:
    ADFDI /FBDI template to Load Data in Parties Tab in Project
    Content:

    Hi,

    Please let me know if we have any template to Bulk Load Project Team Member in Parties Tab for all Projects.

    Below is the navigation.

    Projects -> Project Financial Management -> Search and Open a Project -> Go to Manage Financial Project Settings -> Click the Edit Button and then the Parties Tab:

    Regards

    Udit

  • Mayur
    Generate Borrow and Lent for fix amount
    Topic posted August 12, 2019 by Mayur, tagged Capital Projects, Project Costing 
    Title:
    Generate Borrow and Lent for fix amount
    Content:

    Hi, 

    Currently we are using Borrow and lent functionality. 
    We are using Cost to Cost and cost plus amount to generate borrow and lent. For both method working as per expectation. 

    We have one more requirement. 

    We want to generate Borrow and lent every month for Fixed amount. 
    i.e. We want to generate borrow and lent transaction for GBP 5000 every month. 
    The actual project cost will be from OTL, Misc. transaction, purchasing, payable and Inventory modules. this amount may be GBP 4000 or GBP 7000. 
    But we want to generate Borrow and lent every month for GBP 5000.

    Example

    We have project "***" in highway department, project "***" require some labor work, so department "NNN" is a service department, will provide service to highway project"***".

     

    Employee of "YYY" department will submit time sheet to project "***"

    Now at the month end following entry for OTL 
    Debit: --.***.101.---.-- (GBP 3000/7000) 
    Credit: --.YYY.---.---.-- (GBP 3000/7000) 

    After that we want to generate Borrow and lent transaction with GBP 5000 (fix amount) every month end. 
    (transferring of amount from one cost centre and analysis code to another cost centre and analysis code - with the help of Borrow and lent) 

    Debit: --.ZZZ..MMM.-- (MMM will change based on each project) 
    Credit: --.***.101.---.-- 

    So at project level month end we can know the cost of project and GL level also.

     

    Please help me to map this requirement.

     

    Thanks in Advance.

     

  • Mayur
    Received funding for project, want to capture the same and...
    Topic last edited August 12, 2019 by Mayur, tagged Capital Projects, Project Costing 
    Title:
    Received funding for project, want to capture the same and track the consumption
    Content:

    Hi 

    We are receiving funding for the project and we want to capture the same at project level. 
    We want to capture consumption of funding and remaining balance. 


    i.e. 
    We are receiving following types of funding. 
    Borrowing, capital receipts and reserve. 

    Project 1001 received "Capital receipts" GBP 10,000. 

    Now we will book cost from various module i.e. OTL, purchasing, Payables, Inventory. 
    We submit time sheet of employees to project 1001. (150 GBP/Hour * 10 Hours = 1,500 GBP) 

    Now at project level remaining funding of capital receipts GBP 8500 (10,000 - 1,500) 

    Provide you accounting detail. 
    Funding received should book at following combination - "E-9125-101-5001" - 10,000 

    Actual cost 
    Dr. E-14090-101-6506 - 1,500 (14090 - project task owning organization) 
    Cr. E- *** -100-6506 - 1,500 (***- map to employee organization) 

    At project level business want to capture 10,000 as advance as well actual cost. So project level project manager they can view remaining balance 8,500, funding received 10,000 and actual cost 1,500). 
    By accounting we want to achieve the remaining balance of 8,500, so at GL level also business can have an idea that 8,500 is remaining from funding. 

    Please help me to map this requirement.

    We PURCHASED license of Project Costing, Project control and Project Billing. Licence of Grants Management is NOT Purchased.

    Thanks in advance.

  • Avesh Ganodwala
    Do not hit revenue account in recievable for the complete...1
    Topic posted August 8, 2019 by Avesh GanodwalaSilver Medal: 2,000+ Points, tagged Project Billing & Revenue, Tip 
    Title:
    Do not hit revenue account in recievable for the complete amount
    Summary:
    Do not hit revenue account in recievable for the complete amount
    Content:

    Hi All,

    Our client has requirement where in they want the split the project revenue for the below screnario.

    The total funding of the project is 100K and out of that only 20K belongs to our client and rest to other vendor. however our client need raise the invoice for 100K as they are going to manage the complete project.

    As only 20K belogs to our client, when we raise the invoice we do not want hit our P&L for the complete amount.

    How to achieve this requirement.

    Regards,

    Avesh Ganodwal

     

    Version:
    19B