home - Miscellaneous
Retail torrent. Retail store software

Thanks to special software, keeping records of the movement of goods in stores, warehouses and other similar businesses has become much easier. The program itself will take care of saving and systematizing the entered information; the user only has to fill out the necessary invoices, register receipts and sales. In this article we will look at several of the most popular programs that are perfect for running a retail business.

MoySklad - modern programs designed for trading and warehouse enterprises, retail and online stores. For convenience, the software solution is divided into two parts:

  1. Cash program. Can be installed on any platform: Windows, Linux, Android, iOS. There is support for online cash registers (54-FZ), it is possible to connect the Evotor smart terminal, as well as any of the following fiscal registrars: SHTRIKH-M, Viki Print, ATOL.
  2. Cloud software for inventory accounting. Thanks to the technology used, data can be easily accessed through any browser - just log into your work account. It is designed to work with prices, discounts, and nomenclature. Here, both warehouse accounting and customer base are maintained, all necessary reports are generated and available for viewing.

MoySklad also has several other interesting, useful functions. In it you can create price tags in the interactive editor, and then send them for printing. Depending on the format of the outlet, sales can be carried out individually or in sets, taking into account modifications of the same product. For example, if it is a clothing store, a specific color and size of an item would be considered a modification. Work with bonus programs has been added - for purchases made within the framework of promotions, the program awards points with which the buyer can pay in the future. Payment itself is possible both in cash and through terminals that accept bank cards. It is also important that MyWarehouse operates in accordance with the law on mandatory product labeling.

Based on individual needs, the client is offered to manage a different number of sales points, add an online store or business platform on VKontakte. All users of MoySklad are provided with round-the-clock technical support, whose employees are ready to answer any questions that may arise. MyWarehouse for one user with one outlet is provided free of charge; for larger businesses, flexible tariff plans have been developed with payments starting from 450 rubles/month.

OPSURT

It’s worth noting right away that OPSURT is distributed absolutely free, which is rare for such software, since it is used in business. But this does not make the program bad - everything necessary is present here that the manager and other personnel who will use it may need. There is reliable password protection, and the administrator himself creates access levels for each user.

It is worth noting the convenient management of purchase and sale. You just need to select a name and drag it to another table for it to be counted. This is much easier than selecting it from the list, clicking and going through several windows to prepare the product for movement. In addition, there is the ability to connect a scanner and a receipt printing machine.

True Shop

The functionality of this representative is also quite extensive, but the program is distributed for a fee, and in the trial version half of everything is simply not available even for review. However, there are enough open options to form your opinion about True Shop. This is an unremarkable software with a standard set of tools used in retail trade.

We should also pay attention to the support for discount cards, which is rare. This function opens in the full version and is a table where all clients who have a similar card are entered. This feature allows you to quickly access information about discounts, expiration dates and other information.

Products, Prices, Accounting

“Products, Prices, Accounting” simply resembles a set of tables and databases, but this is only in appearance. In fact, it has more functions that are useful in conducting retail trade and tracking the movement of goods. For example, creating invoices for transfer or receipt and a register of goods. Documents and transactions are then sorted and placed in directories, where the administrator will find everything he needs.

It is possible to upgrade to other versions that provide extensive functionality. Some of them are in testing and not fully developed. Therefore, before switching, study the information in detail on the official website; the developers always describe additional versions.

Universal accounting program

This is one of the lightweight platform configurations developed by Supasoft. It is a set of functions and plugins that are most suitable for running small businesses such as stores and warehouses, where you need to track goods, prepare invoices and reports. The user can always contact the developers, and they, in turn, will help create an individual configuration for the client’s needs.

This version contains a minimum set of tools that may be needed - adding goods, companies, positions and creating free tables with various invoices and purchase/sale reports.

Movement of goods

A free program that helps you sort and store all the necessary information. Then you can quickly open, view and edit it. It is most convenient to work with invoices and reports, as there are convenient forms to fill out. The interface is also designed in the most comfortable style.

There is also a cash register management tool, where all the functionality is implemented in the form of a table. Products are displayed on the left and can be sorted into folders. They move to the adjacent table, where the price and quantity are indicated. Then the results are summed up and the check is sent to print.

Commodity and warehouse accounting

Another representative that has an unlimited number of configurations - it all depends only on the desires of the buyer. This assembly is one of them; it is distributed free of charge and is applicable to familiarization with the basic functionality, but for network work you will need to purchase a paid version. A program was developed on the ApeK platform.

There are many connected plugins, which are quite enough to conduct retail trade and monitor goods. Some functions may even seem superfluous to certain users, but this is not a problem, since they are disabled and enabled in the designated menu.

Client Shop

Client Shop is a good tool for retail trade. Allows you to always be aware of the status of the product, track all processes, draw up purchase and sales invoices, view directories and reports. Elements are distributed into groups in the main window, and the controls are convenient and there are tips that will help novice users understand.

This is not the entire list of programs that are suitable for owners of warehouses, shops and other similar businesses. They are good not only in retail trade, but also in performing other processes associated with working in such enterprises. Look for something that suits you individually, try the free version to understand whether the program suits you or not, since they all differ in many ways.

Year of release: 09/28/2012
Version: 2.0.5.5
Vista compatible: Full
Windows 7 compatibility: full
Windows 8 compatibility: full
Bit depth: 32bit+64bit
Interface language: Russian only
Tablet: Not required
Developer: 1C company
System requirements: OS: Microsoft Windows 2000/NT/XP/2003R2/Vista/2008/7/2008R2/8/2012 x86/64

Description: The program "1C: Retail 8" is designed to automate the business processes of retail outlets (stores), both independent and part of a distributed retail network. "1C: Retail 8" allows you to automate inventory accounting in store warehouses and cash accounting at store cash desks.

Add. information
The program "1C: Retail 8" automates the following operations:

Arrival of goods from the counterparty to the store’s warehouses, including in two-phase (order) mode;
sale of goods and services to the counterparty, including in a two-phase (order) mode;
movement of goods between stores, internal warehouses of stores, stores and warehouses of a trading enterprise, including in two-phase (order) mode;
trade in sets of goods created both at the time of sale of the goods and with the preparation of the set (operation "assembly");
returning goods from customers;
posting, inventory and write-off of goods;
registration of incoming and outgoing cash orders directly in stores;
movement of funds between stores, internal cash registers of stores, shops and cash registers of a trading enterprise;
issuing sales receipts, generating a summary report on the cash register at the end of the shift, taking into account returned goods per shift;
working with acquiring systems, accounting for payment for goods using payment cards, accounting for acquiring agreements and conditions for the return/non-return of a trade concession by the acquirer when returning goods; payment for goods with credits;
the use of percentage discounts on discount cards (including cumulative discounts), discounts divided by store, discounts to counterparties, discounts on the amount of the receipt, discounts by validity period, by quantity of goods, by type of payment.

"1C: Retail 8" supports the operation of the following retail equipment:

Fiscal registrars,
data collection terminals,
barcode scanners,
weighing equipment,
buyer displays,
payment terminals,
magnetic card readers.

Accounting for trading operations in "1C: Retail 8" is carried out only in rubles.

RIB and exchange with the control system

"1C: Retail 8" supports operation in distributed information base (RIB) mode with a clear division of document flow by store, where information on all stores in the network is consolidated in the main RIB node. Mechanisms for automatic initiation of exchange are provided.

Along with working in the RIB mode, the 1C: Retail 8 program can automatically exchange information with the management information system (back-office) in duplex mode. The “Trade Management” configuration, edition 10.3, can be used as a control system for the “1C: Retail 8” program; it is also planned to implement this feature in the “Manufacturing Enterprise Management” configuration. In the control system, you can create an unlimited number of “1C: Retail 8” nodes, which, in turn, can be the main nodes of a distributed information base.

User administration

Mechanisms are provided for administering users of the information base of remote RIB nodes from the main node "1C: Retail 8". For example, in the main node of the RIB, the system administrator can create (edit, assign roles, interfaces, reset passwords) a user of an infobase of a remote node, and also have access to up-to-date information about the settings of infobase users made in the "Configurator" mode (or in the "1C:Enterprise") directly in the RIB nodes.

Multi-company accounting

In the "1C: Retail 8" program, along with multi-store accounting, multi-company accounting is implemented, where each warehouse (sales floor) can be assigned to a specific organization. In this case, various taxation systems can be used: a general taxation system, a simplified taxation system. The program can also be used in stores that are registered under UTII (single tax on imputed income).

