Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Description: The Project Transactions Inquiry details all the transactions that have been distributed to a project together with the revenue/expense distributed to the associated project

Software Version: 2023.08.31 and newer

Table of Contents
exclude(Toolbar Icons|Column Headers|Toolbar Icon)
typeflat

...

Toolbar Icons

Description
Excel

Insert excerpt
Excel - LV
Excel - LV
nopaneltrue

Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Grid Layout
Insert excerpt
Grid Layout - Global
Grid Layout - Global
nopaneltrue
Help
Insert excerpt
Help - Global
Help - Global
nopaneltrue
Inquiry Criteria

Insert excerpt
Inquiry Criteria - Global
Inquiry Criteria - Global
nopaneltrue

  • 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

Insert excerpt
Refresh - Global
Refresh - Global
nopaneltrue

...

Column Headers

Description
Doc No

Insert excerpt
Doc No
Doc No
nopaneltrue
This identifies the document number the Vendor assigned to the invoice/credit memo.

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.

Linked Database Field: ERPx_GLProject.ProjectEndDate 

ExpenseDisplays the expense amount distributed to the project on the transaction.
GL PeriodDisplays the GL period associated with the transaction’s GL Date.
GL YearDisplays the GL year associated with the transaction’s GL Date.
ModuleDisplays the name of the module the transaction originated in.
ProjectDisplays the ID of the project the transaction is distributed to. This field is a hyperlink, which opens the corresponding Project record.
Project ClassIdentifies the Class that the project has been assigned to.
Project DescriptionDisplays the description of the project.
Project GL AccountDisplays 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

Insert excerpt
Def - GL Account Description
Def - GL Account Description
nopaneltrue

RevenueDisplays 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.  

Linked Database Field: ERPx_GLProject.ProjectStartDate 

Transaction Date

Displays the Transaction Date of the source transaction.

Transaction ID

Insert excerpt
Transaction ID
Transaction ID
nopaneltrue
 This field is a hyperlink, which opens the corresponding transaction record.

Transaction Type

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

Insert excerpt
Def - Transaction Types
Def - Transaction Types
nopaneltrue

Vendor ID

Insert excerpt
Vendor ID
Vendor ID
nopaneltrue
 This is only populated for AP Invoice and Credit Memo transactions and is blank when the transaction type is GL Journal Entry.

Vendor Name

Insert excerpt
Vendor Name
Vendor Name
nopaneltrue
 This is only populated for AP Invoice and Credit Memo transactions and is blank when the transaction type is GL Journal Entry.

Related Topics

Projects List View

...