Home Removal A simple program for managing a warehouse. Inventory accounting in Excel

A simple program for managing a warehouse. Inventory accounting in Excel

MyWarehouse is a convenient and easy-to-use Excel-based program, especially in comparison with WMS. No programming skills are required to operate the application - its interface is intuitive for almost every user.

The free trading and warehouse application provides truly unlimited possibilities for optimizing any business processes: with the help of this program they become easier and faster.

Using the warehouse accounting program you can carry out various actions. For example:

  • register receipt and shipment of goods,
  • keep daily records of the shipment and receipt of goods at the warehouse in Excel,
  • carry out regular inventory,
  • print warehouse documents and send them,
  • set up exchange with 1C,
  • receive information about actual balances in the warehouse.

This functionality greatly simplifies warehouse management and saves time and labor costs for personnel working in the organization.

The free warehouse program "MyWarehouse" gives maximum opportunities to users without limiting them in working with the usual additional services and tools. You will definitely appreciate how functional the Warehouse program is: in Excel, many of the functions and capabilities that we offer are simply not available. You can receive maximum benefit from an automated accounting system, integrating it with electronic and SMS mailing services, as well as with 1C. In addition, any warehouse equipment can be connected to the system.

Warehouse accounting program MoySklad and its advantages

The free program "My Warehouse", which can be downloaded on our website, has many advantages. Among them:

  • Ease of use. Anyone can fully use the program, since working with it does not require specific programming or accounting skills. All you need to do is register on the MoySklad service website, download the application and create Accounts every employee.
  • Possibility of access from anywhere in the world where there is an Internet connection. You can download documents created in the application to any tablet, laptop or computer. You can control your warehouse online.
  • Reasonable price. You can download a trial version to test the program for free. For further use of the application, if more than one user will work, a subscription fee will be required: you can choose one of the tariffs that is optimal for your business.
  • Qualified technical support. Our company’s specialists will always help in mastering the trading and warehouse program, although you can figure out its functionality on your own - it is intuitive and simple. Service updates occur automatically without additional effort or charge.

Download the free warehouse program MyWarehouse for managing a warehouse in Excel right now and test it in practice. Familiarization with the application during the test period (14 days) is free. Using the demo version, you will learn the basic principles and mechanisms of the program and evaluate how convenient and functional the free warehouse program is. You can also choose a tariff that is optimal for your business.

As one of effective ways reducing the costs of the enterprise is increasing the effectiveness of the implementation of warehouse tasks. This goal is achieved through process automation. It gives the company significant advantages in the market. Let us next consider what warehouse programs exist.

Excel

This application solution is perfect for any trade or production association that keeps track of the quantity of materials, raw materials, and finished products. The program has certain specifics. Before compiling tables, you need to create reference books:

  1. "Buyers".
  2. "Accounting points". This guide is needed by large enterprises.
  3. "Suppliers".

If an organization produces a relatively constant list of products, you can create its nomenclature in the form of an information base on a separate sheet in the table. Subsequently, income, expenses, and reports will need to be filled out with links to this page. In the “Nomenclature” sheet you should indicate the name of the products, product groups, codes, units of measurement and other characteristics. Warehouse program allows you to generate a report using the "Pivot Table" option. Receipt of objects is taken into account in "Incoming". To track the status of material assets, it is recommended to create a “Remains” sheet.

Automation

Users say that accounting can be made more efficient if the user has the opportunity to independently select the name of the product and supplier from a list. The unit of measurement and manufacturer code are displayed automatically, without the participation of an employee, but the cost, date, invoice number, and quantity of the product must be entered manually.

Program "1C: Warehouse accounting"

This application solution is considered by users to be the most versatile. Warehouse program "1C" suitable for any enterprise, regardless of areas of work, size, volume of products produced/sold and other factors. The application allows you to automate operations as much as possible. In this case, the user enters the data once. This one with storage program features a user-friendly interface. Each responsible employee will have access to the database he needs.

Optimal solution

