How to disable continuous numbering in 1s. Methodology for using the numerators directory

Users of 1C 8.3 enter numbers of incoming documents manually, so when processing a large number of documents there is a high probability of errors.

In case of an error, correcting the numbering of incoming documents in the 1C 8.3 database is very simple. To do this, you need to open the required document and put the required document in the document number field. For example:

In the Goods Receipt document:

Or in the received invoice:

When entering the document Receipt of goods and services in 1C 8.2 (8.3), you must indicate the number and date of the supplier’s primary document. If data is entered incorrectly, the details of the supplier document will be incorrectly reflected in analytical calculations. For more information about this, watch our video:

How to correct the numbering of outgoing documents in 1C 8.3

As for outgoing documents, the 1C 8.3 program, when creating them, itself assigns them a number:

Users see the automatically entered number after recording or posting a document:

When you try to correct the document number, the 1C 8.3 program will issue an information warning about the automatic numbering of outgoing documents:

The need to correct the numbers of outgoing documents arises in the event of a violation of the chronology of entering data into the 1C 8.3 database.

If such a situation occurs in accounting, then correcting the numbering may lead to some difficulties, since in the case of manual adjustment of the number of the outgoing document, the sequential automatic numbering in the 1C 8.3 database may be lost. In addition, if the outgoing document has already been signed and is with the buyer, then the credentials in the 1C 8.3 program will differ from the issued primary documents.

How to restore the chronological numbering of invoices and cash documents in 1C 8.3

In 1C 8.3 it is possible to automatically restore the chronological numbering of incoming and outgoing documents in the service:

This service in 1C 8.3 allows you to check your accounting at any time according to certain provisions of the law and the built-in algorithms of the program. Express check in 1C Accounting 3.0 (8.3) performs accounting analysis in the following areas:

• Accounting policies – checking compliance with general accounting policies;
• Analysis of the state of accounting - monitoring the balance of accounting accounts and identifying technical accounting errors in order to prepare data for the formation of external reporting documents;
• Cash transactions – checking the correctness of cash transactions;
• Maintaining a sales book for VAT – checking the correctness of the reflection of transactions related to maintaining the sales book;
• Maintaining a purchase book for VAT – checking the correct reflection of transactions related to maintaining a purchase book.

To control the numbering of documents in 1C 8.3, you need to go to the Express check settings:

In the settings window that opens, uncheck all accounting sections, since the 1C 8.3 program can check the correct numbering of only cash documents and invoices issued:

Open the Cash Transactions section with “pluses” and check off only compliance with document numbering:

Open the “pluses” section of Maintaining a sales book for value added tax and check the boxes only for compliance with the numbering of documents:

After that, click the Run check button. At the end of the check, the 1C 8.3 program will show:

• Subject of control;
• Result of checking;
• If there are errors, possible reasons for their occurrence and recommendations for eliminating errors:

When checking cash documents, as well as the purchase book and sales book for VAT, the 1C 8.3 program checks the chronology of documents and may suggest correcting the document numbering. In the Recommendations section you can see a proposal for eliminating this error - Automatic renumbering of documents. In addition, in the detailed error report we see a list of documents in which the chronology of document processing was violated.

When turning to the renumbering service, the 1C 8.3 program warns that there may be a discrepancy between the numbers of the issued documents and those that will be recorded. Here you can also choose which number to start renumbering from and which new document numbers will be recorded:

For convenience, the Renumbering service allows you to print a document, the number of which will be corrected. Or a register of documents with old numbers to verify accounting after renumbering:

After the user’s consent to renumber is received, the 1C 8.3 program will carry it out. Next, an information window will appear, which will display a list of renumbered documents indicating the new and old numbers, and it will also be possible to print documents with new numbers from Express Check or their register:

In the same way, you can restore the numbering of issued invoices:

Attention! By agreeing to the automatic renumbering of documents in 1C 8.3, the user risks discrepancies between the credentials and the issued original invoices. This may complicate filing your VAT return:

After completing the operation of renumbering issued invoices, the 1C 8.3 program will issue an information message indicating the new and old numbers of issued invoices, and it will also be possible to print invoices with new numbers or a register:

In order for the error about the correctness of document numbers to disappear from the Express check window, you need to close the renumbering window and recheck the accounting:

The "Numerators" directory is intended for setting up rules for creating registration numbers for incoming, outgoing and internal documents.

To create and change numerators in the “Regulatory and additional information” section in the navigation panel, execute the “Numerators” command; in the list, using the “Create” and “Edit” commands, create and edit the required numerators.

