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

As 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 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 removal all marked objects." 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. Otherwise, we always select the first option and Click 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.

Sincerely, Vladimir Milkin(teacher and developer).

How to delete documents and directories in 1C 8.3? In the program, you can delete marked objects in two ways:

• Interactive deletion;
• Through a mark for deleting objects.

Let's look in detail at examples of how to delete documents marked for deletion in 1C 8.3.

Interactive deletion in 1C

Interactively delete in 1C– this is to delete immediately, without checking referential integrity.

Attention!!! IN in this example shown - how it is forbidden do!

IN typical configurations 1C developers have disabled this feature for most documents and reference books:

And what could this lead to if there was such an opportunity? For example, in the demo database configurator we will enable the ability to edit objects, and for the role Full rights for reference books Nomenclature And Counterparties check the box Interactive removal:

Now let's go into user mode and delete a couple of directory elements by first selecting and clicking Shift + Del:

• Directory Contractors:

• Directory Nomenclature:

And now in the 1C 8.3 configurator we will launch Testing and fixing and check the referential integrity of the information base. As a result, we get a large number of errors in various objects:

In the user mode of 1C 8.3, for example, in the document Sales of goods we will see broken links, that is, links to objects that no longer exist:

And we just deleted two elements of the directory. What could further work with interactive deletion lead to? Therefore, it is recommended to uncheck the interactive deletion box in 1C 8.3.

Through a mark for deleting objects

With this method of deletion, referential integrity is checked and if the object has links, the object will not be deleted.

Let's consider the following example: in the user mode of 1C 8.3, put a checkmark to delete objects:

• In the directory Contractors:

• In the directory Nomenclature:

For direct removal objects marked for deletion in 1C 8.3, you need to start processing . This processing you can run:

• Main menu – All functions – Processing – Deleting marked objects:

• Main menu – All functions – Standard – Deleting marked objects:

• Section Administration – Service – Deleting marked objects:

• Section Administration – Program settings – Support and maintenance – Deleting marked objects:

• Section Operations – Service – Deleting marked objects:

Processing “Deleting marked objects”

Processing “Deleting marked objects” allows you to delete in the 1C program without the need for exclusive mode, that is, you can delete objects when users are in information base 1C 8.3:

Also in 1C 8.3 on the form it is possible to set a checkbox “Block all work in the 1C program and speed up deletion”. In this case, exclusive mode will be required for the duration of deletion.

To see users who are in this moment work in the information base, and you can ask to exit the program while the deletion is running:

• By clicking on the hyperlink "users(n)" on the form "Deleting marked objects", where n is the number of active users;
• Section Administration – Program Settings – Support and Maintenance – Active Users;
• Section Administration – Service – Active users:

Processing allows you to choose one of two deletion modes: automatic or selective deletion of objects in 1C 8.3.

As a result, objects that have no references are automatically deleted:

Here we can indicate which objects we want to delete, leaving the checkboxes enabled. Click on the button Delete. Objects in 1C that do not have links to other objects will be deleted:

Upon completion of the deletion operation, the 1C 8.3 system will show the objects that could not be deleted and their links - in which objects these elements are used:

Here you need to look:

• Either we mistakenly marked these objects for deletion and we need to uncheck this mark:

• Either this is a duplicate, then you need to use processing "Search and remove duplicates". This topic is discussed in detail in the article:

After completing this operation in 1C 8.3, our item marked for deletion will no longer have a link to the document Implementation (act, invoice):

• Or remove references to this object. That is, on the right side of the form “Places of use of the object...” mark the deletion of this object (if it is not needed and was entered incorrectly), or you need to go into these objects and redefine the link:

After completing our manipulations, click on the button To the begining:

Let's go back to the window:

Leave all the checkboxes enabled and click on the button Delete:

Since objects marked for deletion no longer have links, they will be deleted in 1C 8.3.

Attention! Before deleting objects marked for deletion – .

If there was duplication of an employee’s personal data in 1C 8.3 ZUP (several individuals for one person), then it is possible to combine duplicate cards with the help of a special assistant. How to do this, watch the following video:

Automatic deletion in 1C 8.3 through routine operations

In the 1C program it is possible to use regulatory task perform automatic deletion by setting a schedule.

This function can be configured in the section Administration – Program settings – Support and maintenance – Routine operations, where we check the box “Automatically delete marked objects on a schedule”:

It is advisable to set the schedule for the time when the system is least loaded and no one is working in the 1C 8.3 information base.

Using the example, we will set up a schedule from 05/03/2016, daily from 02:00 a.m. Follow the hyperlink Set up a schedule. Schedule settings – tab Are common:

The 1C 8.3 program does not allow you to delete directories and documents in the database immediately, without additional checks. This is done in order to avoid possible errors. For example, if you want to delete an item that is included in a document, you cannot do this.

