1s information register value as of date. Details Register Dimension Properties

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 the entries in the registry have a common 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 via 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;

To quickly and completely clear the 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.

Documents are the essence of accounting in 1C. Each document has a result, for example +10 items arrived.

Reports – allow you to view the results. These results are summarized and shown to the user.

However, there are a lot of documents and if it were necessary to summarize their results, it would be too difficult. Therefore, a better way has been invented!

Documents record their results (called “movements”) in special tables - 1c registers, which themselves summarize the results so that the report simply displays the pre-calculated totals.

Today we will talk about 1C registers and their use.

The 1c register is a table, the same as in Excel, each document writes one or several lines of its movements (results) with some sign - plus or minus - into the 1c register. This means that the total of the 1C register has changed to the corresponding figure.

The document that recorded movements in the 1C register is called the Registrar. The date and time of the movement are equal (in 99% of cases) to the document date. The date of movement is called the Period.

Each 1C register usually takes into account the movements of one particular directory. For example, the 1C register Goods in warehouses - movements of goods (in terms of 1C “nomenclature”) - how many goods arrived at the warehouse, how many left. Register 1C Mutual settlements with counterparties (buyers and suppliers) - movements of contracts with counterparties - how much the counterparty owes us after the purchase or how much we owe him after payment. The directory in the context of which the register is maintained is called the main dimension (analytics) of the 1C register.

Of course, no one makes one basic measurement to the 1C register. After all, if we take into account the movement of goods, then we are interested not only in which goods have decreased or increased, but also, for example, in which warehouse. Therefore, there are always three to five additional measurements “just in case,” which can be called additional analytics of the 1C register.

How is a document posted through registers?

Document movements across 1C registers

Let's see how 1C registers work. Here we have a goods receipt document, in which we see that the product Oil has arrived at the Main warehouse.

In terms of logic and mathematics, this document has the result:

Kremlin oil, Main warehouse +10 (pcs)

Let's check - is this true?

This menu item will show us all the movements of the document that it has made in registers. As we can see, the document made movements through a whole bunch of 1C registers, in each of which it recorded different information (in accordance with the purpose of the 1C register). According to the 1C Goods in Warehouses register, he made the posting that we calculated.

How does it look in the 1C register? Let's open the 1C register through the Operations menu.

The 1C register has opened. There is a lot of data in it. We will make a selection only according to our document.

As a result, we see the movement of our document through the 1C register. It exactly coincides with what we calculated manually:

• Plus – type of movement (income/expense)
• The registrar is our document
• Activity – this motion string is valid (i.e. not disabled)
• Nomenclature, main dimension
• Warehouse, additional dimension
• Quantity, resource (that is, the number we count).

If we select not by document, but by nomenclature (in exactly the same way), then we will see the movements of all documents that touched this nomenclature. One document - we bought the goods. The other one was sold. Naturally, the 1C register itself does not show the total - for this you need to use a report or query.

1C registers are different (we will discuss this below). Postings to different 1C registers also look different. We have now looked at the entries in the 1C accumulation register. This is what the postings of our same document look like according to the 1C accounting register, which works on the basis of the 1C accounting (tax) chart of accounts.

Why are 1C registers needed?

1C registers come in different types. The purpose of using the 1C register depends on its type.

• 1C information registers
  This is a regular table, like in Excel. It has no movements (income/expenses). The 1C information register is usually used to store additional directory data. Using the 1C information register you can organize
• Accounting registers 1C
  From the user's point of view, accounting is maintained on the accounting chart of accounts. In fact, accounting is kept in the table of 1C accounting registers, which are made in the context of the 1C chart of accounts.
• 1C accumulation registers (1C balance register)
  Document movement table + and –, which automatically calculates the total at the beginning of the period and the total at the end of the period. For example, the movement of the Lopat product was +10, and then -8. This means that the remainder at the beginning was 0, and the remainder at the end became 2.

  The 1C accumulation register with the “Balances” view means that movements will be stored (receipts and expenses, which are also called “Turnover”) and additionally, totals will be automatically calculated (called “Balances”).

  The 1C balance register is used in the case when the directory logically may have a remainder. For example, when we take into account the movement of goods, we will use the 1C balance register - after all, we can say that there are 3 pieces of the Lopat product left.

