Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

how is calculated the debit credit in account_account

By
Felipe
on 2/28/13, 4:05 PM 2,116 views

I found this line inside __compute, mapping{ in account.py

'debit': "COALESCE(SUM(l.debit), 0) as debit",

but I don't understand what is l.debit or l.credit also the parent_right parent_left mechanics

for the parent_right parent_left mechanics :see https://answers.launchpad.net/openobject-server/+question/186704

AD LIBITOM, michel Guénard
on 2/28/13, 6:06 PM

Thx thats good information

Felipe
on 3/3/13, 5:12 PM
0

Daniel Reis

--Daniel Reis--
3436
| 6 7 9
Lisbon, Portugal
--Daniel Reis--

Author of the "Odoo Development Essentials" book.

Applications Manager at Securitas Portugal

Github: https://github.com/dreispt

Twitter; @reis_pt


Daniel Reis
On 2/28/13, 6:14 PM

Debit and Credit are basic accounting concepts, used in the double-entry bookkeeping system.

COALESCE is this case works like Oracle's NVL and SQLServer's IsNull: COALESCE(a, b) returns a if a is not null, and returns b if a is null.

It safely defaults to a zero value if no data is found.

well I already knew all of that. What im asking is how the mapping to l.debit or other l. variables works, and how the parent_right and parent_left are generated and what is their role in the calculation.

Felipe
on 2/28/13, 8:24 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 2/28/13, 4:05 PM
Seen: 2116 times
Last updated: 3/16/15, 8:10 AM