How to remove subordinate documents in 1C 7.7. How to quickly clear the database from documents

Along with the input mode "based"In the 1C system: the company exists the possibility of creating subordinate documents that allows you to organize the chains of interrelated documents.

Consider a typical example of the implementation of such an opportunity.

The client was issued an account for the payment of goods. Upon receipt of money, information about the payment order was introduced into the system with reference to the previously written account. Later, when the invoice is discharged on the vacation of goods according to a paid account, a link to the invoice was also introduced. In this case, between the score and documents that "followed" At the expense, the subordination relationship is established. When working with such an account, you can call the list of all subordinate documents to it to view and edit these documents.

The ability to install between submission relations documents is set at the configuration stage. You can find out if any of the documents be subordinate to another document, it is possible according to the following formal attribute: in the document structure (in the header or tabular part) there must be a details of the type "document". However, it should be borne in mind that the type props "document"present in the structure of the document may be absent in the dialog for entering the document. In this case, to determine whether the document can be subordinated to any document, you should refer to the configuration description (items "Description", "General description" menu "Help" Main menu program, book "Configuration Description").

Often input mode "based" And the ability to create subordinate documents is used together. In the above example, filling overlines for the release of goods are conveniently organized using the input "based on", then the invoices can be filled by transferring information from the previously written invoice.

To view the subordinate documents, you must open a document for editing and select item. "Subordinate documents" on the menu "Actions" The main menu of the program.

The screen will be issued a log in which all documents subordinate to the current document will be contained.

If the current document does not have subordinates, the magazine will be empty.

In the general case, the form of the log of subordinate documents may be the same as the full magazine. However, B. Configurator can be created special Journal To work with subordinate documents.

/
Administer 1C: Enterprise 7.7

An erroneously document or record a reference book that is no longer needed, you can delete. Deleting records in the program 1C occurs in two stages:

First stage :

Marking objects to delete that you want to delete.

Manipulation with a marking object in the window Removing marked objects It does not affect the mark on the removal in magazines and reference books.

Wiring Operationsmarked for removal turn off, wiring document - remove. When removing the mark on the removal of wiring is not automatically restored.

Recovery wiring operation Select a command menu-\u003e Actions-\u003e Enable wiring, for postings of the document You must open the document and re-conducted.

Removing marked objects without a monopoly mode.

If 1C is not running in monopoly mode, it will not be possible to use regular removal tools - 1C will be issued an error ""

How to remove marked objects without a monopoly mode?

In a situation where there is no possibility to start 1C in monopoly mode, but you need to delete the marked objects, will help the "Delete" processing, which can be downloaded: Removal without monopolous access ( author Alexander Shatsky, refined by me: the speed of work is significantly increased).

You can run the processing in the "Enterprise" mode, the File menu command - Open.

The interface is similar to standard processing. If you do not want to receive an error "Object not found" Instead of the completed props - delete only with link control, without using the "Delete All" / Delete Links.

Why could not delete some objects?

Such objects are displayed in the column "Unable to delete". When checking (control), the message "*** from *** selected objects cannot be deleted is displayed."

Now why some objects can not be removed from the 1C base? Just in the 1C database there are links to these objects. Somewhere in reference books, documents, motions this object is specified and therefore the system cannot delete it. Such situations corrected manually And here you need a good knowledge of configuration 1c.

All items where the object deleted is used is displayed in the "Remove Links" list. If it is possible to delete all references to a remote object - it will be possible to delete the object itself. If it is forced to delete an object, a system string will appear on the site of links to it "<

Sometimes you need to remove from the base all documents for all periods and leave only directories.

It is necessary if it is necessary if there is a need to create a clean database and not to drive into it already formed directories, such as counterparties and the nomenclature.

In 1c, the company has special treatments that make the same type of operations with documents and reference books, however, such treatments work very long, because, in our case, to delete documents in a few days it is necessary all documents are made unnewned, mark on deletion, and then only remove. It can take a lot of time.

There is a way to quickly, almost instant removal of all documents from the 1C database.

Attention! Before deleting documents, be sure to back up the database!

How to quickly delete all documents from 1c enterprise 7.7

I will say right away, we will not delete specific documents via the 1C enterprise interface. Delete will be directly filesin which documents are stored. Therefore, this method only works on the 1C file version of 1C 7.7.

How to determine which files you need to deletehttp: //syt/admin.php? Mod \u003d editnews & activity \u003d editnews & id \u003d 18 liter to clear the database from the documents? To fulfill our goal it is necessary to know a little to know the data structure of the file version 1C 7.7.

References are stored in files named SC * .dbf., Documents in file files DT * .dbf. and DH * .dbf., registers in files Rg * .dbf. and Ra * .dbf.

Which state of the anew or the document in which file is stored you can take a seat opening file 1cv7.dd by any text editor.

