addons/sale/sale_demo.xml

   1 <?xml version="1.0" encoding="utf-8"?>
   2 <openerp>
   3     <data noupdate="1">
   4
   5         <record model="crm.case.section" id="sales_team.section_sales_department">
   6             <field name="invoiced_forecast">52700</field>
   7             <field name="invoiced_target">60000</field>
   8         </record>
   9
  10         <record model="crm.case.section" id="sales_team.crm_case_section_1">
  11             <field name="invoiced_forecast">36000</field>
  12             <field name="invoiced_target">40000</field>
  13         </record>
  14
  15         <record id="sale_order_1" model="sale.order">
  16             <field name="partner_id" ref="base.res_partner_2"/>
  17             <field name="partner_invoice_id" ref="base.res_partner_2"/>
  18             <field name="partner_shipping_id" ref="base.res_partner_2"/>
  19             <field name="user_id" ref="base.user_demo"/>
  20             <field name="pricelist_id" ref="product.list0"/>
  21             <field name="section_id" ref="sales_team.section_sales_department"/>
  22             <field name="date_order" eval="(DateTime.today() - relativedelta(months=1)).strftime('%Y-%m-%d %H:%M')"/>
  23         </record>
  24
  25         <record id="sale_order_line_1" model="sale.order.line">
  26             <field name="order_id" ref="sale_order_1"/>
  27             <field name="name">Laptop E5023</field>
  28             <field name="product_id" ref="product.product_product_25"/>
  29             <field name="product_uom_qty">3</field>
  30             <field name="product_uos_qty">3</field>
  31             <field name="product_uom" ref="product.product_uom_unit"/>
  32             <field name="price_unit">2950.00</field>
  33         </record>
  34
  35         <record id="sale_order_line_2" model="sale.order.line">
  36             <field name="order_id" ref="sale_order_1"/>
  37             <field name="name">Pen drive, 16GB</field>
  38             <field name="product_id" ref="product.product_product_30"/>
  39             <field name="product_uom_qty">5</field>
  40             <field name="product_uos_qty">5</field>
  41             <field name="product_uom" ref="product.product_uom_unit"/>
  42             <field name="price_unit">145.00</field>
  43         </record>
  44
  45         <record id="sale_order_line_3" model="sale.order.line">
  46             <field name="order_id" ref="sale_order_1"/>
  47             <field name="name">Headset USB</field>
  48             <field name="product_id" ref="product.product_product_33"/>
  49             <field name="product_uom_qty">2</field>
  50             <field name="product_uos_qty">2</field>
  51             <field name="product_uom" ref="product.product_uom_unit"/>
  52             <field name="price_unit">65.00</field>
  53         </record>
  54
  55         <record id="sale_order_2" model="sale.order">
  56             <field name="partner_id" ref="base.res_partner_7"/>
  57             <field name="partner_invoice_id" ref="base.res_partner_address_13"/>
  58             <field name="partner_shipping_id" ref="base.res_partner_address_13"/>
  59             <field name="user_id" ref="base.user_root"/>
  60             <field name="pricelist_id" ref="product.list0"/>
  61             <field name="order_policy">manual</field>
  62             <field name="section_id" ref="sales_team.section_sales_department"/>
  63             <field name="date_order" eval="(DateTime.today() - relativedelta(months=1)).strftime('%Y-%m-%d %H:%M')"/>
  64         </record>
  65
  66         <record id="sale_order_line_4" model="sale.order.line">
  67             <field name="order_id" ref="sale_order_2"/>
  68             <field name="name">Service on demand</field>
  69             <field name="product_id" ref="product.product_product_consultant"/>
  70             <field name="product_uom_qty">24</field>
  71             <field name="product_uos_qty">24</field>
  72             <field name="product_uom" ref="product.product_uom_hour"/>
  73             <field name="price_unit">75.00</field>
  74         </record>
  75
  76         <record id="sale_order_line_5" model="sale.order.line">
  77             <field name="order_id" ref="sale_order_2"/>
  78             <field name="name">On Site Assistance</field>
  79             <field name="product_id" ref="product.product_product_2"/>
  80             <field name="product_uom_qty">30</field>
  81             <field name="product_uos_qty">30</field>
  82             <field name="product_uom" ref="product.product_uom_hour"/>
  83             <field name="price_unit">38.25</field>
  84         </record>
  85
  86         <record id="sale_order_3" model="sale.order">
  87             <field name="partner_id" ref="base.res_partner_14"/>
  88             <field name="partner_invoice_id" ref="base.res_partner_14"/>
  89             <field name="partner_shipping_id" ref="base.res_partner_14"/>
  90             <field name="user_id" ref="base.user_root"/>
  91             <field name="pricelist_id" ref="product.list0"/>
  92             <field name="order_policy">manual</field>
  93             <field name="section_id" ref="sales_team.section_sales_department"/>
  94         </record>
  95
  96         <record id="sale_order_line_6" model="sale.order.line">
  97             <field name="order_id" ref="sale_order_3"/>
  98             <field name="name">On Site Monitoring</field>
  99             <field name="product_id" ref="product.product_product_1"/>
 100             <field name="product_uom_qty">10</field>
 101             <field name="product_uos_qty">10</field>
 102             <field name="product_uom" ref="product.product_uom_hour"/>
 103             <field name="price_unit">30.75</field>
 104         </record>
 105
 106         <record id="sale_order_line_7" model="sale.order.line">
 107             <field name="order_id" ref="sale_order_3"/>
 108             <field name="name">Toner Cartridge</field>
 109             <field name="product_id" ref="product.product_product_39"/>
 110             <field name="product_uom_qty">1</field>
 111             <field name="product_uos_qty">1</field>
 112             <field name="product_uom" ref="product.product_uom_unit"/>
 113             <field name="price_unit">70.00</field>
 114         </record>
 115
 116         <record id="sale_order_4" model="sale.order">
 117             <field name="partner_id" ref="base.res_partner_15"/>
 118             <field name="partner_invoice_id" ref="base.res_partner_address_25"/>
 119             <field name="partner_shipping_id" ref="base.res_partner_address_25"/>
 120             <field name="user_id" ref="base.user_root"/>
 121             <field name="pricelist_id" ref="product.list0"/>
 122             <field name="section_id" ref="sales_team.section_sales_department"/>
 123         </record>
 124
 125         <record id="sale_order_line_8" model="sale.order.line">
 126             <field name="order_id" ref="sale_order_4"/>
 127             <field name="name">Service on demand</field>
 128             <field name="product_id" ref="product.product_product_consultant"/>
 129             <field name="product_uom_qty">16</field>
 130             <field name="product_uos_qty">16</field>
 131             <field name="product_uom" ref="product.product_uom_hour"/>
 132             <field name="price_unit">75.00</field>
 133         </record>
 134
 135         <record id="sale_order_line_9" model="sale.order.line">
 136             <field name="order_id" ref="sale_order_4"/>
 137             <field name="name">Webcam</field>
 138             <field name="product_id" ref="product.product_product_34"/>
 139             <field name="product_uom_qty">10</field>
 140             <field name="product_uos_qty">10</field>
 141             <field name="product_uom" ref="product.product_uom_unit"/>
 142             <field name="price_unit">45.00</field>
 143         </record>
 144
 145         <record id="sale_order_line_10" model="sale.order.line">
 146             <field name="order_id" ref="sale_order_4"/>
 147             <field name="name">Multimedia Speakers</field>
 148             <field name="product_id" ref="product.product_product_31"/>
 149             <field name="product_uom_qty">3</field>
 150             <field name="product_uos_qty">3</field>
 151             <field name="product_uom" ref="product.product_uom_unit"/>
 152             <field name="price_unit">150.00</field>
 153         </record>
 154
 155         <record id="sale_order_line_11" model="sale.order.line">
 156             <field name="order_id" ref="sale_order_4"/>
 157             <field name="name">Switch, 24 ports</field>
 158             <field name="product_id" ref="product.product_product_47"/>
 159             <field name="product_uom_qty">2</field>
 160             <field name="product_uos_qty">2</field>
 161             <field name="product_uom" ref="product.product_uom_unit"/>
 162             <field name="price_unit">70.00</field>
 163         </record>
 164
 165         <record id="sale_order_5" model="sale.order">
 166             <field name="partner_id" ref="base.res_partner_2"/>
 167             <field name="partner_invoice_id" ref="base.res_partner_2"/>
 168             <field name="partner_shipping_id" ref="base.res_partner_2"/>
 169             <field name="user_id" ref="base.user_demo"/>
 170             <field name="pricelist_id" ref="product.list0"/>
 171             <field name="section_id" ref="sales_team.crm_case_section_1"/>
 172             <field name="date_order" eval="(DateTime.today() - relativedelta(months=1)).strftime('%Y-%m-%d %H:%M')"/>
 173         </record>
 174
 175         <record id="sale_order_line_12" model="sale.order.line">
 176             <field name="order_id" ref="sale_order_5"/>
 177             <field name="name">External Hard disk</field>
 178             <field name="product_id" ref="product.product_product_28"/>
 179             <field name="product_uom_qty">1</field>
 180             <field name="product_uos_qty">1</field>
 181             <field name="product_uom" ref="product.product_uom_unit"/>
 182             <field name="price_unit">405.00</field>
 183         </record>
 184
 185         <record id="sale_order_line_13" model="sale.order.line">
 186             <field name="order_id" ref="sale_order_5"/>
 187             <field name="name">Blank DVD-RW</field>
 188             <field name="product_id" ref="product.product_product_36"/>
 189             <field name="product_uom_qty">3</field>
 190             <field name="product_uos_qty">3</field>
 191             <field name="product_uom" ref="product.product_uom_dozen"/>
 192             <field name="price_unit">24.00</field>
 193         </record>
 194
 195         <record id="sale_order_line_14" model="sale.order.line">
 196             <field name="order_id" ref="sale_order_5"/>
 197             <field name="name">Printer, All-in-one</field>
 198             <field name="product_id" ref="product.product_product_37"/>
 199             <field name="product_uom_qty">1</field>
 200             <field name="product_uos_qty">1</field>
 201             <field name="product_uom" ref="product.product_uom_unit"/>
 202             <field name="price_unit">4410.00</field>
 203         </record>
 204
 205         <record id="sale_order_6" model="sale.order">
 206             <field name="partner_id" ref="base.res_partner_18"/>
 207             <field name="partner_invoice_id" ref="base.res_partner_18"/>
 208             <field name="partner_shipping_id" ref="base.res_partner_18"/>
 209             <field name="user_id" ref="base.user_root"/>
 210             <field name="pricelist_id" ref="product.list0"/>
 211             <field name="section_id" ref="sales_team.crm_case_section_1"/>
 212         </record>
 213
 214         <record id="sale_order_line_15" model="sale.order.line">
 215             <field name="order_id" ref="sale_order_6"/>
 216             <field name="name">PC Assamble + 2GB RAM</field>
 217             <field name="product_id" ref="product.product_product_4"/>
 218             <field name="product_uom_qty">1</field>
 219             <field name="product_uos_qty">1</field>
 220             <field name="product_uom" ref="product.product_uom_unit"/>
 221             <field name="price_unit">750.00</field>
 222         </record>
 223
 224         <record id="sale_order_7" model="sale.order">
 225             <field name="partner_id" ref="base.res_partner_11"/>
 226             <field name="partner_invoice_id" ref="base.res_partner_address_20"/>
 227             <field name="partner_shipping_id" ref="base.res_partner_address_20"/>
 228             <field name="user_id" ref="base.user_root"/>
 229             <field name="pricelist_id" ref="product.list0"/>
 230             <field name="order_policy">manual</field>
 231             <field name="section_id" ref="sales_team.section_sales_department"/>
 232             <field name="date_confirm" eval="(DateTime.today() - relativedelta(months=1)).strftime('%Y-%m-%d %H:%M')"/>
 233         </record>
 234
 235         <record id="sale_order_line_16" model="sale.order.line">
 236             <field name="order_id" ref="sale_order_7"/>
 237             <field name="name">Laptop E5023</field>
 238             <field name="product_id" ref="product.product_product_25"/>
 239             <field name="product_uom_qty">5</field>
 240             <field name="product_uos_qty">5</field>
 241             <field name="product_uom" ref="product.product_uom_unit"/>
 242             <field name="price_unit">2950.00</field>
 243         </record>
 244
 245         <record id="sale_order_line_17" model="sale.order.line">
 246             <field name="order_id" ref="sale_order_7"/>
 247             <field name="name">GrapWorks Software</field>
 248             <field name="product_id" ref="product.product_product_44"/>
 249             <field name="product_uom_qty">1</field>
 250             <field name="product_uos_qty">1</field>
 251             <field name="product_uom" ref="product.product_uom_unit"/>
 252             <field name="price_unit">173.00</field>
 253         </record>
 254
 255         <record id="sale_order_line_18" model="sale.order.line">
 256             <field name="order_id" ref="sale_order_7"/>
 257             <field name="name">Datacard</field>
 258             <field name="product_id" ref="product.product_product_46"/>
 259             <field name="product_uom_qty">1</field>
 260             <field name="product_uos_qty">1</field>
 261             <field name="product_uom" ref="product.product_uom_unit"/>
 262             <field name="price_unit">40.00</field>
 263         </record>
 264
 265         <record id="sale_order_line_19" model="sale.order.line">
 266             <field name="order_id" ref="sale_order_7"/>
 267             <field name="name">USB Adapter</field>
 268             <field name="product_id" ref="product.product_product_48"/>
 269             <field name="product_uom_qty">1</field>
 270             <field name="product_uos_qty">1</field>
 271             <field name="product_uom" ref="product.product_uom_unit"/>
 272             <field name="price_unit">18.00</field>
 273         </record>
 274
 275         <record id="sale_order_8" model="sale.order">
 276             <field name="name">Test/001</field>
 277             <field name="partner_id" ref="base.res_partner_15"/>
 278             <field name="partner_invoice_id" ref="base.res_partner_address_25"/>
 279             <field name="partner_shipping_id" ref="base.res_partner_address_25"/>
 280             <field name="user_id" ref="base.user_demo"/>
 281             <field name="pricelist_id" ref="product.list0"/>
 282             <field name="order_policy">manual</field>
 283             <field name="section_id" ref="sales_team.crm_case_section_1"/>
 284         </record>
 285
 286         <record id="sale_order_line_20" model="sale.order.line">
 287             <field name="order_id" ref="sale_order_8"/>
 288             <field name="name">Laptop Customized</field>
 289             <field name="product_id" ref="product.product_product_27"/>
 290             <field name="product_uom_qty">2</field>
 291             <field name="product_uos_qty">2</field>
 292             <field name="product_uom" ref="product.product_uom_unit"/>
 293             <field name="price_unit">3645.00</field>
 294         </record>
 295
 296         <record id="sale_order_line_21" model="sale.order.line">
 297             <field name="order_id" ref="sale_order_8"/>
 298             <field name="name">Mouse, Wireless</field>
 299             <field name="product_id" ref="product.product_product_12"/>
 300             <field name="product_uom_qty">2</field>
 301             <field name="product_uos_qty">2</field>
 302             <field name="product_uom" ref="product.product_uom_unit"/>
 303             <field name="price_unit">12.50</field>
 304         </record>
 305
 306         <!-- Confirm some Sale Orders-->
 307         <workflow action="order_confirm" model="sale.order" ref="sale_order_4"/>
 308
 309         <workflow action="order_confirm" model="sale.order" ref="sale_order_7"/>
 310
 311         <record id="message_sale_1" model="mail.message">
 312             <field name="model">sale.order</field>
 313             <field name="res_id" ref="sale_order_2"/>
 314             <field name="body">Hi,
 315 I have a question regarding services pricing: I heard of a possible discount for quantities exceeding 25 hours.
 316 Could you confirm, please?</field>
 317             <field name="type">comment</field>
 318             <field name="author_id" ref="base.partner_demo"/>
 319         </record>
 320
 321         <record id="message_sale_2" model="mail.message">
 322             <field name="model">sale.order</field>
 323             <field name="res_id" ref="sale_order_2"/>
 324             <field name="parent_id" ref="message_sale_1"/>
 325             <field name="body">Hello,
 326 Unfortunately that was a temporary discount that is not available anymore.
 327 Do you still plan to confirm the order based on the quoted prices?
 328 Thanks!</field>
 329             <field name="type">comment</field>
 330             <field name="author_id" ref="base.partner_root"/>
 331         </record>
 332
 333         <record id="message_sale_3" model="mail.message">
 334             <field name="model">sale.order</field>
 335             <field name="res_id" ref="sale_order_2"/>
 336             <field name="parent_id" ref="message_sale_2"/>
 337             <field name="body">Alright, thanks for the clarification. I will confirm the order as soon as I get my manager's approval.</field>
 338             <field name="type">comment</field>
 339             <field name="author_id" ref="base.partner_demo"/>
 340         </record>
 341         <!-- sale advance demo.. -->
 342         <!-- Demo Data for Product -->
 343
 344         <record id="advance_product_0" model="product.product">
 345             <field name="name">Advance</field>
 346             <field name="categ_id" ref="product.product_category_1"/>
 347             <field name="type">service</field>
 348             <field name="list_price">150.0</field>
 349             <field name="standard_price">100.0</field>
 350             <field name="uom_id" ref="product.product_uom_day"/>
 351             <field name="uom_po_id" ref="product.product_uom_day"/>
 352             <field name="company_id" eval="[]"/>
 353             <field name="image" type="base64" file="sale/static/img/advance_product_0-image.jpg"/>
 354         </record>
 355
 356         <record id="base.user_demo" model="res.users">
 357             <field eval="[(4, ref('base.group_sale_salesman'))]" name="groups_id"/>
 358         </record>
 359
 360         <!-- coming from sale_crm -->
 361         <record id="test_crm_sale_invoice_1" model="account.invoice">
 362             <field name="currency_id" ref="base.EUR"/>
 363             <field name="company_id" ref="base.main_company"/>
 364             <field name="partner_id" ref="base.res_partner_1"/>
 365             <field name="journal_id" ref="account.sales_journal"/>
 366             <field name="section_id" ref="sales_team.section_sales_department"/>
 367             <field name="state">draft</field>
 368             <field name="type">in_invoice</field>
 369             <field name="account_id" ref="account.a_recv"/>
 370             <field name="name">Test invoice 1</field>
 371         </record>
 372         <record id="test_crm_sale_invoice_1_line_1" model="account.invoice.line">
 373             <field name="name">Basic computer with Dvorak keyboard and left-handed mouse</field>
 374             <field name="invoice_id" ref="test_crm_sale_invoice_1"/>
 375             <field name="price_unit">250</field>
 376             <field name="quantity">1</field>
 377             <field name="account_id" ref="account.a_sale"/>
 378         </record>
 379         <record id="test_crm_sale_invoice_1_line_2" model="account.invoice.line">
 380             <field name="name">Little server with raid 1 and 512ECC ram</field>
 381             <field name="invoice_id" ref="test_crm_sale_invoice_1"/>
 382             <field name="price_unit">800</field>
 383             <field name="quantity">2</field>
 384             <field name="account_id" ref="account.a_sale"/>
 385         </record>
 386         <record id="test_crm_sale_invoice_1_line_2" model="account.invoice.line">
 387             <field name="name">Server with raid 10 and 2048ECC ram</field>
 388             <field name="invoice_id" ref="test_crm_sale_invoice_1"/>
 389             <field name="price_unit">4800</field>
 390             <field name="quantity">4</field>
 391             <field name="account_id" ref="account.a_sale"/>
 392         </record>
 393         <workflow action="invoice_open" model="account.invoice" ref="test_crm_sale_invoice_1"/>
 394         <function model="account.invoice" name="pay_and_reconcile">
 395             <!-- ids = -->                    <value eval="[ref('test_crm_sale_invoice_1')]"/>
 396             <!-- pay_amount = -->            <value eval="1850"/>
 397             <!-- pay_account_id = -->        <value eval="ref('account.cash')"/>
 398             <!-- period_id = -->            <value eval="ref('account.period_' + str(int(time.strftime('%m'))))"/>
 399             <!-- pay_journal_id = -->        <value eval="ref('account.bank_journal')"/>
 400             <!-- writeoff_acc_id = -->        <value eval="ref('account.cash')"/>
 401             <!-- writeoff_period_id = -->    <value eval="ref('account.period_' + str(int(time.strftime('%m'))))"/>
 402             <!-- writeoff_journal_id = -->    <value eval="ref('account.bank_journal')"/>
 403             <!-- context = -->              <value eval="{}"/>
 404             <!-- name = -->                 <value eval="str('Payment from ASUStek')"/>
 405         </function>
 406
 407         <!-- Invoice for Indirect Marketing -->
 408
 409         <record id="test_crm_sale_invoice_2" model="account.invoice">
 410             <field name="currency_id" ref="base.EUR"/>
 411             <field name="company_id" ref="base.main_company"/>
 412             <field name="partner_id" ref="base.res_partner_1"/>
 413             <field name="journal_id" ref="account.sales_journal"/>
 414             <field name="section_id" ref="sales_team.crm_case_section_1"/>
 415             <field name="state">draft</field>
 416             <field name="type">out_invoice</field>
 417             <field name="account_id" ref="account.a_recv"/>
 418             <field name="name">Test invoice 1</field>
 419         </record>
 420         <record id="test_crm_sale_invoice_2_line_1" model="account.invoice.line">
 421             <field name="name">Basic formation with Dvorak</field>
 422             <field name="invoice_id" ref="test_crm_sale_invoice_2"/>
 423             <field name="price_unit">500</field>
 424             <field name="quantity">1</field>
 425             <field name="account_id" ref="account.a_sale"/>
 426         </record>
 427         <workflow action="invoice_open" model="account.invoice" ref="test_crm_sale_invoice_2"/>
 428         <function model="account.invoice" name="pay_and_reconcile">
 429             <!-- ids = -->                    <value eval="[ref('test_crm_sale_invoice_2')]"/>
 430             <!-- pay_amount = -->            <value eval="500"/>
 431             <!-- pay_account_id = -->        <value eval="ref('account.cash')"/>
 432             <!-- period_id = -->            <value eval="ref('account.period_' + str(int(time.strftime('%m'))))"/>
 433             <!-- pay_journal_id = -->        <value eval="ref('account.bank_journal')"/>
 434             <!-- writeoff_acc_id = -->        <value eval="ref('account.cash')"/>
 435             <!-- writeoff_period_id = -->    <value eval="ref('account.period_' + str(int(time.strftime('%m'))))"/>
 436             <!-- writeoff_journal_id = -->    <value eval="ref('account.bank_journal')"/>
 437             <!-- context = -->              <value eval="{}"/>
 438             <!-- name = -->                 <value eval="str('Payment from ASUStek')"/>
 439         </function>
 440
 441     </data>
 442 </openerp>