openerp-india team mailing list archive

[jlinkels <931022@xxxxxxxxxxxxxxxxxx>]

I use server version 6.0.3-0. This is  the stable version, I don't know what build that is. It can be found here:
http://www.openerp.com/download/stable/deb/openerp-server-6.0.3-0_all.deb

The steps to reproduce:
Create Demo database
Select only accounting module
Generic charts of accounts
Extended user interface
All other choices default.

Go to accounting -> Reporting -> Legal Reports -> Accounting Reports -> General Ledger
Ask to print the G/L WITH opening balance.
Opening balance is 0.00 on all accounts

Now go to accounting -> Customers -> Customer Invoices
Create new invoice for product EMPL for an amount of EUR 200,-
Including taxes the amount is EUR 230,-

Go to accounting -> Reporting -> Legal Reports -> Accounting Reports -> General Ledger
Ask to print the G/L withOUT opening balance. (leave the checkbox unchecked
The balance of DEBTORS is EUR 230,-
That is correct

Go to accounting -> Reporting -> Legal Reports -> Accounting Reports -> General Ledger
Ask to print the G/L WITH opening balance. (leave the checkbox unchecked
The balance of DEBTORS is EUR 460,-
That is NOT correct

Refer to both attachments.

jlinkels





** Attachment added: "Correct G/L without initial balance"
   https://bugs.launchpad.net/openobject-addons/+bug/931022/+attachment/2738878/+files/gl_without_initial_balance.pdf

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/931022

Title:
  Initial Balance numbers do not make sense and are added to account
  balances

Status in OpenERP Addons (modules):
  Incomplete

Bug description:
  Server version 6.0.3

  I am confused as of the meaning of "Initial Balance" in the General
  Ledger.

  I have used the Demo database. This database has been created in 2011
  and has never been used in 2012. The only fiscal year is 2011

  In this database there are a number of sales recorded and some credits recorded. When I open the General Ledger, I see this for the A/R:
  400000 Clients:
  Debit 2748,-
  Credit 6906,-
  Balance -4158,-

  Apparently this is the sum of all debits and credits entered on this
  account. This seems reasonable.

  Now I open the General Ledger again, but I include "Initial Balance" Now the A/R reads:
  400000 Clients:
  Debit 5496,-
  Credit 13812,-
  Balance -8316,-

  When I look at the entries, I see one entry at the top:
  * Initial Balance:
  Debit 2748,-
  Credit 6906,-
  Balance -4158,-

  Which is of course exactly the sum of all transactions on this
  account.

  This seems hopelessly incorrect. The balance of this account at the
  start of 2011 was zero. Now at the end of 2011 suddenly all
  transactions are being added to the Initial Balance. This makes the
  balance of the account exactly the double amount.

  I would not care about this too much, but I am having a hard in my
  real accounting system where something goes wrong with closing 2011
  and opening 2012. When I try to look at the initial balance in 2012
  (which should be the closing balance of 2011 in normal accounting
  systems) the initial balance doesn't make any sense. But as it seems
  there is no sense at all even when no year closure is made.

  jlinkels

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/931022/+subscriptions