Receiving Report

From UG

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