Acc Reports CTs With No Inv

From UG

(Difference between revisions)
Jump to: navigation, search
(Filters)
(Filters)
Line 11: Line 11:
* NOTE: CT Created on Date: = GenTab.17. Notification Date:
* 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)
* 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 ==
== Output ==

Revision as of 14:06, 2 September 2009


Contents

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

  • PI / SI radio
  • 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)

Personal tools