CT Records Report

From UG

(Difference between revisions)
Jump to: navigation, search
Line 1: Line 1:
[[Category: CT Records Per Office]]
[[Category: CT Records Per Office]]
 +
 +
 +
== Technical Specification ==
 +
=== Summary ===
 +
 +
* This report should appear on Saved/Scheduled Reports section (to run this report you have to schedule it).
 +
* This report should appear on 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.
 +
 +
* Report should use [[CT#Created On Date]] date field to identify when shipment was created.
 +
 +
=== 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.

Revision as of 16:24, 26 February 2010


Contents

Technical Specification

Summary

  • This report should appear on Saved/Scheduled Reports section (to run this report you have to schedule it).
  • This report should appear on 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.
Personal tools