Yes, setting up a solid accounting structure (in any ERP system in general, and specifically in OFBiz) can be daunting. That is why organisations hire business consultants that are subject matter experts.
Most of the the times this is done in tools like MS Excel first before loaded into the system. Regards, Pierre Smits *ORRTIZ.COM <http://www.orrtiz.com>* Services & Solutions for Cloud- Based Manufacturing, Professional Services and Retail & Trade http://www.orrtiz.com On Wed, Aug 20, 2014 at 12:11 PM, Jacques Le Roux < [email protected]> wrote: > I got it, thanks Pierre. It's indeed as products as told Jacopo. I was > only thinking at the time you create the chart of accounts and make an > error. So in this case better indeed to have only the solution Sharan > suggests > > Jacques > > Le 20/08/2014 11:22, Pierre Smits a écrit : > >> But remember: if you're about to setup a financial accounting structure >> always involve accounting or fico experts to get the best setup. Because >> they should be the owners of this. Don't do this on a trial and error >> basis in a production environment without their buy-in and support. GL >> setups are intendend to last for a longer span of time. >> >> Pierre Smits >> >> *ORRTIZ.COM <http://www.orrtiz.com>* >> >> Services & Solutions for Cloud- >> Based Manufacturing, Professional >> Services and Retail & Trade >> http://www.orrtiz.com >> >> >> On Wed, Aug 20, 2014 at 11:12 AM, Pierre Smits <[email protected]> >> wrote: >> >> Addendum: >>> >>> But with a expiration of the association (after having been taken in >>> production, and with transactions) we have to ensure that the data in the >>> transactions will show up in financial reports. >>> >>> Pierre Smits >>> >>> *ORRTIZ.COM <http://www.orrtiz.com>* >>> >>> Services & Solutions for Cloud- >>> Based Manufacturing, Professional >>> Services and Retail & Trade >>> http://www.orrtiz.com >>> >>> >>> On Wed, Aug 20, 2014 at 11:10 AM, Pierre Smits <[email protected]> >>> wrote: >>> >>> Jacques, >>>> >>>> Disassociating a gl account from an internal company should only happen >>>> when there are no other associations involved (i.e. transactions). When >>>> the >>>> setup has been done and it is taken into production, the risk of >>>> removing >>>> the association might jeopardize data integrity. This should never >>>> happen. >>>> >>>> Moreover, when you ask accountants they will say 'what is in, stays in'. >>>> Expiring the association would be better, to ensure that the gl account >>>> can't be selected anymore. >>>> >>>> Regards, >>>> >>>> Pierre Smits >>>> >>>> *ORRTIZ.COM <http://www.orrtiz.com>* >>>> >>>> Services & Solutions for Cloud- >>>> Based Manufacturing, Professional >>>> Services and Retail & Trade >>>> http://www.orrtiz.com >>>> >>>> >>>> On Wed, Aug 20, 2014 at 10:16 AM, Jacques Le Roux < >>>> [email protected]> wrote: >>>> >>>> Thanks Jacopo, >>>>> >>>>> Actually I think I was not clear enough. I know you have the book >>>>> (Sharan told me), I'm speaking about the page s 371 to 373, and notably >>>>> Sharan's note at the bottom of page 373. >>>>> There Sharan details how to associate accounts to a chart of accounts. >>>>> It's about creating a new chart of accounts from an empty one, for a >>>>> new >>>>> organisation for instance. So it's more an association than a creation. >>>>> That's why I ask this question, should we not put a remove button >>>>> there? I >>>>> mean a screen like this one http://demo-trunk-ofbiz. >>>>> apache.org/accounting/control/ListGlAccountOrganization? >>>>> organizationPartyId=Company (for another organizationPartyId) >>>>> >>>>> Jacques >>>>> >>>>> Le 20/08/2014 09:11, Jacopo Cappellato a écrit : >>>>> >>>>> Hi Jacques, >>>>> >>>>>> the reasons are similar to the reasons we don't have a way to remove a >>>>>> Product (and other records) from the system. >>>>>> >>>>>> Jacopo >>>>>> >>>>>> On Aug 20, 2014, at 9:06 AM, Jacques Le Roux < >>>>>> [email protected]> wrote: >>>>>> >>>>>> Hi, >>>>>> >>>>>>> Reading Sharan's books I found that you can't remove an account from >>>>>>> the chart of accounts without using the Webtools/Entity Data >>>>>>> Maintenance >>>>>>> >>>>>>> Is there a reason for that, or should we not create a Jira >>>>>>> improvement >>>>>>> issue? >>>>>>> >>>>>>> Thanks >>>>>>> >>>>>>> Jacques >>>>>>> >>>>>>> >>>>>> >>>>>>
