List form periodic information register 1s 8.3. Changing and deleting entries

1C information registers it is a structured set of data with dimensions and resources. Designed to store periodic information.

Periodicity

Information is stored by dimension and period. You can set the frequency of the information register:

• Non-periodic
• by registrar
• second
• a week
• month
• quarter

Frequency is needed to select information from the register for a certain period of time. If you specify a frequency, entries in the register will be made with the period when the entry was made. Let’s say if you look at the “Item Prices” register, you can see the history of price changes, with what measurements and in what period of time the entry was made.

Periodicity in information registers is needed for information that changes over time, for example: exchange rates, product prices, product discounts and markups, etc.

Registrars

If you make an entry into the information register using a document, you need to set the entry mode: “Submission to the registrar” and select the document with which the entry will be made in the register. Then the “Registrar” field will appear in the register, where information will be stored on what document the entry was made with. The recorder can also be used as a period; to do this, indicate in the “Frequency” field - “By recorder”. Subordination to the registrar is done when it is necessary to strictly link a register to a document and changing entries in the register manually becomes unavailable.

There may be several documents that will act as registrars. In order to add a registrar, you need to go to the properties of the desired information register, go to the “Registrars” tab and check the boxes next to the documents that will act as a registrar.

You can see the movements the recorder makes from the document. To do this, you need to go to the document you are interested in, click: Go – Document movements by the registrar.

Don’t forget to add rights in the registry properties; they can be assigned on the “Rights” tab. Then in the list of roles you need to select the role to which you want to add rights to the register and in the list of rights set the rights to for the selected role.

Uniqueness of records

The uniqueness of a record depends on the period and measurements. For example, if you want to write a record with the same measurements in the “Item Prices” register on the same day, then you will not be able to do this and the program will cause an error, since the periodicity of the register is within a day.

If the frequency is set by the registrar, it also participates in the uniqueness of the record.

For non-periodic and independent registers, uniqueness depends on the combination of dimensions.

Forms

To view records, use the list form, in it you can set the selection according to the fields you are interested in, view the history of records and change them through the record form. You can view register entries as follows: in top menu Click the "Operations" - "Information registers" button. In the window that opens, select the register you need. After this, a list form will open in the form of a table, where each entry is a unique entry.

To edit/create, use the record form; if the record is subordinate to the registrar, then the field will not be available and the form cannot be created.

You need to add forms in the configurator by going to the information register, in the “Forms” tab and click on the “magnifying glass” the desired type forms. Next, a window will open where you can configure the fields of the future form (location, names and specify functionality).

Dimensions, resources and details

Dimensions are intended to form the uniqueness of a record; in the future, you can select them and make a cut based on a specific dimension. The combination of measurements forms the record key. It is better not to create a large number of dimensions so that the table does not grow and does not slow down while working with it.

Dimensions have a “Leading” checkbox; if it is checked, the record will be stored in the database as long as this dimension exists. Several leading measurements can be made. For example, in the information register “Item prices”, the leading dimension is the item; if you delete an item that is included in the record, then the entry in the information register for this item will be automatically deleted.

Resources are designed to store summary information: quantity, price, etc. In the future, we will receive resources for a certain period of time (if the register is periodic), according to measurements.

Details, in most cases, are intended for storage additional information, they do not take part in the uniqueness of the record. For example, you can enter information such as author, comment, etc. into the details.

You can perform the following actions with the information register:

• Deleting an entry in the 1C information register

Peculiarities

— Uniqueness of records based on a set of dimensions: each record in the information register is a new resource value.

— Entries in the information register can be either periodic or not.

— The information register can be dependent and independent of the registrar.

— It is possible to make a cut of the first and latest entries on the required date. This is implemented by virtual tables: “Slice of the First” and “Slice of the Last”. To use these tables, you can use both selection and query (in the query designer you will select these virtual tables and you can make a query on them). These tables will be available if the information register is periodic.

The “Item Prices” register is a periodic register of information, entries are made according to the registrar.

The image shows that the frequency is set to within a day. This means that the price can be changed once a day based on measurements unique during the day.

The register is subordinated to the document “Setting item prices”. This means that the entry into the register comes from this document. Movements on a specific document can be viewed from the document form “Setting item prices”.

The register is designed to store information on the price of an item, with the dimensions “Price type”, “Item” and “Item characteristics”. The leading dimension is all three dimension fields; it will be possible to make selections based on it when sampling.

Conclusion: After reading the article, you will be able to create a 1C information register, add dimensions and resources, configure editing and list forms. Create a record and make a selection existing records. If you have any questions, use the comments in the article, I will try to quickly answer your question.

There are several types of registers in 1C:

• Accumulations that store balances or turnover in numerical form;
• Calculations that store calculation types and calculations themselves are typically used for payroll calculations;
• Accounting records with data on accounting calculations in the form of Dt-Kt;
• Information registers.

