Jonatan Soto wrote:
Comments inline.
On Tue, Apr 27, 2010 at 9:04 AM, Jacques Le Roux <
[email protected]> wrote:
Jonatan Soto wrote:
Hi,
I recover this topic because I'm working on the adaptation of the spanish
accountancy plan (Plan General Contable) to Ofbiz and I think it is
reusable
for other european countries and also to resolve some doubts.
In fact I am working on the low-medium sized companies PGC there is
another
one for bigger enterprises, but it doesn't matter.
The firsts steps I have done are:
- I've downloaded the PGC_ES_PYME.cvs from OpenBravo as Jeroen
recommended and it contains all the chart accounts.
- I've selected the columns that matches the *accountCode glAccountId
parentGlAccountId accountName glAccountClassId*. With a little regexp
and
string replacement I've generated a data xml. I've used OpenBravo
reference
to know the meanings of the columns (
http://wiki.openbravo.com/wiki/Creating_Accounts_Files)
Now, it seems that I have the PGC correctly loaded. I don't know if I have
to do more things in order to get the PGC fully integrated. I have some
doubts and I hope someone can point me to the right direction:
The first thing is related to
https://issues.apache.org/jira/browse/OFBIZ-3411. Regarding to point 1,
what
are intended for the changes of the parentGlAccountid? In my case I used a
few predefined in Ofbiz (asset, liability, revenue, expense, resource) as
was referenced on the OpenBravo document. I don't know I will experience
some side-effect because I have a very limited knowledge of how
accountancy
app works internally.
I left the GL_ACCOUNT_TYPE_ID and GL_RESOURCE_TYPE_ID with null values. In
this case I also don't know what can cause.
Another thing concerned to the adaptation is to know how to do auto
calculations for some accounts. In the spanish PGC there are a few
accounts
that are calculated using the values of another ones. It this possible by
default?
I don't know, but maybe using ECA?
Okay, I will investigate further so if I can find any OOTB way I will
develop a solution following this approach. Then I can create a Jira patch
and link it from the wiki or whatever.
Yes, sounds good. We will try to answer your questions as your will go forward
I am probably missing some questions, but I think they will come along the
time...
Thanks a lot!
PS: If it is the interest of somebody I can attach the spanish PGC I have
created to the jira or wiki.
Yes thanks, we could have a page in the wiki with this 1st effort going
on...
May you tell me the procedure that you would like to do that.
Create a page in the open wiki space (OFBiz (Open For Business) Project Open Wiki) and as you suggested refer to it from the Jira
issue you will create. We will see later how to organize things...
Thanks
Jacques
Jacques
On Mon, Jan 18, 2010 at 3:44 PM, <[email protected]> wrote:
No, or not writing by neogia team's. If I want revert Naccounting
improvement in OFBiz, it's the first operation that will do.
Nicolas
Is there a document (in English) that outlines the main differences
between
OFBiz accounting and the nAccounting?
Med vennlig hilsen
Torstein Hegbom
IT Polaris A/S
tlf: 95832697
-----Opprinnelig melding-----
Fra: Info Olagos [mailto:[email protected]]
Sendt: 18. januar 2010 13:28
Til: [email protected]
Emne: Re: accounting
Thanks Nicolas,
Interesting to know this information.
C'est bien de savoir cette information.
Merci, thanks,
Heidi
2010/1/18 <[email protected]>
Hello Heidi,
TerCompta works on neogia accounting components and not OFBiz
accounting
components. Why ? When I started five years ago on OFBiz we need an
accounting europeen system and we do an error to create a new component
(inspired from baan accounting system). I hope on next years, go back
on
ofbiz accounting and contribute tu main project.
But actually TerCompta is only an addon that embded easier screen to
make
accounting for small businness. It's use many addon :
naccounting-base : to manage account, period and entries
naccounting-integ : to use integration engine (you have some event in
your system and with define rules you up in you accounting entries by
fonctionnal event)
naccouting-french-document : contains an hierarchy account use to make
french income statement
(you can show all on addons.neogia.org/addons)
TerCompta do not have french account define, and you can create a new
addon with an other hierarchy account and income statement document for
an
other state with change TerCompta.
If you have more question, I am available ;)
Nicolas
Yes nAccounting is specific to Neogia. It *replaces* OFBiz accounting.
The
Noegia team is working (for one year now) on so called
"addons". And if I have well understood, when the addons mechanim will
be
released you will be able to plugin nAccounting in OFBiz.
I have always found weird their way of doing it (instead of using
hot-deploy overrides capabilities and such), but this is how
things are going...
Jacques
From: "Info Olagos" <[email protected]>
Hello,
I have downloaded the source code.
It is using a separate component naccounting.
Need to investigate it further. (so means i need time for all these
things....)
regards,
Heidi
2010/1/16 Jacques Le Roux <[email protected]>
Yes sure, it's maintained by Nicolas Malin from libreenberry
http://librenberry.net/spip.php?article21
I'm not quite sure about the licence, most of the time the Neogia
team
uses
GPL...
Jacques
From: "Info Olagos" <[email protected]>
Jacques,
Is there source code available from tercompta?
regards,
Heidi
2010/1/16 Info Olagos <[email protected]>
thanks Jacques,
very interesting info !
Seems to be quite the same as the belgium system but have to
investigate
it
further in detail.
regards,
Heidi
2010/1/16 Jacques Le Roux <[email protected]>
Yes, it's the same in France
http://fr.wikipedia.org/wiki/Plan_comptable_%28France%29
Jacques
From: "Info Olagos" <[email protected]>
Hello Carsten,
In some countries like in Belgium it is obliged to maintain a
minimum
definition of a chart of accounts in the accountancy.
So i think for these countries it is not to be defined as demo
data.
Perhaps other members of this list can inform me if the chart of
accounts
is
for a minimum legally binded by the member state in their country?
regards,
Heidi
2010/1/15 Carsten Schinzer <[email protected]>
Morning Heidi,
indeed I thought that as well, but finally, it's each company's
decision
which GL they would like to use; hence I rather think the demo
account
definitions are what they are: DEMO data. Hence to be customized
per
customer.
An option would be to define various "boilerplate" demo data sets
that
work,
e.g. a GL that reflects typical Charts of accounts.
Let me know your thoughts.
Regards
Carsten
2010/1/15 Info Olagos <[email protected]>
Carsten,
I think you should set also in your i18n document on wiki, the
DemoGeneralChartOfAccounts.xml GlAccount demo
to be localised.
Regards,
Heidi
2010/1/14 Carsten Schinzer <[email protected]>
Hi Jacopo,
well .... errrr .... sort of in the middle of it.
I can thus attach examples of what I did so far, but it's all
untested
yet.
I am especially stuck on the part t hat connects the GL
setting
to
OFBiz
specifics such as InvoiceItems, default accounts ..
I have included the reference to the WIKI doc on i18n (though
it
makes
sens
to boild out ideas on the wiki rather than on the JIRA ticket.
Regards
Carsten
2010/1/14 Jacopo Cappellato
<[email protected]>
Hi Carsten,
On Jan 14, 2010, at 12:19 PM, Carsten Schinzer wrote:
I do have an OFBiz config artifact containing the HGB Para
266
structure
as
XML Emtity Config for GlAccountingClasses.
Question: How to share this ... I could open a JIRA ticket for
improvement
and attach stuff there.
yes, please create a Jira ticket and attach the file or
patch
to
it;
contribution like this could go into the official project
(as
demo
data
that
is not loaded by default).
Do you have only gl account classes or a full chart of
accounts?
Kind regards,
Jacopo
--
Best
Carsten Schinzer
Waisenhausstr. 53a
80637 München
Germany
--
Best
Carsten Schinzer
Waisenhausstr. 53a
80637 München
Germany
Kind regards.
