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. |
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. > |
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. > > > > |
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. >>> >> > |
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. >>> >> > |
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 |
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 |
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. >>>> > > > > |
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 |
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 |
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. >>>>> >> >> >> > > > > |
Free forum by Nabble | Edit this page |