openerp-expert-accounting team mailing list archive

[Luciano Spiegel <l.spiegel@xxxxxxxxx>]

Hi fellows,
I'm pretty new using openERP and we installed v6.1 in our company. We are
setting it up for our organization right now.

We are facing an issue involving Bank Statements and Analytic
Distributions, that don't know if it's a bug, a misconfiguraction or the
way that openERP works that is not consistent. I will try to explain it as
simple as possible.
We want to put all the tickets expenses we do in bank transactions in one
Analytic Account. They are not like supplier invoices.

We create a new Bank Statement (belongs to Journal "Bank" associated to
Account "Bank Account")
with 1 Transaction (Statement Line) to the Account "Purchase Account", we
chose Analytic Distribution "100% to Analytic Account Purchases", Amount
"-50".

We Post It. It creates the 2 Journal Items, for the reconciliation, that's
correct.
one with Debit = "50", Account = "Purchase Account"
one with Credit = "50", Account = "Bank Account"

But the issue comes here.
Both Journal items have been created with the Analytic Distribution
"100% to Analytic Account Purchases"
When we check the Analytic Account, "Analytic Account Purchases" we found
that there are 2 items computed to that Analyitc Account, the 2 Journal
Items created:
one with Amount = "-50", Account = "Purchase Account"
one with Amount = "50", Account = "Bank Account"

So the total balance for that Analytic Account is zero, which is not
correct. That Analytic Account should be -50, with the Purchase we attached
to it in the Bank Statement.
The solution is as simple as not assign the Analytic Distribution selected
in the Statement Line to the Journal Entry created for the credit in "Bank
Account", but this is done internally in openERP.
(There is a way to edit it manually from the Journal Items list an change
the assignation of that Analytic Distribution, which correct the problem
but it's really a good solution to do that for every single Statement Line
we create)

I hope I'm clear in my problem and I ask you for advice to solve it
Thanks in advance.