Receiving Report
From UG
(Difference between revisions)
(→Detailed Design) |
(→Columns in xls) |
||
| Line 73: | Line 73: | ||
=== Filters=== | === Filters=== | ||
=== Output=== | === Output=== | ||
| - | === Columns in xls=== | + | === Columns in xls=== |
| + | |||
| + | * [[Reports_Output#CT_Num_without_hyperlink]] | ||
| + | * date created ??? | ||
| + | * [[Reports_Output# Available]] | ||
| + | * ...... | ||
| + | |||
=== Sort Order=== | === Sort Order=== | ||
=== Schedule vs Generate=== | === Schedule vs Generate=== | ||
== History == | == History == | ||
Revision as of 22:11, 18 May 2010
Contents |
General
Business Requirements
Summary
This report is needed for Trucking modes. It is similar in nature to In Transit.
Hard coded conditions
We need to report all CTs that are:
and (NOT "ON HOLD") and (NOT "PENDING APPROVAL") and (NOT DELIVERED)
Filters
Minimum: Same as in Trucking Optimization Report.
Maximum: all CT fields.
Output
Columns in xls
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
Sort Order
????
Schedule vs Generate
Need both.
Related Business Process
TBD
Misc
See also attached to http://mantis.jaguarfreight.com/mantis/view.php?id=2061
Detailed Design
Hard coded conditions
Filters
Output
Columns in xls
- Reports_Output#CT_Num_without_hyperlink
- date created ???
- Reports_Output# Available
- ......
