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 10:42

Table of Contents [Hide/Show] Default Menu Location General Description Report Filters Standard Report Fields (Header - revbyjob) Standard Report Fields (Detail - revbyjob) Standard Report Fields (Group Footer Sorter - revbyjob) Standard Report Fields (Header - revbyjobd) Standard Report Fields (Group Header Sorter - revbyjobd) Standard Report Fields (Detail - revbyjobd) Standard Report Fields (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 (Header - revbyjob)¶

company: company

Date and time: datetime()

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

Warehouse Name: whsename

Selected Filters: lc_filt

Standard Report Fields (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
  

Standard Report Fields (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 (Header - revbyjobd)¶

company: company

Date and time: datetime()

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

Warehouse Name: whsename

Selected Filters: lc_filt

Standard Report Fields (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
  

Standard Report Fields (Detail - revbyjobd)¶

Invoice Number

• invno
  

Kips

• kips
  

Net Revenue

• netamt
  

Freight

• frtamt
  

Price Per Ton

• ppt
  

Est Margin

• estmargin
  

Margin %

• marpaer
  

Standard Report Fields (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¶