Within the “Inventory Management” interface, you can find out the balances in warehouses, as well as receipts and expenses for a certain period, as follows: select the “Warehouse” tab in the top panel, then “Goods in warehouses” in the drop-down menu. Exactly the same version of the report in the “Purchasing Management” interface, “Inventory” tab - “Goods in warehouses”. Then you need to click the “Settings” button and specify the period. To get balances at the beginning of the year in 1C, you need to enter the date first of January in the date cell.

The shape of the table will depend on the Row Grouping options. If you select the word “hierarchy” in the “Nomenclature” line, the positions will be arranged in order: for example, first sheets, then pipes, then hardware, etc. To get a general report on balances in 1C, you should select the word “hierarchy only” - only amounts will be shown without decryption. Grouping by warehouses is done in the same way.

To obtain information only on specific warehouses or groups of inventory items, you should pay attention to “Selections”. If you select “In the list” as the comparison type, then in the “Values” column you can specify the required warehouses and item groups.

The table that the program displays within the “Goods in warehouses” contains data only on the quantity of materials. If you need to get information on costs and prices, you need to switch the interface to “accounting and tax accounting”. Here select the “Accounting” tab, “Turnover balance sheet” and in the settings specify account 10. The period, grouping parameters (details), and selections are selected in the same way. This 1C report on balances looks different; it indicates the total cost of inventory items and quantity.

Another way to view balances in 1C is to turn to ready-made program templates. They are available in any interface; to find them, you need to select the “Service”, “Additional reports and processing”, or “Custom reports” tab. There are also templates created specifically for specific tasks by the enterprise IT service or 1C specialists. For example, sometimes a report indicating the date of the last receipt of goods and materials or the warehouse number is useful.

Video on the topic

When starting to maintain accounting using the 1C: Enterprise software, you must complete the initial settings of the application and enter account balances. In this case, the working chart of accounts adopted by the accounting policy of the enterprise is compared with the chart of accounts used by 1C, after which data is entered through auxiliary account 00.

Instructions

Determine the start date for computer accounting. This may be the beginning of a month, quarter or reporting year, depending on the adopted accounting policy of the enterprise. Set a working date, i.e. date of entry of balances. It must be earlier than the accounting start date. For example, the last day of the previous reporting period.

Set the accounting results period. To do this, go to the “Tools” menu, the “Options” section and select the “Accounting results” tab. The period must be selected relative to the date of entry of account balances so that they are analyzed either at the end of the period or at the beginning. Perform a full recalculation by selecting the “Manage Accounting Totals” section in the “Operations” menu.

Enter your account balances. Postings on analytical accounting objects and balance sheet accounts, as well as sub-accounts must be entered in correspondence with account 00 “Auxiliary”, and balances on off-balance sheet accounts are reflected in a simple entry indicating one account. Be careful when defining accounts in the 1C: Enterprise program, as they are slightly different in numbering from accounting accounts.

Check that account balances have been entered correctly using a standard report. To do this, go to the “Reports” menu and select “Turnover balance sheet”. You can also click the corresponding button on the toolbar. Balances have been entered correctly if the debit amount equals the credit amount. If a non-zero balance was formed in the reporting on account 00, then errors were made during entry.

These need to be corrected by running the Drill Down command, which reveals detailed information about the report parameters. To edit, click the “Open Document” button, make corrections, then close all windows except the desired report, and double-click the “Refresh” button.

Video on the topic

Before entering incoming and outgoing invoices into the database, you need to reflect in your accounting the balances in the warehouse at the beginning of its maintenance. Inventory balances must be entered on the date preceding the beginning of the period. The most convenient way for accountants to keep track of goods is in the “1C: Trade + Warehouse” program, the configuration of which allows you to fill out the “Inventory of Inventory and Materials” table using the “Remaining Inventory and Materials” report.

Instructions

Start setting up the “Inventory balances” report and call processing of the “Inventory of inventories” tabular part from the dialog. This can be done in any of two ways: using the “Inventory” button or the “Fill” button in the “Inventory of Inventory and Materials” document, selecting the “Fill from report” tab in the menu. After this, you need to fill out the table from the inventory document, which contains the “Inventory balances” report for the group of goods you need.

Select the warehouse where , and indicate a specific group of goods for which balances are checked. Keep in mind that you can select products based on their properties. In addition, using a multiple filter, it is possible to create a custom list of products.

