TMS Monthly Stats Report
From UG
(Difference between revisions)
(→Summary) |
(→Business Requirements & Current Business Process) |
||
| Line 11: | Line 11: | ||
== Business Requirements & Current Business Process == | == 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: | + | Generate report from TMS called "Supplier Detail Previous Month". This report was personally built by Descartes according to Marc's requirements. The columns set on the report are: |
*Supplier | *Supplier | ||
| Line 36: | Line 36: | ||
*Cost Per Lb | *Cost Per Lb | ||
| - | These columns and values | + | These columns and values on this report are used to make up the entire workbook report that is given to Elizabeth Arden. |
=== Requirements === | === Requirements === | ||
| - | Add functionality into CT2 to be able to generate/create these high level reports for the monthly domestic trucking statistics. Basically, add the same as above | + | Add functionality into CT2 to be able to generate/create these high level reports for the monthly domestic trucking statistics. Basically, add the same as above. |
=== Figures === | === Figures === | ||
Revision as of 12:48, 9 August 2011
Contents |
Info
Mantis: 0003003: [TMS optimization] TMS Monthly Stats (make it art of CT2) 3003
Summary
Elizabeth Arden requires a high level monthly report of their domestic trucking activity. Including possibilities on where or how they can save money within their supply chain. This report
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 set 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
These columns and values on this report are used to make up the entire workbook report that is given to Elizabeth Arden.
Requirements
Add functionality into CT2 to be able to generate/create these high level reports for the monthly domestic trucking statistics. Basically, add the same as above.
Figures
TMS Report Menu
TMS Run Supplier Detail Report
Supplier Detail Report Results
Results in HTML (excel ss)
