Overslaan naar inhoud
Menu
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Deze vraag is gerapporteerd
1 Beantwoorden
4305 Weergaven

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




Avatar
Annuleer
Beste antwoord

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

Avatar
Annuleer
Gerelateerde posts Antwoorden Weergaven Activiteit
4
feb. 24
4603
2
dec. 22
14801
1
nov. 22
2161
1
nov. 21
4927
0
jan. 21
2279