Re: SV: accounting

[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.
>
>