Acc Reports CTs With No Inv

From UG

Revision as of 07:03, 11 April 2010 (edit) Alex (Talk | contribs) (→m1894) ← Older edit		Revision as of 08:49, 5 August 2010 (edit) (undo) Andrei (Talk | contribs) Newer edit →
Line 1:		Line 1:
-	[[Category:Acc]]
	[[Category:AccReps]]		[[Category:AccReps]]

---

Revision as of 08:49, 5 August 2010

Contents 1 Biz Req 2 Hard Coded conditions 3 Filters 4 Button 5 Output 6 Excel format 7 Figures 7.1 Figure 1 8 History 8.1 m1894

Biz Req

This report helps to "catch" invoices that for some reson never being billed or never being mapped into any purchase amounts.

Hard Coded conditions

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

• Report conditions has been clarified. Verify that report satisfy #Hard Coded conditions. If not fix it.