allows you to get information about the number of goods and ready meals in a warehouse on a certain date, control stocks and replenish stocks of goods, identify expired products, correct negative balances.
How to work with a report
By default, the report shows the warehouse status for the current day. To receive information on the balance of goods for another date, specify it in the field View balances by date and press the button Refresh .
You can open multiple different windows with a report, for example, with different products.
To get information about the balance of a certain product, just type its name in the field Search by product .
From this report, you can open a report on the movement of goods and balance sheet.
If the report is generated for past period, then it displays all products, even deleted ones, if their balance on the selected date was non-zero.
To select the warehouses for which you want to get data, click the button Stock and in the list that opens, check the boxes next to their names (by default, all warehouses of the enterprise are selected).
Reporting data can be drilled down by warehouses or item groups: the View button is used to select a report option.
The balance report can be customized:
- Sort data by most parameters (or several parameters at the same time),
- Perform grouping, including multilevel,
- Filter data by most parameters (or several parameters),
- Show or hide options.
The report is configured in the same way as other reports in the iiko system, for example, see the description in the Goods and Warehouses section.
Stock control and replenishment
Using the balance report, it is convenient to monitor the availability of all necessary products and ingredients in the warehouse and generate an order to the supplier (invoice) for replenishment.
To control the balance of goods by stock levels in the item View select item Consolidated report. Then the table will display columns with minimum and the maximum number goods in warehouses.
To see which products are running low, in the Remaining Criteria list, select Less than minimum. In this case, only those products, the balance of which satisfies this restriction, will remain in the report.
Similarly, a report on goods, the quantity of which is excessive, is formed according to the criterion More than max .
Previously, the product cards must indicate the levels of stocks: minimum and maximum on the tab Additional Information .
Identification of expired products
Using the report, you can identify and write off products in a timely manner, the expiration date of which has expired at the time of viewing the balances. To do this, the product cards must first indicate the shelf life on the tab Additional Information .
Select from the list Residual criterion in option Expired Products, the screen will display products for which the specified expiration date has passed.
For example, let the shelf life of a cake be two days. The current balance of cakes is 8 pieces. 2 waybills were issued for the goods: yesterday - for 5 pieces, and three days ago - also for 5 pieces.
Thus, there are expired products in the warehouse - the remains of goods from a batch that arrived three days ago.
Correction of negative balances
The iiko system allows you to keep inventory records with the formation of negative balances of goods or dishes in the warehouse. Positions with negative balances are highlighted in red in the report.
However, it must be understood that a negative balance is a signal that something was done incorrectly, or errors are made systematically.
The ability to work with negative balances is determined by access rights and system settings on the tab Accounting settings .
You can open the inventory movement report to find out what caused this situation in the warehouse.
Collation statement
If there were no errors or they have already been corrected, but the negative balance remains, then it must be compensated with the help of collation inventories.
Purchase Invoice
Another way to correct negative balances is to create an incoming invoice for goods that have “gone negative” directly from the Inventory balances report.
Select products with negative balances in the list and in the context menu from the group Negative balances select one of the commands. As a result, you can create:
- Invoice with zero prices (the function is available when viewing balances in any view).
- Invoice with prices at cost (the function is available only when viewing balances in the form of a summary report).
You can also copy information about an item with a negative balance to the clipboard in order to create the necessary warehouse document based on it. This is what the command is for Actions → Negative balances → Copy to clipboard .
The user needs to receive data on the balance of goods in the context of warehouses, and the initial data should be taken from the registers of extended cost accounting for accounting. Appearance The report is shown in the following screenshot.
In order to understand what query needs to be written for the ACS data set, let's consider the structure of tables that store advanced analytics data.
Information sources
Since we will receive the rest of the goods according to the data accounting, then we are interested in the corresponding accumulation register "Cost AccountingRegl". But just like that, we will not get information about the remains of the nomenclature from it. The dimensions of the register are the keys of cost analytics, and not the usual elements of the reference books "Nomenclature", "Nomenclature series" and so on.
An analytics key is an element of the corresponding directory for which various combinations of accounting aspects are stored. The wording is general, so for a better understanding, I will give the following screenshot:
From the figure, we can see that the register dimensions contain directory elements for the corresponding accounting section (type of accounting, costs, batches and distribution of costs). If we make a request to the balances of the "Cost AccountingRegl" register, then we will not be able to set, for example, selection by item or warehouse. We will only have access to selections by the element of the analyst. The latter is very inconvenient.
In order for us to set filters in the usual way, we need to attach information registers to the cost accounting table for each of the analytics sections. Each such information register contains a "Link" resource that refers to the accounting analytics key reference. The values for the dimension key ("Organization", "Warehouse", etc.) are stored in the dimensions of this register.
In the screenshot, I marked the dimensions "Warehouse" in the register "Analytics of Accounting Type" and "Cost" in the register "Analytics of Cost Accounting". The "Cost" dimension stores a link to the item of the "Nomenclature" reference book.
VERY IMPORTANT TO REMEMBER that when receiving only balances by item, and indeed making any report, you need to make a selection for the accounting section in order to get correct data. In our case, you need to set the filter on the "Accounting Section" dimension of the "Analytics of Accounting Type" register by the value of "Inventory" of the "Accounting Sections" enumeration, since it is this accounting section that stores data on stock balances in warehouses.
Request and SKD
And so, the general scheme for storing RAUS data should now be understood at the level in order to write a report on the balance of the item in the context of warehouses. When creating a report on the ACS, we first define the request. I created it as follows:
Request = " SELECT ALLOWED | |PUT AnalyticsBy Accounting Sections |FROM | RegisterInformation. Analytics of the Type of Accounting AS RegisterAnalytics of the Type of Accounting| WHERE | RegisterAnalytics of the Accounting Type. Accounting Section = & Accounting Section |; //////////////////////////////////////////////////////////////////////////////// |SELECT ALLOWED | RegisterAnalytics of the Accounting Type. Warehouse AS Warehouse, | RegisterAnalytics of Cost Accounting. Cost AS Nomenclature, | Cost Accounting Regl Remains. Quantity Remaining AS Remaining |FROM | RegisterAccumulation. Cost AccountingReg. Remains( | , | AnalyticsTypeAccounting | (CHOOSE DIFFERENT | RegisterAnalytics of the Accounting Type. Link | FROM | AnalyticsBy Accounting Sections AS RegisterAnalytics of Accounting Type) ) AS Accounting for Costs | (LEFT JOIN Register of Information. Analytics of Accounting Type AS RegisterAnalytics of Accounting Type | Software Accounting for Costs Regl Remains. AnalyticsAccountingType = RegisterAnalyticsAccountingType. Link) | (LEFT JOIN Register Details. Cost Accounting Analytics AS Register Cost Accounting Analytics | Software Accounting for Costs Regl Remains. Cost Accounting Analytics = Register Cost Accounting Analytics. Link)" ;
In the first query, we get the cost accounting analytics for the "Inventory" accounting section and place the result in the "Analytics By Accounting Sections" temporary table. Next, we make a request to the virtual table of balances of the accumulation register "Cost Accounting Regl", in the parameters of which we specify the selection condition for the analytics of the type of accounting for the values located in the temporary table "Analytics By Accounting Sections".
Now the most interesting thing - we attach the information registers "Analytics of Accounting Type" and "Analytics of Cost Accounting" to the balance table:
As selectable fields, we set the "Cost" field (Nomenclature" from the "Analytics of Cost Accounting" information register and the "Warehouse" field from the "Analytics of Accounting Type" information register. The quantitative indicator of the balance is stored in the "Quantity" resource, which we take from the accumulation register "Cost Accounting Regl".
Don't forget to set the value of the "Accounting Section" parameter to "Enumeration.Accounting Sections.MPZ" on the "Parameters" tab of the data composition scheme.
Result
As a result, we received a working report on the balance of the item, using the register of advanced cost accounting analytics. Of course, it does not have extensive functionality (characteristics, organization cuts, and so on), but as an example explaining general principle development of reports for RAUS - just right.
Goods balance report shows the balance of the goods on the specified date, taking into account all movements of the goods (income/expenditure).
Documents affect the arrival of goods:
Section Sales
- Returns from buyers
Purchasing section
- Income
Section Warehouses
- Entering inventory balances
- Goods posting
- Equipment
Section Retail
- Returns from retail customers
Documents affect the consumption of goods:
Section Sales
- Shipments (Sales)
Purchasing section
- Returns to suppliers
Section Warehouses
- Write-offs of goods
- Dismantling
Section Retail
- Cash receipts
Placement of a report on industry interfaces
Full interface - section Reports.
Wholesale (simple and advanced) - Analytics section.
Services (advanced) - Analytics section.
Trade + Online store (advanced) - Analytics section.
Online store + Retail (advanced) - Analytics section.
Report filters
1. Date - specify the date for which you want to view the balance of goods. If the date filter is empty, the analysis includes the entire period.
2. Warehouse - specify one or more warehouses for which you want to check the balance of goods. If the filter is empty, then the balances from all warehouses will be included in the calculation. In order to see the balance in the context of a specific warehouse, click on the line with the desired product.
3. Retail outlet - specify one or more retail outlets for which you want to view indicators. If the filter is empty, then the report will include transactions for all retail outlets.
4. Group of goods - specify one or several groups for which you want to view indicators. If the filter is empty, then the report will include balances in the "All goods and services" group.
5. Product - indicate one or more specific products for which you want to see the balance. If the filter is empty, then all products will be included in the report.
6. Price types - specify one or more price types that you want to display in the report. Attention! You can only specify the "Sale" price type. It will be useful if a report is required indicating current selling prices.
7. Product characteristics - specify one characteristic and its value in a separate filter field Value of the characteristic by which you want to view the remaining goods.
8. Residuals - Select one of the 5 options for the report: 1. All - shows absolutely all residuals: positive, negative, zero and non-zero. 2. Only positive - shows only the product whose balance is strictly greater than zero. 3. Negative only – shows only the product whose balance is strictly less than zero. 4. Only non-zero - shows only the product whose balance is strictly greater and less than zero. 5. Only zero - shows only the product whose balance is strictly equal to zero.
Report Options
1. Show reserve. This parameter will display the quantity of the reserved item in the report.
2. Show serial numbers. This parameter will allow you to reflect the balance of the goods in the context of a specific serial number.
3. Show modifications. This parameter will allow you to reflect the balance of the goods in the context of specific modifications.
4. Show products from the archive. This parameter will allow you to reflect the remains of the goods that are currently in the archive.
reserves
Business.Ru implements the functionality of reserving goods for a specific order or counterparty. In order to view which product and which order/counterparty is assigned:
1. Generate a report with the "Show reserve" parameter set.
2. In the generated report, an additional column "In reserve" will appear in the "Balance" column.
3. This column reflects the total quantity of goods that is currently in reserve.
4. In order to see which order/counterparty the reserve is assigned to, next to the desired product, click on the value of the reserved quantity (it is interactive).
5. You will see the window "Reservation of goods", in which it is described in detail on the basis of which document and in what quantity the goods are reserved.
Calculation of indicators
1. Remainder. Calculated based on the movement of goods in the specified period. All documents affecting the receipt / consumption of goods are taken into account.
2. The cost per unit of goods is calculated based on the balance of lots that are currently in stock. If the warehouse currently has a balance of different batches, then the cost will be calculated according to the formula (the sum of the cost per unit of goods of all batches) / (number of batches). For example, there were 2 receipts of goods with a unit cost of 10 rubles. and 20 rubles. If the first batch was completely sold, then the report will show the cost of 20 rubles. for a unit. If both batches are still in stock, then the report will show the unit cost of 15 rubles.
3. The total cost is calculated according to the formula (the balance of the goods) * (the cost per unit).
Report generation
After you have specified all the necessary filters, click the "Generate Report" button. A dialog box will appear in front of you.
This message indicates that the report will be generated in the "Background". This will allow you to continue working in the system. After the report is generated, a notification will appear in the upper right corner.
If you haven't left the report page, press the F5 key on your keyboard to refresh the page. After the page is refreshed, you will see the requested report.
Setting permissions
There are 3 types of access rights restrictions in the report:
- Restriction on viewing and printing the report. Using the permissions setting (Administration section), the user can restrict access to viewing the report or only printing it.
- Organization restrictions. If the user has limited access to organizations, then when generating the report, the documents of those organizations to which the user does not have access will not be taken into account.
- Warehouse limitation. If the user has limited access to warehouses, then when calculating the cost indicator, goods that were shipped from warehouses to which the user does not have access will not be taken into account.
Report Remaining goods is designed to obtain information about the current balance of goods in warehouses. The report displays information about the product, its article number, sale price, last purchase price, the balance and its cost at the purchase price and at the sale price.
The report opens from the menu Functions on the button, then you need to press Remaining goods, or from the desktop by pressing the button:
Remaining goods
The report can be filtered by product or product group. This is very convenient when, for example, you need to view the balance of goods only for a specific product group. To set a filter, you need to click the button at the top right of the report (or the button and select the Filter item in the menu that appears) and select one of the options:
- Product selection;
- Selection by product group;
From the list of products and services that appears, select the product (group of products) by which the report will be filtered.
To clear the display filter, click the button.
The report data can also be sent using methods available to the mobile device or printed on a printer. To do this, click the button at the top right of the report and select the item in the menu that appears. Send or Seal.
In the menu item Settings You can choose which columns to display in the report. This is very convenient if, for example, you need to view only specific information about the products included in the report.
Within the "Inventory management" interface, you can find out the balances in warehouses, as well as income and expenditure 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 "Purchase Management" interface, "Stocks" 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, in the date cell you need to enter the date of the first of January.
The shape of the table will depend on the Row Grouping options. If you select the word “hierarchy” in the “Nomenclature” line, then the positions will line up in order: for example, first sheets, then pipes, then hardware, etc. To get a general report on the balances in 1C, you should select the word "hierarchy only" - only amounts without decryption will be shown. Grouping by warehouses is done in the same way.
To get information only on specific warehouses or groups of goods and materials, you should pay attention to "Selections". If you select "In the list" as the type of comparison, then in the "Values" column you can specify the necessary warehouses, item groups.
The table that the program displays in the framework of "Goods in warehouses" contains data only on the number of materials. If you need to get information on cost and prices, you need to switch the interface to "accounting and tax accounting". Here, select the tab "Accounting", "Turnover balance sheet" and in the settings specify the account 10. Similarly, the period, grouping (detailing), selections are selected. Such a 1C report on balances looks different, it indicates the total cost of goods and materials and the quantity.
Another way to see the balances in 1C is to refer to ready-made program templates. They are available in any interface; to search for them, you need to select the tab "Service", "Additional reports and processing", or "Custom reports". There are also templates created specifically for specific tasks IT-service of the enterprise or specialists in 1C. For example, sometimes a report showing the date of the last arrival of goods and materials or the warehouse number is useful.
Related videos
Getting started with bookkeeping software"1C: Enterprise" you need to perform the initial settings of the application and make account balances. At the same time, 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 the auxiliary account 00.
Instruction
Determine the start date for computer accounting. This may be the beginning of the month, quarter or reporting year, depending on the adopted accounting policy enterprises. Set a working date, i.e. date of entry of balances. It must be earlier than the start date. For example, the last day of the previous reporting period.
Set the accounting period. To do this, go to the "Tools" menu, the "Options" section and select the "Accounting totals" tab. The period must be selected relative to the date of entry of account balances so that their analysis is carried out either at the end of the period or at the beginning. Perform a complete recalculation by selecting the "Manage accounting totals" section from the "Operations" menu.
Enter account balances. Postings on analytical accounting objects and balance accounts, as well as sub-accounts, must be entered in correspondence with account 00 “Auxiliary”, and balances on off-balance 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 the correctness of entering account balances 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. The balances were entered correctly if the debit amount is equal to the credit amount. If a non-zero balance was formed in the reporting on account 00, then errors were made during the entry.
They need to be fixed by running the "Detail" command, which expands detailed information about report options. To edit, click the "Open document" button, make corrections, then close all windows except the desired report, and double-click the "Update" button.
Related videos
Before entering incoming and outgoing invoices into the database, you need to reflect in the 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. It is most convenient for accountants to keep records of goods in the program "1C: Trade + Warehouse", the configuration of which allows you to fill in the table "Inventory of goods and materials" using the report "Remains of goods and materials".
Instruction
Start setting up the report "Remains of goods and materials" and call the processing of the tabular part "Inventory of goods and materials" from the dialog. This can be done in any of two ways: using the "Inventory" button or the "Fill" button in the "Inventory of goods and materials" document, selecting the "Fill from the report" tab in the menu. After that, you need to fill in the table from the inventory document, which contains the report "Remains of goods and materials" for the group of goods you need.
Select the warehouse where , and specify a specific group of goods for which the balance check is carried out. Keep in mind that you can select products by their properties. In addition, with the help of a multiple filter, it is possible to create an arbitrary list of products.
Set the "Balances" filter to the "All non-zero" option in the "Including reserve" feature. 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 without VAT". This will make your task easier. However, if the inventory is carried out in a retail warehouse, the position should be set to “Selling price (only)”, because in such a warehouse it is carried out at the same retail prices at which the goods in the retail warehouse are taken into account.
Click the "Inventory" button when you have completed all the necessary settings. In automatic mode, the document “Inventory of goods and materials” you need will be generated. If you have selected a wholesale warehouse, the type “Inventory (by warehouse)” will be set for the compiled document. If you have specified a retail warehouse, then the view will be indicated as "Inventory (by )". The table in the document will contain the balance of goods in accordance with the settings that you set in the report "Remains of goods and materials".
Enter in the "Inventory" all the actual data on the goods in the warehouse. Next, draw up the documents “Write-off of goods and materials” or “Record of goods and materials”, depending on whether you need to reflect the shortage or enter a surplus of goods.
Related videos
Sources:
- stock balance in 2019
1C today is a popular program in an enterprise, in a commercial organization or firm. This is a comprehensive convenient solution for organizing personnel, financial, accounting and material accounting. "1C: Trade Management" makes it possible to control and record absolutely all purchase and sale transactions in the 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".
Instruction
Purchase and install the program "1C: Trade Management" and enter all your data into it. If "1C: Trade Management" is already available and in use, just run it on your computer. To do this, just click on the appropriate shortcut on the desktop.
Open the desired database in "1C: Trade Management". Go to the "Documents" menu to enter balances. Then enter the "Sales" item by selecting the appropriate tab. Select the "Debt Adjustment" option.
In addition to the above method, you can open a document for entering balances using the following transition: "Documents" - item "Purchases" - "Debt adjustment".
Look at the document journal 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 "Contractor" field.
Enter required amount agreements in the tabular part of the document, as well as in the corresponding field the currency and the amount of the debt. 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 debt of the counterparty to the enterprise. Click the "OK" button and enter the balance of goods as of the beginning of the year. To do this, set the working date to 1C before starting to enter balances for the last month that precedes the start of the accounting period. In our case, this is December.
Select "Tools" - "Options" from the menu. Set the desired date and save the information by clicking "OK".
Create a document "Receipt of goods" to enter all the balances of goods in warehouses. To do this, you must perform the following steps.
Go to the "Documents" menu, select "Stocks (warehouse)". Proceed to the item "Receiving Goods". Click the Add button.
Select the "Base" field and enter "Entering initial balances", then the item "Prices and currency" and in it mark the type of prices "Purchasing". Click on the "Selection" button and check the boxes next to the "Quantity", "Price", "Characteristics" fields.
Select necessary element and specify the options. Add all products. Exit the nomenclature window by pressing the "OK" button.
Related videos
Sources:
- rent 1C
Before entering expenditure and receipt invoices into the database, it is necessary to reflect the current balance in the warehouse in accounting. Trade balances are entered on the date that precedes the start date of the period.
Instruction
Run the report in the program "1C: Trade + Warehouse", which is called "Remains of goods and materials". Having started its construction, you will call the processing of the table "Inventory of goods and materials" using the dialog boxes. You can do this in two ways: by clicking on the "Inventory" button or using the "Fill" button in the document called "Inventory of goods and materials". Select the Populate From Report tab from the menu. Next, fill in the tabular part of the inventory document containing a report called "Inventory balances" for your group of goods.
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. note that you can select products by their properties, and using a multiple filter, you can create a list of products randomly.
Set the value "All non-zero" in the filter "Remains", which is in the feature called "Including reserve". Then the inventory will take into account all real balances, excluding the 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". Thus, you will simplify the implementation of the task. Keep in mind that if an item is being inventoried in a retail warehouse, you need to set the position to “Selling price (only
To display account balances in 1C, you need to generate a balance sheet and select the necessary settings. This is the period for which you need to show the turnover, account or sub-account number, detailing parameters. In the "selection" you can specify warehouses, item groups or other limiting factors. For example, to generate balances on account 10 "Materials", in this tab you should select the necessary warehouses "in the list" or one necessary warehouse "equal to".
Sometimes it is convenient to display only the general data on the account in 1C, in this case, in the settings, you must select "Hierarchy" or "Only hierarchy". In the first case, materials grouped by product groups "Black sheet", "Stainless sheet", "Circles", etc. will be displayed, and in the second case only the total amounts for these groups will be displayed. When transferring a table to Excel or a similar program, it is important to take into account that the sums by elements add up to the sums by subgroups, and they are all indicated in one column - therefore, when setting the “Total sum” formula, the program will simply double the total.
The "Purchase 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 on the account will be displayed with an indication of the price. Important - here the cost will be with 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 right positions. 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, you need to make a selection in the "Nomenclature" cell. To do this, set the parameter “in the list” or “equals”, then click “…” in the selection field. Here, select the material by successively “traveling” through the menu, or write in the “contains” field known information - steel grade, standard size, marking, etc. To form the list, you must click the "hierarchical view" button at the top of the window. Having selected the required element, generate a report on it - balances at the beginning and end of the period, movement.
