← Back to team overview

c2c-oerpscenario team mailing list archive

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 <bogdanovidiu.stanciu@xxxxxxxxx>
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

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
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



Follow ups

References