GLAccountGroup* entities

[Rashko Rejmer]

Hi all,

Is someone using these entities?
GLAccountGroup
GlAccountGroupType
GLAccountGroupMember

I have to implement special Gl accounts grouping and I intended to use  
these entities for this purpose, but I got confused of their structure.

GlAccountGroup entity has glAccountGroupTypeId field and  
GlAccountGroupMember entity also has this field that is part of the pk.
I tried to find any information about these entities but they was  
introduced 4 years ago and couldn't find anything related.

Thanks in advance!
Rashko Rejmer

[Jacques Le Roux]

As a side note, also GlAccountClass and GlAccountType (though less to the point) are also used for grouping acounts (maybe not in
the way you are looking for)
Best answer about that so far http://markmail.org/message/hrbdnxoazvcfdpdb

Also here is an old explanation, for GlAccountClass  usage, by Si who is the original author of that
http://lists.ofbiz.org/pipermail/svn/2006-March/003542.html

But I have no ideas for GLAccountGroup usage, maybe yes, for what you are looking for...

HTH

Jacques

From: "Rashko Rejmer" <[hidden email]>

> Hi all,
>
> Is someone using these entities?
> GLAccountGroup
> GlAccountGroupType
> GLAccountGroupMember
>
> I have to implement special Gl accounts grouping and I intended to use  these entities for this purpose, but I got confused of
> their structure.
>
> GlAccountGroup entity has glAccountGroupTypeId field and  GlAccountGroupMember entity also has this field that is part of the pk.
> I tried to find any information about these entities but they was  introduced 4 years ago and couldn't find anything related.
>
> Thanks in advance!
> Rashko Rejmer
>

[David E Jones-3]

On Mar 17, 2009, at 1:12 PM, Jacques Le Roux wrote:

> As a side note, also GlAccountClass and GlAccountType (though less  
> to the point) are also used for grouping acounts (maybe not in the  
> way you are looking for)
> Best answer about that so far http://markmail.org/message/hrbdnxoazvcfdpdb

They are used to classify accounts, but the main way of "grouping"  
accounts is through the account hierarchy using the parent account ID  
on GlAccount itself (ie implements an hierarchy, not a graph).

> Also here is an old explanation, for GlAccountClass  usage, by Si  
> who is the original author of that
> http://lists.ofbiz.org/pipermail/svn/2006-March/003542.html

You mean Si is the original author of that comment? Well... maybe...

> But I have no ideas for GLAccountGroup usage, maybe yes, for what  
> you are looking for...

The basic idea behind GlAccountGroup is to have a structure where an  
account can be in more than one group (as opposed to the main account  
hierarchy where an account can only be under one other account).  
However, there is the restriction that an account can only be in one  
group per group type (which is why the PK is setup as-is).

In cases like this sometimes the demo data is the most useful way to  
see how it works. The demo data I put together for that, and part of  
the reason I created those entities, is in the UsTaxAccountGroups.xml  
file. That use of groups allow you to configure different accounts for  
different tax form fields and then the totals of those different  
accounts for each field (group) can be summed up for the tax reporting.

-David

> From: "Rashko Rejmer" <[hidden email]>
>> Hi all,
>>
>> Is someone using these entities?
>> GLAccountGroup
>> GlAccountGroupType
>> GLAccountGroupMember
>>
>> I have to implement special Gl accounts grouping and I intended to  
>> use  these entities for this purpose, but I got confused of their  
>> structure.
>>
>> GlAccountGroup entity has glAccountGroupTypeId field and  
>> GlAccountGroupMember entity also has this field that is part of the  
>> pk.
>> I tried to find any information about these entities but they was  
>> introduced 4 years ago and couldn't find anything related.
>>
>> Thanks in advance!
>> Rashko Rejmer
>
>

[Rashko Rejmer]

David, Jacques,

Thank you very much for your responses. These entities are exactly  
what I need, I need second structure of GL accounts. One(the main one)  
that is organized using parent-child relationship, gl account type,  
classes and second one that uses the same GL accounts but organize  
them in completely different way.

I was just wandering why it is introduced a restriction one GL account  
to be part of just one group type, but I am ok with this restriction,  
so I will use these entities.

Thanks again.

Regards,
Rashko Rejmer

On Mar 17, 2009, at 10:18 PM, David E Jones wrote:

>
> On Mar 17, 2009, at 1:12 PM, Jacques Le Roux wrote:
>
>> As a side note, also GlAccountClass and GlAccountType (though less  
>> to the point) are also used for grouping acounts (maybe not in the  
>> way you are looking for)
>> Best answer about that so far http://markmail.org/message/hrbdnxoazvcfdpdb
>
> They are used to classify accounts, but the main way of "grouping"  
> accounts is through the account hierarchy using the parent account  
> ID on GlAccount itself (ie implements an hierarchy, not a graph).
>
>> Also here is an old explanation, for GlAccountClass  usage, by Si  
>> who is the original author of that
>> http://lists.ofbiz.org/pipermail/svn/2006-March/003542.html
>
> You mean Si is the original author of that comment? Well... maybe...
>
>> But I have no ideas for GLAccountGroup usage, maybe yes, for what  
>> you are looking for...
>
> The basic idea behind GlAccountGroup is to have a structure where an  
> account can be in more than one group (as opposed to the main  
> account hierarchy where an account can only be under one other  
> account). However, there is the restriction that an account can only  
> be in one group per group type (which is why the PK is setup as-is).
>
> In cases like this sometimes the demo data is the most useful way to  
> see how it works. The demo data I put together for that, and part of  
> the reason I created those entities, is in the  
> UsTaxAccountGroups.xml file. That use of groups allow you to  
> configure different accounts for different tax form fields and then  
> the totals of those different accounts for each field (group) can be  
> summed up for the tax reporting.
>
> -David
>
>
>
>> From: "Rashko Rejmer" <[hidden email]>
>>> Hi all,
>>>
>>> Is someone using these entities?
>>> GLAccountGroup
>>> GlAccountGroupType
>>> GLAccountGroupMember
>>>
>>> I have to implement special Gl accounts grouping and I intended to  
>>> use  these entities for this purpose, but I got confused of their  
>>> structure.
>>>
>>> GlAccountGroup entity has glAccountGroupTypeId field and  
>>> GlAccountGroupMember entity also has this field that is part of  
>>> the pk.
>>> I tried to find any information about these entities but they was  
>>> introduced 4 years ago and couldn't find anything related.
>>>
>>> Thanks in advance!
>>> Rashko Rejmer
>>
>>
>