Receiving Report
From UG
(Difference between revisions)
(→Detailed Design) |
|||
Line 12: | Line 12: | ||
=== MOT (BR) === | === MOT (BR) === | ||
- | For | + | For Truck-Domestic only. |
=== Hard coded conditions (BR) === | === Hard coded conditions (BR) === | ||
Line 79: | Line 79: | ||
=== See Also (BR) === | === See Also (BR) === | ||
See xls attached to http://mantis.jaguarfreight.com/mantis/view.php?id=2061 | See xls attached to http://mantis.jaguarfreight.com/mantis/view.php?id=2061 | ||
+ | |||
+ | <!-- -----------------------------------------------------------------------------> | ||
== Detailed Design == | == Detailed Design == | ||
- | === MOT (SA)=== | + | === MOT (SA) === |
- | === | + | For Truck-domestic only. |
- | === | + | |
- | === Output (SA)=== | + | === Hard coded conditions (SA) === |
- | === Types of output (SA)=== | + | |
- | === Columns(SA)=== | + | We need to report all CTs that are: |
- | === Tabs | + | |
- | === Sort Order (SA)=== | + | *([[CT#On Customer Hold]] = false) |
- | === Schedule vs Generate (SA)=== | + | * and ([[CT#Pending Approval]] = false) |
+ | * and ([[CT#Actual_Delivery_Date]] is empty) | ||
+ | |||
+ | === Filters (SA) === | ||
+ | |||
+ | Minimum: Same as in [[Trucking Optimization Report]]. | ||
+ | |||
+ | Maximum: all CT fields. | ||
+ | |||
+ | === Output (SA)=== | ||
+ | |||
+ | ==== Types of output (SA) ==== | ||
+ | |||
+ | Spreadsheet only. | ||
+ | |||
+ | ==== Columns(SA) ==== | ||
+ | |||
+ | 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? One tab per Pick Up State? | ||
+ | |||
+ | ==== Sort Order (SA) ==== | ||
+ | |||
+ | What columns ? | ||
+ | In what order ? | ||
+ | |||
+ | === Schedule vs Generate (SA) === | ||
+ | Need both. | ||
== History == | == History == |
Revision as of 17:08, 19 May 2010
Contents |
General
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? One tab per Pick Up State?
Sort Order (BR)
What columns ? In what order ?
Schedule vs Generate (BR)
Need both.
Related Workflow (BR)
Unknown.
See Also (BR)
See xls attached to http://mantis.jaguarfreight.com/mantis/view.php?id=2061
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)
Minimum: Same as in Trucking Optimization Report.
Maximum: all CT fields.
Output (SA)
Types of output (SA)
Spreadsheet only.
Columns(SA)
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? One tab per Pick Up State?
Sort Order (SA)
What columns ? In what order ?
Schedule vs Generate (SA)
Need both.