Project Committed Cost Detailed

Form ID: (PM658300)

This generic inquiry form is available if the Extended Financial Data Collection feature is enabled on the Enable/Disable Features (CS100000) form.

This form shows detailed cost information for each commitment line of a project as of the date you specify.

In This Topic [Hide/Show]

Form Toolbar
Selection Area
Table
Table Columns

Back to TopForm Toolbar

The form toolbar has only standard buttons.

Back to TopSelection Area

In this area, you select the project and the date as of which you want to view data.

Element	Description
Through Date	The latest date whose data is shown in the table and used to calculate values. By default, the system inserts the current business date.
Project	The project for which you want to view the costs for all commitments.

Back to TopTable

In the table, you can view each project-related commitment’s budgeted costs, committed costs, remaining costs, retainage, and taxes as of the selected date. Each row represents a line of subcontract, purchase order, project drop-ship order, or direct AP bill related to the project—and all amounts are shown in the project currency on the selected date.

The table toolbar has only standard buttons.

Table Columns

Column Description

Project The project of the commitment line.

Currency The currency of the project.

Owner The project manager.

Start Date The start date of the project task related to the commitment line.

Project Task The project task associated with the commitment line.

Account Group The account group of the cost budget line related to the commitment line.

Original Budgeted Amount The original budgeted amount for the commitment line.

Original Budgeted Quantity

The original budgeted quantity for the commitment line.

This column is hidden by default. You can display this column in the table by using the Column Configuration dialog box. For details, see Adjustment of the Acumatica ERP UI: To Personalize a View of a Form.

Released CO Amount The sum of all amounts of released change orders for the commitment line as of the specified Through Date.

Released CO Quantity

The sum of all quantities of released change orders for the commitment line as of the specified Through Date.

Pending CO Amount The sum of all amounts of unreleased change orders for the commitment line as of the specified Through Date. This amount doesn’t include change requests.

Pending CO Quantity

The sum of all quantities of unreleased change orders for the commitment line as of the specified Through Date. This quantity excludes change requests.

Revised Budgeted Amount The total revised budgeted amount, which the system calculates by using this formula: Original Budgeted Amount + Released CO Amount.

Revised Budget Quantity

The total revised budgeted quantity, which the system calculates by using this formula: Original Budgeted Quanity + Released CO Quantity.

Revised Budgeted and Pending CO Amount The sum of the revised budgeted amount and the unreleased change order amount.

Revised Budgeted and Pending CO Quantity

The sum of the revised budgeted quantity and the unreleased change order quantity.

Actual Amount The total amount of the project transactions with the line’s project budget key as of the specified Through Date.

Actual Quantity

The total quantity of the project transactions with the line’s project budget key as of the specified Through Date.

Related Document The reference number of the purchase order, subcontract, project drop-ship order, or direct AP bill.

Vendor The vendor from which the items or services were purchased.

Original Committed Amount The amount of the purchase order, project drop-ship order, or subcontract line, excluding change orders.

Original Committed Quantity

The quantity of the purchase order, project drop-ship order, or subcontract line, excluding change orders.

Released Commitment CO Amount The sum of the line amounts of the released change orders related to the commitment line (purchase order, drop-ship purchase order, or subcontract line) as of the specified Through Date.

Released Commitment CO Quantity

The sum of the line quantities of the released change orders related to the commitment line (purchase order, drop-ship purchase order, or subcontract line) as of the specified Through Date.

Pending Commitment CO Amount The sum of the amounts of unreleased change orders related to the commitment line as of the specified Through Date. This amount excludes change request amounts.

Pending Commitment CO Quantity

The sum of the line quantities of unreleased change orders related to the commitment line as of the specified Through Date. This amount excludes change request amounts.

Revised Committed Amount The total revised amount of the subcontract, purchase order, or drop-ship purchase order, which the system calculates by using this formula: Original Committed Amount + Pending Commitment CO Amount.

Revised Committed Quantity

The total revised quantity of the subcontract, purchase order, or drop-ship purchase order, which the system calculates by using this formula: Original Committed Quantity + Pending Commitment CO Quantity.

Billed Amount The sum of the billed amounts of the AP documents related to the commitment line with a payment date earlier than or the same as the specified Through Date.

Billed Quantity

The sum of the billed quantities of the AP documents related to the commitment line with a payment date earlier than or the same as the specified Through Date.

