Truck Detailed Manifest
From UG
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
- See #Figure 1. Manifest View and Download To Spreadsheet button
- See #Figure 2. Spreadsheet result view
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
- 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. 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
USE CASE 2
CT# PT# DT# CT1 1 3 CT2 1 4 CT3 2 3
USE CASE 3
CT# PT# DT# CT1 1 4 CT2 1 5 CT3 2 6 CT4 3 3
Figures
Figure 1. Manifest View and Download To Spreadsheet button
Figure 2. Spreadsheet result USE CASE 1 view