Work according to the order scheme

"1C: Retail 8" supports order schemes for the movement, sale and receipt of goods at store warehouses. The order scheme represents the movement of goods required for acceptance or shipment from the warehouse to the buffer list, while the actual operation with the inventory balance in the warehouse is carried out by an issue or receipt order. The 1C: Retail 8 program provides tools for operational control of received and shipped goods in the case of working according to an order scheme.

Features of accounting for goods and setting prices

In the "1C: Retail 8" program, for the purpose of simplification, records are not kept of the characteristics and series of items. If necessary, it is proposed to keep this accounting in the management system - in the “Trade Management” configuration. This ensures correct operation of data exchange between programs.

The "1C: Retail 8" program implements the ability to control the setting of prices for goods for each store separately, which ensures that the prices in the information base correspond to the price tags in the stores' sales areas. It is possible to work with product price types, which, if a management system is used, can act as recommended prices for retail trade. These prices may be adjusted for retail sales depending on the geographic location of the retail outlet (for example, if similar products are available at lower prices from competing organizations located in close proximity to the store). Mechanisms for creating layouts of price tags and labels and printing them from any types of “commodity” documents have also been implemented.

Trading activity analysis

The 1C: Retail 8 program provides various reports that allow you to analyze the activities of a store: conduct a valuation of goods at retail prices, analyze sales and returns of goods, determine at what time and which product sells best in various stores, as well as retail outlets. halls of one store (statistics of cash register receipts). The program provides the ability, based on an analysis of sales and current balances of goods in the store, to plan purchases of goods and automatically generate internal orders of goods for transferring them to the management system (Trade Management configuration).
New in version:

Version 2.0.5.5

Library of standard subsystems

This release uses the Standard Subsystem Library (BSL), version 2.0.1.17.
New features have appeared in the following subsystems:
Basic functionality:
- Storing links to metadata objects in the form of elements of the directory "Identifiers of metadata objects";
- Versioning of software interfaces.
Seal:
- Saving a printable form in PDF and OpenDocument formats when sending by email as an attachment;
- Editing the printed form before printing.
Working with files:
- Added a separate role WorkWithFileFolders to use the capabilities of the subsystem.

Retail store equipment
This release uses the Plug-in Equipment Library (PHL), version 1.0.10.2.

Marketing

Assortment management
Added functionality for managing the assortment of a chain of stores,
allowing:
- Describe the format of stores, group stores by format.
- Establish the composition of the product category: which products will represent each category in each format.
- Create an assortment of store formats.
- Set quantitative restrictions on depth (number of positions) for product categories in formats.
- Establish the role of the product in the format assortment, determine the stage of the assortment and assign the type of prices.
- Perform automatic control of operations with goods depending on the stage of the product life cycle in the assortment of a given store format.
- Conduct an analysis of the state of the assortment.
This functionality is available when using the 1C: Retail configuration offline. Support for this functionality in the "1C: Trade Management, Rev. 11.0" configuration is planned in the next release.
The ability to use this functionality is controlled by the "Use assortment management" setting in the Marketing section.

Attention! To start using the functionality in the completed database, you need to create a list of store formats and assign a format to each store. After this, you need to assign the store’s assortment using the proposed service for initially filling the assortment.
The formation of product categories can be done as needed, based on the convenience of users.

Carrying out inventory in the store using an order scheme

Attention! The document "Inventory of goods" has been renamed to the document "Recalculation of goods".

Added the ability to carry out inventories in a store using an order scheme when the "Use order scheme when reflecting surpluses and shortages" flag is set in the store.
- Added the ability to organize the recount of goods by several groups of accountants. To do this, using one document "Order for inventory", you can create several documents "Recalculation of goods" with an additional check for the intersection of inventory items.
- Added the ability to stagger the procedures for changing warehouse balances at the end of the recalculation and summing up the inventory in a given store (order scheme).
- To separate the users entering recalculation data and summing up the inventory, the profile “Responsible for summing up the inventory” has been added.

Attention! It is necessary to create an access group with a new profile "Responsible for summing up the inventory." Users who entered the documents “Write-off of goods”, “Capitalization of goods”, “Re-grading of goods” must be added to the created access group.

The status attribute has been added to the documents “Order for inventory” and “Recount of goods”. The status of the inventory process is determined by the status of the "Recalculation of Goods" documents entered under the "Inventory Order":
Recount has not started
In the process of recalculation
During the process of placing orders
In the process of registration of acts
Completed
- Added the report “Registration of surpluses and shortages of goods”, showing unfinished operations (formation of orders and generation of acts) in the context of orders and items.
- Added the ability to print inventory results based on the "Inventory Order" document. Forms INV-3, INV-19.
- Added assistant for filling out write-off reasons.

This functionality is available both when using the "1C: Retail" configuration independently, and when used together with the "1C: Trade Management" configuration, ed. 11. In the latter case, it is possible to distribute functions between configurations: the Retail user in the store enters the results of recounts and orders for writing off defects and defects, and the user of the 1C: Trade Management configuration summarizes the inventory results. Two-way exchange of created documents is supported.

Support of mutual settlements with suppliers

The functionality for accounting for mutual settlements with suppliers has been developed.
When using the "1C: Retail" configuration autonomously, it became possible to conduct settlements with suppliers in the context of "Order to supplier" documents.
- When planning payment stages in the Order to Supplier document, it became possible to take into account overpayments for previous orders to this supplier. Offsetting is carried out in the context of product documents “Order to supplier”, “Receipt of goods”, “Return of goods to supplier”.
- Added a non-cash payment registration document that allows you to enter a supplier payment made through a bank.
- Added the “Status of mutual settlements with suppliers” report, which allows you to see the company’s debt and overpayments to suppliers.
For enterprises that do not register orders to suppliers in the program, the ability to mark payment according to the “Receipt of Goods” document has been added.

For enterprises using the "1C: Retail" configuration together with the "1C: Enterprise Accounting" configuration, one-way uploading of non-cash payment documents to the supplier into the "1C: Retail" configuration is supported.

For enterprises using the "1C: Retail" configuration together with the "1C: Trade Management" configuration, the process of creating documents "Application for spending funds" in "1C: Retail" and approving it in "Trade Management 11.0" is supported. Unloading of non-cash payments is supported.

Support for offline cash register machines and scales with label printing in text mode

Added support for KKM-Offline equipment and scales with label printing.
Uploading of a product reference book onto scales with printing of labels and cash registers and downloading of sales reports from cash registers is supported.
It is possible to upload the full directory or only changed positions in accordance with the filters configured in the exchange rules.
To identify a product on Offline equipment and subsequently download the fact of its sale, the product code SKU is used - a product item code assigned in the context of accounting for inventory and sales of goods and services.
To weigh goods on scales, the PLU code assigned to the scales during exchange is used.
Equipment exchange functions are located in the "Sales/Retail Sales" section.

Data exchange

Exchange UT 11.0.9 - RT 2.0.5

Data exchange with the "Trade Management" configuration is supported, version no lower than 11.0.9.
For more details, see the document "Shared use with the 1C: Trade Management configuration", rev. 11.0, included in the delivery.

Exchange BP 2.0.40 - RT 2.0.5
Data exchange with the "Enterprise Accounting" configuration is supported, version no lower than 2.0.40.
For more details, see the document "Shared use with the configuration "1C: Enterprise Accounting", edition 2.0", included in the delivery.

RIB exchanges "Shopping" and "Workplaces"
Modified in accordance with the added functionality.

Displaying information in tabular parts of documents

Columns Article and Code have been added to document forms. The visibility of columns is configured by the "Additional column" parameter when displaying items.

Creation of technical profiles: Responsible for maintaining directories Nomenclature, Organizations, Contractors

To be able to separate users who enter and change the main objects of master data, the following profiles have been introduced:
"Responsible for maintaining inventory"
"Responsible for managing counterparties"
"Responsible for maintaining organizations"
Attention! You need to create access groups for new profiles and assign them to users.

Bugs fixed

1. Error processing additional rights when editing a line in RMK mode.
2. Error in registering the sale of serial goods to various organizations in the RMK Mode.
3. Error in filling out the invoice with retail prices: prices are filled in taking into account the frequency of the register “Up to a second”.
4. Error in calculating the amount for a price excluding VAT in the document “Return from a retail buyer”.
5. Error in filling out the “Responsible Persons” fields of the “Torg-12” printed form
6. Error in determining the "Current store" parameter in the RIB by store.
7. Error in granting rights to the directory "Magnetic Card Templates".
8. Error in calculating indicators in the report “Warehouse valuation (by price type)”.
9. Error in calculating prices for price groups using the “By other types of prices” calculation method.
10. Error in deleting movements of the “Replacement of discount cards” document.

