Ocean Detailed Manifest (M) (xls)

From UG

(Difference between revisions)

Current revision as of 15:55, 7 March 2012

[edit] Mantis

Parent: 1582

Task: 1860

[edit] Business Needs and Requirements

User would like to be able to generate a report that shows result of Ocean container detailed manifest. The result will show detail that is grouped CT# by Container with content information

[edit] Technical Specification

[edit] Summary

This report is a spreadsheet report for Totals of Master Ocean. It has one panel which displays a table of contents totals that is grouped per CT.
This report can be generated from Master OCEAN Totals tab

[edit] User Interface

See #Figure 1. Download To Spreadsheet button
See #Figure 2. Spreadsheet result view

[edit] Hard Coded Conditions

This report is used to identify ALL containers in a Master
Display result CTs that are grouped by container#
One container per section; many CTs can be assigned to one container or more.

[edit] User Defined Conditions

User can define the result whether showing type/unit of Ttl pkgs on plts and loose pkgs
Default value is "No" which is not showing types of Ttl pgks on plts and loose pkgs.
- For example: Ttl pkgs on plts is 10 versus 10 cartons.

[edit] Steps

Go to Master shipment
Select Ocean Master
Click "Master Container Totals" Tab
Select option to display Pkg(s) Type(s) radio button -> optional
Click "Download To Spreadsheet" Button

[edit] Output

Output is an Excel spreadsheet
There is ONLY one tab on spreadsheet
Result shows 1 container per section with total numbers for each column
Spreadsheet consists of Header, Body, and Footer
Header
- Report name
- Generated for user's first name and last name of JAGUAR FRIEGHT SERVICES LIMITED by CyberTrax
- Date Time Stamp
Body

Section 1

Master Shipper ref:
Master Consignee ref:
Vessel Name:
Shipping Line:

Section 2

Container#
Shipper/Consignee
CT#
PO Num
SKU
Qty
Ttl# plt
Ttl pkgs on plts
Type (optional)
Loose pkgs
Type (Optional)
Ttl G kg
CBM (Please see Note below under Section 2)
Footer
- There is no footer
Show output heading for each CT
Each CT result is separated by 1 row

[edit] Columns Definitions

Section 1

Master Shipper ref:

Mapped to Master Air field.MasterGeneral.Master Shipper ref:

Master Consignee ref:

Mapped to Master Air field.MasterGeneral.Master Consignee ref:

Vessel Name:

Mapped to Master Details.9a. Vessel Name:

Shipping Line:

Mapped to Master Details.4.Steamshipline:

Section 2

Shipper/Consignee

Mapped to Ct#Shipper
Mapped to Ct#Consignee

CT#

Mapped to Ct#CT Num

PO Num

Mapped to ContTab.TableA.P.O.

SKU

Mapped to ContTab.TableA.SKU

Qty

Mapped to ContTab.TableA.Qty

Ttl# plt

Mapped to ContTab.TableA.Ttl # of plt

Ttl pkgs on plts

Mapped to ContTab.TableA.Ttl pkgs on plts
Mapped to ContTab.TableA.Ttl pkgs on plts >Type
- This is an Option for user to select on the template in order to show the unit of total packages on plts.

Loose pkgs

Mapped to ContTab.TableA.Loose pkgs
Mapped to ContTab.TableA.Loose pkgs >Type
- This is an Option for user to select on the template in order to show the unit of Loose pkgs.

Ttl G kg

Mapped to ContTab.TableA.Ttl G kg

CBM

Mapped to ContTab.TableB.Total (in cbm)
NOTE: one CT has 1 number of cbm, so in this case, display it on every CT even though it is repeated.

[edit] Sort By Definitions

Earlier Container# to latest Container# (Ascending order)

[edit] Special Cases

[edit] SOW 1

Mantis 3456

Core Requirements:

This is a change request for any Ocean masters. Changes for the ocean container manifest and is based upon conditions:

1. MOT = Ocean FCL (AW, MLB) OR Ocean Client Consol

1a. If E0 client is NOT common, add an exception message for when user clicks on "Download to Spreadsheet" option.

Exception message IE: 
One or more CT records in the master has a different E0 client company.  This needs to be corrected before you can download the  
container manifest.

2. E0 client company has Commodity Table Optional Fields (Invoice, Pieces Per Package, Package Type) & Extra Fields (Extra field 1, Extra field 2, Extra field 3) SET inside Admin > Client Companies >> Part E. Commodity Table Management

If CT meets the above criteria, then Add Columns for Optional Fields "Invoice", "Pieces Per Package", "Package Type" & "Extra Fields" to report as follows:

Change Report Header Name from Ocean Detailed Manifest Report to Container Manifest Report

Add commodity table fields "Invoice", "Pieces Per Package", "Package Type" & "Extra Field" "Extra Field" onto the excel file output only.
- Not necessary to add columns to current data grid/view found on the Master Container Totals Tab.

List columns in order on excel output file after CT column:
- Extra Field 1
- Extra Field 2
- Extra Field 3
- Invoice
- P.O.
- SKU
- Qty
- Pkg Type
- Item Description
- Pcs/pkg
- Ttl # of plts
- Ttl pkgs on plts
- Loose pkgs
- Ttl GW

Column Names = same name values set (default name & custom name) that are in that Client Companies >> Part E. Commodity Table Management

Do not add/list columns to report for unchecked Commodity Table Fields

Example: 
CT 373405 has E0 Client Company = Elizabeth Arden 
AND Client Company Elizabeth Arden has Optional Field Invoice set AND Custom Fields - Extra Field 1=Division, 2= Lot #, 3=Blank set 
inside of Part E. Commodity Table Management 
Excel Output (Manifest) should include these 3 Columns, named according to their settings in Part E of their client company profile
AND include their values from the commodity table's settings inside of the CT record - See #Ocean Client Consol Manifest

[edit] Master Container Totals Tab

[edit] Ocean Client Consol Manifest

[edit] FCL Ocean Manifest

[edit] Figures

[edit] Figure 1. Download To Spreadsheet button

[edit] Figure 2. Spreadsheet result view

[edit] History

[edit] RFC

[edit] v 1.1

http://mantis.jaguarfreight.com/mantis/view.php?id=1319

Master Ocean Container Totals Tab must have one panel which displays a table - per container per CT "contents totals" report.

ss1 // add "Download to spreadsheet" feature
ss2 // add "Download to spreadsheet" button to this tab. xls should look like this file: CT1%20manifest_20091007134418.pdf uploaded to http://mantis.jaguarfreight.com/mantis/view.php?id=1319
ss3 // In this file:

Vedor = Shipper
Ignore Drums column
This is per container (example has 1 cont but could be many containers)

(0004851)
alex (administrator) [ private ]
2009-11-12 12:27

1. Jaguar Import Ref - is it ShipperRef?
>>> GenTab.B. Import ref#:

2. Jaguar Export Ref - is it ConsigneeRef?
>>> GenTab.A. Export ref#:

3. Flight Number/Vessel Name - Flight Number is specific for Air Shipment. Not applicable for container's report. Should I just write Vessel Name (Maybe with Voyage number, because it's usefull information)?
>>> OK

4. The same with House Waybill

>>> remove this label/field

5. Shipping Line ref - what is it? I did not found this field in Shipment object.

>>> remove this label/field

6. Lot# - this value is in the Client Specific extra fields of commodity item. On the moment of creating report I can't define what one of the 3 extra fields is contains "Lot" value.

>>> remove this column

[edit] Review against new examples, Move to Doc Tab

v 1.2
http://mantis.jaguarfreight.com/mantis/view.php?id=1584
Detailed spec - TBD