Receiving Report
From UG
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 info 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)
1) Fields to include - see below
2) Order on xls (left to right) as below
- Address#Company related to CT#Pick Up
- Address#Phone related to CT#Pick Up
- Address#City related to CT#Pick Up
- Address#State related to CT#Pick Up
- Address#Zip related to CT#Pick Up
- Commodity#PO related to CT#CT Num
- Commodity#SKU related to CT#CT Num
- Commodity#Plts related to CT#CT Num
- Commodity#Loose Pkgs related to CT#CT Num
- Commodity#Gross_Lb related to CT#CT Num
- Address#Company related to CT#Delivery To
- Address#Phone related to CT#Delivery To
- Address#City related to CT#Delivery To
- Address#State related to CT#Delivery To
- Address#Zip related to CT#Delivery To
3) Use Reports_Output#LIPCO_multi_line
4) Label for each field is defined in related wiki BO-article (Commodity, Address, CT ). See label: under Reports: section for given field.
Tabs
One tab
Sort Order (SA)
Sort by CT#Actual Delivery Date; earliest on the top.
Schedule vs Generate (SA)
Need both.