Project Summary

Modified on Thu, 25 Jun 2009 16:03 by kyimin — Categorized as: Project Management

Table of Contents [Hide/Show]

Default Menu Location¶

Maintain >> Project Control >> Projects

Accessible from the Reports tab of the 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¶