Re: Delete / Drop From All

On Wed, Dec 3, 2014 at 7:32 AM, Peter van Bussel <..hidden..> wrote:

Hi Chris,

Thank you for your help. The SQL-script underneath disables only users I guess. How about customers and vendors?

Is there still a missing functionality in 1.4.7 for deleting/ dropping contacts or am I missing something?

Set an end date. We do need a delete customer/vendor button that will delete a customer or vendor if not linked to any transactions but it isn't there current;y.

You can also delete from the entity_credit_account, person, company, and entity tables as appropriate. Foreign keys are enforced so you can't delete anything linked elsewhere without knowing about it.

Regards,

Peter

Van: Chris Travers [mailto:..hidden..]
Verzonden: woensdag 3 december 2014 12:53
Aan: LedgerSMB Users
Onderwerp: Re: [Ledger-smb-users] Delete / Drop From All

On Wed, Dec 3, 2014 at 3:53 AM, Peter van Bussel <..hidden..> wrote:
Hi All,

I am missing Delete / Drop From All in my 1.4.7 contacts list.

Any suggestions?

As a temporary workaround:

ALTER USER username WITH VALID UNTIL 'yesterday';

Regards,

Peter

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

--
Best Wishes,
Chris Travers

Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in.
http://www.efficito.com/learn_more

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

Best Wishes,

Chris Travers

Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in.

http://www.efficito.com/learn_more