EGAIS 3.0: differences in the implementation of blot accounting in wholesale and retail

    Obviously, the specifics of the work of retail and wholesale organizations presupposes the existence of different business processes related to alcohol products, and therefore, there are differences when working with EGAIS. These differences also fall on the software tools for working with the Unified State Automated Information System , which we encountered when integrating our TSD software into industry accounting systems.

    Operations, accounting processes and documents in wholesale and retail have differences.

    For starters, I want to sprinkle ash on my head, and admit that we underestimated this problem. Our focus on the integration of DataMobile EGAIS software into various commodity accounting fell on the retail processes of blot registration of alcohol. We made these integrations quickly and were ready for the demand of our alcoholics for a mobile automated solution ahead of time. Our software is positioned as a ready-made solution for EGAIS, which one of our customers hoped for - an alcohol wholesaler. In fairness, it’s worth noting that our wholesaler also did not pay attention to the differences between retail business processes and wholesale ones, bought data collection terminals and our licenses, installed, connected and only then realized that he obviously didn’t understand the wholesale functionality when exchanging mobile software data with accounting enough.

    Now we are working on finalizing the DataMobile EGAIS for the wholesale segment of the alcohol market, and we will write about what we implemented as a result. We do this in cooperation with three alcohol producers who kindly advise us so that our product takes into account all the "life" situations that are present in the wholesaler's everyday life in connection with EGAIS 3.0.

    Why are we writing this article now? When we encountered the problem of our wholesalers, we together monitored the market for mobile (and not only) software solutions and realized that such an “ambush” could be expected by many alcoholics if they did not take into account the nuances that distinguish their activities from retail processes. Therefore, choosing an automated solution for accounting according to EGAIS 3.0, they should know about these nuances right now.

    A brief history of the introduction of EGAIS 3.0.

    06/30/2017 on the FSRAR website announced that in the personal account of the portal, in the “test transport module” section, electronic circuits of version 3 documents were available. Published circuits and descriptions can be used to adapt your accounting systems to use the new format.

    Initially, the introduction of EGAIS for accounting for alcohol products began with the control of the wholesale link (manufacturers and importers), because the main goal was to track the turnover of large quantities of alcohol. Wholesalers received excise stamps on a batch immediately with a series or range of codes. It was precisely taking into account such ranges of excise stamps that the data structure of the EGAIS system was adapted. It was important for the state to understand that the factory produced a certain number of bottles; they had glued excise stamps with numbers in the range equal to the number of units produced.

    Further, it was necessary to connect a retail link to the already operating wholesale EGAIS.
    It somehow did not happen to make a single, and at the same time convenient, system for wholesale and retail. Retail, due to its specificity, cannot work with ranges of codes, and wholesalers cannot afford to blot every bottle when shipping products by wagons.

    To create two independent alcohol accounting systems for wholesalers and for retailers, which will require data synchronization between these systems, is not a lordly thing. Therefore, it is proposed that entrepreneurs themselves take up the treatment of this proctologic disease.

    In the format of the EGAIS version 3 documents, there was a requirement that each receipt document contains a complete list of specific excise stamps that travel through it from a wholesaler to a retailer. Those. EGAIS ceases to operate with ranges of excise stamps and will begin to work with each specific brand. And if this innovation is practically not threatening anything for retail, it had previously dealt with scanning and counting each bottle (on the contrary, with EGAIS 3.0 “mirrors” and other misunderstandings should stop), then for wholesalers the new version requires the preparation and re-automation of most accounting processes.

    Differences EGAIS 3.0 in wholesale and retail.

    So, let's look at what the new work order threatens for those and other business representatives. To do this, we will see which business processes associated with blot registration are expected in a retail store, and which are at the wholesale distributor of alcoholic beverages.

    Alcohol retail business processes:

    • small periodic alcohol admissions that can be tested on a per-unit basis
    • processes for inventory and branding on the 3rd register of accounting EGAIS write off products
    • retail sales (but here cash register software and a barcode scanner are already included )

    Business processes of the alcohol wholesale organization:

    • large receptions of alcohol (pallets, wagons, etc.), which is almost impossible to perform per-unit inspection
    • processes for inventory and stamping on the 3rd register of accounting EGAIS
    • write-offs of products, movements and returns of products
    • aggregation of marks during repackaging, with the printing of labels of new group packaging
    • large shipments of alcohol, using group packaging, as well as checking batches of products

    Naturally, all processes of movement of alcoholic products are reflected in specialized documents in 1C in both cases, but, due to the specifics, the 1C configurations themselves for different business processes are different. For example, retail configurations such as Dalion PRO / UNO, Tavern Head Office / Management, TREND, Shtrikh-M: Trading enterprise, 1C: Retail, incorporate EGAIS documents that allow performing retail business processes. It does not provide accounting, for example, of group packaging and repackaging processes. In some of them, it is possible to keep records of shipments and returns of alcoholic positions, but this will also be in a minimal form, with blotting work and without partiality.
    And here it is important! Choosing mobile software for TSD and work with EGAIS, which is supposed to be integrated into the goods accounting system, the wholesaler should ask the developer what documents his mobile EGAIS program works with by default. In the case of our wholesale customer, who was satisfied only with the description of the functions of our mobile client and, when buying, did not take into account the differences between the retail and wholesale processes - this is what we and he stumbled upon.
    As for wholesale 1C configurations, such as, for example, specialized configurations from KT Alcohol company (KT 2000): Distillery and winery (distillery), Alcohol trade management (UTAP 10 and 11), Complex automation of alcohol trade (KATAP 1 and 2) , then they have in their composition everything necessary for the work of wholesale organizations. In addition to all kinds of reports and declarations, they are needed for work, they also include mechanisms for accounting for group packages, maintaining registers for accounting for them, with the possibility of repacking products, with verification of acceptance and fixing shipments also for group packages.

    If the wholesaler has one of these industry systems, or some other (independently rewritten and adapted configuration), and even if in the description of the mobile client’s compatibility he sees one of these product accounting in the list, it’s worth getting detailed advice from the developer on all the contours of data exchange necessary for wholesale operations with alcohol, taking into account the batch work.

    Separately, it should be noted that until recently there was no certainty on the principles of labeling group packages, but recently various options were proposed by the RAP and the voting was launched. It
    is noteworthy that EGAIS 3.0 started on March 15, 2018, and the proposal to vote was received on March 30 2018 The following option is currently leading., which is likely to be taken as a basis.

    In custody

    We encourage wholesalers of the alcohol market to carefully and carefully consider the choice of software for data collection terminals. Our DataMobile SoftwareIt has open exchange formats and can be used in any business processes of the organization, including when working with non-1C systems, as well as according to its own work algorithms, thanks to parametric settings. However, we are in the process of developing a version for blot accounting in the wholesale trade in alcohol so that our customers do not need to “saw” the standard wholesale processes on their own. We already have a focus group of wholesalers who advise us, but we will be glad to all the recommendations from the representatives of this segment. One head is good, and ten is even better - and our mission is to help businesses solve their problems with the most simple and convenient automation tools. If you have anything to say on this topic, write to us in the comments or e-mail (, we will be grateful for your ideas and suggestions.

    Also popular now: