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

Remove Negative sign In COA Balance Column

By
Naveen
on 5/19/15, 3:36 AM 465 views

How to change Negative(-) sign to Postive(+)sign in Chart of accounts balance column

1
venkateshkumar
On 5/21/15, 7:38 AM

You can use absolute function for COA balance Field.

i.e Account.py file line No:289

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

Replace Line:

'balance': "ABS((COALESCE(SUM(l.debit),0) - COALESCE(SUM(l.credit), 0))) as balance",

He is right I think..

Saravanan Sakthivel
on 5/22/15, 12:30 AM

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

1 follower(s)

Stats

Asked: 5/19/15, 3:36 AM
Seen: 465 times
Last updated: 5/21/15, 7:40 AM