Odoo 中文社区

    • Register
    • Login
    • Search
    • Categories
    • Tags
    • Popular
    • Users
    • Groups

    Odoo中文社区可以通过以下两个域名访问:shine-it.net , odoo.net.cn

    由于系统升迁的原因,本论坛部分较早期的内容存在格式和链接损坏失效的问题,并非本论坛系统本身的缺陷,望谅解

    本社区没有维护任何QQ群讨论组,任何与本社区同名的QQ群讨论组的言论与本社区无关!

    开发人员可以登录gitter讨论组: http://gitter.im/odoo-china/Talk, 需要github账号

    如果您登录系统碰到问题,请在微信公众号留言:

    实用脚本:OpenERP基础篇-新手入门-业务模拟-清除模拟数据反复测试-OpenERPV6

    Odoo 新手求助
    3
    6
    6611
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • X
      xuxudodo last edited by

      OpenERP基础篇-新手入门-业务模拟-数据清除


      使用场景:
      建好了一个帐套,做了很多业务模拟,现在想重新开始,又不想再重新建帐套.
      其中,只想清除销售,采购,库存,会计模块的一些业务数据,产品、客户、供应商和基础配置保留,如果是这样,就可以使用下面的SQL脚本。

      [b]
      [size=14pt][color=red]申明:
      使用有风险,操作需谨慎。
      操作前先备份数据!!![/color][/size][/b]


      --会计部分
      TRUNCATE table account_invoice CASCADE;
      TRUNCATE table account_invoice_line CASCADE;
      TRUNCATE table account_invoice_line_tax CASCADE;
      TRUNCATE table account_invoice_tax CASCADE;
      TRUNCATE table account_move CASCADE;
      TRUNCATE table account_move_line CASCADE;
      TRUNCATE table account_move_reconcile CASCADE;

      TRUNCATE table account_balance_report_journal_rel CASCADE;
      TRUNCATE table account_bank_accounts_wizard CASCADE;
      TRUNCATE table account_bank_statement CASCADE;
      TRUNCATE table account_bank_statement_line CASCADE;
      TRUNCATE table account_bank_statement_line_move_rel CASCADE;
      TRUNCATE table account_cashbox_line CASCADE;
      TRUNCATE table account_invoice CASCADE;
      TRUNCATE table account_invoice_line CASCADE;
      TRUNCATE table account_invoice_refund CASCADE;
      TRUNCATE table account_voucher CASCADE;
      TRUNCATE table account_voucher_line CASCADE;


      TRUNCATE table payment_order CASCADE;

      --POS模块
      TRUNCATE table pos_order CASCADE;
      TRUNCATE table pos_order_line CASCADE;
      TRUNCATE table pos_make_payment CASCADE;
      TRUNCATE table pos_close_statement CASCADE;
      TRUNCATE table pos_box_entries CASCADE;
      TRUNCATE table pos_receipt CASCADE;
      TRUNCATE table pos_confirm CASCADE;
      TRUNCATE table pos_details CASCADE;
      TRUNCATE table pos_open_statement CASCADE;

      --采购模块
      TRUNCATE table purchase_order CASCADE;
      TRUNCATE table purchase_order_line CASCADE;
      TRUNCATE table purchase_order_taxe CASCADE;


      --销售模块
      TRUNCATE table sale_order CASCADE;
      TRUNCATE table sale_order_invoice_rel CASCADE;
      TRUNCATE table sale_order_line CASCADE;
      TRUNCATE table sale_order_line_invoice_rel CASCADE;
      TRUNCATE table sale_order_line_property_rel CASCADE;
      TRUNCATE table sale_order_tax CASCADE;


      --库存模块
      TRUNCATE table stock_inventory CASCADE;
      TRUNCATE table stock_inventory_line CASCADE;
      TRUNCATE table stock_inventory_move_rel CASCADE;
      TRUNCATE table stock_move CASCADE;
      TRUNCATE table stock_move_history_ids CASCADE;
      TRUNCATE table stock_picking CASCADE;


      TRUNCATE table procurement_order CASCADE;
      TRUNCATE table procurement_order_compute CASCADE;
      TRUNCATE table procurement_order_compute_all CASCADE;
      TRUNCATE table procurement_orderpoint_compute CASCADE;
      TRUNCATE table procurement_property_rel CASCADE;


      TRUNCATE table res_log CASCADE;
      TRUNCATE table mail_message CASCADE;

      --CRM模块
      TRUNCATE table crm_lead CASCADE;
      TRUNCATE table crm_meeting CASCADE;
      TRUNCATE table crm_make_sale CASCADE;
      TRUNCATE table crm_phonecall CASCADE;
      TRUNCATE table crm_segmentation_line CASCADE;

      TRUNCATE table edi_document CASCADE;
      TRUNCATE table detail_ledger CASCADE;

      --HR模块
      TRUNCATE table hr_sign_in_out CASCADE;
      TRUNCATE table hr_sign_in_out_ask CASCADE;
      TRUNCATE table hr_sign_in_project CASCADE;
      TRUNCATE table hr_sign_out_project CASCADE;


      看累了,可以下载文档PDF

      [attach=1]

      1 Reply Last reply Reply Quote 0
      • X
        xuxudodo last edited by

        主要是自己经常用,希望对大家有所帮助.

        1 Reply Last reply Reply Quote 0
        • wjfonhand
          wjfonhand last edited by

          这个不错,可以推荐使用

          GoodERP -- Odoo China fork

          1 Reply Last reply Reply Quote 0
          • mrshelly
            mrshelly last edited by

            不错.... 能给贴子加上标签(Tag) 就更棒了哇. ....

            1 Reply Last reply Reply Quote 0
            • X
              xuxudodo last edited by

              [quote author=mrshelly link=topic=4190.msg11309#msg11309 date=1338991829]
              不错.... 能给贴子加上标签(Tag) 就更棒了哇. ....
              [/quote]

              😃 已添加

              1 Reply Last reply Reply Quote 0
              • First post
                Last post