Example
For example, assume you assign one asset to Capital Project Y at the project level. You charge the following expenditure items to the project, all of which are capitalizable and charged to the same CIP account:
|
Supplies
| Operating
| 5,000.00
|
Supplies
| Operating
| 20,000.00
|
Professional
| Labor
| 5,800.00
|
Clerical
| Labor
| 1,500.00
|
Computer
| Service Center
| 14,000.00
|
Meals
| Travel
| 300.00
|
Lodging
| Travel
| 500.00
|
Air Travel
| Travel
| 900.00
|
Miscellaneous
| Operating
| 5,000.00
|
|
TOTAL COSTS
| 53,000.00
|
If you group by Expenditure Category, Oracle Projects creates the following asset lines:
Labor
| 7,300.00
|
Operating
| 30,000.00
|
Service Center
| 14,000.00
|
Travel
| 1,700.00
|
If you group by Expenditure Type, Oracle Projects creates the following asset lines:
Air Travel
| 900.00
|
Clerical
| 1,500.00
|
Computer
| 14,000.00
|
Lodging
| 500.00
|
Meals
| 300.00
|
Miscellaneous
| 5,000.00
|
Professional
| 5,800.00
|
Supplies
| 25,000.00
|
If you group All, Oracle Projects creates the following asset line:
Prerequisites
Before you run the Generate Asset Lines process, you must cost the transactions by running the processes listed below. You do not need to interface these costs to Oracle General Ledger before you create asset lines.
- Distribute Expense Report Costs
- Distribute Supplier Invoice Adjustments
- Interface Supplier Invoices to Oracle Projects
- Distribute Total Burdened Costs (if you are capitalizing burdened CIP costs)
Before you run the Generate Asset Lines process, you must also run the Update Project Summary Amounts process. If you fail to run Update Project Summary Amounts, you will not see the total expensed and CIP amounts in the Capital Projects Sumary window.
To generate summary asset lines for a single project:
1. Navigate to the Capital Projects window.
2. Find the capital project for which you want to generate asset lines.
3. Choose the Generate button.
4. Enter the In Service Date Through. Oracle Projects creates asset lines from assets with an actual date placed in service before and including this date only.
5. If you choose to Include Common Costs, Oracle Projects creates asset lines from costs not assigned to specific assets.
6. Choose OK to submit the Generate Asset Lines process. Oracle Projects creates asset lines for your project and runs the Generate Asset Lines Report.
To generate summary asset lines for a range of projects:
- Choose PRC: Generate Asset Lines process in the Submit Request window and enter the project or range of projects, and the in service date through you want to process. Choose Submit to generate asset lines and run the Generate Asset Lines Report. Review the report to verify the creation of asset lines.
See Also
Generate Asset Lines
Use Grouping Levels to Summarize Asset Costs
Adjusting Assets After Interface
Creating and Preparing Asset Lines for Oracle Assets
Reviewing Asset Lines