Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
pythonodoo12
2 Vastaukset
7337 Näkymät
Avatar
Pamela Castaneda

Hello, could someone help me with the creation of journal entries?

I am creating a custom module and I want to create journal entries with a button, the problem I have is that if there is more than one line or product the values of my journal entries are always those of the first line or product, for example if I have 3 products 3 journal items are created but all take the same value which would be the first product.


this is my PY


    def action_entry(self):
        for rec in self:
            for line in rec.avg_landed_cost_lines:  
                debit = line.average_landed_cost    
                credit = line.average_landed_cost
                move = {
                    'name': '/',
                    'journal_id': rec.journal_id.id,
                    'date': rec.fecha,
                    'ref': rec.name,

                    'line_ids': [(0, 0, {
                        'name': line.product_id.name or '/',
                        'debit': debit,
                        'account_id': line.product_id.property_account_expense_id.id,
                        'partner_id': rec.order_id.partner_id.id,
                    }), (0, 0, {
                        'name': line.product_id.name or '/',
                        'credit': credit,
                        'account_id': line.product_id.property_account_income_id.id,
                        'partner_id': rec.order_id.partner_id.id,
                    })]
                }
                move_id = line.env['account.move'].create(move)
                move_id.post()
                return rec.write({'state': 'progress', 'move_id': move_id.id})


thanks!

Avatar
Hylkää
Avatar
Malay Khamar (Serpent Consulting Services Pvt. Ltd.)
Paras vastaus

Hi Pamela Castaneda,

Your line_ids is not updated. Please try this code. 

def action_entry(self):
    for rec in self:
        move = {
            'name': '/',
            'journal_id': rec.journal_id.id,
            'date': rec.fecha,
            'ref': rec.name,
        }
        line_ids = []
        for line in rec.avg_landed_cost_lines:
            debit = line.average_landed_cost
            credit = line.average_landed_cost

            line_ids += [(0, 0, {
                'name': line.product_id.name or '/',
                'debit': debit,
                'account_id': line.product_id.property_account_expense_id.id,
                'partner_id': rec.order_id.partner_id.id
                }), (0, 0, {
                    'name': line.product_id.name or '/',
                    'credit': credit,
                    'account_id': line.product_id.property_account_income_id.id,
                    'partner_id': rec.order_id.partner_id.id
                    })
                ]
        if line_ids:
            move.update({'line_ids': line_ids})
            move_id = line.env['account.move'].create(move)
            move_id.post()
            rec.write({'state': 'progress', 'move_id': move_id.id})
    return True



Hope it will help you.

Avatar
Hylkää
Avatar
Onestone Software LLP
Paras vastaus

Hi ,

You have not added the line product amount in you code just add line items amount field it will work . please refer the code below and re format the code.

def action_entry(self):
for rec in self:
for line in rec.avg_landed_cost_lines: 
 
move = {
'name': '/',
'journal_id': rec\\.journal_id\\.id,
\\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ 'date':\\ rec\\.fecha,
\\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ 'ref':\\ rec\\.name,

\\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ 'line_ids':\\ \\[\\(0,\\ 0,\\ \\{
\\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ 'name':\\ line\\.product_id\\.name\\ or\\ '/',
\\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ 'debit'_=\\ line\\.average_landed_cost 
\\ \\ \\ \\ \\ \\ 'credit'\\ =\\ line\\.average_landed_cost
\\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ 'account_id':\\ line\\.product_id\\.property_account_expense_id\\.id,
\\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ 'partner_id':\\ rec\\.order_id\\.partner_id\\.id,
\\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\}\\),\\ \\(0,\\ 0,\\ \\{
\\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ 'name':\\ line\\.product_id\\.name\\ or\\ '/',
\\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ 'debit'_=\\ line\\.average_landed_cost 
\\ \\ \\ \\ \\ \\ 'credit'\\ =\\ line\\.average_landed_cost
\\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ 'account_id':\\ line\\.product_id\\.property_account_income_id\\.id,
\\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ 'partner_id':\\ rec\\.order_id\\.partner_id\\.id,
\\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\}\\)\\]
\\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\}
\\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ move_id\\ =\\ line\\.env\\['account\\.move'\\]\\.create\\(move\\)
\\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ move_id\\.post\\(\\)
\\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ return\\ rec\\.write\\(\\{'state':\\ 'progress',\\ 'move_id':\\ move_id.id})

Avatar
Hylkää
Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
Two many2many fields related to each other inside one model Ratkaistu
python odoo12
Avatar
1
kesäk. 22
9220
how to make invoice date field readonly false for administrator after validating invoice in odoo12?
python odoo12
Avatar
Avatar
1
syysk. 21
3955
Update tax in invoice line
python odoo12
Avatar
0
elok. 21
95
How do I find Average Cost Function?
python odoo12
Avatar
0
heinäk. 21
172
How to make invoice date edit after validation only for admins in odoo 12?
python odoo12
Avatar
0
toukok. 21
2354