Use the Project Transaction Pending and Billed Console to review detailed information about project transactions such as the project billable amounts, cost amounts, billed amounts and average hour rates. Transactions may originate from multiple locations including timesheets, expense reports, journal transactions, project invoices, payments, adjustments, billing schedules, accounts receivable invoices, and recurring journal entries.
This console includes Project user fields created in Entity User Fields under Administration | Setup. You can hide and unhide columns to customize what you see in your view. You can group, sort, filter, and zoom in on what you are analyzing. You can export the displayed information to a spreadsheet for further analysis and planning.
Account Code - The general ledger account the transaction is charged to.
Account Description - The description of the general ledger account the transaction is charged to.
Account Dim1 - Dim8 - The general ledger account dimensions 1 - 8 the transaction is charged to.
Base Currency Billable Amount - Total billable amount in the internal company’s base currency. (Units * Billing Rate) or (Hours * Billing Rate)
Base Currency Billable Margin - Billable margin in the internal company’s base currency. ((Billed Rev - Cost Amt)/Billed Rev) * 100)
Base Currency Billable Revenue - Total amount that is billable for revenue in the internal company’s base currency. (Billable Amount - Write-off Amount)
Base Currency Billed Amount - Total amount billed in the internal company’s base currency.
Base Currency Billed Margin - Billed margin in the internal company’s base currency. ((Billed Rev - Cost Amt)/Billed Rev) * 100)
Base Currency Code - The code assigned to the currency assigned to the internal company.
Base Currency Cost Amount - Total actual cost in the internal company’s base currency.
Base Currency Cost Per Unit - Cost per unit (Cost Amount/Cost Units) in the internal company’s base currency. It may be necessary to look at individual journal types, which represent specific types of transactions, by filtering on Journal Type, to get the Base Currency Cost Per Unit you are looking for.
Base Currency Exchange Rate - The exchange rate used to convert from the project transaction’s currency to the base currency assigned to the internal company.
Base Currency Name - The name of the currency assigned to the internal company.
Base Currency Net Billable Income - Net billable income (Billable Revenue - Cost Amount) in the internal company’s base currency.
Base Currency Net Billed Income - Net billed income (Billed Amount - Cost Amount) in the internal company’s base currency.
Base Currency Unbilled Amount - Unbilled amount (Revenue - Billed Amount) in the internal company’s base currency.
Base Currency Unbilled Billing Schedule Amount - Amount, in the internal company’s base currency, that is defined in Billing Schedule that has not been billed.
Base Currency Write-Off Amount - The amount, in the internal company’s base currency, of the transaction that was written off and will not be billed to the customer.
Billable - This flag indicates whether the time or expense detail line is billable to the client.
Billable Amount - Total billable amount. (Units * Billing Rate) or (Hours * Billing Rate)
Billable Hours - Total billable hours for labor transactions. (Hours * Billing Rate) Billable Margin - (((Billable Revenue - Cost Amount)/Billable Revenue) * 100)
Billable Rate Per Hour - The hourly billable rate for time worked on the project. It is defined in the Billing Rates field on the Billing Information tab of Project under Projects. If a rate exception has been entered through the Rate Exception button on the Billing Information tab of Project, that rate exception will override the Billing Rates field selection.
Billable Revenue - Total amount that is billable for revenue. (Billable Amount - Write-off Amount)
Billable Units - Total number of units billable to the customer.
Billed Amount - Total amount billed. Billed Hours - Total number of hours billed.
Billed Margin - ((Billed Rev - Cost Amt)/Billed Rev) * 100)
Billed Units - Total number of units billed.
Closed - This flag determines if the transaction is open/closed. The transaction is considered closed when it has been invoiced or posted with no further action required.
Cost Amount - Total actual cost.
Cost Dim1 - The general ledger account dimension 1 the transaction is charged to OR the dimension 1 from the resource associated with the transaction.
Cost Hours - Total cost quantity classified as labor.
Cost Per Unit - (Cost Amount/Cost Units) It may be necessary to look at individual journal types, which represent specific types of transactions, by filtering on Journal Type, to get the Cost Per Unit you are looking for.
Cost Rate Per Hour - The hourly cost rate for a resource’s time worked on the project. It is entered in the Std. Cost Rate field in the History area of Resource under Projects.
Cost Units - Total actual quantity. Can include hours and units.
Currency Code - The code assigned to the currency assigned to the transaction.
Customer Class - The customer class assigned to the customer associated with the transaction. Customer class is defined in Customer Classes under Financials | Setup and assigned in Customer under Financials | Receivables.
Date - The date entered for the transaction.
Detail Description/Comment - Contains what was entered for comments when the transaction was entered.
Document Date - The date entered for the document associated with the transaction.
Document Description - The description for the document associated with the transaction.
Document External Reference - When Enable Project Invoice External Reference on the Main tab in Project Policies under Projects | Setup is enabled, the External Reference from the project invoice associated with the transaction.
Document Number - The reference number assigned to the document associated with the transaction. The document number is related to the Journal Type. In other words, it is possible to have a Journal Type equal to Timesheet with Document Number 000028 and a Project Invoice with the same document number.
Document Period - The fiscal period the transaction is posted to. Follows the format MM-YYYY. (i.e., 10-2022)
Document Session Reference - The Session Reference from the document (project invoice, expense report, etc.) associated with the transaction.
Document Status - The Status from the document (project invoice, expense report, etc.) associated with the transaction.
Exp Cat Desc - Description of the expense category for the transaction. Expense categories are defined in Expense Categories under Projects | Setup.
Expense Category - The type of expense the transaction represents. Expense categories are defined in Expense Categories under Projects | Setup. For example, Travel, Meals, Hotel, Airfare, etc.
Expense Vendor - The vendor associated with the transaction if it is an expense transaction when entered in Expense Report under Projects or Vendor Invoice and Adjustment under Financials | Payables.
Fiscal Year - The fiscal year portion of the fiscal period the transaction is posted to.
Invoice Account Code - The invoice account assigned to the transaction.
Invoice Account Description - The description associated with the invoice account assigned to the transaction.
Invoice Account Dim1 - Dim8 - The invoice account dimensions 1 - 8 assigned to the transaction.
Invoice Project Account - The invoice project account assigned to the transaction to track project revenue.
Item Description - The description assigned to the inventory item associated with the transaction.
Item ID - The ID assigned to the inventory item associated with the transaction.
Journal Type - The type of transaction. Possible types include: Timesheet, ExpRpt (expense report), Journal, ProjInv (project invoice), Payment (Accounts Payable payment), Adjustment (Accounts Payable adjustment), BillSched (billing schedule), Invoice, RecurringJnl (General Ledger recurring journal)
Labor Category - The labor category associated with the transaction.
Maximum Invoice Period - not currently used.
Net Billable Income - (Billable Revenue - Cost Amount)
Net Billed Income - (Billed Amount - Cost Amount)
Non-Labor Billable Amt - The total billable amount that represents non-labor portions of the transaction. For example, the cost of a subcontractor billed on a vendor invoice will display here. It can be a subset of the marked up billable amount.
Pay Category - The pay category associated with the transaction.
Period- The fiscal period the transaction is posted to.
Project Account - The project account associated with the transaction to track project costs.
Project Contract Description - The description of the contract associated with the project assigned to the transaction.
Project Contract ID - The ID assigned to the contract associated with the project assigned to the transaction.
Project Contract Type - Type of contract assigned to the project associated with the transaction. For example, Fixed Price or Time and Expenses.
Project Customer - The customer assigned to the project associated with the transaction. Customers are assigned to projects on the Billing Information tab of Project.
Project Description - The Description of the project entered on the Main tab of Project.
Project Dim1 - Dim8 - Dimensions 1 - 8 from the project associated with the transaction. Dimensions 1 - 8 are entered for a project on the Main tab of Project.
Project End Date - The End Date entered on the Main tab of Project for the Project associated with the transaction. This is the date the project is planned to end.
Project ID - The ID of the project entered on the Main tab of Project.
Project Manager - The Project Manager entered on the Main tab of Project for the Project associated with the transaction. This is the individual responsible for the project from conception to completion.
Project Start Date - The Start Date entered on the Main tab of Project for the Project associated with the transaction. This is the date the project is planned to start.
Project Status - The Status entered on the Main tab of Project for the Project associated with the transaction.
Project Type - The Type entered on the Main tab of Project for the Project associated with the transaction. The list of possible project types is defined in Project Types under Projects | Setup.
Resource - Employee or subcontractor associated the transaction. This value comes from the name properties in People under Administration.
Resource Dim1 - Dim8 - Dimensions 1 - 8 from the resource associated with the transaction. Dimensions 1 - 8 are associated with a resource in the History area in Resource under Projects.
Resource Email - The email address of the resource associated with the transaction.
Resource First Name - The first name of the resource associated with the transaction. The first name is entered in People.
Resource Last Name - The last name of the resource associated with the transaction. The last name is entered in People.
Resource or Vendor ID - The unique identifier entered for the resource associated with the transaction. The ID is entered in either People or Company under Administration.
Resource or Vendor Name - The name entered for the resource associated with the transaction. The name is entered in either People or Company.
Task 1 - First task component.
Task 2 - Second task component.
Task 3 - Third task component.
Task 4 - Fourth task component.
Task Description - The description of the task associated with the transaction. Task descriptions are entered on the Task tab of Project.
Task ID - The unique ID for the task associated with the transaction. Task IDs are selected on the Task tab of Project. Tasks are defined in Task Definitions under Projects | Setup.
Timesheet Status - The current status of the timesheet. Options include Pending, Submitted, Ready for Review and Approved.
Unbilled Amount - (Revenue - Billed Amount)
Unbilled Billing Schedule Amount - Amount that is defined in Billing Schedule that have not been billed.
Unbilled Billing Schedule Hours - Hours defined in Billing Schedule that have not been billed.
Unbilled Billing Schedule Units - Units defined in Billing Schedule that have not been billed.
Unbilled Hours - Hours that have not been billed.
Unbilled Units - Units that have not been billed.
Write-Off Amount - The amount of the transaction written off and not billed to the customer.
Write-Off Hours - The number of hours of the transaction written off and not billed to the customer.
Write-Off Units - The number of units of the transaction written off and not billed to the customer.
Year Period - The fiscal year-period the transaction is posted to. Follows the format YYYY-MM. (i.e., 2022-10)
For many search result columns that display numeric information (that is, a column that shows something like the actual hours), the System automatically calculates the totals of all values in these columns and displays these at the bottom of the console (for example, the total of actual hours for the rows listed).
If you group search results, the System automatically calculates and displays group subtotals from these totals. Each group’s subtotals appear, regardless of whether the group’s list of details is open or closed. If the list is open the group subtotal appears at the bottom of the list. The grand total for all groups continues to appear at the bottom of the console.
The following consoles include column totals:
Project Transaction Console
Project Transaction Pending and Billed Console
Project Console
Project Summary Console
Project Budget Console
Project Task Summary Console
Project Task Detail Console
Project Invoice Console
Expenses Console
Resource Scheduling Console
Q: Can I create new data in a console?Q: Can I create new data in a console?
A: No. The consoles are read-only.
A: Yes. Click any value in a console that is highlighted and underlined to drill into the screen where that value was created. After the original data entry screen appears, the data is displayed. In some cases, you can edit pieces of the data. When you save the original data entry screen, and then you return to the console, remember to click Execute 
to update the console data to reflect the recent changes.