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 screenshotReport Filters
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 KipsCustomerNet RevenueFreightPrice Per tonEst MarginMargin %Group Footer Sorter - revbyjob
KipsCustomerNet RevenueFreightPrice Per Ton- iif(tkips<>0,tnetamt/(tkips/2),0)
Est MarginMargin %- iif(tnetamt<>0,Round(((tnetamt - tcostamt) / tnetamt) * 100,2),0)
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 KipsCustomerNet RevenueFreightPrice Per tonEst MarginMargin %Detail - revbyjobd
Invoice NumberKipsNet RevenueFreightPrice Per TonEst MarginMargin %Group Footer Sorter - revbyjobd
KipsCustomerNet RevenueFreightPrice Per Ton- iif(tkips<>0,tnetamt/(tkips/2),0)
- iif(akips<>0,anetamt/(akips/2),0)
Est MarginMargin %- iif(tnetamt<>0,Round(((tnetamt - tcostamt) / tnetamt) * 100,2),0)
- iif(anetamt<>0,Round(((anetamt - acostamt) / anetamt) * 100,2),0)
