Agreements and Project Funding

This chapter covers the following topics:

Agreements

In Oracle Projects, an agreement represents any form of contract, written or verbal, between you and one of your customers. For example, an agreement may correspond to a purchase order, a continuing service agreement, or a verbal authorization.

Related Topics

Entering Agreements

Defining an Agreement

An agreement provides the funding for projects and tasks. Each agreement you define includes the following items:

If you specify a hard revenue and invoice limit on an agreement, Oracle Projects prevents revenue accrual and billing activity beyond the amount you funded to a particular project or task.

If you specify a soft revenue and invoice limit, Oracle Projects provides a warning telling you when revenue and billing for the project exceeds the amount you funded.

Note: You can specify a hard limit for both revenue and invoice limit, or a hard limit for revenue or invoice limit.

No project or task can accrue revenue without an agreement to fund its revenue budget.

Entering Agreements

You can enter an agreement representing a purchase order, retainer letter, or any other funding agreement you make with a customer in any currency regardless of your project functional currency. When you record an agreement, you can specify payment terms for invoices against the agreement, and whether there are limits to the amount of revenue you can accrue and bill against the agreement. See also Agreement Templates and Quick Agreement/Funding Projects.

If it is required by your business, you can apply advance receipts to an agreement.

From the Agreements window, you can open the Funding window to allocate funds to one or more projects (or to top tasks within a project), and to see how much unused funding remains for an agreement. Each agreement that funds a project can be entered in a different currency.

For any agreement, you can review the revenue and billing activity associated with the agreement, such as the amount of revenue accrued, the amount invoiced, and the amount of funding that is allocated and has a baseline.

All revenue and invoices in Oracle Projects are recorded against an agreement, and all items that accrue revenue against an agreement subsequently bill against the same agreement.

To enter an agreement

  1. Navigate to the Agreement window.

  2. Enter the Customer who is providing the agreement funding.

  3. Enter the name of the operating unit to which the agreement belongs.

  4. Enter a Number to identify this agreement, such as the customer's purchase order number.

    The agreement number must be unique for this customer and agreement type, although two customers can each have an agreement with an identical agreement number.

    Important: You cannot change this number once you create an invoice against this agreement and interface the invoice to Oracle Receivables.

  5. Enter an agreement Type.

  6. Choose the currency code of the agreement from the list of values. The list of values is restricted to the currencies defined in Oracle General Ledger.

    Note: The currency field can only be updated if the Multi Currency Billing implementation option is enabled at the operating unit and the funds have not been allocated.

  7. Enter the Amount of this agreement.

  8. Enter the payment terms (defined in Oracle Receivables) for any invoices funded by this agreement.

  9. Choose the Revenue Hard Limit or/and Invoice Hard Limit check box to impose a hard limit on revenue accrual and invoice generation for projects funded by this agreement. Otherwise, Oracle Projects imposes a soft limit.

    A hard limit prevents revenue accrual and invoice generation beyond the amount allocated to a project or task by this agreement. A soft limit issues a warning when revenue accrual and invoice generation exceed the amount allocated to a project or task.

  10. If advance receipts application is required by your business, enable Advance Required.

  11. Enter a start date and an expiration date for the agreement. You can leave the expiration date blank if you do not want the agreement to expire. If you generate draft revenue or an invoice for projects funded by this agreement after the agreement expiration date, Oracle Projects creates distribution warnings for revenue and invoices.

  12. Optionally enter a Description of this agreement.

  13. Enter the administrator of the agreement.

    Note: An agreement administrator can be a future-dated employee. However, this is not recommended or likely, because agreement owners are almost always current employees.

  14. Enter the name of the organization that owns the agreement.

    Note: You can choose any project owning organization (in the project owning organization hierarchy assigned to the operating unit) as the organization that owns the agreement.

  15. Enter a Creation Date.

  16. If you want to control the order in which the Agreement funding is consumed, then enter a Billing Sequence Number.

  17. Optionally enter Customer Order Number and Line of Accounting.

  18. Save your work.

Agreements with Advance Payments

You can require advance payments on an agreement and record advance payments as they are made. When you generate draft invoices for projects that are funded by the agreement, the advance balance that is displayed on the funding summary is reduced. You then interface the invoice to Receivables. The AutoInvoice process in Oracle Receivables reduces the balance on the advance.

You cannot apply advance payments to agreements that fund intercompany projects or projects in other operating units.

