Item series ut 11. Setting up item series

The program “1C: Trade Management 8” (rev. 11.3) implements accounting for product series. Its possible options and settings are described in our article.

Let's consider the simplest type of such accounting - a reference indication of product series.

Features of reference accounting for product series

If the reference version of accounting by series is used, then series of goods can be indicated when performing operations - receipt, movement, shipment. Specific operations for which series indication will be required are configured in the series accounting policy.

However, the reference accounting option does not allow you to take into account the balances of goods and their cost by series.

When using reference accounting by series, a situation is possible when the receipt of goods of one series is registered, and when this product is shipped, another series is indicated. In this case, the program will not control the balances by series.

However, with this accounting method, you can use reports to track all movements of goods by series. This can help in such cases as, for example, checking the validity of the client’s claims (if the client submitted a claim for a product that was not the one that was purchased from our company).

Setting up the item type for reference accounting by series

Let’s create a new item type – “Electric bicycles”, with the item type “Product (without accounting features)”.

Reference data and administration / Reference data / Nomenclature classifiers / Types of nomenclature

In the item type card on the “Basic” tab, set the flag for accounting by series; in our example, they will be configured for this type.

By default, the program has the following settings:

series identifies an instance of a product that has a unique serial number;
The series details include only the number, without an RFID tag.

In the example, we will leave the default values. Please note: if a series identifies an instance of a product, then only reference accounting by series is possible. However, in our case this is what is required.

For the batch accounting policy in the example, we will select the “Configured for each warehouse” option. In the field that appears, add a line, indicate the warehouse, then open the policy selection.

Let’s create a new series accounting policy with the “Reference indication of series” type. In the policy form, we will indicate the operations in which a series of goods will be used (in the example, acceptance from the supplier and shipment to the client).

Please note that the policy type "Series reference" does not allow the use of series in planning (that is, in orders). The series will be applied upon selection - directly in the distribution documents.

Let's write down and close the series accounting policy and item type.

Creating an item

Let’s open the product reference book and create a position with the view “Electric bicycles” – “Electric bicycle 1”.

Reference data and administration / Reference data / Nomenclature

After filling, we will write down and close the item item.

Purchasing goods with serial numbers

We will arrange the purchase of electric bicycles with a pre-order to the supplier.

Purchasing / Purchasing / Orders to suppliers

We will create and fill out an order for the supplier. As you can see, product series are not specified in the order. After filling out, we will post the order in the final status “Confirmed”.

Based on the order, we will create a “Receipt of goods and services”.

In this document, on the “Products” tab, there is a column “No.” The red icon in it means that the product is set to be accounted for by series, but the series are not specified. The document in this form cannot be processed.

To enter serial numbers, select the line with the product and click the “Specify series” button.

The “Registration of product series” window will open.

When registering product series, you can either enter new series (the “Input” tab in the registration window) or select from previously entered series (the “Selection” tab). The series number, in turn, can be entered manually or using automatic generation or filling (buttons “Generate number” and “Fill in numbers...”)

In the example, we will enter new numbers manually using the “Enter number” button. Then click “Finish”.

After registering the product series, the pictogram in the “No.” column turned green.

We will post and close the goods receipt document.

Selling goods with serial numbers

Now we will reflect the sale of purchased electric bicycles, with the registration of a preliminary order for the client.

Sales / Wholesale / Customer Orders

We will create and fill out a customer order. In it, as in the order to the supplier, series are not indicated. We will specify the “Ship” action for the product and post the order in the “For Fulfillment” status.

We will create “Sales of goods and services” based on the order. Here on the “Products” tab there is a “Series” column. The icon in it shows whether series are indicated for goods for which accounting is carried out using series.

Our icon is red because the series of goods being shipped have not yet been registered. Click “Specify series”.

Series of electric bicycles have already been registered, so in this case you do not need to introduce new series, but select from the existing ones.

Let’s go to the “Selection” tab in the registration window. To display all episodes, click “All”. Previously introduced series have appeared. Check them off and click Finish.

However, the program would also allow the introduction of new series; in this case, the document would be processed, since the reference accounting of series does not control the balances of the series.

We will document the sale of goods and services.

The sales document allows you to print the “Invoice” form, which displays series of goods.

