Vista Standard Power BI Report: Commitments

Find definitions of the fields and measures included in the Vista Standard Power BI Report: Commitments dashboard organized by column header.

Note: This dashboard combines outputs from Purchase Order and Subcontract queries into a single data set, dsCommitmentsInvoicesWithRetention.
JC Company - Name

Filters the report data by job cost company name. All are selected by default.

Job - Description

Filters the report data by job description. All are selected by default.

Job Status
Filters the report data to include jobs that are coded as either Open, Soft Closed, or Hard Closed. All are selected by default.
Commitment Type

Filters the report data by whether an entry is a purchase order or a subcontract. All are selected by default.

Note:

Purchase order data comes from PO Purchase Order Entry (bPOHD and bPOIT). Subcontract data comes from SL Subcontract Entry (bSLHD and bSLIT).

Vendor - Name

Filters the report data by vendor name. All are selected by default.

Phase - Description

Filters the report data by phase code description. All are selected by default.

Cost Type - Description

Filters the report data by cost type description from bJCCT. All are selected by default.

JCCo

Displays the Job Company to which a job belongs.

Job

Displays the job number and description.

Note: The commitments dashboard only reports commitments coded to a job. Purchase orders coded to Equipment or Inventory are excluded.
Job Description

Displays the job description.

Job Status

Displays whether the job is coded as Pending, Open, Soft Closed, or Hard Closed.

Vendor Group

Displays the company's Vendor Group as specified in bHQCO.

Vendor

Displays the vendor identifier to which a purchase order, subcontract, or AP invoice is coded.

Vendor Name

Displays the vendor name to which a purchase order, subcontract, or AP invoice is coded.

Original Cost

Displays the Purchase Order Original Cost in bPOIT or Subcontract Original Cost in bSLIT.

Current Cost

Calculates the Original Cost + Change Order Cost. The Purchase Order Current Cost is specificied in bPOIT and the Subcontract Current Cost is specified in bSLIT.

Received Total

Displays the total amount received.

Received Not Invoiced

Displays the total amount received not attached to an invoice.

Invoiced Amount

Displays the amounts invoiced in AP and posted to bSLIT or bPOIT.

Remaining Cost

Calculates the Invoiced Amount - Current Cost.

Retention Amount

Displays the invoice amount on retention hold.

Paid Amount

Displays the paid invoice amounts.