Let's look at how to delete documents and directories marked for deletion in 1C 8.3. Removal in 1C 8.2 is slightly different, but has a similar algorithm.

Deleting objects in 1C occurs in two stages:

1. Mark for deletion— setting a sign that a document or directory is planned to be deleted. This element is no different from others; it can also be selected in other objects.
2. Direct removal— a special procedure during which the system controls whether there are links to a given object in the database. After reference control, 1C makes a decision: whether the object marked for deletion can be deleted or not.

Let's look at these two steps. The instructions are absolutely universal and are suitable for all configurations on 1C 8.3 - Accounting, ZUP, Trade Management, ERP, Small Firm Management and so on.

Setting a mark for deletion in 1C is very simple. Simply select the document or reference book you are interested in from the list and press the “delete” button:

After which you need to confirm your intention. You can now see a special note in the log:

This means that the next time you delete objects through special processing, the system will offer to delete this item of the nomenclature.

How to delete objects marked for deletion in 1C 8.3

The second stage is directly deleting what is already marked in the 1C database. This is done using a special service processing “Deleting marked objects”. It is located on the “Administration” tab:

Get 267 video lessons on 1C for free:

When opening, 1C will give us two options to choose from - automatic deletion of all objects and selective deletion:

Selective can be useful to remove a specific object. For example, select “Automatic mode” and click “Delete”. The deletion of all objects marked for deletion in the system will begin. At the end of the work, the system will display conflict situations—objects that are marked for deletion but are included in accounting:

Here you need to make a choice. For example, we marked “Board 4000x200x20” for deletion, but it is included in the “Operation” and ““ documents. If we don’t need these documents either, we simply mark them for deletion and click on the “Repeat deletion” button. If documents are needed, it is worth thinking about whether this item should not be marked for deletion.

In our example, I decided that I didn’t need these documents in the database either, so I checked them. As a result, the system deleted both the interfering item and the unnecessary document:

That's all, now you know how to delete documents and directories from 1C 8.3.

Automatic deletion of directories and documents

The software product “1C 8.3” does not allow documents and reference books in the database to be deleted immediately, without checks. This, of course, is done in order to avoid possible errors. For example, if you want to delete an item that is included in a document, then this is not allowed.

IN this material We will look at how to delete directories and documents marked for deletion in the above-mentioned software product.

In the 1C program, object deletion is carried out in 2 stages. The first of them is a mark for deletion. This is an indication that a directory or document is planned to be deleted. Such an element is no different from others; it can be corrected in other objects. The second stage will be the actual removal. This is a special procedure during which the system checks whether there are links to the selected object in the information database.

Now let's look at these two stages in more detail. It is important to say that the proposed instructions are absolutely universal and are suitable for all configurations on “1C 8.3”: “Trade Management”, “”, “Accounting”, “”, “Small Firm Management”, etc.

First stage - mark for deletion

In “1C” it ​​is very easy to set a mark for deletion. To do this, you just need to select the directory or document that interests us and press the “delete” key:

Once done, you must confirm the desired operation. A special note will appear in the journal:

This means that when deleting objects using special processing, the system will prompt you to delete this item of the nomenclature.

How to delete designated objects in 1C 8.3?

The next, second stage is directly deleting objects marked in the database. This is done with the participation of a special service processing called “Deleting marked objects.” It is located on the tab called “Administration”:

During opening, “1C” will give you a choice of 2 options - selective deletion of all objects and automatic:

Selective can be useful for deleting specific objects. For example, you can select “Automatic mode” and press the “Delete” button. All objects detected in the system will be deleted. At the end of the work, the system will display conflict situations: objects that participate in accounting, but are still marked for deletion:

Here you need to choose. For example, the item “Board 4000x200x20” in this case is designated for deletion, but it is included in the documents called “Production report for the shift” and “Operation”. If these documents are not needed, then you just need to mark them for deletion and press the button called “Repeat deletion”. If documents are needed for work, then you need to think about whether this item really needs to be deleted. In our example, we decided that we do not need these documents.

Now it’s clear how you can delete directories and documents from 1C 8.3.

Deleting documents and directories in automatic mode

In the 1C 8.3 platform it is now possible to delete detected objects automatically. This possibility became a reality with the participation of the so-called regulatory task. The system performs this procedure according to a schedule. It will only take 3 minutes of your time.

To configure, you first need to go to the tab called “Administration”, then - “Support and Maintenance”, where there is a checkbox “Automatically delete detected objects on a schedule”:

When you click on it, the system will offer the required option:

We recommend that you leave the default settings and simply click on the “OK” button. In this case, deletion of marked objects will be carried out at night, because at this time, as a rule, no one is working in the program.

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.

For complete removal object from the 1C database, you need to start processing Deleting marked objects. 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 given 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.

For automatic execution procedure using a routine task, you need to set the Automatically delete marked objects on schedule flag in processing and configure the schedule.