Attention! Features of the RIB update

Error updating RIB when switching from configuration 2.0.4.5 to configuration 2.0.5
Description: When updating the RIB “By store” or “By workplace” from version 2.0.4 to version 2.0.5, a situation may arise in which the peripheral node cannot find the message file with data from the central node. The reason is a changed algorithm for forming the file name of the exchange message. In version BSP 2.0.1 in the “Data Exchange” subsystem, the substitution of node codes when forming a file name occurs with “cutting off” spaces on both sides.
Solution: After updating the main RIB node, you need to one-time rename the message files from the main node, adding spaces to them if necessary. In this case, the peripheral nodes will be able to download the update messages. After updating the peripheral nodes, data exchange will function as usual.

Especially for the site

Not so long ago, all reporting on trading operations was only on paper. Currently, for effective trade management it is necessary to maintain warehouse records, control debts, as well as an increase in the number of items of goods and documents. To successfully solve such a complex of problems, you need an effective program that will optimize and streamline all ongoing business processes.

How to choose your option for automating trading operations? The choice of automation method for retail depends on the following factors:

  • Store format.
  • Number of retail outlets to be automated.
  • Number of cash registers at each outlet.
  • The need to use additional equipment (scales, data collection terminals, barcode scanners).
  • Structures of building a trading network and features of building a management system within the network, movement of flows of goods and funds.

For more than 9 years, the Internet service MoySklad has been developing and implementing unique software for automating trade operations. Our software product lines are constantly being developed and updated. At the same time, we offer free and fully functional access to our service for a 14-day trial period. The advantages of our product can already be assessed in any store or retail outlet by downloading the program we offer without any payment.

The main advantages of our application are simplicity and ease of use. An intuitive interface allows users to get started right away, without special training or lengthy study of instructions. We invite you to test how easy and effective automated trade management can be using your own store as an example (you can download the application right now without paying for test use).

You can find out more detailed information about installing and using the MySklad retail management program from our specialists.

How does our trading software work?

The product was developed for small retail stores. This is a reliable, time-tested and very functional tool that can automate any activity related to trade (warehouse operations, product sales, return of goods, orders from suppliers, etc.).

By downloading the program from the MoySklad online service website and installing it in your enterprise, you can speed up routine processes as much as possible, automate data updating and ensure the normal functioning of the entire enterprise system. In turn, the user can create product positions, its properties and maintain movement documents:

  • Receipt of goods.
  • Its implementation.
  • Purchase returns.
  • Revaluation.
  • Write-off of goods.
  • Product packaging.

The program provides various types of reports that will display sales dynamics in a convenient form. The trading program is easy to use and not overloaded with unnecessary functionality. Once installed, you can get started right away, even without reading the help.

The retail software we offer is designed to work on a single computer, on a network, and over the Internet. This feature allows the user (whether a responsible person or the head of an enterprise) to monitor in real time the dynamics of sales and product balances for each outlet. Moreover, the user can control specific trading operations or the operation of the store as a whole even remotely (for example, while on a business trip or on vacation).

Benefits of the program for retail trade

Have you decided to start using a special program, but don’t know which one is better to choose? Once you discover the benefits of our trading management apps, you will be left in no doubt. The unique developments of the MoySklad service allow you to automate and optimize the necessary business processes, and make trade management as efficient as possible.

The trading program we offer has the following advantages:

  • reliability, accuracy and convenience of all operations that arise when registering sales and managing data;
  • simple and intuitive interface (appearance) of the program;
  • contains the necessary reports: on sales, by goods and categories, by clients, by sellers, by cash flow;
  • Suitable for automation of retail stores, kiosks, restaurants, etc.;
  • completely eliminates the risk of theft by personnel;
  • guarantees transparency of accounting of trade operations, assessment of the profitability and profitability of the enterprise;
  • allows you to make trading management easier;
  • reduces the likelihood of errors occurring during processing of the results obtained;
  • minimizes the influence of the human factor;
  • has qualified technical support;
  • has an acceptable cost.

We guarantee that from the moment you install the program, your trading work will become more comfortable and productive.

Effective trade management using MoySklad software

For more successful and productive management of your business, choose the MyWarehouse program. We offer a simple and reliable solution that combines in one program all the necessary functions for organizing, conducting and monitoring retail trading operations. This integrated approach makes the management process as efficient as possible and minimizes both the financial costs of running a business and the labor costs of your employees.

The program we offer has the following functionality:

  • performing any types of trading operations;
  • significantly expanding the ability to work in the information base;
  • searching for goods based on various characteristics and their combination;
  • work over a local network or via the Internet.

The free version is available for download on the MoySklad online service website.

In order for the store to operate efficiently and be profitable, all work processes must be automated and controlled by the manager. But how to keep records correctly and avoid cost overruns and theft? Let's find out in our article.

What is goods accounting in retail trade?

Retail accounting– this is an accounting of the movement (receipt, storage, sales) of goods in the store.

Purposes of accounting for goods in a store:

  • control the safety of goods;
  • control the sale of goods;
  • have accurate data on balances and turnover of a particular product;
  • have accurate data on the financial results of the store’s trading activities.

Goods accounting also includes:

  • management of goods reserves on the shelves and in the store warehouse;
  • checking the correctness of the documents accompanying the goods;
  • activities of store personnel;
  • the correctness of the inventory;
  • write-off/capitalization of losses and surpluses;
  • control over pricing.

To prevent this, connect the Business.Ru Retail program. It allows you to automate the work of both a single store and a chain of stores. Register sales quickly and easily and does not require an internet connection.

Keeping records of goods in retail trade

Conventionally, it can be divided into accounting for receipt of goods, accounting for sales and accounting for storage of goods.

When goods arrive at the store, the financially responsible person receives them based on the accompanying documents. These are waybills , invoicesTORG-12, certificates, specifications, etc.

At the same time, the correctness of their completion and compliance of the actual availability of goods with documentary data at the time of receipt of inventory materials, as well as the quality of the goods and its safety for the health of customers are checked.

In the event of a discrepancy between factual and documentary data in the required number of copies, a Discrepancy Report is drawn up in the TORG-2 form, where all detected discrepancies are indicated.

After acceptance, the documents, certified by the signature of the receiving person and the seal of the organization, are submitted to the accounting department for acceptance of the cargo for registration. After acceptance, the goods are sent for storage: to the store’s warehouse and sales areas.

Technologically, this process is divided into:

  • Acceptance of goods for storage;
  • Placement of goods;
  • Ensuring optimal storage conditions;
  • Control and care of stored goods;
  • Sending goods for sale, replenishing the stock of goods.

Storage of goods must be organized in accordance with all norms and rules that relate to this product. Should be optimal:

  • method of packing the goods;
  • temperature regime;
  • air humidity state;
  • commodity proximity (to avoid the influence of one product on another - mixing or transfer of odors, moisture, etc.).

Product losses that periodically appear during storage - broken, scrap, shrinkage, spoilage, etc. - written off according to the norms of natural loss - if the losses are not caused by improper storage and lack of control over the goods.

Accounting for sales in a retail store is carried out by issuing a receipt to the buyer for the purchased product.

Disadvantages of manual inventory of goods in a store

The main reason for all errors when accounting for goods in a store is the human factor. Inconsistency in the actions of staff with each other due to the lack or untimely receipt of information on the product, errors when punching a check, when posting goods and filling out documents, theft - these are the problems that become a serious obstacle to the development of the store and its profit.

By automating the accounting of goods in a store, an entrepreneur will be able to eliminate these problems, since it is the automation of accounting that makes it possible to control the movement of goods and the sales process in real time.

Automation of accounting in the store

Advantages of automating goods accounting:

  • helps keep track of the movement of goods;
  • records the process of selling goods in the cash register area;
  • controls product balances;
  • helps carry out inventory;
  • allows you to calculate the turnover of goods - based on sales analysis, it shows the demand for products;
  • helps control offsets with suppliers;
  • allows you to control the activities of store employees, recording all operations performed by them;
  • shows the financial result of trading activities, the profitability of the enterprise.

Programs for accounting for goods/sales at a point of sale

A program for automated accounting of goods in a store should:

  • meet the store's objectives;
  • cost according to the functionality it provides;
  • does not require a lot of time for installation and personnel training;
  • be easy to use;
  • have a clear and logical interface.