So, we need to clear the database of 1C 7.7 from the documents, leaving directories.

To do this, delete:

1. Document files

2. Register files

3. Index files. In any case, it will be necessary to reinperse the database

4. Service files whose destination you are not interested

* .lst.
1soper.dbf.
1sentry.dbf.
1sbkttlc.dbf.
1sbktttl.dbf.
1saccsel.dbf.
1ssbsel.dbf.
1supdts.dbf.
1sdwnlds.dbf.
1SdbSet.dbf.

5. Folders that we do not need

New_stru
Syslog.

To do this, we can delete files into manual, but it is better to write the executable file that will delete all the necessary files for 1 time.

To do this, create a blank file " Delete.cmd."In which DOS teams write:

del syslog.
del * .cdx
del * .lst.
del 1cv7srct.st.
del DT *. *
del DH *. *
del 1SJourn.dbf.
del 1scrdoc.dbf.
del 1SdnLock.dbf.
del 1Sstream.dbf.
del Rg *. *
del Ra *. *
del 1Soper.dbf.
del 1sentry.dbf.
del 1Sbkttlc.dbf.
del 1Sbkttl.dbf.
del 1Saccsel.dbf.
del 1ssbsel.dbf.
del 1Suppdts.dbf.
del 1SDWNLDS.DBF.
del 1SdbSet.dbf.

We are waiting for 1Second. All files are deleted, there are no more documents in our database.

After that, it is desirable to start the database in the configurator mode and paste IB testing and correction.

If you yourself do not want to create a delete file. CMD, you can download the finished file.

Download Delete.cmd.

Watch video How to quickly delete documents from 1C 7.7 database.

In the process of work, almost every accountant, there are situations when, for one reason or another, it is necessary to delete whether the document is needed, or the element of the reference book. In the 1c deletion program, the procedure takes place, similar to the removal of files in the Windows operating system, but with a number of differences. Those. First, the element to be deleted is marked with the corresponding sign, i.e., as if placed in the basket. The physical removal is made after the implementation of some action algorithm. As in 1C to delete the documents marked for deletion.

Full deletion occurs after checking all possible references in the information database. Often the difference in the format of manufactured actions causes confusion and complexity of users of the program. Now we will deal with the question of removing documents in various versions of the 1C program. It is worth noting that this procedure is almost the same in different configurations of the program.

In 1C version 7.7, you need to select a monopoly mode to delete a document when entering 1C mode: Enterprise. Actually, for the mark on removing the monopoly mode is not needed, but it is necessary for the physical removal of marked objects.

After logging in, select the desired entry in the log and click on it the right key, then select "Mark for deletion". After that, the document or the element of the reference book will change the icon on the pictogram with the cross. To the same effect will also be pressed on the dedicated element of the "DEL" key.

After that, the document is considered remote and does not participate in the calculations produced by automatically program. However, it remains in the information base. To complete it, proceed to the processing that removes the marked files. To do this, close all windows in 1C and click the "Operation" main menu item and the "Removal of marked objects" submenu.

Agree with a proposal to continue the operation.

In the window that opens, you will see a list of all documents or elements of reference books to be deleted. In our case, it is only one document.

The top menu buttons control actions above the documents. The button with the icon installed checkboxes will allocate the entire list of documents. The next button with empty cells will clean the selected list. The third button calls the opening of the selected document.

We highlight the documents or elements of the reference book necessary to the physical removal and click the Control button. This button analyzes reference links with a dedicated document. Note that the "Delete" button before control is not available. After the check check, if there is a trouble-free possibility of removing the element, it becomes an inaccessible "Control" button and the "Delete" button is available. To physically delete a document, it is enough to click the "Delete" button and agree with the final warning.

The document is deleted.

However, there are cases when checking reference links is completed by the detection of relationships with a dedicated document of other documents. In this case, until you delete all the detected links to the Document deleted, the complete deletion will not be possible.

****************************************************************

In 1C version 8.2, you need to select a deleted document to delete the document and click the right button to appear the context menu. Next, you need to select the "Install Remove Removal" item and agree with the warning. These actions also occur also by pressing the "DEL" key.

Yes, 1C 8.2 This is not 7.7, even the mark of deletion on the document is affixed suspiciously long.

We agree with the warning of the duration of the operation.

In the window that opens, we see a list marked to remove the database elements. Assigning control buttons is similar to those discussed in the 1C version 7.7 section. Available Document Allocation, List Cancel Selection and Opening Selected Document.

Select the desired element or group of elements and click the "Control" button to check the links. After checking, it turned out that there is a link to the document deleted by us. Expendable invoice in the document Tax invoice. Delete a link to the expenditure overlay and repeat the link check.

After deleting the reference, re-control after which the removal of the selected consumable invoice becomes available.

By pressing the "Delete" button, delete the document permanently.

Download Illustrated Instructions:

Discuss the operation and ask questions on it.