Remove an account from the chart of accounts
Locked
Remove an account from the chart of accounts
 
Administrator
|
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 |
Re: Remove an account from the chart of accounts
|
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 <[hidden email]> 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 |
Re: Remove an account from the chart of accounts
|
|
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 <[hidden email]> 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 > > |
Re: Remove an account from the chart of accounts
|
|
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 <[hidden email]> 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 < >> [hidden email]> 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 >>> >> >> >> > |
Re: Remove an account from the chart of accounts
|
|
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 <[hidden email]> 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 <[hidden email] > > 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 < >>> [hidden email]> 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 >>>> >>> >>> >>> >> > |
Re: Remove an account from the chart of accounts
|
|
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 <[hidden email]> 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 <[hidden email]> > 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 < >> [hidden email]> 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 < >>>> [hidden email]> 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 >>>>> >>>> >>>> >>>> >>> >> > |
Re: Remove an account from the chart of accounts
|
|
In reply to this post by Pierre Smits
exactly... for similar reasons we are not allowing to edit most of the data in PartyAcctgPreferences
Jacopo On Aug 20, 2014, at 11:10 AM, Pierre Smits <[hidden email]> 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 <[hidden email]> > 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 < >>> [hidden email]> 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 >>>> >>> >>> >>> >> |
Re: Remove an account from the chart of accounts
|
Administrator
|
In reply to this post by Pierre Smits
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 <[hidden email]> > 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 <[hidden email]> >> 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 < >>> [hidden email]> 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 < >>>>> [hidden email]> 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 >>>>>> >>>>> >>>>> |
Re: Remove an account from the chart of accounts
|
|
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 < [hidden email]> 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 <[hidden email]> >> 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 <[hidden email]> >>> 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 < >>>> [hidden email]> 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 < >>>>>> [hidden email]> 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 >>>>>>> >>>>>>> >>>>>> >>>>>> |
|
|
In reply to this post by Jacopo Cappellato-4
Hi All
I’ve been offline for a few days so missed the original post. Jacques – you’ve been running through the tutorial but please take a look in the main chapter on Business Accounting Setup on page 68. There is a paragraph as follows “It is important that you do not remove accounts that are active or have already been used for transactions. Even if the net balance is zero then from an audit perspective you should not be removing accounts” “….You should only try to remove accounts have never been used…..” Jacopo / Pierre - this on page 66 in your versions of the book. I'll make a note to update these details into the tutorial even if it’s a bit of duplication – it is important. Thanks Sharan |
Re: Remove an account from the chart of accounts
|
Administrator
|
Thanks for the details Sharan :)
Jacques Le 21/08/2014 09:28, Sharan-F a écrit : > Hi All > > I’ve been offline for a few days so missed the original post. > > Jacques – you’ve been running through the tutorial but please take a look in > the main chapter on Business Accounting Setup on page 68. > > There is a paragraph as follows > > “It is important that you do not remove accounts that are active or have > already been used for transactions. Even if the net balance is zero then > from an audit perspective you should not be removing accounts” > > “….You should only try to remove accounts have never been used…..” > > Jacopo / Pierre - this on page 66 in your versions of the book. > > I'll make a note to update these details into the tutorial even if it’s a > bit of duplication – it is important. > > Thanks > Sharan > > > > > -- > View this message in context: http://ofbiz.135035.n4.nabble.com/Remove-an-account-from-the-chart-of-accounts-tp4654059p4654131.html > Sent from the OFBiz - Dev mailing list archive at Nabble.com. > > |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |