Stand: 07.07.2009
EULANDAŽ ERP System Head Start thru Technology
Home Information PDF Documents EULANDA Handbooks Training Book's corner Download Contact us Table of Contents About us
Password needed Newsgroup
Delete Data
Data records are deleted, using either the "-" symbol from Navigator in the tool bar or the "DEL" key from the keyboard. Please be reminded, that only those records can be deleted, which do not have any connections to other records, hence are not longer needed in the system. Delete data records means among others, "delete addresses, articles, Proposals, Sales and Purchase Orders etc.
Tool bar with symbol to delete data records.
Let's assume, you want to delete an article, which has been used or is in use in any other action - proposal, orders etc, the system will deny this action. The SQL Server checks before any transaction, whether this condition is true or not. In case the SQL Server finds connection of any kind to the object in question, the delete transaction will be aborted and an error message will be displayed.
The only way to delete for example an article, which is used in an invoice, is to delete the invoice, delivery note and sales order. Then, and only then, the article can be deleted. An easier and more secure way is to hide the article or address in question. Check the help to learn more about that solution.
As long as the data to delete is used by any other module in the system, it can't be erased. This applies to all interconnected data system wide e.g. no address can be erased, as long as it is connected to any invoice / order, no term of payment can be deleted, when it is in use.
This protection guaranties the consistency of your data and assures the correct processing of the data.
Hint: Hide data record
If you want to
hide a data record, you find a small explanation in the developer's
manual, to alter your system accordingly.