Data views and standard log reports for bills
- Go to Reports.
- Select Project Specific Reports from the Report Category dropdown.
-
Select Bills from the Report Sub-Category dropdown.
-
Select either Single Project Reports or Multi-Project Reports and select one or more relevant projects.
-
Select the appropriate report in the Standard Reports tab.
Alternatively, you can access the reports using one of the following options on the Project Home page:
- Select Bills in the Procurement section and select Reports on the Bills page.
- Select Procurement Overview in the Procurement section and select the reports icon (
) in the Bills row of the Procurement Stats - Cost To Date section.
Primary data views
- vw_ProjectInfo
- vw_ProjectInfoSimple
- vw_PrimeContractInfo
- vw_PrimeContractInfoSimple
- vw_BillInfo
- vw_BillItems
Optional data views
- vw_CompanyInfo
- vw_CompanyInfoSimple
- vw_ContactInfo
- vw_JobCostCodes
- vw_POInfo
- vw_POItems
- vw_ChangeOrderInfo
- vw_ChangeOrderInfoSimple
- vw_WorkOrderInfo
- vw_WorkOrderInfoSimple
Single project standard log reports for bills
| Report name | Filter parameters |
|---|---|
| Bill Items Grouped by Prime Contract, Manufacturer and Status | ProjectId, PrimeContractId, Manufacturer, BillStatus |
| Bill Items Grouped by Prime Contract, Status and Cost Code | ProjectId, PrimeContractId, BillStatus, JCCId |
| Bill Items Grouped by Prime Contract, Status and Division | ProjectId, PrimeContractId, BillStatus, JCCDivision |
| Bill Items Grouped by Prime Contract, Status and Owner Code | ProjectId, PrimeContractId, BillStatus, OwnerCostCodeId |
| Bill Items Grouped by Prime Contract, Supplier and Status | ProjectId, PrimeContractId, SupplierId, BillStatus |
| Bills Grouped by Contract, Status and Type with Payment Info | ProjectId, PrimeContractId, BillStatus, PaymentStatus |
| Bills Grouped by Prime Contract and CO | ProjectId, PrimeContractId, COId, BillStatus |
| Bills Grouped by Prime Contract and Status | ProjectId, PrimeContractId, BillStatus, BillType |
| Bills Grouped by Prime Contract and Status with Payment Info | ProjectId, PrimeContractId, BillStatus, BillType, PaymentStatus |
| Bills Grouped by Prime Contract and Supplier | ProjectId, PrimeContractId, BillStatus, BillType |
| Bills Grouped by Prime Contract, Status and Type | ProjectId, PrimeContractId, BillStatus |
Multi-project standard log reports for bills
| Report name | Filter parameters |
|---|---|
| Cross Project - Bill Items Grouped by Manufacturer and Supplier | BillFromDate, BillToDate, Manufacturer, SupplierId, BillStatus |
| Cross Project - Bill Items Grouped by Resource Type | BillFromDate, BillToDate, SupplierId, BillStatus |
| Cross Project - Bills Grouped by Export Status, Supplier and Project | BillFromDate, BillToDate, Exported, SupplierId |
| Cross Project - Bills Grouped by Project Supplier and Status with Payment Info | BillFromDate, BillToDate, BillStatus, BillType, PaymentStatus |
| Cross Project - Bills Grouped by Status and Supplier | BillFromDate, BillToDate, SupplierId, BillStatus, BillType |
| Cross Project - Bills Grouped by Status and Supplier with Payment Info | BillFromDate, BillToDate, BillStatus, BillType, PaymentStatus |
| Cross Project - Bills Grouped by Supplier and Status | BillFromDate, BillToDate, SupplierId, BillStatus, BillType |
| Cross Project - Bills Grouped by Supplier and Status with Payment Info | BillFromDate, BillToDate, BillStatus, BillType, PaymentStatus |