You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Jacques Le Roux <ja...@les7arts.com> on 2014/08/20 09:06:30 UTC
Remove an account from the chart of accounts
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
Posted by Jacques Le Roux <ja...@les7arts.com>.
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.
>
>
Re: Remove an account from the chart of accounts
Posted by Sharan-F <sh...@gmail.com>.
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.
Re: Remove an account from the chart of accounts
Posted by Jacopo Cappellato <ja...@hotwaxmedia.com>.
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 <pi...@gmail.com> 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 <ja...@free.fr>
> 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 <
>>> jacques.le.roux@les7arts.com> 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
Posted by Pierre Smits <pi...@gmail.com>.
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 <
jacques.le.roux@les7arts.com> 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 <pi...@gmail.com>
>> 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 <pi...@gmail.com>
>>> 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 <
>>>> jacques.le.roux@free.fr> 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 <
>>>>>> jacques.le.roux@les7arts.com> 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
Posted by Jacques Le Roux <ja...@les7arts.com>.
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 <pi...@gmail.com>
> 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 <pi...@gmail.com>
>> 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 <
>>> jacques.le.roux@free.fr> 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 <
>>>>> jacques.le.roux@les7arts.com> 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
Posted by Pierre Smits <pi...@gmail.com>.
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 <pi...@gmail.com>
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 <pi...@gmail.com>
> 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 <
>> jacques.le.roux@free.fr> 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 <
>>>> jacques.le.roux@les7arts.com> 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
Posted by Pierre Smits <pi...@gmail.com>.
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 <pi...@gmail.com>
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 <jacques.le.roux@free.fr
> > 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 <
>>> jacques.le.roux@les7arts.com> 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
Posted by Pierre Smits <pi...@gmail.com>.
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 <ja...@free.fr>
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 <
>> jacques.le.roux@les7arts.com> 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
Posted by Jacques Le Roux <ja...@free.fr>.
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 <ja...@les7arts.com> 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
Posted by Jacopo Cappellato <ja...@hotwaxmedia.com>.
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 <ja...@les7arts.com> 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