Note: If an agreement is Advance Required enabled and a portion of the funding available is allocated to a project, you must apply receipts to enable further funding and view total and available agreement funding amounts.

Requiring Advance Payments

You can set up an agreement to require advance payments by selecting the Advance Required on the agreement. You can also use the Advance Required client extension to determine which agreements require advance payments. On these agreements, you can enter funding only up to the amount of advance payments.

The ability to change the Advance Required agreement option is controlled by function security.

Entering an Advance Payment

You enter advance payments in Oracle Receivables. When you enter advance payments in Oracle Receivables, you enter the following attributes:

Applying a Receipt

To apply advance payments:

  1. In the Agreements window, query the agreement to which you want to apply payments.

  2. Choose Apply Receipts.

  3. In the Apply Receipts window, select a receipt. The receipts that are displayed are those that have been entered for the agreement customer in the agreement currency, and that have not been fully applied.

  4. The On Account Amount field displays the amount remaining to be applied from the selected receipt. Enter the Advance Amount that you want to apply to the agreement.

You can apply multiple receipts can be applied to one agreement. You cannot apply the same receipt to multiple agreements.

Canceling Application of a Receipt

To cancel ("unapply") advance payments:

  1. In the Agreements window, query the agreement to which you want to cancel an advance payment.

  2. Choose Unapply Receipts.

  3. In the Unapply Receipts window, select a receipt. The receipts that are displayed are those that have been applied to the agreement.

  4. Choose Unapply Receipt.

Viewing Receipts

To view receipts applied to an agreement:

  1. In the Agreements window, query the agreement to which you want to apply payments.

  2. Choose View Receipts.

  3. The View Receipts window displays receipts that have been applied to the agreement.

Viewing Agreement Summary Amounts

To view agreement summary amounts:

  1. Query the agreement you want to review in the Agreement window. The Summary Amounts region displays the overall agreement amounts in the agreement's currency for the following:

    • Amount of the Agreement

    • Allocated, Not Baseline Funding

    • Allocated, Baseline Funding

    • Not Allocated

    • Net Revenue

    • Revenue Write-off

    • Invoiced Amount

    • Advance Amount

  2. Choose the Summary button to view the funding and billing amounts for the agreement in more detail in the Summary Project Funding window.

  3. Choose Funding History in the Funding Summary window to view the allocation history for this agreement.

Project Funding

You must fund a project before the project can accrue revenue and be billed. Funding is the step that allocates an amount associated with a customer agreement to a specific project. The total amount of allocated project funding must equal the current approved project revenue budget amount in order to successfully baseline the project. Optionally, top tasks on projects can be individually funded. If top tasks are funded, then the same requirement of matching budget amounts to funding amounts applies at the top task level of the project.

Oracle Projects allows you to define agreements, projects, and tasks to organize your project work. Funding Multiple Projects and Tasksillustration represents an example of how you can use an agreement to fund multiple projects and tasks.

In this example, a single agreement is used to fund four projects. The agreement has a total value of $150,000. The amount funded is $125,000.

The Agreements section describes how to use agreements to fund projects and tasks in more detail.

Funding Multiple Projects and Tasks

the picture is described in the document text

In Oracle Projects, an agreement represents any form of contract, written or verbal, between you and one of your customers. For example, an agreement may correspond to a purchase order, a continuing service agreement, or a verbal authorization.

Related Topics

Entering Agreements

Fund Across Operating Units

You can fund different projects across operating units by enabling the Allow Funding Across Operating Units functionality in the Billing tab of the Implementation Options window. See: Allow Funding Across Operating Units, Oracle Projects Implementation Guide

Fund at the Project Level

There are many different ways to link agreements, projects and tasks. You should learn the benefits and consequences of each method to create clear policies.

If you use the Date-Effective Funds Consumption option on a project, the billing sequence and effective dates for each agreement determine the order in which agreements/customers are invoiced for projects funded by multiple agreements. Amounts are not prorated between agreements when hard limits are met. In this case, you do not specify a percentage contribution for each customer.

One Customer, One Agreement

Use one agreement when you have one customer and one contract.

This should be your most frequent case. All revenue is accrued and all invoices billed against the same agreement. The same agreement may fund other projects without changing the operation of the system.

Multiple Customers, One Agreement Per Customer

Use one agreement per customer when you have multiple paying customers, no additional contracts with any of the customers, and a requirement to invoice by contract.