We will dwell on the latter in more detail, since they allow us to compile data from the database by measurement sections. For example, “Price Nomenclature” stores data for a specific item and characteristics for a certain type of price.

Fig. 1 “Price nomenclature” register

Characteristics

The register can be either periodic or non-periodic, when there is no need to save the sequence of changes. But if you still need to store it, then it is determined within what period the program will establish control over the uniqueness of records: per second, per day, per month, per quarter and per year.

Fig.2 Frequency and recording mode

If you try to create two records within the same period, the program will generate the error “A record with such key fields exists!” and will not allow you to write to the database.

You can also specify the recording mode. The first is with “Submission to the registrar”, in which records will be recorded by documents and in each of them the registrar document will be indicated. If you choose the second - independent mode, then the data is not recorded by the recorder, but is added, for example, directly from the list or as processing.

Fig.3 Recording modes

The peculiarity of the periodic register is that you can use a slice of the last or first ones, obtaining ready-made values ​​from the database about the last/first set value for a certain date.

Entry into the 1C information register

Rows in a register with a period and a recorder containing information about resources in terms of dimensions are called records.

To add a record to a register, either a record manager or a recordset is used. If entries in the register have shared key, then you must use a Recordset. And to record one single record, if all records in the register are unique, you must use the Record Manager.

An example of a record when using the Information RegisterRecordSet object.

Using the recording manager:

NewRecord = Information Registers.Currency Rates.CreateRecordManager(); NewRecord.Currency = Directories.Currencies.FindByName("USD"); NewRecord.Period = Date(31,12,2016); NewRecord.Course = 100; NewRecord.Multiplicity = 1; NewRecord.Write();

When you use a recordset and the Write method, a record is written to the recordset's information register. In this case, either simply adding lines or replacing existing lines in the register can occur. For independent registers, without setting selections, all entries in the register will be deleted and replaced with added entries.

If you write data into a subordinate register without selecting it, an error will occur.

An example of an entry using a set of entries in the PriceNomenclature information register subordinate to the registrar:

NewRecordSet = Information Registers.Nomenclature Prices.CreateRecordSet(); NewRecordSet.Selection.Register.Set(Link); NewRecordSet = NewRecordSet.Add(); NewDialRecord.Period = Link.Date; NewSetRecord.Nomenclature = Link.Nomenclature; NewSetRecord.Price = Link.Price; NewRecordSet.Write();

An example of a recording through the recording manager:

Record = Information Registers.Currency Rates.CreateRecordManager(); Record.Period = Date; Entry.Course = Course; Record.Currency = Currency; Write.Write();

Search and read information register

To find an entry in the information register and read it, you need the help of queries. For example, we need to get prices entered by a certain registrar:

SELECT Nomenclature Prices.Nomenclature, Nomenclature Prices.Price FROM Register Information.Nomenclature Prices HOW Nomenclature Prices WHERE Nomenclature Prices.Registrar = &Registrar

Changing and deleting entries

To delete an information register entry, for example all EUR exchange rates, use the following code:

Selection Structure = new Structure("Currency", Directories.Currencies.FindByName("EUR")); Selection = Information Registers.Currency Rates.Select(,Selection Structure); While Select.Next() LoopRecordManager = Select.GetRecordManager(); Select.GetRecordManager().Delete(); EndCycle;

For quick and complete cleaning register you can use the following code:

NewRecord = InformationRegisters.TestRegister.CreateRecordSet(); NewRecord.Write();

To adjust and change the register, as well as quickly fill the register with data, you can write a universal processing.

1C 8 information register is a metadata object intended for storing reference information in terms of dimensions determined by the developer.

A typical example of using an information register is storing information about exchange rates by currency and period.

Let's take a closer look at the properties and settings of the information register.

The two main properties of the convergence register are − Periodicity And Recording Mode.

These are unique properties of the information register that no other metadata object has. Let's take a closer look at them.

This property allows you to add an additional dimension to the list of dimensions - Period. With its help, you can solve a large number of problems: storing information in a database, taking into account its relevance on a certain date. There are many applied examples of using periods: storing the value of a currency for each day, storing the price of an item, etc.

The frequency can take the following values:

• Non-periodic
• Within a second
• Within a day
• Within a month
• Within a block
• Within a year

Get 267 video lessons on 1C for free:

If you select a periodicity other than the Non-periodic option, the system will control the uniqueness of records within the specified period of time. If the record is not unique, the 1C system will display a message and will not allow you to write to the database.

And one of the main features of the periodic information register is the ability to obtain ready-made values ​​of the “Cut of the first” and “Cut of the last”. This information allows you to very quickly obtain from the database information about the last (first) set value on a specific date.

Information Register Write Mode

