TMS Monthly Stats Report

From UG

(Difference between revisions)
Jump to: navigation, search
(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

File:TMS Reports Menu.JPG


TMS Run Supplier Detail Report

File:Run Supplier Report.JPG


Supplier Detail Report Results

File:Results.JPG


Results in HTML (excel ss)

File:Results in HTML.JPG

Personal tools