Accounting by series is an additional analytical aspect of item accounting. Series are used if you need to classify goods by batch, or unique serial numbers, or expiration dates, etc. You can set one of the options for using series:

A copy of the product by unique number
Batch of goods by numbers
Batch of goods by expiration date
Batch of goods by numbers and expiration dates

If the option is selected Batch of goods by expiration date or Batch of goods by numbers and expiration dates, then you can specify the minimum shelf life quantum itself, up to which it will be taken into account. This can be either a day or an hour.

In addition to specifying what exactly the series identifies, you must also specify the series accounting policy. Available options:

Reference indication of series (control of goods balances by series is not carried out, but information on series is recorded in turnover documents)
Automatic calculation of series balances using FEFO (control of product balances by series is not carried out, but in the report Remaining goods by expiration date product balances are dynamically calculated by series and expiration dates using the First Expired Fist Out principle)
Management of batch balances (registration of product balances by batch is maintained)
FEFO management of batch balances (registration of goods by batch is maintained; in goods write-off documents, the system first of all offers goods that are about to expire)
Cost accounting by series (end-to-end cost accounting by series)

The series accounting policy is configured for a specific type of item. Moreover, it can be applied both for all warehouses and production departments, and for a specific warehouse and/or a specific production department:

Question 1.29 of exam 1C: Professional by ERP Enterprise Management 2.0. Accounting by series of items can be used for types of items:

Question 1.30 of exam 1C: Professional by ERP Enterprise Management 2.0 . By series we mean:

Copies of goods with the same serial numbers
Lots of goods with the same serial numbers
Lots of goods with the same expiration dates
Lots of goods with the same batch numbers and expiration dates
Option 2 or 4 (depending on setting)
Options 1 or 2 or 3 or 4 (depending on setting)

One of the accounting options for product series in “1C: Trade Management 8” (rev. 11.3) is managing series balances. This method allows you to take into account warehouse balances of goods by series.

Let's look at an example.

5 pieces of the product “Electric bicycle 1” were purchased and received at the warehouse. Electric bicycles belong to different series (from 00001 to 00005). It is necessary to reflect this fact in 1C, with the possibility of accounting for balances by series.

Setting up the item type and batch accounting policy

Setting up accounting by series is carried out at the item type level.

Reference data and administration / Reference data / Nomenclature classifiers / Types of nomenclature

Also, types of nomenclature are available in the “Nomenclature” reference book (right panel “Types and Properties”).

Reference data and administration / Reference data / Nomenclature

Let’s open the item type (in the example – “Electric bicycles”). In the view card on the “Basic” tab there is a flag that enables accounting by series. Let's put it there.

Series settings can be made for this view, or borrowed from another view. Let's select a setting for this type of item.

When setting up, you must specify the composition of the series details, including the identification object, and select the series accounting policy.

For more information about the types of batch accounting policies and other settings for batch accounting, see the article.

The default set of series details can be changed using the “Change” link. In the form that opens, you should select what identifies the series - an instance of the product or a batch.

For series identifying a specimen, only a reference indication of the series is possible. (See article). You can manage batch balances only if they identify product lots.

Let's select the identification of the batch of goods. The series number will be used as a prop; the expiration date is not needed in our example.

The batch accounting policy can be configured either for all warehouses, or for each warehouse separately. Let's specify the policy for the warehouse (in the example - “Hangar”).

The policy is selected from the directory. You can either select an existing batch accounting policy that matches the parameters or create a new one. Let's create a new policy.

Now you need to specify the policy type. It is he who determines the possibilities of accounting. Let’s select the “Manage series balances” type.

If the “Manage series balances” type is selected for the batch accounting policy, then marks for all transactions are automatically set in the policy card. Unchecking is not available. This means that for item types and warehouses that use this policy, it will be necessary to specify product series in all warehouse operations.

For this type of policy, you can only configure the order in which series are specified during shipment operations. There are three options:

When planning shipment. In this case, the series are indicated in orders (customer, for internal consumption, etc.), and in the absence of an order - in invoices.
When planning selection. For order warehouses, series are indicated in the warehouse release order (in the “For picking” status), for non-order warehouses - in invoices.
Upon selection. The series are indicated after completing the selection task.

