TMS Monthly Stats Report
From UG
Contents |
Info
Mantis: 0003003: [TMS optimization] TMS Monthly Stats (make it art of CT2) 3003
Summary
Add functionality into CT2 to be able to generate/create these high level reports for the monthly domestic trucking statistics.
Business Requirements & Current Business Process
Generate report from TMS called "Supplier Detail Previous Month". This report was personally built by Descartes according to Marc's requirements. The columns on the report are:
- Supplier
- Origin State
- Origin Zip
- Consignee
- Destination State
- Destination Zip
- Carrier
- Load Count
- Total Charge
- Total Weight
- Total Pallets
- Total Loose Package
- Avg Weight Per Load
- Avg Pallet Per Load
- Avg Loose Package Per Load
- Lowest Weight Per Load
- Highest Weight Per Load
- Lowest Pallet Per Load
- Highest Pallet Per Load
- Lowest Loose Package Per Load
- Highest Loose Package Per Load
- Cost Per Lb
Requirements
Same as above
Figures
TMS Report Menu
TMS Run Supplier Detail Report
Supplier Detail Report Results
Results in HTML (excel ss)
