Acc Reports CTs With No Inv

From UG

(Difference between revisions)
Jump to: navigation, search
(History)
(Button: "Button" section renamed to "Action Controls")
Line 18: Line 18:
* NOTE: if both dates empty it means do not apply any date filter (no restriction on dates)
* NOTE: if both dates empty it means do not apply any date filter (no restriction on dates)
-
== Button ==
+
== Action Controls ==
-
* Go back > go back to the previous page
+
* '''Reset Form''' > clear all filter
-
* Reset Form > clear all filter
+
* '''Generate Result''' > HTML result(s) with CT#links and paging  
-
* Generate Result > HTML result(s) with CT#links and paging  
+
** '''Go back''' > go back to the previous page
-
** Go back > go back to the previous page
+
** '''Download to Excel''' > Excel report with CT# links
-
** Download to Excel > Excel report with CT# links
+
== Output ==
== Output ==

Revision as of 19:52, 28 November 2010


Contents

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)

Action Controls

  • 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

File:CTs with no inv.JPG

History

m1894

0002157: (Reps) (CTs With No Inv) Add "Unbilled Sales" report type. Rename some labels

Personal tools