Search and remove duplicates of subconto 3.0 types. Search and remove duplicate elements. Implementation of search and removal of duplicate elements

Very often, due to the fault of users, the program introduces duplicate elements. Most often, such cases occur when creating partners and nomenclature. The user may incorrectly search for existing items in the database and end up creating a new item.

As a result, we will receive two separate elements for which records are kept in the program. In such cases, you have to come up with various methods to eliminate these elements.

For example, in the case of duplicate items, combine duplicate item items into a separate group, edit documents, write off and capitalize goods, etc. In general, the “picture” is sad.

In the release of UT 11.1.6 a wonderful ability to search for and delete duplicate elements(directories, etc.), replacing duplicate elements with the selected ones in all places of use.

Applicability

The article was written for the editors of UT 11.1 . If you use this edition, great - read the article and implement the functionality discussed.

If you are working with older versions of UT 11, then this functionality is current. The most noticeable difference between UT 11.3/11.4 and 11.1 edition is the Taxi interface. Therefore, in order to master the material in the article, reproduce the presented example on your UT 11 base. Thus, you will consolidate the material with practice :)

Implementation of search and removal of duplicate elements

Let’s imagine a situation that in our database there are two partners “Ivanov LLC” and “Ivanovich LLC”. Documents for the sale of goods were issued to both partners and cash receipts were issued.

After some time it turned out that this was the same partner. One manager recorded the partner in the database as “Ivanov LLC,” and the other (when writing out a new implementation) misheard the name of the client and created “Ivanovich LLC” in the partner database.

As a result, the database contains 2 sales for the partner “Ivanov LLC” and 2 sales for the partner “Ivanovich LLC”:

And also 2 cash receipt documents for the partner “Ivanov LLC” and 2 cash receipt documents for the partner “Ivanovich LLC”:

To enlarge, click on the image.

To correct this situation, we use the new UT11 mechanism called “Search and remove duplicates.”
Let's go to the "Administration" - "Support and Maintenance" section of the program and follow the hyperlink "Search and delete duplicates."

To enlarge, click on the image.

A processing window will open in front of us:

To enlarge, click on the image.

In the “Search in” field, indicate the “Partners” directory.

In the “Select” field we will indicate the selection according to the necessary partners (“Ivanov LLC” and “Ivanovich LLC”), since we already know which partners we need to unite. The hyperlink will take on the selection condition value.

To enlarge, click on the image.

You must choose one of the rules. In our case, check the box next to the “Client” rule (since this box is checked in the cards of both partners) and click the “Select” button. Once selected, the hyperlink will change meaning.

To enlarge, click on the image.

After specifying the necessary selections and comparison rules, click the “Find duplicates” button.

As a result, we get the following sample:

To enlarge, click on the image.

The list of found duplicates consists of two parts.

On the left side are the found elements. Shown in the list as a tree. Grouped by name.
The right side displays information on the selected elements:

by group of elements (i.e. for each name) – a report on the number of duplicates found for the selected element.

To enlarge, click on the image.

by elements – report on use in the program. The phrase “Not used” or a list of program documents (places) in which this element is used will be displayed here.

To enlarge, click on the image.

One of the elements used in the program is automatically selected as the original. In our case, this is the partner “Ivanov LLC”. In processing it is marked with a blue arrow.

In order to change an element that needs to be left in the program, select it and click the “Mark as original” button.

Duplicates in the list are marked with flags. In our case, the partner is Ivanovich LLC.

To view the selected element, you need to click the “Open” button or double-click on the element.

We will leave the partner “Ivanov LLC” as the main original partner.

After that, click the button in the “Delete duplicates” processing.

After carrying out all the necessary operations, the program will display a message about merging the specified duplicates into one element.

To enlarge, click on the image.

Let's check if the program executed everything correctly.

Let's go to the “Partners” directory:

To enlarge, click on the image.

