Receiving Report
From UG
(Difference between revisions)
(→Filters (SA)) |
|||
Line 97: | Line 97: | ||
=== Filters (SA) === | === Filters (SA) === | ||
- | + | Same as in [[Trucking Optimization Report]]. | |
- | + | ||
- | + | ||
=== Output (SA)=== | === Output (SA)=== |
Revision as of 17:11, 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)
Same as in Trucking Optimization Report.
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.