You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Jonatan Soto <se...@gmail.com> on 2010/08/19 17:59:56 UTC

GlAccountClass & GlAccountType question

After a huge research on that topic I found very useful information about
it, but still having doubts about what will be the effect if I try to change
the GlAccountClass hierarchy.

This topic (http://osdir.com/ml/user.ofbiz.apache.org/2009-07/msg00484.html)
 describes
very well the difference between them so in short my conclusions are:

GlAccountType:  It is used to map GlAccounts for automatic posts purposes on
the GL.
GlAccountClass: It is basically used for reporting purposes.

(Please correct me if my assumptions are wrong)

I've spent few hours reviewing the code seeking for the impact of doing
this. I believe that other companies/projects based in Ofbiz have had to do
it in some way in order to adapt it to their corresponding accountancy
models. I really appreciate if someone can share a similar experience about
this task.

On the other hand, I think GlAccountType is harder to redefine. The reason
that makes me think so is because needs recheck every service where an
automatic post is involved and in some cases changing the whole
implementation. BTW I believe (not sure at all) it's reusable using the OOTB
values, at least in my case.


TIA

*
*


-- 
-----

Jonatan Soto

Re: GlAccountClass & GlAccountType question

Posted by Jacques Le Roux <ja...@les7arts.com>.
From: "BJ Freeman" <bj...@free-man.net>
> not sure what you mean by limited output.
> yes doing and xml with a xslt conversions is one way.
> and the FTL to with CSV output is another.
> the use of the *UIlabels.xml in each config file does need more work agreed.
> I believe the current trunk framework does support inline embedded string conversion to make the labels the correct terminology 
> for each language.
> Since I don't do translation I am not 100% sure on this.

Right, just follow the directions at top (it's not really end user friendly but usable, I use it notably to sort labels...)

> Also the use of the content component for massive text translation is available.
> The Help doc files unfortunately are not integrated to use those but does have the ability to provide help in other languages.

Yes, just look for files like HELP_ROOT_FR.xml in the project

> I have not kept track of the Jira on Languages but Thanks for all your work.
>
> BJ Freeman  <http://bjfreeman.elance.com>
> Carsten Schinzer sent the following on 9/7/2010 12:56 AM:
>
>
>> Hello BJ,
>>
>>
>> good idea if you want limited output.
>>
>> I was more thinking of then exporting accounting data to XML and import that
>> to convert using Excel. Well - probably a matter of choice, preference and
>> tools one feels fittest with. A simple FTL doing a CSV is probably the
>> fastest, I agree.
>>
>> As I am trying to use this little project to get as much out of OFBiz and
>> learn as much about it as possible, I feel fine the way I do right now.
>> After 1.5 years I still feel there is a lot the learn and review about the
>> tool.

I still learn after 5 years+ and I'm pretty sure nobody knows it all :D

>> One of the downsides that the framework has is that it is not fully
>> translated and hence an upside of going through as many screens as I can is
>> that I would come up with translations (in the right context) and fix those
>> along with my journey through the screens.

Took me hundreds of hours to completely translate it in French at some point (mid-2008), then I gave up. Except from time to time 
when I'm inclined too

>> You will have seen some 10+ proposals for de localized Labels from my side
>> already. So, that's an ongoing effort which is facilitated by the "manual"
>> aproach.And applications/accounting is sure one of the big beasts in the
>> whole localisation business.

Yes, and it's the part that  moved more after my translation :/ Now the project seems to settle down, but the beast is still alive, 
be careful ;o)

Jacques

>> I will consider your proposal for larger projects, sure. Thanks for the tip!
>>
>> Regards
>>
>>
>> Carsten
>>
>> 2010/9/6 BJ Freeman<bj...@free-man.net>
>>
>>> Carsten:
>>> have you thought about using a ftl to create an export for quickbooks or
>>> quicken home and business?
>>>
>>> =========================
>>> BJ Freeman<http://bjfreeman.elance.com>
>>> Strategic Power Office with Supplier Automation<
>>> http://www.businessesnetwork.com/automation/viewforum.php?f=52>
>>> Specialtymarket.com<http://www.specialtymarket.com/>
>>> Systems Integrator-- Glad to Assist
>>>
>>> Chat  Y! messenger: bjfr33man
>>>
>>>
>>> Carsten Schinzer sent the following on 9/6/2010 6:18 AM:
>>>
>>>   Hi Jonatan,
>>>>
>>>>
>>>> I admit I thought this was much easier when I started with a mapping last
>>>> year.
>>>> My basic understanding is just as yours, however, I have no proven case
>>>> with
>>>> that yet. As my first project is just going hot live these days, I need to
>>>> wating for some figures before fully trusting what I did and meanwhile
>>>> keeping parallel books :-/ (you can't do that with a 10+ Txn per day shop,
>>>> I
>>>> am afraid, unless you really have nothing else to do).
>>>>
>>>> Kind regards
>>>>
>>>>
>>>> Carsten
>>>>
>>>>
>>>> 2010/8/19 Jonatan Soto<se...@gmail.com>
>>>>
>>>>   After a huge research on that topic I found very useful information about
>>>>> it, but still having doubts about what will be the effect if I try to
>>>>> change
>>>>> the GlAccountClass hierarchy.
>>>>>
>>>>> This topic (
>>>>> http://osdir.com/ml/user.ofbiz.apache.org/2009-07/msg00484.html)
>>>>>   describes
>>>>> very well the difference between them so in short my conclusions are:
>>>>>
>>>>> GlAccountType:  It is used to map GlAccounts for automatic posts purposes
>>>>> on
>>>>> the GL.
>>>>> GlAccountClass: It is basically used for reporting purposes.
>>>>>
>>>>> (Please correct me if my assumptions are wrong)
>>>>>
>>>>> I've spent few hours reviewing the code seeking for the impact of doing
>>>>> this. I believe that other companies/projects based in Ofbiz have had to
>>>>> do
>>>>> it in some way in order to adapt it to their corresponding accountancy
>>>>> models. I really appreciate if someone can share a similar experience
>>>>> about
>>>>> this task.
>>>>>
>>>>> On the other hand, I think GlAccountType is harder to redefine. The
>>>>> reason
>>>>> that makes me think so is because needs recheck every service where an
>>>>> automatic post is involved and in some cases changing the whole
>>>>> implementation. BTW I believe (not sure at all) it's reusable using the
>>>>> OOTB
>>>>> values, at least in my case.
>>>>>
>>>>>
>>>>> TIA
>>>>>
>>>>> *
>>>>> *
>>>>>
>>>>>
>>>>> --
>>>>> -----
>>>>>
>>>>> Jonatan Soto
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>
>>
>>
> 



Re: GlAccountClass & GlAccountType question

Posted by BJ Freeman <bj...@free-man.net>.
not sure what you mean by limited output.
yes doing and xml with a xslt conversions is one way.
and the FTL to with CSV output is another.
the use of the *UIlabels.xml in each config file does need more work agreed.
I believe the current trunk framework does support inline embedded 
string conversion to make the labels the correct terminology for each 
language.
Since I don't do translation I am not 100% sure on this.
Also the use of the content component for massive text translation is 
available.
The Help doc files unfortunately are not integrated to use those but 
does have the ability to provide help in other languages.

I have not kept track of the Jira on Languages but Thanks for all your work.

=========================
BJ Freeman  <http://bjfreeman.elance.com>
Strategic Power Office with Supplier Automation  <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com  <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man
Carsten Schinzer sent the following on 9/7/2010 12:56 AM:


> Hello BJ,
>
>
> good idea if you want limited output.
>
> I was more thinking of then exporting accounting data to XML and import that
> to convert using Excel. Well - probably a matter of choice, preference and
> tools one feels fittest with. A simple FTL doing a CSV is probably the
> fastest, I agree.
>
> As I am trying to use this little project to get as much out of OFBiz and
> learn as much about it as possible, I feel fine the way I do right now.
> After 1.5 years I still feel there is a lot the learn and review about the
> tool.
> One of the downsides that the framework has is that it is not fully
> translated and hence an upside of going through as many screens as I can is
> that I would come up with translations (in the right context) and fix those
> along with my journey through the screens.
>
> You will have seen some 10+ proposals for de localized Labels from my side
> already. So, that's an ongoing effort which is facilitated by the "manual"
> aproach.And applications/accounting is sure one of the big beasts in the
> whole localisation business.
>
> I will consider your proposal for larger projects, sure. Thanks for the tip!
>
> Regards
>
>
> Carsten
>
> 2010/9/6 BJ Freeman<bj...@free-man.net>
>
>> Carsten:
>> have you thought about using a ftl to create an export for quickbooks or
>> quicken home and business?
>>
>> =========================
>> BJ Freeman<http://bjfreeman.elance.com>
>> Strategic Power Office with Supplier Automation<
>> http://www.businessesnetwork.com/automation/viewforum.php?f=52>
>> Specialtymarket.com<http://www.specialtymarket.com/>
>> Systems Integrator-- Glad to Assist
>>
>> Chat  Y! messenger: bjfr33man
>>
>>
>> Carsten Schinzer sent the following on 9/6/2010 6:18 AM:
>>
>>   Hi Jonatan,
>>>
>>>
>>> I admit I thought this was much easier when I started with a mapping last
>>> year.
>>> My basic understanding is just as yours, however, I have no proven case
>>> with
>>> that yet. As my first project is just going hot live these days, I need to
>>> wating for some figures before fully trusting what I did and meanwhile
>>> keeping parallel books :-/ (you can't do that with a 10+ Txn per day shop,
>>> I
>>> am afraid, unless you really have nothing else to do).
>>>
>>> Kind regards
>>>
>>>
>>> Carsten
>>>
>>>
>>> 2010/8/19 Jonatan Soto<se...@gmail.com>
>>>
>>>   After a huge research on that topic I found very useful information about
>>>> it, but still having doubts about what will be the effect if I try to
>>>> change
>>>> the GlAccountClass hierarchy.
>>>>
>>>> This topic (
>>>> http://osdir.com/ml/user.ofbiz.apache.org/2009-07/msg00484.html)
>>>>   describes
>>>> very well the difference between them so in short my conclusions are:
>>>>
>>>> GlAccountType:  It is used to map GlAccounts for automatic posts purposes
>>>> on
>>>> the GL.
>>>> GlAccountClass: It is basically used for reporting purposes.
>>>>
>>>> (Please correct me if my assumptions are wrong)
>>>>
>>>> I've spent few hours reviewing the code seeking for the impact of doing
>>>> this. I believe that other companies/projects based in Ofbiz have had to
>>>> do
>>>> it in some way in order to adapt it to their corresponding accountancy
>>>> models. I really appreciate if someone can share a similar experience
>>>> about
>>>> this task.
>>>>
>>>> On the other hand, I think GlAccountType is harder to redefine. The
>>>> reason
>>>> that makes me think so is because needs recheck every service where an
>>>> automatic post is involved and in some cases changing the whole
>>>> implementation. BTW I believe (not sure at all) it's reusable using the
>>>> OOTB
>>>> values, at least in my case.
>>>>
>>>>
>>>> TIA
>>>>
>>>> *
>>>> *
>>>>
>>>>
>>>> --
>>>> -----
>>>>
>>>> Jonatan Soto
>>>>
>>>>
>>>
>>>
>>>
>>
>
>

Re: GlAccountClass & GlAccountType question

Posted by BJ Freeman <bj...@free-man.net>.
Carsten:
have you thought about using a ftl to create an export for quickbooks or 
quicken home and business?

=========================
BJ Freeman  <http://bjfreeman.elance.com>
Strategic Power Office with Supplier Automation  <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com  <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man


Carsten Schinzer sent the following on 9/6/2010 6:18 AM:
> Hi Jonatan,
>
>
> I admit I thought this was much easier when I started with a mapping last
> year.
> My basic understanding is just as yours, however, I have no proven case with
> that yet. As my first project is just going hot live these days, I need to
> wating for some figures before fully trusting what I did and meanwhile
> keeping parallel books :-/ (you can't do that with a 10+ Txn per day shop, I
> am afraid, unless you really have nothing else to do).
>
> Kind regards
>
>
> Carsten
>
>
> 2010/8/19 Jonatan Soto<se...@gmail.com>
>
>> After a huge research on that topic I found very useful information about
>> it, but still having doubts about what will be the effect if I try to
>> change
>> the GlAccountClass hierarchy.
>>
>> This topic (
>> http://osdir.com/ml/user.ofbiz.apache.org/2009-07/msg00484.html)
>>   describes
>> very well the difference between them so in short my conclusions are:
>>
>> GlAccountType:  It is used to map GlAccounts for automatic posts purposes
>> on
>> the GL.
>> GlAccountClass: It is basically used for reporting purposes.
>>
>> (Please correct me if my assumptions are wrong)
>>
>> I've spent few hours reviewing the code seeking for the impact of doing
>> this. I believe that other companies/projects based in Ofbiz have had to do
>> it in some way in order to adapt it to their corresponding accountancy
>> models. I really appreciate if someone can share a similar experience about
>> this task.
>>
>> On the other hand, I think GlAccountType is harder to redefine. The reason
>> that makes me think so is because needs recheck every service where an
>> automatic post is involved and in some cases changing the whole
>> implementation. BTW I believe (not sure at all) it's reusable using the
>> OOTB
>> values, at least in my case.
>>
>>
>> TIA
>>
>> *
>> *
>>
>>
>> --
>> -----
>>
>> Jonatan Soto
>>
>
>
>


Re: GlAccountClass & GlAccountType question

Posted by Carsten Schinzer <c....@googlemail.com>.
Hi Jonatan,


I admit I thought this was much easier when I started with a mapping last
year.
My basic understanding is just as yours, however, I have no proven case with
that yet. As my first project is just going hot live these days, I need to
wating for some figures before fully trusting what I did and meanwhile
keeping parallel books :-/ (you can't do that with a 10+ Txn per day shop, I
am afraid, unless you really have nothing else to do).

Kind regards


Carsten


2010/8/19 Jonatan Soto <se...@gmail.com>

> After a huge research on that topic I found very useful information about
> it, but still having doubts about what will be the effect if I try to
> change
> the GlAccountClass hierarchy.
>
> This topic (
> http://osdir.com/ml/user.ofbiz.apache.org/2009-07/msg00484.html)
>  describes
> very well the difference between them so in short my conclusions are:
>
> GlAccountType:  It is used to map GlAccounts for automatic posts purposes
> on
> the GL.
> GlAccountClass: It is basically used for reporting purposes.
>
> (Please correct me if my assumptions are wrong)
>
> I've spent few hours reviewing the code seeking for the impact of doing
> this. I believe that other companies/projects based in Ofbiz have had to do
> it in some way in order to adapt it to their corresponding accountancy
> models. I really appreciate if someone can share a similar experience about
> this task.
>
> On the other hand, I think GlAccountType is harder to redefine. The reason
> that makes me think so is because needs recheck every service where an
> automatic post is involved and in some cases changing the whole
> implementation. BTW I believe (not sure at all) it's reusable using the
> OOTB
> values, at least in my case.
>
>
> TIA
>
> *
> *
>
>
> --
> -----
>
> Jonatan Soto
>



-- 

Best

Carsten Schinzer

Waisenhausstr. 53a
80637 München
Germany