In 1C 8.2 and 8.3, this property can be either “Independent” or “Submission to the registrar”. In the first case, entries can be made both programmatically and from the list form of the information register. In the second case, it is necessary to indicate the document that records the entry. This imposes certain restrictions, but at the same time opens up new opportunities.

Details Register Dimension Properties

You should also pay attention to the palette of measurement properties of the information register 1C 8.3. Especially for the Leading and Main Selection flags:

• Presenter— a property of a measurement that implies information that without the value of this measurement, the register entry does not make sense. In fact, this means that when the system deletes a value from a dimension, it also deletes the register entry with the “Leading” dimension. Only one measurement can be set.
• Main selection— if the register is independent, these measurements will be used to determine the registration of changes for the exchange plan. Similar usage Main selection by period includes the main selection for period for periodic registers.

Program entry into the 1C information register

There are two ways to add new records to the information register: using the record manager and using a recordset. The first case is suitable for a single record, the second - for two or more records.

Using the recording manager:

NewRecord = Information Registers.Currency Rates.CreateRecordManager();
NewRecord.Currency = Directories.Currencies.FindByName("USD");
NewRecord.Period = Date(31,12,2016);
NewRecord.Course = 100;
NewRecord.Multiplicity = 1;
NewRecord.Write();

Using a set of 1C information register records:

NewRecordSet = Information Registers.Currency Rates.CreateRecordSet();
//if you do not set selection, all entries in the information register will be deleted
NewRecordSet.Selection.Currency.Set(Dollar, True);
NewRecordSet.Selection.Period.Set(Date(12/31/2016), True);
//form the set record directly
NewRecordSet = NewRecordSet.Add();
NewSetRecord.Currency = Directories.Currencies.FindByName("USD");
NewDialRecord.Period = Date(12/31/2016);
NewSetRecord.Course = 100;
NewSetRecord.Multiplicity = 1;
NewRecordSet.Write();

Registers is a collection of records about objects. They not only store the attributes of program objects, but also record movements according to these parameters. Their purpose is to save data and provide reporting on certain parameters.

The parameters may vary depending on the type of information being stored. Tables store the properties of objects. For example, for the cost of goods it will be:

• Name
• Manufacturer
• Package
• Purchase price

The results of operations carried out in the system are recorded in the registers. Each of the documents records its results. Such entries are called Movements. You can use them to sort and compare data.

If you add an additional time parameter, for example, the price for a certain date, then the selection can also be made by time periods. Storing information with a period value helps to structure and filter the necessary data.

Setting up information registers in 1C 8.3

Setting up such deep program elements is mainly the job of programmers and users do not have to work with them every day. Depending on the type of register, access to it may be located under different control buttons of the corresponding subsystem.

As a rule, users do not need information about where the information register is located in 1s 8.3. Let's just say that the main access to them is in the Configurations section.

How to make an entry in the information register in 1C 8.3

Entries in registers are the result of operations in various parts of the program. But there is an opportunity to make immediate changes. To do this, it is possible to write to the information register 1C 8.3 programmatically (let the analytics of exchange rate fluctuations be an example):

• Let's use the Record Manager to perform one action:

NewRecord = Information Registers.Currency Rates.CreateRecordManager();

NewRecord.Currency = Directories.Currencies.FindByName("UA");

NewRecord.Period = Date(07/30/2018);

NewRecord.Course = 50;

NewRecord.Multiplicity = 1;

NewRecord.Write();

• Let's take a Set of Records for several introductions:

NewRecordSet = Information Registers.Currency Rates.CreateRecordSet();

//Attention! It is important to indicate the selection criteria here. Otherwise, all previously made entries will disappear.

NewRecordSet.Selection.Currency.Set(Hryvnia, True);

NewRecordSet.Selection.Period.Set(Date(07/30/2018), True);

//Now you can start recording the set itself

NewRecordSet = NewRecordSet.Add();

NewSetRecord.Currency = Directories.Currencies.FindByName("UA");

NewDialRecord.Period = Date(07/30/2018);

NewSetRecord.Course = 50;

NewSetRecord.Multiplicity = 1;

NewRecordSet.Write();

How to delete information register in 1s 8.3

In the 1s 8.3 program, adding an entry to the information register is relatively easy. Now let's consider the removal option. Let's take a hypothetical scenario where you need to delete information about the Organization. In this case, the Organization to be deleted parameter will have its own link.

We perform the following actions:

• Code 1C v 8.x
• RecordSet = Information Registers.Organization Construction Objects.CreateRecordSet();
• Recordset.Selection.Organization.Set(Organization to be deleted);
• RecordSet.Write();

After this, you need to create a variation Set of Records, where you can make a selection for the company that is the same as the Organization to be deleted. The result is an empty set of records. For complete removal you need to write it down with substitution. Thus, all information intended to be erased is replaced with empty values.

Note that the sampling of such a set of records is set to equality only.