Receiving Report

From UG

(Difference between revisions)
Jump to: navigation, search
(Detailed Design)
(Columns in xls)
Line 73: Line 73:
=== Filters===  
=== Filters===  
=== Output===  
=== Output===  
-
===  Columns in xls===  
+
===  Columns in xls===
 +
 
 +
* [[Reports_Output#CT_Num_without_hyperlink]]
 +
* date created ???
 +
* [[Reports_Output# Available]]
 +
* ......
 +
 
=== Sort Order===  
=== Sort Order===  
=== Schedule vs Generate===
=== Schedule vs Generate===
== History ==
== History ==

Revision as of 22:11, 18 May 2010


Contents

General

Business Requirements

Summary

This report is needed for Trucking modes. It is similar in nature to In Transit.

Hard coded conditions

We need to report all CTs that are:


and	(NOT "ON HOLD")	
and	(NOT "PENDING APPROVAL")	
and	(NOT DELIVERED)

Filters

Minimum: Same as in Trucking Optimization Report.

Maximum: all CT fields.

Output

Columns in xls

CT#	(text, not hyperlink)
date created	
date available	
pick up date	
delivery date	

------------- (origin / supplier information)
Supplier	
Tel #	
City	
State	
ZIP	
PO #	
SKU/Item	
Plts	
Lose Ctns	
Gross Wt (LB) with LB Label	
------------ Consignee / delivery location
Consignee	
City	
State	
ZIP	
Telephone #	 
Trucker Name

Sort Order

????

Schedule vs Generate

Need both.

Related Business Process

TBD

Misc

See also attached to http://mantis.jaguarfreight.com/mantis/view.php?id=2061

Detailed Design

Hard coded conditions

Filters

Output

Columns in xls

Sort Order

Schedule vs Generate

History

Personal tools