Working with 1C programs, users constantly create documents to reflect various operations with goods: purchase, sale, movement, inventory, etc. In all documents, the user must specify a list of goods. When the assortment of the company's nomenclature is large enough, filling out the documents can take a lot of time.

In the program "1C: Trade Management, ed. 10.3" in all documents, a mechanism for selecting goods is implemented, which allows you to fill out documents quickly and conveniently. Let's consider the operation of this mechanism on the example of the document "Buyer's Order".

Menu: Documents - Sales - Customer Orders

Let's create a document, specify the organization, warehouse and counterparty in it:

Next, you need to fill in a list of ordered goods, their quantities and prices. You can add new rows to the table, select items in them and specify the quantity, but this option is quite complicated.

Click on the "Selection" button to open the selection window:

The selection window looks like this:

The selection window consists of several parts.

At the top, you can select the selection method, specify the item group and search for the item.

Below is a list of all item groups from the directory:

You can place the cursor on the group of goods you need, and the selection window below will display the goods from the selected group.

Under the groups is the list of products and some additional settings.

When working with the selection, you can choose one of the options:

1. According to the handbook. All products from the catalog are displayed, regardless of whether they are in stock.
2. According to the rest of the nomenclature. Only those products that have a balance in stock are displayed. The product list displays additional columns with total stock and free stock.

1. At item prices. Only those products for which sales prices are indicated are displayed. The list of products shows an additional column with the price.

1. According to the balances and prices of the nomenclature. This option combines the options "according to stock balances" and "according to stock prices".

Let's set the selection according to the rest of the nomenclature. You can use the search box at the top to find what you're looking for. Product search is possible by name, article, code and barcode.

Select the option to search by article and specify the required article. The program will find the product with the given article and position it in the list of products:

To add the found product to the buyer's order, you just need to double-click on it. In this case, the program will add a line with the desired product to the order, indicate the quantity - 1 pc. and set the price (if it is set in the database).

Double-clicking on a product again will cause the quantity in the line to increase to 2 pcs. Those. if the product is already present in the order, it is not added again, and the quantity of the product in the order is increased.

At the time of adding the product to the order, you can specify the required quantity and price. To do this, set the flags "Request Quantity" and "Request Price" below:

In this case, double-clicking on a product will open a special window for entering quantity and price:

Buyer order after adding fan:

If a product is accounted for by characteristics, then you can also set the "Request a characteristic" flag in the same place. With this setting, when you double-click on a product, the program will open a window for entering the quantity and price for each product characteristic:

In the Quantity field, specify the quantity of goods with this characteristic that you want to add to the order. And in the price field - the price of a product with this characteristic.

Buyer's order after adding women's sandals:

Thus, you can use the selection, search for the necessary goods and quickly add them to documents, specifying the quantity and price. You can open the selection window in any document that contains a list of products. All settings made in the selection are saved in the program (separately for each user and type of document).

Find directory entry in 1C 8 possible in three ways:

1) Search by code

If known code directory element, and you need to get a link to it, you can use the method FindByCode(<Код>, <ПоискПоПолномуКоду>, <Родитель>, <Владелец>) code catalog element and as a result either a reference to the catalog element or a null link will be obtained if an element with such a code is not found. It should be noted that if there are several elements with the specified code in the directory, then the one that was found first will be returned.

FoundItem = Directories.Nomenclature.FindByCode("00000011254" );

Description of method parameters FindByCode:

• <Код>(required). Type: Number, String. Description: searched code, string or number, depending on the lookup settings in the configurator.
• <ПоискПоПолномуКоду>(optional). Type: Boolean. Description: defines the full code search mode, true — the searched code should be specified as a string consisting of a sequence of codes by directory levels, separated by the “/” symbol. Default value: False.
• <Родитель>(optional)
• <Владелец>(optional)

2) Search by name

