Buhoblik info. Buhoblik info Accounting 3.0 carry out negative goods

This article is intended for 1C professionals – and especially for those who are preparing for 1C Certification: Documentation from the platform.

We'll figure it out today 2 methods for controlling surplus - not just excess in the warehouse, but, for example, frost damage (“how exactly is the client’s engagement and how can you improve your products”)

Both methods are established in standard configurations and certification data. I fragments of two – It is necessary to clearly understand whether Zastosov’s technique is “new”, and when only it is “old”.

This is basic knowledge for 1C programmers, it is recommended not to remove clearings in such areas. You may have a drink on your birthday 15 hvilin :)

Statement of the problem

Let’s take a simple configuration with the documents “Receipt of goods” and “Sales of goods”:

To deposit surplus funds, the accumulation register “Vilnija surpluses” is opened:

At the hour when the document “Reliability of Goods” is completed, the following rules are written:

Processing Procedure(Vidmova, Mode)

For skin TekStrokProducts Z Products Cycle
Rukh = Ruhi.VilniZalishki.Addati();
Rukh.ViewRukhu = ViewRukhuAccumulation.Arrival;
Rukh. Period = Date;
Rukh.Nomenclature = TechRowProducts.Nomenclature;
Rukh.Quality = CurrentRowProduct.Quality;
KіnetsCycle;

KinetsProcedures

Processing of the document “Reliability of Goods” is submitted to the additional designer of rukhivs and is not of interest, since when entering the warehouse, control of surplus is not required.

Another way to control surpluses is to implement the document “Reliability of Goods” - so that at the same time the execution and re-conducting of the document does not create a negative surplus.

For example, 10 new LG TVs arrived at the warehouse, 6 of them were sold. The document contains 10 pieces. vipraviti 5 pcs. - A negative surplus of “minus 1 piece” is created.

For standard UT 11, such control is enabled with the additional functional option “Control goods by the organization when registering receipts.”

At the hour of completion of the document “Sales of goods” it is necessary to organize control of surplus. If there is not enough product on surplus, the document is not carried out and diagnostic information is provided. Whose place is lying in ruins.

We are aware that we are working on simple tasks, if the liability is not insured when written off. Let us focus on the nuances of surplus control.

Note- Algorithms for decomposition have been brought down to make it as reasonable as possible.
They can be optimized, but the “intelligence coefficient” will be lower, so in this statistic we do not focus on anyone.

Of course, you can optimize them yourself, or take our course with accelerated optimization of 1C :)

As you have already realized, the task can be solved in two ways. Let’s talk about the methods that have been discussed since hours ago “1C:Enterprise 8.0”.

Old method of controlling surplus

The principle of the old method of controlling excess attacks: We check that there is a surplus of goods at the required quantity. If it is written off, if it is not – we inform about the pardon.

The algorithm of the old method consists of several blocks:

1. It comes out with surplus goods and document data
2. The cycle includes control over the sufficiency of goods
3. If there are insufficient goods, the document will not be processed
4. If there are enough goods, the ruhi-vitrata is marked

The axis looks like this in the program code:

// 1. Clearing old registry files
Ruhi.VilniZalishki.Write = True;
Ruhi.Write();

// 2. Separate the document data and excess register data
Zapit = New Zapit;
Request.Text =
"VIBRATI

|POMISTTI Products
|З
|DE
| Products.Posilannya = &Posilannya
|GROUP BY
| Products.Nomenclature
|INDEXUVATI BY
| Nomenclature
|;

