Receiving Report

From UG

Revision as of 22:11, 18 May 2010 (edit) Alex (Talk | contribs) (→Columns in xls) ← Older edit		Revision as of 15:01, 19 May 2010 (edit) (undo) Alex (Talk | contribs) (→Business Requirements) Newer edit →
Line 7:		Line 7:
	== Business Requirements ==		== Business Requirements ==
-	=== Summary ===	+	=== Summary (BR) ===
-	This report is needed for Trucking modes. It is similar in nature to In Transit.	+	* It is similar in nature to In Transit.
		+	* Urgently needed for [[NATP]].
-	=== Hard coded conditions ===	+	=== MOT (BR) ===
		+	For Trucking modes only.
-	We need to report all CTs that are:	+	=== Hard coded conditions (BR) ===
		+	We need to report all CTs that are:
-	and (NOT "ON HOLD")	+	(NOT "ON HOLD")
	and (NOT "PENDING APPROVAL")		and (NOT "PENDING APPROVAL")
	and (NOT DELIVERED)		and (NOT DELIVERED)
-	=== Filters ===	+	=== Filters (BR) ===
	Minimum: Same as in [[Trucking Optimization Report]].		Minimum: Same as in [[Trucking Optimization Report]].
Line 25:		Line 28:
	Maximum: all CT fields.		Maximum: all CT fields.
-	=== Output ===	+	=== Output (BR)===
-	==== Columns in xls ====	+	==== Types of output (BR) ===
		+
		+	Spreadsheet only.
		+
		+	==== Columns(BR) ====
	CT# (text, not hyperlink)		CT# (text, not hyperlink)
Line 55:		Line 62:
	Trucker Name		Trucker Name
-	==== Sort Order ====	+	==== Tabs ====
		+
		+	One tab? One tab per Pick Up State?
		+
		+	====  Sort Order (BR) ====
-	????	+	What columns ?
		+	In what order ?
-	=== Schedule vs Generate ===	+	=== Schedule vs Generate (BR) ===
	Need both.		Need both.
-	=== Related Business Process ===	+	=== Related Workflow (BR) ===
-	TBD	+	Unknown.
-	=== Misc ===	+	=== See Also (BR) ===
-	See also 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 ==

---

Revision as of 15:01, 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.6 = Types of output (BR) 2.6.1 Columns(BR) 2.6.2 Tabs 2.6.3 Sort Order (BR) 2.7 Schedule vs Generate (BR) 2.8 Related Workflow (BR) 2.9 See Also (BR) 3 Detailed Design 3.1 Hard coded conditions 3.2 Filters 3.3 Output 3.4 Columns in xls 3.5 Sort Order 3.6 Schedule vs Generate 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 Trucking modes 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

Hard coded conditions

Filters

Output

Columns in xls

• Reports_Output#CT_Num_without_hyperlink
• date created ???
• Reports_Output# Available
• ......

Sort Order

Schedule vs Generate

History