Search for duplicate elements 1c 8.3. Accounting info. Removing duplicate counterparties

Removing duplicates in 1C directories

Quite often, situations arise when duplicates appear in directories, for example, items or counterparties. In this case, the program perceives each such position as a separate product or customer. 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, the standard processing "Search and replacement of duplicate elements of directories" is provided. It can be found in the menu item Service - Universal processing - Search and replacement of duplicate elements of directories (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 delete duplicates.

Description of processing work

IMPORTANT! First of all, make an archive copy of the database... Next, you need to enter the 1C database in the 1C: Enterprise user mode and start the Search and Replace Duplicate Directory Items processing using the Tools - Universal Processing - Search and Replace Duplicate Directory Items menu item, or click the Open button in the File menu item:

The following should appear on the screen:

We select the directory in which there are duplicate elements, in the "Directory" field

In the "Search requisite" field, specify the requisite for the search for duplicates:

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

Click on the button "Find duplicates":

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, the "Correct elements" will be tightened. The definition of elements and removal of duplicates can be manual or automatic.

If one of the elements in the 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 will replace and remove duplicated elements in it.

If the program already has a counterparty with such details, it informs about it. PDF

The search is performed only if INN and Checkpoint entered correctly.

Conditions for performing an automatic check

There should be no problems if:

• you have a typical, not modified configuration;
• you immediately enter data on INN and Checkpoint to the counterparty card;
• data on INN and Checkpoint entered correctly.

Most likely, you do not immediately fill out the information on INN and Checkpoint... Or you have a modified configuration, and then its analysis by a programmer is already required.

Now you need to remove all duplicates from the directory Contractors ... This can be done by special treatment. Finding and removing duplicates .

Finding and removing duplicates

Open processing Finding and removing duplicates you can from the section.

The processing can be operated by a user with Full rights... Processing is intended for finding and removing duplicates in directories and documents. It allows you to find links to all duplicated elements and replaces them with the selected "correct" element.

Step-by-step instructions for finding and removing duplicates

Open processing Finding and removing duplicates : chapter Administration - Program settings - Maintenance - Data correction - Search and delete duplicates.

Step 1. Setting up the duplicate search header

Specify in the search header:

• Search in - Contractors;
• Take away - All elements;
• Compare - TIN matches AND KPP matches.

Step 2. Find duplicates

Click on the button Find Duplicates... The program will automatically compare all counterparties in the database and select with the same INN and Checkpoint .

Step 3. Selecting the original

If duplicates are found, then to the right of the counterparties, information is displayed showing the number of links available in the database for each counterparty.

The left-side item with the most links is automatically marked as Original("Blue" arrow). The duplicate counterparty is marked with a check mark.

Step 4. Merging takes

Deleting duplicates is done by pressing the button Remove duplicates , wherein:

• duplicates will be marked for deletion;
• all occurrences of duplicates in documents are replaced with the selected one Original .

Step 5. Removing duplicates

Processing has successfully merged the take data into the selected original, but the take itself is not deleted. It remained marked for deletion in the directory Contractors .

You can finally remove the duplicate counterparty by processing Deleting marked objects : chapter Operations - Service - Deleting Marked Objects.

Processing will remove LLC "Camellia" from the directory Contractors .

Very often, through the fault of users, the program introduces duplicate elements... Most often, such cases occur when creating partners and items. The user may incorrectly search for existing elements in the database and, as a result, create a new element.

As a result, we get two separate elements for which the program records. In such cases, you have to come up with various methods how to eliminate these elements.

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

The release UT 11.1.6 has a wonderful the ability to search and delete duplicate elements(reference books, etc.), replacing duplicate elements with the selected one in all places of use.

Applicability

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

If you work with older versions of UT 11, then this functionality is relevant... The most noticeable difference between UT 11.3 / 11.4 and 11.1 revision is the Taxi interface. Therefore, in order to master the material of the article, reproduce the presented example on your base of UT 11. 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". Sales documents were issued to both partners and cash receipts were posted.

After a while, it turned out that they were the same partner. One manager recorded the partner in the database as "Ivanov LLC", and the other (when subscribing a new implementation) misheard the name of the client and created "Ivanovich LLC" in the partner's database.

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

As well as 2 cash receipts for the partner "Ivanovich LLC" and 2 cash receipts for the partner "Ivanovich LLC":

Click on the image to enlarge.

To correct this situation, we are using a new UT11 mechanism called "Find and remove duplicates".
Let's go to the section of the program "Administration" - "Support and maintenance" and follow the hyperlink "Find and remove duplicates".

Click on the image to enlarge.

A processing window will open in front of us:

Click on the image to enlarge.

In the field “Search in” we will indicate the reference book “Partners”.

In the "Select" field, we will indicate the selection for the necessary partners ("Ivanov LLC" and "Ivanovich LLC"), since we already know which partners we need to combine. The hyperlink will take on the value of a selection condition.

Click on the image to enlarge.

Be sure to 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 press the “Select” button. After selection, the hyperlink will change its value.

Click on the image to enlarge.

After specifying the necessary selections and comparison rules, press the button "Find duplicates".

As a result, we get the following sample:

Click on the image to enlarge.

The list of found duplicates consists of two parts.

On the left - found items. Shown in the list as a tree. Grouped by name.
In the right part, information on the selected elements is displayed:

• by a group of elements (i.e., by each item) - a report on the number of duplicates found for the selected element.

Click on the image to enlarge.

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

Click on the image to enlarge.

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

In order to change an element that must 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 - a partner of "Ivanovich LLC".

To view the selected item, you need to click the "Open" button or use a double click on the item.

Let's leave the partner "Ivanov LLC" as the main partner-original.

After that, press the button in the "Delete duplicates" processing.

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

Click on the image to enlarge.

Let's check if the program has completed everything correctly.

Let's go to the "Partners" directory:

Click on the image to enlarge.

As you can see, the duplicate partner "Ivanovich LLC" is marked for deletion. Everything is correct.

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

Click on the image to enlarge.

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

Click on the image to enlarge.

What is the reason?

Let's open one of the incoming cash documents made at "Ivanovich LLC".

Click on the image to enlarge.

In the document, we will see that in the tabular section in the "Partner" field, the "Search and delete duplicates" processing has replaced the "Ivanovich LLC" partner with the "Ivanov LLC" partner. In the field "Counterparty" the element "Ivanovich LLC" is selected.

Let's open the card of the counterparty "Ivanovich LLC".

Click on the image to enlarge.

As you can see, the counterparty "Ivanovich LLC" is tied to the partner "Ivanov LLC". Those. duplicate deletion processing tied the counterparty "Ivanovich LLC" to the partner "Ivanov LLC".

Let's open the partner card "Ivanov LLC" and go to the "Contractors" navigation panel item. The list will display two contractors:

Click on the image to enlarge.

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

Let's use the processing "Find and remove duplicates" again. In the field “Search in” we will indicate the reference book “Contractors”, in the field “Select” we will indicate the selection by partner “Ivanov LLC” and in the field “Compare” we will select the rule “Partner”.

Click on the image to enlarge.

Press the button "Find duplicates".

Click on the image to enlarge.

We will not change anything, press the "Delete duplicates" button.

After carrying out all the necessary operations, the program will display a message about the merger of "Contractors" into one element.

Click on the image to enlarge.

Let's open the partner card "Ivanov LLC". We will see that the counterparty "Ivanovich LLC" is marked for deletion.

Click on the image to enlarge.

Correct information is now displayed in the lists of sales documents and cash receipts. Those. in all documents the partner “Ivanovich LLC” and the counterparty “Ivanovich LLC” were replaced by “Ivanov LLC”.

Click on the image to enlarge.

Well, dear ones read, in this article we examined the new processing "Find and remove duplicates". We reviewed its basic settings and principles of use. We see that the settings are not complicated, but 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 their search and manual correction will take a very long time.

With the processing "Find and delete duplicates" no duplicates are afraid of you. So, go ahead and check if there are any duplicates in your database by accident.

In 1C 8.2, the search and removal of duplicate elements was carried out using universal processing from the ITS disk: Search and replacement of data (8.2), which allowed replacing values. Further, objects without references were marked for deletion and removed by processing the Deletion of marked objects.

The process of finding and removing duplicates in 1C 8.2 was carried out in separate operations:

• The presence of a double in the database was recorded;
• The largest number of links to the found pair was determined;
• Processing Finding and Replacing Data an object with fewer links was replaced by a duplicate found with a large number of links;
• The object to which the links were replaced was marked for deletion. Further, after processing, it was eliminated from the 1C 8.2 database.

Search and delete duplicates in 1C 8.3

In the 1C 8.3 database, a unique mechanism for finding and deleting duplicates is implemented in the form of a typical processing of the same name. It searches for duplicate items both in business partners and nomenclature, and in other documents and reference books.

Typical processing in 1C 8.3 Finding and removing duplicates facilitates the process of removing unnecessary information from 1C 8.3. Moreover, to delete without errors, that is, without violations of accounting in the database! How to apply step-by-step processing will be discussed further.

Step 1. Where is the processing Finding and removing duplicates

Processing in 1C 8.3 can be easily called:

• Ch. menu - All functions - Processing - Search and delete duplicates:

• Section Administration - Support and Service:

• Configuring the navigation panel of the Administration section - selecting the Find and remove duplicates command:

Step 2. Possibilities of processing "Find and remove duplicates"

What do you need to know and what is this treatment for?

• Processing searches for and eliminates duplicate elements in all lists of the 1C 8.3 base. At the same time, for administrators 1C 8.3 must be installed full rights;
• Processing helps to find occurrences of all duplicated elements in the 1C 8.3 database and replaces duplicates with links to the selected “correct” element.

Step 3. Finding Duplicate Items

Calling the processing form Finding and removing duplicates... The sequence of actions is indicated by numbers in circles:

We define the conditions for selecting search elements:

1. Selection of documents or directories in which the processing will search for duplicates;
2. The imposition of selection conditions for the selection of elements. For example, an unmarked, filled in INN requisite for deletion:

1. As a rule, in 1C 8.3, the name coincidence is set by default, but it is possible to set others. For example, if the TIN matches in 1C 8.3, there will be a warning about the presence of an existing TIN in the database. The coincidence of codes due to the built-in uniqueness of numbers in 1C is almost impossible. Therefore, the default option is the most popular:

By pressing the book. Search for duplicates selection and comparison of data are made according to the established conditions. If no duplicate elements are found, then a message appears:

When duplicates are found, a list of takes appears. The list includes:

• Left - found items;
• On the right - data on the elements: the number of duplicates found and the list of documents in which they are used.

Step 4. Selecting the original

One of the items on the left is automatically set as the original. In this case, you can specify another element by selecting it and clicking Mark as original... In the list, duplicates are marked with flags.

Step 5. Removing duplicates in 1C 8.3

Produced according to the book. Remove duplicates... Duplicates are marked for deletion, all their attachments in documents are replaced with the selected original. You can finally remove duplicate elements by processing Deleting marked objects... Section Administration - Support and Service.

So, all the information on processing has been received, let's move on to practice.

Step 6. An example of deleting duplicates in the Bank accounts directory

Let's form the Search and delete duplicates form:

1. Directory of bank accounts;
2. Not marked for deletion;
3. Compare by name.

For example, the 1C 8.3 database contains duplicate bank accounts. Let's see how processing will remove duplicate links:

Click Find takes... As a result, 1C 8.3 identified all three duplicate elements and makes it possible to leave the object with more links. This is reasonable, which is why we do this:

Push the button Remove duplicates... After completing all the necessary actions in 1C 8.3, a corresponding message appears:

Let's check the directory Bank accounts. As a result, two accounts are marked for deletion:

Everything went well. We have an order in the 1C 8.3 database!

Be careful! Need to do reserclearly topiyu before deleting duplicates, as the procedure is not reversible! When you are finished removing duplicate items, run Testing and fixing the database, check the main reports, etc.

How to combine duplicated individuals in the 1C ZUP 8.3 program with the help of a special assistant, see our video.