All revenue and invoice amounts are divided between customers according to the percentage splits defined for the project in the Customers and Contract Project options. Each run of revenue generation creates one draft revenue per customer, and each run of invoice generation creates one draft invoice per customer. The draft revenue and invoices for all customers contain the same items, but with prorated amounts.

Oracle Projects supports only one percentage split between customers over the life of a project. You cannot change an existing percentage split.

One Customer, Multiple Agreements

Use multiple agreements when you have one customer, but several contracts, and a requirement to invoice by contract.

For example, a project that was originally funded by one purchase order is subsequently funded by another purchase order. The customer has requested that each invoice reference a specific purchase order. In this case, you would fund the project from two agreements, one for each purchase order. The PRC: Generate Draft Invoice process produces two invoices - one against each purchase order agreement from which funding is used.

When generating an invoice for expenditure items or events for a project that is enabled for Date-Effective Funds Consumption and has multiple agreements with available funds, the billing process first looks at the start date and end dates of the agreements.

If the expenditure items or events fall within the dates of more than one agreement, the billing process uses the billing sequence number to determine the application order of agreements. If the Date-Effective Funds Consumption option on a project is not enabled, the billing process uses hard limit agreements first followed by soft limit agreements in order of agreement expiration date and prorates items between the agreements used.

Multiple Customers, Multiple Agreements Per Customer

Use multiple agreements per customer when you have multiple paying customers, multiple contracts with one or more of the customers, and a requirement to invoice by contract.

This method is a combination of the two above. Revenue is prorated between the customers according to their percentage split. For each customer, revenue is placed on agreements by the same rules as for multiple agreements and a single customer.

Fund at the Task Level

One Customer, One Agreement

Use one agreement when you have one customer and one contract.

Use this method only if you want to accrue revenue cost-to-cost at the task level or impose hard or soft revenue limits at the task level.

Task level funding with one agreement does NOT create separate task invoices. However, you can define an invoice format to group expenditure items by task.

Important: If you enter funding for a project at the top task level, you must assign invoice formats (for labor, non-labor, and retention) to the project that use a top task level grouping option. You assign invoice formats in the Revenue and Billing Information window. If you assign invoice formats that use a project level grouping option, Oracle Projects does not generate invoices for the project.

If you enter funding for a project at the project level, you can assign invoice formats to the project that a use either a project level or top task level grouping option.

Case Study: Funding for Hard Limits at the Task Level

Fremont Corporation has a contract with XYZ Company for $100.000. There are three phases to the project, each with a separate hard limit. Each phase is set up as a top task, and funded with a hard revenue limit:

One Customer, Multiple Agreements

Use multiple agreements when you have one customer, but a requirement to create a separate invoice for each top task.

You can use this method to accrue revenue cost-to-cost or impose hard or soft revenue limits by task, as well as automatically create separate invoices by task.

To create separate invoices by task, you must use a different agreement to fund each task. If you use more than one agreement for a single task, the agreements are used according to the precedence described earlier for projects.

For any agreement, you can review the revenue and billing activity associated with the agreement, such as the amount of revenue accrued, the amount invoiced, and the amount of funding that is allocated and has a baseline.

Multiple Customers, One Agreement Per Customer

Use one agreement per customer when you have multiple paying customers with one customer paying for each piece of the work, no additional contracts with your customers, and a requirement to invoice by contract.

Note: To define project customers with no contribution and associate them with each top task, enable Customer at Top Task on the project Revenue and Billing Information option.

To define project customers with no contribution (so that the system uses Date-Effective Funds Consumption logic to determine what to bill each customer) and fund the project at the task level, enable Date-Effective Funds Consumption as part of the project Revenue and Billing Information option.

Multiple Customers, Multiple Agreements Per Customer

Use multiple agreements per customer when you have multiple paying customers with one customer paying for each piece of the work, multiple contracts with one or more of the customers, and a requirement to invoice by contract.

Note: To define project customers with no contribution and associate them with each top task, enable Customer at Top Task on the project Revenue and Billing Information option. Oracle Project Billing then groups all revenue and invoice amounts by top task and bills the customer associated withthe top task.

To define project customers with no contribution (so that the system uses Date-Effective Funds Consumption logic to determine what to bill each customer) and fund the project at the task level, enable Date-Effective Funds Consumption as part of the project Revenue and Billing Information option.

Funding Multiple Projects With One Agreement

