TMS Monthly Stats Report

From UG

Contents 1 Info 2 Summary 3 Business Requirements & Current Business Process 3.1 Requirements 3.2 Figures 3.2.1 TMS Report Menu 3.2.2 TMS Run Supplier Detail Report 3.2.3 Supplier Detail Report Results 3.2.4 Results in HTML (excel ss)

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)