Receiving Report

From UG

(Difference between revisions)
Jump to: navigation, search
(Tabs)
(Sort Order (BR))
Line 68: Line 68:
====  Sort Order (BR) ====
====  Sort Order (BR) ====
-
What columns ?
+
Sort by delivery date; earliest on the top.
-
In what order ?
+
===  Schedule vs Generate (BR) ===
===  Schedule vs Generate (BR) ===

Revision as of 19:09, 19 May 2010


Contents

General

Business Requirements

Summary (BR)

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 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.

See Also (BR)

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


Detailed Design

MOT (SA)

For Truck-domestic only.

Hard coded conditions (SA)

We need to report all CTs that are:

Filters (SA)

Same as in Trucking Optimization Report.

Output (SA)

Types of output (SA)

Spreadsheet only.

Columns(SA)

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

Sort Order (SA)

What columns ? In what order ?

Schedule vs Generate (SA)

Need both.

History

Personal tools