Acc Reports CTs With No Inv
From UG
(Difference between revisions)
(→Excel format) |
(→Figures) |
||
Line 39: | Line 39: | ||
[[File:CTs with no inv.JPG]] | [[File:CTs with no inv.JPG]] | ||
+ | |||
+ | == History == | ||
+ | |||
+ | === m1894 === |
Revision as of 06:11, 11 April 2010
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
- 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)