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, <malin.nico...@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.ola...@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.nico...@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.ola...@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.r...@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.ola...@gmail.com> > >> >> Jacques, > >> >> > >> >> Is there source code available from tercompta? > >> >> > >> >> regards, > >> >> Heidi > >> >> > >> >> 2010/1/16 Info Olagos <info.ola...@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.r...@les7arts.com> > >> >>> > >> >>> Yes, it's the same in France > >> >>> > >> >>>> http://fr.wikipedia.org/wiki/Plan_comptable_%28France%29 > >> >>>> > >> >>>> Jacques > >> >>>> > >> >>>> From: "Info Olagos" <info.ola...@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.schin...@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.ola...@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.schin...@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.cappell...@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 > >> >>>>> > >> >>>>> > >> >>>>> > >> >>>> > >> >>>> > >> >>> > >> >> > >> >> > >> > > >> > > >> > > >> > >> > >> > > > > > > >