Skip to Content
Menu
This question has been flagged
1 Reply
3289 Views

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

Avatar
Discard
Best Answer

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",

Avatar
Discard

He is right I think..