Receiving Report

From UG

Revision as of 21:57, 18 May 2010 (edit) Alex (Talk | contribs) (→Output) ← Older edit		Revision as of 21:57, 18 May 2010 (edit) (undo) Alex (Talk | contribs) (→Output) Newer edit →
Line 26:		Line 26:
	=== Output ===		=== Output ===
		+
		+	==== Columns in xls ====
		+
	CT# (text, not hyperlink)		CT# (text, not hyperlink)
	date created		date created

---

Revision as of 21:57, 18 May 2010

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.5 Schedule vs Generate 2.6 Related Business Process 2.7 Misc

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

Schedule vs Generate

Need both.

Related Business Process

TBD

Misc

See also attached to http://mantis.jaguarfreight.com/mantis/view.php?id=2061