explanation on GL setup in ofbiz
Locked
explanation on GL setup in ofbiz
 
|
Hi Everyone,
Does anyone have a detail explanation of the following: Gl Account Type Id Gl Account Class Id Gl Resource Type Id Gl Xbrl Class Id Parent Gl Account Id Also if you want to associate costs and sales with a specific store how would you do it. Using Party Group, Store Setup. Normally each store has sales, revenue and costs and we would like to allocate them. It would very hard to maintain an organization structure with each store as subsidiary. So is there a simple way to organize it. Regards, Vikrant No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007 3:59 PM |
Re: explanation on GL setup in ofbiz
|
|
Vikrant,
You may want to see Data Model Resource Book Vol 1. Regards Anil Patel On 5/23/07, [hidden email] < [hidden email]> wrote: > > Hi Everyone, > > Does anyone have a detail explanation of the following: > Gl Account Type Id > Gl Account Class Id > Gl Resource Type Id > Gl Xbrl Class Id > Parent Gl Account Id > > Also if you want to associate costs and sales with a specific store how > would you do it. Using Party Group, Store Setup. Normally each store has > sales, revenue and costs and we would like to allocate them. It would very > hard to maintain an organization structure with each store as subsidiary. So > is there a simple way to organize it. > > Regards, > Vikrant > > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007 > 3:59 PM > > |
RE: explanation on GL setup in ofbiz
|
|
Hi Anil,
Thanks for the reference; we do have that book with us. But as you know in a company you cannot talk in technical language. This terms needs to be explained to Finance and we need to talk in Finance terms not technical implementation :). So asked if anyone done any simple documentation on these terms. In the process we are also working towards making the terms more business friendly :). Would give it back when it's ready. Regards, Vikrant -----Original Message----- From: [hidden email] [mailto:[hidden email]] Sent: Thursday, May 24, 2007 10:20 AM To: [hidden email] Subject: Re: explanation on GL setup in ofbiz Vikrant, You may want to see Data Model Resource Book Vol 1. Regards Anil Patel On 5/23/07, [hidden email] < [hidden email]> wrote: > > Hi Everyone, > > Does anyone have a detail explanation of the following: > Gl Account Type Id > Gl Account Class Id > Gl Resource Type Id > Gl Xbrl Class Id > Parent Gl Account Id > > Also if you want to associate costs and sales with a specific store how > would you do it. Using Party Group, Store Setup. Normally each store has > sales, revenue and costs and we would like to allocate them. It would very > hard to maintain an organization structure with each store as subsidiary. So > is there a simple way to organize it. > > Regards, > Vikrant > > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007 > 3:59 PM > > No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007 3:59 PM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007 3:59 PM |
Re: explanation on GL setup in ofbiz
|
|
What do you mean by technical language here? This is modeling of pure business data, and usually most accountants with experience are okay with tabular structures, and if they have a lot of experience then they should be able to pick up even rather complex and feature rich financial data structures like those in OFBiz. So, could you be more specific about what you mean by business versus technical language? The way I see it this is all business, no technical, but it is fairly complex and because financial system requirements are that way by nature you can only simplify it (dumb it down) so much. -David [hidden email] wrote: > Hi Anil, > > Thanks for the reference; we do have that book with us. But as you know in a company you cannot talk in technical language. This terms needs to be explained to Finance and we need to talk in Finance terms not technical implementation :). > > So asked if anyone done any simple documentation on these terms. In the process we are also working towards making the terms more business friendly :). Would give it back when it's ready. > > Regards, > Vikrant > > -----Original Message----- > From: [hidden email] [mailto:[hidden email]] > Sent: Thursday, May 24, 2007 10:20 AM > To: [hidden email] > Subject: Re: explanation on GL setup in ofbiz > > Vikrant, > You may want to see Data Model Resource Book Vol 1. > > Regards > Anil Patel > > On 5/23/07, [hidden email] < > [hidden email]> wrote: >> Hi Everyone, >> >> Does anyone have a detail explanation of the following: >> Gl Account Type Id >> Gl Account Class Id >> Gl Resource Type Id >> Gl Xbrl Class Id >> Parent Gl Account Id >> >> Also if you want to associate costs and sales with a specific store how >> would you do it. Using Party Group, Store Setup. Normally each store has >> sales, revenue and costs and we would like to allocate them. It would very >> hard to maintain an organization structure with each store as subsidiary. So >> is there a simple way to organize it. >> >> Regards, >> Vikrant >> >> No virus found in this outgoing message. >> Checked by AVG Free Edition. >> Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007 >> 3:59 PM >> >> > > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007 3:59 PM > > > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007 3:59 PM > |
RE: explanation on GL setup in ofbiz
|
|
In reply to this post by Vikrant.Rathore
Hi David,
Thanks for your explanation and this is the reason indeed we are already going to get consultancy from outside. But still the problem appeared when the financial people in my company wanted to understand this model. :) They are still used to ready made stuff (e.g. in SAP and Axapta implementation the functionality is implemented using dimensions and Item Groups) So the GL posting can be done based on ITEM group, cost center or dimension (You can define 1-2 level dimension which can either be a specific shop or warehouse or department). In ofbiz indeed the same can be achieved by the entity defined for GL. The problem is for the our finance people to really grasp the entity definition. If we can define by a simple example and brief explanation it would be easier to explain. Regards, Vikrant -----Original Message----- From: David E Jones [mailto:[hidden email]] Sent: Thursday, May 24, 2007 12:46 PM To: [hidden email] Subject: Re: explanation on GL setup in ofbiz What do you mean by technical language here? This is modeling of pure business data, and usually most accountants with experience are okay with tabular structures, and if they have a lot of experience then they should be able to pick up even rather complex and feature rich financial data structures like those in OFBiz. So, could you be more specific about what you mean by business versus technical language? The way I see it this is all business, no technical, but it is fairly complex and because financial system requirements are that way by nature you can only simplify it (dumb it down) so much. -David [hidden email] wrote: > Hi Anil, > > Thanks for the reference; we do have that book with us. But as you know in a company you cannot talk in technical language. This terms needs to be explained to Finance and we need to talk in Finance terms not technical implementation :). > > So asked if anyone done any simple documentation on these terms. In the process we are also working towards making the terms more business friendly :). Would give it back when it's ready. > > Regards, > Vikrant > > -----Original Message----- > From: [hidden email] [mailto:[hidden email]] > Sent: Thursday, May 24, 2007 10:20 AM > To: [hidden email] > Subject: Re: explanation on GL setup in ofbiz > > Vikrant, > You may want to see Data Model Resource Book Vol 1. > > Regards > Anil Patel > > On 5/23/07, [hidden email] < > [hidden email]> wrote: >> Hi Everyone, >> >> Does anyone have a detail explanation of the following: >> Gl Account Type Id >> Gl Account Class Id >> Gl Resource Type Id >> Gl Xbrl Class Id >> Parent Gl Account Id >> >> Also if you want to associate costs and sales with a specific store how >> would you do it. Using Party Group, Store Setup. Normally each store has >> sales, revenue and costs and we would like to allocate them. It would very >> hard to maintain an organization structure with each store as subsidiary. So >> is there a simple way to organize it. >> >> Regards, >> Vikrant >> >> No virus found in this outgoing message. >> Checked by AVG Free Edition. >> Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007 >> 3:59 PM >> >> > > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007 3:59 PM > > > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007 3:59 PM > No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007 3:59 PM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007 3:59 PM |
Re: explanation on GL setup in ofbiz
|
|
[hidden email] wrote: > Hi David, > > Thanks for your explanation and this is the reason indeed we are already going to get consultancy from outside. But still the problem appeared when the financial people in my company wanted to understand this model. :) > > They are still used to ready made stuff (e.g. in SAP and Axapta implementation the functionality is implemented using dimensions and Item Groups) So the GL posting can be done based on ITEM group, cost center or dimension (You can define 1-2 level dimension which can either be a specific shop or warehouse or department). In OFBiz these things are generally handled through the multi-organization feature. Every transaction entry works with an ID pair of glAccountId and organizationPartyId. > In ofbiz indeed the same can be achieved by the entity defined for GL. The problem is for the our finance people to really grasp the entity definition. If we can define by a simple example and brief explanation it would be easier to explain. The OFBiz data model is based on the OMG GL interface specification, so the descriptions of data elements there may be helpful in addition to what is in the Data Model Resource Book. We were also involved in the early efforts for an AR/AP specification in the OMG that was an extension of the GL interface, but just in a comment and review role, and the main group behind that effort was not able to finish it up so the documentation for that is harder to find, and I don't believe I even have the old draft documents any more. -David > -----Original Message----- > From: David E Jones [mailto:[hidden email]] > Sent: Thursday, May 24, 2007 12:46 PM > To: [hidden email] > Subject: Re: explanation on GL setup in ofbiz > > > What do you mean by technical language here? This is modeling of pure business data, and usually most accountants with experience are okay with tabular structures, and if they have a lot of experience then they should be able to pick up even rather complex and feature rich financial data structures like those in OFBiz. > > So, could you be more specific about what you mean by business versus technical language? The way I see it this is all business, no technical, but it is fairly complex and because financial system requirements are that way by nature you can only simplify it (dumb it down) so much. > > -David > > > [hidden email] wrote: >> Hi Anil, >> >> Thanks for the reference; we do have that book with us. But as you know in a company you cannot talk in technical language. This terms needs to be explained to Finance and we need to talk in Finance terms not technical implementation :). >> >> So asked if anyone done any simple documentation on these terms. In the process we are also working towards making the terms more business friendly :). Would give it back when it's ready. >> >> Regards, >> Vikrant >> >> -----Original Message----- >> From: [hidden email] [mailto:[hidden email]] >> Sent: Thursday, May 24, 2007 10:20 AM >> To: [hidden email] >> Subject: Re: explanation on GL setup in ofbiz >> >> Vikrant, >> You may want to see Data Model Resource Book Vol 1. >> >> Regards >> Anil Patel >> >> On 5/23/07, [hidden email] < >> [hidden email]> wrote: >>> Hi Everyone, >>> >>> Does anyone have a detail explanation of the following: >>> Gl Account Type Id >>> Gl Account Class Id >>> Gl Resource Type Id >>> Gl Xbrl Class Id >>> Parent Gl Account Id >>> >>> Also if you want to associate costs and sales with a specific store how >>> would you do it. Using Party Group, Store Setup. Normally each store has >>> sales, revenue and costs and we would like to allocate them. It would very >>> hard to maintain an organization structure with each store as subsidiary. So >>> is there a simple way to organize it. >>> >>> Regards, >>> Vikrant >>> >>> No virus found in this outgoing message. >>> Checked by AVG Free Edition. >>> Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007 >>> 3:59 PM >>> >>> >> No virus found in this incoming message. >> Checked by AVG Free Edition. >> Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007 3:59 PM >> >> >> No virus found in this outgoing message. >> Checked by AVG Free Edition. >> Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007 3:59 PM >> > > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007 3:59 PM > > > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007 3:59 PM > |
Re: explanation on GL setup in ofbiz
Administrator
|
De : "David E Jones" <[hidden email]>
> > > [hidden email] wrote: > > Hi David, > > > > Thanks for your explanation and this is the reason indeed we are already going to get consultancy from outside. But still the problem appeared when the financial people in my company wanted to understand this model. :) > > > > They are still used to ready made stuff (e.g. in SAP and Axapta implementation the functionality is implemented using dimensions and Item Groups) So the GL posting can be done based on ITEM group, cost center or dimension (You can define 1-2 level dimension which can either be a specific shop or warehouse or department). > > In OFBiz these things are generally handled through the multi-organization feature. Every transaction entry works with an ID pair of glAccountId and organizationPartyId. > > > In ofbiz indeed the same can be achieved by the entity defined for GL. The problem is for the our finance people to really grasp the entity definition. If we can define by a simple example and brief explanation it would be easier to explain. > > The OFBiz data model is based on the OMG GL interface specification, so the descriptions of data elements there may be helpful in addition to what is in the Data Model Resource Book. We were also involved in the early efforts for an AR/AP specification in the OMG that was an extension of the GL interface, but just in a comment and review role, and the main group behind that effort was not able to finish it up so the documentation for that is harder to find, and I don't believe I even have the old draft documents any more. We may put a link to http://www.omg.org/docs/formal/01-02-67.pdf somewhere WDYT ? Jacques > -David > > > > > -----Original Message----- > > From: David E Jones [mailto:[hidden email]] > > Sent: Thursday, May 24, 2007 12:46 PM > > To: [hidden email] > > Subject: Re: explanation on GL setup in ofbiz > > > > > > What do you mean by technical language here? This is modeling of okay with tabular structures, and if they have a lot of experience then they should be able to pick up even rather complex and feature rich financial data structures like those in OFBiz. > > > > So, could you be more specific about what you mean by business versus technical language? The way I see it this is all business, no technical, but it is fairly complex and because financial system requirements are that way by nature you can only simplify it (dumb it down) so much. > > > > -David > > > > > > [hidden email] wrote: > >> Hi Anil, > >> > >> Thanks for the reference; we do have that book with us. But as you know in a company you cannot talk in technical language. This terms needs to be explained to Finance and we need to talk in Finance terms not technical implementation :). > >> > >> So asked if anyone done any simple documentation on these terms. In the process we are also working towards making the terms more business friendly :). Would give it back when it's ready. > >> > >> Regards, > >> Vikrant > >> > >> -----Original Message----- > >> From: [hidden email] [mailto:[hidden email]] > >> Sent: Thursday, May 24, 2007 10:20 AM > >> To: [hidden email] > >> Subject: Re: explanation on GL setup in ofbiz > >> > >> Vikrant, > >> You may want to see Data Model Resource Book Vol 1. > >> > >> Regards > >> Anil Patel > >> > >> On 5/23/07, [hidden email] < > >> [hidden email]> wrote: > >>> Hi Everyone, > >>> > >>> Does anyone have a detail explanation of the following: > >>> Gl Account Type Id > >>> Gl Account Class Id > >>> Gl Resource Type Id > >>> Gl Xbrl Class Id > >>> Parent Gl Account Id > >>> > >>> Also if you want to associate costs and sales with a specific > >>> would you do it. Using Party Group, Store Setup. Normally each store has > >>> sales, revenue and costs and we would like to allocate them. It would very > >>> hard to maintain an organization structure with each store as subsidiary. So > >>> is there a simple way to organize it. > >>> > >>> Regards, > >>> Vikrant > >>> > >>> No virus found in this outgoing message. > >>> Checked by AVG Free Edition. > >>> Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007 > >>> 3:59 PM > >>> > >>> > >> No virus found in this incoming message. > >> Checked by AVG Free Edition. > >> Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007 3:59 PM > >> > >> > >> No virus found in this outgoing message. > >> Checked by AVG Free Edition. > >> Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007 3:59 PM > >> > > > > No virus found in this incoming message. > > Checked by AVG Free Edition. > > Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007 3:59 PM > > > > > > No virus found in this outgoing message. > > Checked by AVG Free Edition. > > Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007 3:59 PM > > |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |