Sections of the site
Editor's Choice:
- Object method not found for the nearest tax period
- Accounting info Uploading VAT from 1s 8
- Check z report. Operations with cash register. Innovations related to the implementation of online cash registers
- Production cost of production Calculate preliminary cost using a regulatory task
- Global module 1s 8.3. General modules. External Join flag
- Changing registers in 1s 8
- The difference between “1C: UPP” and “1C: BP”
- English alphabet for children - How to learn the alphabet quickly and fun
- The most common elements in living organisms are
- How to build a relationship with a Taurus man How a relationship with a Taurus man will develop
Advertising
Cost calculation in UT11, or where did batch accounting go? Production cost of production Calculate preliminary cost using a regulatory task |
In the configuration for 1C: "Trade Management" in edition 11, instead of the usual batch accounting, the so-called RAUZ appeared, or, more correctly, in terms of UT: keeping records of the cost of goods by type of inventory. To begin with, it’s worth telling what it is ROUSE and where he came from. RAUZ - advanced cost accounting analytics. This mechanism first appeared in the SCP and Integrated configurations in 2008. It provides for storing information about goods (products) and costs in one register (or rather, in three instead of 32 for UPP - taken from here) and not in the context of batches, but in the context of an accounting analyst, which speeds up the calculation and determination of the total cost of goods (final products). This calculation does not occur at the time of sale (write-off) of the goods (products), but as a separate processing (document) just to take into account all costs and speed up this process. In the UT11 configuration, this term (RAUZ) is not used, because as such “cost accounting” is not provided (more precisely, it is provided, but not in the same volumes and in that sense), but the basis remains: 1. The number of registers has decreased compared to UT10.3 Was 18: Costs, VATLots of Goods, VATPresented, VATPresentedRealization0, VATAccrued, = VATIndirectExpenses, VATSales0, Lots of GoodsInWarehouses, LotsofGoodsTransferred, Sales, SalesOnDiscountCards, SalesCost, SoldGoods, GoodsVNTT, GoodsV ReserveInWarehouses, GoodsInRetail, GoodsInWarehouses, GoodsOrganizations. Now 4: Revenue and Cost of Sales, Free Remains, Cost of Goods, Goods in Warehouses; 2. The cost price is calculated not at the time of writing off the goods, but in a separate document, a regulatory task; All this, of course, is good, but it is worth saying that for Integrated or SCP, where various costs, production and complex cost calculations are used, RAUZ is an indisputable advantage, but for Trade Management, where in principle everything is quite simple - bought, sold, managed accounting by type of inventory becomes quite a problem. When managers cannot track the gross profit of sold products in real time, this is not very good, especially since it is worth saying that in UT10.3, to speed up the process of processing documents, it was possible to process documents by batch not in real time, but by separate processing! Comment: Enable the ability to use batch accounting only in UPP. In the Integrated accounting settings, there is also an option to account for goods, by batches, BUT the cost price in this case will not be formed at all. There is no such option in UT11. Let's move on to setting up accounting in UT11. You can enable separate accounting in the Administration subsystem on the Finance tab. If the " By department or manager", for each Division (Regulatory reference information - Enterprise Structure), you need to indicate what exactly records will be kept for this division. Important: These are very interesting parameters; if you set them by division managers, then only the manager who purchased them will be able to sell the product; if you set it by department, then you can sell goods only from the department for which it was purchased (there is no standard mechanism for moving goods across departments). Sign " By financial accounting groups" allows you to specify additional analytics for financial accounting of settlements with suppliers in receipt documents, then you will also need to indicate this analytics in sales documents. The trait " Deal", makes it possible to indicate transactions upon receipt of goods and their sale. The most necessary and non-binding sign is " By supplier", the partner (supplier) is indicated in the Receipt document, and is determined automatically upon sale. Important: refilling of inventory types in a document occurs only at the time of posting if:
And also, the types of records are automatically refilled in all documents when setting or removing the sign of maintaining separate accounting in the settings . Conclusion: simply reposting documents will not repopulate the inventory types in the documents! After setting the necessary characteristics, at the time of goods receipt, the corresponding elements of the Inventory Types directory will be created, which will act as batches, and when writing off (selling) the goods, these types of inventory, depending on the specified details, will be automatically determined and substituted in the document. You can view the selected inventory types by clicking on the "Open inventory types" button on the PM document toolbar. After the goods have been capitalized and sold, it is worth determining our profit from the sale. For this purpose, there is a document “Cost Cost Calculation” (Finance Subsystem - Regulatory Documents). This document has 2 options for its formation: preliminary and actual. At preliminary calculation the operational cost is formed (not full): additional costs are not taken into account. expenses, the cost of sales is not adjusted depending on the adjustments of the previous period, revenue is not distributed among the organization’s activities, and rounding errors are not written off. Advance paynemt needed specifically for managers who need to see the cost of products sold in real time. But there is no way to obtain it in real time, and it is possible to carry out this document automatically through a routine task. For it to work, you must: in the settings of methods for estimating the cost of goods (located in the organization card on the left in the navigation panel "Methods for estimating the cost of goods"), set the attribute " Update with a routine task". Then, in the settings of routine tasks (Administration - Support and Maintenance - Routine and background tasks), find "Cost cost calculation", make sure that it is used and set a schedule for it. Actual calculation must be done manually at the end of the month. To do this, you need to set the appropriate attribute in the “Calculation of Cost” document and carry it out. Now you can generate a gross profit report. From the outside it seems that everything is beautiful, but if you try to get the cost in terms of sales documents, you will get the picture: This leads to the conclusion that it is not possible to obtain the cost price in the context of sales documents in UT11.0.8.11 using standard means. P.S. The column “Additional expenses” in the Gross Profit report and the documents “Distribution of expenses for the cost of goods” and “Distribution of expenses and income” deserve special attention, but this is in a separate article, as well as the tricks of calculating the cost and pitfalls in the cost of UT11. The write-off cost can be calculated both for a month and for a certain period of time through the document “Calculation of the cost of goods”. You can also calculate through the monthly closing assistant. Note. The cost is calculated for each warehouse separately.
(balance (of cost) at the beginning of the month + receipt (of cost) during the month) / (balance of quantity at the beginning of the month + receipt of quantity during the month) = cost
(balance (cost) at the beginning of the month + receipts (by value) during the month) / (balance at the beginning of the month (quantity) + receipts during the month (quantity)) = cost price of absolutely any batch for the selected month
Practice of calculating cost in 1C:UT 11.1:Method one. The simplest one is to create the document “Sales - Documents for calculating the cost of goods” at the end of each month. Method two. Through “Administration - Support and maintenance - Routine and background tasks - Cost calculation - Run now.” You can also configure a scheduled task to run automatically once a month. Rice. 1
Rice. 2 How to perform the cost calculation procedure:1. Right-click on the cell with the red number (in the “Gross Profit” column), then “Decrypt”. There you need to select “Registrar” - you can see what documents the movements were made with. 2. We look at the accumulation register through the menu: “Menu” - “Service” - “Options” - “Display the “All functions” menu”; Go to the menu “All functions” - “Accumulation registers” - “Goods in warehouses (or goods of the organization), or “Cost of goods”. If you perform a selection by nomenclature and characteristics, you will see at what price it was purchased (the “Receipt of goods and services” document, or entering opening balances), and at what price it was sold; Rice. 3 Rice. 4
Rice. 5 Note. Currencies are divided in 1C:UT into the currency of management and regulatory accounting mainly for the formation of accounting documents in the program: book of purchases and sales, etc., but if they are the same (rubles), then there will be no difference in the reports, depending on the choice of currency. Back Up The mechanism for offline (non-operational) cost calculation, movement through cost registers, general information. Starting with ERP version 2.1.3 (and the corresponding versions KA and UT), two types of movement are distinguished:
For a list of registers maintained by the cost calculation mechanism, see Outgoing Mechanism Data() The recorder of settlement movements is now the primary document (from the Movement Document attribute), and not the Calculation of Cost of Goods document. The document Calculation of Cost of Goods no longer makes movements in the following registers: Revenue and Cost of Sales, Purchases, Other Expenses of Work in Process (available only in ERP and KA) (the document remains the registrar for these registers for backward compatibility). When reposting documents, settlement movements are saved, regardless of changes made to the document (For this purpose, a special code is placed in the module for a set of records of maintained registers. For an example, see the accumulation register module Cost of Goods - calls to procedures of this module.). Changes in the document will be taken into account in the calculation movements when recalculating the cost. Starting with version ERP 2.1.3, the algorithm for generating and recording movements has changed.
These changes allow you to:
Transition to ERP version 2.1.3 (and corresponding versions KA2 and UT11) When switching to a new version, previously generated settlement movements are not automatically changed, Start cost calculation. The entry point to the calculation algorithm is the procedure CalculateAll() into which the parameters are passed:
Original description // Start cost calculation. Before the calculation, a document Calculation of the Cost of Goods will be generated for each organization (if it did not already exist) with the following filling:
To perform the calculation without crashing in case of an error, there is a wrapper function CalculateAllAtTryException() parameters are similar to the CalculateAll() procedure, but the function returns a value - Boolean - a sign of successful execution of the calculation. Performing cost calculations. Direct calculation is performed in the function Calculate Cost By Group of Organizations()
Structure of the calculation stage. Schematically, the calculation procedure looks like this:
Accessing information security data in queries. Since new settlement movements in cost registers are recorded in IS only at the end of the calculation,
For convenience, for some registers this data is automatically cached in the temporary table VTKashRecords<Имя регистра>. 2. Register balances (for balance registers) at the end of the period should be obtained by combining:
For convenience, for some registers this data is automatically cached in the temporary table VTKashCalculatedBalances<Имя регистра>. 3. New movements generated at previous stages of calculation are stored in the temporary table VTKash<Имя регистра>. There are also a number of additional features of working with queries (reasons: optimization, platform, etc.). 1. The data used for selections in all requests of the calculation mechanism is stored
To set these parameters, use the universal procedure InitializeRequestProperties() 2. There is a Platform error 30025997, which causes problems with the Movement Type field in temporary tables.
Debugging and troubleshooting. To facilitate development, testing and troubleshooting, a mechanism for logging calculations has been implemented (see procedures of the type Calculation Protocol_...) which is processed in the following steps:
It is also possible to override some calculation parameters (see CalculateAll(), Debugging Parameters parameter). P.S. This article will be most useful for programmers. It was based on the comments of 1C programmers in the 1C: Enterprise: “Trade Management” solution, edition 11.2.3. The article is written in FAQ form and is ideal for users who do not want to delve into multi-page descriptions of various cost calculation methods. In this article, we will look at what valuation methods there are and what their features are, what accounting analytics are possible and where they are configured, what documents need to be drawn up in the system, and how they affect the cost calculation. Additionally, we will consider options for accounting for material and equipment, distribution of costs and possible errors in calculating costs. The course “UT 11 – Quick Start” was taken as a basis, and materials from webinars and training manuals were also used. ApplicabilityThe article was written for the editors of 1C: Trade Management 11.0 . If you use this edition, great - read the article and implement the functionality discussed. If you plan to start implementing UT 11, then, most likely, a more recent edition will be used - keep in mind that the cost calculation errors have already been corrected, and the functionality will differ slightly. Therefore, we recommend taking the course Practical tasks of level 1C: Specialist in UT 11, KA 2 and 1C: ERP 2, this will help you avoid mistakes and loss of time/reputation. Cost calculation in "1C: Trade Management 11"What methods of estimating the value of goods upon disposal can be used in UT 11?You can choose one of two methods for estimating the cost of goods upon disposal - average for the month, FIFO. Where to indicate the method used for valuing goods upon disposal?Finance -> Setting up cost estimation methods. The setting is set for each organization from a specific date. Where is the introduced method of valuing goods upon disposal used?In the document “Calculation of the cost of goods” (Finance -> Regulatory documents). Can be changed directly in the document. What are the features of the “FIFO” method in UT11?
For what objects of analytical accounting can the cost of an item be taken into account separately?The cost of an item can be taken into account separately for the following objects of analytical accounting: warehouse, financial accounting group, division or manager, transaction. Where to define analytical accounting objects for which the cost of an item can be taken into account separately?Administration -> Finance -> Separate accounting. In the context of a warehouse, cost calculation is always carried out. Separate accounting is carried out using both the FIFO method and the average method. Why is the amount of written-off cost not indicated when posting documents for Sales?Implementation documents make movements only by quantity. The cost price will be calculated using the document “Calculation of the cost price of goods”; movements in the cost price will be made using this document. It turns out that the quantity is written off by one document, and the cost by another. What regulatory documents must be entered to calculate the cost and obtain a financial result, what is the sequence of documents?To correctly calculate the cost, you must enter documents in the following sequence:
How often do I need to enter the Cost Calculation document?Within a month, we will be introducing the “Cost Cost Calculation” documents with the “preliminary” option. At the end of the month, we enter the “Cost calculation” document with the “actual” option. Documents can be entered for each organization. If there is resale of goods between organizations, then such organizations must be entered into one document. Is it possible to calculate cost automatically according to a schedule?You can, for this you need to set up a routine task (Finance -> Setting up methods for assessing the cost of goods -> Update the cost with a routine task); Administration -> Scheduled and background tasks, add the “Cost calculation” task to the list of active tasks, set up a schedule. Why was the “preliminary” cost calculation method introduced in the document “Calculation of the cost of goods”?The “preliminary” calculation mode was introduced to increase performance; writes to some registers are not made. The “preliminary” cost is calculated, which at the end of the month will be calculated exactly in the “actual” mode. What is the difference between a “preliminary” cost calculation and an “actual” one in the document “Calculation of the cost of goods”?The cost is always calculated according to the “average”, regardless of the method specified for the organization. The calculation is carried out using a simplified method (TZR are not distributed). The movement occurs only in the Cost of Goods register, the reference value of the cost calculated by the average cost method is recorded, the detailing of the cost is carried out according to the measurements of the Cost of Goods register. The data storage period is one month. Movements in this register are formed by both the preliminary and actual cost calculation options. Movements in the registers Cost of goods, Revenue and cost of sales, Other expenses are not formed. In which reports can you analyze preliminary cost?
Possible UT11 errors when calculating costs and methods for correcting themThe reason is that the system “remembers” the previously written off “Inventory Type” when the document is first posted and records it in the “Inventory Types” tabular section (the “Inventory Types” tabular section is not cleared during any actions with the document). Elimination method: before running the “Cost Cost Calculation” document, clear the tabular part “Types of Inventory” of the “Sales of Goods and Services” document. When incoming documents are changed “retrospectively” (change in document date) in the Sales document, a batch of goods is written off not in accordance with the FIFO method (if it is set in the “Cost Cost Calculation” document). Reason - the system determines which batch to write off according to the information register of the Date of Receipt of Goods of the Organization. When changing the date of a posted receipt document, the Receipt Date in the register of information about the Date of Receipt of Goods of Organizations changes only when the new date is greater than the previous one. Thus, if the document had a date of 03.01 - in the register Date of receipt = 03.01, change to 04.01 - in the register Date of receipt = 04.01, change to 02.01 - in the register Date of receipt = 04.01. Correction - deletion of records on inventory items from the register of information on the Date of Receipt of Goods of Organizations and re-posting of documents. When incoming documents are changed “retrospectively” (change in document date) in the Sales document, a batch of goods is written off not in accordance with the FIFO method (if it is set in the “Cost Cost Calculation” document). The reason is that if there were several receipts during the period with the same measurements in the “Cost of Goods” register, then the system considers the latest receipt date to be the batch date. Thus, if on the 1st and 10th there was an arrival of 10 pieces and 20 pieces. goods with measurements according to the register Cost of goods SbTv1, and on the 3rd there was an arrival of the same goods 10 pcs. with measurements according to the register Cost of goods SbTV2, then when this product is sold on the 15th in a quantity of 10 pcs. The batch of the 3rd date will be written off, because MAX(1,3)=3 on SatTV1. When you change the cost accounting pegging setting, there are already entered receipt documents. What to pay attention to when changing separate accounting settingsWhen you change the pegged accounting settings, the Inventory Type analytics changes. In many documents, this analytics is filled in when the document is posted, recorded in the document details, and does not change when the document is re-posted. Is it possible to include the cost of technical equipment in the cost of goods?Yes, it is possible, but the amount of TZR is stored in a separate attribute of the Cost of Goods register – Amount of Additional Expenses. Is it possible to distribute goods and materials to the cost of inventory and materials of the current period if the documents for them arrived in the next period (the goods were received on 01/25/13, and delivery documents from the transport company were issued on 02/05/13)?No you can not. Documents of receipt of goods and materials and goods and materials must be in the same period. Is it possible to automatically distribute the delivery of goods to several receipt documents or to an item list?No, you can’t, such distribution must be done manually. For each receipt or item, enter a separate line and calculate the amount manually. Is it possible to allocate additional costs to a specific document Assembly (disassembly) of goods?No you can not. It is possible only for the nomenclature. If we purchased this item from a supplier, then additional. expenses will be distributed to her as well. But you can take a less obvious route. Enter a separate assembly warehouse, move all components there, enter the Assembly (disassembly) document, move the kit from the components warehouse. Then you can enter additional. expenses for a specific move. What documents are used to document payroll expenses?Document Cash receipt order with transaction type Other expenses. Is it possible to separate in time the reflection of expenses for the payment of wages and the payment of wages itself?Is it possible to automatically distribute additional costs across multiple dimensions?No, you can’t, such distribution must be done manually. For each analytics, enter a separate line and calculate the amount manually. At the end of the reporting period, the system calculates the cost. To do this, use the document Calculation of the cost of goods, with the option installed Actual: In this case, you can specify the cost calculation method - Monthly average, FIFO (weighted valuation), FIFO (rolling valuation). The cost can also be calculated in advance; the same methods are available: Cost calculation can be performed with isolation of the financial result according to specified analysts. They must be set in the system in advance, before use. If the functional option is enabled, then the financial result is separated by orders; but you can also specify additional distribution options: Question 13.33 of exam 1C: ERP Professional Enterprise Management 2.0. Preliminary calculation of the cost of goods is carried out using the following methodology:
Verified. The correct answer is the first one. In general, all options are available, but according to the answers to the test, the preliminary cost is calculated only by the average. Question 13.34 of exam 1C: ERP Professional Enterprise Management 2.0. When setting up an organization's accounting policy, the following can be selected as a cost calculation method:
Question 13.36 of exam 1C: ERP Professional Enterprise Management 2.0.
Question 13.37 of exam 1C: ERP Professional Enterprise Management 2.0. The financial result can be isolated:
Question 13.35 of exam 1C: ERP Professional Enterprise Management 2.0. If there are intercompany sales, the cost calculation method should be:
Question 13.38 of exam 1C: ERP Professional Enterprise Management 2.0. You can view the financial result taking into account segregation in the reports:
|
Read: |
---|
Popular:
New
- Accounting info Uploading VAT from 1s 8
- Check z report. Operations with cash register. Innovations related to the implementation of online cash registers
- Production cost of production Calculate preliminary cost using a regulatory task
- Global module 1s 8.3. General modules. External Join flag
- Changing registers in 1s 8
- The difference between “1C: UPP” and “1C: BP”
- English alphabet for children - How to learn the alphabet quickly and fun
- The most common elements in living organisms are
- How to build a relationship with a Taurus man How a relationship with a Taurus man will develop
- Marriage in the Russian Federation and everything you need to know about it