Transition from trading 10 to 11. Possible use cases for data transfer processing
It discusses what cost, batch, RAUS and cost allocation are, what problems can arise when implementing a configuration, and how to make the transition to UT “problem-free”.
Written in an ironic style, the article is easy to read and will be of interest to all users of UT 11 - as an alternative point of view, with which you can agree or not.
Applicability
The article was written for the editors of 1C: Trade Management - 11.0. If you use this edition, great - read the article and implement the considered functionality.
If you plan to start implementing UT 11, then most likely a more recent version will be used. In this case, the material of the article will be irrelevant.
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.
From the author of the article...
Have you already stopped having nightmares in which a crowd of chief accountants, armed with chainsaws, is chasing you, shouting: “But in our seven it was like this, return the seven!”?
"Then we go to you!" - said the developers of UT 11 and ... developed UT 11.
I remember reading an article a long time ago about how in ancient times there was only one BIOS for computers, which was a monopolist and how some other company decided to make its own BIOS. They brought together programmers who had never in their lives poked around in an existing BIOS (for clarity of perception) and gave them only a goal - to create a thing that could do this and that. And the programmers created - the new BIOS did the same as the previous one, but by other means.
This story was constantly recalled to me during the course on UT11 - it really looks very similar to the fact that it was developed by those who had never dealt with previous versions of UT and other configurations in their lives, but simply had the task in front of them - to make it copy to distribute and not to contradict the law.
And they created it! And it does work! And the most interesting thing is that after the third pack of validol you even begin to understand that everything is not so bad, and maybe even no worse than it was! Or maybe (the subconscious mind is still afraid to allow this thought close to the surface until the psyche has grown stronger) - even better than it was!
What is new and interesting in UT11? I present my small subjective review of features (not to be confused with bugs!) of this system.
Let's have no party!
Simple and understandable accounting for batches has sunk into oblivion! Yes, yes, you heard right - no more parties! No, the cost calculation has not been canceled! How can it be calculated without parties? To answer this question, you need to remember what the cost price and the batch are in general.
Cost price is everything we spent on the product before we sold it, plus everything we spent to sell the product. In the simplest example, we spent the cost of the product at the price of the supplier plus the cost of delivery from the supplier, and we spent the salary of sellers and storekeepers to sell it.
The consignment- this is one receipt of goods, i.e. this is a group of goods that was bought at the same price, brought in by the same truck, unloaded by the same loaders and accepted by the same storekeeper. Those. it is assumed that all costs for each product in this batch were the same and that each product in this batch cost us the same, and vice versa, goods from different batches quite often cost differently. The party was invented because there is no need to keep records of one product, if it is faster and more correct to group the same products.
Quite a logical approach!
But this is theory, and if you look closely at practice, you can see a few more interesting things.
Firstly, quite often, especially with certain agreements with suppliers, several batches do not differ from each other in any way - they are purchased at the same price, delivered by the same trucks, unloaded by the same loaders (at least with the same salary). Those. often several parties could be combined into one without any damage.
Further - if one loader unloaded half of one batch, a third of the second and a quarter of the third, and at the same time no one, even he himself, knows that he unloaded exactly half, a third and a quarter - how can linking to a batch help to calculate the share of his salary, pertaining to a particular party?
And even more interesting - if half of one batch, a third of the second and a quarter of the third were moved to another warehouse - what difference does it make to us which batch these goods were from, if they themselves have already formed a new batch?
Yes, we can keep track of all this, but often the difference in the prices of batches will be equal to a penny and the cost of dressing this skin will far exceed common sense.
It turns out that, in fact, the grouped identical goods turned out to be not exactly the same. Or completely different. What to do? Count by piece? Let's wait with the answer and "announce the entire list."
Put off until tomorrow what you can do today!
From all of the above, one thing can be understood for sure - until the product is sold, its momentary cost can range from "within a penny" to "plus or minus a million." And a completely logical question arises - why load the system at the time of implementation, why load the system with routine tasks, why constantly mock the bodies of already completed documents by re-executing them if we still do not know the exact cost of the goods until it is sold? (We may not know for sure even when we sold it, but this is a topic for a separate article, and this question is more from the special cases section.)
This question obviously did not let the developers of UT11 sleep, and they cleared their conscience by removing all this. Now the cost price can be calculated only from a separate document!
No reruns, no sequences. At the end of the month, you press two buttons and you get such a document and a sea of \u200b\u200bcost - from the beginning of the month to the end of the day of the document! No, of course, if you need it right now and not a second later, you can right now. Yes, and you can hang it on a routine task. But the fact remains - productivity grows very, very strongly, because it is considered "at the end".
FIFO = average + LIFO
As for the cost calculation methods, they nominally remained the same legally permitted ones - FIFO and average (weighted average, not moving average, because there are no operational cost calculations, only for a month!).
Everything is clear with the average, the average is calculated according to the Sharikov method - “take everything, and divide it”: everything that was sold plus everything that was spent is divided by the quantity and we get the cost price. But with FIFO - a surprise! FIFO is calculated as a weighted average of sales minus LIFO balances!
It's time to take a few deep breaths to avoid dizziness.
So - in IFRS, which has become something like communism for domestic accounting, to which it is taking leaps and bounds, it is written that if the first purchased goods were the first to be sold, then, accordingly, on the balance we have goods purchased last! Those. if we calculate the balances using the LIFO method, then we just get the cost of sales calculated according to FIFO.
Why so perverted, you ask. I don’t know, but it seems to me that the point is that we buy a lot at once, and we sell little by little. And purchase documents are obtained by an order, or even several orders of magnitude less than sales documents. And if you count FIFO sales, then you need to do a lot more operations than if you count LIFO balances. As a result, we have: the amount of purchased minus LIFO balances is equal to the amount of sales according to FIFO!
But that's not all! After we have received the amount of our total retirement, we would also have to calculate all this FIFO already in relation to each product - to get the cost price.
And here is the explosion of the bomb - and there is no more FIFO! All this received, but not yet divided, amount is divided quite honestly between each product! Those. according to FIFO (more precisely, according to LIFO balances), we get only total amount disposal, and then again the usual weighted average! My head is spinning, but if you sleep with this thought for several nights, you understand that everything is logical and legal.
R**Z
In fact, ROUSE is not a swear word! Although it is very often accompanied by swear words! No - this is Advanced Cost Accounting Analytics. RAUZ is a party substitute.
A little higher, I wrote that dividing into lots as goods bought together does not always help in calculating the cost. So RAUSE is a kind of dynamic parties. Those. goods purchased (or accepted on commission - but this is a different type of goods), from one supplier, one division, one transaction - this is something like a batch, or as it is called in UT11 - a “type of stock”.
At the same time, RAUS can be turned off completely or in parts, for example, if the same product purchased from different suppliers is absolutely the same for you and you are not interested in tracking its relationship with the supplier until the very fact of the sale, then you can simply turn off supplier analytics. But it is important to remember that when RAUS is enabled for suppliers, the same product, in the same warehouse, of the same division, but from different suppliers, is two different products in terms of cost, or rather, two different types stocks!
By the way, in pursuit of the previous paragraph - FIFO is used when selecting goods in a sales document. Those. goods purchased with different documents from the same supplier will be taken randomly, but the same goods from different suppliers will be taken from the supplier who delivered it first.
Cost allocations, lines of business and other scary words
In fact, in terms of costing, UT 11 has become a very powerful mechanism, a kind of SCP for the poor. No, really, compared to what it was before, the cost calculation has really turned into a serious, powerful, customizable mechanism, which is also very optimized, first of all from the point of view of common sense, and then programmatically.
If earlier we had a bulky, fuming colossus that ate resources, constantly broke down and required gentle maintenance, and at the output gave only two different numbers depending on the cost estimation method, now we have a small silent machine that has a bunch of buttons, works briskly and gives a whole bunch of information to think about and optimize business processes.
Among other things, it also has such things as the distribution of costs for areas of activity and even entire strategies for such distributions. Now it is possible to automatically distribute almost any costs into areas of activity by coefficients, in proportion to income-expenses, arbitrarily, according to predetermined or specifically specified analysts. This can be done both for all activities of all organizations at once, and for one specific small product. All in all…
Results
… I am delighted! Yes, I'm really excited! When you first get acquainted with the list of what is no longer there and with an even larger list of what has been added there, there is a completely natural shock. But when you start to look closely, think about all those innovations, no - you compare the surprises that are there with what it was, you understand that the developers just did a titanic job!
The main thing is to get rid of established patterns, to understand that the old is not always better than the new. And in this system you will find a lot of confirmation of this.
No, it is not perfect, there are still bottlenecks, there are also elementary code errors. But it's innovative, it gave a whole bunch of ideas for accounting that have yet to be rolled back. In general, the future will show how good this system is, but it seems to me that this very future is quite bright for it.
equipment list,
which will help implement UT 11
However, my delight is only my delight. It is quite possible that technical experts will not agree with me, but this is not the worst thing. Even if you experience delight from UT11 like mine, it is absolutely not a fact that you will be able to infect with your delight the users who will work with it - accountants, managers, salespeople and, above all, management. I'll even tell you more - if you are going to implement this system at a client, then you have to fight!
So, what does it take to introduce this miracle of enemy technology to an unsuspecting and so far happy client? Below I offer a list of equipment that may even help to accomplish this task.
Atomic bomb
No more, no less - and all because it is much easier to build everything from scratch than to make a transition. After all, there is nothing coinciding with the old versions in UT 11.
And if you don’t want to spend the rest of your days confusingly explaining to the client why, looking into the new configuration, he had the feeling that he now works / owns a completely different company, and why his cost suddenly turned from a native and understandable X into an absolute Y, if if you don’t want to create some kind of UT 10.3 from UT 11, in order to return everything as it was, it’s better to immediately explain to the client that switching to UT 11 is like moving to another planet: you can take only the most necessary things with you (remains in the warehouse and mutual settlements) and burn the rest!
Pillbox with a machine gun and a supply of provisions
Because it will take a long time and stubbornly to keep the defense from accountants and managers who set uncomfortable questions about the cost price, about writing off costs to nowhere, about the incomprehensible names of documents and about other delights of the new UT.
Here we can only advise the strength of the spirit and the methodical processing of users with the idea that “as it was before” will no longer be, but will be “like this”, and at the same time do not forget to explain what “like this” is and why it is good.
KUNG
So in the army they call a van, in which a whole bunch of various tools and spare parts are stored. You will need all this because there are still damp places and grammatical errors in code. And even in the principles there are voids, for example, the type of reserves that cannot be changed in an already completed document. In general, the programmer still has where to roam in this system, the most important thing is not to inadvertently, out of habit, not to assemble the old UT10.3 from this system.
Harakiri knife set
And not even because your war with conservatism can end with your complete surrender (and this can easily happen) and you, like a real samurai, will have to protect your face by ripping open your belly. And first of all, because before implementation, you yourself need to understand what is good and what is bad in this system, what you like and what not, and think - are you yourself a conservative? Maybe you yourself like the old one, not because it is better, but because it has already been well studied, warmed up, circled around? Maybe you didn’t think that the party is not so necessary, but RAUS can come in handy?
It is quite possible that you will have to tear out the rotten grain of conservatism from yourself - and the struggle with yourself is always the hardest.
Finally
It seems to me that the UT11 system is a system of great opportunities. And to use them or not is already your strong-willed decision. It is yours - not the client and not the management. Only you can explain "why" or "why not". For my part, I highly recommend checking it out. I like it.
To maintain 1C software products, it is enough to master the basic knowledge in order to understand the principle of operation at the user level. However, the latest developments are so modified that in some cases they exclude the possibility of an upgrade due to the complete discrepancy between the analytical and calculation structure and the previous version. To be able to change the configuration of the program, it is necessary to comprehend not only outward difference, but also try to understand the algorithm for generating calculations and the way of postings. 1C: Trade Management 11 just refers to such know-how. The transition from configuration 10 is completely practically impossible, as a result of which the question arises of the advisability of refining your own base as opposed to acquiring a new 11.
The transition from version 10 to 11 is not possible for a number of reasons.
1. Fundamental differences in the formation of documents and their participation in accounting entries. In order to improve the processing of information on incoming orders and their implementation, the sequence of operations and tools for accounting and adjustment have been changed.
2. Documents for accounting in warehouse and batch equivalent have changed. The settings and functionality are so different that an upgrade, if possible, is only in an informative manner. In other words, the numbers are carried over but not viewable. primary documents that became the basis for them.
Comparing the accounting "remake" of the 11th generation with 1C: Trade Management 10, it should be noted that not only the operational processing of the client base has undergone restructuring, but also its ordering within the activities of sales managers. A comprehensive analysis of the transaction allows not only to record the fact of the sale, but to project it in the future.
The process of conducting an operation, or rather, control, can be considered an absolutely new moment. If in the 10th edition the document could be posted only after analysis, and if necessary, the system could prohibit posting, then in 1C ed. 11 control and conduct processes are independent of each other, which positively affects the overall performance, reduces the percentage of errors.
Functional features of 1C version 11
Considering that previous versions, for example 1C: Trade Management 8, were created for one user in the context of the activities of a small enterprise, maximum - in the PROF configuration, which allowed increasing the number of users and adjusting the configuration, then the "eleventh" stepped far ahead.
The scale of the system is many times greater than its predecessors, as for direct control, its functionality has reached an unprecedented level.
Implementation innovative projects in terms of counterparty positioning, not only in terms of supplier and customer, but also tracking business relationships between the company's partners, structured reproduction of corporate information.
System settings allow you to automate sales in the context of discounts, fixed prices and payment terms, based on the marketing policy of the trade enterprise.
Interactive repayment tracking accounts receivable based on the planned calendar, allows you to control the partner "behavior" of counterparties, track revenue and classify "debts" by time of delay.
The analytics is carried out automatically on the basis of postings from payment to order and does not require further maintenance by the user.
Another feature is the interaction with sales representatives, which now have the ability to obtain individual settings according to a given scheme. Control over their implementation is recorded and analyzed by the system independently on the basis of the information received.
Applications for portable devices significantly expand the network of interaction between the base and the sales agent, wherever he is. You can work with clients and report on the fulfillment of orders online.
Who needs to install the "eleventh" version
The specificity of the program is such that its implementation in organizations that previously used the “simplified” mode 1c: trade management 8 or even 10, not only will not bring benefits, but can harm. Implementation new edition 1 C is justified in those companies that pursue a multi-level marketing policy, with a serious turnover and a diverse list of items, have an extensive base of counterparties. A unique solution of its kind for stationary programs is the inclusion of subsystems adapted to the external technological equipment, saving and printing documents in common formats (Word and Office) and much more.