As you can see, the duplicate partner “Ivanovich LLC” is marked for deletion. That's right.

Let's go to the list of sales documents. Two sales have been corrected to the partner “Ivanov LLC” (column “Partner”). But the counterparty in the documents has not been corrected (column “Counterparty”).

To enlarge, click on the image.

Let's go to the list of cash receipt documents. Here we see that there are no changes.

To enlarge, click on the image.

What is the reason?

Let's open one of the cash receipt documents posted to Ivanovich LLC.

To enlarge, click on the image.

In the document we will see that in the tabular part in the “Partner” field, the “Search and remove duplicates” processing replaced the partner “Ivanovich LLC” with the partner “Ivanov LLC”. In the “Counterparty” field, the element “Ivanovich LLC” is selected.

Let’s open the card of the counterparty “Ivanovich LLC”.

To enlarge, click on the image.

As you can see, the counterparty “Ivanovich LLC” is tied to the partner “Ivanov LLC”. Those. Processing for removing duplicates linked the counterparty “Ivanovich LLC” to the partner “Ivanov LLC”.

Let’s open the “Ivanov LLC” partner card and go to the “Counterparties” navigation panel item. The list will display two counterparties:

To enlarge, click on the image.

It turns out that we have united partners, but there are still counterparties who also need to be united into one.

Let’s use the “Search and remove duplicates” processing again. In the “Search in” field we will indicate the directory “Counterparties”, in the “Select” field we will indicate the selection by partner “Ivanov LLC” and in the “Compare” field we will select the “Partner” rule.

To enlarge, click on the image.

Click the “Find duplicates” button.

To enlarge, click on the image.

We won’t change anything, click the “Delete duplicates” button.

After carrying out all the necessary operations, the program will display a message about merging the “Counterparties” into one element.

To enlarge, click on the image.

Let’s open the partner card of “Ivanov LLC”. We will see that the counterparty “Ivanovich LLC” is marked for deletion.

To enlarge, click on the image.

The lists of sales documents and cash receipt orders now display correct information. Those. In all documents, the partner “Ivanovich LLC” and the counterparty “Ivanovich LLC” were replaced by “Ivanov LLC”.

To enlarge, click on the image.

Well, dear readers, in this article we looked at the new processing “Search and remove duplicates”. We looked at its basic settings and principles of use. We see that the settings are not complicated, and the functionality is useful.

If there is not a lot of information in the database, then yes, documents and reference books can be replaced manually. But if there are hundreds of documents, then searching and manually correcting them will take a lot of time.

With the “Search and remove duplicates” processing, you are not afraid of any duplicates. So, go ahead and check if there are any duplicates in your information database.

In this article we will look at the possibility of searching and deleting duplicates in “1C:Enterprise 8.3” and “1C:Enterprise 8.2”. We will illustrate how to work with the standard “Search and remove duplicates” processing in the 1C system in the form of step-by-step instructions. We will also consider in detail how to search for repetitions in 1C 8.3 and how to correctly remove duplicates.

If you do not monitor the data in the 1C program, then duplication of information is inevitable. Most often this happens in the directories “Nomenclature” and “Counterparties”.

Finding and deleting duplicates in 1C:Enterprise 8.2

In 1C 8.2, searching and deleting duplicates can be done using processing from the ITS disk: “Search and replace data” (8.2). This is a universal processing that allows us to change one value to another, after which objects without links were marked for deletion and deleted using the “Deleting marked objects” processing.

The process of searching and deleting duplicates in 1C 8.2 can be carried out in separate operations:

By recording the presence of a double in the program.
Determining the largest number of links to the found pair.
Processing “Search and replace data” (an object with a smaller number of links is usually replaced by a found duplicate with a large number of links).
The object, the links to which were replaced, was marked for deletion and physically deleted from the 1C 8.2 database using the “Deleting marked objects” processing.

Finding and deleting duplicates in 1C:Enterprise 8.3

