You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Adrian Stern <ar...@gmail.com> on 2014/02/04 10:22:54 UTC
Re: Implementing Chart of Accounts for Switzerland (Or any country
for that matter)
I've not come much further on this topic. I started creating my own CoA but
having problems filling out the fields glAccountClassId and
glAccountTypeId.
I did find some explanation about those fields in
the ManagerReferenceAccounting.pdf, but i am still unsure if i'm on the
right track.
Are there any German speaking people in this mailing list? Or someone who
has done this before?
This is my very first task in ofbiz... so i'm kind of lost.
I've found the translations of this classes and types
in config/AccountingEntityLabels.xml but i lack some explaining...
Are there any accounts that absolutley have to be used or are all of them
more or less optional and ofbiz knows of its own what to do whith the one
available?
Regards,
Adrian
On 28 January 2014 20:57, Adrian Stern <ar...@gmail.com> wrote:
> Hello
>
> I'm looking for Information about implementing a completely new chart of
> accounts. I think i actually found everything important, but i still want
> to ask about some random input and a share of your experiences.
>
> So. As i understand the first Step is to create the global chart (tree) as
> the example "data/DemoGeneralChartOfAccounts.xml" states. This will result
> in the entries in
>
> Accounting -> Global GL Settings
>
> And with that, i can configure the Organization GL Settings which are
> specific to my needs.
>
> 1. Could there be any dependencies one has to take care of when using a
> different chart of accounts?
>
> 2. Is there an "OFBiz"-Way for doing that? Since this Chart is not part of
> ofbiz, should i keep it in the hot-deploy folder? How do you organize?
>
> 3. How do i tell ofbiz to use not the Demo tree but my own, after creating
> it? Grep reveals a number of files using DemoGeneralChartOfAccounts.xml but
> i bet there is a Global setting somewhere. Well. Probably just
> ofbiz-component.xml and SetupEvents.xml...
>
> Regards, Adrian
>
>
Re: Implementing Chart of Accounts for Switzerland (Or any country
for that matter)
Posted by Adrian Stern <ar...@gmail.com>.
Hi Jacques
We're currently working with this tree. But as it seems the paths are not
absolute.
glAccountId=300000 -> Equity (Equity)is
glAccountId=310000 -> OwnersEquity (Equity - OwnersEquity)
glAccountId=311000 -> ReturnOfCapital (Distribution - ReturnOfCapital)
While the first two are in the same branch, ReturnOfCapital is in the
Branch of Distribution.
This tells us that it is not important to stay in one branch but instead it
is sometimes necessary to switch branches like in the example above.
Is there some policy for the usage of this classes? And also ist there a
similiar list for the glAccountTypeId's?
On 4 February 2014 13:31, Jacques Le Roux <ja...@les7arts.com>wrote:
> This might help http://markmail.org/message/uq7w4snax3w7gyrk
>
> Jacques
>
> On Tuesday, February 04, 2014 1:01 PM, archdove@gmail.com wrote
> > Hi Igor
> >
> > Thanks for your links. The italian chart did not help much. It differs
> too
> > much and i'm not able to find clear matches (because of the langage
> barrier
> > probably). I could find a relevant download from XBRL-CH.ch however this
> > one is from 2011 and there was a revision in 2013.
> > I would say we can solve about 1/4 to 1/3 with the files available so far
> > whith matching it against the demo chart.
> >
> > What i'm looking for know is an explanation about what glAccountType and
> > glAccountClass actually do -> what they are used for.
> > Also there are some other types which are not glAccountType or Class
> which
> > would match by description. Like:
> GlResourceType.description.RAW_MATERIALS
> > which would be what we're looking for but it is not an account type but a
> > Resource Type.
> >
> > Looks like we have to build our own from scratch...
> >
> >
> >
> > On 4 February 2014 11:16, Igor Gallingani <ig...@gmail.com>
> wrote:
> >
> >> I forgot
> >>
> >> glAccountType in italian is translated as "causale contabile" ==
> >> "???kausalen Konten??? or ???Buchhalter ????" (google )
> >> glAccountClass = the class of the account
> >>
> >>
> >> 2014-02-04 Igor Gallingani <ig...@gmail.com>:
> >>
> >>> I hope it can be useful. This chart of accounts is based on
> >>> http://www2.xbrl.org//it/.
> >>> You can compare it with http://www.xbrl.de/.
> >>>
> >>>
> >>> 2014-02-04 Adrian Stern <ar...@gmail.com>:
> >>>
> >>> I've not come much further on this topic. I started creating my own CoA
> >> but
> >>>> having problems filling out the fields glAccountClassId and
> >>>> glAccountTypeId.
> >>>> I did find some explanation about those fields in
> >>>> the ManagerReferenceAccounting.pdf, but i am still unsure if i'm on
> the
> >>>> right track.
> >>>>
> >>>> Are there any German speaking people in this mailing list? Or someone
> who
> >>>> has done this before?
> >>>> This is my very first task in ofbiz... so i'm kind of lost.
> >>>>
> >>>> I've found the translations of this classes and types
> >>>> in config/AccountingEntityLabels.xml but i lack some explaining...
> >>>>
> >>>> Are there any accounts that absolutley have to be used or are all of
> them
> >>>> more or less optional and ofbiz knows of its own what to do whith the
> one
> >>>> available?
> >>>>
> >>>> Regards,
> >>>> Adrian
> >>>>
> >>>>
> >>>> On 28 January 2014 20:57, Adrian Stern <ar...@gmail.com> wrote:
> >>>>
> >>>>> Hello
> >>>>>
> >>>>> I'm looking for Information about implementing a completely new
> chart of
> >>>>> accounts. I think i actually found everything important, but i still
> want
> >>>>> to ask about some random input and a share of your experiences.
> >>>>>
> >>>>> So. As i understand the first Step is to create the global chart
> (tree) as
> >>>>> the example "data/DemoGeneralChartOfAccounts.xml" states. This will
> result
> >>>>> in the entries in
> >>>>>
> >>>>> Accounting -> Global GL Settings
> >>>>>
> >>>>> And with that, i can configure the Organization GL Settings which are
> >>>>> specific to my needs.
> >>>>>
> >>>>> 1. Could there be any dependencies one has to take care of when
> using a
> >>>>> different chart of accounts?
> >>>>>
> >>>>> 2. Is there an "OFBiz"-Way for doing that? Since this Chart is not
> part of
> >>>>> ofbiz, should i keep it in the hot-deploy folder? How do you
> organize?
> >>>>>
> >>>>> 3. How do i tell ofbiz to use not the Demo tree but my own, after
> creating
> >>>>> it? Grep reveals a number of files using
> DemoGeneralChartOfAccounts.xml but
> >>>>> i bet there is a Global setting somewhere. Well. Probably just
> >>>>> ofbiz-component.xml and SetupEvents.xml...
> >>>>>
> >>>>> Regards, Adrian
>
Re: Implementing Chart of Accounts for Switzerland (Or any country
for that matter)
Posted by Jacques Le Roux <ja...@les7arts.com>.
This might help http://markmail.org/message/uq7w4snax3w7gyrk
Jacques
On Tuesday, February 04, 2014 1:01 PM, archdove@gmail.com wrote
> Hi Igor
>
> Thanks for your links. The italian chart did not help much. It differs too
> much and i'm not able to find clear matches (because of the langage barrier
> probably). I could find a relevant download from XBRL-CH.ch however this
> one is from 2011 and there was a revision in 2013.
> I would say we can solve about 1/4 to 1/3 with the files available so far
> whith matching it against the demo chart.
>
> What i'm looking for know is an explanation about what glAccountType and
> glAccountClass actually do -> what they are used for.
> Also there are some other types which are not glAccountType or Class which
> would match by description. Like: GlResourceType.description.RAW_MATERIALS
> which would be what we're looking for but it is not an account type but a
> Resource Type.
>
> Looks like we have to build our own from scratch...
>
>
>
> On 4 February 2014 11:16, Igor Gallingani <ig...@gmail.com> wrote:
>
>> I forgot
>>
>> glAccountType in italian is translated as "causale contabile" ==
>> "???kausalen Konten??? or ???Buchhalter ????" (google )
>> glAccountClass = the class of the account
>>
>>
>> 2014-02-04 Igor Gallingani <ig...@gmail.com>:
>>
>>> I hope it can be useful. This chart of accounts is based on
>>> http://www2.xbrl.org//it/.
>>> You can compare it with http://www.xbrl.de/.
>>>
>>>
>>> 2014-02-04 Adrian Stern <ar...@gmail.com>:
>>>
>>> I've not come much further on this topic. I started creating my own CoA
>> but
>>>> having problems filling out the fields glAccountClassId and
>>>> glAccountTypeId.
>>>> I did find some explanation about those fields in
>>>> the ManagerReferenceAccounting.pdf, but i am still unsure if i'm on the
>>>> right track.
>>>>
>>>> Are there any German speaking people in this mailing list? Or someone who
>>>> has done this before?
>>>> This is my very first task in ofbiz... so i'm kind of lost.
>>>>
>>>> I've found the translations of this classes and types
>>>> in config/AccountingEntityLabels.xml but i lack some explaining...
>>>>
>>>> Are there any accounts that absolutley have to be used or are all of them
>>>> more or less optional and ofbiz knows of its own what to do whith the one
>>>> available?
>>>>
>>>> Regards,
>>>> Adrian
>>>>
>>>>
>>>> On 28 January 2014 20:57, Adrian Stern <ar...@gmail.com> wrote:
>>>>
>>>>> Hello
>>>>>
>>>>> I'm looking for Information about implementing a completely new chart of
>>>>> accounts. I think i actually found everything important, but i still want
>>>>> to ask about some random input and a share of your experiences.
>>>>>
>>>>> So. As i understand the first Step is to create the global chart (tree) as
>>>>> the example "data/DemoGeneralChartOfAccounts.xml" states. This will result
>>>>> in the entries in
>>>>>
>>>>> Accounting -> Global GL Settings
>>>>>
>>>>> And with that, i can configure the Organization GL Settings which are
>>>>> specific to my needs.
>>>>>
>>>>> 1. Could there be any dependencies one has to take care of when using a
>>>>> different chart of accounts?
>>>>>
>>>>> 2. Is there an "OFBiz"-Way for doing that? Since this Chart is not part of
>>>>> ofbiz, should i keep it in the hot-deploy folder? How do you organize?
>>>>>
>>>>> 3. How do i tell ofbiz to use not the Demo tree but my own, after creating
>>>>> it? Grep reveals a number of files using DemoGeneralChartOfAccounts.xml but
>>>>> i bet there is a Global setting somewhere. Well. Probably just
>>>>> ofbiz-component.xml and SetupEvents.xml...
>>>>>
>>>>> Regards, Adrian
Re: Implementing Chart of Accounts for Switzerland (Or any country
for that matter)
Posted by Adrian Stern <ar...@gmail.com>.
Hi Igor
Thanks for your links. The italian chart did not help much. It differs too
much and i'm not able to find clear matches (because of the langage barrier
probably). I could find a relevant download from XBRL-CH.ch however this
one is from 2011 and there was a revision in 2013.
I would say we can solve about 1/4 to 1/3 with the files available so far
whith matching it against the demo chart.
What i'm looking for know is an explanation about what glAccountType and
glAccountClass actually do -> what they are used for.
Also there are some other types which are not glAccountType or Class which
would match by description. Like: GlResourceType.description.RAW_MATERIALS
which would be what we're looking for but it is not an account type but a
Resource Type.
Looks like we have to build our own from scratch...
On 4 February 2014 11:16, Igor Gallingani <ig...@gmail.com> wrote:
> I forgot
>
> glAccountType in italian is translated as "causale contabile" ==
> "???kausalen Konten??? or ???Buchhalter ????" (google )
> glAccountClass = the class of the account
>
>
> 2014-02-04 Igor Gallingani <ig...@gmail.com>:
>
> > I hope it can be useful. This chart of accounts is based on
> > http://www2.xbrl.org//it/.
> > You can compare it with http://www.xbrl.de/.
> >
> >
> > 2014-02-04 Adrian Stern <ar...@gmail.com>:
> >
> > I've not come much further on this topic. I started creating my own CoA
> but
> >> having problems filling out the fields glAccountClassId and
> >> glAccountTypeId.
> >> I did find some explanation about those fields in
> >> the ManagerReferenceAccounting.pdf, but i am still unsure if i'm on the
> >> right track.
> >>
> >> Are there any German speaking people in this mailing list? Or someone
> who
> >> has done this before?
> >> This is my very first task in ofbiz... so i'm kind of lost.
> >>
> >> I've found the translations of this classes and types
> >> in config/AccountingEntityLabels.xml but i lack some explaining...
> >>
> >> Are there any accounts that absolutley have to be used or are all of
> them
> >> more or less optional and ofbiz knows of its own what to do whith the
> one
> >> available?
> >>
> >> Regards,
> >> Adrian
> >>
> >>
> >> On 28 January 2014 20:57, Adrian Stern <ar...@gmail.com> wrote:
> >>
> >> > Hello
> >> >
> >> > I'm looking for Information about implementing a completely new chart
> of
> >> > accounts. I think i actually found everything important, but i still
> >> want
> >> > to ask about some random input and a share of your experiences.
> >> >
> >> > So. As i understand the first Step is to create the global chart
> (tree)
> >> as
> >> > the example "data/DemoGeneralChartOfAccounts.xml" states. This will
> >> result
> >> > in the entries in
> >> >
> >> > Accounting -> Global GL Settings
> >> >
> >> > And with that, i can configure the Organization GL Settings which are
> >> > specific to my needs.
> >> >
> >> > 1. Could there be any dependencies one has to take care of when using
> a
> >> > different chart of accounts?
> >> >
> >> > 2. Is there an "OFBiz"-Way for doing that? Since this Chart is not
> part
> >> of
> >> > ofbiz, should i keep it in the hot-deploy folder? How do you organize?
> >> >
> >> > 3. How do i tell ofbiz to use not the Demo tree but my own, after
> >> creating
> >> > it? Grep reveals a number of files using
> DemoGeneralChartOfAccounts.xml
> >> but
> >> > i bet there is a Global setting somewhere. Well. Probably just
> >> > ofbiz-component.xml and SetupEvents.xml...
> >> >
> >> > Regards, Adrian
> >> >
> >> >
> >>
> >
> >
>
Re: Implementing Chart of Accounts for Switzerland (Or any country
for that matter)
Posted by Igor Gallingani <ig...@gmail.com>.
I forgot
glAccountType in italian is translated as "causale contabile" ==
"???kausalen Konten??? or ???Buchhalter ????" (google )
glAccountClass = the class of the account
2014-02-04 Igor Gallingani <ig...@gmail.com>:
> I hope it can be useful. This chart of accounts is based on
> http://www2.xbrl.org//it/.
> You can compare it with http://www.xbrl.de/.
>
>
> 2014-02-04 Adrian Stern <ar...@gmail.com>:
>
> I've not come much further on this topic. I started creating my own CoA but
>> having problems filling out the fields glAccountClassId and
>> glAccountTypeId.
>> I did find some explanation about those fields in
>> the ManagerReferenceAccounting.pdf, but i am still unsure if i'm on the
>> right track.
>>
>> Are there any German speaking people in this mailing list? Or someone who
>> has done this before?
>> This is my very first task in ofbiz... so i'm kind of lost.
>>
>> I've found the translations of this classes and types
>> in config/AccountingEntityLabels.xml but i lack some explaining...
>>
>> Are there any accounts that absolutley have to be used or are all of them
>> more or less optional and ofbiz knows of its own what to do whith the one
>> available?
>>
>> Regards,
>> Adrian
>>
>>
>> On 28 January 2014 20:57, Adrian Stern <ar...@gmail.com> wrote:
>>
>> > Hello
>> >
>> > I'm looking for Information about implementing a completely new chart of
>> > accounts. I think i actually found everything important, but i still
>> want
>> > to ask about some random input and a share of your experiences.
>> >
>> > So. As i understand the first Step is to create the global chart (tree)
>> as
>> > the example "data/DemoGeneralChartOfAccounts.xml" states. This will
>> result
>> > in the entries in
>> >
>> > Accounting -> Global GL Settings
>> >
>> > And with that, i can configure the Organization GL Settings which are
>> > specific to my needs.
>> >
>> > 1. Could there be any dependencies one has to take care of when using a
>> > different chart of accounts?
>> >
>> > 2. Is there an "OFBiz"-Way for doing that? Since this Chart is not part
>> of
>> > ofbiz, should i keep it in the hot-deploy folder? How do you organize?
>> >
>> > 3. How do i tell ofbiz to use not the Demo tree but my own, after
>> creating
>> > it? Grep reveals a number of files using DemoGeneralChartOfAccounts.xml
>> but
>> > i bet there is a Global setting somewhere. Well. Probably just
>> > ofbiz-component.xml and SetupEvents.xml...
>> >
>> > Regards, Adrian
>> >
>> >
>>
>
>
Re: Implementing Chart of Accounts for Switzerland (Or any country
for that matter)
Posted by Igor Gallingani <ig...@gmail.com>.
I hope it can be useful. This chart of accounts is based on
http://www2.xbrl.org//it/.
You can compare it with http://www.xbrl.de/.
2014-02-04 Adrian Stern <ar...@gmail.com>:
> I've not come much further on this topic. I started creating my own CoA but
> having problems filling out the fields glAccountClassId and
> glAccountTypeId.
> I did find some explanation about those fields in
> the ManagerReferenceAccounting.pdf, but i am still unsure if i'm on the
> right track.
>
> Are there any German speaking people in this mailing list? Or someone who
> has done this before?
> This is my very first task in ofbiz... so i'm kind of lost.
>
> I've found the translations of this classes and types
> in config/AccountingEntityLabels.xml but i lack some explaining...
>
> Are there any accounts that absolutley have to be used or are all of them
> more or less optional and ofbiz knows of its own what to do whith the one
> available?
>
> Regards,
> Adrian
>
>
> On 28 January 2014 20:57, Adrian Stern <ar...@gmail.com> wrote:
>
> > Hello
> >
> > I'm looking for Information about implementing a completely new chart of
> > accounts. I think i actually found everything important, but i still want
> > to ask about some random input and a share of your experiences.
> >
> > So. As i understand the first Step is to create the global chart (tree)
> as
> > the example "data/DemoGeneralChartOfAccounts.xml" states. This will
> result
> > in the entries in
> >
> > Accounting -> Global GL Settings
> >
> > And with that, i can configure the Organization GL Settings which are
> > specific to my needs.
> >
> > 1. Could there be any dependencies one has to take care of when using a
> > different chart of accounts?
> >
> > 2. Is there an "OFBiz"-Way for doing that? Since this Chart is not part
> of
> > ofbiz, should i keep it in the hot-deploy folder? How do you organize?
> >
> > 3. How do i tell ofbiz to use not the Demo tree but my own, after
> creating
> > it? Grep reveals a number of files using DemoGeneralChartOfAccounts.xml
> but
> > i bet there is a Global setting somewhere. Well. Probably just
> > ofbiz-component.xml and SetupEvents.xml...
> >
> > Regards, Adrian
> >
> >
>