Revenue by Project

Modified on Thu, 20 Oct 2011 13:34 by Greg Andrews — Categorized as: Project Management

Table of Contents [Hide/Show]

   General Description
   Report Filters
   Standard Report Fields Summary - revbyjob
      Page Header - revbyjob
      Detail - revbyjob)
      Group Footer Sorter - revbyjob
   Standard Report Fields Detail - revbyjobd)
      Header - revbyjobd
      Group Header Sorter - revbyjobd
      Detail - revbyjobd
      Group Footer Sorter - revbyjobd

General Description¶

Default Menu Location Reports >> Project Management >> Revenue by Project

Screen Name REVBYJOB

Function The Revenue by Project generates a report based on a date range and project type.

Click here for a screenshot

Report Filters¶

Start Date

End date

Project Type

Warehouse

Summary/Detail

Standard Report Fields Summary - revbyjob¶

Page Header - revbyjob¶

company: company

Date and time: datetime()

Page Number: "Page # " + alltrim(str(_pageno))

Warehouse Name: whsename

Selected Filters: lc_filt

Detail - revbyjob)¶

Project ID/Name

projid

msnname

Kips

kips

Customer

company

Net Revenue

netamt

Freight

frtamt

Price Per ton

Est Margin

estmargin

Margin %

marper

Group Footer Sorter - revbyjob¶

Kips

kips

kips

Customer

company

Net Revenue

netamt

netamt

Freight

frtamt

frtamt

Price Per Ton

iif(tkips<>0,tnetamt/(tkips/2),0)

Est Margin

estmargin

estmargin

Margin %

iif(tnetamt<>0,Round(((tnetamt - tcostamt) / tnetamt) * 100,2),0)

marper

Standard Report Fields Detail - revbyjobd)¶

Header - revbyjobd¶

company: company

Date and time: datetime()

Page Number: "Page # " + alltrim(str(_pageno))

Warehouse Name: whsename

Selected Filters: lc_filt

Group Header Sorter - revbyjobd¶

JobNo

projid

msnname

Kips

kips

Customer

company

Net Revenue

netamt

Freight

frtamt

Price Per ton

Est Margin

estmargin

Margin %

marper

Detail - revbyjobd¶

Invoice Number

invno

Kips

kips

Net Revenue

netamt

Freight

frtamt

Price Per Ton

Est Margin

estmargin

Margin %

marpaer

Group Footer Sorter - revbyjobd¶

Kips

kips

akips

Customer

company

Net Revenue

netamt

anetamt

Freight

frtamt

afrtamt

Price Per Ton

iif(tkips<>0,tnetamt/(tkips/2),0)

iif(akips<>0,anetamt/(akips/2),0)

Est Margin

estmargin

aestmargin

estmargin

Margin %

iif(tnetamt<>0,Round(((tnetamt - tcostamt) / tnetamt) * 100,2),0)

iif(anetamt<>0,Round(((anetamt - acostamt) / anetamt) * 100,2),0)

marper