• Accumulation registers 1C (revolution register 1C)
  Table of movement of documents + and -, which does not count the total.

  The 1C turnover register is no different from the balance register, except that it does not automatically calculate balances.

  The 1C revolution register is used in the case when the directory logically cannot have a remainder. If we need to take into account sales of goods, then we will use the turnover register.

  For example, product sales were +10 (we sold) and then -2 (they returned to us). We cannot say that the balance of sales has become 8, because logically the concept of balance of sales does not exist; we will say that the total turnover (the sum of each line of turnover) has become 8.

• 1C settlement registers

  Table of movements by calculation types and periods. Used in payroll (called Complex periodic calculations).

Where are the 1C registers located?

The execution of a document in code (in a program) is prescribed by the programmer. To do this, open . Find a line like “Procedure ProcessingProcessing(”. Open the cross and you will see the program for processing this document.

Setting up and developing 1C Registers

Main features of 1C Registers, by tab:

For example, let's assume that the data will be taken from documents. In this case, every time when forming any the program would need a report go through all documents, extract data from them and only then, based on this data, create the requested report.

Obviously, such an approach to generating reports would be ineffective. Therefore, in practice, there is such a thing as holding a document. When posting a document (as opposed to simply recording it in the 1C database), based on the 1C form filled out by the user, Accounting creates so-called postings, that is, it makes one or more entries in one or more registers.

1C registers are simply tables containing columns and rows. The principle is the same as with Excel tables or regular “paper” tables.

The movement of a document through registers is the entries made by a document into registers when posted, called.

It is from these registers that data is taken when generating various reports. This much faster than going through all the documents. It is for this reason that you should always be careful not only when filling out the document form, but also, if necessary, control the transactions generated by the document.

There was an important part of the article, but without JavaScript it is not visible!

Types of 1C Accounting registers

In fact, registers in 1C: Accounting are used not only for storing document postings, but also for various other purposes. In this regard, there are several species registers:

• Information registers
• Accumulation registers
• Calculation registers
• Accounting registers

The last type of register stores the accounting entries of documents. How all these differ from each other and why, I tell you in the course I teach, Enterprise Accounting 8. Here I will give again a list of existing 1C registers, only in the form of a screenshot (using the example of 1C Accounting 8.2).

But the same thing using the example of 1C: Accounting 8.3:

website_

Viewing 1C Accounting registers

It never hurts to know where exactly certain registers are located in the program and why each of them is needed. Well, at least because one day ( and very easily!) you may need to review them in order to find and correct errors in accounting (a typical task when closing a month).

Any of the registers can be opened using the forms I provided above. That is, from a general list of registers of a certain type. As an example, I will give the most famous register - the accounting register. However, this name is more technical, since for the user it is called Posting journal.

website_

When you open any register, the data there is displayed "in the shared heap". They can be filtered according to the parameters you need in exactly the same way as you can do with documents.

Making changes to registers

If you take another look at the fragment of the contents of the 1C Enterprise accounting register in the figure above, you will notice the absence of a button Add. The fact is that Not all registers can be entered directly, i.e. open it and add elements (rows) manually, as you can do with documents or reference books.

A quick question: did you know that in some directories you also cannot enter data through everyone’s favorite “Add” button. Why do you think?

Here is an example of a simple information register into which entries can be made manually. Using such registers is, of course, easier.

website_

If there is no button in the register Add, then data in such registers is entered only by so-called registrars. The meaning of the concept of a registrar is illustrated by the same picture with the form of an accounting register.

Let's sum it up

1C Accounting registers store data that is no less important than that recorded in document forms. It is very important to be able to work correctly with various registers - this helps to understand whether the program is doing everything correctly (in accordance with your needs). All this also helps to correct errors in accounting.

I discuss the features of different registers, entering data into them, types of registrars, the difference between periodic and non-periodic registers, and much more in my course 1C: Accounting 8, presented on this site.

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.

Frequency 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.

In the registry properties, do not forget to add rights; 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 the 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 clicking on the “magnifying glass” next to the desired type of form. 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 to store 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 cross-section of the first and last records for the desired 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 select existing records. If you have any questions, use the comments in the article, I will try to quickly answer your question.