In the “Remainings” filter, set the “All non-zero” option in the “Including reserve” attribute. This is done so that the inventory takes into account real balances and not reserved goods. Use the convenient switch in the “Prices” tab - “Average cost excluding VAT”. This will make your task easier. However, if the inventory is carried out in a retail warehouse, the position should be set as “Selling price (only)”, because in such a warehouse it is carried out at the same retail prices at which the goods are recorded in the retail warehouse.

Click the "Inventory" button when you have completed all the required settings. The “Inventory of Inventory and Materials” document you need will be automatically generated. If you have selected a wholesale warehouse, the generated document will be set to the “Inventory (by warehouse)” type. If you specified a retail warehouse, then the type will be indicated “Inventory (by )”. The table in the document will contain the balances of goods in accordance with the settings that you set in the “Inventory balances” report.

Enter into “Inventory” all the actual data on the goods in the warehouse. Next, fill out the documents “Write-off of goods and materials” or “Capitalization of goods and materials”, depending on whether you need to reflect the shortage or enter a surplus of goods.

Video on the topic

Sources:

• remaining stock in 2019

1C today is a popular program in an enterprise, commercial organization or company. This is a comprehensive, convenient solution for organizing personnel, financial, accounting and material records. “1C: Trade Management” makes it possible to control and record absolutely all purchase and sale transactions in an enterprise. However, not all accountants initially know how to transfer balances to 1C at the beginning of the year.

You will need

• - PC;
• - “1C: Trade Management”.

Instructions

Purchase and install the “1C: Trade Management” program and enter all your data into it. If “1C: Trade Management” is already available and in use, just launch it on your computer. To do this, just click on the corresponding shortcut on the desktop.

Open the desired database in “1C: Trade Management”. Go to the “Documents” menu to enter balances. Then go to “Sales” by selecting the appropriate tab. Select the "Debt Adjustment" option.

In addition to the above method, you can open a document to enter balances using the following transition: “Documents” - item “Purchases” - “Debt adjustment”.

Look at the document log that appears in front of you. Click on the “Add” button in the window and wait until a new document is created. Select the counterparty you need in the “Counterparty” field.

Enter the required number of contracts in the tabular part of the document, as well as the currency and debt amount in the corresponding field. Click on the “Add” button. Such actions will allow you to add this row to your tabular section.

Find the column “Increase in debt” and enter in it the amount of the counterparty’s debt to the company. Click the "OK" button and enter the product balances as of the beginning of the year. To do this, set the working date in 1C before starting to enter balances for the last month that precedes the start of the accounting period. In our case it is December.

Select “Tools” – “Options” from the menu. Enter the desired date and save the information by clicking “OK”.

Create a “Goods Receipt” document to enter all remaining goods in warehouses. To do this, you must perform the following steps.

Go to the "Documents" menu, select "Inventory (warehouse)". Go to the item “Positioning of goods”. Click the Add button.

Select the “Base” field and enter “Enter initial balances”, then the “Prices and currency” item and in it select the “Purchase” price type. Click on the “Selection” button and check the boxes next to the “Quantity”, “Price”, “Characteristics” fields.

Select the required element and specify the parameters. Add all products. Exit the item window by clicking the “OK” button.

Video on the topic

Sources:

• rent 1C

Before entering expense and receipt invoices into the database, it is necessary to reflect the current balances in the warehouse in accounting. Inventory balances are entered on the date that precedes the start date of the period.

Instructions

Run the report in the 1C: Trade + Warehouse program, called “Inventory balances”. Having started its construction, you will use dialog boxes to call up the processing of the “Inventory of goods and materials” table. You can do this in two ways: by clicking on the “Inventory” button or using the “Fill” button in the document called “Inventory of Inventory”. Select the Fill from Report tab from the menu. Next, fill out the tabular part of the inventory document containing a report called “Inventory balances” for your product group.

Determine the warehouse where the inventory is carried out. In addition, you should indicate the group of goods you need for which you will create balances. Please note that you can select products by their properties, and by using a multiple filter, you can create a list of products at random.

