TMS Monthly Stats Report
From UG
(Difference between revisions)
(→Business Requirements & Current Business Process) |
(→Business Requirements & Current Business Process) |
||
| Line 13: | Line 13: | ||
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: | 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 | + | *Supplier |
| - | Origin State | + | *Origin State |
| - | Origin Zip | + | *Origin Zip |
| - | Consignee | + | *Consignee |
| - | Destination State | + | *Destination State |
| - | Destination Zip | + | *Destination Zip |
| - | Carrier | + | *Carrier |
| - | Load Count | + | *Load Count |
| - | Total Charge | + | *Total Charge |
| - | Total Weight | + | *Total Weight |
| - | Total Pallets | + | *Total Pallets |
| - | Total Loose Package | + | *Total Loose Package |
| - | Avg Weight Per Load | + | *Avg Weight Per Load |
| - | Avg Pallet Per Load | + | *Avg Pallet Per Load |
| - | Avg Loose Package Per Load | + | *Avg Loose Package Per Load |
| - | Lowest Weight Per Load | + | *Lowest Weight Per Load |
| - | Highest Weight Per Load | + | *Highest Weight Per Load |
| - | Lowest Pallet Per Load | + | *Lowest Pallet Per Load |
| - | Highest Pallet Per Load | + | *Highest Pallet Per Load |
| - | Lowest Loose Package Per Load | + | *Lowest Loose Package Per Load |
| - | Highest Loose Package Per Load | + | *Highest Loose Package Per Load |
| - | Cost Per Lb | + | *Cost Per Lb |
=== Requirements === | === Requirements === | ||
Revision as of 21:02, 8 August 2011
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)
