In Transit Report

From UG

(Difference between revisions)
Jump to: navigation, search
(User Interface)
(User Interface)
Line 22: Line 22:
** '''Generate Report BUTTON''' - to generate report
** '''Generate Report BUTTON''' - to generate report
** '''Reset Form BUTTON''' - to clear form on both tabs
** '''Reset Form BUTTON''' - to clear form on both tabs
-
* See ''In Tansit UI for User Defined Conditions.JPG'' and ''File:In_Tansit_Output_Tab.JPG''.
+
* See [[Media:In Tansit UI for User Defined Conditions.JPG]] and ''File:In_Tansit_Output_Tab.JPG''.
=== Hard Coded Conditions ===
=== Hard Coded Conditions ===

Revision as of 22:57, 5 December 2009

In Tansit UI for User Defined Conditions.JPG


Contents

Business Needs and Requirements

This report is used to identify those shipments that already "considered on the move" but "considered not yet delivered".

Technical Specification

Summary

  • Input for this report is a list of all CTs in the system.
  • To appear on the report CT must satisfy Hard Coded Conditions and User Defined Conditions .
  • In Output section of this specification it is defined how user can control output and in what form it is presented to the user

User Interface

  • In order to generate report user have to:
    • configure "user defined conditions" (select desired Client Company for example) and
    • configure "output" (Select Shipper CT field to appear on the generated table)
  • All settings are grouped in two tabs:
    • Filters
    • Output
  • Action controls:
    • Generate Report BUTTON - to generate report
    • Reset Form BUTTON - to clear form on both tabs
  • See Media:In Tansit UI for User Defined Conditions.JPG and File:In_Tansit_Output_Tab.JPG.

Hard Coded Conditions

For CT to appear on this report it must satisfy all conditions below:

  • CT does not have Deleted status AND
  • Additional conditions are mode specific - see below:

MOT = Air

  • ExpTab.Master Airway bill "is not empty" AND
  • ImpTab.Actual Delivery Date "is empty" or today's date or yesterday's date

MOT = LCL/Client Consol

  • CT has at least one container AND
  • Container# field "is not empty" for one or more containers on ContTab.ContainersTable AND
  • ImpTab.Actual Delivery Date "is empty" or today's date or yesterday's date


MOT = FCL and MOT = Truck-Ocn

  • CT has at least one container AND
  • Container# field "is not empty" for one or more containers on ContTab.ContainersTable AND
  • ContTab.ContainersTable.ContainerX.Actual Delivery Date "is empty" or today's date or yesterday's date for all for one or more containers


MOT = Truck-Dom

  • GenTab.Estimated Export Pick-Up Date "is not empty" AND
  • ImpTab.Actual Delivery Date "is empty" or today's date or yesterday's date

MOT = Truck-Air

  • GenTab.Estimated Export Pick-Up Date "is not empty" AND
  • ImpTab.Actual Delivery Date "is empty" or today's date or yesterday's date


Note About Containers

Note about Archived CTs

They are not included into this Report

User Defined Conditions

These are also called filters.

General functionality

  • See In Tansit UI for User Defined Conditions.JPG
  • All filters are located on "Filters" tab
  • There is a check box in front of every filter. Filter is applied only when checked
  • all filters are "multiselect"
  • Filters consists of several groups

Non-specific to MOT group of filters

    • 1 Client (List is from Admin > Client Companies; Mapped to: CT, Gen Tab, E0. Client field)
    • 2 Origin Country (List is from Admin > Geography > Countries; Mapped to: CT, Gen Tab, Origin country field)
    • 3 Destination Country (List is from Admin > Geography > Countries; Mapped to: CT, Gen Tab, Destination country field)
    • 4 Origin Region
    • 5 Destination Region


Air filters

    • Airport(s) of departure
    • Airport(s) of destination
  • s5 Ocean only filters:
    • port(s) Terminals of departure
    • port(s) Terminals of destination

Output setting

  • "Display PO" numbers on report results checkbox
  • MOT checkbox - controls for what MOT to run this report. Options are:
    • AIR
    • OCEAN
    • TRUCKING

Output

File:In Tansit Output Tab.JPG
  • s1 Is in the form of Excel file
  • s2 It consists of 4 sections (one per MOT). Each has same design
  • s3 Each section is a table with the following columns
    • CT #
    • Shipper
    • Consignee
    • Quantity,
      • new start: depends on the MOT:
        • if FCL, then show number of containers (example: "5 containers")
        • if LCL, then show Volume ("23 cbm")
        • if AIR, then show Chargeable Weight ("200 kg")
        • if TRUCK, then show Gross Weight ("200 kg")
      • new end --Alex 23:05, 7 July 2009 (UTC)
    • from country
    • to country
    • estimated/actual departure
    • estimated/actual arrival
    • PO (show only first PO, show PO++ if more than one PO exists)
  • s4 sort by: estimated/actual arrival, to country, qty
  • s5 For MOT=Air, Truck each line represents one CT
  • s6 For MOT=FCL, LCL each line represents:
    • One CT only if that CT does not have Master
    • If CT has a Master then:
      • each line in the table above represent one master
      • ANY CT from that master is shown in a dropdown
      • all fields displayed are fields for THAT CT (except Quantity that always shows value for entire Master)
      • if user selects another CT then all fields are re-freshed
  • s7 [View] button opens CT record
  • s8 For departure and arrival columns: Show estimated value if actual value is not set

Development QA and History of Changes

Link to Parent Mantis

m#928(In Transit)

Ver 0

Ver 1

See In Transit Report ARC

Tweaks V.1.1.a

Note: Feed back added from meeting on Oct1,2009

tw1) Add output tab for user in order to manage his report result. Heading consists of:

  • CT#
  • Shipper
  • Consignee
  • Quantity
  • Departure
  • Destination
  • Departure Date
  • Arrival Date
  • P.O.

No update to TS

Tweaks V.1.1 b

tw1) Update filter names as below

  • From Countries -> Origin Countries
  • To Countries -> Destination Countries
  • From Regions -> Origin Regions
  • To Regions -> Destination Regions
  • From Airports -> Origin Airports
  • To Airports -> Destination Airports
  • From Ports/Terminals -> Origin Ports/Terminals
  • To Ports/Terminals -> Destination Ports/Terminals

No update to TS

Tweaks version 1.1.a

Note: Tira 9:50 28 Oct 2009

tw1) Add summary shipment record() count on the report to indicate that how many shipments...

tw2) Create a HTML result page before excel report

tw3) Create download to excel button -> generate xls report

No update to TS

Rel 2.0 Complete change of report conditions

  • In this version all hard coded conditions has been completely changed.

No update to TS

Dec 5 Spec major cleanup

  • TS has been updated
  • Ver 1.0 has been archived

--Alex 21:31, 5 December 2009 (UTC)

RFC

1.need to exact order and form of sorting rules (include sorting rules by date for masters)--Andrei 09:51, 23 July 2009 (UTC)--

Personal tools