You can allocate funds from one agreement to any number of projects or top level tasks.

If your business deals with very large contracts, and divides the work into separate projects, you can use one agreement to fund each project. You may assign some of the work to a time and materials project, other work to a fixed price project, and other related bid and proposal work to an indirect project. The agreement represents the total value of the contract. You can generate separate invoices for each contract project.

An agreement may also represent a contract to do an unspecified amount of work over a period of time. You can create a project as various pieces of work are defined. Each of these projects is funded by the master agreement.

Funding a Project

You can allocate an agreement's funds to a project or top-level task in the agreement's currency. Using conversion attributes, each funding amount in the agreement currency is converted to the project functional and project currency. You can divide these funds among several projects or tasks. In addition to allocating funds, you can reverse agreement funding from a project or task, up to the amount accrued or invoiced. See: Currency Conversion Attributes, Oracle Projects Fundamentals.

Note: You cannot fund at the task level for multiple-customer projects unless the Customer at Top Task option is enabled or the Date-Effective Funds Consumption option is enabled.

You can also view the funding line's baseline status for this project or task.

Note: Only baseline funding is used for revenue or invoice generation.

When a project is funded by amounts that are in more than one currency, the funding amounts are converted to a common currency to determine a project's total funding across all agreements. The processes that generate revenue and invoices for a project use this total amount. During revenue and invoice processing, Oracle Projects performs fund checking using the total funding amount in the project functional currency (revenue) and invoice processing currency (invoice).

Note: The funding currency can be used as the invoice processing currency only when all funding amounts are in the same currency.

To fund a project:

  1. Navigate to the Agreement form and query the agreement you want.

  2. Choose the Funding button.

  3. In the Fund Projects window, enter the number of the project you want to fund with this agreement. The list of values displayed for this field is dependent on the following:

    • If Allow Funding Across Operating Units is enabled for your operating unit, then:

      • The list of values contains projects from other operating units

    • If multi-currency is disabled for a project, then:

      • The list of values is restricted to projects whose project functional currency is the same as the agreement currency.

      • The list of values contains all projects for which the Allow Funding Across Operating Units functionality is enabled.

    • If multi-currency is enabled for a project, then:

      • The list of values contains all projects except projects whose invoice processing currency is selected as the funding currency, and that already have funding in a currency that is different from the agreement currency.

        For example, if a project with the invoice processing currency equal to the funding currency has already been funded by an agreement in GBP (agreement currency), then you cannot fund the project with another agreement in a different currency (EUR).

    • If receipts are applied to the agreement, then:

      • You cannot fund the projects from other operating units, and

      • You cannot fund the intercompany projects

  4. Enter the number of the top-level task you want to fund with this agreement. If you do not want to restrict funding for a particular task, leave this field blank.

    Note: If the project is funded at the task level and the Customer at Top Task option is enabled for the project, the list of values is restricted to the top tasks associated with the customer.

  5. Enter the Amount you want to allocate to this project or task.

  6. Enter a Date to record when you allocated agreement funds to this project or task. The Date Allocated is used as the rate date to determine the exchange rate when the Rate Date Type for the project's funding currency attribute is PA/Invoice Date.

  7. If you enter an agreement currency that is different from the project functional currency, use the Folder tools to enter the conversion attributes when you fund the agreement in the Fund Projects window.

  8. Enter the Funding Classification to indicate the nature of the allocations. Funding lines can be aggregated by funding classification and reported accordingly using Project Intelligence. See: Using Project Intelligence chapter in Oracle Daily Business Intelligence.

  9. Save your work.

Reviewing Project Funding Information

To review project funding information:

  1. Query the project or agreement in the Project Funding Inquiry window. See: Project Funding Inquiry Window Reference.

You can access the Project Funding Inquiry window can be accessed from the Fund Projects window.

Reversing Funds from a Project

To reverse funds from a project:

  1. Enter a negative amount if you want to reverse funds from a project or task and allocate the funds elsewhere, or to leave the funds available for future funding. You can decrease the funding amount up to the amount already accrued or invoiced for the project or task.

Related Topics

Currency, Oracle Projects Fundamentals

Currency Conversion Attributes, Oracle Projects Fundamentals

Funding Revaluation

Funding revaluation allows you to periodically revalue your project funding, taking into account the effects of currency fluctuations between funding and project functional currency. Companies operating in a multi currency environment, with fixed price contracts, typically require that project funding amounts reflect the fluctuations in the currency exchange rate by:

