Daily Report - Elizabeth Arden

From UG

(Difference between revisions)
Jump to: navigation, search
(Figures)
(User Defined Conditions)
Line 27: Line 27:
* Filters consist of several groups
* Filters consist of several groups
* Every filter is connected by '''AND''' and sub selections inside each filter combo-box are connected by '''OR'''
* 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.
* If none of the filters are selected, generate ALL results.
==== Filters ====
==== Filters ====

Revision as of 22:21, 29 January 2010


Contents

Parent Mantis

1722

Business Needs and Requirements

This report is used to identify new shipments for the last 24 hours. This is a specific request report for Elizabeth Arden only.

Technical Specification

Summary

  • The result of this report is a number of CTs in the system that is generated daily for the last 24 hours or every date and time that user manages to send the report to Clients via email.
  • Report MUST include ALL records that are created since previous report
  • This report can be managed through the saved and Scheduled report for class report dropdown and set the satisfied filters
  • Report is a "re-occurring" report (not a one time report)
  • Report is based on Client Companies(E0)
  • 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

Hard Coded Conditions

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

  • Client Companies (E0 Client)
  • Shippers:
  • Consignees:
  • Origin Countries:
  • Destination Countries:
  • Origin Regions:
  • Destination Regions:

Output

Columns Definitions

Sort By Definitions

Special Cases

Figures

Figure 1. Schedule dropdown menu

File:DailyEA.JPG

Figure 2. General Tab

File:GeneralTabDailyEA.JPG

History

RFC

Personal tools