CT Records Report

From UG

Revision as of 17:19, 26 February 2010 (edit) Montira (Talk | contribs) (→User Interface) ← Older edit		Revision as of 17:20, 26 February 2010 (edit) (undo) Montira (Talk | contribs) (→User Interface) Newer edit →
Line 10:		Line 10:
	=== User Interface ===		=== User Interface ===
-	From Scheduled Reports	+	'''From Scheduled Reports'''
	See [[#Figure 1. CT Records Per Office (Schedule Menu) ]]		See [[#Figure 1. CT Records Per Office (Schedule Menu) ]]
Line 18:		Line 18:
	See [[#Figure 3. Output Tab ]]		See [[#Figure 3. Output Tab ]]
-	From Acc Reports	+	'''From Acc Reports'''
	See [[# ]]		See [[# ]]

---

Revision as of 17:20, 26 February 2010

Contents 1 Technical Specification 1.1 Summary 1.2 User Interface 1.2.1 Filters 1.3 Hard Coded Conditions 1.4 User Defined Conditions

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 Acc > Reports > CT Records Per Office.
• Report shows date time stamp and how many records are found (number)per mode and per office

User Interface

From Scheduled Reports

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

See #Figure 2. General Filters Tab

See #Figure 3. Output Tab

From Acc Reports

See #

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.

Figure 1. CT Records Per Office (Schedule Menu)

Figure 2. General Filters Tab

Figure 3. Output Tab

Figure 4. SpreadSheet