Truck Detailed Manifest

From UG

Revision as of 19:35, 16 April 2010 by Montira (Talk | contribs)
Jump to: navigation, search


Contents

Mantis

Parent: 1906

Task: 1916

Business Needs and Requirements

User would like to be able to generate a report that shows result of truck detailed manifest. The result will show detail per CT from Elizabeth Arden Trucking for virtual group with content information by trailers.

Technical Specification

Summary

  • This report is a spreadsheet report for Totals of virtual group for Truck move. It has one panel which displays a table of contents totals that is grouped per CT.
  • This report can be generated from Generate Document option Step 3 then select option Manifest from Drop down Menu

User Interface

Hard Coded Conditions

  • This report is used to identify content of shipments for ALL trailers in a virtual group
  • Display result CTs that are grouped by trailer#. This can be either PT# or DT# but not both, depending on user selected
  • One trailer per section; many CTs can be assigned to one trailer
  • Same CT# will never be assigned to many PTs#
  • Same CT# will never be assigned to many DTs#
  • Same CT# can be assigned to both PT# and DT# at the same time

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.
  • User can define the result of detail manifest to group by Pick up trailer or Delivery trailer
  • Default value is "PT" which spreadsheet will show shipment records with content that are grouped by Pick-up trailer

Steps

  • Define Virtual group using classifiers
  • Generate Document
  • Select Manifest and click show template
  • Result displays as READ ONLY on HTML view
  • Select option to display Pkg(s) Type/unit(s) radio button -> optional (default to "No")
  • Select option to group manifest by pick up trailer/ delivery trailer radio button -> optional (default to "PT")
  • Click "Download To Spreadsheet" Button

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

  • Trucker Name:
  • Reference:

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

Columns Definitions

Section 1

  • Trucker Name:
  • Mapped to none
  • Default to blank
  • Reference:
  • Mapped to none
  • Default to blank

Section 2

  • Shipper/Consignee
  • CT#
  • 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. Total CBM shows N/A

Sort By Definitions

  • Earlier Container# to latest Container# (Ascending order)

Special Cases

USE CASE 1

CT#   PT#   DT#
CT1    1     1
CT2    1     1
CT3    1     1

File:Usecase1.JPG

USE CASE 2

CT#  PT#  DT#
CT1   1    3
CT2   1    4
CT3   2    3

File:Usecase2.JPG

USE CASE 3

CT#  PT#  DT#
CT1   1    4
CT2   1    5
CT3   2    6
CT4   3    3

File:Usecase3.JPG

Figures

Figure 1. Manifest View and Download To Spreadsheet button

File:TruckManifestView.JPG

Figure 2. Spreadsheet result USE CASE 1 view

File:TruckDetailedManifest.JPG

History

RFC

History

Personal tools