The numerator is specified for the types of documents. It is permissible to specify one numerator for several types at once, for example, in order to support continuous numbering for them.

The name of the numerator must be selected according to the area of ​​application. For example, for the document type “Employment contracts”, it is permissible to enter the numerator of the same name “Employment contracts”.

In the "Frequency" field, select the frequency of use of this numerator. For each new interval, the numbering starts from the beginning.

If the rules for recording documents provide for the maintenance of separate numbering of documents of various enterprises, then the “Independent numbering by organization” flag must be set in the numerator. In this case, documents of the type to which this numerator is assigned will have a registration number of a single format, but with individual numbering for each organization.

Each numerator has its own progressive registration number, which does not depend on other numerators.

The numerator specifies the format of the registration number, which can be constructed (assembled from ready-made fragments) in the numerator card. The registration number format has the ability to include various service fields, highlighted with square brackets and delimiters (for example, a dash, a slash).

If the separator is placed inside square brackets within which a service field is defined, then it will be added to the number only when the service field is added. For example, if the registration number format is [Number][-IndexOrg], then a dash will be inserted into the number only if the index of the related organization is defined in the list of numbering indices.

The numerator allows you to generate a document number using a prefix or suffix of the number of the associated document. To do this, use the service field [ConnectionDocNumber], which can be added to the number format. At the same time, the "Link Type" field is made available, in which you need to define the link type that defines the related document from which the number will be obtained.

The numerator allows for separate numbering in the context of a related document. To do this, in the numbering card you need to select the "Independent numbering by linked document" checkbox and define the type of connection that defines the linked document. For example, if such a numerator is assigned to the document type “Additional. agreement", then add. agreements related to a single contract will have an increasing numbering, starting from 1, which will be independent of the additional numbering. agreements relating to another contract.

You can see the result of the created numerator in the "Example" field (at the bottom of the form).

The list of current numbers (including for each organization) can be seen using the “All numbers” command of the navigation panel of the numberer card.

The list of types of documents for which a numerator is assigned can be seen using the “Assigned to” command in the navigation panel of the numerator card.

The “Corporate Document Flow” program has automatic numbering of all directories and documents, while documents of the “Corporate Documents” type have their own numbering system configured by the administrator, and all other objects use the built-in numbering of the “1C:Enterprise 8.3 / 8.2” platform.

The platform's built-in numbering involves assigning a document number (or directory code) at the time an object is recorded in the database. It is possible to manually edit an automatically assigned number or code; in this case, to prevent accidental changes in numbering data, the system issues a warning before attempting to change the number of a document or directory.

The numbering of corporate documents is determined by setting the types of numbering formats performed by the system administrator in the “System Administration” subsystem, item “Numbering of corporate documents”.

The numbering of corporate documents depends on certain numbering formats and on the assignment of a specific format to the desired types of documents and organizations.

Numberers are assigned using a special document “Assignment of Numberers”.

In the following sections we will take a closer look at working with corporate document numberers.

Numbering format

The numerator format determines the form in which the corporate document number will be generated, including the numerator format that determines what data will be included in the number, in what order they will be located and what separating characters will be used in the corporate document number.

Various system numbering formats are available in the “Numbering of corporate documents” screen form, “Numbering format” item. Selecting the “Number Format” item leads to the opening of a special system directory as shown in the figure below.

Each element of the “Number Format” directory contains the name of the numerator format and, directly, the format string, which is then used to determine the number of the corresponding corporate document.

The format string can be entered manually or, more conveniently, compiled interactively using data from the tabular part of the directory element. The tabular part of the directory element “Numerator Format” lists all possible tags (components of a numerator); the system administrator can mark the necessary tags in this numerator and click the “Generate numerator” button. The table section also indicates the maximum data length of each tag.

Below is a list of tags that can be used in the numbering format:

• Document Number ""
• Document type “[VD]”
• Department code "[KP]"
• Organization code "[KO]"
• Organization prefix "[PF]"
• Employee code "[KS]"
• Document type "[TD]"
• Nomenclature of cases “[ND]”
• Year (two digits) "[YY]"
• Year (four digits) "[YYYY]"
• Foundation document number “[TO]”
• Project prefix "[PR]"
• Project code "[KP]"

The figure below shows an example of the formation of a numerator based on a department code, an organization code and a five-digit serial number.

The tags noted in the table part participate in the formation of the document number.

Purpose of numberers

To assign numberers to specific types of corporate documents, there is a special document “Assigning Numberers”.

