Create Journal Entries whit code

2 Odpovědi

7837 Zobrazení

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!

Malay Khamar

Nejlepší odpověď

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.

Onestone Software LLP

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})

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Přihlásit se

Related Posts	Odpovědi	Zobrazení
Two many2many fields related to each other inside one model Vyřešeno python odoo12	1 čvn 22	9639
how to make invoice date field readonly false for administrator after validating invoice in odoo12? python odoo12	1 zář 21	4259
Update tax in invoice line python odoo12	0 srp 21	95
How do I find Average Cost Function? python odoo12	0 čvc 21	172
How to make invoice date edit after validation only for admins in odoo 12? python odoo12	0 kvě 21	2634

This question has been flagged

Enjoying the discussion? Don't just read, join in!