Negative amount shown without sign on balance sheet

Bug #930283 reported by jlinkels
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Odoo Addons (MOVED TO GITHUB)
Invalid
Undecided
Unassigned

Bug Description

OpenERP server 6.0.3
GTK Client 6.0.3

When an account balance is negative in the G/L, it is nevertheless shown without sign on the balance sheet.

This yields the following weird situation.
Start with a database without any booking entries and all accounts on 0
Make this booking:

110510 PL Bank 1000D
110200 Debtors 1000C

In the G/L this shows up as
Debtors
Debit 0
Credit 1000
Balance -1000

PL Bank
Debit 1000
Credit 0
Balance 1000

On the balance sheet, this situation is now shown

Assets
PL Bank 1000
Debtors 1000

Balance 0

Now, Balance 0 is correct.
However, if you add all the amounts up you don't end op with 0

True, balance accounts should not be negative. Before presenting the balance sheet the Debtors account should have been
transferred to the Liability side.
But while checking the balance it is weird to see that a negative account balance is presented positive.
Without checking all accounts on the trial balance, it is impossible to find out where this goes wrong.

jlinkels

Revision history for this message
Ravish(OpenERP) (rmu-openerp) wrote :

Hello jlinkels,

I have checked your issue . But in trunk as well as in 6.1 balance sheet is already improved with printing negative sign .
It's not a blocking point . So we can't consider it. I have attached a screen shot(trunk) for your reference .

Thanks!!

Changed in openobject-addons:
status: New → Invalid
Revision history for this message
jlinkels (jlinkels) wrote :

I know there will be no development or bug fixing in 6.0

However, in 6.1 it is still wrong.

The image you posted shows:

Liability -4000
Assets 4000

That is not a correct balance sheet. In a balance sheet, both Assets and Liability should be equal. Furthermore, Net Profit has to be shown as a positive amount on the Liabilities site, Net Loss as a positive amount on the Assets side. It is necessary that negative signs are displayed, but this must be according to the balance of the account, while also considering the correct side of the balance sheet.

In 6.1 the P/L is not correct either. There is also a sign problem. In 6.1 you can now select the sign for accounts on PL. However, with the same sign selected, Income is negative (incorrect), while Revenues are positive (correct). See this post in the forum: http://www.openerp.com/forum/post101286.html#p101286

With all due respect, I would recommend the OpenERP development team to pay more attention to the basic technical issues of accounting reporting, not just the programming side. Both in 6.0 it was wrong, and in 6.1 there was a lot of development, and it is still not correct. Unfortunately, while a number of others and myself have tried to point out omissions in accounting reporting, and tried to help by explaining what was wrong, issues have been ignored or denied.

jlinkels

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.