Daily Report - Elizabeth Arden

From UG

(Difference between revisions)
Jump to: navigation, search
(Filters and Filters Matching Logic)
(Columns Definitions)
Line 72: Line 72:
** If user is client, CT# hyperlinks are link to view shipment page under client interface> shipment detail.
** If user is client, CT# hyperlinks are link to view shipment page under client interface> shipment detail.
** If user is internal user(JG users), CT# hyperlinks are linked to view shipment page in Internal interface.  
** If user is internal user(JG users), CT# hyperlinks are linked to view shipment page in Internal interface.  
-
** Default on the ''combo box''
+
** Default on the ''combo box'' selected list
* Vendor
* Vendor
** Mapped to [[CT#Shipper]]
** Mapped to [[CT#Shipper]]
-
** Default on the ''combo box''
+
** Default on the ''combo box'' selected heading output list
* Division
* Division
** No mapping (Heading Only)
** No mapping (Heading Only)
** Default value: N/A for data
** Default value: N/A for data
-
** Default on the ''combo box''
+
** Default on the ''combo box'' selected heading output list
* P/O num
* P/O num
** Mapped to [[Commodity#PO]]
** Mapped to [[Commodity#PO]]
-
** Default on the ''combo box''
+
** Default on the ''combo box'' selected heading output list
* Item code
* Item code
** Mapped to [[Commodity#SKU]]
** Mapped to [[Commodity#SKU]]
-
** Default on the ''combo box''
+
** Default on the ''combo box'' selected heading output list
* Quantity
* Quantity
** Mapped to [[Commodity#Qty]]
** Mapped to [[Commodity#Qty]]
-
** Default on the ''combo box''
+
** Default on the ''combo box'' selected heading output list
* Weight
* Weight
** Mapped to [[Commodity#Gross Kg]]
** Mapped to [[Commodity#Gross Kg]]
-
** Default on the ''combo box''
+
** Default on the ''combo box'' selected heading output list
* Cartons
* Cartons
** Mapped to [[Commodity#Pkgs On Plts]]
** Mapped to [[Commodity#Pkgs On Plts]]
-
** Default on the ''combo box''
+
** Default on the ''combo box'' selected heading output list
* Pallets
* Pallets
** Mapped to [[Commodity#Plts]]
** Mapped to [[Commodity#Plts]]
-
** Default on the ''combo box''
+
** Default on the ''combo box'' selected heading output list
* Drums
* Drums
** Mapped to [[Commodity#Loose Pkgs]]
** Mapped to [[Commodity#Loose Pkgs]]
-
** Default on the ''combo box''
+
** Default on the ''combo box'' selected heading output list
* Carrier
* Carrier
** No mapping (Heading Only)
** No mapping (Heading Only)
** Default value: Jaguar
** Default value: Jaguar
-
** Default on the ''combo box''
+
** Default on the ''combo box'' selected heading output list
* Mode
* Mode
** Mapped to [[CT#Mode Of Transport]]
** Mapped to [[CT#Mode Of Transport]]
-
** Default on the ''combo box''
+
** Default on the ''combo box'' selected heading output list
* Carrier Remarks
* Carrier Remarks
** No mapping (Heading Only)
** No mapping (Heading Only)
** Default value to blank
** Default value to blank
-
** Default on the ''combo box''
+
** Default on the ''combo box'' selected heading output list
* Destination
* Destination
** Mapped to [[CT#Consignee]]
** Mapped to [[CT#Consignee]]
-
** Default on the ''combo box''
+
** Default on the ''combo box'' selected heading output list
* Estimated Delivery
* Estimated Delivery
** Mapped to [[CT#Automated Estimated Delivery Date]]
** Mapped to [[CT#Automated Estimated Delivery Date]]
-
** Default on the ''combo box''
+
** Default on the ''combo box'' selected heading output list
* Actual Delivery
* Actual Delivery
** Mapped to [[CT#Actual Delivery Date]]
** Mapped to [[CT#Actual Delivery Date]]
-
** Default on the ''combo box''
+
** Default on the ''combo box'' selected heading output list
* Revise Date
* Revise Date
** No mapping (Heading Only)
** No mapping (Heading Only)
** Default value to blank
** Default value to blank
-
** Default on the ''combo box''
+
** Default on the ''combo box'' selected heading output list
* Remarks Planning
* Remarks Planning
** No mapping (Heading Only)
** No mapping (Heading Only)
** Default value to blank
** Default value to blank
-
** Default on the ''combo box''
+
** Default on the ''combo box'' selected heading output list
* Customer References#  
* Customer References#  
Line 161: Line 161:
* Custom fields  
* Custom fields  
** if E0 client has "custom fields" that is/are set in admin mode, these should be available list as well
** if E0 client has "custom fields" that is/are set in admin mode, these should be available list as well
-
** Heading Must be dynamic name
+
** Heading on output tab should be Extra 1, Extra 2,...etc
-
*** For example: if there is a custom field "Extra line 1 = Lot#", it MUST show "Lot#" instead of "Extra line 1"
+
** Heading Must be dynamic name on the spreadsheet
 +
*** For example: if there is a custom field "Extra 1 = Lot#", it MUST show "Lot#" instead of "Extra line 1" on the spreadsheet
* Total CBM  
* Total CBM  

Revision as of 17:33, 17 February 2010


Contents

Parent Mantis

1722

Business Needs and Requirements

  • This report is used to identify new shipments (CT's) created in the system since the last time the instance of this report run.
  • This is a specific request report for Elizabeth Arden only. (It is assumed that user would select Arden related Clients in Client filter. But actually they could select any client)

Technical Specification

Summary

  • This report should appear only in Saved/Scheduled Reports section (to run this report you have to schedule it).
  • Report shows date time stamp and how many records are found (number)
  • This report is almost similar to Daily Report, but the heading on the spreadsheet is different also with the extra fields

User Interface

See #Figure 1. Schedule dropdown menu

Filters

All filters for user defined report conditions are on one tab - see #Figure 2. General Tab

Also see #Filters and Filters Matching Logic.


Hard Coded Conditions

  • This report is used to identify new shipments (CT's) created in the system since the last time the instance of this report run.

User Defined Conditions

  • See Figure 2 for general filters tab below
  • All filters are "multi select"
  • Check box in front of each filter. If filter is set, check box MUST be automatically checked vise versa
  • Filters consist of several groups
  • Every filter is connected by AND and sub selections inside each filter combo-box are connected by OR
    • For example: ((Client Companies = E.A. USA Domestic) OR(Client Companies = Elizabeth Arden)) AND ((Shippers = A-TESTCOMP - TestCity - test remark)OR(Shippers = ABC - HK - test))
  • If none of the filters are selected, generate ALL results.

Filters and Filters Matching Logic

  • Reports Filters#Client
    • This is a mandatory filter
    • Allow user to select max to 10 client companies
    • If user does not set this filter; leave it blank then clicks "Ok", warning error message pop-up displays "Please set Client Companies filter"
    • If user selects some client companies filter more than 10 client companies then clicks "Ok", warning error message pop-up displays "List of Client companies can be selected less than or equal 10 client companies."

Output

  • Create output tab with list of output headings
  • These output headings are almost the same as Daily Report but label name and order differently
  • Required default headings on the combo box, the rest of headings are in drop down filter output list
  • List of headings #Columns Definitions

Columns Definitions

  • CT# with link (JG and Non-JG users)
    • Mapped to CT#CT Num
    • If user is client, CT# hyperlinks are link to view shipment page under client interface> shipment detail.
    • If user is internal user(JG users), CT# hyperlinks are linked to view shipment page in Internal interface.
    • Default on the combo box selected list
  • Vendor
    • Mapped to CT#Shipper
    • Default on the combo box selected heading output list
  • Division
    • No mapping (Heading Only)
    • Default value: N/A for data
    • Default on the combo box selected heading output list
  • P/O num
    • Mapped to Commodity#PO
    • Default on the combo box selected heading output list
  • Item code
    • Mapped to Commodity#SKU
    • Default on the combo box selected heading output list
  • Quantity
    • Mapped to Commodity#Qty
    • Default on the combo box selected heading output list
  • Weight
  • Pallets
    • Mapped to Commodity#Plts
    • Default on the combo box selected heading output list
  • Carrier
    • No mapping (Heading Only)
    • Default value: Jaguar
    • Default on the combo box selected heading output list
  • Carrier Remarks
    • No mapping (Heading Only)
    • Default value to blank
    • Default on the combo box selected heading output list
  • Destination
    • Mapped to CT#Consignee
    • Default on the combo box selected heading output list
  • Revise Date
    • No mapping (Heading Only)
    • Default value to blank
    • Default on the combo box selected heading output list
  • Remarks Planning
    • No mapping (Heading Only)
    • Default value to blank
    • Default on the combo box selected heading output list
  • Custom fields
    • if E0 client has "custom fields" that is/are set in admin mode, these should be available list as well
    • Heading on output tab should be Extra 1, Extra 2,...etc
    • Heading Must be dynamic name on the spreadsheet
      • For example: if there is a custom field "Extra 1 = Lot#", it MUST show "Lot#" instead of "Extra line 1" on the spreadsheet
  • Authorization
    • No mapping (Heading Only)
    • Default value to blank
    • this field is allowed user to manage it manually [Y/N]

Sort By Definitions

  • Sort by CT# from earlier CT# to newer CT#

Summary

  • Output is a spreadsheet
  • Spreadsheet tabs: There is ONLY one tab
  • Spreadsheet consists of Header, Body, and footer
  • Header:
    • Report name
    • Date Time Stamp
    • Criteria (list of filter(s) selected)
    • Jaguar Logo
  • Body: (general info)
    • Consists of columns and rows
      • Column: headings
      • Row: shipment records
  • Footer
    • There is no footer

Special Cases

TBD

Figures

Figure 1. Schedule dropdown menu

File:DailyEA.JPG

Figure 2. General Tab

File:GeneralTabDailyEA.JPG

History

RFC

Personal tools