The online service Business.Ru was created for those who need a convenient and effective program for managing trade and warehouses. In addition, a program has been developed specifically for recording sales in the store to automate the cashier’s workplace Business.Ru Retail.

  1. Accounting for basic commodity transactions (receipt, expense, return, reservation, inventory)
  2. Accounting for sales and consumption of goods
  3. Accounting for orders from customers and orders to suppliers
  4. Internal movement, write-off of goods
  5. Tracking stock in warehouses
  6. Accounting for expenses of cash and small items (low-value and wear-and-tear items)
  7. Working with price lists
  8. Payment tracking
  9. Calculation and control of customer debts
  10. Calculation and accounting of salaries to employees
  11. Printing invoices, delivery notes, invoices, receipts, price lists, etc.
  12. Printing price tags, business cards
  13. Processing of commercial and logistics transactions with goods
  14. Movement of goods within the warehouse
  15. Accounting for customer activity and creating orders for suppliers based on it
  16. Work across multiple warehouses and retail outlets (creating several unrelated accounting groups within one warehouse accounting program)
  17. Control of cash and non-cash payments
  18. Creation of documents according to existing standards and arbitrarily
  19. Export, import and synchronize any data processed by the warehouse accounting and trade program
  20. Flexible database structure with customization for any task
  21. Network and multi-user modes, flexible configuration of access rights with restrictions on fields and records
  22. Customization - setting up menus, toolbars and other elements personally for each user

Integration with retail equipment

The functionality of the Warehouse and Trade program, like our other programs, has the ability to integrate with retail equipment.
Operation of the system with equipment such as barcode scanner, plastic cards, money box, receipt printer, data collection terminal etc. allows you to speed up work and improve the quality of customer service.
Read more about integrating the program with equipment on the pages and "Equipment".

Video on integration of FR Atol and Shtrikh-M

Also using the program you can:

  • Create, change, delete records, fields, tables
  • Import data into any database table from Excel or CSV text files
  • Delete duplicate records with the same values ​​for specified fields
  • Sort tables by any field, including sorting by several fields (up to 3) while holding down the Shift key
  • Filter the table by any field using the following operators: =, >, >=, "Contains", "Does not contain", "Starts with", "Does not start with", "Ends with", "Does not end with", LIKE, NOT LIKE
  • Group identical data in any field when the table is sorted by that field (for checked fields in table properties)
  • Mark entries as "Favorites", then they will be displayed in orange. The color is set in the table properties
  • Mark posts as "Dead" ("Uninteresting"), then they will be displayed in gray (or other) color
  • Set up color rules. You decide which lines to highlight, in what color and under what conditions.
  • Build a tree based on any fields with an arbitrary number of levels for hierarchical display of data from any table
  • Change data in any field (except ID and calculated fields) directly in the table or in a separate form (selected in settings), mark multiple records, delete, print, export marked
  • Change or delete multiple records at once in any database table using the Bulk Update form
  • Create new stored fields for tables of the following types: Text, Large text, Numeric, Yes/No, Date and time, Picture
  • Create calculated fields for tables, for example, you can create a field with the formula "[Field 1] / [Field 2]"
  • Create calculated fields whose values ​​will be taken from other tables.
  • Create new tables with exactly the same capabilities for actions with them as any other table
  • Link drop-down lists of fields to other tables for easy selection of values ​​from them when editing in a table or for selection from other forms when editing in a form
  • Set an arbitrary number of subordinate tables for any table (for which you need to set the binding by fields in the table properties)
  • Change the order of fields in any table using drag and drop or using the "Settings" form
  • Rename table fields and the names of the tables themselves in accordance with the specifics of your business.
  • Print the current view of any table, taking into account field visibility, width and order
  • Export data from any table to MS Excel or CSV text file, taking into account the current table view
  • Export the current record to MS Word based on a template file with bookmarks corresponding to field names
  • Work with multiple database files, create new databases, of course, you can also open them using MS Access.

Program installation

To install the program you need:

  • Download the program ProductsCount.msi
  • Launch the installer by double clicking on the downloaded file
  • Follow the instructions of the installer to install the program onto your hard drive.
  • Launch the program by selecting it from the “Programs” menu by clicking the “Start” button or a shortcut on the desktop.

Certificate of Rospatent

Version history


