Acc Reports CTs With No Inv

From UG

Revision as of 06:11, 11 April 2010 (edit) Alex (Talk | contribs) (→Figures) ← Older edit		Revision as of 06:59, 11 April 2010 (edit) (undo) Alex (Talk | contribs) (→Biz Req) Newer edit →
Line 3:		Line 3:
	== Biz Req ==		== Biz Req ==
-	We need to find all CTs with 0 invoices created (sales inv) or 0 lines posted against CT in any PI in the system.	+
		+	CT should appear on this report if at least one condition is satisfied:
		+
		+	* CT is '''billed''' - see [[Billed CT Status]] OR
		+	* 0 lines posted against CT in any PI in the system
	== Filters ==		== Filters ==

---

Revision as of 06:59, 11 April 2010

Contents 1 Biz Req 2 Filters 3 Button 4 Output 5 Excel format 6 Figures 6.1 Figure 1 7 History 7.1 m1894

Biz Req

CT should appear on this report if at least one condition is satisfied:

• CT is billed - see Billed CT Status OR
• 0 lines posted against CT in any PI in the system

Filters

• Invoice Type: PI / SI radio button
• CT Created on Date: from / to date calendar

• NOTE: CT Created on Date: = GenTab.17. Notification Date:
• NOTE: if both dates empty it means do not apply any date filter (no restriction on dates)

Button

• Go back > go back to the previous page
• Reset Form > clear all filter
• Generate Result > HTML result(s) with CT#links and paging
  • Go back > go back to the previous page
  • Download to Excel > Excel report with CT# links

Output

2 columns:

• CT (link)
• Client

With paging.

With download to xls.

Excel format

Same as HTML (ZUL)

Figures

Figure 1

History

m1894