Select the option “When planning shipment”.

Let's write down and close the series accounting policy and select it. Then we will write down and close the item type. The batch accounting setup for this type is complete.

Specifying series when purchasing

Product series are not specified in orders to the supplier. The series are indicated in the goods receipt document.

We will create a document “Receipt of goods and services” - directly or based on an order to the supplier. On the “Basic” tab, we indicate the warehouse for which the batch accounting policy was configured (in the example, a hangar).

On the “Products” tab, add a line, select the product “Electric bicycle 1” (having the form “Electric bicycles”, for which we have set up series accounting), indicate the quantity and price.

The red icon in the “No.” column indicates that it is necessary to indicate a series of products. Otherwise, the document will not be processed. Select the line and click “Specify series”.

Registration of product series

Clicking the “Specify series” button from the receipt document opens a window for registering product series. Here you can either select from existing series (on the “Selection” tab) or enter new ones (on the “Input” tab).

In our example, products with new series arrive. You must enter their numbers. It can be done:

manually using the “Add” button;
using automatic generation using the “Generate number” button;
automatic filling using the “Fill in numbers” button.

In the example, click “Fill in numbers”.

In the opened form for setting up the filling of series numbers, you can generate a certain number of new numbers (in order or from a specified range), or fill the series with all numbers from a specified range.

Specify the generation of five new numbers and click OK.

In the product series registration window, lines with series numbers appeared. Numbers are available for manual correction. The quantity of products for each series must also be entered manually.

In the example we indicate 1 piece. each episode.

Please note that in the lower left part of the window a comparison is displayed: for what quantity of goods the batches need to be registered, and how many have already been registered.

After filling in the numbers, click “Finish”.

Then we will post and close the goods receipt document. We reflected the receipt of goods with serial numbers.

List of goods in warehouses

Let’s see how the series are reflected in the “List of goods in warehouses” report.

Warehouse and delivery / Warehouse reports / List of goods in warehouses

Let's generate a report. As you can see, it displays the receipt and final balance for each series of goods.

The program allows you to take into account products by series and expiration dates. Series and expiration dates are a section (analytics) of warehouse accounting. Series and expiration dates may be indicated upon receipt and shipment of goods. Products with series and expiration dates can participate in the internal turnover of the organization.

Working with batches and expiration dates of items involves two stages:

Setting up accounting for batches and expiration dates of items. This stage is performed by the employee responsible for maintaining inventory in the organization.
Working with batches and expiration dates in program documents. Performed by employees working with goods distribution documents.

Configuring System Settings
Before you start using the functionality, in the accounting settings, in the sectionNSI, you must check the boxUse series nomenclature.
Setting up accounting for batches and expiration dates of items
Setting up batch and item accounting consists of two stages:

Formation of rules (for different types of items and for different warehouses) for keeping records of the series and expiration dates of items.
Formation for the type of nomenclature, a list of warehouses and rules for keeping records of batches and expiration dates in these warehouses.

Rules for keeping records of batches and expiration dates are formed in the directory Series Accounting Policies. You can open the directory in the section Regulatory and reference information, using the navigation bar command Series Accounting Policies. By list command Create, you can begin to formulate a new rule for accounting for batches and expiration dates. In the shape of Batch Accounting Policy You can make the following settings.

In field Policy type you need to select a value from the list. The value of the field will influence how the system will account for goods: whether a full record of goods balances will be kept or this information will be recorded in documents for reference. When you fill out a field, other form values are filled in with default values.

The following values are available for the Policy Type field:

Series reference – a rule with this type of policy is created for goods for which it is not necessary to keep records of balances by series and expiration dates, but information on series or expiration dates must be recorded in turnover documents.
– a rule with this type of policy is created for goods for which it is not necessary to keep records of balances by series and expiration dates, but when accepting goods, as well as during internal trade turnover, it is necessary to record information by series or expiration dates.
Managing batch balances - a rule with this type of policy is created for goods for which it is necessary to keep track of balances by series and expiration dates. At the same time, records of batches by series and expiration dates are not kept, i.e. When shipping goods, you can specify any series or expiration date registered in the program.
- a rule with this type of policy is created for goods for which it is necessary to keep track of balances by series and expiration dates. The difference from the previous paragraph is that in the shipment documents the program will offer to write off goods with expiring dates first (first expire first out). At the same time, just as in the previous paragraph, the opportunity to indicate the serial number or expiration date for each unit of product remains.

