Trucking Optimization Report

From UG

Revision as of 01:51, 22 April 2010 (edit) Alex (Talk | contribs) ← Older edit		Revision as of 01:58, 22 April 2010 (edit) (undo) Alex (Talk | contribs) Newer edit →
Line 25:		Line 25:
	* default: empty		* default: empty
	* meaning: on what date cargo is available for pick up (from Origin Door)		* meaning: on what date cargo is available for pick up (from Origin Door)
		+	* MOT: Truck
	=== Cargo due ===		=== Cargo due ===
Line 31:		Line 32:
	* default: empty		* default: empty
	* meaning: by what date cargo should be delivered (to Destination Door)		* meaning: by what date cargo should be delivered (to Destination Door)
		+	* MOT: Truck
	== Trucking Optimization Report ==		== Trucking Optimization Report ==
Line 96:		Line 98:
	** Weight, lb // Grand ttl for CT		** Weight, lb // Grand ttl for CT
	** CBM // Grand ttl for CT		** CBM // Grand ttl for CT
-	** Cargo available //	+	** Cargo Available // CT field
-	** Cargo due //	+	** Cargo Due // CT field
	* Totals: provided for numerical columns		* Totals: provided for numerical columns
Line 105:		Line 107:
	* Generate option (need by April 23 NY mid day on demo)		* Generate option (need by April 23 NY mid day on demo)
	* Schedule option (need for release)		* Schedule option (need for release)
		+
		+	== Use Cases ==
		+
		+	=== All cargo to one Delivery Location for selected Cargo Due time frame ===
		+
		+	See [[Figure 1]]

---

Revision as of 01:58, 22 April 2010

Contents 1 Intro 2 Due dates 3 Demo Server Data 4 Create additional fields 4.1 Cargo available 4.2 Cargo due 5 Trucking Optimization Report 5.1 Hard coded conditions 5.2 Filters 5.3 Output 5.4 Schedule vs Generate 6 Use Cases 6.1 All cargo to one Delivery Location for selected Cargo Due time frame

Intro

Testing on Demo server today revealed that we are missing critical Report that needs to be demonstrated to Client on Monday.

This report (#Trucking Optimization Report) is defined below along with required additional fields.

Please postpone all other work to produce this missing Report/components ASAP. See more below.

Due dates

• Ideally: April 23 NY mid day on Demo server
• Worst case: April 26 NY morning on Demo server

Demo Server Data

In order to have meaningful functionality test in NY on Demo server we need more or less latest data from staging (especially Addressbook).

Create additional fields

Cargo available

• widget: datebox
• location: Gen Tab
• default: empty
• meaning: on what date cargo is available for pick up (from Origin Door)
• MOT: Truck

Cargo due

• widget: datebox
• location: Gen Tab
• default: empty
• meaning: by what date cargo should be delivered (to Destination Door)
• MOT: Truck

Trucking Optimization Report

Hard coded conditions

None. (All CTs should be captured)

Filters

For April 23 NY mid day:

• Client Company // single select // match against CT#E0_Client OR CT#E1_Client OR CT#E2_Client OR CT#E3_Client
• CT#MOT // single select // only choice of Truck Domestic for May 1; add 2 more trucking modes after

• #Cargo Due
• #Cargo Available

• CT#Pick Up (Company - city - note) // single select
  • populate list with all unique Address_bo#Company_City_Remark fields existing currently in DB where Address#Category equals to Address#ExportPickUpLocation
• CT#Pick Up (city) // single select
  • populate list with all unique Address#City fields existing currently in DB where Address#Category equals to Address#ExportPickUpLocation
• CT#Pick Up (state) // single select
  • populate list with all unique Address#State fields existing currently in DB where Address#Category equals to Address#ExportPickUpLocation

Developer's Note:
-----------------
To simplify you can instead show a list of all US states

• CT#Delivery To (Company - city - note) // single select
  • populate list with all unique Address_bo#Company_City_Remark fields existing currently in DB where Address#Category equals to Address#ExportDeliveryLocation
• CT#Delivery To (city) // single select
  • populate list with all unique Address#City fields existing currently in DB where Address#Category equals to Address#ExportDeliveryLocation
• CT#Delivery To (state) // single select
  • populate list with all unique Address#State fields existing currently in DB where Address#Category equals to Address#ExportDeliveryLocation

Developer's Note:
-----------------
To simplify you can instead show a list of all US states

For May 1 release:

• Remaining Virtual Group Filters (not confirmed!)

Output

• media: xls only

• Sort by: Cargo due, earliest on the top

• Tabs: each tab per State (from Pick Up Location)

• Fields (left to right)
  • label on xls // mapping explained
  • CT# //
  • Pick Up Location // Pick Up Location Company
  • P City // Pick Up Location City
  • P State // Pick Up Location State
  • Delivery Location // Delivery Location Company
  • D City // Delivery Location City
  • D State // Delivery Location State
  • HU // Grand ttl for CT
  • Weight, lb // Grand ttl for CT
  • CBM // Grand ttl for CT
  • Cargo Available // CT field
  • Cargo Due // CT field

• Totals: provided for numerical columns

Schedule vs Generate

• Generate option (need by April 23 NY mid day on demo)
• Schedule option (need for release)

Use Cases

All cargo to one Delivery Location for selected Cargo Due time frame

See Figure 1