VersionWhat's new
2.950 1. Improvements to the VBScript interpreter
2.948 1. When moving an entry up or down, subordinate entries are now taken into account.
2. New internal commands GenerateBarcode and GenerateBarcodeEan13
2.946 1. Two new forms - Export to a folder with CSV files and Import from a folder with CSV files
2.945 1. Improved performance when importing from XML and CSV
2.941 1. New form "Counter settings" (called from the context menu by right-clicking on the ID field)
2.931 1. Improvements to the SMS mailing form
2.928 1. Improvements to functionality: interpreter, internal commands
2.913 1. Improvements to SMS mailing 2. Improvements to the VBScript interpreter
2.897 1. Improvements for integration with receipt printers
2.887 1. Import improvements
2.880 1. Integration with new models of receipt printers - Atol 30F, ShtrikhM PTK
2. Improvements to the "Simple filters" functionality
2.875 1. Added the ability to personalize the tree
2.872 1. New checkbox in the table properties - "Simple filters"
2.871 1. Added the ability to set business rules for subordinate tables - a different set of tables depending on the condition
2.858 1. Improved export to XML and import from XML 2. Improved reminders with the “All reminders in one form” checkbox
2.856 1. A new property “Field font size” has been added to the color selection rules 2. New internal commands: AddRecordsIntoSchedule (fill in the calendar for the year ahead), SetValueForCellRange (add to a group of cells), Sum (sum)
2.845 1. Improvements to export - in export forms of any type, you can select a template file from the database table 2. Improvements to export to RTF - you can use tags , ,
2.840 1. Added the ability to export to XML using a template
2.836 1. Scheduled import improvements
2.834 1. Import improvements, ability to import on a schedule 2. Ability to view a list of databases on different MS SQL Servers
2.832 1. Improvements to the configuration protection form - new options 2. Implementation of the Replace function in the default value and other places
2.829 1. New checkbox “Do not print empty table columns” in the form for generating a Word document using a template 2. The ability to store template files in a separate database table - tblTemplates
2.828 1. Improvements for the “Many-to-many” type of connection 2. Improvements in generating documents using templates with labels and
2.827 1. Ability to set more than one custom button for subordinate tables 2. Ability to enable the "ADD" button on the main toolbar 3. Improvements to the VBScript interpreter
2.823 1. Redesign of the "Export to CSV" form - the ability to export main and subordinate, as well as export using a template
2.801 1. Improvements to reminders in the case of "Show all reminders in one form" 2. Improvements to SMS mailing - new parameter "XML request"
2.790 1. Improvement of email newsletters - the ability to insert more than one image in HTML format, the ability to use bookmarks from subordinate tables
2.781 1. Improvement of the “Print receipts and labels” form, a new item in the “Service” menu, support for new equipment and the ability to use an RTF template
2.767 1. New checkbox in the field settings "Allow selecting a group of cells", useful for calendar tables when entering a full name in a date range
2.766 1. New internal command Translit - for writing Russian text in Latin 2. New internal command SetVisibleTabs - for setting visible tabs on the form for editing according to conditions from the script 3. Improvement of the RefreshTable, RefreshActiveTable, RefreshActiveSubTable commands
2.761 1. Added the ability to customize the toolbar for subordinate tables 2. In field properties, the functionality for creating composite indexes on several fields has been improved
2.752 1. Improvement of the “Printing receipts and labels” form, new equipment
2.751 1. Improvement of the VBScript interpreter 2. Improvement of the functionality Condition on the value 3. Improvement of color selection rules
2.743 1. Improvement of the "Print a receipt" form - added Fprint-11 receipt printer, the ability to set a script for the operation of POS equipment 2. Improvement of value conditions - the ability to call procedures 3. New commands GetControlValue, SetControlValue 4. Improvement of color rules - the ability to recognize NULL values
2.733 1. Improvements to the generation of Word documents - new endings _LETTERS for inserting each letter into a separate cell of the Word table, _DAYS, _WORKDAYS 2. New types of triggers - after adding a record, after deleting a record 3. Improvements to picture fields - output to the panel on the right from another table with the ability to edit, etc.
2.726 1. New right-click context menu item on the subtable tab “Show filter panel” 2. Improved export to CSV - ability to select fields
2.725 1. New button on the toolbar "Export table to XML"
2.723 1. Display of file fields in the form for editing 2. Storing custom images directly in the database for the form for editing, color selection rules 3. Ability to set a command when clicking on a custom image for the form
2.705 1. Improved functionality for storing pictures in the database, displaying links to pictures. 2. New types of links - “Link to image file” and “Link to file - short name” 3. Improvements to integration with the PsPhone IP telephony program - display the caller card, call PsPhone from the program with a dialer 4. New internal commands : SetTab, HideTab, relevant for flexible configuration of the form for editing using conditions
2.700 1. Integration with the IP-telephony program PsPhone has been implemented - when an incoming call, a client card is shown 2. New internal SetTab command for setting the current main tab or form tab for editing 3. The "Print all records in one file" checkbox is implemented in the "Export to" form HTML" and other improvements
2.688 1. New ability to quickly search across multiple fields
2.671 1. New checkbox in the table properties "Custom tree settings"
2.670 1. Possibility of passing parameters to user procedures 2. Improvement in duplicating records - second-level subordinate tables are taken into account
2.663 1. New type of link in field properties - link to file - short name
2.657 1. New type of trigger - when double clicking on a record 2. New ability to set hyperlinks in the edit form and in custom forms
2.655 1. New internal command GoToUrlAndImportXml, designed to obtain various information from sites (exchange rates, counterparty by TIN, etc.)
2.648 1. New setting in reports "Merge by fields"
2.642 1. Improvement of the “Field Settings” form - the panel on the left and the field rules are now personal settings
2.637 1. Refinement of the "Internet Search" form to obtain XML
2.633 1. Two new types of triggers: When opening a table and When switching to a tab 2. Improvements to export by template to RTF documents
2.626 1. New version of the help
2.612 1. Improvements to the “Add many” functionality
2.611 1. The ability to create forms and display them, for example, when starting a program or by command. List of forms in the Database Properties window
2.604 1. Ability to add custom buttons and images to forms for editing. 2. Improvements to generating documents using templates
2.601 1. Implementation of the "Print all records in one file" checkbox for Excel 2. Implementation of labels or to highlight a repeating block in Word and Excel template files and in reports
2.600 1. Form for generating documents using templates - instead of one, two checkboxes “Print all records in one file” and “Each record from a new sheet”
2.598 1. Ability to change the width of the drop-down list in the main or subordinate tables
2.594 1. New ability to customize the panel on the left, where you can place filter lists to filter the table with one click, as well as a calendar
2.593 1. New internal command InputFromList 2. New tab ending _NOFORMAT and _CODE128 for printing barcodes in office documents
2.585 1. Improvements to reports - you can apply filters for reports of any type, a drop-down calendar is shown for the "Date and time" fields
2.582 1. Improvements to reports - color selection and other settings can be applied when outputting to Excel in various combinations, according to a template and taking into account styles
2.579 1. Improvements to export to Excel - picture fields are saved in the file itself 2. Improvements to reports - the ability to display a report in Excel grouped by template
2.577 1. Import improvements - buttons for saving and loading all form settings
2.575 1. Improvements to export to Word and Excel in terms of color selection, as well as in reports 2. Improvements to export to RTF. Ability to specify the # symbol in bookmarks like tblTable_#_Field2_Field3, which prints the serial number of the record 3. In import forms, a new checkbox “Call procedure when finished”
2.569 1. In the color selection rules, there is a new ability to specify a picture (BMP file format) to display it in a table cell
2.562 1. New checkbox in the settings “Automatically check for updates at startup” and a new form for checking for a new version 2. Improvements to reports - the ability to specify complex SQL expressions containing nested queries, as well as several statements, not necessarily SELECT
2.545 1. New checkbox in the “Print grid” settings in the “Export table to Excel” form 2. When generating a document using a template, selected records of the subordinate table are displayed 3. Improvements to the VBScript interpreter
2.534 1. New form “Import from client bank” 2. Import improvements, redesign of the import form
2.532 1. Improvements in setting tooltips - they can be set for form fields 2. Improvements when outputting reports in Excel - when specifying several SQL statements, all tables are shown sequentially with headings 3. An algorithm for automatically arranging Tab sequences for form fields has been implemented
2.528 1. Improvements to setting tooltips 2. New internal commands: InputDate, InputDateRange, SetStatusText, SetMousePointer, SetVisibleFields, SetInvisibleFields, SetFieldsVisibility 3. Improvements to import from Excel files 4. Improvements to the VBScript interpreter
2.519 1. Setting up tooltips to display additional information when you hover the mouse; you can set formulas that depend on the text under the mouse. Called from the "Table Properties" form
2.518 1. In the field settings, the ability to fix certain table columns has been added so that they do not scroll when scrolling horizontally 2. Improvements to the VBScript interpreter
2.513 1. New preset values ​​for date and time field filters: Current quarter, Last quarter, Quarter before last, Next quarter 2. Improvements to import from Excel files - automatic search for the beginning of the table 3. Improvements to export to Excel using a template
2.509 1. New types of commands for triggers: Send email to everyone, Send sms to everyone, VBScript to everyone, which will be triggered for all records that satisfy the condition specified in the “Condition” parameter, and not for the current record. 2. Improvements to export to Excel
2.494 1. New types of bookmark endings when generating documents: _LETTERS (each letter in a separate cell of the Excel document), _LETTERSOVER#, LCASE, UCASE, _LEFT#, _RIGHT#, _MID#, _MID#AND# 2. The analyzer of custom SQL expressions has been improved and formulas 3. Improvements when working with MS SQL Server 4. New SMS providers added
2.472 1. Implemented “By Role” access rights with the ability to create custom roles
2. Added the ability to make database backups every time interval
3. Added the ability to set the default value for fields of the "Picture" type - file path
4. New type of link “Link to image file” in the field properties; pictures will be displayed in the same way as stored image fields
2.467 1. New form "Send e-mail using template"
2.452 1. New checkbox in the import form "Execute triggers"
2. New trigger time - "After adding an entry"
3. VBScript improvements
2.420 1. New checkbox in the field settings "Align field headers to the center"
2. Added the ability to specify “any field” in the color selection rules
3. Wood improvements - the ability to set arbitrary formulas for building levels and for filtering data
4. Improvements to exporting tables to Excel
5. VBScript improvements
2.413 1. New setting of the SubTablesEditInForm autoform, which can be set so that adding and changing records of subordinate tables of the form for editing is done through a separate form
2.412 1. Added new internal commands ExportTableToExcel, LoadFilters, CheckFilters
2. Improvements to exporting tables to Excel - color highlighting is picked up
3. Improvements to input into tables - impossibility of leaving the table if required fields are not filled in, maintaining the sorting of the drop-down list
4. Improvements to reports - you can specify several SQL statements separated by semicolons and, accordingly, get several tables in the report
5. VBScript improvements
2.397 1. Added the ability to minimize the program to tray (in the "File" menu)
2.394 1. Added internal commands EnableFields, DisableFields, EnableToolbarButtons, DisableToolbarButtons for blocking fields of the current record and buttons by condition. See screenshots in Gallery No. 25 and No. 26
2.391 1. A new custom button “Print receipt” has been added to the demo database configuration, in the “Sales” table.
2. New report setting - “Send report by email” when generating according to a schedule
3. Added a new internal command OpenDetailsForm to display a form for adding or editing a record in the current or another table
2.390 1. Added the ability to print a receipt on a receipt printer via the OPOS standard. The name of the PrintCheck command that can be set for a custom button to launch a form.
2. The editing form can now be minimized and expanded to full screen.
2.389 1. Added new internal commands: GoToRecord, GoToTableAndRecord, CopyRecord, CopyRecordAndSubTable, which can be used for custom buttons, as well as in triggers, reminders, etc.
2.388 1. For custom toolbar buttons, the ability to specify a VBScript command and, accordingly, code in this language has been added. Example in the Gallery, screenshot No. 23
2.381 1. Added implementation of second-level subtables in the form for editing (when setting ShowSubTables=1)
2.380 1. Improvements to the color selection rules - a new parameter “Field for color selection” (which may differ from the condition field)
2. Improvements when working with barcode scanners - automatic decoding of Unicode strings for some scanners
3. New autoform setting TabsPosition, which allows you to set the top, left, width and height for custom form tabs for editing, for example TabsPosition 900,900,8000,4000
2.378 1. New checkbox when adding a new report "Visible to everyone"
2. Improvements when working with a barcode scanner
3. Improvements to capturing images from a webcam
4. Changes in the “About the program” form - the ability to query the “Simple Software” database and obtain information about the licensee
2.376 1. New form "Export to text file", which allows you to make various transformations of existing text files (including HTML files) or generate new ones
2. For the "Date and Time" fields, the ability to set preset values ​​has been added - the day of the week (for example, "Sunday") and the month and year ("January 2013" or 01.2013 or 2013-01)
2.372 1. Improved import performance
2. New internal commands (MakeSnapshot, Emailing, Smsing, SendEmail, SendSms)
2.370 1. Added the value "(Any field)" to the table with filters for searching by any field in the table using filters
2. Added a new provider for SMS mailings sms16
2.367 1. The "Merge" field setting no longer depends on sorting and is always valid
2. Added error handling in triggers
3. New preset values ​​for the “Date and time” field filters - “For the previous 7 days”, “For the previous 5 minutes”, etc.
2.366 1. New menu item "Tools" -> "Internet Search"
2. In the field properties you can set a link to an internal program command
3. In the import form, the “Add” and “Delete” buttons have been added, and you can specify an arbitrary fixed value that will be imported along with the data
2.362 1. New checkbox "Make visible to all users" on the form for adding tables and tabs
2.361 1. In the demo database, the “Supplier” field has been added to the “Received Goods” table, and the “Total Sold” totals have been set, showing the total quantity of goods sold
2. Added the ability to save triggers to a file and load
2.358 1. A new “Import” button has been added to the toolbar, which makes it possible to import data only into the current table without the ability to select another
2. The InputBox(Prompt, Title, Default) command has been implemented, which can be specified in angle brackets in triggers and expressions
3. Improvements to search with the option "Output results in a list"
2.356 1. Improvements to reminders - a new “Message” parameter that will appear immediately before the reminder is triggered. Useful for Email or SMS sending
2. In the "Help" menu there is a new menu item "Check for a new version" that allows you to easily update
3. Import improvements
2.353 1. Improvements to "Conditions on value" - new option "Show message without prohibition"
2. Improvements to field properties in the “Link to program” part
3. Improvements to SMS distribution
2.351 1. New context menu item for fields - "Assign a value for all field entries..."
2. New context menu item for numeric fields - "Number all values ​​in the field..."
3. Import improvements
2.347 1. Improvements to email newsletters - added the ability to attach multiple files
2. Improvements for SMS distribution - added the ability to maintain a log file
2.344 1. The structure of the demo database has been slightly changed - the production trigger has been improved, some calculated fields have been replaced with stored ones
2. Improvements to export to Word using a template - now you can specify bookmarks directly in the document text in square brackets
3. In the parameters you can set the formula for the folder with templates
2.342 1. Added the ability to filter a list of values ​​from another table when entering into a calculated field
2. Improvements to triggers - now they also work for subtables in case of deleting the main record along with subordinate records
3. Improvements to the tree - it is built correctly and filters in the case of fields with the "Multiple selection" checkbox ticked
2.339 1. Improvements to SMS messaging - a new provider has been added
2. Improvements to reports - when using custom filters in SQL type, the table with filters shows possible values
2.336 1. Added the ability to send SMS based on a trigger or as a reminder.
2.334 1. For MS SQL Server, you can specify a call to a stored procedure as an SQL instruction, for example “call dbo.sp1(“param1”)”. But when you subsequently create an Access database, all the logic of the stored procedures will be lost.
2.332 1. New checkbox in the import form - "Fill in default values"
2. The structure of the demo database has been changed - a stored field "Article" (ProductCode) has been added to many subtables instead of a calculated one
2.320 1. Improvements to triggers - you can refer to calculated fields of a saved record
2.315 1. Added the ability in triggers (and not only) to indicate a link to the previous value of a field (which was before editing) by specifying the field in curly braces.
2.311 1. Improvements to the generation of Word documents
2. Improvements to SMS distribution
2.305 1. Improvements to SMS distribution
2.303
2.301 1. Import improvements
2.300 1. Improvements when working with a barcode scanner
2. New checkbox in the form "New Word/Excel document using template" - "Do not print empty tables"
2.296 1. New form "Import from XML file" with the ability to set a schedule for this task
2. Changing the form of report parameters - added the name of the target report file with the ability to save reports in a specified folder
3. When the "Show list of databases at startup" setting is enabled, the ability to select a DBMS has been added
2.295 1. Implemented the “Show list of databases at startup” setting in the case of MS SQL Server
2.290 1. Changes in the structure of the demo database: a number of triggers have been added for the “Received Goods” and “Components” tables, changing prices and the total cost of products
2. “Folder link” has been added to the field properties
3. Improvements when working with MS SQL Server in the case of nested subqueries in the FROM part of views
2.288 1. Added “Link to folder” to the field properties
- correct work with nested subqueries in the FROM part
2.285 1. Added the ability to set color rules for individual cells in the table
2.283
2.280 1. Improvements to multiple selection in the subtable using the "Add many" button
2. Improvements when working with MS SQL Server
2.276 1. In access rights, in horizontal filtering rules, you can set the restriction "Prohibition of deletion"
2. When generating Word documents using a template, you can set a bookmark in the form of text in square brackets in the first cell of the table (as in an Excel template) so that the table header remains unchanged
2.274 1. The structure of the demo database has been changed
2. Improvements in customizing menus and toolbars
2.273 1. Changes in the structure of the demo database - return to the previous version of the structure without performance problems
2.272 1. Improvements in menu settings - the ability to hide or block individual context menu items
2. Changes in the structure of the demo database - the "Production" block
2.270 1. In the “Field settings” form, a new checkbox “Show context menu for records”
2. Some reports have been corrected in the demo database configuration
2.268 1. Added a functional block for SMS sending
2. Improvements when working with MS SQL Server
2.266 1. Improvements when working with MS SQL Server
2.254 1. Improvements when working with MS SQL Server
2.253 1. A new report “Total number of goods in all warehouses” has been added to the current demo database.
2. Improvements to the logic for creating a database on MS SQL Server using the current Access database
2.248 1. Improvements to the logic for creating a database on MS SQL Server using the current Access database
2. Improvements to export to XML
2.247 1. Added the ability to specify the encoding when exporting to XML and CSV
2.245 1. Added functionality to export the entire database to XML text format, called by the administrator from the "File" menu
2.244 1. The structure of the demo database has been changed - the “Production” functional block is now placed in two separate physical tables tblProduction and tblProductionProducts
2. The qdfStoresState view now shows products taking into account accepted reserve orders
2.243 1. The capabilities of fields with a link to a file have been expanded - by clicking on the button with an ellipsis, menu items are shown, incl. item "Assign a link to a file with copying to the server"
2.238 1. Improvements to access rights - for horizontal filtering rules in the “Value” column, you can set them using AND or OR and other conditions
2.236 1. Improvements to second-level subordinate tables - now you can assign them to any subtable
2. Improvements to the functionality of multiple additions to subtables
3. Improvements to triggers
4. Improvements to the conditions for the value
2.227 1. Reconstruction of the Condition on value form, which now allows you to set the construction “If... Then... Otherwise...”
2. The panel on the right is now personal settings

