Reports - Project Accounting - Project Commitments Details

Overview

Project commitments represent the unused value of an open or closed Purchase Order (PO) and its approved Mods associated to a project. If there is an approved PO that has no detail lines, and there are no vendor invoices, timesheets, or expense reports that reference that PO, then the commitment value is the full amount of the PO summary. All actual costs that reference the PO, i.e. detail line items/cells from vendor invoices (not including PO Funding Cap Adj.), timesheets, or expense reports, reduce the value of the commitment.

Note that individual PO lines can be closed independent of whether the PO itself has been closed. In this case, the line close date is used to determine whether the line should be included in commitments. Once the PO document is closed, commitments should use the earlier of the PO close date and the PO line close date to determine whether the line should be considered a commitment.  

Roles

This report is available to users having any of the following roles:  Administrator, P&R Administrator, Purchaser, Purchase Order Viewer, and Project Administrators (Resource Requestor, Project Viewer, Project Manager, Project Lead, Project Approvers).

Note: Purchase Order Viewers have access to POs for the legal entity to which the user has access via Financial Org Access, and POs for the vendor to which the user has access via Vendor Org Access. See People Organization Access for more information.

Note: Purchasers have access to POs for the legal entity to which the user has access via Financial Org Access.

License

This report is available with the Project Financials family of Unanet licenses.

 

Topics covered on this help page include:

 

 


Selection Criteria

Field Descriptions (click on a link below for additional information)

 



Example Report Output

 

Click here to see the Commitments Calculations Matrix for more details about how cost and bill are calculated.

This report is organized by Project Organization/Project and includes only  those PO and PO lines that are related to projects.

For each PO that has no lines, this report shows a single report row based on the PO Summary information. This line will be considered an EXPENSE/ODC line. It will display a single report row containing the total approved cost associated with the PO. Cost is determined as the sum of all original and Mod PO amounts that:

 

Also for each PO that has no lines, this report shows 0 to many rows of actuals reported against the PO/PO line (actuals could be cap adjustments, labor, items, or expenses coming from VI, timesheets, or expense reports).

 

For an expense PO Summary  - actuals stamped with the PO include: 


For expense PO Line - actuals stamped with the PO/PO Line include: 

 

For labor PO Line - actuals stamped with the PO/PO Line include: 

 

For each PO that has at least one line, this report shows rows for each included detail line, but nothing for the PO Summary. It also shows a single report row containing a total approved cost (and quantity where applicable) associated with the PO line. Cost and quantity are determined as a sum of all lines related to the line from the original PO and all Mods that:

 

Field Description Notes

 

Applied Qty and Cost:

 

Cap Adj: amount from Vendor Invoice funding cap adjustment

Remaining: PO amount - Applied - Cap adj

Committed: Same as Remaining unless PO or PO line is closed or allows overages and the Remaining amount is negative, in which case the Committed amount is zero

 

The data sources included in the report consist of all PO/PO Line rows that meet the various criteria specified plus any actuals that have been associated with the PO/PO Lines in Vendor Invoices (VI), Timesheets, or Expense Reports as follows:

Labor Line actuals from:

 

Expense Line actuals from:

 

Item Line actuals from:

 

The following columns are populated based on the attributes from the PO/PO Line(s):


The following columns are populated based on the attributes from the PO/PO Line(s) for the PO report rows and from the actuals:


The following columns are populated for PO report rows only:


The following columns are populated for Actuals report rows only: