Receiving Report
From UG
(→Sort Order (SA)) |
(→Columns(SA)) |
||
| Line 108: | Line 108: | ||
Spreadsheet only. | Spreadsheet only. | ||
| - | ==== Columns(SA) ==== | + | ==== Columns (SA) ==== |
| - | + | 1) Fields to include - see below | |
| + | |||
| + | 2) Order left to right as below | ||
* [[CT#CT_Num]] | * [[CT#CT_Num]] | ||
| Line 125: | Line 127: | ||
* [[Address#Zip]] related to [[CT#Pick Up]] | * [[Address#Zip]] related to [[CT#Pick Up]] | ||
| - | * [[ | + | * [[Commodity#PO]] related to [[CT#CT Num]] |
| - | * [[ | + | * [[Commodity#SKU]] related to [[CT#CT Num]] |
| - | * [[ | + | * [[Commodity#Plts]] related to [[CT#CT Num]] |
| - | * [[ | + | * [[Commodity#Loose Pkgs]] related to [[CT#CT Num]] |
| - | * [[ | + | * [[Commodity#Gross_Lb]] related to [[CT#CT Num]] |
* [[Address#Company]] related to [[CT#Delivery To]] | * [[Address#Company]] related to [[CT#Delivery To]] | ||
| Line 139: | Line 141: | ||
* [[CT#Pick Up Trucker]] | * [[CT#Pick Up Trucker]] | ||
| - | Use [[Reports_Output#LIPCO_multi_line]] | + | 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 ==== | ==== Tabs ==== | ||
Revision as of 19:54, 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)
- It is similar in nature to In Transit.
- Urgently needed for NATP.
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:
- (CT#On Customer Hold = false)
- and (CT#Pending Approval = false)
- and (CT#Actual_Delivery_Date is empty)
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
- Address#Company related to CT#Pick Up
- Address#Phone related to CT#Pick Up
- Address#City related to CT#Pick Up
- Address#State related to CT#Pick Up
- Address#Zip related to CT#Pick Up
- Commodity#PO related to CT#CT Num
- Commodity#SKU related to CT#CT Num
- Commodity#Plts related to CT#CT Num
- Commodity#Loose Pkgs related to CT#CT Num
- Commodity#Gross_Lb related to CT#CT Num
- Address#Company related to CT#Delivery To
- Address#Phone related to CT#Delivery To
- Address#City related to CT#Delivery To
- Address#State related to CT#Delivery To
- Address#Zip related to CT#Delivery To
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.