Set the value “All non-zero” in the “Remainings” filter, which is located in the characteristic called “Including reserve”. Then the inventory will take into account all real balances, excluding reserved goods. For your convenience, you can use a special switch, which is located in the “Prices” tab and is called “Average cost without VAT”. This will make it easier for you to complete the task at hand. Keep in mind that if the goods are being inventoried in a retail warehouse, you need to set the position “Sales price (only

To display account balances in 1C, you need to create a balance sheet and select the necessary settings. This is the period for which you need to show the turnover, account or subaccount number, and detail parameters. In the “selection” you can specify warehouses, product groups or other limiting factors. For example, to generate balances for account 10 “Materials”, in this tab you should select the required warehouses “in the list” or one desired warehouse “equals”.

Sometimes it is convenient to display only general data on an account in 1C; in this case, in the settings you need to select “Hierarchy” or “Hierarchy only”. In the first case, materials grouped by item groups “Black sheet”, “Stainless sheet”, “Circles”, etc. will be displayed, and in the second - only the total amounts for these groups. When transferring the table to Excel or a similar program, it is important to take into account that the sums for the elements add up to the sums for the subgroups, and they are all indicated in one column - therefore, when setting the “Total Amount” formula, the program will simply double the total amount.

The “Purchasing Management” or “Inventory Management” interfaces also allow you to display account balances, but only the quantity will be indicated in the table (the “Goods in Warehouses” report). If you create the actual purchases for a certain period, the number of 10 materials received to the account will be displayed, indicating the price. It is important that here the cost will include VAT, while in the turnover account 10 the total cost is indicated without VAT.

It is convenient to use the “Quick Selection” functions to find the positions you need. For example, by selecting the desired department or warehouse, you can quickly display all balances for a certain period. If you need to find out about the availability of certain items in the warehouse or the movement of certain items, you need to make a selection in the “Nomenclature” cell. To do this, set the parameter “in the list” or “equal to”, then click “…” in the selection field. Here, select the material, sequentially “traveling” through the menu, or write in the “contains” field known information - steel grade, standard size, marking, etc. For the list to be formed, you must click the “hierarchical viewing” button at the top of the window. Having selected the desired element, generate a report on it - balances at the beginning and end of the period, movement.

In accordance with the methodology for accounting for inventory balances of alcoholic beverages, all receipts of alcoholic beverages in the Unified State Automated Information System (EGAIS) system are accounted for in the accounting register for inventory balances No. 1. In turn, all goods intended for retail sale must be moved to the inventory register No. 2 in the EGAIS system.

This can be done using the documents ( Stock –EGAIS). Document Transfer to the EGAIS trading floor can also be issued based on other configuration documents: Receipt of goods, Movement of goods, .

Possible sequence of user actions in the configuration:

• If the goods are delivered directly to the sales floor (to a warehouse with the “Trading floor” type), then based on the document Receipt of goods(after completion of the data exchange cycle with EGAIS upon receipt) The user draws up a document Transfer to the EGAIS trading floor and sends it to EGAIS. Thus, in the EGAIS system, warehouse balances on register No. 1 of goods in the warehouse decrease, and on register No. 2 they increase.
• If in a store the premises of the receiving warehouse and the sales floor are separated by accounting, then on the basis of the document Receipt of goods The user can issue Internal movement of goods. In this case, the balance of goods on the sales floor will change only according to the configuration data. In the EGAIS system, these goods are still listed in the inventory register No. 1. In order for such goods to be moved to the inventory register of goods balances No. 2 in the Unified State Automated Information System (EGAIS) system, it is necessary to do so on the basis of the document Internal movement of goods create a document Transfer to the EGAIS trading floor. Transfer to the sales floor should be completed after the completion of the data exchange cycle with EGAIS upon receipt, i.e. after EGAIS confirmed that the TTN was successfully accepted and confirmed.

In the created document, certificates 2 are filled in based on information about the receipt of alcoholic beverages. After posting the document, you must use the command Send to EGAIS. At the same time, in the EGAIS system, warehouse balances on register No. 1 of goods in the warehouse decrease, and on register No. 2 they increase, but they are stored without cutting certificates 2.

Returns from the sales floor to the warehouse, for example, to process a return to a supplier or return transfer to a distribution center, are processed using a document Return from the EGAIS trading floor (Stock – EGAIS). The document can also be drawn up based on other configuration documents: Movement of goods, Internal movement of goods. Returns from the sales floor can be processed only after the goods have been registered in accounting register No. 2 in the Unified State Automated Information System.

For each product line, the user must indicate certificate 2, according to which the goods were written off to the sales floor. After posting the document, you must use the command Send to EGAIS. At the same time, in the EGAIS system, warehouse balances on register No. 2 of goods in the sales area decrease, and on register No. 1 of goods in the warehouse increase.

The program also supports requesting balances for each register using the document Remains of EGAIS (Stock – EGAIS).

When creating a document, you must select Shop, Organization and the register in which the request is generated Request for stock balances or Request for balances on the trading floor. Post the document and send a request to EGAIS. It should be taken into account that requests for balances have a low execution priority, and balances are formed for all goods at the time the request is executed in the EGAIS IS.

Therefore, the document will reflect the balances of all warehouse goods in the context of references 2 or in the sales area, but already grouped by goods.

If the User is just starting to keep records in the configuration, then he can request the remains of alcoholic beverages in the Unified State Automated Information System with a document Remains of EGAIS and based on it create a document Posting of goods(if necessary, adjusting the tabular part of the document) to reflect the initial balances.

In the clarification of the FSRAR dated 06/02/2016(http://egais.ru/news/view?id=1472) Regarding maintaining balances on the Unified State Automated Information System accounting registers it is said:

In addition to previously posted information on the methodology for maintaining balances by retail trade organizations of alcoholic beverages(http://egais.ru/news/view?id=1456), Rosalkogolregulirovanie reports the following.
For retail sales of labeled alcoholic products:
From 01.07.2016:
✓ if there is a positive balance of products in register No. 2, the sold products will be automatically written off in register No. 2;
✓ in the absence of a positive balance of products in register No. 2, the sold products will not change the current balances of the organization (“the balance will not go into the minus”);

From 10/01/2016.
✓ regardless of the presence of a balance of products in register No. 2, the sold products will reduce the current balances of the organization;
✓ if there is no positive balance of products in register No. 2, the system will automatically “remove balances to minus”);
✓ closing of negative balances will be carried out automatically if the organization transfers the corresponding amount of products to the balances of register No. 2;
✓ data on current balances will not be used in control activities.
From 01/01/2017.
✓ Rosalkogolregulirovanie plans to start using data on current balances in control activities.

Adjustment of EGAIS balances

Important! In accordance with the methodology for recording inventory balances of alcoholic beverages, retail trade organizations no later than 10/01/2016 must record in the Unified State Automated Information System (EGAI) the remaining balances of alcoholic products received before 01/01/16 and not sold until 10/01/2016.
The balances of alcoholic products in the EGAIS system must be completely brought into line with actual wholesale and retail trade organizations by 01/01/2017, FSRAR reminds of this in a message dated 07/19/2016.(http://egais.ru/news/view?id=1478).

In order to reconcile and adjust balances on EGAIS registers, an inventory assistant has been developed in the configuration Adjustment of EGAIS balances(chapter Stock – EGAIS).
The assistant allows you to generate documents that change the balances of alcoholic beverages in the EGAIS system on register No. 1 of goods in the warehouse and on register No. 2. The assistant analyzes the accounting balances of alcoholic products (balances according to configuration data and balances according to EGAIS data) and prompts the user to adjust balances in the EGAIS system. Depending on the situation, the following documents can be automatically generated:

• Certificate of registration on the balance sheet of the Unified State Automated Information System;
• Transfer to the EGAIS trading floor;
• Statement of write-off of the Unified State Automated Information System;
• Return from the EGAIS trading floor.

Before adjusting balances, it is necessary to conduct a complete inventory of alcoholic products.

• Conduct a complete inventory of alcoholic beverages and make sure that, based on the results of the recount of goods, all necessary documents for the movement of goods have been drawn up (Write-off of goods, Capitalization of goods, Order to reflect the results of recount of goods).
• Check that for all operations of the movement of alcoholic products for which recording in the Unified State Automated Information System is provided, the data was transmitted and responses were received from the Unified State Automated Information System.
• Request balances in EGAIS in register No. 1 and register No. 2.
• If necessary, compare the nomenclature and counterparties with alcoholic products and EGAIS organizations, respectively.
• Check which documents for adjusting balances the assistant proposes to draw up and generate them (Act of statement on the EGAIS balance sheet, Transfer to the EGAIS trading floor, EGAIS write-off act, Return from the EGAIS trading floor).
• Post the documents generated by the assistant Correction of EGAIS balances and send them to EGAIS.

Important! From October 1, 2016, quantitative restrictions will be introduced in relation to electronic documents for placing products on the balance sheet, which will not allow large volumes of products purchased before the introduction of the Unified State Automated Information System to be placed on the balance sheet.(http://egais.ru/news/view?id=1478). In addition, please note that balance requests have low execution priority.
It is strongly recommended to carry out an inventory in advance (not leaving it until the end of September 2016) and bring the balances of alcoholic products in the EGAIS system into line with the actual ones. The mechanisms necessary for this are already implemented in the configuration.

An assistant is designed to correct balances Adjustment of EGAIS balances(chapter Stock – EGAIS). The list and order of actions that the assistant suggests the user perform corresponds to the recommended procedure for organizing work on adjusting balances in the EGAIS system, described above.

In the first step, you should indicate the organization for which you need to adjust the balances in Unified State Information System and the store.

If the program user keeps partial records of transactions with unlabeled alcoholic products, confirming receipts, but not transmitting sales information to EGAIS (in the section Administration – Item settings – Alcohol accounting the functional option – is disabled), then by processing the adjustment of balances, he can prepare the program for maintaining full accounting by writing off the balances of low-alcohol products accumulated on the EGAIS accounting registers. To do this, you need to check that the setting – is set on the first page of the assistant.

If the user keeps records of transactions for all alcoholic products, both labeled and unlabeled, then the setting Adjust the balances of unlabeled products will not be displayed on the assistant form, and adjustment documents will be generated for all products.
Filling out the fields Organization And Shop you need to go to the next step using the command Further.

The first thing the user sees at the next step “Preliminary check” is a recommendation about the need to conduct a complete inventory of alcoholic products. Via hyperlink Create you can go directly from the assistant form to create a new one Order for recount of goods (inventory). In this case, a rule for selecting goods will be automatically established in the document. Inventory of alcoholic products. This rule allows you to include only alcoholic products in the list of goods for recalculation (items that belong to the item type Product: Alcohol (alcohol-containing) products.

Recalculation of alcoholic products is carried out in the same way as for any other goods. After the recalculation is completed and the status is set in the document Recalculation completed, then on the assistant form the item “Carrying out an inventory” will be marked completed.

To the user using the report Registration of surplus/shortages of goods It is recommended to check that, based on the results of the recount of goods, all necessary documents for the movement of goods have been drawn up ( Write-off of goods, Posting of goods, Order for reflecting the results of recounting of goods). The report can be called directly from the assistant form using a hyperlink Form.

If the inventory is not completed (in the document Order for recount of goods (inventory) status not set Recalculation completed) or the recount was not carried out in all warehouses of the store, such information will be displayed on the assistant form and will be marked with the corresponding icon.

Let's move on to the analysis of unfinished exchanges with EGAIS.

Before sending a request to receive balances to EGAIS, the assistant checks the completion of exchanges with EGAIS. If the configuration contains documents awaiting confirmation from EGAIS, or there are unloaded documents in the Universal Transport Module, then such information will be displayed on the assistant form and will be marked with a warning icon. In this case, you can exchange with EGAIS directly from the assistant form.

Attention! Documents with processing status New do not affect the result of the adjustment and are not analyzed by processing. If such documents are available in the information base, the user should independently analyze the draft documents and delete documents created by mistake. Information about the statuses of EGAIS documents can be obtained in the corresponding lists of documents in the section Stock – EGAIS.

Once the preliminary check has been successfully completed, you can proceed to the next step. In the third step, the user can create a request in EGAIS to receive balances in register No. 1 (balances in the warehouse) and register No. 2 (balances in the sales area). Separate requests for balances are generated for each register. To do this you need to set the switches Request remaining stock And Request balances on the sales floor and use the command Further.

It is possible to select previously downloaded EGAIS balances. This option may be in demand if the balances have already been received earlier and since the moment of requesting the balances, no transactions have been executed that change the balances in the Unified State Automated Information System.

In the next step, the assistant removes the remaining alcohol.

If in the assistant at the step “Receiving balances from EGAIS” the switch was set Select previously downloaded, then on the bookmark Accounting balances Balances are displayed as of the date and time of receipt of EGAIS balances. If the user requested balances from the Unified State Automated Information System directly from processing, then the current accounting balances of the item in the user’s information base will be displayed as accounting balances.

If in a store the premises of the receiving warehouse and the sales floor are separated by accounting, then the accounting balances will be displayed in two columns Ost. stock And Ost. shopping room. Moreover, if in the configuration for a store several warehouses with the types “Trading floor” and “Warehouse” are defined, the total balances for each type of warehouse are displayed.

On the bookmark Balances in EGAIS the balances of alcoholic beverages obtained from the Unified State Automated Information System are displayed for each register.

List of products and alcoholic products, which is displayed on the tabs Accounting balances And Balances in EGAIS, depends on setting Upload sales of unlabeled products to EGAIS In chapter Administration – Item settings and settings Adjust the balances of unlabeled products in the assistant for adjusting EGAIS balances (see above). Labeled alcoholic products are always displayed, and unlabeled alcoholic beverages are displayed if the user keeps full records of unlabeled products in the Unified State Automated Information System or plans to adjust the balances through processing.

It is possible to proceed to the next step to generate EGAIS adjustment documents provided that no system warnings are received at the “Remains of alcoholic beverages” step. If any warnings are detected, a warning icon and a text description are displayed for such lines, and further work with the assistant is blocked.

Possible system warnings:

• Unmatched alcoholic beverages were found on the remains.
  In this case, it is necessary to compare EGAIS alcohol products with the configuration nomenclature.
• Products sold by the piece were found that were associated with a classifier element sold by the glass.
  Items sold by bottling must be assigned to the item type Product: Alcoholic (alcohol-containing) products (Sold by the glass), compared with alcoholic products EGAIS with product type Unpackaged, and the volume in deciliters of the base unit of measurement must also be indicated.

To compare EGAIS alcohol products with the configuration nomenclature, you must use the command Compare on the bookmark Accounting balances or Balances in EGAIS. When comparing alcoholic products of EGAIS, the system also analyzes whether a comparison was made with the EGAIS organization (indicated in the EGAIS nomenclature card in the field Manufacturer

If there is no connection between alcoholic products and the configuration nomenclature, on the form Comparison of EGAIS nomenclature For such alcoholic products, a warning icon is displayed and when using the command Compare First, it is proposed to compare EGAIS organizations. If the comparison of EGAIS organizations is not completed, then the comparison of EGAIS nomenclature will not be made.

After all EGAIS alcohol products have been compared with the configuration nomenclature, the command becomes available Further.

At the next step, the assistant displays a table that displays accounting balances and balances according to Unified State Automated Information System data. For each line in which the accounting balances do not coincide with the balances according to the Unified State Automated Information System, the quantity of alcoholic products that must be added to the balance sheet/written off from the EGAIS balance sheet, transferred to the trading floor or returned from the trading floor is calculated.

Manual correction of data in the table is provided only for products sold by the glass, because... the balance of such products in the Unified State Automated Information System may differ from the actual one by the volume of opened containers. All quantities for bottling products are displayed on the form in deciliters. To bring the balances of bottled products in EGAIS into line with the actual ones, it is necessary to calculate the number of unopened containers for such products, convert them to the deciliter unit of measurement and enter the quantity that needs to be written off/put on balance in EGAIS and transferred/returned from the sales floor in the appropriate columns of the table.

To create documents for adjusting EGAIS balances, you must use the command Further.

At the last step, you need to post the generated documents and use the command Send to EGAIS. Since each document is transferred to EGAIS separately, the command must be executed as many times as the number of documents that need to be uploaded to EGAIS.

Official website http://its.1c.ru/db/egais#content:69:retail22

Send this article to my email

When starting to work with any automated system, it is necessary to perform preparatory work. These include initial setup, entering regulatory reference information, loading balances, etc. In this article we will touch upon an important question for many beginners who have just installed the 1C Retail program, how to make balances in 1C.

In order to “make” balances in 1C, you will need a document called Receipt of goods. It is intended to document the fact of an increase in the accounting balances of goods when entering the initial balances. It also serves to reflect the fact of detection of surplus in the organization’s warehouse. It is available in the Warehouse → Warehouse operations section.

A new document is entered using the Create command.

Let's start filling out the header. When creating a document, some fields can be filled in automatically, either if you set selections in the document journal before creating a new document, or if default values ​​are entered for the user. In any case, you must fill in all the fields presented in the header, with the exception of the number and date; they will be filled in automatically when you record the document.

Filling is possible in different ways:

 Line by line filling using the Add command and selecting items from the Nomenclature directory.

 Using the selection function, opens with the command Select products. The selection window can be configured in a way convenient for you. On the left is the selection option, for example grouping by type of item, on the right are the directory positions corresponding to the selected grouping. Here, if you only know the name of the product and it doesn’t matter to you which group it belongs to, you can position yourself in the top grouping and use the search bar by entering the name.

Also in this window you can obtain information about existing balances in warehouses, this will allow you to eliminate duplication of data entry when initially filling out the system.

Here you can select many items; they are stored in the list at the bottom of the window, which is displayed when the Show selected products flag is checked. To ensure that the selected items are included in the document, use the Transfer to Document command.

 You can also make balances in 1C using the barcode of the product; to do this, you need to scan it using a TSD (data collection terminal) or enter it manually by clicking the find by barcode icon.

In addition to the product items themselves, in the tabular section you will need to indicate (if you have not done this before) the quantity, unit of measurement and price of inventory items, as well as the series and characteristics, if the product requires their maintenance.

After the balances have been entered, the document must be processed. Based on it, you can display printed forms: registration act, inventory, labels and price tags (available using the print command).

You can check the results of your work in warehouse reports, for example, movements grouped by warehouse.

Team of experienced 1C programmers:

From 5 minutes response time to urgent tasks, even on weekends and holidays.

30+ programmers with up to 20 years of experience in 1C.

We make video instructions on completed tasks.

Live communication through any messengers convenient for the client

Monitoring the completion of your tasks through our specially developed application

Official partners of the 1C company since 2006.

Experience of successful automation from small firms to large corporations.

99% of clients are satisfied with the results

Not only an accountant needs to know the number of goods in stock on a specific date; such information is needed for planning purchases and controlling sales. You can generate a reporting sheet in the software package “1C: Trade Management edition 11.0”, “Taxi” interface in several ways; in addition, the settings allow you to display not only the total quantity of the item, but also analyze the inventory in a specific warehouse cell, clarify the movement of goods for period including reserve. Before you look at the balances in the warehouse in 1C, you should determine which report will be more convenient to do this with.

Overview of warehouse reports

All main reports regarding product balances are located in the “Warehouse and Delivery” tab.

Each report is designed to present information differently. To decide how to view warehouse balances in 1C, let’s consider all the features of analytical forms. To select the required report, you need to open the tab with the left mouse button and generate indicators by clicking the corresponding button.

All tables can be printed, you must first open the window in viewing mode, and also save to a file or send by e-mail. Let's consider the features of the formation of each reporting form for viewing warehouse balances.

List of goods movement in the warehouse

In this table, you can clarify not only the balances of goods in the warehouse, but also their movement for a certain period of time or as of the date of the report.

The “Warehouse balances” report generates the quantity of items for all storage addresses by default, if a specific warehouse is not selected. In the “Settings” tab, you can check more detailed inventory analytics.

• In the “Selection” tab, use the “Selection” button to configure the generation of a report on a specific product item, product range, or product groups;

• In the “Fields” tab, you set the analytics parameters for the formation of warehouse balances. To do this, you need to check the cell in the left field, then use the arrow to move it to the right field. The hierarchy order in the right margin is formed by the arrows at the top of the panel. With their help, you can prioritize the reflection of product items.

To prevent unnecessary information from being reflected in the reporting form, you can uncheck the box in the left field;

• After selecting analytics, you need to create a report on the balance of goods in warehouses by clicking the “Close and generate” button.

To search for a product item in the generated report on product balances, use the “Find” button. This is a convenient search if the company has a large inventory of inventory. The analysis can be performed not only by the full name of the product; it is enough to enter part of the word.

The settings for the “List of goods in warehouses” report are configured in the same way. It is formed for the enterprise as a whole or for each specific warehouse; you can also set any period for data reflection.

By double-clicking the left mouse button on the quantitative balance or movement of goods, you can open the income or expense analytics.

Warehouse inventory turnover

This report generates inventory analytics. The form is intended to determine balances, control their movement, identify low-turnover groups, in addition, it can be used to estimate the quantity of items for the items of interest.

In the “Settings” tab you can select the following parameters.

• Analysis of turnover of commodity items for a certain interval;
• Type of price - the analysis will be generated only in relation to wholesale, retail, dealer or other types of prices that are provided at this enterprise;
• Stock;
• Type of nomenclature;
• Classification type;
• In the “Selection” tab, if necessary, you can sort the analyzed positions.

After you finish selecting the settings using the “Close and Generate” button, the reporting data will be reflected on the screen.

Remains and availability of goods

This report generates balances for the warehouse or the enterprise as a whole only as of the current date. It is designed to analyze the following data.

• Quantitative balance of goods;
• Reflects the number of positions placed in reserve. They are highlighted in red and have a negative value;
• Available balance, which is calculated taking into account the goods in reserve;
• Expected amount of income and expense;
• The expected quantity of goods for a given date, taking into account reserves, receipts and expenses;
• Available quantity of goods by dates. It may change as new documents are processed.

All settings are made in the corresponding tab; the selection principle is similar to previous reports. After selecting analytical data, the report is generated using the “Close and Generate” button.

Similar data can be performed in the “Commodity Calendar” report; it analyzes balances for specific dates, taking into account the receipt of goods, sales and reserves. The program will also tell you which items are already expired.

Report “Statement of item series”

This form allows you to clarify the movement and quantity of a specific product item. This may be necessary, for example, to identify controversial issues regarding the quality of a product or batch, shipment and remaining defects.

In setup mode, you need to select the following options.

• Data analysis period;
• Product item;
• If necessary, you can narrow the search by filling in the “Series” and “characteristics” fields of the product. This is doable provided that the data was initially entered into the item card.

Using the “Close and Generate” button, the reporting form will be displayed on the monitor.

Remaining goods by expiration date

In this report, you can control inventory taking into account expiration dates. This is a convenient report not only for food residues, but also for cosmetic products, household chemicals, pharmacology, and veterinary medicine. To do this, in the “Settings” tab, you must first select the expiration date, the limit of which should be monitored.

• Expired products;
• 0-20%, 20-40%, 40-60%, 60-80% left before expiration;
• View perishable product items, as well as items with an expiration date of more than a year.

Information about the expiration date must be entered manually into the product card upon arrival. For a detailed analysis, the report allows you to select a narrower category of inventory, as well as identify a specific warehouse for selecting analytics.

Inventory in operation

The report allows you to quickly generate information about product items transferred and returned by employees or other individuals. The program provides analytics for the following positions.

• Analysis of balances in relation to all individuals or allows you to select a specific person;
• Analysis of the balances of the entire product range or a separate product item;
• Clarify the status of production of an item's resource.

The “Close and generate” button will display the report on the screen.

Conclusion

You can view product balances in the “1C: Trade Management version 11.0” program, “Taxi” interface using various reports, the data is generated not only in quantitative terms, but also in total. In addition, expanded forms help analyze the movement of items throughout the enterprise, at a specific warehouse, or just one product item. The software package will tell you which goods are reserved, this is convenient if several people are involved in shipment.

Let's consider the procedure for unloading balances when working in 1C: Retail version 2.2

Step 1: Open the report

In the left menu, select Warehouse, then Warehouse reports.

Rice. 1. Menu “Warehouse”, section “Warehouse reports”

In the form that opens, in the Warehouse operations item, select Warehouse balances.

Rice. 2. Section “Warehouse reports”, item “Warehouse balances”

In the report you can select by parameters:

• Nomenclature

Then click the “Generate” button.

Rice. 3. Report “Warehouse balances”

Let's consider the procedure for unloading balances when working in 1C: Retail version 2.1

Step 1: Open the report

In the top menu, click Warehouse, and in the field on the left - warehouse reports. Next - the balances in warehouses.

Rice. 4. “Warehouse” menu, section “Warehouse reports”

Step 2. Setting up selection and generating a report

Selection can be done in the same way as in version 2.2. Then click the “Generate” button.

Rice. 5. Report “Warehouse balances”

What else you need to know to work in 1C: Retail

How to save a report to your desktop

Click on the blue floppy disk sign or use the keyboard shortcut Ctrs + S. Select the format and save location.

Rice. 6. Saving the report

How to track balances in the 1C: Retail program

In the Sales section there is a report Sales analysis and order generation. It will help you understand when and how much goods need to be purchased.

Rice. 7. Report “Sales analysis and order formation”

How to unload balances with prices

Step 1. Select Warehouse, then Warehouse Reports.

Step 2. In the block that opens, click on Warehouse valuation (in prices by price type).

Step 3. Enter the data in the selection and click the Calculate button.

Rice. 8. Menu “Warehouse”, item “Warehouse assessment”

If you still have questions about creating balances in the 1C: Retail program, please contact our specialists for help.

Similar articles