The document is located in the “System Administration” subsystem, in the “Document Numbering” item. The document “Assigning Numberers” allows you to assign the numberer format specified in the document (see the previous section) to specific types of corporate documents, as well as enterprise organizations. The following figure shows an example of assigning the numberer “Number - division code / organization code” for the type of documents “Incoming” three organizations. In the future, when creating this type of corporate document for these three organizations, the document number will be generated according to the specified format.

System administrators may not indicate any organizations in the list of organizations in the “Number Assignment” document, in which case the assigned numerator will be valid for all organizations.

If the document “Number Assignment” does not indicate the type of document, but only a list of organizations, then the assigned numerator will be valid for all types of documents and for the list of specified organizations.

Important! The assigned numerator begins to operate from the date specified in the “Date” attribute of the document.

The system can create as many “Numbering Assignment” documents as necessary to describe all possible options for numbering corporate documents.

Current numberers

In the “System Administration” subsystem in the numbering settings, you can open a list of current corporate document numberers. The list of current numerators displays information about all assigned numerators of corporate documents in the EDMS “Corporate Document Flow”.

If necessary, program administrators can make changes to the numbering system directly, through this list of current numberers.

How can I correct the numbering of documents in 1C 8.3?

What to do if the numbering of documents is lost in 1C 8.3 or 8.2? 1C Enterprise Accounting 3.0 has a standard tool for this operation. This is the "Accounting Express Check" feature.

But, unfortunately, it checks for correct numbering only on cash documents (PKO and RKO) and on invoices.

This article covers:

• built-in tools
• and gradually create a simple processing for renumbering other documents

Before any actions on the database, be sure to make a backup copy.

Renumbering using Express Accounting Check

This processing for renumbering 1C documents is located in the “Reports” section. Next, look for the “Accounting Analysis” section and go to “Express Check”. The following window will appear:

Set the required period and click the “Perform check” button.

If errors are found in any section of the accounting, as usual, it will be highlighted in red.

In this configuration, we specifically created several error situations for clarity:

As you can see, our document numbering is incorrect. And as it is written, the 1C 8.3 program offers to fix this automatically. Click on the highlighted link:

And we can clearly see that the numbering is indeed broken, and the program suggests replacing number four with number three on the last invoice.

Please note that it is possible to set the starting number for a given period. This means that if we were to start at number 123, that's what will happen. This is relevant when renumbering does not occur from the beginning of the year.

Note! Renumbering of posted documents requires re-posting of these documents. Therefore, the process may take a long time. In addition, prefixes are taken into account when renumbering. Check to see if they have changed.

Click “Continue” and the renumbering process will begin.

For programmers: creating 1C processing for renumbering other documents

For our experiments, we will select the document “Sales (acts, invoices)”.

Let's create a new external processing and add the following details to the form:

• Start date
• Expiration date
• InitialNumber
• Organization

The “Organization” detail should be added only if records are kept for several organizations in one information base. Otherwise, it is enough to add the “Prefix” attribute. The request in this case will be a little simpler. Here's what happened:

And so, we create a team on the client. Since requests are executed on the server, this command will only contain a call to the server procedure, for example, “ExecuteOnServer()”.

Request = New Request;

Request.Text =

"CHOOSE
| Sales of Goods and Services. Link,
| Sales of Goods and Services. Organization. Prefix
|FROM
| Document. Sales of Goods and Services HOW to Sales of Goods and Services
|WHERE
| Sales of Goods and Services.Organization.Link = &Organization
| And Sales of Goods and Services. Date BETWEEN & Start Date AND & End Date";

Query.SetParameter("StartDate", StartDay(ThisForm.StartDate));
Request.SetParameter("EndDate", EndDay(ThisForm.EndDate));
Request.SetParameter("Organization", ThisForm.Organization);
ResRequest = Request.Execute();
DetailRecord Selection = Query Res.Select();

Now let’s go through the selection result in a loop and renumber the documents:

StartNumber = ThisForm.StartNumber;

While SelectDetRecord.Next() Loop

Prefix = SelectionDetRecord.OrganizationPrefix;
DocObject = SelectDetRecord.Link.GetObject();

DocObject.Number = Prefix + Rights("0000000000000000000" + StartNumber, 11 - StrLength(Prefix));

StartNumber = StartNumber + 1;
Attempt

If DocObject.Posted Then

DocObject.Write(DocumentWriteMode.Write);

Otherwise

DocObject.Write(DocumentWriteMode.Write);

endIf;

Exception

Report(ErrorDescription());

EndAttempt

