Receiving Report
From UG
(Difference between revisions)
(→Business Requirements) |
(→Columns(SA)) |
||
Line 110: | Line 110: | ||
==== Columns(SA) ==== | ==== Columns(SA) ==== | ||
- | + | Display in the following order: | |
- | + | ||
- | + | * [[CT#CT_Num]] | |
- | + | ** use [[Reports_Output#CT_Num_without_hyperlink]] | |
- | + | ||
+ | * [[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)
- 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 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:
------------- (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.