The software product “1C: Accounting 8. Edition 3.0” already has a built-in unique mechanism for searching and eliminating duplicates. This is a standard “Search and remove duplicates” processing, which is suitable for searching not only in items and contractors, but also in other directories and documents.

Typical processing in 1C 8.3 “Search and remove duplicates” simplifies the work of removing unnecessary information from the database as much as possible. Moreover, for proper deletion - without violations of records in the database!

Where is the “Search and remove duplicates” processing located?

Processing can be called:

Main menu/All functions/Processing/Search and delete duplicates.
Administration/Support and Maintenance section.
Having configured the Navigation Panel of the Administration section: setting up the Navigation Panel - selecting the “Search and removal of duplicates” command from the available commands.

Processing capabilities “Search and remove duplicates”

What do we need to know about this processing?

Processing is intended to search and eliminate duplicates in all lists of the 1C program (for 1C program administrators - there must be Full rights).
Processing allows you to find occurrences of all duplicated elements in the 1C database and replaces duplicates with links to the selected “correct” element.

We will look at how to work with this processing step by step in this article.

Step 1. Running a search for duplicate elements

Call the “Search and remove duplicates” processing form.

Set the conditions for selecting search elements:

1. Selecting directories or documents in which processing will search for duplicates.

2. Imposing conditions for selecting a choice, for example, a filled-in TIN detail that is not marked for deletion.

3. Rules for searching for duplicates: the default is to match the names, but you can set others. For example, a match of TIN or codes (in the first case in 1C 8.3) will result in a warning about the presence of the entered TIN in the database, but a match of codes due to the inherent uniqueness of numbers in 1C is mostly impossible.

By clicking the “Search for duplicates” button, data is selected and compared according to the specified conditions. If no duplicates are found, the corresponding message is displayed: “No duplicates were found for the specified parameters.”

When duplicates are detected, a list of duplicates is displayed. The list consists of 2 parts: on the left are the found elements. On the right is information on the selected elements: the number of duplicates found and the list of documents in which they were used.

Step 2: Select original

One of the elements on the left side is automatically selected by the 1C program as the original.

However, you can select a different item by highlighting it and clicking the Mark as Original button. Duplicates in the list are marked with flags.

Step 3. Directly deleting duplicates in “1C:Enterprise 8.3”

Removing duplicates occurs by clicking the “Delete duplicates” button. Duplicates will be marked for deletion, and all their attachments in documents will be replaced with the selected Original. You can permanently delete duplicates by processing “Deleting marked objects” (section Administration/Support and Maintenance).

An example of deleting duplicates in the “Bank Accounts” directory

Fill out the form “Search and remove duplicates”:

1. Directory of bank accounts.

2. Not marked for deletion.

3. Compare by name.

For example, in the 1C 8.3 database there are 3 duplicate bank accounts, let’s see how processing will remove unnecessary links:

Click on the “Find duplicates” button. The 1C 8.3 program found all three duplicates and suggests leaving the object with more links. This is reasonable, so we do it;

Click the “Delete duplicates” button. After completing all the steps, the 1C program will display a message indicating successful completion: All found duplicates (3) have been successfully combined.

Let's look at the "Bank Accounts" directory:

two bank accounts are marked for deletion. Now we remove them after processing "Deleting marked objects".

Be careful! Be sure to do it backup copy before deleting duplicates, since the procedure is irreversible. Upon completion of removing duplicates, generate basic reports, perform an express check of accounting, testing and correction of the database.

Based on materials from Profbukh8.ru

In the latest editions of the configuration based on 1C 8.3, an excellent opportunity has appeared to automate the search and replacement of duplicate directories. This is done using special processing 1C - Search and replacement of duplicates. It is built into such application solutions on managed forms as: , .

Let's look at a short instruction: how to find processing in the interface, how to use it to collapse duplicate items of items, contractors and other directories.

Attention! Before working with processing, be sure to make a backup copy of the database.

