Viewing and Adding Transactions

This topic discusses how to:

View project transactions.
Maintain transaction information.
View detail transactions for source applications.
Add transactions.

Pages Used to View and Add Transactions

Page Name	Definition Name	Navigation	Usage
Transaction List	PROJECT_EXPRESSG	select Project Costing, then select Transaction Definitions, then select Transaction List, then select Transaction List Enter search criteria and click the Search button.	View transactions that belong to a project activity. This page operates in deferred processing mode.
Transaction Detail	PROJ_EXPR_ENTRY_PG	Click the Transaction Detail icon on a row in the Project Transactions grid on the Transaction List page.	Maintain detailed information on a specified transaction.
Show All Transaction Details	PROJECT_EXPRESS_02	Click the Show All Transaction Details link on the Transaction Detail page.	View detailed information from all of the Project Costing feeder systems that are associated with a single transaction line.
<Application> Detail Transactions	(depends on the application)	select Project Costing, then select Transaction Definitions, then select Transaction List, then select Transaction List Click the Drill to Source icon on the Transaction List page.	View detailed information for transactions that originate from other applications.
Add Transactions	INTFC_PROJ_EXPR_02	select Project Costing, then select Transaction Definitions, then select Add Transactions, then select Add Transactions	Add transactions to an active project activity.

Transaction List Page

Use the Transaction List page (PROJECT_EXPRESSG) to view transactions that belong to a project activity.

This page operates in deferred processing mode.

Navigation

select Project Costing, then select Transaction Definitions, then select Transaction List, then select Transaction List

Enter search criteria and click the Search button.

Image: Transaction List page

This example illustrates the fields and controls on the Transaction List page. You can find definitions for the fields and controls later on this page.

Analysis Group

Enter the analysis group that contains the type of transactions that you want to view. You can view only the transactions that belong to analysis groups to which you have been granted security access. Therefore, not all transactions may be accessible.

The default value is based on your user preferences.

Date Type, From Date, and Through Date

Enter search criteria for the transactions that you want to view. The default value for the Date Type field is Acct Date (accounting date). The default values for the From Date and Through Date fields are based on your user preferences.

Max Rows

Enter the maximum number of rows for the system to display in the Transaction List. The default value is 200.

If the activity has more transactions than the value that you enter in this field, use the navigation arrow icons (First Item, Previous Item, Next Item, and Last Item) to scroll through all transactions.

Click to retrieve the transactions from the Project Transaction table that match the search criteria.

Project Transactions

Click the Transaction Detail icon to access the Transaction Detail page, where you can view more detailed information for a particular transaction.

Click the Drill to Source icon to navigate to the PeopleSoft application where the transaction originated. The system uses key values on the detail record to drill to the source transaction.

Click the Drill to Billing icon to access PeopleSoft Billing information. This icon appears only if PeopleSoft Billing is installed, the value in the Billing Distribution Status field is D (distributed), the Billing Business Unit field is not blank, and the transaction contains an invoice number.

Summarized Transactions

If you are summarizing transactions, and:

If the transaction contains key values of the source transaction and you click on the Drill to Source icon, then the system transfers you directly to the source transaction
If the transaction does not contain the key values of the source transaction and you click on the Drill to Source icon, then the system transfers you to the Detail Transactions page for the source application.

For more information about summarizing transactions,

See Understanding Feeder and Pricing Summarization.

Transaction Detail Page

Use the Transaction Detail page (PROJ_EXPR_ENTRY_PG) to maintain detailed information on a specified transaction.

Navigation

Click the Transaction Detail icon on a row in the Project Transactions grid on the Transaction List page.

Image: Transaction Detail page

This example illustrates the fields and controls on the Transaction Detail page. You can find definitions for the fields and controls later on this page.

Use this page to:

View transaction detail and ChartField information.
Manually associate an asset ID to a transaction.
Modify most transaction detail information, except for monetary values and dates.

Note: To maintain data integrity between feeder systems and Project Costing, make all transaction adjustments and modifications in the original source system and integrate the transactions back to Project Costing.

Detail Activity

Displays the detail activity ID that is used for charging time reports in PeopleSoft Expenses. The system uses this field only if all of these conditions exist:

PeopleSoft Program Management is installed.
The Project Charging Level option on the Project Definitions - Program Management page is set to an activity costing level of 1, 2, or 3 of the work breakdown structure.
The Charging Level for Time Report option is set to All Detail Activities on the Project Definitions - Program Management page.

The Detail Activity field (ACTIVITY_ID_DETAIL) stores the detail activity that is used in time report charging. The Activity field (ACTIVITY_ID) stores the parent activity at the appropriate charging level.

Rev Distribution Status (revenue distribution status)

Modify the revenue distribution status to make the row eligible or ineligible for revenue pricing. Available values are:

