Project Summary
From Adjutant Wiki
{TOC}
Contents
- 1 Default Menu Location
- 2 General Description
- 3 Report Filters
- 4 Report Selection
- 5 Active Project Summary - ACTPROJ
- 5.1 Standard Report Fields (Header - ACTPROJ)
- 5.2 Standard Report Fields (Group Header company - ACTPROJ)
- 5.3 Standard Report Fields (Group Header keyno - ACTPROJ)
- 5.4 Standard Report Fields (Detail - ACTPROJ)
- 5.5 Standard Report Fields (Group Footer keyno - ACTPROJ)
- 5.6 Standard Report Fields (Page Footer - ACTPROJ)
- 6 Standard Report Fields (Page header - ACTPROJ2)
- 7 Additional Report Fields for Customization
Default Menu Location
Maintain >> Project Control >> Projects
Accessible from the Reports tab of the Management\Project Control - Reports.jpg|Project Control screen.
General Description
The Project Summary provides an active project summary or an active work order summary report.
Report Filters
Project#: The project number is automatically passed when the screen runs from the Project Screen or enter or select project number
Project Name: The project name is automatically passed when the screen runs from the Project Screen or enter or select
SrvOrd Primarily blank
Start Date: Start date
End Date: End date
Report Selection
Project: Run report by project
Serivce Order: Run report by service order
Active Project Summary - ACTPROJ
Standard Report Fields (Header - ACTPROJ)
Company
- gc_company
Standard Report Fields (Group Header company - ACTPROJ)
Customer
- company
Standard Report Fields (Group Header keyno - ACTPROJ)
Owner
- fullname
Project ID
- keyno
Project Name
- name
Notes
- shortnote
Standard Report Fields (Detail - ACTPROJ)
Project
- name
Phase Dates
- pstartdate
- penddate
Phase
- phase
Customer
- company
Phase Notes
- descrip
Estimate - Total Cost
- tcest
Estimate - Total Revenue
- trest
Estimate - Labor Cost
- lcest
Estimate - Labor Revenue
- lrest
Estimate - Equipment Cost
- ecest
Estimate - Equipment Revenue
- erest
Estimate - Overhead Cost
- ocest
Estimate - Overhead Revenue
- orest
Budget - Total Cost
- tcbud
Budget - Total Revenue
- trbud
Budget - Labor Cost
- lcbud
Budget - Labor Revenue
- lrbud
Budget - Equipment Cost
- ecbud
Budget - Equipment Revenue
- erbud
Budget - Overhead Cost
- ocbud
Budget - Overhead Revenue
- orbud
Realized - Total Cost
- tcrea
Realized - Total Revenue
- trrea
Realized - Labor Cost
- lcrea
Realized - Labor Revenue
- lrrea
Realized - Equipment Cost
- ecrea
Realized - Equipment Revenue
- errea
Realized - Overhead Cost
- ocrea
Realized - Overhead Revenue
- orrea
Pending - Total Cost
- tcpen
Pending - Total Revenue
- trpen
Pending - Labor Cost
- lcpen
Pending - Labor Revenue
- lrpen
Pending - Equipment Cost
- ecpen
Pending - Equipment Revenue
- erpen
Pending - Overhead Cost
- ocpen
Pending - Overhead Revenue
- orpen
Committed - Total Cost
- tccom
Committed - Total Revenue
- trcom
Committed - Labor Cost
- lccom
Committed - Labor Revenue
- lrcom
Committed - Equipment Cost
- eccom
Committed - Equipment Revenue
- ercom
Committed - Overhead Cost
- occom
Committed - Overhead Revenue
- orcom
Total - Total Cost
- tctot
Total - Total Revenue
- trtot
Total - Labor Cost
- lctot
Total - Labor Revenue
- lrtot
Total - Equipment Cost
- ectot
Total - Equipment Revenue
- ertot
Total - Overhead Cost
- octot
Total - Overhead Revenue
- ortot
Over/Under - Total Cost
- tcover
Over/Under - Total Revenue
- trover
Over/Under - Labor Cost
- lcover
Over/Under - Labor Revenue
- lrover
Over/Under - Equipment Cost
- ecover
Over/Under - Equipment Revenue
- erover
Over/Under - Overhead Cost
- ocover
Over/Under - Overhead Revenue
- orover
Estimate - Material Cost
- mcest
Estimate - Material Revenue
- mrest
Estimate - Subcontracts Cost
- scest
Estimate - Subcontracts Revenue
- srest
Estimate - Expenses Cost
- xcest
Estimate - Expenses Revenue
- xrest
Budget - Material Cost
- mcbud
Budget - Material Revenue
- mrbud
Budget - Subcontracts Cost
- scbud
Budget - Subcontracts Revenue
- srbud
Budget - Expenses Cost
- xcbud
Budget - Expenses Revenue
- xrbud
Realized - Material Cost
- mcrea
Realized - Material Revenue
- mrrea
Realized - Subcontracts Cost
- screa
Realized - Subcontracts Revenue
- srrea
Realized - Expenses Cost
- xcrea
Realized - Expenses Revenue
- xrrea
Pending - Material Cost
- mcpen
Pending - Material Revenue
- mrpen
Pending - Subcontracts Cost
- scpen
Pending - Subcontracts Revenue
- srpen
Pending - Expenses Cost
- xcpen
Pending - Expenses Revenue
- xrpen
Committed - Material Cost
- mccom
Committed - Material Revenue
- mrcom
Committed - Subcontracts Cost
- sccom
Committed - Subcontracts Revenue
- srcom
Committed - Expenses Cost
- xccom
Committed - Expenses Revenue
- xrcom
Total - Material Cost
- mctot
Total - Material Revenue
- mrtot
Total - Subcontracts Cost
- sctot
Total - Subcontracts Revenue
- srtot
Total - Expenses Cost
- xctot
Total - Expenses Revenue
- xrtot
Over/Under - Material Cost
- mcover
Over/Under - Material Revenue
- mrover
Over/Under - Subcontracts Cost
- scover
Over/Under - Subcontracts Revenue
- srover
Over/Under - Expenses Cost
- xcover
Over/Under - Expenses Revenue
- xrover
Project
- name
Phase Dates
- pstartdate
- penddate
Customer
- company
Estimate - Total Cost
- tcest
Estimate - Total Revenue
- trest
Estimate - Labor Cost
- lcest
Estimate - Labor Revenue
- lrest
Estimate - Equipment Cost
- ecest
Estimate - Equipment Revenue
- erest
Estimate - Overhead Cost
- ocest
Estimate - Overhead Revenue
- orest
Budget - Total Cost
- tcbud
Budget - Total Revenue
- trbud
Budget - Labor Cost
- lcbud
Budget - Labor Revenue
- lrbud
Budget - Equipment Cost
- ecbud
Budget - Equipment Revenue
- erbud
Budget - Overhead Cost
- ocbud
Budget - Overhead Revenue
- orbud
Realized - Total Cost
- tcrea
Realized - Total Revenue
- trrea
Realized - Labor Cost
- lcrea
Realized - Labor Revenue
- lrrea
Realized - Equipment Cost
- ecrea
Realized - Equipment Revenue
- errea
Realized - Overhead Cost
- ocrea
Realized - Overhead Revenue
- orrea
Pending - Total Cost
- tcpen
Pending - Total Revenue
- trpen
Pending - Labor Cost
- lcpen
Pending - Labor Revenue
- lrpen
Pending - Equipment Cost
- ecpen
Pending - Equipment Revenue
- erpen
Pending - Overhead Cost
- ocpen
Pending - Overhead Revenue
- orpen
Committed - Total Cost
- tccom
Committed - Total Revenue
- trcom
Committed - Labor Cost
- lccom
Committed - Labor Revenue
- lrcom
Committed - Equipment Cost
- eccom
Committed - Equipment Revenue
- ercom
Committed - Overhead Cost
- occom
Committed - Overhead Revenue
- orcom
Total - Total Cost
- tctot
Total - Total Revenue
- trtot
Total - Labor Cost
- lctot
Total - Labor Revenue
- lrtot
Total - Equipment Cost
- ectot
Total - Equipment Revenue
- ertot
Total - Overhead Cost
- octot
Total - Overhead Revenue
- ortot
Over/Under - Total Cost
- tcover
Over/Under - Total Revenue
- trover
Over/Under - Labor Cost
- lcover
Over/Under - Labor Revenue
- lrover
Over/Under - Equipment Cost
- ecover
Over/Under - Equipment Revenue
- erover
Over/Under - Overhead Cost
- ocover
Over/Under - Overhead Revenue
- orover
Estimate - Material Cost
- mcest
Estimate - Material Revenue
- mrest
Estimate - Subcontracts Cost
- scest
Estimate - Subcontracts Revenue
- srest
Estimate - Expenses Cost
- xcest
Estimate - Expenses Revenue
- xrest
Budget - Material Cost
- mcbud
Budget - Material Revenue
- mrbud
Budget - Subcontracts Cost
- scbud
Budget - Subcontracts Revenue
- srbud
Budget - Expenses Cost
- xcbud
Budget - Expenses Revenue
- xrbud
Realized - Material Cost
- mcrea
Realized - Material Revenue
- mrrea
Realized - Subcontracts Cost
- screa
Realized - Subcontracts Revenue
- srrea
Realized - Expenses Cost
- xcrea
Realized - Expenses Revenue
- xrrea
Pending - Material Cost
- mcpen
Pending - Material Revenue
- mrpen
Pending - Subcontracts Cost
- scpen
Pending - Subcontracts Revenue
- srpen
Pending - Expenses Cost
- xcpen
Pending - Expenses Revenue
- xrpen
Committed - Material Cost
- mccom
Committed - Material Revenue
- mrcom
Committed - Subcontracts Cost
- sccom
Committed - Subcontracts Revenue
- srcom
Committed - Expenses Cost
- xccom
Committed - Expenses Revenue
- xrcom
Total - Material Cost
- mctot
Total - Material Revenue
- mrtot
Total - Subcontracts Cost
- sctot
Total - Subcontracts Revenue
- srtot
Total - Expenses Cost
- xctot
Total - Expenses Revenue
- xrtot
Over/Under - Material Cost
- mcover
Over/Under - Material Revenue
- mrover
Over/Under - Subcontracts Cost
- scover
Over/Under - Subcontracts Revenue
- srover
Over/Under - Expenses Cost
- xcover
Over/Under - Expenses Revenue
- xrover
- datetime()
- "Page "+alltrim(str(_pageno))
Standard Report Fields (Page header - ACTPROJ2)
Company
- gc_company
Standard Report Fields (Group Header custno- ACTPROJ2)
Customer
- company
Standard Report Fields (Detail - ACTPROJ2)
SvrOrd#
- sono
Task
- task
Estimate - Total Cost
- tcest
Estimate - Total Revenue
- trest
Estimate - Labor Cost
- lcest
Estimate - Labor Revenue
- lrest
Estimate - Equipment Cost
- ecest
Estimate - Equipment Revenue
- erest
Estimate - Overhead Cost
- ocest
Estimate - Overhead Revenue
- orest
Budget - Total Cost
- tcbud
Budget - Total Revenue
- trbud
Budget - Labor Cost
- lcbud
Budget - Labor Revenue
- lrbud
Budget - Equipment Cost
- ecbud
Budget - Equipment Revenue
- erbud
Budget - Overhead Cost
- ocbud
Budget - Overhead Revenue
- orbud
Realized - Total Cost
- tcrea
Realized - Total Revenue
- trrea
Realized - Labor Cost
- lcrea
Realized - Labor Revenue
- lrrea
Realized - Equipment Cost
- ecrea
Realized - Equipment Revenue
- errea
Realized - Overhead Cost
- ocrea
Realized - Overhead Revenue
- orrea
Pending - Total Cost
- tcpen
Pending - Total Revenue
- trpen
Pending - Labor Cost
- lcpen
Pending - Labor Revenue
- lrpen
Pending - Equipment Cost
- ecpen
Pending - Equipment Revenue
- erpen
Pending - Overhead Cost
- ocpen
Pending - Overhead Revenue
- orpen
Committed - Total Cost
- tccom
Committed - Total Revenue
- trcom
Committed - Labor Cost
- lccom
Committed - Labor Revenue
- lrcom
Committed - Equipment Cost
- eccom
Committed - Equipment Revenue
- ercom
Committed - Overhead Cost
- occom
Committed - Overhead Revenue
- orcom
Total - Total Cost
- tctot
Total - Total Revenue
- trtot
Total - Labor Cost
- lctot
Total - Labor Revenue
- lrtot
Total - Equipment Cost
- ectot
Total - Equipment Revenue
- ertot
Total - Overhead Cost
- octot
Total - Overhead Revenue
- ortot
Over/Under - Total Cost
- tcover
Over/Under - Total Revenue
- trover
Over/Under - Labor Cost
- lcover
Over/Under - Labor Revenue
- lrover
Over/Under - Equipment Cost
- ecover
Over/Under - Equipment Revenue
- erover
Over/Under - Overhead Cost
- ocover
Over/Under - Overhead Revenue
- orover
Estimate - Material Cost
- mcest
Estimate - Material Revenue
- mrest
Estimate - Subcontracts Cost
- scest
Estimate - Subcontracts Revenue
- srest
Estimate - Expenses Cost
- xcest
Estimate - Expenses Revenue
- xrest
Budget - Material Cost
- mcbud
Budget - Material Revenue
- mrbud
Budget - Subcontracts Cost
- scbud
Budget - Subcontracts Revenue
- srbud
Budget - Expenses Cost
- xcbud
Budget - Expenses Revenue
- xrbud
Realized - Material Cost
- mcrea
Realized - Material Revenue
- mrrea
Realized - Subcontracts Cost
- screa
Realized - Subcontracts Revenue
- srrea
Realized - Expenses Cost
- xcrea
Realized - Expenses Revenue
- xrrea
Pending - Material Cost
- mcpen
Pending - Material Revenue
- mrpen
Pending - Subcontracts Cost
- scpen
Pending - Subcontracts Revenue
- srpen
Pending - Expenses Cost
- xcpen
Pending - Expenses Revenue
- xrpen
Committed - Material Cost
- mccom
Committed - Material Revenue
- mrcom
Committed - Subcontracts Cost
- sccom
Committed - Subcontracts Revenue
- srcom
Committed - Expenses Cost
- xccom
Committed - Expenses Revenue
- xrcom
Total - Material Cost
- mctot
Total - Material Revenue
- mrtot
Total - Subcontracts Cost
- sctot
Total - Subcontracts Revenue
- srtot
Total - Expenses Cost
- xctot
Total - Expenses Revenue
- xrtot
Over/Under - Material Cost
- mcover
Over/Under - Material Revenue
- mrover
Over/Under - Subcontracts Cost
- scover
Over/Under - Subcontracts Revenue
- srover
Over/Under - Expenses Cost
- xcover
Over/Under - Expenses Revenue
- xrover
Customer
- company
Estimate - Total Cost
- tcest
Estimate - Total Revenue
- trest
Estimate - Labor Cost
- lcest
Estimate - Labor Revenue
- lrest
Estimate - Equipment Cost
- ecest
Estimate - Equipment Revenue
- erest
Estimate - Overhead Cost
- ocest
Estimate - Overhead Revenue
- orest
Budget - Total Cost
- tcbud
Budget - Total Revenue
- trbud
Budget - Labor Cost
- lcbud
Budget - Labor Revenue
- lrbud
Budget - Equipment Cost
- ecbud
Budget - Equipment Revenue
- erbud
Budget - Overhead Cost
- ocbud
Budget - Overhead Revenue
- orbud
Realized - Total Cost
- tcrea
Realized - Total Revenue
- trrea
Realized - Labor Cost
- lcrea
Realized - Labor Revenue
- lrrea
Realized - Equipment Cost
- ecrea
Realized - Equipment Revenue
- errea
Realized - Overhead Cost
- ocrea
Realized - Overhead Revenue
- orrea
Pending - Total Cost
- tcpen
Pending - Total Revenue
- trpen
Pending - Labor Cost
- lcpen
Pending - Labor Revenue
- lrpen
Pending - Equipment Cost
- ecpen
Pending - Equipment Revenue
- erpen
Pending - Overhead Cost
- ocpen
Pending - Overhead Revenue
- orpen
Committed - Total Cost
- tccom
Committed - Total Revenue
- trcom
Committed - Labor Cost
- lccom
Committed - Labor Revenue
- lrcom
Committed - Equipment Cost
- eccom
Committed - Equipment Revenue
- ercom
Committed - Overhead Cost
- occom
Committed - Overhead Revenue
- orcom
Total - Total Cost
- tctot
Total - Total Revenue
- trtot
Total - Labor Cost
- lctot
Total - Labor Revenue
- lrtot
Total - Equipment Cost
- ectot
Total - Equipment Revenue
- ertot
Total - Overhead Cost
- octot
Total - Overhead Revenue
- ortot
Over/Under - Total Cost
- tcover
Over/Under - Total Revenue
- trover
Over/Under - Labor Cost
- lcover
Over/Under - Labor Revenue
- lrover
Over/Under - Equipment Cost
- ecover
Over/Under - Equipment Revenue
- erover
Over/Under - Overhead Cost
- ocover
Over/Under - Overhead Revenue
- orover
Estimate - Material Cost
- mcest
Estimate - Material Revenue
- mrest
Estimate - Subcontracts Cost
- scest
Estimate - Subcontracts Revenue
- srest
Estimate - Expenses Cost
- xcest
Estimate - Expenses Revenue
- xrest
Budget - Material Cost
- mcbud
Budget - Material Revenue
- mrbud
Budget - Subcontracts Cost
- scbud
Budget - Subcontracts Revenue
- srbud
Budget - Expenses Cost
- xcbud
Budget - Expenses Revenue
- xrbud
Realized - Material Cost
- mcrea
Realized - Material Revenue
- mrrea
Realized - Subcontracts Cost
- screa
Realized - Subcontracts Revenue
- srrea
Realized - Expenses Cost
- xcrea
Realized - Expenses Revenue
- xrrea
Pending - Material Cost
- mcpen
Pending - Material Revenue
- mrpen
Pending - Subcontracts Cost
- scpen
Pending - Subcontracts Revenue
- srpen
Pending - Expenses Cost
- xcpen
Pending - Expenses Revenue
- xrpen
Committed - Material Cost
- mccom
Committed - Material Revenue
- mrcom
Committed - Subcontracts Cost
- sccom
Committed - Subcontracts Revenue
- srcom
Committed - Expenses Cost
- xccom
Committed - Expenses Revenue
- xrcom
Total - Material Cost
- mctot
Total - Material Revenue
- mrtot
Total - Subcontracts Cost
- sctot
Total - Subcontracts Revenue
- srtot
Total - Expenses Cost
- xctot
Total - Expenses Revenue
- xrtot
Over/Under - Material Cost
- mcover
Over/Under - Material Revenue
- mrover
Over/Under - Subcontracts Cost
- scover
Over/Under - Subcontracts Revenue
- srover
Over/Under - Expenses Cost
- xcover
Over/Under - Expenses Revenue
- xrover
- datetime()
- "Page "+alltrim(str(_pageno))