If known Name directory element and you need to get a link to it, you can use the method FindByName(<Наименование>, <ТочноеСоответствие>, <Родитель>, <Владелец>) directory manager. In the simplest case, you need to pass to this method Name directory element and as a result either a reference to the directory element or a null reference will be obtained if an element with the same name is not found. It should be noted that if there are several elements with the specified name in the directory, the one that is found first will be returned.

FoundItem = Directories.Nomenclature.FindByName( "welding machine");

Description of method parameters FindByName:

• <Наименование>(required). Type: String. Description: A string containing the search name.
• Exact Match> (optional). Type: Boolean. Description: defines the full match search mode, the search will be successful if the search string: in the case of the parameter value Lie— will match the left part of the name, in case of parameter value True— will completely match the name (with the exception of “tail” spaces in the name). Default value: False.
• <Родитель>(optional). Type: DirectoryLink. Description: the parent within which to search, if not specified, then the search will be carried out in the entire directory.
• <Владелец>(optional). Type: DirectoryLink. Description: the owner within which you want to search, if not specified, then the search will be carried out in the entire directory.

3) Search by arbitrary attribute

If the value of any props directory and you need to get a link to it, you can use the method FindByAttributes(<ИмяРеквизита>, <ЗначениеРеквизита>, <Родитель>, <Владелец>) directory manager. In the simplest case, it is necessary to pass to this method the name of the attribute, its value, and as a result either a link to the dictionary element or a null link will be obtained if an element with such a value of the specified attribute is not found. It should be noted that if there are several elements in the directory with the same value of the specified attribute, then the one that was found first will be returned.

FoundItem = Directories.Nomenclature.FindBy Props("Article" ,"A-255" );

Description of method parameters FindByProps:

• <ИмяРеквизита>(required). Type: String. Description: name of the attribute, as it is specified in the configurator, by the value of which the search is performed. Value type: arbitrary, except for ValueStorage and strings of arbitrary length.
• <ЗначениеРеквизита>(required). Type: Custom. Description: value of the attribute to search for.
• <Родитель>(optional). Type: DirectoryLink. Description: the parent within which to search, if not specified, then the search will be carried out in the entire directory.
• <Владелец>(optional). Type: DirectoryLink. Description: the owner within which you want to search, if not specified, then the search will be carried out in the entire directory.

In this article I will tell you about the quick search function 1C Enterprise 8. What is a quick search? Very simple. Quick search is one of the ways to navigate in large lists of 1C records. These can be lists of documents, directories, registers - everything that is represented by tables.

What is a quick search?

The quick search function in 1C Enterprise documents is extremely convenient and allows you not to scroll through huge arrays of data (for example, using the scroll bar), but to immediately jump to the desired place in the list. Unfortunately, novice users of 1C Enterprise 8 (including 1C Accounting 8) at first do not use the quick search capabilities, preferring to scroll through the lists of documents manually (and they can be Very large). This article will help you figure out how to use a quick search in 1C.

First of all, it should be noted that in 1C Enterprise 8 configurations built on managed forms, quick search works differently than in previous versions of 1C. Therefore, we will analyze separately the use of quick search in managed forms and in ordinary ones.

Quick search in 1C Accounting 8.2

In versions of 1C Accounting from 8.0 to 8.2 function is intended for transition to the desired part of the list. For an example, look at the chart of accounts window shown in the figure.

A line is selected in the window. Note the subtle triangle of stripes pointed to by the red arrow. As in other Windows programs where there are lists (for example, in Explorer), the position of this marker (triangle) determines the sorting of the list as a whole − in which column the marker is set, the entire list will be sorted by that column. In the figure, the marker is in the Code column, so the accounts in the chart of accounts will be sorted by code.

The marker can be moved from one column to another by clicking on the desired column ( on the HEADING column!) with the mouse. If the marker is already in the current column, then clicking will reverse the sort direction (i.e. from larger to smaller or vice versa). This is standard behavior for any Windows program. What is the peculiarity of this marker in 1C Enterprise and how is it related to quick search?

