Passa al contenuto
È necessario essere registrati per interagire con la community.
Tutti gli articoli Persone Badge
Etichette (Mostra tutto)
odoo accounting v14 pos v15
Sul forum
La domanda è stata contrassegnata
accountingaccount_balancejournal_itemversion13
1 Rispondi
3858 Visualizzazioni
Avatar
Dhananjay Patil

Hi everyone,
Currently I have 60k account.move.line records in my system, and i have to set a value of compute field so while the compute runs it takes lot of time to set the value in field for 60k records...
Please advise me how can I optimize that.
This is on priority ,  I have pasted the method below to make my question more clear
Thanks in Advance


Compute Method:

line_obj = self.env['account.move.line']
for rec in self:
    if rec.account_id:
        query = """SELECT sum(balance) from account_move_line where account_id = %s and create_date < %s and date <= %s and id != %s """
        self.env.cr.execute(query, (rec.account_id.id, rec.create_date, rec.date, rec.id))
        running_balance = self.env.cr.fetchone()[0] or 0.0
        if rec.debit:
            running_balance += rec.debit
        if rec.credit:
            running_balance -= rec.credit
        rec.running_balance = running_balance
    else:
        rec.running_balance = 0.00






Avatar
Abbandona
Dhananjay Patil
Autore
I have already stored that value as I need that field in some report.
I know that it will obviously take take...I just wanted a efficient way that it can reduce somewhat time.

On Mon, Oct 18, 2021, 11:26 PM Devendra Kavthekar <dkatodoo@gmail.com> wrote:

A new answer on How can I improve Performance of Compute method in Account Move Line has been posted. Click here to access the post :

See post

Sent by Odoo S.A. using Odoo.

Avatar
Devendra Kavthekar
Risposta migliore

You can do this in batch of 10k records or minimum amount of records possible that can allow the commit to happen.

Not sure about the purpose - but it will take more time of course if the query is performed on large dataset.

By the way, it seems you need to:

Do:

date <= %s and id == %s """

Instead of:

date <= %s and id != %s """
?


As a side note, may be you already know:

Dont write compute methods at all, best way if possible. Use create/write or other methods instead.

And if you must write compute method - make it stored when possible.

Avatar
Abbandona
Post correlati Risposte Visualizzazioni Attività
What is "Matching Number" in a Journal Item? Risolto
accounting journal_entry journal_item
Avatar
Avatar
Avatar
3
dic 19
8679
Balance sheet report at specific point of time in odoo8
accounting account_balance odoo8.0
Avatar
0
lug 15
3886
I HAVE AN DOLLAR , EURO TRANSACTIONS I WANT TO GET TOTAL FOR EACH FOREIGN CURRENCY AND HOW MUCH DOLLAR AND EURO I OWE IN EACH JOURNAL
accounting currency journal_entry journal_item
Avatar
0
mag 25
853
Using fiscal year in pivot and spreadsheets
accounting reporting pivot journal_item
Avatar
2
mar 25
376
After Making Vendor payment Bill still in Posted state and Payment Journal Items showing zero values
accounting journal_item vendorbill Odoo16
Avatar
Avatar
1
giu 24
1891