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:22

Table of Contents [Hide/Show] Default Menu Location General Description Report Filters Standard Report Fields (Header) =Standard Report Fields (Detail) Standard Report Fields (Group Footer Sorter)

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)¶

company: company

Date and time: datetime()

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

Warehouse Name: whsename

Selected Filters: lc_filt

=Standard Report Fields (Detail)¶

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)¶

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