Receiving Report

From UG

Contents 1 General 2 Business Requirements 2.1 Summary 2.2 Hard coded conditions 2.3 Filters 2.4 Output 2.4.1 Columns in xls 2.4.2 Sort Order 2.5 Schedule vs Generate 2.6 Related Business Process 2.7 Misc 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

This report is needed for Trucking modes. It is similar in nature to In Transit.

Hard coded conditions

We need to report all CTs that are:

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

Filters

Minimum: Same as in Trucking Optimization Report.

Maximum: all CT fields.

Output

Columns in xls

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

Sort Order

????

Schedule vs Generate

Need both.

Related Business Process

TBD

Misc

See also 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