Revaluate Funding

Before generating revenue and processing invoices, funding is revalued to determine the total available funding on a project and to ensure that invoices are generated in accordance with the hard limits set. To revaluate funding, you run the following concurrent programs:

Projects are included in the concurrent programs and eligible for revaluation based on the following criteria:

Funding Revaluation Components

The Funding Revaluation process includes the following components:

To view the detailed components used in the Funding Revaluation process, you run the audit report AUD: Revaluated Funding Audit Report.

Funding Backlog

The Revaluate Funding process first determines the current project funding backlog amount. Project funding backlog is the remaining project funding available to be billed to the customers. The funding backlog subject to revaluation is the total baseline funding amount less invoices issued to customers, both paid and unpaid.

After deriving the funding backlog amount, the Funding Revaluation process calls the Funding Revaluation Factor client extension. The Funding Revaluation Factor client extension allows you to apply a funding revaluation factor to the funding backlog amount. This extension can be used to implement escalation indices defined for a contract. The factor can increase or decrease the funding backlog amount subject to revaluation and is applied to the funding backlog amount in the funding currency. The funding revaluation rate is applied to the funding backlog amount to derive the revaluated backlog amount in project functional and invoice processing currency.

The process then creates a net funding adjustment line with the funding line classification "Revaluation" in the project functional currency. The process adjusts the current value of project funding available for revenue and invoice processing. If you have the option "Baseline Funding Without Budget" enabled, you can automatically create a baseline for the funding adjustments and update the budgets as part of the revaluation process. If this option is not enabled, you must adjust the budgets and create a baseline for the funding adjustments manually after revaluating funding.

To enable funding revaluation for a project you must check the Revaluate Funding check box when you set up your project types and projects.

Note: Revaluated Backlog amounts are calculated for both the invoice processing currency (IPC) and the project functional currency (PFC).

Include Foreign Exchange Gains And Losses (FXGL)

You can optionally include gains and losses for paid and unpaid project invoices, in the Funding Revaluation process. The process calculates the foreign exchange gain or loss (FXGL) associated with the project and agreement, and adjusts project revenue accordingly. The gain or loss will increase or decrease the revenue for the project but will not affect the unbilled receivables or unearned revenue amounts.

To include the effects of the foreign exchange gains and losses in the project revenue, you must:

Paid Project Invoices

When cash is applied to invoices, Oracle Receivables calculates and posts the realized gains and losses to the General Ledger currency gain and loss accounts of the operating unit. The Revaluate Funding process includes these gains and losses on paid project invoices to record the effect of the transaction as a realized gain or loss against the project revenue.

Unpaid Project Invoices

Unpaid project invoices consist of all issued project invoices less AR cash receipts. Issued project invoices include all released project invoices whether or not they have been transferred to Oracle Receivables. Though the cash applied in AR may include tax and other components as defined by the cash application rules, the revaluation process considers only the cash applied to the invoice line type "Line."

The paid project invoices are deducted from the total project invoiced to determine the unpaid project invoice amounts. The resulting unpaid project invoice amount is revalued by applying the revaluation rate.

Note: When determining unpaid project invoice amounts with retention lines, cash receipt amounts applied to retention invoices are treated like regular invoices, except when retention is at the project level and funding is at the task level. In that case, applied cash is allocated at the task level on a first in first out basis. Cash is first applied to the earliest retention line at the task level. After that line is paid, the remaining cash is applied to the second retention line, and so on.

Revaluated Funding in Project Functional Currency (PFC)

The revaluated funding in project functional currency is calculated as follows:

Total Revaluated Funding Amount in PFC = Revaluated Funding Backlog in PFC + Revaluated unpaid project invoice amount in PFC + Cash applied to project invoices in PFC + Realized Gains - Realized Losses.

The net funding adjustment in PFC = Total Revaluated funding amount in PFC - Total baseline funding amount in PFC before revaluation.

Revaluated Funding in Invoice Processing Currency (IPC)

Funding revaluation needs to be performed in the invoice processing currency to revalue the backlog in IPC to control future invoicing. The revaluated funding in invoice processing currency is calculated as follows:

Total Revaluated Funding Amount in IPC = Revaluated Funding backlog in IPC

The net funding adjustment in IPC = Total Revaluated funding amount in IPC - Prior baseline funding adjustment amount in IPC - Funding backlog in IPC before revaluation