There is such a program as "Super Warehouse". It is quite popular among entrepreneurs. Its advantages include a simple interface and ease of learning. This is the simplest. It allows you to summarize information about Money ah and products from the kiosk to large base. For those users for whom mobility is very important, a version with a portable application has been developed. It can be installed on both a hard drive and removable media.

"Antonex"

This warehouse program is used, as a rule, by trading enterprises. It is perfect for medium and small businesses. The program is simple, but at the same time it contains all the necessary functionality for summarizing information. Users say that they can easily generate reports on sales, cash transactions, analysis of financial indicators, audit of balances, and so on. The program is free to use. But there is also a paid version with a wider range of options.

"VVS Office"

This is a fairly reliable and flexible application solution. It allows you to automate production, trade and warehouse. Implementation into an enterprise is not accompanied by any difficulties and requires minimal labor costs. The program has a free trial and a paid version.

"Product-Money-Product"

This program is designed for comprehensive control of the activities of retail, wholesale, mixed and other trading enterprises - from a kiosk to a large supermarket. The application allows you to summarize and reflect information about all types of transactions and money flows. The application solution ensures control of mutual settlements with clients and maintenance of all necessary documentation. Judging by the reviews, using the program the user can generate analytical reports on the work of the entire organization.

"Info-Enterprise"

Application solution "IP: Trading warehouse"has extensive functionality. It allows you to easily automate operations. The application is used by wholesale and retail stores, warehouses, and supermarkets. In general, the program is focused on trading activities. However, the developers have provided for the possibility of using the application at other enterprises. The program is suitable for all organizations that conduct warehouse accounting .

"Openwork"

This program is used to automate the cycle of operations in a warehouse. The application can summarize information on all stages of work. The application solution has a wide range of options. It allows you to take into account transactions regarding the receipt and expenditure of objects, and prepare analytical reporting.

Microinvest

This application solution is an automation system for network retail facilities. These include, for example, self-service or counter-service stores. The program is also used in restaurants and large warehouse facilities. According to users, the application meets all the requirements for operations to summarize information about the movement of commodity resources within the enterprise itself or between its divisions.

Other solutions

Some enterprises use a program such as "Warehouse and Sales". It is designed not only to summarize information obtained from the company's usual storage areas. The application solution can be used to record information coming from external warehouses that have the structure of an online store. The application allows you to serve orders by phone and e-mail.

The "Warehouse+" program, as reviews say, is quite simple and convenient. It contains all the necessary set of options. Using the application, you can easily create receipt and expenditure documents, print invoices, invoices and other papers. In addition, the application solution calculates sales prices with specified coefficients.

The "Warehouse 2005" program was developed to summarize information from small enterprises conducting trading activities. It can generate reports on stored products, movement of products and money. The application is built on a multi-currency accounting model. It can be used to create exchange rate tables.

The "Warehouse accounting of goods" program is used to quickly reflect information. Using the application, the user tracks the remaining materials and products, and receives reports for any date of interest. Generalization of information is carried out on the basis of cards.

The OK-Sklad program is a fairly powerful application. The application solution is suitable for manufacturing and commercial enterprises. The program contains a complete set necessary functions. One of the advantages of the application is its interface. It is clear and user friendly.

Conclusion

As seen, warehouse programs enough. The choice will depend on various factors. The main criteria are the volume of products in warehouses, the speed of goods turnover, the number of counterparties, the need to draw up additional documents, and so on. If we talk about universal applications, then, undoubtedly, the best solution would be the 1C program.

This is certain best program for maintaining warehouse records. The advantages of the program include a simple user interface and ease of learning. The program allows you to keep full records of goods and money from a kiosk to a large wholesale warehouse. For users who value mobility, there is a version created using portable application technology (portable edition). The program in this version can be installed both on the computer’s hard drive and on removable media (USB-flash, etc.) and can be freely moved from computer to computer.

This is a simple, reliable and flexible program for automating trade, warehouse and production. Easy to deploy, the program requires a minimum of effort to implement and has an affordable price. A free trial version is available.

The program is designed for maintaining operational warehouse accounting. The program allows you to track the balances of goods and materials in the warehouse and receive reports on balances as of any date. Commodity accounting is based on maintaining warehouse accounting cards.

