In Transit Report

From UG

(Difference between revisions)

Revision as of 21:26, 5 December 2009

Parent Mantis

Business Needs and Requirements

This report is used to identify those shipments that already "considered on the move" but "considered not yet delivered". Of course we can find out about that based on dates we store for shipment.

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 it is defined how user can control output and in what form it is presented to the user

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

see FCL vs Truck-Ocean

Note about Archived CTs

They are not included into this Report

User Defined Conditions

These are also called filters.

s1 Filters are selected by user
s2 In front of each filter there is a checkbox. If checked then this filter must be applied.
s3 All filters are multiselect
s4 Air only filters:
- Airport(s) of departure
- Airport(s) of destination
s5 Ocean only filters:
- ~~port(s)~~ Terminals of departure
- ~~port(s)~~ Terminals of destination
s6 Other filters (any MOT):
- 1 Client
- 2 Origin Country
- 3 Destination Country
- 4 Origin Region
- 5 Destination Region
s7 Display PO Numbers on report results
s8 [new] MOT filter - controls for what MOT to run this report --Alex 22:54, 30 June 2009 (UTC)

Output

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

History

Ver 0

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.

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

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

Rel 2.0 Complete change of report conditions

In this version all hard coded conditions has been completely changed

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)--

@@ Line 50: / Line 50: @@
 ==== Note About Containers ====
-* see [[Containers_and_Contents_Component#FCL_.2F_LCL_vs_Ocean-Truck]]
+* see [[Containers_and_Contents_Component#FCL_.2F_LCL_vs_Ocean-Truck| FCL vs Truck-Ocean ]]
 ==== Note about Archived CTs ====