> Comments inline.
>
> On Tue, Apr 27, 2010 at 9:04 AM, Jacques Le Roux <
>
[hidden email]> 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
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...
>
>>
>> Jacques
>>
>>
>>
>>>
>>> On Mon, Jan 18, 2010 at 3:44 PM, <
[hidden email]> 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:
[hidden email]]
>>>>> Sendt: 18. januar 2010 13:28
>>>>> Til:
[hidden email]
>>>>> Emne: Re: accounting
>>>>>
>>>>> Thanks Nicolas,
>>>>>
>>>>> Interesting to know this information.
>>>>>
>>>>> C'est bien de savoir cette information.
>>>>>
>>>>> Merci, thanks,
>>>>>
>>>>> Heidi
>>>>>
>>>>> 2010/1/18 <
[hidden email]>
>>>>>
>>>>> 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" <
[hidden email]>
>>>>>>> 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 <
[hidden email]>
>>>>>>>
>>>>>>> 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" <
[hidden email]>
>>>>>>>> Jacques,
>>>>>>>>
>>>>>>>> Is there source code available from tercompta?
>>>>>>>>
>>>>>>>> regards,
>>>>>>>> Heidi
>>>>>>>>
>>>>>>>> 2010/1/16 Info Olagos <
[hidden email]>
>>>>>>>>
>>>>>>>> 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 <
[hidden email]>
>>>>>>>>>
>>>>>>>>> Yes, it's the same in France
>>>>>>>>>
>>>>>>>>>
http://fr.wikipedia.org/wiki/Plan_comptable_%28France%29>>>>>>>>>>
>>>>>>>>>> Jacques
>>>>>>>>>>
>>>>>>>>>> From: "Info Olagos" <
[hidden email]>
>>>>>>>>>>
>>>>>>>>>> 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 <
[hidden email]>
>>>>>>>>>>
>>>>>>>>>> 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 <
[hidden email]>
>>>>>>>>>>>
>>>>>>>>>>> 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 <
[hidden email]>
>>>>>>>>>>>>
>>>>>>>>>>>> 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
>>>>>>>>>>>>>
>>>>>>>>>>>> <
[hidden email]>
>>>>>>
>>>>>>>
>>>>>>>>>>>>> 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.