The program "IP: Trade Warehouse" is part of the Info-Enterprise program system. "IP: Trade Warehouse" allows you to easily and conveniently automate warehouse accounting at a trading enterprise. Among the users of our program are wholesale and retail trade enterprises, chain stores, and wholesale warehouses. Despite its trade orientation, "IP: Trade Warehouse" allows you to keep records of materials, finished products, small business products, i.e. The program can be used wherever warehouse accounting is necessary.

As with other FOLIO programs, no special knowledge is required to operate, other than familiarity with MS Windows.

Warehouse accounting "Warehouse+" is a very simple and convenient program that has the most necessary capabilities. Formation of incoming and outgoing documents. Printing of invoice, invoice, invoice and receipt order. Calculation of three sales prices with given coefficients relative to the purchase price, followed by the ability to select one of these prices to form sales prices for a specific buyer.

"1C: Accounting 8" is a universal mass-use program for automating accounting and tax accounting, including the preparation of mandatory (regulated) reporting. This is a ready-made solution for accounting in organizations engaged in any type of commercial activity: wholesale and retail trade, commission trade (including subcommission), provision of services, production, etc. In addition, using "1C: Accounting 8" they can keep records individual entrepreneurs applying a simplified taxation system or a general taxation regime.

The "Azhur-SKLAD" program is designed to automate the cycle of accounting for warehouse operations. The system includes a full cycle of accounting for all types of warehouse transactions of receipt, accounting of expenditure transactions and preparation of analytical reporting.

This is a trade and warehouse program for comprehensive control over the activities of wholesale, retail, wholesale-retail and other trading enterprises - from a kiosk to a supermarket. The program allows you to carry out and formalize all types of trade and warehouse operations, account for funds and control mutual settlements with clients, maintain all the necessary documentation and analyze the work of the entire enterprise.

"Microinvest Warehouse Pro" is an industry solution that is an automation system for “network” retail structures (self-service stores and/or counter sales), warehouse facilities and restaurants. "Microinvest Warehouse Pro" meets all the requirements for the movement of commodity resources within the enterprise itself or in a network of enterprises connected by their commercial or production activities.

"Tirika-Shop" is a very simple but very powerful program for a store. It can do everything, but at the same time it is so easy to use that even an inexperienced user will master it in five minutes. The program is suitable for a store of any profile: groceries, building materials, auto parts, clothing, and so on.

"RM-SKLAD Warehouse Accounting" is a program for maintaining warehouse accounting and trade operations in an enterprise of any form of ownership. It is primarily intended for small and medium-sized businesses. The program can be used in small shops, warehouses, and production for operational accounting of goods and materials.

"Warehouse and Trade" is a simple, reliable program for automating trade and warehouse accounting. It allows you to easily and quickly create primary documents (invoices, invoices, invoices, contracts, etc.), control stock balances, keep records of sales and receipt of goods, make reservations, keep records of debts to customers and suppliers, take into account purchase prices and calculate the cost of products during production, calculate the profit received and much more. The program has extensive interface customization options.

Inventory accounting in Excel is suitable for any trading or production organization, where it is important to take into account the amount of raw materials and finished products. For this purpose, the company maintains warehouse records. Large companies, as a rule, purchase ready-made solutions for electronic accounting. Today there are a lot of options available for various areas of activity.

In small enterprises, the movement of goods is controlled on their own. Excel tables can be used for this purpose. The functionality of this tool is quite sufficient. Let's get acquainted with some of the possibilities and create our own warehouse accounting program in Excel.

At the end of the article you can, which is analyzed and described here.

How to keep inventory records in Excel?

Any custom inventory solution, whether built in-house or purchased, will only work well if the basic rules are followed. If you neglect these principles at the beginning, then the work will become more difficult later.

  1. Fill out the reference books as accurately and thoroughly as possible. If this is a product range, then it is necessary to enter not only the names and quantities. For correct accounting, you will need codes, articles, expiration dates (for individual industries and trade enterprises), etc.
  2. Initial balances are entered in quantitative and monetary terms. It makes sense to take an inventory before filling out the relevant tables.
  3. Maintain chronology in recording transactions. Data on the receipt of products at the warehouse should be entered before the shipment of goods to the buyer.
  4. Don't be disdainful additional information. To draw up a route sheet, the driver needs the shipment date and the name of the customer. For accounting – payment method. Each organization has its own characteristics. A number of data entered into the warehouse accounting program in Excel are useful for statistical reports, payroll for specialists, etc.

