Air Detailed Manifest (M) (xls)

From UG

Contents 1 Mantis 2 Business Needs and Requirements 3 Technical Specification 3.1 Summary 3.2 User Interface 3.3 Hard Coded Conditions 3.4 User Defined Conditions 3.5 Steps 3.6 Output 3.6.1 Columns Definitions 3.6.2 Sort By Definitions 3.7 Special Cases 4 Figures 4.1 Figure 1. Download To Spreadsheet button 4.2 Figure 2. Spreadsheet result view 5 History 6 RFC 7 History 7.1 Implement this new feature

Mantis

Parent: 1583

Task: 1531

Business Needs and Requirements

User would like to be able to generate a report that shows result of air detailed manifest. The result will show detail per CT with content information

Technical Specification

Summary

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

User Interface

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

Hard Coded Conditions

• This report is used to identify ALL CT records in a Master
• Display result

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.

Steps

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

Output

• Output is an Excel spreadsheet
• There is ONLY one tab on spreadsheet
• Result shows 1 CT 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:
• Flight Number:
• Airline:

Section 2

• Shipper/Consignee
• HAWB
• CT#
• PO Num
• SKU
• Qty
• Ttl# plt
• Ttl pkgs on plts
• Type (Optional)
• Loose pkgs
• Type (Optional)
• Ttl G kg
• CBM
• Footer
  • There is no footer
• Show output heading for each CT
• Each CT result is separated by 1 row

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:

• Flight Number:

• Mapped to Master Details.Flight One #:

• Airline:

• Mapped to Master Details.Airline:

Section 2

• Shipper/Consignee

• Mapped to Ct#Shipper
• Mapped to Ct#Consignee

• HAWB

• Mapped to Ct#HAWB

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

Sort By Definitions

• Earlier CT# to latest CT#

Special Cases

Figures

Figure 1. Download To Spreadsheet button

Figure 2. Spreadsheet result view

History

RFC

• This report may be moved to Misc tab, still need an approval, since this report has no template. Right now just leave on Master Air Total

History

Implement this new feature

• ver 1.0
• http://mantis.jaguarfreight.com/mantis/view.php?id=1531