Sub-ledgers in Ofbiz ?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
11 messages Options
Reply | Threaded
Open this post in threaded view
|

Sub-ledgers in Ofbiz ?

kunal aggarwal
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.
Reply | Threaded
Open this post in threaded view
|

Re: Sub-ledgers in Ofbiz ?

BJ Freeman
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.
>

Reply | Threaded
Open this post in threaded view
|

Re: Sub-ledgers in Ofbiz ?

kunal aggarwal
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 <[hidden email]> 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.
> >
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Sub-ledgers in Ofbiz ?

BJ Freeman
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 <[hidden email]> 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.
>>>
>>
>

Reply | Threaded
Open this post in threaded view
|

Re: Sub-ledgers in Ofbiz ?

brijesh m
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 <[hidden email]> 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.
>>>
>>
>



       
Reply | Threaded
Open this post in threaded view
|

Re: Sub-ledgers in Ofbiz ?

David E Jones
In reply to this post by kunal aggarwal

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


Reply | Threaded
Open this post in threaded view
|

Re: Sub-ledgers in Ofbiz ?

Vince Clark
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" <[hidden email]>
To: [hidden email]
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


Reply | Threaded
Open this post in threaded view
|

Re: Sub-ledgers in Ofbiz ?

BJ Freeman
In reply to this post by brijesh m
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 <[hidden email]> 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.
>>>>
>
>
>
>        

Reply | Threaded
Open this post in threaded view
|

Re: Sub-ledgers in Ofbiz ?

Rees Watkins
In reply to this post by kunal aggarwal
Thank you for your posting.

If I have a supplier eg DemoSupplier and I want to implement a Accounts Payable Sub-ledger how do I do this?
If I raise a purchase order for Company ( standard demo )  an entry will be made in the General Ledger Accounts Payable as expected.
If I want a sub-ledger for DemoSupplier you mail indicates 2 methods - 1 - setup a new entry in Chart of accounts 2- setup DemoSupplier as an Internal Organization.

For each method what do I have to do to set OFBiz up to post so I see a sub-ledger entry in addition to the GL entry when a purchase invoice is created?

Thank you
Rees Watkins



----- Original Message ----
From: BJ Freeman <[hidden email]>
To: [hidden email]
Sent: Monday, 11 August, 2008 9:33:16 PM
Subject: Re: Sub-ledgers in Ofbiz ?

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.
>

Send instant messages to your online friends http://uk.messenger.yahoo.com
Reply | Threaded
Open this post in threaded view
|

Re: Sub-ledgers in Ofbiz ?

Jacopo Cappellato-3
I think that the solution has been already answered in very recent  
posts (some of it are part of this thread), so please do some research  
and try to re-read them according to the new information you have now.

The idea is to create a new account (child of the Accounts Payable),  
then configure GL setup to post to that account if the party is  
DemoSupplier (there is a screen to do this, and an email in which I  
have explained how to do this). Then you can create a report (or use  
the existing screens) that shows you the summarized totals for the  
Accounts Payable tree.

Jacopo

On Aug 13, 2008, at 10:56 AM, Rees Watkins wrote:

> Thank you for your posting.
>
> If I have a supplier eg DemoSupplier and I want to implement a  
> Accounts Payable Sub-ledger how do I do this?
> If I raise a purchase order for Company ( standard demo )  an entry  
> will be made in the General Ledger Accounts Payable as expected.
> If I want a sub-ledger for DemoSupplier you mail indicates 2 methods  
> - 1 - setup a new entry in Chart of accounts 2- setup DemoSupplier  
> as an Internal Organization.
>
> For each method what do I have to do to set OFBiz up to post so I  
> see a sub-ledger entry in addition to the GL entry when a purchase  
> invoice is created?
>
> Thank you
> Rees Watkins
>
>
>
> ----- Original Message ----
> From: BJ Freeman <[hidden email]>
> To: [hidden email]
> Sent: Monday, 11 August, 2008 9:33:16 PM
> Subject: Re: Sub-ledgers in Ofbiz ?
>
> 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.
>>
>
> Send instant messages to your online friends http://uk.messenger.yahoo.com


smime.p7s (3K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Sub-ledgers in Ofbiz ?

BJ Freeman
In reply to this post by BJ Freeman
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 <[hidden email]> 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.
>>>>>
>>
>>
>>        
>
>
>
>