2.225 1. Two reports “Customer Balance” and “Supplier Balance” have been reconstructed.
2. Improvements to filters in reports with custom filters
2.224 1. The structure of the demo database has been changed - in the “Sold Items” table in the “Product Code” field, the selection is made showing the balances in the warehouse
2. When sending an email using a trigger, simultaneous execution of an SQL statement is now possible
2.222 1. The "Allow input in a field of another table" checkbox now works in the case of MS SQL Server when editing in a table
2. Improvements to export to Word and Excel using templates
2.221 1. Improvements when copying text via the clipboard - questions no longer appear instead of Russian letters
2. Improvements to filters in reports - a list of possible values ​​is shown in the case of custom filters
2.219 1. Improvements in the algorithm for creating a database in MS SQL Server format based on the current Access database structure
2.217 1. Improvements when working with drop-down lists when editing in a table
2. Improvements to the conditions for the value when editing in the table
3. For the “Sold Items” table, a condition has been set for the value of the “Quantity” field, which warns if a quantity is entered that is greater than in stock
2.216 1. Improvements to trigger conditions
2.211 1. For custom buttons on the toolbar, the ability to set the command type to “Execute SQL” has been added
2. Added a new type of triggers “When the table is updated” (the “When triggered” parameter)
3. Improvements in the algorithm for creating an Access database using the current MS SQL Server database
2.208 1. Improvements to access rights settings (horizontal filtering rules)
2. Added the ability to set the “Many-to-many” relationship type between views
2.204 1. Changed the qdfBuyPrices view ("Last purchase prices") for portability under MS SQL Server
2. Improvements to create an Access database based on a MS SQL Server database and vice versa
3. The “Proxy server” parameter has been added to the functionality of email newsletters
2.201 1. The structure of the demo database has been changed - a new table “Currency rates”, assigned as a subordinate table for the table “Currencies”
2. Improvements to create an Access database based on the MS SQL Server database
2.196 1. Added a new table "Product groups" to the demo database
2. Improvements to reminders
3. Import improvements
2.195 1. Improvements when working with the barcode scanner
2.190 1. Integration with a barcode scanner has been implemented - if there is a BarCode field in the subtable table, the cursor is positioned in it and other improvements
2. The structure of the demo database has been changed - in the “Sales” table editing is enabled in the form with a subordinate table shown in the editing form for convenient work with the barcode scanner
3. Import improvements
2.187 1. A new property has been added to the form settings for editing - ShowSubTables, which allows you to show subordinate tables in the form
2. A number of other improvements
2.185 1. Improvements to the "Add many" button - added the ability to work with a barcode scanner
2. Import improvements
3. Security improvements
4. Toolbar customization improvements
2.184 1. In the toolbar settings, the ability to set many parameters has been added when generating a document using a template
2. Added a new type of trigger that fires when opening and closing the editing form
3. Improvements to quick search
2.183 1. Improvements to the conditions for the value
2. Import improvements
2.179 1. Added the possibility of exclusive login
2.177 1. New trigger time - "When the form is opened"
2.175 1. Improvements to the panel on the right - you can set arbitrary calculated fields
2. A number of other improvements
2.170 1. Improvements to triggers - new trigger time "After adding, changing, deleting an entry"
2.167 1. Improvements to triggers - now they also work with some multiple operations
2.164 1. Improvements to quick search
2.157 1. Improvements to triggers: in the “Confirmation” column you can indicate bookmarks in angle brackets - links to the fields of the current record
2. Added a new checkbox to the form "Make all ID values ​​sequential" - "Make a database backup"
2.153 1. Import improvements
2. Improvements to quick search
2.148 1. Improved quick search - no longer replaces current filters
2. Added context menu item "Paste from clipboard" for image fields
3. Trigger improvements
2.145 1. New checkbox in the quick search settings - “Search by the condition “Contains””
2. A number of other fixes and improvements
2.144 1. Added a button for multiple additions to subordinate tables when selecting from the directory while holding Ctrl or Shift (when editing in the form)
2. Improvements for working with MS SQL Server - the algorithm for creating a new MS SQL database using the current Access structure has been improved
2.142 1. The structure of the demo database has been changed (significantly) - all links to products are now based on the ProductID field, as was previously the case in DemoDatabase_3.mdb
2. A single database was chosen as the basis, the remaining databases were abolished. Now only DemoDatabase.mdb will be developed
3. The concept of “Product Set” was introduced - specified quantities of certain components. When a set is sold, its components are written off
4. A number of improvements and improvements in the program
2.141 1. Improvements when migrating databases to MS SQL Server
2.140 1. The structure of the demo database has been changed - new directories “Currencies” and “Units of Measurement”, new fields in some tables.
2. The document template "Invoice" has been changed
3. Included is a template for a new document "Invoice M11"
2.137 1. The logic for constructing default values ​​for the "Date and Time" fields has been improved
2. A number of other improvements
2.130 1. Improved export to HTML and office documents
2. Added a new form for setting up form tabs for editing
3. Improved logic for deleting fields
2.129 1. New field type - “File” for storing relatively small files in a database table field (up to 1024 KB), file fields are displayed in both the main and subordinate tables
2.125 1. New field type - “File” for storing relatively small files in a database table field (up to 1024 KB)
2. Added a second parameter "Option 2" in the toolbar configuration table - you can save the name of the generated file in the field when you click on the custom button
3. In the demo database configuration, totals have been added to the “Products” table, showing the current quantity of goods in stock
2.123 1. Improved logic for adding fields to complex views (such as "Warehouse status")
2.122 1. Improved work with filters - filters are saved when opening a table in selection mode
2. For a quick search, you can hardcode the search field. This is done from the right-click menu
3. New new value for triggers “When triggered” - “When adding, changing and deleting a record”
2.120 1. Added two items to the context menu for entries: “Move entry up” and “Move entry down”
2. Added the ability to rename the table name in the table properties
2.118 1. Improvements for working with MS SQL Server
2. Performance improvements
2.117 1. New ability to run reports on a schedule - a “Scheduled” button has been added to the report settings form
2. Optimize performance when working with complex views
2.113 1. Improvements to the “Print price tags” report - price tags appear in two columns
2.111
2.109 1. Added the ability to add fields from other tables to complex views (such as “State of warehouses”, etc.)
2. Security improvements - added encryption of passwords for the database
2.107 1. Improvements to triggers
2.106 1. Improvements to the DemoDatabase.mdb structure - added the "Outgoing Payments" table and 2 reports: Customer Balance and Supplier Balance
2. Improvements for export to Excel - data types are converted more correctly and formatting is applied
3. Improvements to deletion triggers
2.105 1. Trigger improvements - new type of operation "send e-mail"
2. Mailing improvements - new "Delete duplicates" button
2.104 1. Improvements in trigger functionality
2. Mailing improvements
2.101 1. Improvements to triggers - deletion triggers have been improved, events have been added for triggers: every minute, every hour, when the program starts, when the program exits
2. Improvements to the change history - the deletion operation is recorded in the change history
3. Improvements to the functionality for removing fields from complex views
2.100 1. Improvements for working with MS SQL Server

