Acc Reports CTs With No Inv

From UG

Revision as of 16:35, 1 September 2009 (edit) Alex (Talk | contribs) (→Filters) ← Older edit		Revision as of 16:37, 1 September 2009 (edit) (undo) Alex (Talk | contribs) (→Output) Newer edit →
Line 17:		Line 17:
	* Client		* Client
-	With paging	+	With paging.
		+
		+	With download to xls.
		+
		+	== Excel format ==
		+
		+	Same as HTML (ZUL)

---

Revision as of 16:37, 1 September 2009

Contents 1 Biz Req 2 Filters 3 Output 4 Excel format

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.

Filters

• CT Created on Date: = GenTab.17. Notification Date:

• if both dates empty it means do not apply any date filter (no restriction on dates)

Output

2 columns:

• CT (link)
• Client

With paging.

With download to xls.

Excel format

Same as HTML (ZUL)