> 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?
develop a solution following this approach. Then I can create a Jira patch
>
> 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
>>>>>>>>>>
>>>>>>>>>
>
>