EndCycle;

Naturally, this is a simplified example of how documents can be renumbered. If desired, here you can add a selection of other types of documents, as well as organize renumbering of directory codes.

This is how terrible the numbering was before processing started:

After starting processing, the numbering was aligned:

Based on materials from: programmist1s.ru

The next number is automatically assigned. What to do if the numbering of documents in 1C is lost, how to restore the chronological order, what are the reasons for such a failure - we consider it in order.

Restoring the chronological order of document numbering.

Any document (document, English) of the 1C system is completely characterized by its three components - number, date and time. The numbering of documents in 1C is configured so that its new number is proposed automatically, but can also be entered manually. In this case (in both cases), the Numerator controls its uniqueness - creation with the same one will be prohibited.

Documentation of a certain type is collected in separate journals (and each of them is assigned its own unique number by the Numerator):

Numerator

Just like documents and journals, the Numerator is an application object. Its use is intended to consistently number documents in various journals in accordance with their types.

Correcting numbering errors in 1C 7

The Numerator mechanism in the seven is set up simpler than in 1C 8. This is how you can correct it.

Manually

For this:

• Open the journal of the corresponding type of documentation;
• Sort by ascending date;
• Manually correct all incorrect numbers from the first (in time) to the last.

New numbering

Another solution would be to create a new numbering. For this purpose it is enough to change the initial prefix.

Automatically

This operation requires special care. This is done using autoprocessing UCHOICE.ERT. It is located in the ExtForms folders of the information databases. You can ask friends or specialists for similar treatment.

Corrections in eight

Documentation in accounting is divided into two types:

• Input - received from counterparties (the numbers assigned by the counterparty are important in it). Incorrect entry of it results in incorrect reflection of the details in the certificates of analytical calculations. For example, in reconciliation acts;
• Outgoing - it is created by the user himself (in it, numbering must be performed end-to-end in a time period). This is important, for example, for tax invoice registers.

Let's look at options to fix the problem in different cases.

Incoming numbering

Input documentation numbers are entered manually. It is difficult for an employee to maintain constant attention and, when processing a large amount of data, the operator is doomed to make a mistake. To correct numbers in incoming documents, open them and enter the correct attribute in the designated field. For example, in the “Receipt of Goods” dock:

In “Receipt to account”:

On the invoice/invoice:

The details in the “Receipt of goods/services” journal and other incoming correspondence are corrected in the same way.

Outgoing document flow

The automatically entered number of the created document is visible after it is recorded or posted. When you try to fix it, the program will display a warning about autonumbering.

When manually assigning (entering) it, one nuance of the Numerator’s operation is triggered. The 1C system always remembers the last number entered as new for subsequent counting. For example, the last number assigned automatically was KA-000175. And the user, when entering manually, assigned the following - PO-000123. Therefore, the next license plate will be PO-000124. That is, the existing rule will fail. Obviously, numbering errors in logs occur only due to the carelessness of users (during manual correction).

IMPORTANT. Manual correction of outgoing numbering is not recommended to avoid compromising the integrity of accounting.

Restoring numbering using “Express check”

In the third version of the eight, it is possible to automatically restore the chronological order of incoming/outgoing documents using the Express Check service. To begin, all the checkboxes in the settings window for all accounting sections need to be unchecked:

Use the “Plus” sign to open “Cash Transactions” and check the “compliance with document numbering” checkboxes. After opening the “plus sign” next to “Maintaining a sales ledger”, check the box to comply with the numbering.

The check is performed by clicking the “Run” button. The report states:

• Controlled item;
• The obtained control result;

If there are errors, advice on elimination (renumbering) and an analysis of the occurrence will be available for viewing in the Recommendations section. A detailed report-list of documents with errors is also provided:

If you use the renumbering command, the system will warn you about a possible discrepancy between the numbers of already issued documents and those in the database. In addition, you can select a document to start renumbering and the type of new numbers:

After the command to renumber, the system executes it. And upon completion, an information plate is displayed with a reflected list of corrected documents, with a list of new and replaced numbers. You will have access to print the corrected documentation or its registry. The numbering of issued invoices/invoices is also restored:

IMPORTANT. When accepting auto-renumbering, there is a risk of deviation between the accounting data and the primary one that has already been issued. Such cases complicate the filing of returns with tax authorities.

To get rid of the numbering error in the Express Check window, you need to close the renumbering window and check the accounting again.

One of the methods discussed will help you fix the numbering failure. If none of the methods failed to set up/change the numbering in the right direction, contact specialists in this field.