Receiving Report
From UG
(Difference between revisions)
(→Columns(BR)) |
(→Columns(SA)) |
||
| Line 114: | Line 114: | ||
* [[CT#CT_Num]] | * [[CT#CT_Num]] | ||
** use [[Reports_Output#CT_Num_without_hyperlink]] | ** use [[Reports_Output#CT_Num_without_hyperlink]] | ||
| - | |||
* [[CT#Created On]] | * [[CT#Created On]] | ||
* [[CT#Cargo available]] | * [[CT#Cargo available]] | ||
* [[CT#Actual Pick Up Date]] | * [[CT#Actual Pick Up Date]] | ||
* [[CT#Actual Delivery Date]] | * [[CT#Actual Delivery Date]] | ||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | + | * [[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]] | |
| - | + | ||
| + | * [[CT#]] related to [[Commodity#PO]] | ||
| + | * [[CT#]] related to [[Commodity#SKU]] | ||
| + | * [[CT#]] related to [[Commodity#Plts]] | ||
| + | * [[CT#]] related to [[Commodity#Loose Pkgs]] | ||
| + | * [[CT#]] related to [[Commodity#Gross_Lb]] | ||
| + | |||
| + | * [[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]] | ||
| - | + | * [[CT#Pick Up Trucker]] | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | Use [[Reports_Output#LIPCO_multi_line]] ! | |
| - | + | ||
==== Tabs ==== | ==== Tabs ==== | ||
Revision as of 19:48, 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)
Display in the following order:
- 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
- CT# related to Commodity#PO
- CT# related to Commodity#SKU
- CT# related to Commodity#Plts
- CT# related to Commodity#Loose Pkgs
- CT# related to Commodity#Gross_Lb
- 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
Use Reports_Output#LIPCO_multi_line !
Tabs
One tab
Sort Order (SA)
What columns ? In what order ?
Schedule vs Generate (SA)
Need both.