To track your revaluation currency gains and losses differently from the unbilled receivable realized gains and loss account, you must set up function transactions called Realized Gains Account and Realized Losses Account for the AutoAccounting function Revenue and Invoice Accounts. Oracle Projects uses AutoAccounting to determine the default realized gains and realized losses accounts.

Important: You must set up Oracle Projects AutoAccounting so that the derived accounts match the general ledger currency realized gains and realized losses accounts in Oracle Receivables.

If you define your own detailed accounting rules in Oracle Subledger Accounting, then Oracle Subledger Accounting overwrites default accounts, or individual segments of accounts, that Oracle Projects derives using AutoAccounting. If you define your own subledger accounting rules, then you must set up rules so that the derived accounts match the general ledger currency realized gains account and realized losses account in Oracle Receivables.

Reviewing Funding Adjustment Lines

You can view the various revaluation components of the funding adjustment line from the folder in the Funding History window. Navigate to the Project Funding Inquiry window and select an Agreement in the Summary by Agreement region. Click on the Funding History button. You can choose the various revaluation component fields to include in the folder.

Example of Funding Revaluation

Following is an example of how funding revaluation is calculated for a company whose functional currency is different from the funding currency.

In this example the company has the following agreement in place with a customer:

The following table shows the billing transactions that occur during the Jan-2001 period:

Date Description Funding Currency (GBP) Exchange Rate (GBP:USD) Project Functional Currency (USD) Exchange Rate (GBP:USD) Invoice Processing Currency (USD)
01-Jan-2001 Total project funding amount [A] 1,000,000 GBP   1,550,000 USD   1,550,000 USD
  Issued project invoices (includes paid and unpaid) [B+C=F] 300,000 GBP   465,000 USD   465,000 USD
  Project funding backlog [A-F=G] 700,000 GBP   1,095,000 USD   1,095,000 USD
  AR cash receipt to project invoices during the period[D] (200,000) GBP   (310,000) USD    
  AR Realized Gain/Loss from cash receipts to project invoices [E]     -2000 USD    
  Project invoices issued but not paid [F-D=H] 100,000 GBP        
31-Jan-2001 Project funding to revaluate to project functional currency [G+H=I] 800,000 GBP        

Prior to generating revenue on 31-Jan-2001, the project funding in GBP is revalued in project functional currency. The currency exchange rate from GBP to USD on 31-Jan- 2001 is 1.58.

Revaluation to project functional currency on 31-Jan-2001 includes the following three components:

The project funding requiring revaluation is determined as shown by the following table:

Date Description Funding Currency (GBP) Exchange Rate (GBP:USD) Project Functional Currency (USD) Exchange Rate (GBP:USD) Invoice Processing Currency (USD)
01-Jan-2001 Total project funding amount [A] 1,000,000 GBP   1,550,000 USD   1,550,000 USD
  Issued project invoices (includes paid and unpaid) [B+C=F] 300,000 GBP   465,000 USD   465,000 USD
  Project funding backlog [A-F=G] 700,000 GBP   1,095,000 USD   1,095,000 USD
  AR cash receipt to project invoices during the period[D] (200,000) GBP   (310,000) USD    
  AR Realized Gain/Loss from cash receipts to project invoices [E]     -2000 USD    
  Project invoices issued but not paid [F-D=H] 100,000 GBP        
31-Jan-2001 Project funding to revaluate to project functional currency [G+H=I] 800,000 GBP        

The following table details the total project funding amount after revaluation:

Date Description Funding Currency (GBP) Exchange Rate (GBP:USD) Project Functional Currency (USD) Exchange Rate (GBP:USD) Invoice Processing Currency (USD)
  Project invoices issued but not paid [J] 1,000,000 GBP 1.58 1,580,000 USD    
  Project funding backlog [K] 700,000 GBP 1.58 1,106,000 USD 1.58 1,106,000 USD
  Project invoices paid [D]     (310,000) USD    
  AR Realized Gain/Loss from cash payments to project invoices [E]     -2000 USD    
31-Jan-2001 Total project funding amount after revaluation [L]     1,572,000 USD [L=J+K+D+E]   1,106,000 USD [L=K]

The revaluation process generates the funding adjustment line as detailed in the following table:

Date Description Funding Currency (GBP) Project Functional Currency (USD) Invoice Processing Currency (USD)
31-Jan-2001 Funding Revaluation Adjustment [M]   22,000 USD [L-A] 11,000 USD [L-G]

