You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Jonatan Soto <se...@gmail.com> on 2010/04/26 21:32:05 UTC
Re: SV: accounting
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 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.
On Mon, Jan 18, 2010 at 3:44 PM, <ma...@librenberry.net> 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:info.olagos@gmail.com]
> > Sendt: 18. januar 2010 13:28
> > Til: user@ofbiz.apache.org
> > Emne: Re: accounting
> >
> > Thanks Nicolas,
> >
> > Interesting to know this information.
> >
> > C'est bien de savoir cette information.
> >
> > Merci, thanks,
> >
> > Heidi
> >
> > 2010/1/18 <ma...@librenberry.net>
> >
> >> 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" <in...@gmail.com>
> >> > 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 <ja...@les7arts.com>
> >> >
> >> >> 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" <in...@gmail.com>
> >> >> Jacques,
> >> >>
> >> >> Is there source code available from tercompta?
> >> >>
> >> >> regards,
> >> >> Heidi
> >> >>
> >> >> 2010/1/16 Info Olagos <in...@gmail.com>
> >> >>
> >> >> 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 <ja...@les7arts.com>
> >> >>>
> >> >>> Yes, it's the same in France
> >> >>>
> >> >>>> http://fr.wikipedia.org/wiki/Plan_comptable_%28France%29
> >> >>>>
> >> >>>> Jacques
> >> >>>>
> >> >>>> From: "Info Olagos" <in...@gmail.com>
> >> >>>>
> >> >>>> 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 <c....@googlemail.com>
> >> >>>>
> >> >>>> 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 <in...@gmail.com>
> >> >>>>>
> >> >>>>> > 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 <c....@googlemail.com>
> >> >>>>> >
> >> >>>>> > > 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
> >> <ja...@hotwaxmedia.com>
> >> >>>>> > >
> >> >>>>> > > > 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
> >> >>>>>
> >> >>>>>
> >> >>>>>
> >> >>>>
> >> >>>>
> >> >>>
> >> >>
> >> >>
> >> >
> >> >
> >> >
> >>
> >>
> >>
> >
> >
>
>
>
Re: SV: accounting
Posted by Jacques Le Roux <ja...@les7arts.com>.
Hi Jonatan,
What happened finally?
Thanks
Jacques
From: "Jacques Le Roux" <ja...@les7arts.com>
> Jonatan Soto wrote:
>> Comments inline.
>>
>> On Tue, Apr 27, 2010 at 9:04 AM, Jacques Le Roux <
>> jacques.le.roux@les7arts.com> 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, <ma...@librenberry.net> 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:info.olagos@gmail.com]
>>>>>> Sendt: 18. januar 2010 13:28
>>>>>> Til: user@ofbiz.apache.org
>>>>>> Emne: Re: accounting
>>>>>>
>>>>>> Thanks Nicolas,
>>>>>>
>>>>>> Interesting to know this information.
>>>>>>
>>>>>> C'est bien de savoir cette information.
>>>>>>
>>>>>> Merci, thanks,
>>>>>>
>>>>>> Heidi
>>>>>>
>>>>>> 2010/1/18 <ma...@librenberry.net>
>>>>>>
>>>>>> 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" <in...@gmail.com>
>>>>>>>> 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 <ja...@les7arts.com>
>>>>>>>>
>>>>>>>> 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" <in...@gmail.com>
>>>>>>>>> Jacques,
>>>>>>>>>
>>>>>>>>> Is there source code available from tercompta?
>>>>>>>>>
>>>>>>>>> regards,
>>>>>>>>> Heidi
>>>>>>>>>
>>>>>>>>> 2010/1/16 Info Olagos <in...@gmail.com>
>>>>>>>>>
>>>>>>>>> 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 <ja...@les7arts.com>
>>>>>>>>>>
>>>>>>>>>> Yes, it's the same in France
>>>>>>>>>>
>>>>>>>>>> http://fr.wikipedia.org/wiki/Plan_comptable_%28France%29
>>>>>>>>>>>
>>>>>>>>>>> Jacques
>>>>>>>>>>>
>>>>>>>>>>> From: "Info Olagos" <in...@gmail.com>
>>>>>>>>>>>
>>>>>>>>>>> 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 <c....@googlemail.com>
>>>>>>>>>>>
>>>>>>>>>>> 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 <in...@gmail.com>
>>>>>>>>>>>>
>>>>>>>>>>>> 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 <c....@googlemail.com>
>>>>>>>>>>>>>
>>>>>>>>>>>>> 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
>>>>>>>>>>>>>>
>>>>>>>>>>>>> <ja...@hotwaxmedia.com>
>>>>>>>
>>>>>>>>
>>>>>>>>>>>>>> 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.
>
>
Re: SV: accounting
Posted by Jacques Le Roux <ja...@les7arts.com>.
Jonatan Soto wrote:
> Comments inline.
>
> On Tue, Apr 27, 2010 at 9:04 AM, Jacques Le Roux <
> jacques.le.roux@les7arts.com> 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, <ma...@librenberry.net> 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:info.olagos@gmail.com]
>>>>> Sendt: 18. januar 2010 13:28
>>>>> Til: user@ofbiz.apache.org
>>>>> Emne: Re: accounting
>>>>>
>>>>> Thanks Nicolas,
>>>>>
>>>>> Interesting to know this information.
>>>>>
>>>>> C'est bien de savoir cette information.
>>>>>
>>>>> Merci, thanks,
>>>>>
>>>>> Heidi
>>>>>
>>>>> 2010/1/18 <ma...@librenberry.net>
>>>>>
>>>>> 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" <in...@gmail.com>
>>>>>>> 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 <ja...@les7arts.com>
>>>>>>>
>>>>>>> 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" <in...@gmail.com>
>>>>>>>> Jacques,
>>>>>>>>
>>>>>>>> Is there source code available from tercompta?
>>>>>>>>
>>>>>>>> regards,
>>>>>>>> Heidi
>>>>>>>>
>>>>>>>> 2010/1/16 Info Olagos <in...@gmail.com>
>>>>>>>>
>>>>>>>> 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 <ja...@les7arts.com>
>>>>>>>>>
>>>>>>>>> Yes, it's the same in France
>>>>>>>>>
>>>>>>>>> http://fr.wikipedia.org/wiki/Plan_comptable_%28France%29
>>>>>>>>>>
>>>>>>>>>> Jacques
>>>>>>>>>>
>>>>>>>>>> From: "Info Olagos" <in...@gmail.com>
>>>>>>>>>>
>>>>>>>>>> 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 <c....@googlemail.com>
>>>>>>>>>>
>>>>>>>>>> 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 <in...@gmail.com>
>>>>>>>>>>>
>>>>>>>>>>> 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 <c....@googlemail.com>
>>>>>>>>>>>>
>>>>>>>>>>>> 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
>>>>>>>>>>>>>
>>>>>>>>>>>> <ja...@hotwaxmedia.com>
>>>>>>
>>>>>>>
>>>>>>>>>>>>> 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.
Re: SV: accounting
Posted by Jonatan Soto <se...@gmail.com>.
Comments inline.
On Tue, Apr 27, 2010 at 9:04 AM, Jacques Le Roux <
jacques.le.roux@les7arts.com> 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.
>
>
> 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.
>
> Jacques
>
>
>
>>
>> On Mon, Jan 18, 2010 at 3:44 PM, <ma...@librenberry.net> 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:info.olagos@gmail.com]
>>>> Sendt: 18. januar 2010 13:28
>>>> Til: user@ofbiz.apache.org
>>>> Emne: Re: accounting
>>>>
>>>> Thanks Nicolas,
>>>>
>>>> Interesting to know this information.
>>>>
>>>> C'est bien de savoir cette information.
>>>>
>>>> Merci, thanks,
>>>>
>>>> Heidi
>>>>
>>>> 2010/1/18 <ma...@librenberry.net>
>>>>
>>>> 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" <in...@gmail.com>
>>>>>> 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 <ja...@les7arts.com>
>>>>>>
>>>>>> 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" <in...@gmail.com>
>>>>>>> Jacques,
>>>>>>>
>>>>>>> Is there source code available from tercompta?
>>>>>>>
>>>>>>> regards,
>>>>>>> Heidi
>>>>>>>
>>>>>>> 2010/1/16 Info Olagos <in...@gmail.com>
>>>>>>>
>>>>>>> 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 <ja...@les7arts.com>
>>>>>>>>
>>>>>>>> Yes, it's the same in France
>>>>>>>>
>>>>>>>> http://fr.wikipedia.org/wiki/Plan_comptable_%28France%29
>>>>>>>>>
>>>>>>>>> Jacques
>>>>>>>>>
>>>>>>>>> From: "Info Olagos" <in...@gmail.com>
>>>>>>>>>
>>>>>>>>> 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 <c....@googlemail.com>
>>>>>>>>>
>>>>>>>>> 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 <in...@gmail.com>
>>>>>>>>>>
>>>>>>>>>> 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 <c....@googlemail.com>
>>>>>>>>>>>
>>>>>>>>>>> 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
>>>>>>>>>>>>
>>>>>>>>>>> <ja...@hotwaxmedia.com>
>>>>>
>>>>>>
>>>>>>>>>>>> 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.
Re: SV: accounting
Posted by Jacques Le Roux <ja...@les7arts.com>.
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?
> 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...
Jacques
>
>
> On Mon, Jan 18, 2010 at 3:44 PM, <ma...@librenberry.net> 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:info.olagos@gmail.com]
>>> Sendt: 18. januar 2010 13:28
>>> Til: user@ofbiz.apache.org
>>> Emne: Re: accounting
>>>
>>> Thanks Nicolas,
>>>
>>> Interesting to know this information.
>>>
>>> C'est bien de savoir cette information.
>>>
>>> Merci, thanks,
>>>
>>> Heidi
>>>
>>> 2010/1/18 <ma...@librenberry.net>
>>>
>>>> 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" <in...@gmail.com>
>>>>> 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 <ja...@les7arts.com>
>>>>>
>>>>>> 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" <in...@gmail.com>
>>>>>> Jacques,
>>>>>>
>>>>>> Is there source code available from tercompta?
>>>>>>
>>>>>> regards,
>>>>>> Heidi
>>>>>>
>>>>>> 2010/1/16 Info Olagos <in...@gmail.com>
>>>>>>
>>>>>> 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 <ja...@les7arts.com>
>>>>>>>
>>>>>>> Yes, it's the same in France
>>>>>>>
>>>>>>>> http://fr.wikipedia.org/wiki/Plan_comptable_%28France%29
>>>>>>>>
>>>>>>>> Jacques
>>>>>>>>
>>>>>>>> From: "Info Olagos" <in...@gmail.com>
>>>>>>>>
>>>>>>>> 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 <c....@googlemail.com>
>>>>>>>>
>>>>>>>> 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 <in...@gmail.com>
>>>>>>>>>
>>>>>>>>>> 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 <c....@googlemail.com>
>>>>>>>>>>
>>>>>>>>>>> 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
>>>> <ja...@hotwaxmedia.com>
>>>>>>>>>>>
>>>>>>>>>>>> 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