Baoding-FenShuaJiang
/
Green_GoodERP18_FSJ_Standard
关注 1
点赞 0
百科 捐赠
gooderp18绿色标准版
您最多选择25个主题 主题必须以字母或数字开头，可以包含连字符 (-)，并且长度不得超过35个字符
分支: master
分支列表 标签列表
${ item.name }
创建分支 ${ searchTerm }
从 'master'
${ noResults }
Green_GoodERP18_FSJ_Standard/gooderp18/good/money/models/generate_accounting.py

255 行
12KB
原始文件 永久链接 Blame 文件历史 

  1. # Copyright 2016 上海开阖软件有限公司 (http://www.osbzr.com)

  2. # License AGPL-3.0 or later (http://www.gnu.org/licenses/agpl).

  3. 

  4. from odoo import models, fields, api

  5. from odoo.exceptions import UserError

  6. 

  7. 

  8. class MoneyInvoice(models.Model):

  9.     _inherit = 'money.invoice'

  10. 

  11.     voucher_id = fields.Many2one(

  12.         'voucher',

  13.         '对应凭证',

  14.         readonly=True,

  15.         ondelete='restrict',

  16.         copy=False,

  17.         help='结算单确认时生成的对应凭证')

  18.     cogs_voucher_id = fields.Many2one(

  19.         'voucher',

  20.         '成本凭证',

  21.         readonly=True,

  22.         ondelete='set null',

  23.         copy=False,

  24.         help='结算单确认时生成的成本凭证')

  25. 

  26.     def money_invoice_draft(self):

  27.         """

  28.         撤销确认结算单时，撤销确认凭证

  29.         """

  30.         res = super(MoneyInvoice, self).money_invoice_draft()

  31.         for invoice in self:

  32.             voucher, invoice.voucher_id = invoice.voucher_id, False

  33.             if voucher.state == 'done':

  34.                 voucher.voucher_draft()

  35.             # 始初化单反审核只删除明细行：生成初始化凭证时，不生成往来单位对方的科目，所以要删除相关明细行

  36.             if invoice.is_init:

  37.                 vouch_obj = self.env['voucher'].search(

  38.                     [('id', '=', voucher.id)])

  39.                 vouch_obj_lines = self.env['voucher.line'].search([

  40.                     ('voucher_id', '=', vouch_obj.id),

  41.                     ('partner_id', '=', invoice.partner_id.id),

  42.                     ('init_obj', '=', 'money_invoice'), ])

  43.                 for vouch_obj_line in vouch_obj_lines:

  44.                     vouch_obj_line.unlink()

  45.             else:   # 非初始化单反审核时删除凭证

  46.                 voucher.unlink()

  47.             # 删除发出成本凭证

  48.             cogs_voucher = self.env['voucher'].search(

  49.                 [('ref', '=', '%s,%s' % (self._name, invoice.id))])

  50.             if cogs_voucher:

  51.                 if cogs_voucher.state == 'done':

  52.                     cogs_voucher.voucher_draft()

  53.                 cogs_voucher.unlink()

  54.         return res

  55. 

  56.     def money_invoice_done(self):

  57.         """

  58.         确认结算单时，创建凭证并确认

  59.         """

  60.         res = super(MoneyInvoice, self).money_invoice_done()

  61.         vals = {}

  62.         # 初始化单的话，先找是否有初始化凭证，没有则新建一个

  63.         for invoice in self:

  64.             if invoice.is_init:

  65.                 vouch_obj = self.env['voucher'].search(

  66.                     [('is_init', '=', True)])

  67.                 if not vouch_obj:

  68.                     vouch_obj = self.env['voucher'].create(

  69.                         {'date': invoice.date,

  70.                          'is_init': True,

  71.                          'ref': '%s,%s' % (self._name, self.id)})

  72.                 invoice.write({'voucher_id': vouch_obj.id})

  73.             else:

  74.                 vouch_obj = self.env['voucher'].create({

  75.                     'date': invoice.invoice_date or

  76.                     fields.Date.context_today(self),

  77.                     'ref': '%s,%s' % (self._name, self.id)})

  78.                 invoice.write({'voucher_id': vouch_obj.id})

  79.             if not invoice.category_id.account_id:

  80.                 raise UserError('请配置%s的会计科目' % (invoice.category_id.name))

  81.             partner_cat = invoice.category_id.type == 'income' \

  82.                 and invoice.partner_id.c_category_id \

  83.                 or invoice.partner_id.s_category_id

  84.             partner_account_id = partner_cat.account_id.id

  85.             if not partner_account_id:

  86.                 raise UserError('请配置%s的会计科目' % (partner_cat.name))

  87.             if invoice.category_id.type == 'income':

  88.                 vals.update({

  89.                     'vouch_obj_id': vouch_obj.id,

  90.                     'partner_credit': invoice.partner_id.id,

  91.                     'name': invoice.name,

  92.                     'string': invoice.note or '',

  93.                     'amount': invoice.amount,

  94.                     'credit_account_id': invoice.category_id.account_id.id,

  95.                     'partner_debit': invoice.partner_id.id,

  96.                     'debit_account_id': partner_account_id,

  97.                     'sell_tax_amount': invoice.tax_amount or 0,

  98.                     'credit_auxiliary_id': invoice.auxiliary_id.id,

  99.                     'currency_id': invoice.currency_id.id or '',

  100.                     'rate_silent': self.env['res.currency'].get_rate_silent(

  101.                         self.date, invoice.currency_id.id) or 0,

  102.                              })

  103.                 # 找到发票对应发货单的凭证，复制修改, 结转主营业务成本

  104.                 send_voucher = False

  105.                 if self.env['ir.module.module'].sudo().search(

  106.                         [('name', '=', 'sell'), ('state', '=', 'installed')]):

  107.                     delivery = self.env['sell.delivery'].search(

  108.                         [('name', '=', invoice.name)])

  109.                     send_voucher = delivery.voucher_id

  110.                 # 该公司不是月末一次性结转发出成本

  111.                 if send_voucher:

  112.                     cost_voucher_data = send_voucher.copy_data()

  113.                     out_account_id = self.env.ref(

  114.                         'finance.categ_sell_goods').account_id.id

  115.                     cogs_account_id = self.env.company.cogs_account.id

  116.                     # 如果发货单没有直接结转成本

  117.                     if out_account_id != cogs_account_id:

  118.                         for vl in cost_voucher_data[0]['line_ids']:

  119.                             if vl[2]['account_id'] != out_account_id:

  120.                                 vl[2].update({'account_id': cogs_account_id})

  121.                             vl[2].update({

  122.                                 'debit': vl[2]['credit'],

  123.                                 'credit': vl[2]['debit'],

  124.                                 'voucher_id': False})

  125.                         cost_voucher_data[0].update(

  126.                             {'ref': '%s,%s' % (self._name, self.id)})

  127.                         if invoice.invoice_date:

  128.                             cost_voucher_data[0].update(

  129.                                 {'date': invoice.invoice_date})

  130.                         cogs_voucher = self.env['voucher'].create(

  131.                             cost_voucher_data)

  132.                         cogs_voucher.voucher_done()

  133.                         invoice.cogs_voucher_id = cogs_voucher.id

  134.             else:

  135.                 vals.update({

  136.                     'vouch_obj_id': vouch_obj.id,

  137.                     'name': invoice.name,

  138.                     'string': invoice.note or '',

  139.                     'amount': invoice.amount,

  140.                     'credit_account_id': partner_account_id,

  141.                     'debit_account_id': invoice.category_id.account_id.id,

  142.                     'partner_debit': invoice.partner_id.id,

  143.                     'partner_credit': invoice.partner_id.id,

  144.                     'buy_tax_amount': invoice.tax_amount or 0,

  145.                     'debit_auxiliary_id': invoice.auxiliary_id.id,

  146.                     'currency_id': invoice.currency_id.id or '',

  147.                     'rate_silent': self.env['res.currency'].get_rate_silent(

  148.                         self.date, invoice.currency_id.id) or 0,

  149.                     })

  150.             if invoice.is_init:

  151.                 vals.update({'init_obj': 'money_invoice', })

  152.             invoice.create_voucher_line(vals)

  153.             # 删除初始非需要的凭证明细行,不确认凭证

  154.             if invoice.is_init:

  155.                 vouch_line_ids = self.env['voucher.line'].search([

  156.                     ('account_id', '=', invoice.category_id.account_id.id),

  157.                     ('init_obj', '=', 'money_invoice')])

  158.                 # 删除凭证明细行之前先确保凭证是草稿状态

  159.                 if invoice.voucher_id.state == 'done':

  160.                     invoice.voucher_id.voucher_draft()

  161.                 for vouch_line_id in vouch_line_ids:

  162.                     vouch_line_id.unlink()

  163.             else:

  164.                 vouch_obj.voucher_done()

  165.         return res

  166. 

  167.     def create_voucher_line(self, vals):

  168.         if vals.get('currency_id') == self.env.user.company_id.currency_id.id \

  169.                 or not vals.get('rate_silent'):

  170.             debit = credit = vals.get('amount')

  171.             sell_tax_amount = vals.get('sell_tax_amount')

  172.         else:

  173.             # 外币免税

  174.             debit = credit = vals.get('amount') * vals.get('rate_silent')

  175.         # 把税从金额中减去

  176.         if vals.get('buy_tax_amount'):  # 如果传入了进项税

  177.             debit = vals.get('amount') - vals.get('buy_tax_amount')

  178.         if vals.get('sell_tax_amount'):  # 如果传入了销项税

  179.             credit = vals.get('amount') - sell_tax_amount

  180.         # 借方行

  181.         currency_id = vals.get(

  182.             'currency_id') or self.env.user.company_id.currency_id.id

  183.         if currency_id != self.env.user.company_id.currency_id.id:  # 结算单上是外币

  184.             self.env['voucher.line'].create({

  185.                 'name': "%s %s" % (vals.get('name'), vals.get('string')),

  186.                 'account_id': vals.get('debit_account_id'),

  187.                 'debit': debit,

  188.                 'voucher_id': vals.get('vouch_obj_id'),

  189.                 'partner_id': vals.get('partner_debit', ''),

  190.                 'auxiliary_id': vals.get('debit_auxiliary_id', False),

  191.                 'currency_id': vals.get('currency_id'),

  192.                 'currency_amount': vals.get('amount'),

  193.                 'rate_silent': vals.get('rate_silent'),

  194.                 'init_obj': vals.get('init_obj', False),

  195.             })

  196.         else:   # 结算单上是本位币

  197.             self.env['voucher.line'].create({

  198.                 'name': "%s %s" % (vals.get('name'), vals.get('string')),

  199.                 'account_id': vals.get('debit_account_id'),

  200.                 'debit': debit,

  201.                 'voucher_id': vals.get('vouch_obj_id'),

  202.                 'partner_id': vals.get('partner_debit', ''),

  203.                 'auxiliary_id': vals.get('debit_auxiliary_id', False),

  204.                 'init_obj': vals.get('init_obj', False),

  205.             })

  206.         # 进项税行

  207.         if vals.get('buy_tax_amount'):

  208.             if not self.env.user.company_id.import_tax_account:

  209.                 raise UserError('请通过"配置-->高级配置-->公司"菜单来设置进项税科目')

  210.             self.env['voucher.line'].create({

  211.                 'name': "%s %s" % (vals.get('name'), vals.get('string')),

  212.                 'account_id': self.env.user.company_id.import_tax_account.id,

  213.                 'debit': vals.get('buy_tax_amount'),

  214.                 'voucher_id': vals.get('vouch_obj_id'),

  215.             })

  216.         # 贷方行

  217.         currency_id = vals.get(

  218.             'currency_id') or self.env.user.company_id.currency_id.id

  219.         if currency_id != self.env.user.company_id.currency_id.id:

  220.             self.env['voucher.line'].create({

  221.                 'name': "%s %s" % (vals.get('name'), vals.get('string')),

  222.                 'partner_id': vals.get('partner_credit', ''),

  223.                 'account_id': vals.get('credit_account_id'),

  224.                 'credit': credit,

  225.                 'voucher_id': vals.get('vouch_obj_id'),

  226.                 'auxiliary_id': vals.get('credit_auxiliary_id', False),

  227.                 'currency_amount': vals.get('amount'),

  228.                 'rate_silent': vals.get('rate_silent'),

  229.                 'currency_id': vals.get('currency_id'),

  230.                 'init_obj': vals.get('init_obj', False),

  231.             })

  232.         else:

  233.             self.env['voucher.line'].create({

  234.                 'name': "%s %s" % (vals.get('name'), vals.get('string')),

  235.                 'partner_id': vals.get('partner_credit', ''),

  236.                 'account_id': vals.get('credit_account_id'),

  237.                 'credit': credit,

  238.                 'voucher_id': vals.get('vouch_obj_id'),

  239.                 'auxiliary_id': vals.get('credit_auxiliary_id', False),

  240.                 'init_obj': vals.get('init_obj', False),

  241.             })

  242.         # 销项税行

  243.         if vals.get('sell_tax_amount'):

  244.             if not self.env.user.company_id.output_tax_account:

  245.                 raise UserError(

  246.                     '您还没有配置公司的销项税科目。\n请通过"配置-->高级配置-->公司"菜单来设置销项税科目!')

  247.             self.env['voucher.line'].create({

  248.                 'name': "%s %s" % (vals.get('name'), vals.get('string')),

  249.                 'account_id': self.env.user.company_id.output_tax_account.id,

  250.                 'credit': sell_tax_amount,

  251.                 'voucher_id': vals.get('vouch_obj_id'),

  252.             })

  253. 

  254.         return True
上海开阖软件有限公司 沪ICP备12045867号-1