Deleting documents in 1C 8.3 accounting. Accounting info. Through a mark for deleting objects
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 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 in 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, especially since it is impossible to cancel this operation!
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.
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.
Note: When you mark a directory group for deletion, all elements, as well as subgroups, will also be marked for deletion. Consequently, 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.
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.
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.
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 you need the objects with which this document is associated, 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.
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. By double clicking the mouse you can open the object. After the selection is made, you need to click Delete and the process of clearing the database of marked objects will begin.
In 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.
To automatically perform the procedure using a scheduled task, you need to set the Automatically delete marked objects on a schedule flag in processing and configure the schedule.
Do you need a 1C programmer?
Your advantages when working with us!
Free preliminary estimate of the cost of tasks before work begins.
The price of an hour of work for a programmer is 2 times lower than the market.
Priority quick response to urgent tasks - from 5 minutes!
A clear system for setting, tracking and submitting tasks.
We make video instructions on completed tasks.
We provide warranty support for 3 months for completed tasks.
How to delete objects (directories, documents) marked for deletion from the database in 1C: Accounting 8.3 (revision 3.0)
2017-02-15T15:51:46+00:00As you know, in 1C: Accounting 8.3 (revision 3.0) you cannot delete any object (directory, document) immediately. You can only mark it for deletion. This is explained by the fact that this object can be used in other database objects.
For example, a Nomenclature directory element marked for deletion can be used in existing implementation documents. Then this element cannot be deleted. And if the element is not used anywhere, removing it is easy!
Let us have the element “Brick” marked for deletion from the Nomenclature directory. Let's remove it from the database permanently.
1. To do this, go to the “Administration” section and select the “Delete marked objects” ():
2. Select “Automatic deletion of all marked objects” as the deletion mode. This option is almost always suitable. It may not be suitable only if, in addition to the “Brick”, we have other objects marked for deletion, which for some reason we do not want to delete now. And so - we always select the first option and press the "Delete" button.
3. The program will do everything itself and only at the end, if elements that are referenced by other elements of the database have been marked for deletion, a window like this will pop up. It shows elements that cannot be deleted (left side) and the objects that reference them (right side). Just click the "Close" button.
Suitable for 1C 8.3 ZUP, 1C 8.3 Trade Management, 1C 8.3 Accounting and other 1C 8.3 configurations. Let's study the launch mode of the 1C 8.3 program Managed application.
Not everyone knows that this treatment actually replaced the treatment Universal selection and processing of objects. And the mark for deletion in 1C 8.3 is considered a service attribute of the object. Therefore, we can talk about changing the document details if you want to mark the document for deletion.
How to mark for deletion in the document journal
It makes sense to use the processing discussed above in 1C 8.3 for complex selections and a large volume of deleted documents. If you delete documents from one document journal, you can proceed as follows.
Step 1
In the open journal of Implementations documents, we set the selection for the counterparty “Carpenter+” and the Organization “Ivanov IP”:
Step 2
Click Ctrl+A– mark all selection documents, then while pressing the key Ctrl Click on the document that does not need to be deleted. For example, sales less than 10,000 rubles. Thus, we selected the necessary documents according to the example, which are highlighted in color (in this case yellow):
Step 3
Right-click on the list. In the drop-down context menu (or by clicking the More) select the desired command Mark for deletion/Unmark:
We get the result - 6 selected documents are marked for deletion:
How to mark for deletion using processing Universal selection and processing of objects
There is special processing for Information Technology Support (ITS) subscribers UniversalSelectionAndProcessingObjects.epf. You can find it on the ITS disk in the directory \1CITS\EXE\ExtReps\Unireps82\UniversalSelection\ or by searching in the online version of the ITS.
True, it only works when running 1C 8.3 in normal application mode. For a managed application, you can find similar treatments on developer sites.
We will use processing for ITS subscribers. To do this, we will configure the launch of the 1C 8.3 program in normal mode. Let's look at an example in the 1C 8.3 ZUP 3.0 program. We launch the 1C ZUP 3.0 program in Configurator mode. On the menu Service Parameters on the bookmark Launch of 1C Enterprise put a dot, as in the figure below, at the application Thick client (regular application):
Click apply. We launch the 1C ZUP 3.0 (8.3) program in mode Company(you can use the F5 button from the configurator). Now you can from the menu File – Open select processing from the directory where it is installed (or you can connect it).
Problem to be solved: Mark all documents for deletion Payroll and contributions for the Main Division for the period February-June 2016. for organizing Ideal in 1C 8.3 ZUP 3.0
Step 1
In the Search Object window, start typing the word “accrual”. The 1C ZUP 3.0 (8.3) program will offer options in the drop-down list. Selecting an object Calculation of salaries and contributions:
Step 2
On the Selection by details values tab, use the “green button with a plus” to add selections, and set the condition: date > 02/01/2016, since the 1C 8.3 ZUP database contains the latest documents for June 2016:
Step 3
Click on the button Find Objects. We get the result. If we don’t want to mark an object for deletion, then uncheck the box next to it:
Step 4
Go to the bookmark Processing. Selecting processing Mark for deletion By clicking on the arrow, move it to the right side of the window - Selected treatments. Click Run. We get the result:
Step 5
Next, open the Payroll journal. We see that all payroll documents from February for the “Ideal” organization (except for the document for not to the Main unit) are marked for deletion. Let's open a document that is not marked for deletion. We see that it is formed according to Division 2:
How to mark all documents for deletion at once without checking referential integrity
For example, this method can be used when a 1C 8.3 user decides to completely clear the 1C 8.3 database of documents, and use the existing directories and settings to keep records for another organization.
In the Main Menu (triangle in the upper left corner) select All functions. Finding processing
On the bookmark Deleting data With this processing, you can select not only all documents to be deleted at once, but also set individual types of documents and the deletion period. By default in 1C 8.3 there is a checkmark Delete objects, for which you have access rights:
We tick all documents. All you have to do is press the button Delete. But, please note that without referential integrity control, it makes sense to delete configuration objects when cleaning the 1C 8.3 database or when debugging the transfer (warning message from the developers). In other cases, it is better to mark objects for deletion.
In the 1C program, almost no object can be physically deleted immediately. This feature can be configured in roles (the “delete” and “interactive deletion” rights). Typically, the developer does not allow such actions to be performed in order to avoid disastrous consequences in the future.
Marking for deletion means that the object is no longer relevant for the user. When a mark is placed on a document, its posting is automatically cancelled.
Example of deleting a directory item Nomenclature
In our example, we will delete an element, but the process of deleting a document or any other object is no different from the instructions given.
Let's set a checkbox for deletion directly from the list form of this directory. To do this, select the position we need and press the Del key on the keyboard (or use the context menu).
The program will ask us a question about the need (or removal) of the deletion mark. Let's answer “Yes”.
After this, a sign will appear next to the selected directory element. We remind you that if a configuration object has delete or interactive delete rights, then using the Shift+Del combination you can immediately delete it physically.
Now we can proceed to directly deleting our directory object. If you do not have access to this functionality, it means that you do not have the appropriate rights to it.
Select the “Delete marked objects” item in the “Administration” menu.
This functionality is also available in the “All functions” menu.
In the window that opens, the program will ask you to choose whether you want to delete all objects marked for deletion or only some. In our example, we will only delete the item “Edged board 50*250*300”.
For some time, the system will calculate whether other infobase objects reference our board. As a result, the program gave us a notification that deletion was impossible.
In order for our item to be deleted, we need to mark all objects in the table on the right for deletion. Another option is to replace our object with another everywhere.
You shouldn't have any problems marking related objects for deletion, so we'll choose a replacement.
Click on the "Replace..." button.
Let's select the item that will be replaced in all related objects. After this, you will again be presented with a window to delete again. This time everything went well, as the program notified us about.
Automatic deletion of marked objects according to schedule
In newer versions of the 1C program (starting from 8.3), the developers have added a very convenient ability to automatically delete marked objects on a schedule. Let's look at how to make this setting.
In the form that opens, go to the “Routine Operations” section and check the box “Automatically delete marked objects on a schedule.” After this, the “Set up schedule” hyperlink will become active for you. Follow it.
A standard form for setting up a schedule will open in front of you. If necessary, you can change the default values, but so that the start time of this routine operation does not coincide with the working hours of your organization’s employees.
