account/Balance Sheet Report: accounts should show negative balances in case of credit asset or debit liability

Hello Stefan,

We can not print the balance with it's sign in report so I am not sure with this issue.
I am setting this issue in opinion for more clearance from Accounting Expert side.

Thanks.

On 22. 03. 11 13:48, Vinay Rana (openerp) wrote:
> Hello Stefan,
>
> We can not print the balance with it's sign in report so I am not sure with this issue.
> I am setting this issue in opinion for more clearance from Accounting Expert side.
>
> Thanks.
>
>
> ** Changed in: openobject-addons
> Status: New => Opinion
>
why is that?
i corrected this bug for me, i will submit a diff soon, if you like.

b

It seems like a possible solution is the one line below, and removing references to abs() from the balance sheet rml files when applied to account balances (not balance sheet totals). That leaves modifying the sxw source files, of course

--- account/report/account_balance_sheet.py 2011-01-14 00:11:01 +0000
+++ account/report/account_balance_sheet.py 2011-03-22 12:19:20 +0000
@@ -130,38 +130,40 @@
             accounts_temp = []
             for account in accounts:
                 if (account.user_type.report_type) and (account.user_type.report_type == typ):
                     account_dict = {
                         'id': account.id,
                         'code': account.code,
                         'name': account.name,
                         'level': account.level,
- 'balance':account.balance,
+ 'balance': (account.balance and typ == 'liability' and -1 or 1 ) * account.balance,
                     }
                     currency = account.currency_id and account.currency_id or account.company_id.currency_id
                     if typ == 'liability' and account.type <> 'view' and (account.debit <> account.credit):
                         self.result_sum_dr += account.balance
                     if typ == 'asset' and account.type <> 'view' and (account.debit <> account.credit):
                         self.result_sum_cr += account.balance
                     if data['form']['display_account'] == 'bal_movement':

Hello,

We are aware of this and a solution will be available soon.
We have decided to print the sign of the balance in reports. However, it happens sometimes that you might want to print a negative balance as positive and a positive balance as negative (eg: you generally want to see the income account as positive after making a sale even though the income account has been credited). To solve this, we will add a checkbox in the account form to reverse the balance sign printed on reports if desired.

Hi Bogdan,

As Fabrice (fhe) mentioned this is on the radar for being resolved.
This has been an issue for US accounting as well as we display some
accounts as negative in the balance sheet reports and on the actual
on-screen chart of accounts for accounts in assets, liabilities,
equity, income and expense. We see this in almost all areas of a
balance sheet for the contra accounts: Accumulated Depreciation,
Sales Discounts, Purchase Discounts, Distributions in Equity, etc.

My understanding is this would be resolved officially when 6.0.2 is released.

On Wed, Mar 23, 2011 at 12:28 AM, Vinay Rana (openerp)
<email address hidden> wrote:
> ** Changed in: openobject-addons
>   Importance: Undecided => Low
>
> ** Changed in: openobject-addons
>       Status: Opinion => Triaged
>
> ** Changed in: openobject-addons
>     Assignee: (unassigned) => OpenERP R&D Addons Team 3 (openerp-dev-addons3)
>
> --
> You received this bug notification because you are a member of OpenERP
> Drivers, which is subscribed to OpenERP Addons.
> https://bugs.launchpad.net/bugs/740132
>
> Title:
>  account/Balance Sheet Report: accounts should show negative balances
>  in case of credit asset or debit liability
>
> Status in OpenERP Modules (addons):
>  Triaged
>
> Bug description:
>  Hi,
>
>  in 6.0 and in trunk, when the balance sheet report is printed out, it
>  is impossible to point out asset accounts with a negative balance or a
>  liabilities with a positive balance. Consider the following situation:
>  an asset (say, a bank account) which happens to have a negative
>  balance does not show up with a negative sum. Therefore, it looks to
>  the employee as if the bank account has a positive balance. There are
>  a number of other scenarios in which this problem occurs, such as a
>  VAT return in case of a net loss.
>
>  Note that the end sum of the balance sheet is correct, but if you add
>  up all the numbers manually you end up with a different and wrong
>  number (the amounts are simply run through abs() in the RML).
>
>  Regards,
>  Stefan.
>

On 23. 03. 11 12:05, David Mitchell (www.novapointgroup.com) wrote:
> Hi Bogdan,
>
> As Fabrice (fhe) mentioned this is on the radar for being resolved.
> This has been an issue for US accounting as well as we display some
> accounts as negative in the balance sheet reports and on the actual
> on-screen chart of accounts for accounts in assets, liabilities,
> equity, income and expense. We see this in almost all areas of a
> balance sheet for the contra accounts: Accumulated Depreciation,
> Sales Discounts, Purchase Discounts, Distributions in Equity, etc.
>
> My understanding is this would be resolved officially when 6.0.2 is
> released.
>
> On Wed, Mar 23, 2011 at 12:28 AM, Vinay Rana (openerp)
> <email address hidden> wrote:
>> ** Changed in: openobject-addons
>> Importance: Undecided => Low
>>
>> ** Changed in: openobject-addons
>> Status: Opinion => Triaged
>>
>> ** Changed in: openobject-addons
>> Assignee: (unassigned) => OpenERP R&D Addons Team 3 (openerp-dev-addons3)
>>
>> --
>> You received this bug notification because you are a member of OpenERP
>> Drivers, which is subscribed to OpenERP Addons.
>> https://bugs.launchpad.net/bugs/740132
>>
>> Title:
>> account/Balance Sheet Report: accounts should show negative balances
>> in case of credit asset or debit liability
>>
>> Status in OpenERP Modules (addons):
>> Triaged
>>
>> Bug description:
>> Hi,
>>
>> in 6.0 and in trunk, when the balance sheet report is printed out, it
>> is impossible to point out asset accounts with a negative balance or a
>> liabilities with a positive balance. Consider the following situation:
>> an asset (say, a bank account) which happens to have a negative
>> balance does not show up with a negative sum. Therefore, it looks to
>> the employee as if the bank account has a positive balance. There are
>> a number of other scenarios in which this problem occurs, such as a
>> VAT return in case of a net loss.
>>
>> Note that the end sum of the balance sheet is correct, but if you add
>> up all the numbers manually you end up with a different and wrong
>> number (the amounts are simply run through abs() in the RML).
>>
>> Regards,
>> Stefan.
>>
fine with me, I just happen to have this specific issue solved, as it
blocked me some time ago. I am sure that the official solution will be
more complete.

regards,
b

i confirm too: it will be soon available in trunk.

Thanks for the contribution

Hi Quentin,

I know you guys are busy working on finalizing items for the community/partner days - do you have an ETA when the negative/positive balance field on the account will hit the production/stable system. I know you guys originally targeted 6.0.2 - but I'm not sure it made it through your testing to be included in that release based on your workload.

This issue is causing the users of the system here in the US to have to manually calculate the balance sheet and P&L statements and not be able to use the canned OpenERP reports without the negative/positive balance fields for the reports as FHE has mentioned. Basically, they have to export the data into Excel and then manipulate the data to show shareholders and owners today.

We can solve it with other code - but something as fundamental as this we need to really need to have it in the base system.

Could you advise with a quick update??

Thx.

customizable with account.financial.report