1c forced deletion of marked objects. Accounting info. Deleting marked objects without exclusive mode
The 1C Enterprise system initially does not involve direct deletion of any objects from the database, for example elements of directories, documents, reports, etc. Of course, you can still configure the user’s role so that he can immediately deleted from 1s some object no mark for deletion, but doing this is highly not recommended. We would also like to note the fact that even if the user’s role is configured to directly delete objects (interactive deletion), this is still will not allow him to delete some objects in enterprise 1c, and this can only be done through mark for deletion.
Why was the mark for deleting objects in 1c made?
Let’s answer the question “Why was this mark for deletion made?”, because it’s faster delete an object from 1s straightaway. This was done for several reasons:
- There is a possibility that the user will subsequently change his mind and want to return the deleted object, when there is a check mark, it is enough to uncheck it, If you delete it interactively, you cannot restore data.
- In 1c, one object, for example a document, can refer to many other objects in the system (directories, constants, other documents, etc.), and at the same time many other objects can also refer to this object (in our case, a document). If the 1C enterprise system allowed direct deletion of objects from the database, this would lead to dire consequences, since objects with “broken links” would immediately begin to appear, and this would be a loss of data and incorrect functioning of the database, which sooner or later it will lead to the collapse of the database and almost complete loss of your data!
Two types of deletion in 1c, the concept of referential integrity control in 1c
In the program 1c objects can be deleted in two ways:
- Using interactive deletion (direct deletion without referential integrity checks)
- Through a deletion mark (deletion with referential integrity check)
Let's look at what referential integrity is in 1C. But in order for you and me to answer this question, we need to know what “broken” links are in 1C. For those who don’t know, broken links in 1c are links that point to an unused memory area, that is, they essentially point to nowhere. Now let's take as an example any document in the 1C enterprise system. It contains many different details. These details can be either simple (primitive types such as number, date, boolean), or they can be object (such as links to other system objects, for example various directories, enumerations, etc.) So here is the control of referential integrity in 1c this precisely means the fact that the object will not be deleted from the 1c system as long as it is referenced by any other objects of the system. Just marking the deletion of 1c objects allows you to preserve the referential integrity mechanism in 1c, since processing the deletion of marked objects will not allow you to delete an object while other objects are referencing it.
How to restore deleted objects in 1c? What happens to objects after they are deleted from 1C?
Many people ask us similar questions, and there is only one answer: physically deleting data from 1c (using the methods described below) leads to COMPLETE DESTRUCTION OF THE FILE FROM THE BASE! Recovery deleted files from the database is not possible.
We are always ready to provide you with timely assistance in updating the 1C 8.3 system.
Interactive deletion in 1s
So we have already discussed with you that interactive deletion in 1s occurs without referential integrity control, and this is fraught with very bad consequences for the system; it is recommended to use such deletion only for debugging purposes. To enable interactive deletion 1s We first need to go to the configurator, open the General ---> Roles branch and select the “Full rights” role.
Now press the F9 key, the role “Full Rights” is copied and another “Full Rights1” appears. Open it by double clicking the mouse. The role properties window will appear, click the "Actions" ---> "Set all rights" button. After that, click OK. Now let’s save the database configuration; to do this, click on the little blue barrel in the upper left corner, or press the F7 key. If the barrel becomes inactive, then the configuration is saved. We have created a role with rights to interactive deletion of objects from 1c .
Now in the configurator, open the Administration ---> Users tab.
A list of users will open, select the user under which you want to enable interactive deletion of 1c objects and press pencil or F2. The user properties window will open, go to the second tab "Other". There, find the role that we copied, in my case it is “Full Rights1”, check the box and click OK.
After this, launch 1C Enterprise, select the user for whom the new role was installed. Now you can delete objects directly, to delete an object select it and press the combination SHIFT key+ DEL, the system will ask if you are sure about deletion; if the answer is yes, the object will be deleted from the system.
Deleting 1c objects by marking them for deletion or how to delete objects in 1c?
Now let's look at the question with you " How to delete objects in 1c?". So, we open the database we need in 1C enterprise. The screenshot shows "Accounting government agency", click in the menu on the "Operations" tab ---> " Removing marked objects".
If you have a managed interface, such as in "Enterprise Accounting Rev. 3.0", then there you need to go to the "Administration" tab, there you will see the "Service" subgroup, and in it you need to select " Removing marked objects".
An alternative way to open the object deletion assistant in 1C 8.2 and 1C 8.3
In general, if you cannot find a button in your configuration with which you can call the wizard deleting marked objects 1c, then in 1C 8.2 you can open it in the following way, this method suitable for any configuration, the screenshots below show what actions need to be performed in 1C 8.2. Open the tree of all treatments that are in the system and select " Removing marked objects".
If you are working on the 1C 8.3 platform and you have a configuration with interface driven, then you need to enable the “All functions” button; see how to do this.
Start searching for objects marked for deletion in 1c
A window will appear in front of us, which is shown below, it will reflect all objects marked for deletion in the system. We check off those that we want to delete; in general, it is advisable to delete them all, because they are marked for deletion, which means they are no longer needed in the system. After you have noted everything you need, click “Control”.
The system will take some time to complete this task, a little later you will see the window shown below. Please note that you may have objects with both green and red checkmarks.
Green means that the object can be deleted, red means that it cannot. An object marked with a red checkmark cannot be deleted, since it is referenced by other system objects. In the window below you will see those objects that reference it, and before you delete an object marked with a red checkmark, you need to remove references to this object from other objects. What does this mean in practice?
The need for timely removal of objects marked for deletion in 1c. How to delete objects marked with red checkmarks?
Let's look at an example using the "Enterprise Accounting" configuration. We have a document “Acceptance for accounting of fixed assets”, it respectively indicates the main asset (for example, a computer) and many other parameters, but they do not at the moment not interested. If we want to remove this OS from our database, then without additional actions we will not be able to do anything. Our OS (computer) will be marked with a red tick when we try to remove it. Why? But our document “Acceptance for accounting of OS” has a link to the OS that we now want to delete! When we click on it in the list of objects, we will see all the objects that reference our OS, and before we delete this OS, we need to first go into all these objects and delete the references. In our case, this means that we need to cancel the document “Acceptance for accounting of fixed assets”, and delete this fixed assets from the document, and then record the document. Now the document no longer references our OS, and we can delete it. One rule follows from all this: It is necessary to delete objects marked for deletion in 1C in a timely manner! Otherwise, getting rid of them later can be very, very problematic, due to the fact that there will be a large number of links between objects. By the way, timely deleting objects from 1s also has several obvious advantages:
- System performance increases
- Reduces the likelihood of user errors
- Reduces the size of your database
- There is no “interface clutter” when the system has many objects marked for deletion, documents posted, and also not posted.
In our company you will always receive first-class service for the 1C program at very reasonable prices!
Completing the removal of marked objects in 1s
Now let's delete the objects completely. Click the "Delete" button. The system will delete all objects that were marked with green checkmarks.
Only those marked with red checkmarks will remain, click “Close”, this is the process deleting objects from 1c completed. If something doesn’t work out for you, we are ready to connect to your 1C remotely and help solve your problems.
1c deleting marked objects, detailed video instructions about deleting 1c objects
- We tell you why you need a deletion mark in 1c
- We show with an example how to delete objects in 1C
- Useful practical advice is given
- We show how to delete objects marked with red checkmarks in 1C
- There is also a lot of other useful information
We hope that our article is about deleting objects marked for deletion in 1C She was very helpful and answered all your questions.
Today we will talk about deleting documents, as well as any 1C Accounting object data in general (I explain what object data is and how it differs from others in my full 1C Accounting 8 course with examples). Sometimes there are situations ( yes, perhaps not sometimes), when you need to delete a document, but it doesn't want to leave. Let's see why this happens and how to fix it.
Since we are talking about removal, and this operation irrevocable, then be sure to read the article about database backup. Very often this helps to avoid major problems in the company!
How to delete a document in 1C Accounting
First, let's look at how objects are generally deleted in 1C Accounting 8. First of all, it should be said that not a single object (1C document, directory element, etc.) can be deleted directly, as, for example, we delete unnecessary files on Windows. The process of deleting documents in 1C is a little different.
COMMENT! In some versions of 8.3 it is possible to directly delete elements, including pre-installed ones(!). Never use this, much less cancel it this operation impossible!
To delete a directory element, group or document that you no longer need, you must first mark for deletion. This can be done using the key Delete on the keyboard or the corresponding button on the toolbar. Below is an example from 1C Accounting 8.3:
Before clicking the delete button, make sure that the desired object is selected in the list. During the operation, the program will ask for confirmation of the action.
website_After confirmation, the object will be marked in the list with a red cross on the left, as in the figure below. By the way, about the cross, but another one, there is another one here on the site.
website_Please note: When you mark a directory group for deletion, all elements, as well as subgroups, will also be marked for deletion. As a result of this, If there are many elements in the group marked for deletion, the process may take some time!
You can remove a mark for deletion in the same way as you can mark it.
If you mark it to , its execution is cancelled.
To finally get rid of 1C Accounting database objects marked for deletion, you need to start processing "Deleting marked objects". For 1C Accounting 8.3, to do this, go to the main menu.
website_And for 1C Accounting 8.2, to delete marked objects you need to go to the menu "Operations / Deleting marked objects." or in the "Administration" section.
website_Remember: deleted objects cannot be restored. No way.
There was an important part of the article, but without JavaScript it is not visible!
Why is the document not deleted?
However, quite often there are situations when an object marked for deletion cannot be permanently deleted. For some reason the program cannot do this. Why?
In 1C Accounting, a document or directory element cannot be deleted if there is at least one link to it.
Thus, if a document “does not want” to be deleted, it means that it is referenced by other documents in the 1C database. What do you mean by reference? Very simple. This means that in another document There is a field in which this "non-deletable document" is selected as a value. An example for 1C Accounting 8.2 is given below.
website_If you try to delete the invoice underlined in this document, then a situation with an “eternal” document will arise. There is a separate article about such cases when a document or directory element is not deleted. I recommend checking it out.
Let's sum it up
If you do not delete any document, directory element or anything else that is deleted by setting a deletion mark, then you need to sequentially delete all links to the object being deleted. Only in this case there will be no obstacles to its final removal.
Of course, if the objects with which it is associated this document, you need, then you can forget about deleting. For example, there was a warehouse. Then he was liquidated. However, it will no longer be possible to remove it from the 1C Accounting database, since it is used in many documents. However, after collapsing the database, you can still get rid of unnecessary documents.
I discuss the features of working with objects marked for deletion, deleting links to objects and other related issues in my full course on 1C Accounting. After completing the training course, all your questions about 1C will disappear.
In the process of work, almost every accountant encounters situations when, for one reason or another, it is necessary to delete either a document or an element of the directory. In the 1C program, deletion occurs according to a procedure similar to deleting files in the operating room Windows system, but with a number of differences. Those. First, the item to be deleted is marked with the appropriate sign, i.e., as if placed in the trash. Physical removal is carried out after performing a certain algorithm of actions. How to delete documents marked for deletion in 1C.
Complete deletion occurs after checking all possible links in information base data. Often, differences in the format of the actions performed cause confusion and difficulties for program users. Now we will deal with the issue of deleting documents in different versions of the 1C program. It is worth noting that this procedure is almost the same in different program configurations.
In 1C version 7.7, to delete a document, you need to select the exclusive operating mode when entering 1C:Enterprise mode. Actually, exclusive mode is not needed to mark for deletion, but it is necessary to physically delete marked objects.
After logging in, select the desired entry in the journal and click on it right key, then select “Mark for deletion.” After this, the document or directory element will change the icon to an icon with a cross. Pressing the “Del” key on the selected element will have the same effect.
After this, the document is considered deleted and does not participate in calculations performed automatically by the program. However, it remains in the information base. For him complete removal proceed to processing that deletes marked files. To do this, close all windows in 1c and click the main menu item “Operations” and the submenu “Deleting marked objects...”.
Agree with the proposal to continue the operation.
In the window that opens, you will see a list of all documents or directory elements to be deleted. In our case, this is only one document.
The top menu buttons control actions on documents. A button with an icon of installed checkboxes will highlight the entire list of documents. Next button with empty cells will clear the selected list. The third button opens the selected document.
Select the documents or directory elements that need to be physically deleted and click the “Control” button. This button analyzes reference links with the selected document. Note that the “Delete” button is not available before control. After conducting a control check, if there is a problem-free ability to delete an element, the “Control” button becomes unavailable and the “Delete” button becomes available. To physically delete a document, simply click the “Delete” button and agree to the final warning.
The document has been deleted.
However, there are cases when the check of reference relationships ends with the discovery of relationships with the selected document of other documents. In this case, until all detected links to the document being deleted are removed, it will be impossible to perform a complete deletion.
****************************************************************
In 1C version 8.2, to delete a document you need to select the document to be deleted and click right button for the appearance context menu. Next, you need to select “Set deletion mark” and agree to the warning. These actions will also occur when you press the “Del” key.
Yes, 1C 8.2 is not 7.7, even the deletion mark on the document is suspiciously long.
We agree with the warning about the duration of the operation.
In the window that opens, we see a list of database elements marked for deletion. The assignments of the control buttons are similar to those discussed in the section for 1C version 7.7. List selection of documents, list deselection, and opening of the selected document are available.
Select the desired element or group of elements and press the “Control” button to check the links. After checking, it turned out that there is a link to the Expense Invoice document that we are deleting in the Tax Invoice document. Let's delete the link to the consumable patch and check the links again.
After deleting the link, we carry out repeated control, after which it becomes possible to delete the selected invoice.
By clicking the “Delete” button, we delete the document permanently.
Download illustrated instructions:
You can discuss the operation and ask questions about it at.
When starting to work in 1C company programs, many people have a question: how to delete unnecessary documents or directory elements? When you click on the "Del" button, the document is only marked for deletion and remains in its place. After reading the article you will know the answer to this question.
Now we will look at how to delete documents in different programs 1C. A common point for all programs is that deletion is only possible in exclusive mode, i.e. No one except you should be working in the program at this moment; it should be closed on all other computers.
Now let’s figure out how to remove unnecessary elements in one of the most popular programs at the moment - 1C: Enterprise Accounting 8, version 2.0.
First you need to switch the interface to Full. Go to the menu item
Tools -> Switch interface -> Full
Now select the item
Operations ->
And we agree that the operation may take a long time. Then in the window that opens, click the “Control” button.
The program begins checking whether other documents contain links to the ones you want to delete. For example, the document “Sales of goods and services” is marked for deletion, but there is a link to this document in the invoice. The program will report this and will not delete the document in this case. In order for a document or directory element to be deleted, you must first remove links to it from all other documents.
Green checkmarks in the figure indicate those documents that can be deleted, and red checkmarks indicate those that have links. The bottom part of the form shows which documents use the object marked for deletion.
After clicking the "Delete" button, those items that are marked in green will be deleted.
To delete objects in new version 1C: Accounting - edition 3.0 you need to go to the "Administration" tab and select the "Delete marked objects" item.
And starting from version 3.0.34, you need to go to the menu
Administration -> Support and Maintenance -> Deleting marked objects
Then you need to choose whether you want to delete all marked objects or just some of them.
In the 1C program: Comprehensive automation 8 and 1C: Salary and personnel management 8 you also need to switch the interface to “Full” and go to the menu
Operations -> Deleting marked objects
In conclusion, I would also like to note that documents that are marked for deletion but are found in a closed period (a date for prohibiting editing has been set) will not be deleted. Therefore, it is better to do everything in a timely manner, for example, once a month or before starting preparation for reporting.
And if you need more information about working in 1C: Enterprise Accounting 8, then you can get our book onlink.
Send this article to my email
When trying to delete an unnecessary system object (directory item, document, report option, etc.), the user will not be able to permanently remove it from the 1C database; he can only set a mark for deletion. Therefore, the question arises - How to delete marked objects in 1C 8.3?
In this article we will look at how to complete this process. The deletion functionality for many configurations is identical and the described technique is suitable for UT, ERP, Accounting and ZUP.
To completely remove an object from the 1C database, you must run the Deletion of marked objects processing. This was done not to complicate the work of users, but to avoid errors. For example, if you remove the counterparty to whom the sale is registered, the products will be sold to no one. Therefore, it is impossible to simply remove objects from the system; you must first make sure that it is not used anywhere and its absence will not lead to errors in the program, and it is for this purpose that the Deletion of marked objects processing is provided.
Thus, in 1C, deletion is performed in two stages:
Setting a mark for deletion in 1C;
Final removal by processing if the object is not involved in any way in the system.
How to set a deletion mark in 1C 8.3?
To set a mark for deletion in 1C, select the desired reference book/document (you can also select a list of objects at once), in the More menu, select the Mark for deletion/Unmark command (in some magazines an icon of this command is displayed) or press the delete button on your keyboard . The system will ask you to confirm your intentions and after that the mark will be checked.
Please note that if you try to set a mark on an already marked element, the reverse action will be performed - unchecking it.
How to delete marked objects?
In Accounting and ZUP, processing is available in the Administration section, in UT and ERP in the Master Data and Administration → Support and Maintenance section. And if you suddenly forgot in which section to look for the desired system object, you can always use the All functions section.
Processing Removal of marked objects is controlled by referential integrity, i.e. if the object being deleted has references in other objects, the deletion procedure will not be performed.
Two processing modes are available, automatic and manual (selective), and you can also set up a routine task for automatic removal according to a specified schedule.
In selective mode, the system will display all items marked for deletion, grouped by type. Using the checkboxes, you can select objects that you want to permanently remove from the system. Double click mouse can open the object. After the selection is made, you must click Delete and the process of clearing the database of marked objects will begin.
At automatic mode this process will start immediately.
As a result, regardless of the selected mode, processing will attempt to delete all objects that have the mark. If deletion is not possible, a list of non-deleted objects will be displayed with links to their places of use.
The options available in this case are:
Mark the places of use for deletion and try to delete again.
Make corrections at points of use. For example, if you need to delete an employee who is in the Hiring list document, you need to delete him from this document.
Perform the replacement procedure using the Replace command. A list of similar items for replacement will be offered. For example, if you need to replace a characteristic of an item in a document, a list of characteristics of the same item will be offered.
For automatic execution procedures using regulatory task In processing, you need to set the Automatically delete marked objects according to schedule flag and configure the schedule.