Billed Exclusive Tax Amount The sum of all exclusive taxes from the released bills for the commitment.

Billed Inclusive Tax Amount The sum of all inclusive taxes from the released bills for the commitment.

Billed Use Tax Amount The sum of all use taxes from the released bills for the commitment.

Total Billed Amount with Taxes The total billed amount with taxes, which the system calculates by using this formula: Billed Amount + Billed Exclusive Tax Amount + Billed Use Tax Amount.

Paid Amount The sum of the amounts paid according to the AP documents related to the commitment line with a payment date earlier than or the same as the specified Through Date.

Cash Discount The sum of cash discounts in all AP document lines with the project budget key specified in the line as of the specified Through Date.

Realized Gain/Loss The sum of the realized gain or loss amounts in all AP document lines with the project budget key specified in the line as of the specified Through Date.

Withheld Tax Amount The sum of the withheld tax amounts in all AP document lines with the project budget key specified in the line as of the specified Through Date.

Amount to Bill The amount to bill the customer, which the system calculates by using this formula: Revised Committed Amount - Billed Amount.

Amount to Pay The amount to be paid to the vendor, which the system calculates by using this formula: Billed Amount - Paid Amount - Withheld Tax Amount - Cash Discount + Billed Exclusive Tax Amount - Realized Gain/Loss.

Project Committed Cost Detailed

