You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by kunal aggarwal <ku...@gmail.com> on 2008/08/11 20:18:52 UTC
Sub-ledgers in Ofbiz ?
Hi friends,
I want to implement the concept of sub-ledgers, does Ofbiz supports it. If
yes how to achieve it ?
Can anyone please help me out ?
Thanks
Kunal.
Re: Sub-ledgers in Ofbiz ?
Posted by BJ Freeman <bj...@free-man.net>.
Not sure there is a best practices for GL numbering.
this usually is from the Accountant you already have.
here are some considerated
210000 Accounts payable
211000 thru 219000 types of payables
or
211000 219900 type of payables if a large company
that leaves two number in each type to enumerate. or 01-99
if that is not enough, like a lot of vendors. then before you begin
using the Chart of accounts, you need to increase the number
The problems becomes the Key size since some DB's only allow 30 characters.
so if you plan to expand the Chart of account numbering system
make sure you Database will support the size keys you will be using.
BJ Freeman sent the following on 8/12/2008 7:44 AM:
> basic rule is you post to the lowest level of GL (detail)
> Double posting means credit and debit and should not be used, in
> accounting, any other way.
> the rest should be take care of already.
>
> britches m sent the following on 8/11/2008 9:54 PM:
>> Hi BJ,
>> double posting here should mean that there was two debit or credit postings for the corresponding transaction lets say for customer payment we should have :
>> 1. one debit posting in that customer's "own" GL i.e. child.
>> 2. other debit posting in GL which is the parent of all the
>> customers account. I doubt wheather we can do it presently.
>>
>> Thanks
>> Brijesh M.
>>
>>
>>
>> BJ Freeman <bj...@free-man.net> wrote: using an Seca is what I would recommend.
>> these are used like in the shopping cart to update the grandtotal.
>>
>> so you don't post to the top level just the sublevels
>> then the Seca compute the next tier up.
>>
>> Now by double posting you mean debit and credit each one is a
>> transaction in itself so they get entered after the transactions balance.
>> take a look at
>> applications\accounting\script\org\ofbiz\accounting\ledger
>>
>> kunal aggarwal sent the following on 8/11/2008 12:59 PM:
>>> Hi BJ,
>>> I have done posting in GL accounts through this child parent relationship
>>> but by sub-ledger I mean that one among following should work :
>>> 1. two corresponding postings to two GL accounts i.e. one child and its
>>> parent.
>>> 2. or I should have an summing effect of childs to parent.
>>>
>>> To my knowledge both does not happen presently. Please suggest something.
>>>
>>> Thanks
>>> Kunal.
>>>
>>> On Tue, Aug 12, 2008 at 1:03 AM, BJ Freeman wrote:
>>>
>>>> I have seen a lot of discussion about this.
>>>> I think there needs to be some definition of terms
>>>> before we talk about sub ledgers.
>>>> GL is the end product of all transactions.
>>>> the GL represents in single Dollar values for a GL account Code.
>>>> There are no invoice or transaction related directly to the GL.
>>>>
>>>> The Transactions calculated for each GL and at some point Posted.
>>>> at that time the Transaction history is for audit only.
>>>> and Invoice is a debit to the Tranactions and a payment is a credit
>>>> so you Transactions must balance before you can post to the GL.
>>>>
>>>> so a GL is best represented, for this discussion, by
>>>> https://demo.hotwaxmedia.com/accounting/control/GlAccountNavigate
>>>>
>>>> A sub ledger is a more detailed representation of a particular GL main
>>>> account.
>>>> so lets take GL account 700000 other expenses
>>>> under that you have a sub account 701000 Credit card Service Charges
>>>> Under that you have a further sub acct of differnt CC 701100-701400
>>>> Now if you wish to add more under each of those you have two more number
>>>> if you wish to expand this then you need to revise the numbering system
>>>> to accomodate the detail you want.
>>>>
>>>> Now say you want this broken down by Internal Organizations then you
>>>> you could then create the Internal Organizations and list them here
>>>> https://demo.hotwaxmedia.com/accounting/control/ListCompanies
>>>>
>>>> going thru setup and clicking on Chart of accounts
>>>>
>>>> https://demo.hotwaxmedia.com/accounting/control/ListGlAccountOrganization?organizationPartyId=MARKETING
>>>>
>>>> you can assign a GL account to Internal Organization
>>>>
>>>> So if you will ask your question based on this format maybe they can be
>>>> clarified.
>>>>
>>>>
>>>>
>>>> kunal aggarwal sent the following on 8/11/2008 11:18 AM:
>>>>> Hi friends,
>>>>> I want to implement the concept of sub-ledgers, does Ofbiz supports it.
>>>> If
>>>>> yes how to achieve it ?
>>>>>
>>>>> Can anyone please help me out ?
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> Thanks
>>>>> Kunal.
>>>>>
>>
>>
>>
>
>
>
>
Re: Sub-ledgers in Ofbiz ?
Posted by BJ Freeman <bj...@free-man.net>.
basic rule is you post to the lowest level of GL (detail)
Double posting means credit and debit and should not be used, in
accounting, any other way.
the rest should be take care of already.
britches m sent the following on 8/11/2008 9:54 PM:
> Hi BJ,
> double posting here should mean that there was two debit or credit postings for the corresponding transaction lets say for customer payment we should have :
> 1. one debit posting in that customer's "own" GL i.e. child.
> 2. other debit posting in GL which is the parent of all the
> customers account. I doubt wheather we can do it presently.
>
> Thanks
> Brijesh M.
>
>
>
> BJ Freeman <bj...@free-man.net> wrote: using an Seca is what I would recommend.
> these are used like in the shopping cart to update the grandtotal.
>
> so you don't post to the top level just the sublevels
> then the Seca compute the next tier up.
>
> Now by double posting you mean debit and credit each one is a
> transaction in itself so they get entered after the transactions balance.
> take a look at
> applications\accounting\script\org\ofbiz\accounting\ledger
>
> kunal aggarwal sent the following on 8/11/2008 12:59 PM:
>> Hi BJ,
>> I have done posting in GL accounts through this child parent relationship
>> but by sub-ledger I mean that one among following should work :
>> 1. two corresponding postings to two GL accounts i.e. one child and its
>> parent.
>> 2. or I should have an summing effect of childs to parent.
>>
>> To my knowledge both does not happen presently. Please suggest something.
>>
>> Thanks
>> Kunal.
>>
>> On Tue, Aug 12, 2008 at 1:03 AM, BJ Freeman wrote:
>>
>>> I have seen a lot of discussion about this.
>>> I think there needs to be some definition of terms
>>> before we talk about sub ledgers.
>>> GL is the end product of all transactions.
>>> the GL represents in single Dollar values for a GL account Code.
>>> There are no invoice or transaction related directly to the GL.
>>>
>>> The Transactions calculated for each GL and at some point Posted.
>>> at that time the Transaction history is for audit only.
>>> and Invoice is a debit to the Tranactions and a payment is a credit
>>> so you Transactions must balance before you can post to the GL.
>>>
>>> so a GL is best represented, for this discussion, by
>>> https://demo.hotwaxmedia.com/accounting/control/GlAccountNavigate
>>>
>>> A sub ledger is a more detailed representation of a particular GL main
>>> account.
>>> so lets take GL account 700000 other expenses
>>> under that you have a sub account 701000 Credit card Service Charges
>>> Under that you have a further sub acct of differnt CC 701100-701400
>>> Now if you wish to add more under each of those you have two more number
>>> if you wish to expand this then you need to revise the numbering system
>>> to accomodate the detail you want.
>>>
>>> Now say you want this broken down by Internal Organizations then you
>>> you could then create the Internal Organizations and list them here
>>> https://demo.hotwaxmedia.com/accounting/control/ListCompanies
>>>
>>> going thru setup and clicking on Chart of accounts
>>>
>>> https://demo.hotwaxmedia.com/accounting/control/ListGlAccountOrganization?organizationPartyId=MARKETING
>>>
>>> you can assign a GL account to Internal Organization
>>>
>>> So if you will ask your question based on this format maybe they can be
>>> clarified.
>>>
>>>
>>>
>>> kunal aggarwal sent the following on 8/11/2008 11:18 AM:
>>>> Hi friends,
>>>> I want to implement the concept of sub-ledgers, does Ofbiz supports it.
>>> If
>>>> yes how to achieve it ?
>>>>
>>>> Can anyone please help me out ?
>>>>
>>>>
>>>>
>>>>
>>>> Thanks
>>>> Kunal.
>>>>
>
>
>
>
Re: Sub-ledgers in Ofbiz ?
Posted by brijesh m <br...@yahoo.com>.
Hi BJ,
double posting here should mean that there was two debit or credit postings for the corresponding transaction lets say for customer payment we should have :
1. one debit posting in that customer's "own" GL i.e. child.
2. other debit posting in GL which is the parent of all the
customers account. I doubt wheather we can do it presently.
Thanks
Brijesh M.
BJ Freeman <bj...@free-man.net> wrote: using an Seca is what I would recommend.
these are used like in the shopping cart to update the grandtotal.
so you don't post to the top level just the sublevels
then the Seca compute the next tier up.
Now by double posting you mean debit and credit each one is a
transaction in itself so they get entered after the transactions balance.
take a look at
applications\accounting\script\org\ofbiz\accounting\ledger
kunal aggarwal sent the following on 8/11/2008 12:59 PM:
> Hi BJ,
> I have done posting in GL accounts through this child parent relationship
> but by sub-ledger I mean that one among following should work :
> 1. two corresponding postings to two GL accounts i.e. one child and its
> parent.
> 2. or I should have an summing effect of childs to parent.
>
> To my knowledge both does not happen presently. Please suggest something.
>
> Thanks
> Kunal.
>
> On Tue, Aug 12, 2008 at 1:03 AM, BJ Freeman wrote:
>
>> I have seen a lot of discussion about this.
>> I think there needs to be some definition of terms
>> before we talk about sub ledgers.
>> GL is the end product of all transactions.
>> the GL represents in single Dollar values for a GL account Code.
>> There are no invoice or transaction related directly to the GL.
>>
>> The Transactions calculated for each GL and at some point Posted.
>> at that time the Transaction history is for audit only.
>> and Invoice is a debit to the Tranactions and a payment is a credit
>> so you Transactions must balance before you can post to the GL.
>>
>> so a GL is best represented, for this discussion, by
>> https://demo.hotwaxmedia.com/accounting/control/GlAccountNavigate
>>
>> A sub ledger is a more detailed representation of a particular GL main
>> account.
>> so lets take GL account 700000 other expenses
>> under that you have a sub account 701000 Credit card Service Charges
>> Under that you have a further sub acct of differnt CC 701100-701400
>> Now if you wish to add more under each of those you have two more number
>> if you wish to expand this then you need to revise the numbering system
>> to accomodate the detail you want.
>>
>> Now say you want this broken down by Internal Organizations then you
>> you could then create the Internal Organizations and list them here
>> https://demo.hotwaxmedia.com/accounting/control/ListCompanies
>>
>> going thru setup and clicking on Chart of accounts
>>
>> https://demo.hotwaxmedia.com/accounting/control/ListGlAccountOrganization?organizationPartyId=MARKETING
>>
>> you can assign a GL account to Internal Organization
>>
>> So if you will ask your question based on this format maybe they can be
>> clarified.
>>
>>
>>
>> kunal aggarwal sent the following on 8/11/2008 11:18 AM:
>>> Hi friends,
>>> I want to implement the concept of sub-ledgers, does Ofbiz supports it.
>> If
>>> yes how to achieve it ?
>>>
>>> Can anyone please help me out ?
>>>
>>>
>>>
>>>
>>> Thanks
>>> Kunal.
>>>
>>
>
Re: Sub-ledgers in Ofbiz ?
Posted by BJ Freeman <bj...@free-man.net>.
using an Seca is what I would recommend.
these are used like in the shopping cart to update the grandtotal.
so you don't post to the top level just the sublevels
then the Seca compute the next tier up.
Now by double posting you mean debit and credit each one is a
transaction in itself so they get entered after the transactions balance.
take a look at
applications\accounting\script\org\ofbiz\accounting\ledger
kunal aggarwal sent the following on 8/11/2008 12:59 PM:
> Hi BJ,
> I have done posting in GL accounts through this child parent relationship
> but by sub-ledger I mean that one among following should work :
> 1. two corresponding postings to two GL accounts i.e. one child and its
> parent.
> 2. or I should have an summing effect of childs to parent.
>
> To my knowledge both does not happen presently. Please suggest something.
>
> Thanks
> Kunal.
>
> On Tue, Aug 12, 2008 at 1:03 AM, BJ Freeman <bj...@free-man.net> wrote:
>
>> I have seen a lot of discussion about this.
>> I think there needs to be some definition of terms
>> before we talk about sub ledgers.
>> GL is the end product of all transactions.
>> the GL represents in single Dollar values for a GL account Code.
>> There are no invoice or transaction related directly to the GL.
>>
>> The Transactions calculated for each GL and at some point Posted.
>> at that time the Transaction history is for audit only.
>> and Invoice is a debit to the Tranactions and a payment is a credit
>> so you Transactions must balance before you can post to the GL.
>>
>> so a GL is best represented, for this discussion, by
>> https://demo.hotwaxmedia.com/accounting/control/GlAccountNavigate
>>
>> A sub ledger is a more detailed representation of a particular GL main
>> account.
>> so lets take GL account 700000 other expenses
>> under that you have a sub account 701000 Credit card Service Charges
>> Under that you have a further sub acct of differnt CC 701100-701400
>> Now if you wish to add more under each of those you have two more number
>> if you wish to expand this then you need to revise the numbering system
>> to accomodate the detail you want.
>>
>> Now say you want this broken down by Internal Organizations then you
>> you could then create the Internal Organizations and list them here
>> https://demo.hotwaxmedia.com/accounting/control/ListCompanies
>>
>> going thru setup and clicking on Chart of accounts
>>
>> https://demo.hotwaxmedia.com/accounting/control/ListGlAccountOrganization?organizationPartyId=MARKETING
>>
>> you can assign a GL account to Internal Organization
>>
>> So if you will ask your question based on this format maybe they can be
>> clarified.
>>
>>
>>
>> kunal aggarwal sent the following on 8/11/2008 11:18 AM:
>>> Hi friends,
>>> I want to implement the concept of sub-ledgers, does Ofbiz supports it.
>> If
>>> yes how to achieve it ?
>>>
>>> Can anyone please help me out ?
>>>
>>>
>>>
>>>
>>> Thanks
>>> Kunal.
>>>
>>
>
Re: Sub-ledgers in Ofbiz ?
Posted by "Vince M. Clark" <vc...@globalera.com>.
I'm not an accountant but here are my comments.
The only time I have seen systems actually "double post" is in multi-currency situations where transactions are conducted in one currency and reporting needs to be in two or more. At the time of transaction the currency conversion takes place and the transaction is posted in both currencies.
Otherwise the concept of a sub-ledger as I understand it is just a subset of the GL. Older systems and paper based systems actually maintain separate ledgers for different kinds of transactions (AR, AP, etc.) and then periodically post summary entries to a GL.
In OfBiz if you want to see a sub-ledger just run a report that is restricted to the kinds of transactions you want to see, such as AR Invoices.
----- Original Message -----
From: "David E Jones" <jo...@hotwaxmedia.com>
To: user@ofbiz.apache.org
Sent: Tuesday, August 12, 2008 2:18:50 AM (GMT-0700) America/Denver
Subject: Re: Sub-ledgers in Ofbiz ?
On Aug 11, 2008, at 1:59 PM, kunal aggarwal wrote:
> Hi BJ,
> I have done posting in GL accounts through this child parent
> relationship
> but by sub-ledger I mean that one among following should work :
> 1. two corresponding postings to two GL accounts i.e. one child and
> its
> parent.
This leads to redundant data and is discouraged in general with OFBiz
data modeling designs.
> 2. or I should have an summing effect of childs to parent.
This is how the GL account rollups work in OFBiz. Each account has its
own total for its own transaction entries, and a grand total that
includes the totals of all child accounts.
> To my knowledge both does not happen presently. Please suggest
> something.
Where have you seen #2 not happening? That should be supported in
screens, reports, summary total on-the-fly updating, etc.
-David
Re: Sub-ledgers in Ofbiz ?
Posted by David E Jones <jo...@hotwaxmedia.com>.
On Aug 11, 2008, at 1:59 PM, kunal aggarwal wrote:
> Hi BJ,
> I have done posting in GL accounts through this child parent
> relationship
> but by sub-ledger I mean that one among following should work :
> 1. two corresponding postings to two GL accounts i.e. one child and
> its
> parent.
This leads to redundant data and is discouraged in general with OFBiz
data modeling designs.
> 2. or I should have an summing effect of childs to parent.
This is how the GL account rollups work in OFBiz. Each account has its
own total for its own transaction entries, and a grand total that
includes the totals of all child accounts.
> To my knowledge both does not happen presently. Please suggest
> something.
Where have you seen #2 not happening? That should be supported in
screens, reports, summary total on-the-fly updating, etc.
-David
Re: Sub-ledgers in Ofbiz ?
Posted by kunal aggarwal <ku...@gmail.com>.
Hi BJ,
I have done posting in GL accounts through this child parent relationship
but by sub-ledger I mean that one among following should work :
1. two corresponding postings to two GL accounts i.e. one child and its
parent.
2. or I should have an summing effect of childs to parent.
To my knowledge both does not happen presently. Please suggest something.
Thanks
Kunal.
On Tue, Aug 12, 2008 at 1:03 AM, BJ Freeman <bj...@free-man.net> wrote:
> I have seen a lot of discussion about this.
> I think there needs to be some definition of terms
> before we talk about sub ledgers.
> GL is the end product of all transactions.
> the GL represents in single Dollar values for a GL account Code.
> There are no invoice or transaction related directly to the GL.
>
> The Transactions calculated for each GL and at some point Posted.
> at that time the Transaction history is for audit only.
> and Invoice is a debit to the Tranactions and a payment is a credit
> so you Transactions must balance before you can post to the GL.
>
> so a GL is best represented, for this discussion, by
> https://demo.hotwaxmedia.com/accounting/control/GlAccountNavigate
>
> A sub ledger is a more detailed representation of a particular GL main
> account.
> so lets take GL account 700000 other expenses
> under that you have a sub account 701000 Credit card Service Charges
> Under that you have a further sub acct of differnt CC 701100-701400
> Now if you wish to add more under each of those you have two more number
> if you wish to expand this then you need to revise the numbering system
> to accomodate the detail you want.
>
> Now say you want this broken down by Internal Organizations then you
> you could then create the Internal Organizations and list them here
> https://demo.hotwaxmedia.com/accounting/control/ListCompanies
>
> going thru setup and clicking on Chart of accounts
>
> https://demo.hotwaxmedia.com/accounting/control/ListGlAccountOrganization?organizationPartyId=MARKETING
>
> you can assign a GL account to Internal Organization
>
> So if you will ask your question based on this format maybe they can be
> clarified.
>
>
>
> kunal aggarwal sent the following on 8/11/2008 11:18 AM:
> > Hi friends,
> > I want to implement the concept of sub-ledgers, does Ofbiz supports it.
> If
> > yes how to achieve it ?
> >
> > Can anyone please help me out ?
> >
> >
> >
> >
> > Thanks
> > Kunal.
> >
>
>
Re: Sub-ledgers in Ofbiz ?
Posted by BJ Freeman <bj...@free-man.net>.
I have seen a lot of discussion about this.
I think there needs to be some definition of terms
before we talk about sub ledgers.
GL is the end product of all transactions.
the GL represents in single Dollar values for a GL account Code.
There are no invoice or transaction related directly to the GL.
The Transactions calculated for each GL and at some point Posted.
at that time the Transaction history is for audit only.
and Invoice is a debit to the Tranactions and a payment is a credit
so you Transactions must balance before you can post to the GL.
so a GL is best represented, for this discussion, by
https://demo.hotwaxmedia.com/accounting/control/GlAccountNavigate
A sub ledger is a more detailed representation of a particular GL main
account.
so lets take GL account 700000 other expenses
under that you have a sub account 701000 Credit card Service Charges
Under that you have a further sub acct of differnt CC 701100-701400
Now if you wish to add more under each of those you have two more number
if you wish to expand this then you need to revise the numbering system
to accomodate the detail you want.
Now say you want this broken down by Internal Organizations then you
you could then create the Internal Organizations and list them here
https://demo.hotwaxmedia.com/accounting/control/ListCompanies
going thru setup and clicking on Chart of accounts
https://demo.hotwaxmedia.com/accounting/control/ListGlAccountOrganization?organizationPartyId=MARKETING
you can assign a GL account to Internal Organization
So if you will ask your question based on this format maybe they can be
clarified.
kunal aggarwal sent the following on 8/11/2008 11:18 AM:
> Hi friends,
> I want to implement the concept of sub-ledgers, does Ofbiz supports it. If
> yes how to achieve it ?
>
> Can anyone please help me out ?
>
>
>
>
> Thanks
> Kunal.
>