Arrival Notice

From UG

Revision as of 05:41, 17 May 2013 by Alex (Talk | contribs)
Jump to: navigation, search


Contents

Business Needs and Terminology

The purpose of this document is to notify that shipment is about to arrive.

Notify one or more from the list:

  • Customs Broker (most of the times) [Imp Tab]
    • option 1) this is a "Jaguar broker" (ex: Overton)
    • option 2) this is a "Customer's broker"
      • like in case of Basic Fun
      • then Freight Invoice section (TOC) will be printed
  • Notify Party [Gen Tab]

It is created by operator in Import Department.

There are two types of this documents:

Location

CT profile > Doc Tab

Arrival Notice Ocean

Parent Mantis: 581

Template

As usual document can be pre-viewed and edited through pdf template.

See Example on #Figure 1. Arrival Notice Ocean Template

See field descriptions, mappings, etc below.

Top Section

  • Office Logo
copy of Office#Logo; it is office specific based on user login
  • DOCUMENT ADDRESS
copy of Office#Address; it is office specific based on user login
  • "ARRIVAL NOTICE / FREIGHT INVOICE" line
  • CT #
current CT#; in case of group generate this field contains all selected CTs
  • REFERENCE NO
copy of CT field CT#ImportRef
  • SHIPPER:
copy of CT field CT#Shipper
  • CONSIGNEE:
copy of CT field CT#Consignee
  • NOTIFY:
copy of CT field CT#Notify
  • BROKER:
copy of CT field CT#Customs Broker
  • DATE
displays todays date (user's time zone)
  • Master Bill of Lading:
copy of CT field CT#MBL
  • AMS Bill of Lading:
pre-fill to blank
  • PREPARED BY:
1)first and last name of login User; 2) e-mail associated with login User
  • House Bill of Lading:
copy of CT field CT#HBL
  • SubHouse Bill of Lading:
pre-fill to blank
  • Freight Location:
copy of CT field CT#Cargo location
  • RELEASE TYPE
Release Type field should be pulling from CT#Original BL Required Yes No.
When “Yes” is clicked, the Release Type field should display “OB/L Required”.
When “No” is clicked, the Release Type field should display “Express”.
  • PORT OF LOADING
copy of CT field CT#Port Of Loading
  • PORT OF DISCHARGE
copy of CT field CT#Port Of Discharge
  • DESTINATION TERMINAL
copy of CT field CT#Destination Terminal
  • Vessel/Voyage
merge of values of two fields:
copy of CT field CT#Vessel Name
copy of CT field CT#Voyage Num
  • ETD:
copy of CT field CT#Port Of Loading Estimated Date
  • Discharge Date
copy of CT field CT#Port Of Discharge Estimated Date
  • Destination Date
copy of CT field CT#Destination Terminal Estimated Date
  • IT#
copy of CT field CT#IT
  • IT Date
copy of CT field CT#IT Date
  • IT Location
copy of CT field CT#IT Location
  • PO Numbers:
all PO's from ContTab.TableA; in case of group generate this field contains all PO's from all selected CTs

Commodity Table Section

See Ocean Docs Commodity Table (feature)

Bottom Section

When “Yes” is clicked, REMARKS should be pre-filled with
PLEASE SEND CHASHIER'S CHECK, MONEY ORDER, OR BROKER CHECK PAYABLE TO JAGUARFREIGHT SERVICE; FREIGHT CAN ONLY BE RELEASED UPON RECEIPT OF CHARGES SHOWN
PRIOR TO CARGO PICK-UP, CONSIGNEE MUST CLEAR CUSTOMS AND CONFIRM FREIGHT RELEASE WITH PIER/CFS. PLEASE PICK UP YOUR CARGO UPON RELEASE IN ORDER TO AVOID UNNECESARY CHARGES
When “No” is clicked, REMARKS should be pre-filled with
PRIOR TO CARGO PICK-UP, CONSIGNEE MUST CLEAR CUSTOMS AND CONFIRM FREIGHT RELEASE WITH PIER/CFS. PLEASE PICK UP YOUR CARGO UPON RELEASE IN ORDER TO AVOID UNNECESSARY CHARGES
  • generate report button

Pdf

See Examples on #Figure 2. Arrival Notice Ocean Pdf and #Figure 3. Arrival Notice Ocean Pdf 2nd Page

Header

  • See section 1 on Figure 2. It is for page one.
Jaguar Logo. Reflects Template Office Logo.
Jaguar Address. Reflects Template DOCUMENT ADDRESS.
Doc Title. "ARRIVAL NOTICE / FREIGHT INVOICE" line.
DATE. Reflects Template DATE.
Page X of Y. X - current page num; Y - total num of pages.

Top Section

  • See section 2 on Figure 2.
Reflects Template Top Section.

Commodity Section

  • See section 3 on Figure 2.
Reflects Template Commodity Table Section.

TOC Section

  • See section 2 on Figure 3.
Print TOC section if TOC checkbox is unchecked.

Bottom Section

  • See section 4 on Figure 2.
Print REMARKS section if REMARKS checkbox is checked.

Footer

  • See section 5 on Figure 2 or section 3 on Figure 3.
Print "PREPARED BY: " + first and last name of login User.

Multipage case

  • Header for pages other than first
  • If there is subsequent page then print "Continued on next page" at the bottom of the page

Figures

Figure 1. Arrival Notice Ocean Template

Figure 2. Arrival Notice Ocean Pdf

File:Arrival Notice Ocean Pdf.JPG

Figure 3. Arrival Notice Ocean Pdf 2nd Page

File:Arrival Notice Ocean Pdf 2nd Page.JPG

Arrival Notice Air

Parent mantis: 565

Template

It has 2 sections: top and bottom.

Template Top Section

ARRIVAL NOTICE / FREIGHT

  • This is a label

CT#:

  • UI type: textbox
  • UI params: tbd
  • UI validation/constraint/overflow: tbd
  • mapping: CT#
  • default: value from current CT
  • group generate case: show as many CTs as can fit; if not all can fit add "++" at the end of the string

REFERENCE NO.:

  • UI type: textbox
  • UI params: tbd
  • UI validation/constraint/overflow: tbd
  • mapping: Gen Tab.Import ref#
  • default: value from current CT
  • group generate case: pull from current CT

SHIPPER:

  • UI type: textarea
  • UI params: tbd
  • UI validation/constraint/overflow: on pdf show up to 7 lines, discard the rest
  • mapping: Gen Tab, Shipper
  • default: value from current CT
  • group generate case: pull from current CT


CONSIGNEE:

  • UI type: textarea
  • UI params: tbd
  • UI validation/constraint/overflow: on pdf show up to 7 lines, discard the rest
  • mapping: Gen Tab, Consignee
  • default: value from current CT
  • group generate case: pull from current CT

NOTIFY:

  • UI type: textarea
  • UI params: tbd
  • UI validation/constraint/overflow: on pdf show up to 7 lines, discard the rest
  • mapping: Gen Tab, Notify
  • default: value from current CT
  • group generate case: pull from current CT


BROKER:

  • UI type:
  • UI params: tbd
  • UI validation/constraint/overflow: on pdf show up to 7 lines, discard the rest
  • mapping: Imp Tab, Customs Broker
  • default: value from current CT
  • group generate case: pull from current CT


Date:

  • UI type: datebox
  • UI params: tbd
  • UI validation/constraint/overflow: tbd
  • mapping: none
  • default: current date from user's PC
  • group generate case: n/a


MAWB:

  • UI type: textbox
  • UI params: tbd
  • UI validation/constraint/overflow: tbd
  • mapping: Exp Tab, Master Airway bill
  • default: value from current CT
  • group generate case: pull from current CT


HAWB:

  • UI type: textbox
  • UI params: tbd
  • UI validation/constraint/overflow: tbd
  • mapping: Exp Tab, HAWB#
  • default: value from current CT
  • group generate case: pull from current CT
  • note:


PREPARED BY:

  • UI type: textbox + textbox
  • UI params: tbd
  • UI validation/constraint/overflow: tbd
  • mapping: textbox 1: First Name and Last Name; textbox 2: email ; based on login user
  • default: current user
  • group generate case: n/a

