View source for Project Summary

{TOC}

==Default Menu Location==

Maintain >> Project Control >> Projects

Accessible from the Reports tab of the [http://www.abiscorp.com/AdjWiki/GetFile.aspx?File=Project 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

===Standard Report Fields (Group Footer keyno - ACTPROJ)===

'''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

===Standard Report Fields (Page Footer - ACTPROJ)===

*  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

===Standard Report Fields (Group Footer custno- ACTPROJ2)===

'''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

===Standard Report Fields (Page Footer - ACTPROJ2)===

*  datetime()

*  "Page "+alltrim(str(_pageno))


==Additional Report Fields for Customization==

[[Category:Project Management]]