TMS Monthly Stats Report

From UG

Revision as of 21:02, 8 August 2011 by Denise (Talk | contribs)
Jump to: navigation, search


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