Receiving Report
From UG
Contents |
General
Business Requirements
Summary (BR)
- It is similar in nature to In Transit.
- Urgently needed for NATP.
MOT (BR)
For Trucking modes 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
Hard coded conditions
Filters
Output
Columns in xls
- Reports_Output#CT_Num_without_hyperlink
- date created ???
- Reports_Output# Available
- ......