Processing to find duplicates

Processing Search and removal of duplicates is located on the “Administration” tab, in the “Support and Maintenance” section:

At the bottom:

Get 267 video lessons on 1C for free:

During processing, it is necessary to indicate which directory we want to “scan” (in our case, nomenclature), according to which selection (those not marked for deletion) and what will be a fact of a duplicate for us (let’s take a name match for similar words). After setting, click “Find duplicates”.

1C will offer options for duplicates:

Using the example of the STINOL refrigerator: the system marked the element with the ending “101” as the original, and the element “103” as a duplicate. In the window on the right we see in which documents this item of nomenclature is involved.

You can repurpose the "original" using the "Mark as original" button based on your own beliefs. I recommend choosing as a standard the object that has more “use points” in order to speed up the process of gluing together takes:

Removing duplicates in 1C directories

Quite often situations arise when duplicates arise in directories, for example, items or contractors. In this case, the program perceives each such item as a separate product or client. To solve this problem, it is necessary to combine these identical positions into one, that is, remove all duplicate elements, leaving only the correct ones.

For these purposes, standard processing “Search and replace duplicate directory elements” is provided. It can be found in the menu item Service – Universal processing – Search and replacement of duplicate directory elements (Trade Management 10).

IMPORTANT! This processing is suitable for both 1C Enterprise: Trade Management 10 and 1C Enterprise: Accounting 2.0. In 1C Enterprise: Accounting 3.0 this processing is built in by default in Processing – Search and removal of duplicates.

Description of processing work

IMPORTANT! First of all, make an archive copy of the database. Next, you need to go to the 1C database in the “1C:Enterprise” user mode and run the “Search and replace duplicate directory elements” processing using the menu item Tools – Universal processing – Search and replace duplicate directory elements, or in the File menu item click the Open button:

The following should appear on the screen:

Select a directory that contains duplicate elements in the “Directory” field

In the “Search details” field we indicate the details for searching for duplicates:

If necessary, set the search selection. To do this, add a new line in the “Additional selection for search” tabular section and select the attribute in the “Field” column.

Click on the “Find duplicates” button:

Next, we need to define the “Correct elements”, that is, those elements that will remain, and their duplicates will be deleted; in all documents, instead of duplicates, “Correct elements” will be added. Identification of elements and removal of duplicates can be manual or automatic.

If one of the elements in a group is highlighted in bold, then the “Correct Element” is defined in this group.

After determining the “Correct elements”, you must click the “Replace in all groups” button.

Attention! This operation is irreversible! After its launch, the system will go through each group and replace and remove duplicate elements in it.

How to remove duplicates in the 1C 8.3 Accounting directory?

Let's look at a short instruction: how to find processing in the interface, how to use it to collapse duplicate items of items, contractors and other directories.

Attention! Before working with processing, be sure to make a backup copy of the database.

Processing to find duplicates

Processing Search and removal of duplicates is located on the “Administration” tab, in the “Support and Maintenance” section:

At the bottom:

During processing, it is necessary to indicate which directory we want to “scan” (in our case, nomenclature), according to which selection (those not marked for deletion) and what will be a fact of a duplicate for us (let’s take a name match based on similar words). After setting, click “Find duplicates”.

1C will offer options for duplicates:

You can repurpose the "original" using the "Mark as original" button based on your own beliefs. We recommend choosing as a standard the object that has more “places of use” in order to speed up the process of gluing takes:

If we think that this group of elements is not duplicates, simply uncheck the parent element:

Searching for duplicates 1C 8.3 will highlight these objects in gray, which means that they will not participate in the gluing procedure.

After all the settings, you need to click on the “Delete duplicates” button. Be careful, the procedure is not reversible, do not forget to make a backup copy!

At the end of the procedure, be sure to check the database for errors: build basic reports, check the closing date of periods, etc.

Based on materials from: programmist1s.ru