Excel

Favorites

Grid Layout

Help

Inquiry Criteria

• Date From: To filter project transactions beginning on or after this date. Defaults to blank. 

• Date To: To filter project transaction up thru this date. Defaults to blank. 

• GL Period: To filter project transactions that occurred on one or more selected GL Periods. Defaults to All.

• GL Year: To filter project transactions that occurred on one or more selected GL Years. Defaults to All.

• Project: To filter project transactions by one or more Project IDs. Defaults to All. 

• Project Class: To filter project transactions by one or more Project Classes. Defaults to All.

• Show Transactions: To filter project transactions by the transaction type (Revenue or Expense). Defaults to All.

Refresh

Doc No

Database Field: ERPx_APTransactionHeader.DocNumber

End

Displays the end date assigned to the project.

The date the Project ends. If this date is empty then the Project will be open indefinitely. This value is always editable and if entered it must occur on or after the 'Start' date.

Database Field: ERPx_GLProject.ProjectEndDate 

Expense

Displays the expense amount distributed to the project on the transaction.

GL Period

Displays the GL period associated with the transaction’s GL Date.

GL Year

Displays the GL year associated with the transaction’s GL Date.

Module

Displays the name of the module the transaction originated in.

Project

Displays the ID of the project the transaction is distributed to. This field is a hyperlink, which opens the corresponding Project record.

Project Class

Identifies the Class that the project has been assigned to.

Project Description

Displays the description of the project.

Project GL Account

Displays the GL Account number of the GL Account associated with the transaction. This is the line item’s Purchase Account for AP Invoices and Credit Memos and the account number for manual journal entries.

Project GL Account Description

Revenue

Displays the revenue amount distributed to the project on the corresponding transaction.

Start

The date the Project begins. Projects cannot be assigned to transactions that occur before this date.  

Database Field: ERPx_GLProject.ProjectStartDate 

Transaction Date

Displays the Transaction Date of the source transaction.

Transaction ID

Transaction Type

Displays the type of the transaction (e.g. Purchasing Invoice or GL Journal Entry).

Vendor ID

Vendor Name