Receiving Report

From UG

(Difference between revisions)
Jump to: navigation, search
(Detailed Design)
Line 12: Line 12:
=== MOT (BR) ===
=== MOT (BR) ===
-
For Trucking modes only.
+
For Truck-Domestic only.
=== Hard coded conditions (BR) ===
=== Hard coded conditions (BR) ===
Line 79: Line 79:
=== See Also (BR) ===
=== See Also (BR) ===
See xls attached to http://mantis.jaguarfreight.com/mantis/view.php?id=2061
See xls attached to http://mantis.jaguarfreight.com/mantis/view.php?id=2061
 +
 +
<!-- ----------------------------------------------------------------------------->
== Detailed Design ==
== Detailed Design ==
-
=== MOT (SA)===  
+
=== MOT (SA) ===
-
=== Hard coded conditions (SA) ===  
+
For Truck-domestic only.
-
=== Filters (SA)===  
+
 
-
=== Output (SA)===  
+
=== Hard coded conditions (SA) ===
-
=== Types of output (SA)===  
+
 
-
=== Columns(SA)===  
+
We need to report all CTs that are:
-
=== Tabs (SA) ===  
+
 
-
=== Sort Order (SA)===  
+
*([[CT#On Customer Hold]] = false)
-
=== Schedule vs Generate (SA)===
+
* and ([[CT#Pending Approval]] = false)
 +
* and ([[CT#Actual_Delivery_Date]] is empty)
 +
 
 +
=== Filters (SA) ===
 +
 
 +
Minimum: Same as in [[Trucking Optimization Report]].
 +
 
 +
Maximum: all CT fields.
 +
 
 +
=== Output (SA)===
 +
 
 +
==== Types of output (SA) ====
 +
 
 +
Spreadsheet only.
 +
 
 +
==== Columns(SA) ====
 +
 
 +
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
 +
 
 +
==== Tabs ====
 +
 
 +
One tab? One tab per Pick Up State?
 +
 
 +
===Sort Order (SA) ====
 +
 
 +
What columns ?
 +
In what order ?
 +
 
 +
=== Schedule vs Generate (SA) ===
 +
Need both.
== History ==
== History ==

Revision as of 17:08, 19 May 2010


Contents

General

Business Requirements

Summary (BR)

MOT (BR)

For Truck-Domestic only.

Hard coded conditions (BR)

We need to report all CTs that are:

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

Filters (BR)

Minimum: Same as in Trucking Optimization Report.

Maximum: all CT fields.

Output (BR)

Types of output (BR)

Spreadsheet only.

Columns(BR)

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

Tabs

One tab? One tab per Pick Up State?

Sort Order (BR)

What columns ? In what order ?

Schedule vs Generate (BR)

Need both.

Related Workflow (BR)

Unknown.

See Also (BR)

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


Detailed Design

MOT (SA)

For Truck-domestic only.

Hard coded conditions (SA)

We need to report all CTs that are:

Filters (SA)

Minimum: Same as in Trucking Optimization Report.

Maximum: all CT fields.

Output (SA)

Types of output (SA)

Spreadsheet only.

Columns(SA)

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

Tabs

One tab? One tab per Pick Up State?

Sort Order (SA)

What columns ? In what order ?

Schedule vs Generate (SA)

Need both.

History

Personal tools