It is impossible to unequivocally answer the question of how to maintain inventory records in Excel. It is necessary to take into account the specifics of a particular enterprise, warehouse, and goods. But we can derive general recommendations:

  1. To maintain inventory records correctly in Excel, you need to create reference books. They can take 1-3 sheets. This is a directory “Suppliers”, “Buyers”, “Goods accounting points”. In a small organization where there are not many counterparties, directories are not needed. There is no need to draw up a list of points for registering goods if the enterprise has only one warehouse and/or one store.
  2. With a relatively constant list of products, it makes sense to create a product range in the form of a database. Subsequently, receipts, expenses and reports are filled out with references to the nomenclature. The “Nomenclature” sheet may contain the name of the product, product groups, product codes, units of measurement, etc.
  3. Receipt of goods to the warehouse is recorded on the “Receipt” sheet. Disposal – “Expense”. Current state– “Remains” (“Reserve”).
  4. Results, the report is generated using the Pivot Table tool.

To prevent the headers of each warehouse accounting table from running away, it makes sense to fix them. This is done on the “View” tab using the “Freeze Areas” button.

Now, regardless of the number of records, the user will see the column headers.



Excel table “Warehouse accounting”

Let's look at an example of how a warehouse accounting program in Excel should work.

We make “Directories”.

For supplier data:


*The shape may be different.

For customer data:


*Please note: the title bar is frozen. Therefore, you can enter as much data as you like. The column names will be visible.

To audit goods release points:


Let us repeat once again: it makes sense to create such directories if the enterprise is large or medium-sized.

You can make a product nomenclature on a separate sheet:


In this example, we will use drop-down lists in the table for warehouse accounting. Therefore, we need Directories and Nomenclature: we will make references to them.

Let's give the range of the "Nomenclature" table the name: "Table1". To do this, select the table range and enter the corresponding value in the name field (opposite the formula bar). You also need to assign a name: "Table2" to the range of the table "Suppliers". This will allow you to conveniently refer to their values.

To record incoming and outgoing transactions, fill out two separate sheets.

Making a hat for the “Parish”:

Next stage - automation of table filling! We need to make sure that the user chooses from ready list name of the product, supplier, point of accounting. The supplier code and unit of measure should be displayed automatically. The date, invoice number, quantity and price are entered manually. Excel calculates the cost.

Let's start solving the problem. First, we will format all directories as tables. This is necessary so that something can be added or changed later.

Create a drop-down list for the “Name” column. Select the column (without a header). Go to the “Data” tab - the “Data Check” tool.

In the “Data type” field, select “List”. An additional “Source” field immediately appears. To take the values ​​for the drop-down list from another sheet, use the function: =INDIRECT("item!$A$4:$A$8").

Now, when filling out the first column of the table, you can select the product name from the list.

Automatically in the “Unit” column change" the corresponding value should appear. Let's do it using the VLOOKUP and UND functions (it will suppress the error resulting from the VLOOKUP function when referring to an empty cell in the first column). Formula: .

Using the same principle, we create a drop-down list and autocomplete for the “Supplier” and “Code” columns.

We also create a drop-down list for the “Accounting point” - where the received goods were sent. To fill out the “Cost” column, use the multiplication formula (= price * quantity).

We create a table “Consumption of goods”.


Drop-down lists are used in the columns “Name”, “Point of registration of shipment, delivery”, “Buyer”. Units of measurement and cost are filled in automatically using formulas.

We make a “Turnover Statement” (“Results”).

At the beginning of the period we set zeros, because warehouse accounting is just beginning to be maintained. If it was previously maintained, then this column will contain remainders. Names and units of measurement are taken from the product range.

The “Receipts” and “Shipments” columns are filled in using the SUMIFS function. We calculate the remainders using mathematical operators.

