Receiving Report

From UG

Revision as of 16:55, 19 May 2010 (edit) Alex (Talk | contribs) (→Detailed Design) ← Older edit		Revision as of 17:08, 19 May 2010 (edit) (undo) Alex (Talk | contribs) Newer edit →
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 1 General 2 Business Requirements 2.1 Summary (BR) 2.2 MOT (BR) 2.3 Hard coded conditions (BR) 2.4 Filters (BR) 2.5 Output (BR) 2.5.1 Types of output (BR) 2.5.2 Columns(BR) 2.5.3 Tabs 2.5.4 Sort Order (BR) 2.6 Schedule vs Generate (BR) 2.7 Related Workflow (BR) 2.8 See Also (BR) 3 Detailed Design 3.1 MOT (SA) 3.2 Hard coded conditions (SA) 3.3 Filters (SA) 3.4 Output (SA) 3.4.1 Types of output (SA) 3.4.2 Columns(SA) 3.4.3 Tabs 3.4.4 Sort Order (SA) 3.5 Schedule vs Generate (SA) 4 History

General

• parent: http://mantis.jaguarfreight.com/mantis/view.php?id=2061

Business Requirements

Summary (BR)

• It is similar in nature to In Transit.
• Urgently needed for NATP.

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:

• (CT#On Customer Hold = false)
• 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