C: Created
D: Distributed
G: Generated
I: Ignore
N: Not distributed

You can not modify the field if the status is D (distributed).

GL Distribution Status (general ledger distribution status)

Modify the general ledger distribution status to make the row eligible or ineligible for submission to PeopleSoft General Ledger. Available values are:

D: Distributed
G: Generated
H: Hold
I: Ignored
J: Creating journals
M: Modified
N: None
P: To be processed

You can not modify the field if the status is D (distributed).

BI Distribution Status (billing distribution status)

Displays the PeopleSoft Billing distribution status.

Modify the billing distribution status to make the row eligible or ineligible to price for billing. You can only modify this field when the current value in the BI Distrib Status field is I, N, or U.Available values are:

D: Distributed; already billed.
I: Ignore; not to be billed.
N: New; not distributed.
P: Priced.
U: Unbillable/nonbillable.
W: Worksheet; billing calculations are in the Project Costing Billing Worksheet.

Cost Distribution Status

Modify the cost distribution status to make the row eligible or ineligible for cost pricing. Available values are:

C: Created
D: Distributed
G: Generated
I: Ignore
N: Not distributed

You can not modify the field if the status is D (distributed).

Profile ID

Enter an asset profile ID that is used by PeopleSoft Asset Management and Project Costing.

See Setting Up and Using Manual Capitalization.

Asset ID

Enter an asset ID that is used by PeopleSoft Asset Management and Project Costing.

Show All Transaction Details Page

Use the Show All Transaction Details page (PROJECT_EXPRESS_02) to view detailed information from all of the Project Costing feeder systems that are associated with a single transaction line.

Navigation

Click the Show All Transaction Details link on the Transaction Detail page.

(Application) Detail Transactions Page

Use the <Application> Detail Transactions page ((depends on the application)) to view detailed information for transactions that originate from other applications.

Navigation

select Project Costing, then select Transaction Definitions, then select Transaction List, then select Transaction List

Click the Drill to Source icon on the Transaction List page.

Use this page to view the source of a transaction.

If you are using Feeder Summarization, you can view the detail of the summarized transactions. The page title and the Project Transactions grid are determined by the system source of the transaction:

System Source	Page Title	Project Transactions Grid
BEX	Expenses Detail Transactions	PC_EX_DETAIL
BGL	General Ledger Detail Transactions	PC_GL_DETAIL
BTL	Time and Labor Detail Transactions	PC_TL_DETAIL

Add Transactions Page

Use the Add Transactions page (INTFC_PROJ_EXPR_02) to add transactions to an active project activity.

Navigation

select Project Costing, then select Transaction Definitions, then select Add Transactions, then select Add Transactions

Image: Add Transactions page

This example illustrates the fields and controls on the Add Transactions page. You can find definitions for the fields and controls later on this page.

To add a transaction:

Enter an analysis type for each transaction entered.

You can enter transactions for only the analysis types that are in the specified analysis group.

Note: Budgetary ChartFields cannot be selected on this page. Therefore, budget rows cannot be added on this page.
Enter the source transaction amount and select the source currency for the transaction.

If the transaction currency is different from the base currency of the project business unit, the system automatically converts the transaction amount to the business unit's base currency based on the incoming transaction rate type that is established for the business unit. For example, if the business unit's incoming transaction rate type is Source, the system converts the transaction amount to the business unit's base currency by using the default conversion rate type that is established for your user ID (the user ID of the person who is logged in to the system). However, if the business unit's incoming transaction rate type is Projects BU, the system converts the transaction amount to the business unit's base currency by using the default rate type that is specified for the business unit. The converted amount is displayed in the PCBU Transaction Amount field on the Transaction Detail page.

You set up rate type default values on the User Preferences - Project Costing page.

Note: If you enter an account in the General Ledger ChartFields grid on the Transaction Detail page that requires a statistics code, you must enter the statistics code for the transaction.
Click Save to save the data in the Project Transaction Interface staging table (INTFC_PROJ_RES).
Click Process Transactions to load the rows into the Project Transaction table (PROJ_RESOURCE) and trigger these actions:
- Commitment Control budget-checks transactions before sending them to the Project Transaction table if the Commitment Control feature is enabled for Project Costing.
- The Pricing Application Engine process (PC_PRICING) creates target transaction rows if the source transaction is eligible for pricing.

Note: If Commitment Control is enabled for Project Costing, or if Projects Budgeting is enabled, you cannot add transactions on this page with analysis types that belong to the Cost Budget and Revenue Budget analysis groups that are specified on the Project Costing Definition page for the project. Use the appropriate budgeting application to enter these types of transactions.

To create a revenue transaction row that will be budget checked in Commitment Control, enter a negative value (credit). Failure to do so results in an increased revenue budget.