In Group Specify series The flags indicate in which documents/operations the batches or expiration dates will be indicated. The check boxes are available if the policy type has a series reference specified. If the policy type specifies management of series balances (either of two options), then all checkboxes of the group Specify series are displayed and become unavailable for editing (i.e., when accounting for balances, indicating series in documents becomes mandatory). If the policy type specifies Automatic calculation of batch balances using FEFO, then only group checkboxes are available for editing Upon shipment.
Managing batch balances, then using the switch you can configure when the series will be indicated in the order warehouse during shipment:

■ at the time of placing an order or sale - switch When planning shipment;
■ at the moment of issuing the task to the warehouse worker - switch When planning the selection;
■ after completing the selection task - switch Upon selection.

If the policy type is set toFEFO management of batch balances, then the switch turns on. When planning selection, the switches become inaccessible, i.e. the program will offer shipment of series using the FEFO method always at the stage of issuing tasks.

If the policy type is set to Automatic calculation of batch balances using FEFO or Series reference and checkbox Upon shipment is cleared, then all switches are reset and become unavailable (with such policies the setting does not matter).

If the policy type is set to Series reference, and the checkbox Upon shipment installed then the switch turns on Upon selection and the switches become unavailable, i.e. With these settings, the program will offer batch shipment upon selection during the goods shipment process.

A list of warehouses and rules for keeping records of batches in these warehouses, for the type of item, is formed in the form Type of nomenclature. To do this in form, in a group Accounting Rules, you need to check the box Use series. The checkbox is available if in the field Item type set value Product(services cannot have series). After checking the box on the form, the page will be available Series in which the final settings for batch accounting are made.

Before creating a list of warehouses and specifying policies for batch accounting at these warehouses, you must specify in the Series identify field what the series will be: the serial number of a specific product, the batch series, or the expiration date of the batch. The following values are available in the field:

– with this setting, the series will be a unique serial number of a specific product, for example, the serial number of a specific mobile phone, or other complex household equipment;
- with this setting, the series can characterize minor differences in product characteristics that are associated with production features. For example, batches (series) of wallpaper - as a rule, different batches (series) of wallpaper differ in color shade. Also, with this setting, the series may belong to a product that is sold as a cut from rolls, logs, etc. For example, a series is a roll of linoleum, a coil of cable, etc.;
- with this setting, the series will represent the shelf life of a batch of goods, for example, the shelf life of a batch of milk;
- with this setting, the series will characterize both the shelf life of the batch and reflect minor differences in product characteristics that are associated with production features. For example, batches of paint - as a rule, different batches of paint differ in shade of color and at the same time, each supply of paint has an expiration date;

For expiration dates (if the field Series identify filled with value Lots of goods with the same expiration dates or Lots of goods with the same batch numbers and expiration dates) you can specify the accuracy of the expiration date: up to days or up to hours.

Next, for the item type, you need to generate a list of warehouses at which this or that series accounting policy will be applied. When creating the list, you should consider the following: recording serial numbers in the program is only possible for reference. That is, if a series of goods is identified Instances of goods with unique serial numbers, then only policies created for reference accounting of series can be added to the list, i.e. policies with type Series reference.

If the series is identified Lots of goods with the same serial numbers, then policies created to take into account expiration dates cannot be added to the list, i.e. policies with types Automatic calculation of batch balances using FEFO And FEFO management of batch balances.

If the warehouse does not use an order scheme when reflecting surpluses, shortages and spoilage (the corresponding checkbox in the Use of order scheme group is not selected in the warehouse card), then for such a warehouse you can only specify policies in which the checkboxes are also not selected (in the group Specify series)When recounting goods, reflecting surpluses, shortages and damage to goods And When moving between rooms. If a warehouse uses an order scheme to reflect surpluses, shortages and spoilage, then for such a warehouse you can specify any batch accounting policy.

Working with batches and expiration dates in program documents

Working in the program with batches and expiration dates is supported in the following documents:

