[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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.


------------------------------------------------------------------------------
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