Receiving Report

From UG

(Difference between revisions)
Jump to: navigation, search
(Columns (SA))
(Sort Order (SA))
Line 151: Line 151:
====  Sort Order (SA) ====
====  Sort Order (SA) ====
-
Sort by delivery date; earliest on the top.
+
Sort by [[CT#Actual Delivery Date]]; earliest on the top.
===  Schedule vs Generate (SA) ===
===  Schedule vs Generate (SA) ===

Revision as of 20:09, 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 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 on xls (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 CT#Actual Delivery Date; earliest on the top.

Schedule vs Generate (SA)

Need both.

History

Personal tools