Bank Release:

  • UI type: textbox
  • UI params: tbd
  • UI validation/constraint/overflow: tbd
  • mapping: none
  • default: blank
  • group generate case: n/a

Flight Number:

  • UI type: textbox
  • UI params: tbd
  • UI validation/constraint/overflow: tbd
  • mapping: Exp Tab, Flight One #
  • default: value from current CT
  • group generate case: pull from current CT


Freight Location:

  • UI type: textarea
  • UI params: tbd
  • UI validation/constraint/overflow: tbd
  • mapping: Imp Tab, Cargo Location
  • default: value from current CT
  • group generate case: pull from current CT


AIRPORT OF LOADING:

  • UI type: textbox
  • UI params: tbd
  • UI validation/constraint/overflow: tbd
  • mapping: Exp Tab, Airport of Departure
  • default: value from current CT
  • group generate case: pull from current CT


AIRPORT OF DISCHARGE:

  • UI type: textbox
  • UI params: tbd
  • UI validation/constraint/overflow: tbd
  • mapping: Exp Tab, Airport of Destination
  • default: value from current CT
  • group generate case: pull from current CT


FINAL DESTINATION:

  • UI type: textbox
  • UI params: tbd
  • UI validation/constraint/overflow: tbd
  • mapping: Imp Tab, Delivery Address (correct ???)
  • default: value from current CT (correct ???)
  • group generate case: pull from current CT


ETD:

  • UI type: datebox
  • UI params: tbd
  • UI validation/constraint/overflow: tbd
  • mapping: Exp Tab, ETD - Est Time of Dept
  • default: value from current CT
  • group generate case: pull from current CT


ETA:

  • UI type: datebox
  • UI params: tbd
  • UI validation/constraint/overflow: tbd
  • mapping: Exp Tab, ETA - Est Time of Arrival
  • default: value from current CT
  • group generate case: pull from current CT


IT number:

  • UI type: textbox
  • UI params: tbd
  • UI validation/constraint/overflow: tbd
  • mapping: Imp Tab, IT#
  • default: value from current CT
  • group generate case: pull from current CT


IT date:

  • UI type: datebox
  • UI params: tbd
  • UI validation/constraint/overflow: tbd
  • mapping: Imp Tab, IT Date
  • default: value from current CT
  • group generate case: pull from current CT


Location:

  • UI type: datebox
  • UI params: tbd
  • UI validation/constraint/overflow: tbd
  • mapping: Imp Tab, IT Location
  • default: value from current CT
  • group generate case: pull from current CT

Template Bottom Section

PO

See #Figure 2: Template Bottom Section , sec 1.

PO numbers:

  • UI type: textbox
  • UI params: tbd
  • UI validation/constraint/overflow: fit as many as possible, add "++" at the end if not all can fit
  • mapping: Cont Tab, Table A, PO numbers from all lines
  • default: value from current CT
  • group generate case: pull from all selected CT's, first from current CT
Commodity table

See #Figure 2: Template Bottom Section , section 2.


Marks and Numbers :

  • UI type: textarea
  • UI params: tbd
  • UI validation/constraint/overflow: none
  • mapping: none
  • default: pre-fill to "Address"
  • group generate case: TBD


Description of Goods and Pkgs :

  • UI type: textarea
  • UI params: tbd
  • UI validation/constraint/overflow: none
  • mapping: Gen Tab, Commodity description
  • default: value from current CT
  • group generate case: TBD


Weight:

  • UI type: textarea
  • UI params: tbd
  • UI validation/constraint/overflow: see Precision
  • mapping: Cont Tab, Table A, GRAND TOTAL: TtlGkg
  • default: value from current CT
  • group generate case: sum of all values for selected CT's


Measurement:

  • UI type: textbox
  • UI params: tbd
  • UI validation/constraint/overflow: see Precision
  • mapping: Cont Tab, Table B, TOTALs: Total (in cbm)
  • default: value from current CT
  • group generate case: sum of all values for selected CT's


