1s 8.3 trade management card of goods movement. Reflection of turnover in the accounting model. General overview of working with a warehouse


Product report in 1C Accounting 8.3

The commodity report in the 1C Accounting 8.3 program is a unified form TORG-29, approved by Decree of the State Statistics Committee of December 25, 1998 No. 132. The form is used for balance accounting of goods and allows you to control the movement of inventory items and balances in warehouses.

TORG-29 is drawn up by the financially responsible person who receives and releases the goods, and is then transferred to the accounting department in two copies. The accountant monitors the commodity report and primary documents, marks receipt and returns a copy of the report to the financially responsible person.

Let's take a closer look at the features of creating a report. Let's first look at the system settings. The report will be generated only for organizations that keep records of retail goods at sales value. This setting is set in the organization's accounting policy for navigation: Main / Settings / Accounting policy.

To generate a report in the 1C Accounting 8.3 program, you need to follow the navigation path: Sales / Reports / Product report (TORG-29).

The person responsible for generating documents sets the required period and warehouse, then clicks the “Generate” command.

Selection by the “Warehouse” field is mandatory. The standard functionality of the program does not provide the ability to display a report on several warehouses of an organization. It should be noted that the warehouse must be of the “Retail store” or “Manual outlet” type. Accordingly, the warehouse selection form opens with programmatic selections for the “Warehouse type” field, and wholesale warehouses are not displayed in the list. If the user does not find the warehouse of interest in the selection list, it is necessary to additionally check this detail and the correctness of filling out the warehouse card.

Also in the top panel of the form, the user is given the opportunity to fill in the product report number. Numbering is carried out from the beginning of the year.

After clicking the “Generate” command, the specified number will be displayed in the report, and the automatic counter will increase the value of the “Document Number” field for the next report by 1 unit.

The details of the organization in the form are filled out from the “Organizations” directory, namely:

Name of company;

According to OKPO;

Type of activity according to OKDP.

Editing this information is available via the navigation path: Home / Settings / Organizations.