A new event line is created as shown in the following table:

Event Type Event Amount (Project Functional Currency)
Realized Loss 2000 USD

After generating project revenue and revenue accounting events, the accounting entries for the realized loss are as follows:

Dr. Event Revenue Account 2000

Cr. Realized Losses Account 2000

Dr. Realized Losses Account 2000

Cr. Project Specific Realized Losses 2000

Related Topics

Revaluated Funding Audit Report, Oracle Projects Fundamentals

Revaluate Funding for a Single Project, Oracle Projects Fundamentals

Revaluate Funding for a Range of Projects, Oracle Projects Fundamentals

Delete Revaluated Funding for a Range of Projects, Oracle Projects Fundamentals

Funding Revaluation Factor Client Extension, Oracle Projects APIs, Client Extensions, and Open Interfaces Reference

Implementation Options, Oracle Projects Implementation Guide

Event Types, Oracle Projects Implementation Guide

Project Types, Oracle Projects Implementation Guide

Project Types: Billing Information, Oracle Projects Implementation Guide

Accounting for Revenue and Invoices, Oracle Projects Implementation Guide

Project Funding Inquiry Window Reference

Use this Project Funding Inquiry window to view information about project funding and to baseline your budget automatically. For a given project, you can view the amount invoiced, the amount of net revenue accrued, the revenue write-off balances, as well as other funding information.

You can view summary amounts for funding allocated to a particular project by agreement and top level task, such as baseline amounts, the amount of revenue accrued and invoiced, as well as the customer providing agreement funding. Amounts can be viewed in the project functional, project, funding currency, or invoice processing currency by selecting the respective tabbed region. Funding amounts can be viewed only when all project funding is in the same currency.

You can also use this window to view a history of project funding allocation, such as the incremental allocation amounts, and the allocation date.

You can use the Project Retention Inquiry window to review retention information, see Reviewing Retention Information.

Baseline a Budget

You can also use this window to baseline a revenue budget if the Baseline Funding Without Budget option is enabled in the Revenue and Billing Information window. See: Project Types: Funding, Oracle Projects Implementation Guide. Click on the Baseline Funding button to baseline the funding and create a revenue budget for the project. A revenue budget is created for the project that includes all funding from the agreements that fund the project. The revenue budget has the following attributes:

If funding changes for a project, you can baseline the funding again. A new version of the budget is created each time the funding has a baseline.

Note: When a budget is created by baseline funding, you cannot change the budget lines or version using the budget windows. The budget can only be viewed. In addition, once you have used the system defined budget entry methods, they cannot be modified.

Funding

Currency: Currency in which the amounts are displayed.

Not Baselined: The total funding amount that does not have a baseline for this project or task.

Baselined: The total funding amount that has a baseline for this project or task.

Total: The total funding allocated to this project or task.

Billing

Net Revenue: The net amount of revenue accrued for this project or task, regardless of revenue transfer status.

Revenue Write-Off: The total amount of revenue write-off events.

Invoiced Amount: The total amount invoiced for this project including any retention amount withheld, regardless of invoice transfer status.

Retention

Withheld: The total amount of retention withheld for this project or top task.

Billed: The total amount of withheld retention billed for this project or top task.

Note: If you fund your project at the top task and retention level is at the project level, the Summary Amounts region will not display withheld and billed retention information.

Funding Summary by Agreement

Funding amounts can be viewed in the project functional currency. To view funding amounts for each agreement in the project, funding, and invoice processing currency, use the folder to select the fields for display.

Agreement Number: The agreement number from which funds are allocated.

Top Task Number: The task number to which funds are allocated, if you have funded your project at the top level task level.

Funding History Window

Funding amounts are in the funding/agreement currency. To view funding amounts in the project, funding, and invoice processing currency, use the folder technology to select the fields for display.

Date: The date this funding line was allocated.

By: The person responsible for allocating this funding line.

Funding Amount: The incremental amount of agreement funding allocated by this detail funding line.

Funding Classification: Funding classification of the funding line.

Baselined: This check box indicates whether the funding line has a baseline.

Quick Agreement / Funding Projects

Many companies have short-term projects, lasting one to ten days, which they want to bill. Oracle Projects provides an easy way to set up these short-term contract projects. You can create a project template that is associated with an agreement, funding, and baseline budgets. When you create a new project by copying the template, the agreement funding, and baseline budgets will also be copied to the new project.

