Comment 3 for bug 722832

Revision history for this message
Frank Adler (frank-adler) wrote : Re: [Bug 722832] [NEW] Balance Sheet Report - Overall balance calculation error

Hi Bogdan,

you are spot on - I checked my accounts yesterday and it's the the net loss which gets added to assets and liabilities. I am using a German SKR04 CoA and it might be that I set the balancing account in the company details wrong. Just not sure which account it needs to be... The other odd thing is that all accounts have a ref nr, where as the net loss has the ref "net loss" so as if OpenERP itself just added it to the accounts in the end underneath the balancing account I specify.

Do you have a tip in terms of what account type etc. the balancing acct should be? ( or even which acct I need to use if you know the SKR04...at the moment it is set to "297800 Verlustvortrag vor Verwendung")

Cheers,
Frank

Sent from my iPad

On 24/02/2011, at 2:27, Bogdan Stanciu <email address hidden> wrote:

> On 22. 02. 11 10:07, Launchpad Bug Tracker wrote:
>> You have been subscribed to a public bug:
>>
>> Hi There,
>>
>> First bug I log here, so hope this is the right spot.
>>
>> Have recently installed version 6.0.1 straight from the main website
>> with a minimal module set to complete my annual statement (Balance
>> sheet, P&L) in OpenERP. After entering all transactions as journal
>> entries I went to Reporting | Legal Reports | Accounting Reports |
>> Balance sheet (One period, all entries, no filters). I noticed that the
>> overall balance is calculated incorrectly. If I manually add up all the
>> line items in the balance sheet I get to a total of 9.995.65 EUR
>> (consistently for assets and liabilities) whereas the report returns
>> 11626.82 EUR. I am only using standard modules with one exception which
>> is "account_cancel" and no currency calculations either.
>>
>> Since this would be pretty essential to any company running their
>> financials through OpenERP it would be great to get this fixed.
>>
>> Best Regards
>> Frank
>>
>> ** Affects: openobject-addons
>> Importance: Undecided
>> Status: New
>>
> as I went through this, let me make you attentive to one possible cause:
> either you have accounts that do not balance, or you have some accounts
> with the wrong type in your COA, and they get into the total.
>
> suggestion: take the difference and try to match it to some of your
> writings, and see if it does not go into a transitory account. then
> check the account's setting.
>
> good luck!
> bogdan
>
> --
> You received this bug notification because you are a direct subscriber
> of the bug.
> https://bugs.launchpad.net/bugs/722832
>
> Title:
> Balance Sheet Report - Overall balance calculation error
>
> Status in OpenERP Modules (addons):
> Invalid
>
> Bug description:
> Hi There,
>
> First bug I log here, so hope this is the right spot.
>
> Have recently installed version 6.0.1 straight from the main website
> with a minimal module set to complete my annual statement (Balance
> sheet, P&L) in OpenERP. After entering all transactions as journal
> entries I went to Reporting | Legal Reports | Accounting Reports |
> Balance sheet (One period, all entries, no filters). I noticed that
> the overall balance is calculated incorrectly. If I manually add up
> all the line items in the balance sheet I get to a total of 9.995.65
> EUR (consistently for assets and liabilities) whereas the report
> returns 11626.82 EUR. I am only using standard modules with one
> exception which is "account_cancel" and no currency calculations
> either.
>
> Since this would be pretty essential to any company running their
> financials through OpenERP it would be great to get this fixed.
>
> Best Regards
> Frank
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/openobject-addons/+bug/722832/+subscribe