PCS:

  • UI type: textbox
  • UI params: tbd
  • UI validation/constraint/overflow: see Precision
  • mapping: Cont Tab, Table A, GRAND TOTAL: Ttl HU
  • default: value from current CT
  • group generate case: sum of all values for selected CT's


Remarks

See #Figure 2: Template Bottom Section , section 3.

It consists of checkbox and textarea. If unchecked - do not print this section.

Remarks (text):

  • UI type: textbox
  • UI params: tbd
  • UI validation/constraint/overflow:
  • mapping: Cont Tab, Table A, GRAND TOTAL: Ttl HU
  • group generate case: set default based on current CT values
  • default: see logic below


IF Imp Tab.Payment of freight charges required prior to release? = N THEN pre-fill:

PRIOR TO CARGO PICK-UP, CONSIGNEE MUST CLEAR CUSTOMS AND CONFIRM FREIGHT RELEASE WITH PIER/CFS. PLEASE PICK UP YOUR CARGO UPON RELEASE IN ORDER TO AVOID UNNECESSARY CHARGES

IF Imp Tab.Payment of freight charges required prior to release? = Y THEN pre-fill:

PLEASE SEND CHASHIER'S CHECK, MONEY ORDER, OR BROKER CHECK PAYABLE TO JAGUARFREIGHT SERVICE; FREIGHT CAN ONLY BE RELEASED UPON RECEIPT OF CHARGES SHOWN

PRIOR TO CARGO PICK-UP, CONSIGNEE MUST CLEAR CUSTOMS AND CONFIRM FREIGHT RELEASE WITH PIER/CFS. PLEASE PICK UP YOUR CARGO UPON RELEASE IN ORDER TO AVOID UNNECESARY CHARGES

Freight Invoice

See #Figure 2: Template Bottom Section , section 4.

This is a separate sub component. See Freight Invoice Section On Arrival Notice.

Pdf

See #Figure 3: Arr Notice Pdf.

Header

See sec 1.

Header for page 2,3, ... is different from Header page 1. See Freight Invoice Section On Arrival Notice

Header for 1-page version consists of:

Jaguar logo

  • it is office specific based on login user

Issued By

  • login user's first name and last name

Document name

Page X of Y

Address

  • Jaguar Office address based on login user


Top Section

See #Figure 3: Arr Notice Pdf, sec 2.

All values come from Template.


Bottom Section

See #Figure 3: Arr Notice Pdf, sec 3.

All values come from Template.

Footer

See #Figure 3: Arr Notice Pdf, sec 4.

First, Last names and email of logged user (from template).

Special case: Groups

See "group generate case:" attribute in fields definition.

Special case: Multiple pages

  • "Continued on next page" should appear at the bottom right of pdf.


Additional Figures

Figure 1: Template Top Section

File:Arrival_Notice_Air_Template_Top_Section.JPG

Figure 2: Template Bottom Section

File:Arrival_Notice_Air_Template_Bottom_Section.JPG

Figure 3: Arr Notice Pdf

File:Arrival_Notice_Air_Pdf.JPG

Known Non Critical Bugs and Issues

  • See all TBD above
  • Prepared By to be standardized
  • Label case to be standardized (template and pdf)
  • Marks and Numbers - should we pull from CT?
  • Measurement or Volume ??? to be standardized
  • Measurement : should we print unit (CBM) ?
  • "Continued on next page" - is this only for this doc or we can make it "generic component"
  • Make labels on pdf and template uniform.


See Also

SOWs

SOW 1 2 3

n/a

SOW 4 Changes to TOC

mantis: 4150

spec:

Estimated Sales Charges should propagate from Est Tab into "Table Of Charges" section on these pdfs:

We already have similar functionality but TOC is copied from Imp Tab which is to be replaced by TOC on Est tab.

There are some changes in functionality - see below:

  • default is Do NOT print
  • do not allow edit lines
  • allow delete lines
  • TOC on pdf should look like new TOC on Sales Inv
  • Let user select only ONE Bill To, populate lines linked to it
  • On Edit load old TOC but show Refresh button
    • if clicked refresh TOC to sync with current state of Est Tab
  • On Generate give warning: "TOC will be refreshed. Are you sure?"

Mock up below shows current state of prototype:

Personal tools