Acc Reports CTs With No Inv

From UG

Revision as of 11:30, 3 December 2010 by Andrei (Talk | contribs)
Jump to: navigation, search


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 Company
  • Jaguar Office

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