CT Records Report

(Difference between revisions)

Revision as of 17:47, 26 February 2010

This report should appear on Saved/Scheduled Reports section (to run this report you have to schedule it).
This report should appear Acc > Reports > CT Records Per Office.
Report shows date time stamp and how many records are found (number)per mode and per office

From Scheduled Reports

See #Figure 1. CT Records Per Office (Schedule Menu)

From Acc Reports

See #Figure 4. Filters and Buttons

This report is used to identify how many shipments (CT's) has been created in the system by specific office during a given time frame (???Still need to know how to generate per schedule? all from the beginning to present OR from the last report
Report should use CT#Created On Date date field to identify when shipment was created.

See Figure 2 for general filters tab below
Date filter is from Date to Date calendar
Office filter is "multi select"
Office selected filters are connected by OR condition
- For example: ((Office = New York) OR (Office = London))
Check box in front of each filter. If filter is set, check box MUST be automatically checked vise versa
If none of the filters are selected, generate ALL results.

Figure 1. CT Records Per Office (Schedule Menu)

Figure 2. General Filters Tab

Figure 3. Output Tab

Figure 4. Filters and Buttons

Figure 5. SpreadSheet

@@ Line 44: / Line 44: @@
 ==== Filters and Filters Matching Logic ====
+* Date: From [[Ct#Created_On_Date]] To [[Ct#Created_On_Date]]
 * [[Office#City]]
-** 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."
-* [[Reports Filters#Shipper]]
-* [[Reports Filters#Consignee]]
-* [[Reports Filters#Origin Country]]
-* [[Reports Filters#Destination Country]]
-* [[Reports Filters#Origin Region]]
-* [[Reports Filters#Destination Region]]