The project template is funded with an agreement template; the revenue budget and funding may have a baseline. When you copy a new project from the project template, you specify the customer in the Quick Entry options, and Oracle Projects copies the agreement, funding, and baseline budgets from the template to the project. You can specify the agreement amount in Quick Entry. If the project is of short duration, you may elect to have a nominal agreement amount (such as $1.00) with a soft limit.

Related Topics

Project Templates for Quick Agreement

Agreement Template

Funding a Project Template

Budgeting for Project Templates

Copying a Template to Create a Quick Agreement Project

Project Templates for Quick Agreement

Project Options

When you are creating a project template that will be used to create a quick agreement, you must enter a customer in the Customer option of the project. You will use this customer in the agreement template that creates the agreement/funding for the quick agreement project. You can only have one customer in a template that will be used to create Quick Agreement projects. The customer billing contribution must equal 100%. If you have more than one customer in the project template, you will not be able to associate the project template with an agreement template.

Define any other project and task options that are appropriate for the project. A Quick Agreement template has no special restrictions or requirements other than those noted in the above paragraph.

Quick Entry Setup

When creating a project template for quick agreement projects, you must enable the Customer field in the Quick Entry setup. You then select the customer relationship to use when creating the project customer (primary, for example). When you create a project by copying the template, you enter the appropriate customer in Quick Entry. The customer in the agreement template will be replaced by the customer you enter in Quick Entry.

You can also enter an agreement amount and agreement owning organization in the quick entry fields.

Enable any other Quick Entry fields that are appropriate for the project. A Quick Agreement template has no special restrictions or requirements other than those noted in the above paragraph.

Related Topics

Project Template Design Considerations, Oracle Projects Fundamentals

Defining Quick Entry Fields, Oracle Projects Fundamentals

Agreement Template

To create a Quick Agreement, you set up an agreement template that will be associated with a project template. See: Defining Agreement Templates, Oracle Projects Implementation Guide.

A project created from the project template associated with the agreement template will have an agreement created for it with the values entered in the agreement template. The only exceptions are the Agreement Number and Expiration Date. The Agreement Number will be the same as the Project Number you enter in Quick Entry. The Expiration Date will be based on the relationship between the project start date and the agreement template Expiration Date.

For example, if the project start date of the project template is January 1, 1996, the agreement template expiration date is January 10, 1996, and the new project's start date is July 15, 1996, then the agreement for the new project will be created with an expiration date of July 25, 1996.

Agreement templates can only be viewed in the Agreement Template Entry window. You cannot view agreement templates in the Agreement Entry window.

Related Topics

Entering Agreements

Creating a Quick Agreement Project

To create a quick agreement project

  1. Set up a Project Template with a Customer Quick Entry field and a customer defined in the project option.

  2. Set up an Agreement Template with the same customer entered in the Customer option in the Project Template.

  3. Select any currency as well as a default owning organization for the Agreement template.

  4. Within the Agreement Template, fund the Project Template at either the project or task level.

  5. Create a revenue and/or cost budget for the Project Template. Baseline the budgets.

  6. Copy the Project Template to a new project. The new project will be ready to bill as soon as it is created.

Funding a Project Template

Each agreement template that funds a project template can fund only one project template. Conversely, each project template can only be funded by one agreement template.

When you fund an agreement template, only project templates (not projects) will be listed in the Project List of Values.

When you create a new project from the project template associated with the agreement template, you enter a starting date for the project. The funding date for the new project will be based on the funding date you entered in the agreement template, adjusted by the difference between the project template start date and the project start date.

For example, if the funding date in the agreement template is January 1, 1997 and the project template has a start date of June 1, 1996, when you create a new project whose start date is July 15, 1996, The funding for the new project will have an allocation date of July 15, 1997.

You can fund agreement templates at either the project or task level.

Copying a Template to Create a Quick Agreement Project

To create a Quick Agreement Project, you select a template to copy. Oracle Projects copies the template to the new project, along with the agreement, funding, and baseline budgets based on the following rules:

Budgeting for Project Templates

Enter budgets for the project template you will use to create Quick Agreements. After the budgets are created, baseline the budgets. New projects created from the template will have baseline budgets equal to the amounts entered in the budgets for the project template.

Related Topics

Budget Entry, Oracle Project Management User Guide