2.96 1. Added quick search panel. Enabled from the right-click menu on the toolbar
2. Added drop-down calendars for the "Date and Time" fields in the format without time
3. Improvements to the structure of the demo database - in the “Products” table there is a new field “Supplier”
2.92 1. Improvements to create a database structure in MS SQL based on the Access database structure
2.87 1. Added the ability to customize the form toolbar for editing (custom buttons)
2.85 1. Updated toolbar
2. Improvements to the functionality of generating Excel documents using templates
2.84 1. A template has been added for the document "Consignment note" Template TTN.xls
2. Improvements to the drop-down lists of the table (resizing the list with multiple choice, etc.)

4. Improvements to the conditions for the value
2.82 1. New toolbar design
2. Added a new checkbox "Apply record style" in the form for exporting tables to Excel and HTML
3. Improvements to the condition for the value in the field properties - you can set it like "= "
4. Improvements to the functionality Group update - you can add a range of records to the table from a certain index and with a given step
2.80 1. Improvements to the form designer - you can flexibly set arbitrary inscriptions and frames
2. Improvements to adding new records to subordinate tables when editing in the table - can be added if there is an unsaved record in the main one
2.79 1. Improvements for working with MS SQL Server
2.78 1. In field properties, the ability to add several fields from another table at once has been added
2. Added a vertical scroll bar when using custom forms for editing
3. The structure of DemoDatabase_3.mdb has been slightly changed - the trigger for the "Orders to suppliers" table has been modified
2.77 1. Improvements to triggers
2. Improvements to export to RTF format
2.76 1. The structure of DemoDatabase.mdb has been slightly changed - the trigger for the "Orders to suppliers" table has been modified
2.75 1. Added two preset constants “Current time of any date” and “For x minutes” for the values ​​of filters or reminders of fields of the “Date and time” type.
2. Improvements to triggers
3. Improvements for working with MS SQL Server
2.73 1. Import improvements in case of using the "Update data" checkbox
2. Improvements to export to RFT format (support for compound bookmarks, global constants, sums in words)
2.68 1. Added a number of constants for flexible settings for generating amounts in words when generating documents
2.67 1. Added the ability to set arbitrary inscriptions (labels) in the form designer for editing
2.65 1. Added form designer - the ability to design custom forms for editing with grouping by tabs
2. When generating office documents using templates, processing of one more ending _spellmoneyint has been added - the amount in words without specifying 00 kopecks
2.63 1. Added support for cascading changes. For example, when changing the value of an article in the product table, the program will prompt you to also change this value in related tables
2. Added the ability to specify second-level subordinate tables (3 tables on the tab - main, subordinate and subordinate to subordinate). To do this, in the setup table, in the field of the main table, you must specify the name of the first subordinate table, a dot and the name of the field
3. The structure of the demo database has been slightly changed: new values ​​have been added to the table of receipt and write-off of goods, in the "Operation Type" field: Return of goods and Regrading
2.62 1. The structure of the demo database has been changed: all product links are again made using the ProductCode field (Article)
2. By right-clicking on any foreign key field of any table, an option to go to another table will always be shown (if it is present among the main tabs)
2.61 1. Improvements to triggers
2.60 1. Improved functionality for deleting fields present in complex views
2. Added the ability to set triggers for deleting and moving through records in the table
3. The structure of the demo database DemoDatabase.mdb has been slightly improved
2.58 1. The structure of the demo database has been changed: triggers have been modified in accordance with the new structure of connections for the ProductID field
2. A number of other improvements and fixes
2.56 1. The structure of the demo database has been changed: all product links are now made using the ProductID (Product Code) field, and not by ProductCode (Article) as before
2.53 1. Adding a field from another table - in some cases, you can add fields to complex views, for example, in the "Warehouse Status" view, display a field from the "Products" table
2.52 1. Changes in the structure of the demo database: another subordinate table “Chronology” has been added to the main table “Products”
2. Changes in the structure of the demo database: a custom button has been added to the “Sales” table - “Check” with the associated script PrintCheck.vbs for printing a check through the fiscal registrar. The script file contains detailed comments.
3. Improvements in reports (graphs in reports, etc.)
2.50 1. Report display performance improvements
2. Two service buttons have been added to the field properties: “Copy the settings of this field to another field” and “Copy the settings of all table fields”
3. In the mailing form, a text field has been added to indicate the port number of the SMTP server
2.46 1. Fixed several bugs
2.40 1. In the field properties there is a new artefact “Condition on value” with the ability to enter a formula with the construction “If... Then...”
2. In the field properties there is a new checkbox "Fill in the default value only when focus arrives"
3. Optimized speed of working with the database and a number of improvements for working with MS SQL Server
2.38 1. Changes in the structure of the demo database: the “Sales, expenses and profit for the period” report has been improved
2. Changes in the structure of the demo database: the views qdfArrivalsProducts, qdfProductsHistory, qdfStoresState, qdfStoresStateWithReserve have been updated
2.34 1. Improvements when working with MS SQL Server
2. A number of other improvements and fixes
2.28 1. A new attribute “Condition on value” has been added to the field properties
2. In the field properties, “Link to Skype” has been added to the list of link types
2.27 1. A new report “State of warehouses as of date” has been added to the demo database configuration
2. Another filter “Warehouse code” has been added to the “Turnover sheet (quantity)” report
3. Improved "Calendar" in filtering mode by the condition "From... to"
2.25 1. In the field settings, a new “Calendar” checkbox has been added to display calendars in the preview panel on the right
2.23 1. Fixed a bug in the operation of triggers
2.22 1. Search has been improved: new options “(All fields)” and “(All fields of the main and subtables)” have been added.
2. In the demo database configuration, an error in the “Sales, expenses and profit for the period” report has been corrected
2.21 1. The following fields have been added to the "Warehouse Status" view: Product group, Family, Type, Unit of measure, Limit
2. On the main “Sales” tab in the “Sold Items” subtable, for the “Article” field, a formula is set for selecting only those products that are in stock
2.20 1. Added the ability to specify multiple SQL statements separated by semicolons in the report data source. Works when using a template file with labels, etc.
2.13 1. A new report “Sales, expenses and profit for the period” has been added to the demo database configuration
2.10 1. A new functional block “Production” and a tab of the same name have been added to the demo database configuration
2. Added another demo database with a simplified structure (no documents and ProductCode fields)
2.6 1. New version of the help system
2.5 1. The structure of the demo database has been changed: the error of incorrectly counting product balances in the presence of movements has been fixed
2.4 1. New report "Turnover sheet for warehouses with amounts"
2. New entry context menu item "Insert default value" (if a default value is defined for the field)
3. Improved some triggers
2.1 1. Added export and generation of documents using a template in RTF format
2. Added the ability to search in all fields
3. In the field properties and table properties there is a new checkbox "Read only"
2.0 1. Added support for Microsoft SQL Server 2000 - 2008 DBMS
1.33 1. New report "Sales and payment"
2. In the field properties form, a new checkbox “Read only” (valid for all users, including administrators)
3. New autoform setting "FieldsPositions", which allows you to set field positions on the form in the format "Field1:left,top Field2:left,top"
1.31 1. When you check the "Completed" checkbox on a customer order, it is transferred to sales. When you check the "Completed" checkbox on an order to a supplier, it is transferred to the receipt. Implemented on triggers that can be flexibly adjusted
2. A number of improvements for triggers - the ability to set the trigger condition, the text of the confirmation message, etc. Triggers have been added
3. Improvements for duplicating and deleting records
1.29 1. Two templates have been added to the distribution package: Template PKO.doc and Template RKO.doc, documents for which are generated from the “Cash desk” table
2. A number of fixes when working with replication
1.26 : new tables “Payments”, “Agreements”, “Works”, “Dealer agreements”, etc.
2. Added the ability to create HTML reports with pictures. New report "Products with pictures"
3. New checkbox "Merge" in the field properties
4. New checkbox "Read only" in the table properties, the ability to set the highlighting style for the current record
5. A number of other improvements and fixes (reminders, reports, speed optimization)
1.23 1. The structure of the demo database has been changed
2. Improved functionality for entering values ​​into a calculated field from another table when editing in the table
3. A number of other improvements and fixes (reminders in one form, scroll bar for the detail panel on the right)
1.16 1. The structure of the demo database has been changed: the “Group” field has been added to many views and reports.
2. Added the ability to customize the quick view panel on the right, the fields for which are set in the field settings
3. A number of other improvements and fixes
1.15 1. The structure of the demo database has been changed
2. A number of other improvements and fixes
1.14 1. Templates for all documents have been redesigned
2. The structure of the demo database has been changed: fields for VAT have been added to the “Sold Goods” table. (In case of accounting without VAT, these fields can be hidden or deleted.)
3. Improvements for exporting to Excel using a template: the ability to set bookmarks like and , as well as
4. Additional settings in field settings
1.13 1. Added a new report "Employee Business Cards"
2. Fixed the error of incorrect filling of the receiving warehouse during internal transfer
3. A number of improvements in multiplayer mode
1.12 1. New attribute of the “Confidential” field in the field properties for marking secret fields (for example, “User Password”, etc.)
2. Added a checkbox in the field settings "Allow changing field positions by dragging and dropping" (valid for all users)
3. Implemented row offset when inserting tables during the generation of an Excel document using a template
4. Ability to copy an entry to the clipboard and paste an entry from the clipboard
1.11 1. New tables have been added: Expenses, IBP Expenses, Cash, Salaries
2. Modified the report "State of warehouses with reserves" and others
3. Two fields have been added to the “Received Goods” table: “Price in currency” and “Currency”
4. The “Payment amount” field has been added to the “Sales” table
1.9 1. Added a new report "Printing price tags"
2. Added the ability to set an HTML template for a report in the report properties
1.7 1. New tables have been added: “Orders to suppliers”, “Expenses”, “Cash desk”
2. Added the ability to change the field type
1.5 1. New reports have been added: "State of warehouses with reserves" (with ordered goods), "Chronology of receipts", "Chronology of consumption"
2. The report "Turnover sheet" now has two versions: only quantity and with amounts
1.2 1. Improvements for working in multi-user mode
2. New context menu item for entries "Filter by text" for quickly filtering the table by text in a cell
3. Ability to set styles for reports (in the report settings form)
4. New report "Turnover sheet"
 


Read:



Responsibilities of a Customer Support Manager

Responsibilities of a Customer Support Manager

Customer service manager is a profession that requires a high level of knowledge in building dialogues with customers, establishing relationships with management in their...

Output as an indicator of labor productivity

Output as an indicator of labor productivity

Labor productivity characterizes the efficiency of labor in material production. This is not only one of the most important performance indicators...

Error Prevention Process Used in Lean Systems Lean Manufacturing

Error Prevention Process Used in Lean Systems Lean Manufacturing

Don't lose it. Subscribe and receive a link to the article in your email. Japan knows a lot about the quality of its products and many of us are familiar with...

What is margin in trading?

What is margin in trading?

Hello, dear readers of the blog site. For those who, to one degree or another, are faced with the topic of doing business or any other...

feed-image RSS