Viewing Cost History and Summarizing Cost Rows
Use the Review Cost (COST_HISTORY) component to review cost history for capitalized and non capitalized assets.
Use the Cost Summarization (AM_COST_SUM_RUN) component to summarize cost rows.
This topic provides overviews of cost history and cost summarization and discusses how to generate cost summarizations:
|
Page Name |
Definition Name |
Usage |
|---|---|---|
|
ASSET_TRANS_01 |
View a history of an asset's transactions. Physical Book Cost displays when book cost is categorized as physical as a result of Capitalization Threshold. This information does not display for a Financial book. |
|
|
Cost History Detail |
ASSET_TRANS_02 |
View more detail about a specific transaction. |
|
Non Cap History List |
ASSET_TRANS_03 |
View a history of a non capitalized asset's transactions. |
|
Non Cap History Detail |
ASSET_TRANS_04 |
View more detail about a specific transaction. |
|
AM_COST_SUM_RUN |
Generate cost summarizations. |
PeopleSoft enables you to view cost history of assets online. You can view cost history for both capitalized and non capitalized assets. Using the Cost History component, you can:
View a history of an asset's transactions on the Cost History List page.
View detail about a specific transaction on the Cost History Detail page.
View a history of a non capitalized asset's transactions on the Non Cap Cost History List page.
View more detail about a specific transaction on the Non Cap Cost History Detail page.
View physical book cost when book cost is categorized as physical as a result of Capitalization Threshold. This information does not display for a Financial book.
Multiple transactions coming from PeopleSoft feeder systems rapidly create a large volume of cost history lines. PeopleSoft Asset Management provides the Cost Summarization process to summarize multiple cost lines that meet certain criteria into a single line. The process uses the Cost Summarization Run component (AM_COST_SUM_RUN). You should run the process only after calculating depreciation (AM_DEPR_CALC) and creating accounting entries (AM_AMAEDIST).
Cost summarization affects cost rows in the Cost table only. No changes are made to the Acquisition Detail table. The fields that are summarized are Cost, Transaction Cost, and Quantity. Cost summarization creates an audit table (AM_COST_SUM_AUD) that contains the original cost rows before summarization.
You can summarize cost rows that have matching values for:
Business unit.
Asset ID.
Book.
Category.
Transaction type.
Chart of accounts, or ChartField.
Cost type.
Transaction code.
Accounting year and period.
Transaction year and period.
Depreciation convention.
Summarization updates the transaction date with the first day in the transaction period for all lines. It updates the accounting date with the last day in the accounting period for all lines. The summarization is then based on the new dates.
The only exception is the actual day (AD) convention.
When the transaction currency code or type differs, cost summarization uses the asset base currency as the transaction currency, and currency type is blank.
Note: You can run cost summarization in streamline mode during the create accounting entry process using the accounting entry component (AM_AMAEDIST).
Use the Cost History List page (ASSET_TRANS_01) to view the cost history of an asset.
Navigation:
This example illustrates the fields and controls on the Cost History List page. You can find definitions for the fields and controls later on this page.
Click the Detail link to access the Cost History Detail page and review cost details for an individual transaction.
Click the Comments link to access the Cost History List - Comments page and view or add relevant supporting comments to an asset transaction.
Click the Attachments link to access the Cost History List - Attachments page and view or add relevant supporting documents to an asset transaction.
Cost History List - Comments Page
Use the Cost History List - Comments page (AM_COMMENTS_SEC) and view or add relevant supporting comments to an asset transaction.
Field or Control |
Description |
|---|---|
Comment |
Enter comments for an asset. |
User ID, Name and Date/Time Stamp |
Displays the user ID, name, and date/time stamp related to the user who added the comment. You can edit the date/time stamp after saving the comment. |
Source |
Displays the transaction source for the asset, such as adjustment, transfer, and so forth. |
Cost History List - Attachments Page
Use the Cost History List - Attachments page (AM_ADD_ATTACH_SEC) to view or add relevant supporting documents to an asset transaction.
Field or Control |
Description |
|---|---|
Add Attachment |
Click this button to attach files as supporting documentation for an asset. Supply a description of the file or files that you attach. |
File Name |
Displays the attached file. Click the file-link to access the file. |
Description |
Displays a description of the file attachment when one was provided by the user. |
User, Name, and Date/Time Stamp |
Displays the user ID, name, and date/time stamp related to the user who added the attachment. |
Use the Cost Summarization page (AM_COST_SUM_RUN) to generate cost summarizations.
Navigation:
Field or Control |
Description |
|---|---|
Business Unit |
The business unit is required. |
Book Name |
If this field is blank, the cost summarization applies to all books. |
Category |
Select a category to apply summarization only to that category. Leave blank to include all categories. |
From Asset ID and To Asset ID |
Optionally enter a range of asset IDs to apply the summarization to specific assets. The assets that are available belong to the category when category is defined and that have accounting entries already generated. If the To Asset ID field is left blank, the summarization applies only to the asset ID that is specified in the From Asset ID field. |
Accounting Date Range |
The accounting date range is required for summarization. You can apply cost summarization to multiple books with different calendars. Define the date range according to the books that are selected. |
Note: When a line does not meet the criteria to summarize with other lines, no summarization occurs.
Cost summarization creates an audit table so that you can review the summarization details after you have processed the summary.