Hi Cameron, The main problem in this approach is still the same suppose I have a company called ABC which has 3 stores now suppose I receive an invoice from a vendor for $1000. This invoice is for 3 stores with $400, $300 and $300. This is of type expense so my accounting entry would be: 1. DR. Expense (Store 9000) $400 2. DR. Expense (Store 9010) $300 3. DR. Expense (Store 9020) $300 4. CR. AP (Vendor ABC) $1000
For any sales my entry would be like: 1. DR. AR (Store 9000) $20 2. CR. Revenue (Store 9000) $18 3. CR. VAT (Store 9000) $2 4. DR. Cash (Store 9000) $20 5. CR. AR (Store 9000) $20 For inventory and COGS we will have: 1. DR. COGS (Store 9000) $10 2. CR. INVENTORY (Store 9000) $10 So similar to concept of class in quickbooks I can have a single COA (Charts of Accounts) for the whole company and then use this store id dimension or class to segregate it across stores or cost center. This would be able to generate a clean Profit and Loss and all the expense report by shop and by cost center. Using party role id means creating a subsidiary. Indeed in store setup we already have a store id so it can be similar. Regards, Vikrant -----Original Message----- From: Cameron Smith [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 05, 2007 1:41 PM To: [email protected] Subject: Re: How to implement activity based costing in ofbiz Dear Vikrant, you could create a Party (or PartyGroup) to represent the internal organizational unit which runs each store. Then associate a certain GlAccount with this Party via GlAccountRole. The only drawback here is that GlAccountRole does not have an organizationPartyId field. Therefore if your system runs the accounting for multiple distinct organizations, and two of them use the same store, you will have to be careful to avoid clashes between GlAccountRoles. Perhaps by creating distinct roles with a certain unique prefix or suffix based on the accounted' party's ID. cameron > > Subject: How to implement activity based costing in > ofbiz > Date: Mon, 4 Jun 2007 17:32:04 +0800 > From: <[EMAIL PROTECTED]> > To: <[email protected]> > > Hi Everyone, > > Does anyone have an idea how to implement activity > based costing in ofbiz? To be precise what I mean is > in QuickBooks if you are running multiple stores you > can have P & L (Profit and Loss) by store by using > class which identifies what > activity/program/function will be affected by the > transaction or what funding source is affected. > > But to have P & L for each store or business > division the General Journal should have a store > code or some cost center code similar to class in > Quickbooks. > > There are some customization which can be done to > accommodate it. But does anyone can point to > existing data model in accounting which can be used > for similar purpose. > > Regards, > Vikrant ___________________________________________________________ Yahoo! Mail is the world's favourite email. Don't settle for less, sign up for your free account today http://uk.rd.yahoo.com/evt=44106/*http://uk.docs.yahoo.com/mail/winter07.html No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.8.9/832 - Release Date: 6/4/2007 6:43 PM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.8.9/832 - Release Date: 6/4/2007 6:43 PM