Entering balances;
Customer order;
Application for return of goods from the client;
Return of goods from the client;
Return of goods to the supplier;
Order for reflecting surplus goods;
Warrant for reflecting shortages of goods;
Warrant for damage to goods;
An order to reflect the results of recounts of goods;
Order for movement of goods;
Selection (placement) of goods;
Reflection of the results of checking an order for goods;
Movement of goods;
Re-grading of goods;
Conversion of goods;
Receipt of goods and services;
Sales of goods and services;
Receipt order for goods;
Issue order for goods;
Assembly (disassembly) of goods;
Domestic consumption of goods;
Retail sales report;
KKM check;
KKM receipt for return;

When trading in a non-ordered warehouse, the series and expiration dates of the items are indicated in the invoices (Sales of goods and services, Receipt of goods and servicesetc.), in the case of goods turnover through an order warehouse in warehouse orders.

Depending on the type of document, series and expiration dates can be indicated in documents in two ways: only using the command in the tabular part of the document Specify series or directly in the tabular part of the document (in some of such documents you can also use the command Specify series). For example, in the documents Receipt of goods and services To indicate the batch or expiration date, you need to use the tabular command Specify series and, and in the document Order for reflecting surplus goods series or expiration dates are indicated directly in the tabular part of the document.

If information about series in a document is filled in using the command Specify series and in the document (in the header or in the tabular part) a warehouse is selected where batches and expiration dates are kept, then in the tabular part of such documents a column appears in which an icon marks those goods for which it is necessary to indicate batches or expiration dates for the selected warehouse.

If the pictogram is highlighted in red, then serial numbers or expiration dates are not indicated for the product (or not all are indicated).
If the icon is highlighted in green, then the information on the series is provided in full.

By command Specify series the form opens Registration of product series. The form must indicate batches and/or expiration dates.

Lots of goods with the same serial numbers,Lots of goods with the same expiration dates or Lots of goods with the same batch numbers and expiration dates, then in the form for each entered series you must indicate the quantity of the product.
If a rule with a policy type is set for a warehouse and item type Instances of goods with unique serial numbers, then it is not required to indicate the quantity of goods for each series, but the number of indicated series must correspond to the number of units of the product range for which these series are indicated (each unit of goods has its own serial number). For example, if in a document Receipt of goods and services there are ten units of goods, then in the form Registration of product series Ten serial numbers must be provided. At the bottom of the form Registration of product series information is displayed on the number of series that need to be registered and how many series have already been registered.

Form Registration of product series allows you to register series using a barcode scanner (in cases where information about the series is printed on the product or its packaging in the form of a barcode). In this case, you can configure the order in which product barcodes and series barcodes will be scanned. The setting is carried out in the form Registration of product series on command All actions–Set the series scanning order.

The following settings are available (selected by switch):

Product barcode – all barcodes of the series of this product – barcode of the next product – with this setting in the document, after scanning the barcode of the product and selecting it into the tabular part of the document, the series registration form will be opened in which you can scan the series barcodes the number of times that is necessary. After all series have been scanned, the series registration form must be closed manually. The read barcode, after closing the registration form, will be interpreted by the program as a product barcode;
Product barcode – barcode of the series of this product – barcode of the next product - with this setting in the document, after scanning the barcode of the product and selecting it into the tabular part of the document, a series registration form will be opened, which will be automatically closed after a single scan. The barcode read in the registration form will be interpreted as a series barcode; the read barcode, after closing the registration form, will be interpreted by the program as a product barcode;

Information about series in the tabular part of documents is indicated in the column Series. The command can be used to fill the series Specify series. You can also indicate series directly in the tabular section. The same product with different series in the document is displayed in different lines (the number of lines with such a product is equal to the number of series).

If batch accounting settings are specified for a product, then after selecting the product in the tabular part, the column Series becomes mandatory. If batch accounting settings are not specified for a product, then in the column Series the inscription is displayed Series are not indicated.

05.09.2018 2081

In the current lesson, we will consider the option of using product series in UT 11, in which the balance of goods in the context of a specific series is controlled when posting expense documents.

Series accounting policy, type of item

Let's start by creating a batch accounting policy:

