Receiving Report

From UG

Revision as of 19:54, 19 May 2010 by Alex (Talk | contribs)
Jump to: navigation, search


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 info 
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)

1) Fields to include - see below

2) Order left to right as below

3) Use Reports_Output#LIPCO_multi_line

4) Label for each field is defined in related wiki BO-article (Commodity, Address, CT ). See label: under Reports: section for given field.

Tabs

One tab

Sort Order (SA)

Sort by delivery date; earliest on the top.

Schedule vs Generate (SA)

Need both.

History

Personal tools