Acc Reports CTs With No Inv

From UG

Contents 1 Biz Req 2 Hard Coded conditions 3 Filters 4 Action Controls 5 Output 6 Excel format 7 Figures 7.1 Figure 1 8 History 8.1 m1894 8.2 0002157: (Reps) (CTs With No Inv) Add "Unbilled Sales" report type. Rename some labels

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

History

m1894

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

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