ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Le Roux" <jacques.le.r...@les7arts.com>
Subject Re: SV: accounting
Date Tue, 27 Apr 2010 07:04:07 GMT
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, <malin.nicolas@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 <malin.nicolas@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" <info.olagos@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 <jacques.le.roux@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" <info.olagos@gmail.com>
>>>>>> Jacques,
>>>>>>
>>>>>> Is there source code available from tercompta?
>>>>>>
>>>>>> regards,
>>>>>> Heidi
>>>>>>
>>>>>> 2010/1/16 Info Olagos <info.olagos@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 <jacques.le.roux@les7arts.com>
>>>>>>>
>>>>>>> Yes, it's the same in France
>>>>>>>
>>>>>>>> http://fr.wikipedia.org/wiki/Plan_comptable_%28France%29
>>>>>>>>
>>>>>>>> Jacques
>>>>>>>>
>>>>>>>> From: "Info Olagos" <info.olagos@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.schinzer@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 <info.olagos@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.schinzer@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
>>>> <jacopo.cappellato@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 



Mime
View raw message