Comment 4 for bug 722832

On 23. 02. 11 22:24, Frank Adler wrote:
> 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
hi again,looking to skr04, it seems pretty much correct, if you use the
"stock" version. however, if you have something in the profit/loss
account, that means that you closed the year, right?

unfortunatelly, this doesn't work too well, i filed a bug which was left
unanswered (#714787) Actually it was parked on the wrong line :-)) . in
my case, I created a special period, for the closing on 31.12, but
everything gets mixed.

in any case, i see the 2978 acc having liability as user type. if this
is not the case for you, start from there...

good luck!