In this release, new fields have been added to the Vista Financials dataset and the Spectrum Project Management dataset. Additionally, the Spectrum Job Cost Details report has been updated to the new look, and is now tied to the Spectrum Project Management dataset.
New Fields in Vista: Financials Dataset
-
Unapproved Invoices: Approval Seq, Approved YN, Date Assigned, Line, Line Description, Optional Reviewer, Rejected YN, Seq, Unapproved AP Reference, Unapproved Invoice Description.
-
Accounts Payable Unapproved Invoice: Days Since Assigned, Invoice Total, Line Amount.
-
HQ Reviewer Groups: Responsible Person, Reviewer Group, Reviewer Group - Description, Reviewer Group Description.
-
HQ Reviewer Users: Reviewer, Reviewer - VP User Name, VP User Name.
See Vista: Financials.
New Fields in Spectrum: Project Management Dataset
-
Commitments: Percent Complete, Total Ordered, Total Received, Total Open.
-
Job: Company - Job, Company - Job - Phase.
-
Vendor: Company - Vendor.
-
Job Materials: Deliver By, Item Category, Materials Quantity Due, Materials Quantity Due To Date, Unit Cost, Standard Cost, Materials Status, Tax, Po#/Req#, Warehouse.
-
Subcontracts: Subcontract Amount, Subcontract Amount to Date, Subcontract Quantity, Subcontract Quantity to Date.
-
Subcontract Detail: Subcontract bill item - Description.
Updated Spectrum Job Cost Details Report
The Spectrum Job Cost Details standard Power BI report has been updated to the new look, and is now tied to the Spectrum Project Management dataset. Depending on your permissions, you can edit the report in the Power BI editor and save your changes. See Job Cost Detail - Spectrum.