A quick search in the 1C Enterprise 8 lists is carried out according to the column in which the marker is located. In this case, a quick search in the chart of accounts will be carried out in the Code column.

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

How to use quick search in 1C? Easily! Just start typing what you want to find in THIS column, i.e. where the marker is. In the example in the figure above, you must enter the account number. For example, you want to find account 50 Kassa . In this case, enter ( You don't need to click anywhere!) the number 50 from the keyboard, and if there is an account with this number in this column (and, of course, there is one), then the list will scroll to this line, and the line itself will be highlighted. The result is shown in the chart of accounts screenshot below.

The text that the arrow points to no need to wash afterwards- he will disappear.

If, in the above example, you start typing the word "Cashier", then the text at the bottom of the window will be entered and then erased. This happens because as soon as Start of the entered quick search line no longer matches the beginning of at least one line in this column, 1C Enterprise concludes that the searched line was not found and automatically erases it. Due to this two rules to remember.

In 1C Enterprise 8, a quick search is performed at the beginning of the line, i.e. in the column, the match of the input text with the beginning of one of the lines of this column is searched.
This leads to an important recommendation: when entering data into directories, name the elements so that it is convenient to search for them using a quick search. For example, it is better to write the name of the counterparty as "Company Name LLC" than "Company Name LLC". And even more so, you should not use quotation marks and other unnecessary characters in the name (we are talking about filling in the Name field in the forms).

If you start typing text and it is erased, what you are looking for is not in this column! In this case, check the input language, as well as the column in which the quick search is performed. Common Mistake- Wrong column selected. For example, the marker is set in the Code column, and the search is performed by the account name.

Quick search in 1C Accounting 8.3

Now let's see how quick search differs in version 1C Enterprise 8.3. Usage is very similar to version 8.2, but there is one major difference to remember.

In 1C Accounting 8.3, as well as in any other configurations on managed forms (the same new interface), it works as a filter. Simply put, as a result of the quick search function, part of the list hiding.

How to use it, we will now find out. To get started, look at the screenshot of the chart of accounts window 1C Accounting 8.3 below.

As you can see, the same marker is in one of the columns. The search is also performed by the column in which the marker is set. This has all remained unchanged. However, if you start typing text (in the example, the account number), the following will happen.

As you can see, the search box just automatically opened. The exact same window will open if you click on the search button on the window toolbar (underlined in the figure). As a result, when you click the Find button in the search window (hidden behind the drop-down menu in the picture) or simply Enter, you will get the following result.

From here it is clear that a quick search in 1C Accounting 8.3 simply leaves the part of the list that meets the search conditions visible. In this case, the Find button disappears, and instead a lens with a cross appears (underlined in the figure), when pressed, the list returns to its original state (the line found as a result of a quick search remains highlighted).

Another one important feature quick search in 1C Accounting 8.3- a match is not searched at the beginning of the line, as in version 8.2, but a search is made for a match with any part of the lines in the column. Thus, if the counterparty is called "Company Name LLC", and when searching, start entering "Company Name LLC", then the line will still be found!

Drawing conclusions

Thus, a quick search in 1C Accounting 8.2 and earlier versions is intended to scroll the list to the desired line, and in 1C Accounting 8.3 a quick search works like a regular filter, hiding the part of the list that you do not need.

The nomenclature in 1C 8.3 means materials, semi-finished products, equipment, services, returnable packaging, overalls, etc. All this data is stored in the "Nomenclature" directory. You can get into it from the section "Reference books", subsection "Goods and services", item "Nomenclature"

You will see a list of directory positions that has a multi-level hierarchical structure.

In this article, we will step by step consider all the instructions for the initial filling of the nomenclature in 1C 8.3 using the example

For the convenience of using this guide, 1C Accounting uses groups (folders). They combine a nomenclature that has common features. In each group, in turn, it is possible to create subgroups (similar to the file system on a computer). The number of hierarchy levels is set by the programmer, but initially there are no restrictions.

Let's create new group. In the list form of the "Nomenclature" reference book, click on the "Create group" button.

Specify the name of the group to be created. You can also fill in its form, but it is not necessary.

As you can see in the figure below, the group we created fit into the "Materials". If it needs to be moved to another group or to the root, open the context menu and select "Move to group". A window will open where you will need to specify a new location.

Creating a new stock item

Let's move on to adding the nomenclature itself. To do this, in the form of a directory list, click on the "Create" button. A card of the new nomenclature will open in front of you.

Fill in the "Name" field. The value in the "Full name" field will be filled in automatically. Please note that the full name is displayed in reports, printing forms documents, price tags, etc. The "Name" field is used for easy search of items in the program.

Fill in the rest of the details if necessary:

• The fields "Type of item" and "Included in the group" are filled in automatically from the data of the group in which the new item is created. You can change them if necessary.
• The value in the "Unit" field is the storage unit for the rest of this item.
• The tax rate specified in the requisite “% VAT”, if necessary, can be changed already during the formation of documents.
• "Sales price" is specified by default in sales documents. This setting can be changed by clicking on the hyperlink "?" next to this field.
• In the "Production" section, you can specify the cost item of this nomenclature item, and its specification (for finished products), in other words, the composition.
• Depending on the characteristics of the nomenclature, other sections are filled in, such as "Alcoholic products" and "Imported goods".

After you have filled out the card of the item being created, you need to write it down.

What is the type of item in 1C 8.3 and how to set them up

In order to set up types of nomenclature, click on the corresponding hyperlink in the list form of the "Nomenclature" reference book.

Item types are needed to separate item positions. Each type can have its own . It is very important to avoid the presence of duplicates in this reference book, which can lead to incorrect operation of item accounting accounts.

When installing a typical configuration from a supplier, this directory will already be filled with the main types of stock items. If the item type is a service, do not forget to set the appropriate flag when creating it.

Item accounting accounts in 1C 8.3

To generate accounting entries, you need to set up accounting accounts. This can be done from the list form of the reference book "Nomenclature" by clicking on the hyperlink "Nomenclature accounting accounts".

In the standard configuration of 1C Accounting 3.0, this register is already filled out. But if necessary, it can be adjusted manually.

Accounts can be configured:

• for a specific nomenclature position;
• by nomenclature group;
• by type of nomenclature;
• by warehouse;
• by type of warehouse;
• by organization;
• throughout the nomenclature, specifying an empty reference as a value.

If different accounting accounts have been set up for a specific item and for it, then the account will be taken from the item. In such cases, aggregated accounts have a lower priority.

Setting item prices

One item can have multiple prices. They differ in types, for example, wholesale price, retail price, etc.

Go to the item card of the "Nomenclature" reference book and follow the "Prices" hyperlink.

A list will open in front of you, in which it is possible for a specific type on a specific date. It is enough to indicate the price in the appropriate column, and then click on the "Record prices" button. The item price setting document will be created automatically, and you will see a link to it in this list.

See also the video about the nomenclature:

With the help of the 1C program, a complete analysis is performed on the workload of the warehouse for a specific period, with its help it is possible to determine and prevent peak days of demand or shortage of commodity items. This information is used by purchasing departments, sales departments, warehouse workers and accountants. Before you can see the movement of goods in 1C, you need to check the analytics. The information will be reliable in the context of any position of the warehouse only if the data is entered into the "1C: Enterprise 8.3" program in the "1C: Trade Management edition 11.0" configuration of the "Taxi" interface in a timely manner.

General overview of working with a warehouse

Working with a warehouse involves registration of receipt, sale, movement between warehouses, as well as reporting on the movement of stock for 1C and inventory. In addition, the inventory of all warehouses and registration of its results.

Admission

The receipt of the item in 1C 8 should be performed from the "Purchases" menu, the "Purchase documents (all)" tab. To do this, you need to "Create" a new document with the appropriate button.

• The receipt of goods and services from third-party suppliers;
• Receipt of commodity items through an accountable person;
• Other receipts, including gratuitous ones;
• Correct documents if necessary;
• Return of items or materials;
• All work with invoices.

In any of the created documents, you must fill in the "Basic" tab with the parameters of the supplier, the contract, and select the warehouse. The "Products" tab is designed to select specific items.

Before adding a product to 1C, you should check the availability of this item in the directory. Double cards will make it difficult to work with the nomenclature later, and regrading may also occur.

To enter a card, you need to create a new nomenclature item in the "Goods" tab with the "Create" button. All information from the card will then be used in the formation of documents for transfer and sale, as well as the creation of reports, therefore, all cells must be filled in reliably.

Analytic data in the cell "Group financial accounting» allow you to select an enlarged nomenclature group: finished products, goods, accounting of materials in 1C, overalls, intangible assets. According to the selected position, the corresponding postings in accounting will be formed.

In the case of a charitable or gratuitous transfer of goods, postings in 1C are formed when the appropriate tab "Write off for expenses" is selected. This will affect financial result.

After filling in all the data on admission, you can print the document. Depending on the nature of the income, an appropriate income report is selected. The button "Post and close" will complete the posting of goods in 1C, after which all information is reflected in the accounts accounting and in reporting forms

Implementation

The sale of goods can be processed in the "Sales" menu in the "Sales documents (all)" field. The format of the document is similar to the receipt. The "Basic" tab is intended for registration general information about the deal.

• You must select a client from the directory;
• the field "Agreement on the conditions of sale" is mandatory;
• specify the type of operation;
• select warehouse.

The remaining fields will be filled in automatically from the previously entered data in the directories.

Perform selection a large assortment goods for UT 11 is more convenient through the "Fill" tab with the "Selection of goods" button. After selecting specific commodity items, you should transfer them to the delivery note using the "Transfer to document" button.

After filling in all the tabs and fields, you can print the document. Depending on the type of implementation, the program provides the following printables.

• Sales Invoice;
• the act of providing services;
• invoice;
• bill of lading and bill of lading.

The document will be included in the report only after the form is posted and closed.

Goods movement report

After you have credited the goods in 1C, you can generate reports on the movement of the item. To do this, from the "Warehouse and delivery" menu, go to the "Warehouse reports" tab. Clicking the button opens all available warehouse reports.

List of goods in warehouses

The general movement of goods in the warehouse can be viewed from the first menu "Statement of goods in warehouses".

The report is generated for the organization as a whole. If necessary, you can perform its formation for a specific warehouse. If you check the box "Detailed to", under each position, information about primary documents will be presented. They can be opened by double-clicking the left mouse button.

Inventory turnover in warehouses

The program provides a report on the turnover in 1C "Inventory turnover in warehouses". Its necessity can be estimated in large shopping malls or logistic bases, as well as in the presence of several retail outlets. It is formed on the basis of data on the movement of commodity groups with an analysis for a certain period and the output of the average daily balance.

Using the data of the report on the turnover of goods, you can plan the supply of product groups in a specific period, analyze the seasonality of sales, and quickly respond to market changes in relation to certain positions. If necessary, you can make a selection for the organization as a whole or for a specific warehouse.

If necessary, you can customize the analysis of information in more detail. To do this, in the "Settings" tab, select analytics in quantitative or sum terms, configure the selection by commodity group, retail or wholesale price.

Conclusion

The movement of the nomenclature in 1C can be performed in more detail. If necessary, the filling of the address warehouse with goods, the movement of batches of certain nomenclature items is analyzed. Software complex a daily commodity calendar is provided, which reflects current balances and planned receipts. For product groups, it is possible to keep records based on their expiration dates.