Welcome Guest, you are in: <root>AFIweb • Login

Page History: Revenue by Project

Compare Page Revisions

5 4 3 2 1 0 Current 5 4 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: Tue, 07 Jul 2009 14:01

Table of Contents [Hide/Show] Default Menu Location 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 Additional Report Fields for Customization

Default Menu Location¶

Reports >> Project Control >> Revenue by Project

Click here for a screenshot

General Description¶

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

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

• ppt
  

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)
  

• ppt
  

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

• ppt
  

Est Margin

• estmargin
  

Margin %

• marper
  

Detail - revbyjobd¶

Invoice Number

• invno
  

Kips

• kips
  

Net Revenue

• netamt
  

Freight

• frtamt
  

Price Per Ton

• ppt
  

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)
  

• ppt
  

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
  

Additional Report Fields for Customization¶