In the policy type field you need to select Managing batch balances, as a result, the choice of households. operations (in which a series is filled in according to this policy) becomes unavailable - series will be indicated in all operations. But you can specify the moment of series selection - the screenshot shows the case in which series will be indicated in orders (client, for movement, for internal consumption):

When working with a specific item, the setting for using series is taken from the item type:

It is necessary to establish that the series will identify a batch of goods (to identify instances, only a reference indication of the series is used):

We will work with designer furniture, so we are not interested in the expiration date or production date. Select the created policy (common for all warehouses):

We do not find the new policy in the list that opens; the reason is described at the top of the form:

There are two ways to solve the problem:

in all warehouses, enable the use of an order scheme to reflect surpluses, shortages and damage;
use the policy only for a specific warehouse.

Let's choose the second one:

For all items of this type, serial accounting will be used only in the main warehouse.

Control of balances by batch

Let's create an item card; the series usage type is filled in automatically:

Now we create a document for the purchase of goods, we try to post without specifying the series (unsuccessfully):

Click Specify series and fill in the necessary data (it was possible to classify both sofas as one series, but I will make two series as an example). If you have already entered the series earlier, you can use the tab Choice.

In regular warehouse reports you will not see information about series; you need to look for it in a specialized report:

Now let's try to sell sofas; to do this, first create a customer order:

Despite the empty series, the document is processed successfully. The thing is that the security option is not specified Ship- in this case we will immediately have an error when carrying out:

We fill out the series according to the available balances:

If in your case there are a lot of lines, it is convenient to select all the lines of the list ( Ctrl+A), and then click on Distribute:

The series in the order have been filled, we carry it out:

On the basis of creating sales of goods and services, the series was filled in according to the order:

We navigate and close the document.

Let's look at the series statement again:

Don't let the meaning confuse you not carried out in a collumn Remainder- here we are talking about the fact that there is no accounting of the balances of goods from buyers in the context of series, but the accounting of balances by series in warehouses is maintained.

Control of operational balances in the warehouse card must be enabled:

Comments (5)

Dmitry 2018-12-19 22:09:53

To set the accounting policy for series of this type, where the balance of the series is controlled, in the “Warehouse and delivery” section the “Order warehouses” setting must be set, and also, for the warehouse, you need to set the setting for using the order scheme when reflecting surpluses, shortages, re-grading and spoilage Answer

Dmitry 2018-12-19 22:12:21

This is when setting an individual policy for a warehouse Answer

Dmitry Medvedkov 2018-12-19 23:03:27

Dmitry, I don’t quite understand - do you disagree with something? Did I make a mistake somewhere? In my opinion, the article pays attention to what you write about Answer

Elena 2019-05-29 19:11:52

I can’t understand why there is such a requirement that there should be an order warehouse? Yes, we want to control series for all warehouses, not only for the main one, but we don’t want to use orders. what is the need? Answer

Dmitry Medvedkov 2019-05-29 19:49:53

The screenshots above show that this is a design limitation of the system. Why exactly it was introduced is a better question to ask the developers. I think the point here is that the inclusion of accounting for product balances by series significantly complicates commodity accounting and necessitates the use of an additional circuit of order accounting documents. Answer

Payment details Cost, licensing, use by multiple users Product cost - 0 rubles. The number of jobs is unlimited. No additional licensing required.

What are the payment options? How to add a product to the database?

You can implement the product yourself by viewing the instructions. If you have any difficulty with this, I can help. Contact me and we will set up a specific time for communication.

If the development does not start (or works incorrectly) In this case, first of all, check the instructions to see if you connected the development correctly. If the check did not yield anything, make a screenshot of the error and send it to me by mail indicating the name of the development. At your choice, I can either correct the error and send you a new version of the file, or return the money.
If the development breaks after the update, you will need to contact me, tell me the number of the new release of your configuration and the name of the development you purchased. After that, I will send an adapted version of the file by mail.

Is it possible to improve the development on my own?

Yes, you can. The source code is open and available for any modification, there are no restrictions.

Are there changes to the configuration?

No, the implementation of the development does not change the database configuration in any way and will not affect subsequent updates.

Is there a demo version?
No, I cannot provide demo access to development.

In the payment note, be sure to indicate product ID 592 and your email address, where I will then send a link to download the development.