Trucking Optimization Report

From UG

(Difference between revisions)
Jump to: navigation, search
Alex (Talk | contribs)
(Created page with 'Category:New Arden Trucking Project Sorry, there was a disconnect and testing on Demo server today revealed that we are missing very important Report that needs to be demon…')
Newer edit →

Revision as of 01:48, 22 April 2010


Sorry, there was a disconnect and testing on Demo server today revealed that we are missing very important 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.

Contents

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)
Cargo due
  • widget: datebox
  • location: Gen Tab
  • default: empty
  • meaning: by what date cargo should be delivered (to Destination Door)

Trucking Optimization Report

Hard coded conditions

None. (All CTs should be captured)

Filters

For April 23 NY mid day:


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


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 //
    • Cargo due //
  • Totals: provided for numerical columns
Schedule vs Generate
  • Generate option (need by April 23 NY mid day on demo)
  • Schedule option (need for release)
Personal tools