Receiving Report

From UG

(Difference between revisions)
Jump to: navigation, search
(Business Requirements)
(Columns(SA))
Line 110: Line 110:
==== Columns(SA) ====
==== Columns(SA) ====
-
CT# (text, not hyperlink)
+
Display in the following order:
-
date created
+
 
-
date available
+
* [[CT#CT_Num]]
-
pick up date
+
** use [[Reports_Output#CT_Num_without_hyperlink]]
-
delivery date
+
 
 +
* [[CT#Created On]]
 +
* [[CT#Cargo available]]
 +
* [[CT#Actual Pick Up Date]]
 +
* [[CT#Actual Delivery Date]]
 +
* [[CT#]]
 +
* [[CT#]]
 +
* [[CT#]]
 +
* [[CT#]]
 +
* [[CT#]]
   
   
  ------------- (origin / supplier information)
  ------------- (origin / supplier information)
Line 122: Line 131:
  State
  State
  ZIP
  ZIP
 +
 +
------------
  PO #
  PO #
  SKU/Item
  SKU/Item
Line 133: Line 144:
  State
  State
  ZIP
  ZIP
-
  Telephone #  
+
  Telephone #
 +
 
 +
  ------------ Trucker info
  Trucker Name
  Trucker Name

Revision as of 19:28, 19 May 2010


Contents

General

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)

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.



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)

Display in the following order:

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

Personal tools