跳至內容
選單
此問題已被標幟
1 回覆
4304 瀏覽次數

I added field to 

account\.move\.line\ and\ i\\ need\\ to\\ show\\ it\\ in\\ General\\ Ledger\\ as\\ a\\ acolumn\\ after\\ Debit\\ for\\ example

I\\ create\\ this\\ code

class\\ AccountMove\\(models\\.Model\\):
\\ \\ \\ \\ _inherit\\ =\\ 'account\\.move\\.line'

\\ \\ \\ \\
hat_qty\\ =\\ fields\\.Float\\(string="QTY",\\ compute='_compute_hat_qty',\\ store=True\\)

\
\\ \\ \\ \\ \
\\ \\ \\ \\ \\ \\ \\ \\ \
\\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \account.report.column">
/> hat_qty
line.hat_qty
Hat Qty
none




頭像
捨棄
最佳答案

Hi,

First of all, you need to inherit the account.partner.ledger and after  need to customize the query and add the fields to that query Also you need to update the columns

class AccountPartnerLedger(models.AbstractModel):
    _inherit = 'account.partner.ledger'

    def _get_columns_name(self, options):
        res = super(AccountPartnerLedger, self)._get_columns_name(options)
        if options['unreconciled']:
            dict = [{'name': _('Unpaid'), 'class': 'number'}]
            for d in dict:
                res.append(d)
        res.append({'name': _('Last Payment Date'), 'class': 'number'})
        return res
       
    //You can super the _get_columns_name function based on the above code that will help to add the column at the end of the report, once you need to add in between any field then try overriding the given function.
   
   
    // override the _get_report_line_move_line function to add records based on the particular column otherwise you need to try this code
   
def _get_report_line_move_line(self, options, partner, aml, cumulated_init_balance, cumulated_balance):

   res = super(AccountPartnerLedger, self)._get_report_line_move_line(options, partner, aml,
                                                              cumulated_init_balance,
                                                              cumulated_balance)
   res['columns'].append({'name': self.format_report_date(aml['hat_qty']), 'class': 'number'})
   
   return res
   
   
    also try to override the given functions _get_lines_without_partner, _get_query_amls
   
    In the query add your field like account_move_line.hat_qty,


Hope it helps

頭像
捨棄
相關帖文 回覆 瀏覽次數 活動
4
2月 24
4600
2
12月 22
14799
1
11月 22
2160
1
11月 21
4927
0
1月 21
2279