The commodity report includes information on all incoming and outgoing movements of goods in the selected warehouse for a specified interval, which is presented in the form of a table with the columns below:

  • Name (element of the directory “Nomenclature”);
  • Date (date of the document recording the transaction, the report is displayed in the context of movement documents);
  • Number (register document number);
  • Product amount (amount from the “Products” tabular section of the movement document)
  • The amount of containers (the amount from the tabular section “Returnable containers” of the movement document)
  • Accounting notes (fields for accountant's comments).

By clicking the “Print” button, the responsible user opens the report preview window and sends it to print.

Still have questions? Get a free consultation on design in 1C 8.3!

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

General overview of working with a warehouse

Working with a warehouse involves processing receipts, sales, movements between warehouses, as well as generating reports on the movement of items for 1C and inventory. In addition, conducting an inventory in all warehouses and recording its results.

Admission

Receipt of items in 1C 8 should be done from the “Purchasing” menu, “Purchasing Documents (all)” tab. To do this, you need to “Create” a new document with the corresponding button.

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

In any of the created documents, you must fill in the parameters of the supplier, contract, and select a warehouse in the “Basic” tab. The “Products” tab is intended for selecting 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 items later, and misgrading may also occur.

To enter a card, you need to create a new item in the “Products” tab using the “Create” button. All information from the card will then be used when generating documents for movement and sale, as well as creating reports, so you need to fill out all the cells accurately.

Analytical data in the “Financial accounting group” cell allows you to select an enlarged product group: finished products, goods, materials accounting in 1C, workwear, intangible assets. According to the selected position, the corresponding accounting entries will be generated.

In the case of a charitable or gratuitous transfer of goods, transactions in 1C are generated by selecting the appropriate “Write off as expenses” tab. This will affect the financial result.

After filling out all the admission information, you can print the document. Depending on the nature of the receipts, select the appropriate receipt report. The “Post and close” button will complete the posting of goods in 1C, after which all information is reflected in the accounting accounts and reporting forms

Implementation

Sales of goods can be completed in the “Sales” menu in the “Sales documents (all)” field. The format of the document is similar to that of the receipt. The “Basic” tab is intended for displaying general information about the transaction.

  • You must select a client from the directory;
  • The field “Agreement on terms of sale” is required;
  • specify the type of operation;
  • select warehouse.

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

It is more convenient to select a large assortment of goods for UT 11 through the “Fill” tab with the “Selection of goods” button. After selecting specific product items, you should transfer them to the invoice using the “Move to document” button.

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

  • Sales Invoice;
  • the act of providing services;
  • invoice;
  • commodity and consignment note.

The document will appear in the report only after the form is completed and closed.

Goods movement report

After you have received the goods in 1C, you can generate reports on the movement of items. To do this, from the “Warehouse and Delivery” menu, go to the “Warehouse Reports” tab. When you click the button, all available warehouse reports open.

List of goods in warehouses

The general movement of goods in the warehouse can be viewed from the first menu “List of goods in warehouses”.

The report is generated for the organization as a whole. If necessary, you can create it for a specific warehouse. If you check the “Details to” box, information about the source documents will be provided under each item. They can be opened by double-clicking the left mouse button.

Inventory turnover in warehouses

The program provides a report on turnover in 1C “Inventory turnover in warehouses”. Its need can be assessed in large shopping centers or logistics bases, as well as in the presence of several retail outlets. It is formed on the basis of data on the movement of product groups with analysis for a certain period and output of the average daily balance.

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

If necessary, you can configure the analysis of information in more detail. To do this, in the “Settings” tab, select analytics in quantitative or total terms, set up selection by product group, retail or wholesale price.

Conclusion

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

From an accounting point of view, moving goods between warehouses is only a change in the value of the subconto (analytics). The goods must remain on the same accounting account (for example, 41.01) and at the same price (cost). Let's look at step-by-step instructions on how to move goods in 1C 8.3.

Everything described below is true not only for goods, but also for materials, semi-finished products, finished products and other goods and materials.

The movement can be completed using a document of the same name, which is located in the “Warehouse” menu:

The document header is simply filled out:

In 1C Accounting 8.3, movement of goods is possible in three options:

  • between warehouses;
  • transfer to retail trade;
  • (on off-balance sheet accounts);
  • movement of return goods.

Let's look at each of them in more detail.

Between warehouses and retail

The simplest and most common way. To do this, on the “Products” tab, you need to fill in the quantity of goods for transfer and:

Get 267 video lessons on 1C for free:

Please note that if you transfer goods that are not in the warehouse/organization/on the accounting account, then “minuses” will be included in the accounting. It is important to check which account and warehouse the goods are currently in.

Let's look at the postings that generated the document on the movement of goods:

As you can see, in all postings, only the second sub-contact – “warehouse” – has changed.

You can also see that the first two entries have a filled “Amount” (the transfer price was formed at cost), but the third does not. This example clearly shows what will happen if you move a product that is not in stock.

Transfer of goods to retail

In order to make a transfer to a retail store or NTT, just select the desired retail warehouse in the “Recipient” field in the document header.

Returns from retail to a wholesale warehouse in 1C occur according to the same scheme; naturally, the warehouses are swapped.

The prices at which the goods will be sold at a retail outlet are indicated using the document ““. The retail price type is set individually for the warehouse:

The planning and performance of not only the purchasing and sales departments, but also production as a whole depends on promptly obtaining information about the amount of inventory assets a company has. Maintaining warehouse accounting in 1C will allow you to receive up-to-date data using the necessary filters.

If a company has several warehouses, setting up warehouse accounting must begin with the introduction of two or more accounting locations. To do this, you need to find the “Warehouses” section in the “Directories” - “Goods and Services” menu.

Fig.1



Fig.2



Fig.3

We sequentially fill in the fields of group, name, and responsible person. Similarly, we create Warehouse No. 2 indicating the name as “Retail”.



Fig.4

Thus, we formed two warehouses: No. 1 and No. 2.

For correct accounting, you must enter balances at the beginning of the year. To do this, in the “Main” menu we find the “Balance Entry Assistant” tab.



Fig.5

The balance entry assistant window opens, in which we select the balances for which account we want to enter. In our case, this is account 41 “Goods”.



Fig.6

The document date of 12/31/2017 is set automatically, since in our settings it is set that the balances were visible on 01/01/2018 (if the document date is January 1, the amount of the balances falls into the turnover of the current year).



Fig.7

Remaining goods can be checked in the menu “Warehouse” - “Reports” - “Remaining goods”.



Fig.8

In the window that opens, set the date on which we want to check the balance and click on the “Generate” button.



Fig.9

The receipt of goods into the organization is documented in the “Purchases” section with the document “Receipts (acts, invoices)”, which is registered with the line “Warehouse”.



Fig.10

Hovering the cursor over the line “Warehouse” leads to the possibility of choosing which warehouse to receive the goods arriving on the invoice.



Fig.11

We choose Warehouse No. 1 “Wholesale”. For example, let’s fill in the name and quantity of the delivered product – “Computer included” in the amount of 80 pieces.

The most common type of movement of goods is movement from a Wholesale warehouse to a Retail warehouse (transfer from a warehouse to a store, for example). To do this, go to the “Warehouse” section and go to the “Movement of Goods” subsection. A journal for registering transferred goods opens, in which it is necessary to generate an electronic document “Movement of goods”.



Fig.12

After filling in the date of movement of the goods, fill in the “Sender” column, selecting the Wholesale warehouse, and then the “Recipient” column - in our case, this is the Retail warehouse. In the “Nomenclature” line, using the “Add” or “Selection” buttons, we will transfer 50 pieces of “Computers included” from the “Wholesale” warehouse to the “Retail” warehouse.

After completing this document, we again generate the “Remaining goods” report.



Fig.13

The 1C program for warehouse accounting simplifies as much as possible the procedure for disposing of materials and goods from the warehouse. Next, let's look at an example of writing off materials for production. The write-off of material for production is documented in the “Requirement-invoice” document.

To register it, you need to go to the “Warehouse” section, then the “Warehouse” subsection, then find the line “Invoice requirements”.



Fig.14

In the window that opens, you can immediately select the warehouse from which you are going to write off materials for production. This function is active until you click the “Create” button.



Fig.15



Fig.16

When filling out the necessary details, there is a “Warehouse” line on the right, which allows you to select from which warehouse the materials are written off for production. In our example, Warehouse No. 1 is Wholesale.



Fig.17



Fig.18

Note! We specifically placed the quantity of materials in excess of the actual availability in the warehouse. The system allows you to write off materials in excess, since in the menu “Administration” - “Post documents” (Fig. 19) we have checked the box in the line “Allow write-off of inventories if there are no balances according to accounting data.”



Fig.19



Fig.20

If you uncheck this box, the program will prohibit posting a document for writing off materials. Below we will describe how the system controls negative balances.

Inventory of goods

Automation of warehouse accounting also implies electronic registration of inventory results. For this purpose, the following documents are provided in the “Inventory” section:

  • Inventory of goods;

Let's take a closer look at all three documents.

We will conduct an inventory of goods in Warehouse No. 1. To do this, select the document “Inventory of goods”.



Fig.21

By clicking the “Fill” button, the document displays information on balances based on accounting data. Let us remind you that after moving the goods, we still had 40 “Computers included” in our warehouse. Let's assume that there are actually 39 computers in the warehouse. To do this, edit the “Actual quantity” column. The program automatically calculates the amount of deviation with a minus sign and highlighted in red.





Fig.23

To further reflect the inventory results in accounting, you need to post a document “Write-off of goods”.



Fig.24

In the “Inventory” line, the program allows you to select the document that served as the basis for writing off the missing goods. After selecting this document, click the “Fill” button. 1C Enterprise provides for automatic transfer of data from the selected document without re-entering.



Fig.25

Here it is worth paying attention to the column “Expenses (OU)”. In accordance with the accounting policy, when carrying out this document, damage should be written off directly as expenses or not taken into tax accounting.



Fig.26

The report shows that there are 39 computers in stock.

Let's assume that, based on the results of the inventory, we have, on the contrary, a surplus of 2 computers.



Fig.27

As when writing off goods, in the “Posting of goods” you need to select the basis document “Inventory of goods”, information from which is also automatically pulled into the new document.



Fig.28



Fig.29

In the pictures presented above, please note that according to the product range DT (Diesel fuel) there is a negative balance of 2000 liters, that is, we shipped a product that we actually did not have in stock. From this we conclude that the program did not reflect the supply of diesel fuel from our suppliers. To eliminate such moments, automated warehouse accounting is supplemented with the document “Control of negative balances,” which can be found in the “Warehouse” - “Reports” menu.





Fig.31

When control of negative balances is disabled, this report allows you to effectively and timely track the receipt and reflection in accounting of material reports of responsible persons, and also eliminates misgrading in the product range. Otherwise, the program does not allow you to post the corresponding document.

6.1. Generating reports on goods movements

Using the “Statement of inventory balances” report, you can monitor information about the movement of inventory items in a specific warehouse, for a specific company. You can also monitor information about the movement of inventory items in the context of various analytical features of management accounting. Using filters in the report, you can display information only on the movement of inventory items at a specific warehouse (or at several warehouses using a multiple filter). This report is entered from the “Statement of inventory balances” item in the main menu of the “Reports” program.

Data in the report can be presented in both basic and base units of measurement. If basic units of measurement are set for the report, you can display quantitative results for each of the inventory groups in the report. To do this, you need to set the “Totals by groups” flag. To get a more complete picture of the movement of inventory items, you can set the flag “Show balances with commission agents” and receive information not only about the movement of your own inventory items in warehouses, but also about the transfer of inventory items for sale to commission agents. On the “Multiple filter” tab, the user can set special filter parameters for generating a report - By item, By warehouse, By item properties, By company, By legal entity. persons, According to management analytics. In this case, in the “List of selected elements” report form window, it is possible to select specific values ​​or a list of values ​​corresponding to the selected filter type. It should be noted that the values ​​of the selected elements can be either directory elements or groups of elements.

– Company / Warehouse / Item property / Item / movement documents – information about the warehouse and item. If the appropriate detail is specified, then information about the company, the item property and the movement document, according to which the movement of inventory items to warehouses was made, is displayed.

– Opening balance – balance of inventory items at the beginning of the reporting period.

– Receipt – the amount of inventory items received (purchased or transferred from another warehouse) to the warehouse during the reporting period.

– Expense – the amount of inventory items written off (sold or moved to another warehouse) from the warehouse during the reporting period.

– Final balance – the balance of inventory items at the end of the reporting period.

– Final reserve – the balance of the inventory reserve at the end of the reporting period.

In the “Inventory balances” report, you can display data on inventory balances with distribution by warehouse. This report is entered from the “Inventory balances” item in the main menu of the “Reports” program. The report presents both quantitative and summary indicators of inventory items. The price and value of the remaining goods in warehouses are calculated based on the price value specified in the report settings: cost price including VAT, cost price excluding VAT, price from the price directory. For retail warehouses, the report can show the price at which inventory items are stored in the retail warehouse and the amount. In this case, you must select the value of the “Price” column: selling price (retail only). When you select the value in the “Price” column: “from the price directory”, an additional window opens in which you must select the price type from the drop-down list. The list displays all price types specified in the corresponding directory (Purchase, Small Wholesale, Wholesale, Retail). When choosing a price from the directory, the price and cost of inventory items are displayed in the currency that is specified for this type of price in the directory. In the event that it is necessary to control only quantitative balances, you can select the value “do not show” for the “Price” column. In this report, you can set a filter by inventory balances in the warehouse. For wholesale warehouses, you can set a filter based on the availability of inventory items, taking into account reserved inventory items. In this case, the “Balances” field must be set to “minus reserves.” Using this report, you can monitor information about the balances of inventory items in a specific warehouse, for a specific company. You can also monitor information about inventory balances in the context of various analytical features of management accounting. To get a more complete picture of the movement of inventory items, you can set the flag in the “Show balances with commission agents” field and receive information not only about the balances of your own inventory items in warehouses, but also about the balances of inventory items transferred for sale to commission agents.

Information that is generated in the report:

– goods and materials – group of goods and materials, full name of goods and materials or group of goods and materials.

– Price – this column appears if the price display setting is set (any value is selected except “do not show”). Prices will be shown in the currency that is defined for this price type in the directory.

– Cost and selling price (sales price) for retail are shown in accounting currency. In the event that inventory items are stored in a retail warehouse at different prices, then inventory balances will be shown for each price at which there are inventory balances in the retail warehouse.

– Name of warehouse (commission agent) – quantity and amount of inventory items in warehouses as of the date of report generation.

By button<Инвентаризация>the user can generate a “Warehouse Inventory” document based on the data obtained from the report.

The report “Batch Statement of Inventory and Materials” presents not only quantitative, but also total indicators of inventory items. This report is entered from the “Batch Statement of Inventory and Inventory” item in the main menu of the “Reports” program. Using this report, you can find out how much inventory material is registered with a certain material entity, find out from which supplier the inventory item came from, how much at cost the inventory item was spent for a certain period, etc. The amounts in the report can be calculated in the currency of management accounting ( Management accounting) or in the accounting currency (Accounting). If the amounts are calculated in the accounting currency, they can be shown with or without VAT (Accounting (with VAT) or Accounting (without VAT)). You can select various data for your report using filters. You can select information on purchased inventory items, accepted inventory items for sale, as well as information on various materials, products, services, semi-finished products or containers (the “Batch Status” parameter). You can select information on one financially responsible person or an arbitrary list of financially responsible persons (the “MOL” parameter). You can generate data on transactions executed by one company that is part of the company (Company), on transactions executed by a legal entity (Legal Entity) or on transactions that have a certain analytical characteristic (Management Analytics). Using drill-down and groupings in a report, you can obtain a variety of information. For example, if you set the detailing Supplier – Item – Movement documents, you can get information about which inventory items were purchased from the supplier and what documents were prepared. If you set the detail level MOL - Nomenclature, and set a filter by groups of inventory items, or by an arbitrarily selected list (on the “Multiple filter” tab), you can get information about how much in the currency of management accounting the data of inventory items are held by the financially responsible persons. To obtain more visual information in reports, it is not recommended to set detail by a large number of parameters; this will lead to the cumbersome presentation of data in the report, i.e., the information from the generated report will be difficult to analyze. If you check the “Details by transactions” checkbox, you can obtain more detailed information on all transactions that were performed during the reporting period. For example, in this case, the “Receipt” column will be detailed to the level of specific operations for the receipt of inventory, transfer of inventory at retail, assembly of kits, capitalization of inventory, etc. d. The corresponding columns will present the amounts in accordance with the selected accounting currency (“Management accounting”, “Accounting with VAT”, “Accounting without VAT”) for each operation. If details are specified for movement documents, then the corresponding amounts will be displayed for each document. Quantitative characteristics in this report are displayed if any batch parameters are set, for example, a certain batch status is selected, detail is set by batch status, detail is set by batch properties.

In this report, it is also possible to detail the properties of a batch of goods and materials - by size, color, shelf life, etc. To obtain this type of information, it is necessary to set the detail of the report on the properties of the batch. In this case, if upon receipt of inventory items a certain property was assigned, then it will be grouped in the report.

Information that is generated in the report:

– Opening balance – information about the opening balance of inventory items as of the date of report generation in quantitative and total terms;

– Receipt – information about how many inventory items were received in quantitative and total terms during the period of report generation;

– Expense – information about how much inventory and materials were spent during the reporting period;

– Final balance – information about how much inventory in quantitative and total terms remained at the end of the report generation.

“Report on sales of inventory items” serves in the system for users to obtain information on sales of inventory items. This report is entered from the “Inventory and Materials Sales Report” item in the main menu of the “Reports” program. From the report, the user can obtain complete information about the purchase and selling prices of goods and materials, profit and turnover received from the sale of goods. This report also displays information about discounts provided when selling goods, the amount of VAT paid upon receipt and sale of goods. Using report settings, you can make various selections and groupings of report parameters.

In the report, you can select information on specific inventory items, groups of inventory items, inventory items that have certain properties, as well as an arbitrary list of inventory items, groups of inventory items and properties of inventory items (on the “Multiple filter” tab). You can filter by specific buyers (suppliers), a group of buyers (suppliers), or by an arbitrary list of buyers (suppliers) by selecting values ​​on the “Multiple filter” tab. The user can make a selection by the status of the sold inventory items: “all”, “purchased”, “accepted” (selecting the “Type of goods” parameter from the list). If the flag “For accepted goods and materials, display commission” is set, the commission will be shown as profit for goods and materials accepted for sale. In this case, the report can be generated only in the accounting currency and only for those goods and materials accepted for sale for which the enterprise has already reported to the principal (the “Report to the Principal” document has been drawn up). When deciphering the amount of profit, a list of those reports of the principals is shown, as a result of the execution of which the commission was accrued. The selection can also be made by type of sale: “any”, “wholesale”, “retail”. It should be taken into account that: “wholesale sale” is a sale documented using the documents “Sales of goods and materials (purchase and sale)”, “Commission Agent’s Report”, and “retail sale” is a sale documented using retail trade documents (“ KKM report", "Sales (retail)"). Return of goods from the buyer is displayed in the “Sales” column with a minus sign. If the goods returned by the buyer were then sold, a new batch of goods is created, created by a return document.

The configuration provides the ability to drill down into the report based on various parameters. You can also change the order in which data is presented in the report. The order of data presentation is changed in the “Report Detail” settings window on the “Main” tab using the control buttons (up, down). Having placed the cursor on the desired position, you can use the control buttons to move it to the desired location. By changing the level of detail and the order of data presentation, you can obtain a wide variety of information in the sales report. So, for example, by setting the detail parameters “Nomenclature” - “Delivery Documents” - “Sales Documents”, you can obtain information about the profit from the sale of goods by suppliers and compare the profit received from the sale of goods by several suppliers. By setting the detail parameters: “Nomenclature” – “Sales documents” – “Delivery documents”, you can obtain information about which supplier’s goods were sold to the buyer.

The “Inventory Reserves” report is designed to display information about inventory reserves. This report is entered from the “Inventory and Material Reserves” item in the main menu of the “Reports” program. The report generates a full or partial (if a certain filter is installed) list of reserved inventory items. Reservations of inventory items are made at a specific warehouse or for the company as a whole. The report can display information about how much inventory is reserved at a specific warehouse. Using a multiple filter (the “Multiple Filter” tab), you can display a report on the reservation of inventory items at several randomly selected warehouses.

The report can additionally display information about the reserve of specific inventory items. The selection of inventory items is carried out using the appropriate filters: inventory items, inventory groups, inventory items properties. Selection based on the properties of inventory items is made on the “Multiple filter” tab. The report can also provide information about which customers the inventory items are reserved for. To do this, in the report detail, you need to set the “By Customers” flag. If you need to see how many inventory items are reserved for a specific buyer, then you must select it in the “Buyer” field. The report can be detailed by warehouses, customers for whom inventory items are reserved, contracts and movement documents. If you set the “Totals by groups” flag, the report will display groups of inventory items and the total amount of inventory items reserved for this group. Totals by group can only be displayed if the information in the report is displayed in basic units.

Information that is generated in the report:

– Warehouse / Nomenclature / Buyer / Movement documents – information about goods and materials (group of goods and materials), full name of goods and materials (group of goods and materials). If the appropriate detail is specified, information is displayed about the warehouse that has reserved inventory items, for which buyer the inventory items were reserved, and under what contract the reservation was made. Information is also displayed about which document was used to reserve and remove the reserve from the warehouse. Please note that if the reservation was made not for a specific warehouse, but for the entire company as a whole, then the line “not selected” is displayed in the report.

– Initial reserve – how many inventory items were reserved as of the start date of the report.

– Reserved – how many inventory items are reserved for the entire period of report generation. Reservation of inventory items is carried out when preparing the documents “Request for warehouse”, “Request for delivery”. Automatic reservation of inventory items is also carried out if the end-to-end accounting mode is used. In this case, the receipt document issued on the basis of the “Order to Supplier” reserves inventory items at the warehouse indicated in it for the buyer to whom this order was distributed.

– Removed from reserve – information about how many inventory items have been removed from reserve. The reserve is removed upon shipment of goods and materials at the request of the buyer (document “Sales of goods and materials”). Manual removal of the reserve is carried out using the document “Buyer’s Application Correspondent.” This document is issued on the basis of an existing application and adjusts the quantity of inventory items reserved according to the application.

– Final reserve – how much inventory remains reserved as of the end date of the report.

By button<Снятие резерва>the user can generate a document “Removal of a reserve for a company” or “Removal of a reserve for a warehouse” based on the data presented in the report.

Using the “Quantitative-total accounting card” report in the “Trade + Warehouse” configuration, you can generate a printed form of a quantitative-total accounting card, approved by Decree of the State Statistics Committee of Russia dated December 25, 1998 No. 132 (form according to OKUD 0330228). In this case, it is possible to select a product item, storage warehouse and type of accounting price. For warehouses with the retail warehouse attribute, the parameter for selecting the type of accounting price becomes inactive. It should be taken into account that the card number in the report is automatically set to one more than the previously entered one. This report is entered from the “Quantitative-cumulative accounting card” item in the main menu of the “Reports” program. In the “Legal entity for printing” field, the user can set the legal entity that should be included in the header of the quantitative accounting card. It is important to keep in mind that in order to generate a report, all fields of the card must be filled out.

The “Project Report” form is used in the system to obtain information about the fulfillment of customer requests, monitoring the fulfillment of orders by suppliers, as well as the movement of inventory items grouped by projects. This report is entered from the “Project Report” item in the main menu of the “Reports” program. In the project report, you can generate data using various filters. Using the “Report Detail” settings group, you can set different order of data presentation in the report. To obtain more visual information in reports, it is not recommended to set granularity for a large number of parameters; this will lead to cumbersome presentation of data in the report and create additional problems when analyzing it. It should be taken into account that the project report does not analyze the documents “Receipt of services, etc.”, “Implementation of OS, intangible assets”. The project report also does not analyze documents recording the movements of inventory and cash. In the project report, only the document “Advance report line (payment to supplier)” is analyzed; all other documents for settlements with accountables are not analyzed in the report.

Let's look at several options for using this report. One of the options for using projects may be the ability to distribute documents to responsible persons (for example, managers) responsible for the purchase and sale of inventory items. In this case, when drawing up a document, the name of the manager responsible for carrying out this operation is entered in the “Project” field. In order for the user in the project report to receive information about the fulfillment of customer requests (orders by suppliers) by managers, it is necessary to set the flags in the “Output information” group - “About customer requests”, “About suppliers’ orders”, and in the “Report detailing” group set the following grouping order: “Project” – “Authors of documents” – “Documents of movement”. In this report, you can also obtain information about which of the managers is responsible for fulfilling a specific buyer’s request, which of the employees drew up documents within the framework of the project, and which documents were used for the shipment (or receipt) of goods and materials. The amounts in the report are given in the currency of the counterparty agreement under which the buyer’s application or supplier’s order documents were drawn up. Setting the detail “On cash flows” will also allow the user to obtain information about payments made by counterparties - suppliers and buyers. Another example of using projects is the ability to track the effectiveness of a marketing company. When registering a document in the project field, you can specify additional information about where the user learned about the products sold by the company (from an advertisement in a newspaper, from information on a billboard, or from printed materials published by the company itself). The report can then compare product sales performance and determine which of the company's marketing campaigns was more effective. In this case, in the report in the “Output information” group, you should set the flag “On movements of inventory items”. In the “Report Detail” settings group, you should set the following grouping order – “Projects” – “Nomenclature”. Information in the report can be displayed in the accounting or management accounting currency. The quantity of inventory items can be displayed in basic or basic units of measurement. The data in the “Incoming” column is formed on the basis of receipt documents of goods and materials, and the data in the “Expense” column is based on shipment documents. If you set the additional detail “Transaction documents”, you can control which documents were used to document the receipt and shipment of goods and materials.

The “Commodity Report” report is intended to generate a printed form of a commodity report, approved by Resolution of the State Statistics Committee of Russia dated December 25, 1998 No. 132 (TORG-29). A product report can be generated for a specific company or legal entity. For a legal entity, a commodity report is generated if the company has several companies that have the same legal entity, but different analytical features of management accounting. The product report number is set in the settings before generating the report.

The “Accompanying Register” report is intended for compiling accompanying registers when recording goods at purchase prices, when maintaining varietal and batch accounting of goods. This report is entered from the “Accompanying Register” item in the main menu of the “Reports” program. It can be formed only for one specific company or one legal entity. A report on a legal entity is compiled if in the configuration there are several companies that have the same legal entity, but different analytical characteristics of management accounting. The accompanying register number is specified in the report settings. When you enter a new accompanying register, its number is automatically set to one more than the previously entered number. The user can create an accompanying register for a specific warehouse.

From the book Accounting author Bychkova Svetlana Mikhailovna

Method for calculating the cost of goods (except for goods accounted for at sales value) upon sale (issue) Goods are valued similarly to inventories, the valuation methods of which are discussed in the subsection “Procedure for writing off the cost of inventories”.

From the book Accounting author Melnikov Ilya

PREPARATION OF ACCOUNTING REPORTS When drawing up an accounting report, the following must be ensured: – complete reflection for the reporting period of all business transactions and the results of the inventory of production resources, finished products and calculations; – complete

From the book Accounting in Trade author Sosnauskiene Olga Ivanovna

2.7. Preparation of commodity reports A commodity report is, first of all, a document confirming the balance of goods registered with a specific financially responsible person. The commodity report is drawn up by the financially responsible person based on

From the book Balancing: a textbook author Zabbarova Olga Alekseevna

3.1. Structural construction of balance sheets The general idea of ​​using the balance sheet method is to equalize the total value of the indicators recorded on the left and right sides of the balance sheet equation. The first experience in constructing balance sheets belongs to the accounting department.

From the book Consumer Rights Protection: Frequently Asked Questions, Sample Documents author Enaleeva I. D.

Chapter 2 The right of consumers to the proper quality of goods, works, services and the safety of goods 2.1. Product quality. Warranty period According to Art. 470 of the Civil Code of the Russian Federation, the goods that the seller is obliged to transfer to the buyer must meet the quality requirements established by the Civil Code of the Russian Federation,

From the book 1C: Accounting 8.2. A clear tutorial for beginners author Gladky Alexey Anatolievich

Chapter 12. Setting up, generating and printing statements and reports In fact, all accounting is carried out with the aim of obtaining clear and reliable reports. In this chapter we will tell you how to work with reports in the 1C Accounting 8 program. It is worth noting that

From the book Foreign Economic Activity: Training Course author Makhovikova Galina Afanasyevna

5.3. The procedure for the arrival of goods into the customs territory of the Russian Federation, the departure of goods from the customs territory of the Russian Federation. Release of goods Arrival of goods and vehicles into the customs territory of the Russian Federation is allowed at checkpoints across the State Border of the Russian Federation during work

From the book Handbook on Internal Audit. Risks and business processes author Kryshkin Oleg

Subprocess “Creating the need for inventory items/works/services and generating applications” This subprocess includes four main stages: generating the need for inventory items/works/services; preparation and execution of the application by the customer, approval of the application for

From the book 1C: Enterprise. Trade and warehouse author Suvorov Igor Sergeevich

The nuances of writing reports There is extensive literature devoted to business writing. However, it is unlikely to contain any mention of specific aspects of writing audit reports. There are a number of nuances, both before writing the report, and during and after writing

From the book 1C: Enterprise, version 8.0. Salary, personnel management author Boyko Elvira Viktorovna

6.4. Preparation of financial reports The “Purchases Book” report is called up from the “Purchases Book” sub-item of the “Accounting Reports” item in the main menu of the “Reports” program. The purchase book is formed based on the purchase book entries. Purchase ledger entries can be generated

From the book Google AdWords. Comprehensive Guide by Geddes Brad

6.5. Creating analytical reports The “Sales Dynamics” report is designed to obtain information about sales dynamics for a selected period of time. The period of this analysis is set in the report settings (Period). This report is called from the sub-item “Sales dynamics”

From the book Great Team. What You Need to Know, Do, and Say to Build a Great Team by Miller Douglas

4.5.2. Generating regulated reports At the beginning of the procedure for generating a regulated report, a start form opens. The start form is intended for:? choosing the period for generating a regulated report;? automatic shape detection

From the book Comprehensive economic analysis of an enterprise. Short course author Team of authors

Using Reports to Optimize Your Account Now that you know how to download and extract data from the AdWords system, you need to understand how to use different reports to analyze your account more effectively. If you want to visualize data using conditional

From the book Managing Financial and Commodity Flows at Trade Enterprises author Neveshkina Elena

2. Reporting If you are writing formal reports for management, both your project team leader and other team members need to know when they can get the information they need from you. You must meet the allotted deadlines in order to

From the author's book

8.2. Analysis of segmented reports Having recognized that the use of a two-stage calculation of marginal income provides greater information opportunities, we will analyze more detailed segments. Reporting for plant No. 1 by individual types of products

From the author's book

Chapter 2. Formation of the value of goods when accepting them for accounting The concepts of “price” and “cost”, “cost” and “cost” are so often confused and swapped that the differences between them are no longer paid attention to. So, you bought the product for

Editor's Choice
How does a loan agreement differ from a loan or credit agreement, and how to correctly formalize the issuance of money to an employee in the program...

Commodity report in 1C Accounting 8.3 Commodity report in the 1C Accounting 8.3 program is a unified form TORG-29,...

In this article I want to consider aspects of the calculation and withholding of personal income tax in 1C 8.3, as well as the preparation of reports on forms 2-NDFL and...

What to do if an erroneous entry is made in accounting? To do this, you can use special techniques for correcting such records. If an error...
There are at least 5 reasons for refusing to purchase and use counterfeit software for business. These are: Non-economic risks:...
How to assemble and disassemble goods in the program using the example of Trade Management?
In this article I want to consider aspects of the calculation and withholding of personal income tax in 1C 8.3, as well as the preparation of reports on forms 2-NDFL and...
Left and right connection 1s
KUDiR: a terrible beast or an important document?