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