Receiving Report

From UG

Revision as of 19:28, 19 May 2010 (edit) Alex (Talk | contribs) (→Columns(SA)) ← Older edit		Revision as of 19:29, 19 May 2010 (edit) (undo) Alex (Talk | contribs) (→Columns(BR)) Newer edit →
Line 46:		Line 46:
	pick up date		pick up date
	delivery date		delivery date
-		+	------------- (origin / supplier information)
-	------------- (origin / supplier information)	+
	Supplier		Supplier
	Tel #		Tel #
Line 53:		Line 52:
	State		State
	ZIP		ZIP
		+	------------
	PO #		PO #
	SKU/Item		SKU/Item
Line 58:		Line 58:
	Lose Ctns		Lose Ctns
	Gross Wt (LB) with LB Label		Gross Wt (LB) with LB Label
-
	------------ Consignee / delivery location		------------ Consignee / delivery location
	Consignee		Consignee
Line 64:		Line 63:
	State		State
	ZIP		ZIP
-	Telephone #	+	Telephone #
		+	------------ Trucker info
	Trucker Name		Trucker Name

---

Revision as of 19:29, 19 May 2010

Contents 1 General 2 Business Need (MO) 3 Business Requirements 3.1 Summary (BR) 3.2 MOT (BR) 3.3 Hard coded conditions (BR) 3.4 Filters (BR) 3.5 Output (BR) 3.5.1 Types of output (BR) 3.5.2 Columns(BR) 3.5.3 Tabs 3.5.4 Sort Order (BR) 3.6 Schedule vs Generate (BR) 3.7 Related Workflow (BR) 4 Detailed Design 4.1 MOT (SA) 4.2 Hard coded conditions (SA) 4.3 Filters (SA) 4.4 Output (SA) 4.4.1 Types of output (SA) 4.4.2 Columns(SA) 4.4.3 Tabs 4.4.4 Sort Order (SA) 4.5 Schedule vs Generate (SA) 5 History

General

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

Business Need (MO)

Unknown.

See also xls provided by Module Owner attached to 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 info 
Trucker Name

Tabs

One tab

Sort Order (BR)

Sort by delivery date; earliest on the top.

Schedule vs Generate (BR)

Need both.

Related Workflow (BR)

Unknown.

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)

Same as in Trucking Optimization Report.

Output (SA)

Types of output (SA)

Spreadsheet only.

Columns(SA)

Display in the following order:

• CT#CT_Num
  • use Reports_Output#CT_Num_without_hyperlink

• CT#Created On
• CT#Cargo available
• CT#Actual Pick Up Date
• CT#Actual Delivery Date
• CT#
• CT#
• CT#
• CT#
• CT#

------------- (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 info 
Trucker Name

Tabs

One tab

Sort Order (SA)

What columns ? In what order ?

Schedule vs Generate (SA)

Need both.

History