Projects Reconciliation Workbench

The Projects Reconciliation Workbench enables project managers to review all of the transactions in progress for a single project. You must run the Transaction in Process Summary (PC_PETIP_SUM) process (Project Costing, Utilities, Transaction in Process Summary) to load the TIP (Transactions in Progress) tables before you create or review a reconciliation ID. You create various reconciliation scenarios such as Project Closeout or End of Month Review by assigning each one a reconciliation ID and associating it with a business unit and a project ID. After setting up this information, you select specific criteria and search for transactions in progress associated with:

• PeopleSoft Project Costing

  You can specify a project activity and an analysis type, which apply to all of the subsystem transactions, or leave these fields blank and the system displays all transactions for all activities and analysis types. You can display Project Costing transactions in progress that have not been costed or priced (ALLTOPC), as well as unbilled transactions during a period of time that the project was inactive (INACTPC).

• PeopleSoft Billing

  You can search for and display PeopleSoft Billing transactions in progress (BITOPC ) for the project in a grid on the Billing page.

• PeopleSoft Commitment Control

  You can search for and display unposted project budgets, budgets not distributed to PeopleSoft Commitment Control, or budgets not distributed to PeopleSoft Project Costing (BDTOPC ) for the project in a grid on the Budgets page.

• PeopleSoft Contracts

  You can search for and display project activities that are not assigned with a contract line for a project that is sourced from PeopleSoft Grants, PeopleSoft Project Costing, or both (CANOPC) for the project in the grid on the Contracts page.

• PeopleSoft Expenses

  You can search for and display PeopleSoft Expenses transactions in progress (EXTOPC) and approved time transactions in progress (TMTOPC ) for the project in the grid on the Expenses page.

• PeopleSoft Grants F & A

  You can search for and display PeopleSoft Grants F & A (Facilities and Administration) transactions in progress (FATOPC) for the project in the grid on the Grants F & A page.

• PeopleSoft General Ledger

  You can search for and display any PeopleSoft General Ledger journal transactions in progress (GLTOPC) for the project in the grid on the General Ledger page.

• PeopleSoft Inventory

  You can search for and display any PeopleSoft Inventory transactions in progress (INTOPC) for the project in the grid on the Inventory page.

• PeopleSoft Purchasing

  You can search for purchase orders (POTOPC) and requisitions (REQTOPC) in progress, as well as unsourced purchase orders (UNSPO) and requisitions (UNSREQ) that are closed, mass liquidated, open, unavailable for sourcing, and canceled, and that are associated with the selected project. You display this information in the four grids on the Purchasing page.

• PeopleSoft Payables

  You can search for PeopleSoft Payables transactions in progress (APTOPC) and unpaid vouchers that have been distributed to Project Costing (APNOPY), associate them with a method of payment based on the contract associated with the selected project, and display this information in the grids on the Payables page.

• PeopleSoft Receivables

  You can search for and display PeopleSoft Receivables transactions in progress (ARTOPC) for the project in the grid on the Receivables page.

The subsystem tabs that appear depend upon your system's setup. Once you select the search criteria on each page and display the transactions in progress based on this criteria, you save the page. Once you save the page, you can exit the workbench and return to this data later by selecting the same reconciliation ID. If you want to display different data for this reconciliation ID, you click a Reset button, which clears the original search criteria. After you enter the new criteria and search for the transactions, you can save the page again to retain the results. You can also drill down to the source transaction for each transaction listed in each grid.