CT Records Report

(Difference between revisions)

Revision as of 17:30, 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 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.

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.

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 23: / Line 23: @@
 ==== Filters ====
-All filters for user defined report conditions are on one tab - see [[#Figure 2. General Tab ]]
-Also see [[#Filters and Filters Matching Logic]].
+See [[#Filters and Filters Matching Logic]].
 === Hard Coded Conditions ===