In this article, I will examine 1C and CliK not as ready-to-implement solutions, but as platforms for creating custom solutions.
1C
Client Communicator
Free versions
None.
A free trial version is available with many different limitations.
Any configuration can be used in single-user mode for free and without restrictions.
Installation
File version (not recommended for network operation):
1. Install the platform;
2. Create an information base.
Server version:
1. Install a database management system of your choice (MS SQL, PostgreSQL, IBM DB2, PostgresPro, Oracle Database);
2. Install the platform on server;
3. Create an information base on the server;
4. Install on client computers and set up access to the information base.
The server version is usually installed by an experienced 1C specialist.
1. Install MS SQL;
2. Restore the database on the server;
3. Install on client computers and set up access to the database.
Even a non-IT specialist can handle the installation.
Operating system requirements
Microsoft Windows, Linux, Mac OS X.
Microsoft Windows.
Cost
Rental
From 700 to 1300 rubles/month for one active connection
Only in the cloud service.
1000 rubles/month for one workplace
1500 rubles/month for one connection
Database placement within the local network is possible.
Purchase of licenses (example based on the configuration of Trade Management for 25 people), in rubles
Purchase is possible for any number of licenses; the calculation is based on 25 licenses.
Configuration – 25,960
Server license – 86,400
Client license for 25 workplaces – 99,600
Total: 211,960.
Licenses can be purchased only from 25 licenses (there is a possibility to purchase up to 25 licenses).
For 25 workplaces – from 200,000 to 450,000.
For 25 connections – from 300,000 to 675,000.
Information and technical support. Updates
Recommended price for 1C: ITS for 12 months 40,572
No depends on the number of previously purchased licenses.
Depends on the number of previously purchased licenses – 25% of the total amount of purchased licenses.
For the example above: from 50,000 to 168,750
This amount is divided equally quarterly.
Licensing
Variant 1: USB key.
Variant 2: Electronic license. A document with a list of PIN codes for 3 possible reinstalls is issued. A key request is required for the next reinstall.
A request for a license is being formed; after receiving a response, we will load it.
Variant 1: for a workplace - a license request is required when changing/adding a workplace.
Variant 2: for connecting a computer - a license request is required when changing/adding a computer that will connect to the database.
Variant 3: database license - a license request is required when installing and changing the number of connections.
Ready-made solutions
There are 6 most popular configurations:
1. Accounting
2. Payroll and Human Resources Management
3. Trade Management
4. Comprehensive Automation
5. Small Business Management
6. ERP
In addition to these, numerous industry-specific solutions are released.
There are 3 basic configurations:
1. Sales
2. Management
3. Trade
In addition to these, there are 5 ready-made industry solutions.
The Client Communicator is designed to create individual automation solutions.
Implementation and customization
One of the numerous ready-made specialized configurations is taken as a basis.
Option 1 (cost-effective, but more painful for users). Familiar accounting processes are changed to those described in the configuration.
Option 2. The configuration is processed to the maximum extent to fit the existing business processes of the enterprise.
One of the basic configurations is taken as a basis. It can be used as is or customized to the needs of the enterprise by oneself (minor tweaks) or with the help of a specialist.
Cost of implementation/customization
From 1800 RUB/hour.
From 1500 RUB/hour.
Possibility of self-modification/customization
A 1C programmer is required for any modification of data.
It is possible to make minor modifications independently:
1. Add new directories (SQL tables are created);
2. Add fields to directories (tables);
3. Create calculated fields (results are not stored in the DB, they are dynamic), an intuitive calculation wizard is used;
4. Create stored calculations (results are stored in the DB). The configurator automatically creates SQL triggers;
5. Create database events. For example, upon receiving payment - send an email confirmation;
6. Create planned events. For example, automatically send birthday greetings.
7. Edit the content of forms and cards.
More complex modifications require the involvement of a programmer with knowledge of T-SQL and VBScript.
Creating printed forms
A 1C programmer is required.
Report forms can be created using Fast Report, Word, or Excel, as per your choice.
Each user can create reports for themselves.
Basic training is required to create reports in Fast Report (there are free video tutorials available), and a convenient report query builder is used.
To create reports in Word or Excel, you need to install the MS Office package and enable integration.
Working with barcode scanners
Installation of special processing for the existing model of the scanner is required.
No additional device configuration is required. The scanner connects to the computer and starts working.
Integration with PBX
You need to purchase an extension for the PBX.
No additional payment is required; it is included in the platform.
Configuration is necessary.
Integration with online cash registers
Installation of extensions for the chosen cash register model is required.
Work by a programmer is required.
Integration with 1C
Data synchronization between different 1C configurations is sometimes required. It can be configured independently.
It can be configured independently. Knowledge of the 1C database structure is required.
Performance
Performance depends on several factors:
1. The quality of procedures written by the developer;
2. Execution of background tasks;
3. No optimization work is being done on the IS;
4. Low technical specifications of the server and client computer.
The server hardware has quite high requirements. For example, for 50 users, a CPU with 8 cores at 3.2 GHz and 96 GB of RAM is required.
Server requirements correspond to the selected version of MS SQL. A list of Microsoft SQL Server 2012 versions and their requirements is available at .
Up to 15 workstations and a database size of less than 10 GB can use the free version of Microsoft SQL Express.
More than 15 workstations or a database size greater than 10 GB requires using Microsoft SQL Server 2012 Standard or higher (Developer, Enterprise, etc.).
User Interface
Topics
There are 2 themes: Standard (deprecated) and Taxi.
There are 52 templates available for the user to choose from.
Object card
A programmer can create various document forms for different interfaces. In practice, this is rarely used.
In the designer, you can create different cards for each user group.
Forms with lists
Typically, one list of documents is used. Subordinate forms are used very rarely.
The form can be customized to your needs.
Data export functionality is available.
In the form, several interrelated tables are typically placed. For example, a list of contractors with quick access to tabs below: a list of contacts, a list of contracts, etc.
There is an option to display information in a vertical table for quick viewing without opening the card.
Splitters are used.
The form can be customized to your needs.
There are options to:
• export data;
• merge duplicates directly in the table;
• batch edit data in the table;
• multiple selection (for instance, when selecting several contractors, all contacts of the selected contractors are displayed in the contact table);
• work with lists. Lists can be saved in three versions: public with editing rights, public without editing rights, and accessible only to the creator;
• navigate to the reference field card where the mouse cursor is hovered;
• dial a phone number;
• send an email;
• open a printed report form.
Aggregate functions in the table
None.
Users can customize it to meet their needs.
Filters in tables
Available:
1. Ability to place quick filters on the form;
2. Filter by the content of the selected field in the row;
3. Customize the list (search by field content, direct and reverse links, coloring, grouping).
Available:
1. Ability to place quick filters on the form;
2. Filter by the content of the selected field in the row;
3. Advanced filter (search by field content, direct and reverse links, coloring), filters can be saved in three versions: public with editing rights, public without editing rights, and accessible only to the creator;
4. Quick filter by columns (like in Excel);
5. Filter tree of two types: static and dynamic (by direct and reverse links);
6. Grouping data using the mouse.
OLAP — reports
None.
There is a wizard for creating a custom OLAP report by the user with saving options.
Forms with frequently used OLAP reports are created.
Geovisualization
An additional purchase of 1C: Enterprise 8 is required. GIS Spatial Data Management.
Available.
Multilingualism
Available.
Available.
Charts and graphs
Available.
Available on interface forms.
Import from Excel table
Processing is required.
Available.
Use of widgets
Not available.
Available.
User chat
Available.
Available.
Administration
User roles are created.
For each role, permissions for configuration objects are set.
Multiple roles can be assigned to a user.
User groups are created.
An individual interface and access parameters to objects are created for each group.
A user belongs to only one group.
Configuration
A 1C programmer with training in configuration in 1C is required.
The programming language is highly specific.
Experienced users perform straightforward tasks. Some complex procedures and triggers are created using the intuitive Builder Wizard.
For complex tasks, a programmer knowledgeable in T-SQL and VBScript is needed (it is mandatory to study this in all universities training programmers).
Application of modifications
When creating new objects, all users must stop working during the update process.
Users can continue to work as usual. To apply changes, the program needs to be restarted or F12 pressed.
Bulk data adjustment
A special form for changing group properties is available.
Special processing developed by 1C programmers is required.
All dependent data must be repopulated, or all modified documents must be reprocessed.
There is a possibility of bulk data change by the user from the table form.
The time for writing and executing scripts for data replacement in T-SQL is several times lower compared to 1C.
When using triggers that recalculate data during changes of others, discrepancies do not occur. For example, when bulk changing prices, the total in the row and in the document itself will be automatically updated.
WEB interface
Available.
Available.
Business processes
A graphical builder editor is available.
A graphical builder editor is available.
Conclusions:
1. The price of the initial purchase in the original version matches.
2. The cost of maintaining 1C is significantly higher, as assistance from a programmer is often required.
3. Some features in 1C are available, but for an additional fee.
4. The user interface in Client Communicator is much more convenient.
5. Enhancements in 1C are more time-consuming and require a certain level of specialist qualification.
6. The best server available is used for 1C at the enterprise, even if it's solely for accounting tasks.
Source: habr.com