Form ID:  ([~/?ScreenId=PM658300|PM658300])[anchor|#note_fwv_xrw_sqb]((({S:Warn}This generic inquiry form is available if the ''Extended Financial Data Collection'' feature is enabled on the [HelpRoot_FormReference\CS_10_00_00|Enable/Disable Features] ([~/?ScreenId=CS100000|CS100000]) form.
)))
This form shows detailed cost information for each commitment line of a project as of the date you specify.{br}{TOC}
==Form Toolbar==[anchor|#_755fb071-adfc-49a2-9490-894cae1a6969]
The form toolbar has only standard buttons.
==Selection Area==
In this area, you select the project and the date as of which you want to view data.[anchor|#_e5187bde-5e5b-443d-abe3-b96e2ba1c586]
{| class="checklist" | width="100%" 
|- 
!width="20%" ! Element
!width="80%" ! Description
|- 
| '''Through Date'''
| The latest date whose data is shown in the table and used to calculate values. By default, the system inserts the current business date.
|- 
| '''Project'''
|  The project for which you want to view the costs for all commitments.
|}
==Table==
In the table, you can view each project-related commitment&rsquo;s budgeted costs, committed costs, remaining costs, retainage, and taxes as of the selected date. Each row represents a line of subcontract, purchase order, project drop-ship order, or direct AP bill related to the project—and all amounts are shown in the project currency on the selected date.[anchor|#_088519af-53e5-4c17-ae7b-de688dbb7793]{br}

The table toolbar has only standard buttons.[anchor|#_825e406f-18eb-4af4-b25a-20177dca6bc9]
===Table Columns===
{| class="checklist" | width="100%" 
|- 
!width="20%" ! Column
!width="80%" ! Description
|- 
| '''Project'''
| The project of the commitment line.
|- 
| '''Currency'''
| The currency of the project.
|- 
| '''Owner'''
| The project manager.
|- 
| '''Start Date'''
| The start date of the project task related to the commitment line.
|- 
| '''Project Task'''
| The project task associated with the commitment line.
|- 
| '''Account Group'''
| The account group of the cost budget line related to the commitment line.
|- 
| '''Original Budgeted Amount'''
| The original budgeted amount for the commitment line.
|- 
| '''Original Budgeted Quantity'''
| The original budgeted quantity for the commitment line.[anchor|#_0c47a82d-1b49-4fa8-a6f3-6bd2aca18f8c]((({S:Warn}This column is hidden by default. You can display this column in the table by using the '''Column Configuration''' dialog box. For details, see [HelpRoot_GettingStarted\GS_ModernUI_User_Interface_Personalization_Activity|Adjustment of the Acumatica ERP UI: To Personalize a View of a Form].
)))
|- 
| '''Released CO Amount'''
| The sum of all amounts of released change orders for the commitment line as of the specified '''Through Date'''.
|- 
| '''Released CO Quantity'''
| The sum of all quantities of released change orders for the commitment line as of the specified '''Through Date'''.[anchor|#_0c47a82d-1b49-4fa8-a6f3-6bd2aca18f8c]((({S:Warn}This column is hidden by default. You can display this column in the table by using the '''Column Configuration''' dialog box. For details, see [HelpRoot_GettingStarted\GS_ModernUI_User_Interface_Personalization_Activity|Adjustment of the Acumatica ERP UI: To Personalize a View of a Form].
)))
|- 
| '''Pending CO Amount'''
| The sum of all amounts of unreleased change orders for the commitment line as of the specified '''Through Date'''. This amount doesn’t include change requests.
|- 
| '''Pending CO Quantity'''
| The sum of all quantities of unreleased change orders for the commitment line as of the specified '''Through Date'''. This quantity excludes change requests.[anchor|#_0c47a82d-1b49-4fa8-a6f3-6bd2aca18f8c]((({S:Warn}This column is hidden by default. You can display this column in the table by using the '''Column Configuration''' dialog box. For details, see [HelpRoot_GettingStarted\GS_ModernUI_User_Interface_Personalization_Activity|Adjustment of the Acumatica ERP UI: To Personalize a View of a Form].
)))
|- 
| '''Revised Budgeted Amount'''
| The total revised budgeted amount, which the system calculates by using this formula: {{Original Budgeted Amount + Released CO Amount}}.
|- 
| '''Revised Budget Quantity'''
| The total revised budgeted quantity, which the system calculates by using this formula: {{Original Budgeted Quanity + Released CO Quantity}}.[anchor|#_0c47a82d-1b49-4fa8-a6f3-6bd2aca18f8c]((({S:Warn}This column is hidden by default. You can display this column in the table by using the '''Column Configuration''' dialog box. For details, see [HelpRoot_GettingStarted\GS_ModernUI_User_Interface_Personalization_Activity|Adjustment of the Acumatica ERP UI: To Personalize a View of a Form].
)))
|- 
| '''Revised Budgeted and Pending CO Amount'''
| The sum of the revised budgeted amount and the unreleased change order amount.
|- 
| '''Revised Budgeted and Pending CO Quantity'''
| The sum of the revised budgeted quantity and the unreleased change order quantity.[anchor|#_0c47a82d-1b49-4fa8-a6f3-6bd2aca18f8c]((({S:Warn}This column is hidden by default. You can display this column in the table by using the '''Column Configuration''' dialog box. For details, see [HelpRoot_GettingStarted\GS_ModernUI_User_Interface_Personalization_Activity|Adjustment of the Acumatica ERP UI: To Personalize a View of a Form].
)))
|- 
| '''Actual Amount'''
| The total amount of the project transactions with the line’s project budget key as of the specified '''Through Date'''.
|- 
| '''Actual Quantity'''
| The total quantity of the project transactions with the line’s project budget key as of the specified '''Through Date'''.[anchor|#_0c47a82d-1b49-4fa8-a6f3-6bd2aca18f8c]((({S:Warn}This column is hidden by default. You can display this column in the table by using the '''Column Configuration''' dialog box. For details, see [HelpRoot_GettingStarted\GS_ModernUI_User_Interface_Personalization_Activity|Adjustment of the Acumatica ERP UI: To Personalize a View of a Form].
)))
|- 
| '''Related Document'''
| The reference number of the purchase order, subcontract, project drop-ship order, or direct AP bill.
|- 
| '''Vendor'''
| The vendor from which the items or services were purchased.
|- 
| '''Original Committed Amount'''
| The amount of the purchase order, project drop-ship order, or subcontract line, excluding change orders.
|- 
| '''Original Committed Quantity'''
| The quantity of the purchase order, project drop-ship order, or subcontract line, excluding change orders.[anchor|#_0c47a82d-1b49-4fa8-a6f3-6bd2aca18f8c]((({S:Warn}This column is hidden by default. You can display this column in the table by using the '''Column Configuration''' dialog box. For details, see [HelpRoot_GettingStarted\GS_ModernUI_User_Interface_Personalization_Activity|Adjustment of the Acumatica ERP UI: To Personalize a View of a Form].
)))
|- 
| '''Released Commitment CO Amount'''
| The sum of the line amounts of the released change orders related to the commitment line (purchase order, drop-ship purchase order, or subcontract line) as of the specified '''Through Date'''.
|- 
| '''Released Commitment CO Quantity'''
| The sum of the line quantities of the released change orders related to the commitment line (purchase order, drop-ship purchase order, or subcontract line) as of the specified '''Through Date'''.[anchor|#_0c47a82d-1b49-4fa8-a6f3-6bd2aca18f8c]((({S:Warn}This column is hidden by default. You can display this column in the table by using the '''Column Configuration''' dialog box. For details, see [HelpRoot_GettingStarted\GS_ModernUI_User_Interface_Personalization_Activity|Adjustment of the Acumatica ERP UI: To Personalize a View of a Form].
)))
|- 
| '''Pending Commitment CO Amount'''
| The sum of the amounts of unreleased change orders related to the commitment line as of the specified '''Through Date'''. This amount excludes change request amounts.
|- 
| '''Pending Commitment CO Quantity'''
| The sum of the line quantities of unreleased change orders related to the commitment line as of the specified '''Through Date'''. This amount excludes change request amounts.[anchor|#_0c47a82d-1b49-4fa8-a6f3-6bd2aca18f8c]((({S:Warn}This column is hidden by default. You can display this column in the table by using the '''Column Configuration''' dialog box. For details, see [HelpRoot_GettingStarted\GS_ModernUI_User_Interface_Personalization_Activity|Adjustment of the Acumatica ERP UI: To Personalize a View of a Form].
)))
|- 
| '''Revised Committed Amount'''
| The total revised amount of the subcontract, purchase order, or drop-ship purchase order, which the system calculates by using this formula: {{Original Committed Amount + Pending Commitment CO Amount}}.
|- 
| '''Revised Committed Quantity'''
| The total revised quantity of the subcontract, purchase order, or drop-ship purchase order, which the system calculates by using this formula: {{Original Committed Quantity + Pending Commitment CO Quantity}}.[anchor|#_0c47a82d-1b49-4fa8-a6f3-6bd2aca18f8c]((({S:Warn}This column is hidden by default. You can display this column in the table by using the '''Column Configuration''' dialog box. For details, see [HelpRoot_GettingStarted\GS_ModernUI_User_Interface_Personalization_Activity|Adjustment of the Acumatica ERP UI: To Personalize a View of a Form].
)))
|- 
| '''Billed Amount'''
| The sum of the billed amounts of the AP documents related to the commitment line with a payment date earlier than or the same as the specified '''Through Date'''.
|- 
| '''Billed Quantity'''
| The sum of the billed quantities of the AP documents related to the commitment line with a payment date earlier than or the same as the specified '''Through Date'''.[anchor|#_0c47a82d-1b49-4fa8-a6f3-6bd2aca18f8c]((({S:Warn}This column is hidden by default. You can display this column in the table by using the '''Column Configuration''' dialog box. For details, see [HelpRoot_GettingStarted\GS_ModernUI_User_Interface_Personalization_Activity|Adjustment of the Acumatica ERP UI: To Personalize a View of a Form].
)))
|- 
| '''Billed Exclusive Tax Amount'''
| The sum of all exclusive taxes from the released bills for the commitment.
|- 
| '''Billed Inclusive Tax Amount'''
| The sum of all inclusive taxes from the released bills for the commitment.
|- 
| '''Billed Use Tax Amount'''
| The sum of all use taxes from the released bills for the commitment.
|- 
| '''Total Billed Amount with Taxes'''
| The total billed amount with taxes, which the system calculates by using this formula: {{Billed Amount + Billed Exclusive Tax Amount + Billed Use Tax Amount}}.
|- 
| '''Paid Amount'''
| The sum of the amounts paid according to the AP documents related to the commitment line with a payment date earlier than or the same as the specified '''Through Date'''.
|- 
| '''Cash Discount'''
| The sum of cash discounts in all AP document lines with the project budget key specified in the line as of the specified '''Through Date'''.
|- 
| '''Realized Gain/Loss'''
| The sum of the realized gain or loss amounts in all AP document lines with the project budget key specified in the line as of the specified '''Through Date'''.
|- 
| '''Withheld Tax Amount'''
| The sum of the withheld tax amounts in all AP document lines with the project budget key specified in the line as of the specified '''Through Date'''.
|- 
| '''Amount to Bill'''
| The amount to bill the customer, which the system calculates by using this formula: {{Revised Committed Amount - Billed Amount}}.
|- 
| '''Amount to Pay'''
| The amount to be paid to the vendor, which the system calculates by using this formula: {{Billed Amount - Paid Amount - Withheld Tax Amount - Cash Discount + Billed Exclusive Tax Amount - Realized Gain/Loss}}.
|}