Download the warehouse accounting program (a ready-made example compiled according to the scheme described above).


So the independently compiled program is ready.

The free version of Debit Plus can be used by both entrepreneurs and small businesses. The system allows you to conduct inventory control, includes a system for interacting with clients. The functions of the system include arch balance sheet, fixed asset accounting, wage. The program is available for Windows, Linux, Mac OS.

Free version of the "Debit Plus" system:

  • Suitable for both entrepreneurs and small businesses.
  • Allows you to maintain warehouse accounting both with and without accounting (at the user's request).
  • Works on various OS - Windows, Linux, Mac OS, and DBMS - PostgreSQL, MySQL.
  • It is completely ready to work under the conditions of Ukrainian legislation and is promptly updated in connection with its changes.

The system consists of the Eclipse RCP platform, the Debit+ module itself, which is distributed as a compiled jar and configuration.
The entire configuration is written in JavaScript, the forms are in XML. You can use Eclipse for development.
In fact, only one configuration is free - the one with accounting and small pieces of other sections. The rest are paid.
But no one is stopping you from freely modifying it to suit yourself, especially since the site has quite a lot of documentation and examples.

A pineapple. GNU General Public License is a free software license. Software under this license is free for use for any purpose.

Pineapple is a freely distributed accounting automation platform. The system will help automate purchases, sales, and report generation. This free analogue of 1C has distribution kits for Linux and Windows.

Its own technology. The program is free, but the exact license is not known.

"Own technology"- management accounting platform for small and medium-sized businesses. The basic configuration of the system, which meets the requirements of most Russian companies, is distributed free of charge, including for use in commercial organizations. License Agreement and Terms of Use.

Main features:

  • warehouse accounting of materials, goods, products;
  • accounting and analysis of sales of goods, products, services;
  • conducting mutual settlements with buyers or suppliers;
  • accounting of cash flows at the cash desk, bank, ability to download data from the client bank.
  • registration of all necessary primary documents, printed forms that comply with the law;

For all accounting sections, you can generate register statements; in addition, a number of built-in and additional reports are available.
Reports and printable forms can be exported to Excel, Open Office, and also sent by email. It is possible to upload data to programs accounting(when the corresponding additional module is activated).

Benefits of the program:

  • High speed thanks to client-server technology
  • The network version allows a large number of users to work with a single database, which is unique for free programs of this class
  • Multi-company accounting in one database and the ability to work with several databases
  • Flexible reports with custom groupings and filters
  • Possibility of connecting commercial equipment (RS232 or USB emulation)
  • Automatic re-run when correcting old documents

Athena. The program is free, but the exact license is not known.

Purpose:
Development and operation of various accounting tasks (and not only accounting), each of which is created with its own database.

This is a two-in-one system. The developer uses it to build accounting projects, and the user operates the developed projects in it.

The system can be classified as part of the RAD - Rapid Application Development direction, a tool for rapid application development, but on the condition that the developer is not a beginner. The complex, as a tool for developing various accounting tasks, is not so simple. On the pages of this site, beginners will find a lot of information to familiarize themselves with or master the system.

Athena exists in two versions: in the form of single-user and network assemblies.
A project completed using one assembly will work in another.
A few words about the differences between the assemblies are given on the "Download" page.

Athena is distributed free of charge without any conditions or guarantees.

Openbravo. Free ERP system with open source.

Wide, versatile functionality
Rich functional content: End-to-end financial accounting, Sales and CRM, Purchasing, Warehouse, Production, and Project and service management
Built-in extensible environment: Best developments from Openbravo, third-party modules and vertical solutions for better implementations
Expansion of organizational structure: Simple expansion from a mono-company to a multi-company structure with its own business units and warehouses

Innovative
True open WEB architecture
Ease of use WEB: Simple and secure access to all functionality associated with WEB services, quick integration with other applications.
Easy to change and update: Most unique modifications are done without programming
Deployment flexibility: Mono or multi-party, on Windows or Linux, at home or at a service provider - you choose the ideal conditions

Low cost of ownership
High returns at minimal cost
Minimum initial investment: The “Pay only for services” model reduces the investment burden and allows you to clearly control the cost of the result obtained
Transparent pricing: Simplicity and clarity, no hidden fees, no license overpayments
Quick start, high results: Quick start with initial functionality and inexpensive cost of developing functionality in the future

GrossBee . GrossBee offers its customers a unique opportunity for such systems - to receive a fully functional single-user version of the GrossBee XXI system for free.

The enterprise management system "GrossBee XXI" refers to ERP systems class and is designed for complex automation of trade and manufacturing enterprises of various sizes: from corporations to small companies. The system solves problems of accounting and planning of material and financial resources, production, analysis of enterprise performance indicators, and many others.

All functions of the system are implemented as a set of interconnected modules that actively interact with each other and together form a single, holistic application. The modules are replaceable, allowing you to develop customized solutions for specific businesses.

The modules are combined into subsystems, each of which is used to solve specific problems. For example, the material accounting subsystem “deals” with the movement of inventory items, the cash and non-cash accounting subsystem deals with banking and cash transactions, etc.

The structure of the GrossBee XXI system is shown in the figure (click on the corresponding subsystem for detailed information):

GrossBee XXI includes the following main subsystems:

  • Material accounting subsystem
  • Contract accounting subsystem
  • Material resources planning subsystem
  • Production accounting subsystem
  • Production planning subsystem
  • Cash accounting subsystem
  • Cash planning subsystem
  • Subsystem for accounting for debts and settlements with counterparties
  • Fixed asset accounting subsystem
  • Accounting subsystem
  • Personnel accounting and payroll subsystem
  • Economic analysis subsystem
  • Enterprise economic monitoring subsystem
  • Administrative functions

All subsystems use a common database and exchange information with each other, which makes it possible to create a unified information environment at the enterprise, common to all its divisions. In general, the division into modules is quite arbitrary. For example, the material resources planning subsystem uses both data on the balance of goods in the enterprise's warehouses and information from the accounting and production planning subsystems, the fixed assets accounting subsystem receives data on equipment wear and tear from the production accounting subsystem, etc.

It should be noted that the system continues to actively develop; new modules and subsystems are constantly appearing in it, which are easily connected to others within the overall system architecture.

VS: Accounting. Accounting module - Free!

VS:Accounting is a program for maintaining accounting records for small and medium-sized enterprises. It allows accounting for organizations with both general and simplified taxation systems.

What is included in the Accounting module:

  • General taxation regime and specialized tax regimes of the simplified tax system, UTII.
  • Book of accounting of income and expenses.
  • Tax return according to the simplified tax system.
  • Tax return for UTII.
  • Accounting for fixed assets.
  • Accounting for inventories and services.
  • Accounting for cash transactions and formation of a cash book.
  • Accounting for current account transactions.
  • Accounting for trade transactions wholesale trade, in retail, accounting of goods at sales prices, calculation of trade margins.
  • Accounting for settlements with accountable persons and generation of advance reports.
  • Accounting for settlements with counterparties, generation of reconciliation reports.
  • Formation of a sales book, a purchase book and invoice journals.
  • Formation and uploading of accounting and tax reporting in electronic form.
  • Current reporting forms.
  • Standard accounting reports: turnover sheet, analytical calculation and others (with drilling function).
  • Different ways of entering transactions: using standard operations, posting documents, manually.
  • Client-bank.

Other paid modules can be found at the office. website.

  • Salary and personnel
  • Personalized accounting
  • Trade
  • Stock

OpenERP.

The system began to develop through the efforts of Fabien Pinckaers in 2000. Tiny ERP soon began to be implemented in the public trading market.

Until the end of 2004, Fabien Pinckaers combined in one person the developer, manager, and distributor of Tiny. In September 2004 (when he completed his research), other programmers were brought in to develop and distribute Tiny ERP.

By 2006, the program was successfully used in specialized bookstores, distribution companies, and service companies.

At this time, the TinyForge resource opens. Since then, developers from all over the world have been involved in the development of modules.

A stable version is released every 4-6 months, and a developer version is released every month. In June 2007, in version 4.1.1, a “web client” appeared, allowing you to use all the capabilities of the system using a regular browser.

In July 2008, Launchpad became the platform for organizing the work of the OpenERP community, and the system itself became more open to translators and developers. Also in 2008, the first version of the OpenERP book was written, replacing the system documentation. Since 2009, OpenERP has been included in the Ubuntu and Debian packages.

Technical features

  • Python programming language
  • Server-client interaction is implemented using the XML-RPC protocol
  • The server part uses PostgreSQL as a DBMS
  • GTK-based clients
  • Ajax based web client
  • A web client has been developed to work using mobile devices (currently access through it is read-only)
  • Modular structure

Modules

  • Accounting
  • Asset accounting
  • Budget
  • Human Resource Management - HRM
  • Products (goods)
  • Production
  • Sales
  • Procurement
  • Warehouse management
  • SCRUM - project management for software development
  • Order lunches to the office
  • Project management

Official website of the program: openerp.com

Tria

Standard configurations - free

How Tria works

The Tria platform was created in the image and likeness of the most common former USSR software product - 1C Enterprise. Just like 1C, the ready-made solution consists of two parts - a platform (launched application) and a database.

Comparison with 1C or a little history

The Tria system was not born on empty space. At first, the developers were creating non-standard solutions based on 1C 7.7. As a result of consistent research, a mechanism for business operations was born.

The essence of this mechanism is that the entire logic of document behavior is not contained in code in a programming language, but is specified using a special reference book Business transactions.

As a result, we received the following advantages:

  • The logic of document operation can be changed on the fly, while other users continue to work in the database.
  • The process of making changes to the configuration has been significantly simplified and accelerated, and consequently, the cost of support has been significantly reduced. What a programmer does in 1C in a day can be done in TRIA in an hour.
  • The level of requirements for a TRIA customizer/implementer has been significantly reduced. People who did not know how to program configured the wiring themselves and radically changed the logic of the program. The emphasis in the requirements for implementers has shifted: first of all, specialists must know the subject area, understand the methodology of work, and only then be specialists in TRIA.

Naturally, Tria turned out to be ideologically similar to 1C. The same hierarchical structure directories, documents, document journals, registers. There is no chart of accounts and periodic details yet - it will be planned over time. Essentially, this is something similar to the “Operational accounting” or “trade” component in 1C.

Here, of course, I would like to draw a comparison table, especially since 1C is familiar inside and out, but many will consider this as anti-advertising. Therefore, we will limit ourselves to a very brief summary: in 1C you can do almost everything that the user wants. It's just a matter of time, money and good specialist. Our software is more limited in functionality, but everything that can be done in Tria is much easier and faster, and therefore cheaper. At the same time, programming requires a significantly lesser degree of specialist training.

Main competitive advantage– this is a significant reduction in costs for the purchase, implementation, modifications and IT support of your software.

The configurations offered in TRIA contain all the experience of successfully running the business of our clients. They receive not only the program, but also constant recommendations and suggestions to increase the profitability of their companies. We are proud of the achievements of our clients, that over 4 years of using TRIA in the Lugansk region, not a single client has stopped their business, but on the contrary, despite the crisis, they are successfully developing.

Tria Specifications

For normal operation of Tria, a Pentium 150, 32 megabytes is enough random access memory, 15 megabytes of disk space. How larger size databases and the volume of entered information, the more power the computer (on which the database is located) is required.

The Tria platform is a portable application - i.e. a program that does not require installation. You can install the program by simply copying the entire directory, and carry your accounting on a flash drive. On any computer you can issue documents or receive information about balances.

The free Firebird SQL server is used as a data storage (there are versions of the server both for Windows and for free OS(Linux, FreeBSD)).

For single-user work, by default it is proposed to work with the embedded version of the Firebird server, which does not require its separate installation and administration.

You can read more about Firebird's capabilities here:

  • www.ibphoenix.com – manufacturer’s website
  • www.ibase.ru is the website of the company that took part in the development of this server. Contains a lot useful information in Russian.
  • www.interbase-world.com, www.sql.ru are sites where you can communicate with programmers who operated this server.


New on the site

>

Most popular