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