1 <?xml version="1.0" encoding="utf-8"?>
4 <record id="view_account_invoice_report_tree" model="ir.ui.view">
5 <field name="name">account.invoice.report.tree</field>
6 <field name="model">account.invoice.report</field>
7 <field name="type">tree</field>
8 <field name="arch" type="xml">
9 <tree string="Invoices Statistics">
10 <field name="date" invisible="1"/>
11 <field name="user_id" invisible="1"/>
12 <field name="year" invisible="1"/>
13 <field name="day" invisible="1"/>
14 <field name="month" invisible="1"/>
15 <field name="type" invisible="1"/>
16 <field name="company_id" invisible="1"/>
17 <field name="partner_id" invisible="1"/>
18 <field name="product_id" invisible="1"/>
19 <field name="product_qty" invisible="1"/>
20 <!--field name="delay" avg="Days to Close"/-->
21 <field name="nbr" sum="# of Lines"/>
22 <field name="price_average" avg="Average Price"/>
23 <field name="price_total" sum="Total Price"/>
24 <field name="state" invisible="1"/>
25 <field name="payment_term" invisible="1"/>
26 <field name="period_id" invisible="1"/>
27 <field name="fiscal_position" invisible="1"/>
28 <field name="currency_id" invisible="1"/>
29 <field name="journal_id" invisible="1"/>
30 <field name="date_due" invisible="1"/>
31 <field name="address_contact_id" invisible="1"/>
32 <field name="address_invoice_id" invisible="1"/>
33 <field name="account_id" invisible="1"/>
34 <field name="partner_bank" invisible="1"/>
35 <field name="residual" sum="Total Residual"/>
36 <field name="delay_to_pay" avg="Avg. Delay To Pay"/>
41 <record id="view_account_invoice_report_graph" model="ir.ui.view">
42 <field name="name">account.invoice.report.graph</field>
43 <field name="model">account.invoice.report</field>
44 <field name="type">graph</field>
45 <field name="arch" type="xml">
46 <graph string="Invoices Statistics" type="bar">
47 <field name="product_id"/>
48 <field name="price_total"/>
53 <record id="view_account_invoice_report_search" model="ir.ui.view">
54 <field name="name">account.invoice.report.search</field>
55 <field name="model">account.invoice.report</field>
56 <field name="type">search</field>
57 <field name="arch" type="xml">
58 <search string="Invoices">
60 <filter icon="terp-account" string="This Year"
61 domain="[('date','<=', time.strftime('%%Y-%%m-%%d')),('date','>',(datetime.date.today()-datetime.timedelta(days=365)).strftime('%%Y-%%m-%%d'))]"
62 help="Invoices of the year"/>
63 <filter icon="terp-account" string="This Month"
65 domain="[('date','<=', time.strftime('%%Y-%%m-%%d')), ('date','>',(datetime.date.today()-datetime.timedelta(days=30)).strftime('%%Y-%%m-%%d'))]"
66 help="Invoices of this month"/>
67 <filter icon="gtk-media-rewind"
70 domain="[('date','<=', time.strftime('%%Y-%%m-%%d')), ('date','>',(datetime.date.today()-datetime.timedelta(days=7)).strftime('%%Y-%%m-%%d'))]"
71 help="Invoices during last 7 days"/>
72 <separator orientation="vertical"/>
73 <filter string="Draft"
75 domain="[('state','=','draft')]"
76 help = "Draft tasks"/>
77 <filter string="Pro-forma"
79 domain="[('state','=','proforma'),('state','=','proforma2')]"
80 help = "Pro-forma tasks"/>
81 <filter string="Current"
83 domain="[('state', '=' ,'open')]"
84 help = "In progress tasks"/>
85 <separator orientation="vertical"/>
86 <field name="user_id" widget="selection">
88 <filter icon="terp-account"
91 domain="[('user_id','=',uid)]" />
92 <filter icon="terp-account"
93 string="Invoices Non Users"
94 help="Invoices Non Users"
95 domain="[('user_id','=',False)]"/>
97 <field name="product_id"/>
98 <field name="partner_id"/>
99 <field name="company_id" groups="base.group_multi_company" widget="selection"/>
102 <group expand="0" string="Extended options..." colspan="10" col="12">
103 <filter string="Done"
105 domain="[('state','=','paid')]"
106 help = "Done tasks"/>
107 <filter string="Cancelled"
109 domain="[('state', '=' ,'cancel')]"
110 help = "Cancelled tasks"/>
111 <separator orientation="vertical"/>
113 <field name="payment_term" widget="selection"/>
114 <separator orientation="vertical"/>
115 <field name="currency_id" widget="selection"/>
116 <field name="journal_id" widget="selection"/>
118 <field name="address_contact_id"/>
119 <field name="address_invoice_id"/>
120 <separator orientation="vertical"/>
121 <field name="account_id"/>
122 <field name="partner_bank"/>
123 <separator orientation="vertical"/>
124 <field name="period_id" widget="selection"/>
125 <field name="fiscal_position" widget="selection"/>
127 <field name="date" string="Date Invoiced"/>
128 <separator orientation="vertical"/>
129 <field name="date_due"/>
132 <group expand="1" string="Group By..." colspan="10" col="12">
133 <filter string="Salesman" name='User' icon="terp-account" context="{'group_by':'user_id'}"/>
134 <filter string="Product" icon="terp-account" context="{'group_by':'product_id'}"/>
135 <filter string="Partner" icon="terp-account" context="{'group_by':'partner_id'}"/>
136 <filter string="Company" icon="terp-account" context="{'group_by':'company_id'}" groups="base.group_multi_company"/>
137 <separator orientation="vertical"/>
138 <filter string="State" icon="terp-account" context="{'group_by':'state'}"/>
139 <filter string="Type" icon="terp-account" context="{'group_by':'type'}"/>
140 <filter string="Payment Term" icon="terp-account" context="{'group_by':'payment_term'}"/>
141 <separator orientation="vertical"/>
142 <filter string="Currency" icon="terp-account" context="{'group_by':'currency_id'}"/>
143 <filter string="Journal" icon="terp-account" context="{'group_by':'journal_id'}"/>
144 <separator orientation="vertical"/>
145 <filter string="Account" icon="terp-account" context="{'group_by':'account_id'}"/>
146 <filter string="Bank Account" icon="terp-account" context="{'group_by':'partner_bank'}"/>
148 <filter string="Contact Address" icon="terp-account" context="{'group_by':'address_contact_id'}"/>
149 <filter string="Invoice Address" icon="terp-account" context="{'group_by':'address_invoice_id'}"/>
150 <separator orientation="vertical"/>
151 <filter string="Force Period" icon="terp-account" context="{'group_by':'period_id'}"/>
152 <filter string="Fiscal Position" icon="terp-account" context="{'group_by':'fiscal_position'}"/>
153 <separator orientation="vertical"/>
154 <filter string="Day" icon="terp-account" context="{'group_by':'day'}"/>
155 <filter string="Month" icon="terp-account" context="{'group_by':'month'}"/>
156 <filter string="Year" icon="terp-account" context="{'group_by':'year'}"/>
162 <record id="action_account_invoice_report_all" model="ir.actions.act_window">
163 <field name="name">Invoices</field>
164 <field name="res_model">account.invoice.report</field>
165 <field name="view_type">form</field>
166 <field name="view_mode">tree,graph</field>
167 <field name="context">{'search_default_month':1,'search_default_User':1,'group_by_no_leaf':1,'group_by':[]}</field>
168 <field name="search_view_id" ref="view_account_invoice_report_search"/>
171 <menuitem action="action_account_invoice_report_all" id="menu_action_account_invoice_report_all" parent="account.menu_finance_reporting" sequence="0"/>