| VIBRATE
,
| DUTY POSILANNYA (Products. Nomenclature) YAK Nomenclature Statement,
| Products.Kilkist YAK Kilkist,
| Є NULL (Zalishok. Quantity of surplus, 0) YAK Zalishok
|З
| Products YAK
| LEFT CONNECTION RegisterAccumulation.VilniZashki.Zashki(
| &Moment of the hour,
| Nomenclature B
| (VIBRATE
| Nomenclature YAK Nomenclature
| Z
| PZ Products.Nomenclature = Reserves.Nomenclature";
Input.SetParameter("InstantHour", InstantHour());

// 3. Bypassing the query results

// 4. Checking the availability of goods
Shortage = VibirkaProducts.Quantity - VibirkaProducts.Suspended;
Yakshto Deficit>0 Todi
Vidmova = True;
Announcement.Text = "Product "+SelectionProduct.NomenclatureRevelation+" is insufficient in quantity "+Shortage+" pcs.";
Inform.Inform();
KinetsYakscho;

// 5. Transition to the cob cycle, as soon as there are cuts
Yakshcho Vidmova Todi
Continue to live;
KinetsYakscho;

// 6. Vikonannya rukhiv at the registry
Rukh. Period = Date;

KіnetsCycle;

// 7. Established authority for recording documents at the end of a transaction
Ruhi.VilniZalishki.Write = True;

KinetsProcedures

We comment on the key points of the algorithm.

1. Clearing old registry files

Below in the algorithm will be written to the excess register.

If the current document was previously carried out, then the ability to remove old documents from writing down- This is a serious problem.

Is such a situation possible? If the date of the document collapses forward.

Let's show in practice what it's like:

1. Surplus table lamps 10 pcs.
2. The document is dated 02/16/17, 6 lamps are written off
3. The date of the document is changed to 02/17/17 (the date can be moved forward by up to 1 second), the document is transferred.

If the purification of the archives is not canceled, the system will notify you about the defect of 2 pieces. Why? Moreover, the old document writers wrote off 6 of the 10 existing lamps. Then the system is about to write off 6 more pieces, and on the gratings there are only 4 more.

The problem occurs in line 3 of the code:

• The set of records is being cleared (before reading on the form or previous collectors)
• The "Record" flag is set for the set of records
• The recording of all sets is marked, as the sign “Record” appears

Strictly speaking, we can carry out the purification of the archives during the time of documenting:

We recommend the option of removing the ruks during the process - we do it ourselves if it is necessary to effectively remove the ruks.

2. Separate the document data and surplus from the register

The drink consists of two packages:

• First, the grouped data of the table part appears - the time table is created
• In another entry, before the document data, surpluses are added to the register.

Na scho varto zvernuti uvagu na tsey asks:

1. When a time table is created, the field that will be added to is indexed – this is designed for optimal productivity
2. The moment of removing the surplus - indicates the position of the document on the clock axis
3. There may be surpluses in the register - therefore, the left connected to the “Quality” resource is set to the function “ECTNULL” - NULL values ​​are reduced to zero.

3. Bypassing the search results

The division will ask to place grouped document data and surpluses behind nomenclature items.

The cycle goes through the result of this input.

4. Checking the availability of goods

This means there is a shortage of goods.

If the deficit is greater than zero, it means there is no shortage of goods:

• Apparently diagnostic information
• We set the parameter “Vidmov” for processing the value “True”

If “Vidmova” is different from “Truth”, then the result of the document transaction will not be recorded. To put it simply, this is a system command not to process this document.

5. Transition to the cob cycle, as soon as there are cuts

If in the early stages of the cycle there is a beating (Vidmova = Truth), then there is no sense in forming the hand. However, until the database, the stench will not be recorded.

6. Vikonannya of Rukhs at the Registry

Once the verification of the surplus has been successful, we form a ruble-witrate.

7. Establishment of a document for recording documents at the end of a transaction

If this ensign is not installed, then the ruins will NOT be recorded.

For example, the transaction of a document is recorded in a set of records, which is indicated by the “Record” sign.

For the sake of fairness, it is important that setting the option “Record” to a set of records has the same effect - at the option of the document “Recording changes when carried out” the value “Record selections” is indicated:

However, the very meaning of “Record selections” is the de facto standard:

• Here's a look at typical solutions
• It will be set up after the creation of new documents.

Other options - "Record modified" - are outdated and may not be affected in current configurations.

New method for controlling surplus

The new method is based on the following principle: we write off unnecessary goods, and then check whether negative surpluses have been created for the goods of the document. If this is the case, it is necessary to carry out the document carefully.

As you know, the difference in the moment of control of surpluses is important:

• The old technique is to check the solution first, then write it off
• A new technique - we write off the first word, then we check it.

As a result, the program code will look like this:

Processing Procedure(Vidmova, Operation Mode)

// 1. Sequencing the document data
Zapit = New Zapit;
Request.ManagerTeamHourlyTable = NewManagerTeamHourlyTable;
Request.Text =
"VIBRATI
| Nomenclature YAK Nomenclature,
| SUMA(Product.Quantity) YAK Quantity
|POMISTTI Products
|З
| Document.Realization of ProductsService.Products YAK
|DE
| Products.Posilannya = &Posilannya
|GROUP BY
| Products.Nomenclature
|INDEXUVATI BY
| Nomenclature
|;
|////////////////////////////////////////////////////////////////////////////////
| VIBRATE
| Nomenclature YAK Nomenclature,
| Products.Kilkist YAK Kilkist
|З
| Tovari YAK Tovari";
Request.InstallParameter("Posilannya", Posilannya);
ResultRequest = Request.Viconati();

// 2. Formation of rukh_vtrat register
Ruhi.VilniZalishki.Clear();
SelectProducts = QueryResult.Select();
Poki VibirkaProducts.Offensive() Loop
Rukh = Rukh.VilniZalishki.AddatiVitrata();
Rukh. Period = Date;
Rukh.Nomenclature = VibirkaProducts.Nomenclature;
Rukh.Quality = VibirkaProducts.Quality;
KіnetsCycle;

// 3. Recording records in the database
Ruhi.VilniZalishki.Write = True;
Ruhi.Write();

// 4. Query that removes negative excesses from the register
Request.Text =
"VIBRATI
| Nomenclature YAK Nomenclature,
| TAX POSILANNYA (Zalishki. Nomenclature) YAK Nomenclature Statement,
| -Zalishki.Kilkist Zalishok YAK Defetsit
|З
| RegisterAccumulation.VilniyZashki.Zashki(
| &Moment of the hour,
| Nomenclature B
| (VIBRATE
| Nomenclature YAK Nomenclature
| Z
| Products YAK Products)) YAK Zalishki
|DE
| Surplus.Kilkist< 0";

CordonControl = New Cordon(Moment Hour(), ViewKorody.Inclusive);
Request.InstallParameter("Moment to Hour", CordonControl);
ResultRequest = Request.Viconati();

// 5. Notification about shortage of goods
If the result is not requested. Empty() then
Vidmova = True;
VibirkaPomilki = Result of Query.Vibrate();
Poki VibirkaMilkki.Offensive() Loop
Message = New Message to Koristuvachevi;
Message.Text = "Product "+Selection of Milks.Nomenclature of Presentation+" is insufficient in quantity "+Selection of Milks.Shortage+" pcs.";
Inform.Inform();
KіnetsCycle;
KinetsYakscho;

KinetsProcedures

Let's look at the key points of the algorithm.

1. Sequencing the document data

This will fill in the necessary grouping of data in the tabular part of the document.

Please note that in the first entry of the packet the time table is created - it will also be used in the next entry. Please tell the manager of the sentries the table created for him.

2. Formation of documents for the register

In the cycle, data is recorded from the document to the register - so that the write-off of goods is completed automatically (without verification).

3. Recording records in the database

Once the balances in the register have changed, you need to write them down.

4. A prompt that removes negative excesses from the register

And now let’s simply collect the negative surpluses for the goods of the document.

Here, the vikoryst is creating the first time table - the mind is superimposed on the nomenclature (for which we are not creating a new object of the “Write” type, but vikorist’s creations earlier).

To restore respect for how the hour is transmitted, the type of data “Cordon” is vikorist. Any excess must be removed immediately after the document is processed.

Is it possible to remove the surplus without a border, for example, by adding 1 second to the date of the document?

No! Even in one second there can be a large number of documents. Therefore, the only correct option is to select the “Including” view of the cordon.

5. Notification about shortage of goods

If the result of the application is not empty, then there are negative surpluses - in this case the document will not be processed and notifications about all amendments will appear.

Advantages of surplus control using the new method

Well, it’s wrong for the algorithms to solve the same problem.

The difference between the algorithms is clear, but the advantages are not obvious.

So let's cheer them up:

1. There is no need to clean up old document debris. Essentially, this operation of writing an empty set of archives to the database and deleting empty ones is a resource-intensive operation.
2. The query that removes data from negative excesses expands to one table – There is no need to work directly with the document data and set up the “ISNULL()” function

Moreover, during the normal flow of business processes, the customer indicates a quantity that does not exceed the surplus in the warehouse.

In this case, the other one will ask for more details and the execution of the document will be as smooth as possible.

Why are milliseconds so important?

On bases with a small number of data, the difference will be immeasurable. However, in modern systems with dozens of medical devices, the cost of a skin millisecond is high.

In addition, on the 1C:Fakhivets platform it is necessary to implement a new method for controlling surpluses, which does not allow for specific assignments.

Ok, so you need to start using a new technique first, right?

It’s not like that!

The new technique can only be used in the sense that for processing a document, all the necessary data is on the document itself.

So, to remove data, you do not need to go to the registers that control surpluses.

So, for example, if the sum was insured in the “Vilna Zalishki” register, then the old control method would have to be abandoned.

Before speaking, in the standard “1C: Trade Management 11”, control of surpluses is implemented using the new method, and in “1C: Accounting 8” - according to the old method.

That's not all!

Most of the algorithms presented can be used only for initial purposes. On the right is that you can’t get insurance in them ceramic blocking, which must be stagnated if there is more than one accountant working in the system.

Blocking for both methods is dedicated to excess control. Also, this article has a more complex situation - in addition to the control of surpluses, the structure of the inventory of the nomenclature that is being written off is also determined. We recommend that you read it carefully.

And for the “seed” let’s just say that Installed blocking in the new method is even easier to avoid- And this is another advantage of the new method of controlling surpluses.

Pouches

We use short pouches.

We looked at two methods for controlling surpluses, which stagnate in current typical configurations.

Key differences between methods at the moment of surplus control:

• The old method is control until records are recorded at the registry
• New technique - control after recording documents at the registry

In this case, a new technique is more effective, but it will never be the same again.

Criterion for stagnation– since the formation of archives does not need to go back to the data of the controlled register, a new technique can be used.

If we are talking about control of stock surpluses, then the implementation of a new technique is more possible if data on compliance and warehouse surpluses are stored in different registers.

І on completion of application typical configurations:

• U UT 11 There are 2 main registers for the area of ​​nomenclature: Excess surplus (quantity) and Compatibility of goods (data on comparability) - a new methodology is being developed
• U BP 3.0 Compliance data and surpluses are stored in one accounting register - the old method of controlling surpluses is being reversed.

In my video tutorials, I often talk about the fact that the 1C database needs to be carefully prepared before the end of the reporting period. One of the important points of such preparation is the control of negative surpluses of goods, materials and finished products. What points do you need to quickly check in order to check the status of the inventory items in 1C: Accounting? Let's take a look at their actions.

1. Title “Turnover balance by rack”

Then we look at the sound with respect and analyze the appearance of damage

The balance sheet is handy because it allows you to assess the presence of negative cash surpluses and identify other problem situations:
- cash surplus of goods and materials without sum;
- soum surplus without kіkostі;
- Negative sum surplus.
However, since the form involves a large number of nomenclature positions, then such a reversal can be complicated. In addition, the OSO has to formulate the skin structure for the skin (10, 41, 43), which also complicates the robotic process.

2. Sound "Control of negative surpluses"

The period, organization and form are indicated.

Until the end, nomenclature items that have been identified as having a negative surplus will be eliminated. A great advantage is that data from all areas of inventory are analyzed. Practicing this way, in my opinion, is easier, lower than OSV.
The downside is that it allows you to control negative excesses that are behind the scenes of other problems, which allows you to identify OSV.

3. Sound “Analysis of subconto”

Select the “Nomenclature” subconto and check that the display of multiple displays is enabled in the settings.

Subconto analysis is good because it allows you to filter out information about the collapse of goods and materials at all levels. For example, consider the situation when the product is in one form, and is sold in another way.

Due to the large number of nomenclatures, analyzing the data can be difficult.
I shared a report about the work with this in the video tutorial How to work with the “Analysis of Subconto” in 1C-VIDEO.
Thus, each of the views has its own pros and cons. I would recommend combining them:
- find out the rough solutions with the help of “Control of negative surpluses”;
- then take a look at the CCA for all the details of the inventory;
- to identify the reasons for an incorrect balance, use the “Analysis of subconto” function.
Tsikavy butts, connected with the joke and the correction of amends in the form of goods and materials, I also analyzed from two red videos:

At trading and manufacturing enterprises, negative surpluses “emerge” from the accounting department in the departmental system. They stink of excessive write-offs of goods/materials.

What are the reasons for this guilt?

Daily attendance of the parish

The most common reason may be the lack of availability of goods and the introduction of surplus cobs. For example, they have received goods, but have not yet managed to get it into the system, they have already managed to sell it. And the goods are being processed, then moved to the store and sold, after completing the document of receipt.

In this situation, the correct way would be to verify the presence of the document on the basis. If it has not been carried out, check the filling and carry it out. If the document is no longer available in the database, you must enter it retroactively. In this case, it is understood that the retroactive addition of documents during a closed filing period may cause changes in the amount of filings, according to the maximum allowance limit.

Regrading

Another broad reason for the phenomenon we analyzed is re-sorting or an excess of one item for a product (material) and at the same time a shortage of another. For example, the program apparently shows that there are only 10 pieces of black hamanets, and in the store the seller sells red hamanets and registers them in the sales database for 5 pieces. As a result, the surplus of black hamants does not change, and our surplus appears in the red hamans.

When correcting surplus, the following method is used: the purchase of one product is registered and the write-off of another. For this purpose the document “Acquisition of Goods” is created and 5 pieces are purchased. chervoni gamantsi. Next, the document “Write-off of goods” is created and 5 items are written off. black gamans.

If in 1C:Accounting 3.0 there is a negative surplus for goods (materials), then when the document “Sales of goods” is processed, information is displayed about those for which this document is impossible to process, as shown in the tabular section There are a number of documents that contain a surplus.

Fig. 1 Information in the document regarding the presence of surplus in the warehouse

Signals are detected in the balance sheet - negative balances appear in red!

Fig.2 Release of OSV

How to enable or disable control of negative excesses in 1C BP 3.0

You can set up control in the “Administration” section, then click on the “Document management” option.

Fig.3 Adjustment

To enable control, you need to activate the permission on the parameter "Allow write-off of inventories for any surplus in the account data."

Fig.4 Allowed units to be written off for negative indicators of surplus

In order to sell a product, it is necessary to activate the control at any time. The “Implementations” document is carried out in the system, and then control is re-entered. Then, of course, you need to remember to analyze the surplus in order to correct the loss in the form of negative goods.

In order to control surpluses across warehouses, you need to set up analytics for them in the storage parameters through the administration.

Fig.5 Parameters

Printed "Adjusting the plan of the Rakhunks."

Fig.6 Adjustment parameter

It is embossed “For nomenclature, batches and warehouses (for quantity and bag).”

Fig. 7 Inventory parameters

At the hour of installing analytics, clicking “Behind warehouses (saving places)”, we choose how to manage the account.

Fig.8 Activation of analytics behind warehouses

If the chosen setting is “for the sum and sum”, it is likely that the amount will be in the quantity and sum for the warehouses, and if it is “for the sum”, then it will be less than the sum in the skin warehouse, and the sum is written off in are designated as a way under the price of reserves for the entire quantity in all warehouses.

Control calls

“Control of negative surpluses” is used to analyze the detection of negative surpluses of goods of an organization. You can unlock it through “Warehouse - Control of negative surpluses”.

Fig.9 Sign up for surplus control

Fig. 10 Control form

In the settings you can specify which data will be followed, for example, group data for Organization, Warehouse, Disposal Document, Nomenclature, etc.

Fig. 11 Setting up the control signal

In the selection, you can specify what data to formulate the name for, for example, any specific composition or problematic nomenclature.

Fig. 12 Selection from the control signal

Fig. 13 Formation of control signal

Negative surpluses are a kind of indicator of changes in the environment. It is important to steadily remove surpluses in warehouses and correct them promptly. Incorrect surpluses create problems for the operational work of accountants, and can also cause incorrect allocation of assets, revaluation and other important accounting indicators.

There are two types of situations in which it is necessary to adjust surplus control.

First situation. Sometimes accountants are faced with the problem of the impossibility of writing off materials or goods in the 1C 8.3 program due to the presence of them in the form, although it actually stinks. The accountant needs to accurately prepare documents for the improvement of materials and goods:

This situation is possible, since the organization only began to take shape in 1C 8.3, and the data is entered before the program without delay.

Another situation is when the accountant writes off materials that are not in stock. And the accountant draws up the documents for promotion, which is very good for the company’s reputation.

Adjusting surplus control

The 1C 8.3 Accounting program has settings for controlling surpluses. And when the database is created, you can write off the goods that appear in the daily program.

Surpluses are monitored across a specific organization and warehouse for all types of documents: sales, invoices, transfers, etc., including warehouse analytics.

Important! To control the surplus in the warehouse, in 1C 8.3 it is necessary to install analytics on warehouses and warehouses for the type of goods and materials.

In this order:

• For the first situation, you need to check the box and enter all the surplus materials to the base. And it is important that you promptly check the availability of goods and materials.
• For another situation, you need to check the box to collect write-off of the current product (materials).

How to enable surplus control in 1C 8.3

To remove the security of document processing for all types of goods, it is necessary to set up the 1C 8.3 program in the Administration section - further Setting up the document processing:

check the box It is allowed to write off inventories for the amount of surplus for the following information:

Control of surplus in warehouses

To control negative surpluses in warehouses, set up the analytics Behind warehouses. You can access analytics for warehouses in customized areas: Administration section – go to Area settings. Select Adjusting the rakhunkiv plan and in terms of reserves we are pressing on For nomenclature and warehouses (for quantity):

A new ensign is being installed in the new window Behind the warehouses (saving places). The checkbox is given and is included in the control of surplus in warehouses:

• If the checkbox is ticked, control of surplus occurs between organizations;
• If the checkbox is checked - for the organization and a specific warehouse:

Control of negative surpluses 1C 8.3

Since there is no way to check the box or there is no reason to deal with negative surpluses, in 1C 8.3 Sales Accounting there is a sign that allows you to control negative surpluses.

Sounds Control of negative surpluses in 1C 8.3 it is located in the Warehouses section - further Control of negative surpluses:

The report can be formulated over a period of time with details of documents, warehouses, nomenclature and other objects of the organization. And also display data on the composition and nomenclature, vikory and selection:

Important! The control of negative surpluses shows negative surpluses for this period. If the documents were written off before the beginning of the day, then the negative surplus should not be spent on them.

To change the sound settings, use the Show settings command. By moving through the tabs Setting up Grouping, Selections, Additional fields, you can give the information the desired look:

On the website you can find out about the configuration of 1C Accounting 8.3.

Report on customizing programs 1C 8.2 (8.3) Collection of write-off of inventories for any surplus, how it flows into financial results can be seen in the current video: