01.01.2022

The simplest program for the warehouse. Trading warehouse


  1. Accounting for basic commodity operations (incoming, outgoing, return, reservation, inventory)
  2. Accounting for sales and consumption of goods
  3. Accounting for orders from buyers and orders to suppliers
  4. Internal movement, write-off of goods
  5. Tracking stock balances
  6. Accounting for cash and IBE expenses (low-value and wearing 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, waybills, invoices, checks, price lists, etc.
  12. Printing price tags, business cards
  13. Processing of commercial and logistics operations with goods
  14. Movement of goods within the warehouse
  15. Accounting for customer activity and creating orders to suppliers based on it
  16. Work across multiple warehouses and retail outlets (creating multiple unrelated posting groups within a single inventory control program)
  17. Cash and non-cash payment control
  18. Creation of documents according to existing standards and arbitrarily
  19. Export, import and synchronization of 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 - customization of menus, toolbars and other elements personally for each user

Integration with trading equipment

The functionality of the program "Warehouse and trade", as well as our other programs, has the ability to integrate with commercial equipment.
System operation with equipment such as barcode scanner, plastic cards, money box, receipt printer, data collection terminal etc. allows you to speed up the work and improve the quality of customer service.
More details about the integration of the program with equipment on the pages and "Equipment".


Also with the help of the program you can do the following:

  • Create, modify, delete records, fields, tables
  • Import data into any database table from Excel or CSV text files
  • Delete duplicate records with the same values ​​of given fields
  • Sort tables by any field, including sorting by multiple fields (up to 3) while holding the Shift key
  • Filter a table by any field using the following operators: =, >, >=, "Contains", "Does not contain", "Starts with", "Does not begin with", "Ends with", "Does not end with", LIKE, NOT LIKE
  • Group the same data in any field when the table is sorted by this 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 entries as "Dead" ("Uninteresting"), then they will be displayed in gray (or other) color
  • Set color rules. You yourself determine which lines, what color and under what conditions to highlight.
  • Build a tree by any fields with an arbitrary number of levels for hierarchical display of data from any table
  • Change data in any field (except for ID and calculated fields) directly in the table or in a separate form (selected in the settings), mark several records, delete, print, export marked
  • Modify 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, Big text, Numeric, Yes/No, Date and time, Image
  • 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 options for actions with them as with any other table
  • Link drop-down lists of fields to other tables to easily select values ​​from them when editing in a table, or to select 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 the fields of tables 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 the visibility of the fields, their width and order
  • Export the data of any table to MS Excel or a text CSV file, taking into account the current table view
  • Export the current record to MS Word based on a template file with bookmarks corresponding to the field names
  • Work with several database files, create new databases, of course, you can also open them with MS Access.

Program installation

To install the program you need:

  • Download Program ProductsCount.msi
  • Run the installer by double clicking on the downloaded file
  • Install the program on your hard drive following the instructions of the installer
  • Run 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 CSV folder and Import from CSV folder
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. Functional improvements: interpreter, internal commands
2.913 1. Improvements in SMS messaging 2. Improvements in the VBScript interpreter
2.897 1. Improvements in integration with receipt printers
2.887 1. Improvements on import
2.880 1. Integration with new models of receipt printers - Atol 30F, ShtrihM PTK
2. Improvements to the "Simple Filters" functionality
2.875 1. Added the ability to set tree personalization
2.872 1. New checkbox in 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. Refinement of export to XML and import from XML 2. Refinement of reminders with the checkbox "All reminders in one form"
2.856 1. A new property "Field font size" has been added to the color highlighting rules 2. New internal commands: AddRecordsIntoSchedule (fill the calendar a year in advance), SetValueForCellRange (add to a group of cells), Sum (sum)
2.845 1. Improvements in export - in export forms of any type, you can select a template file from the database table 2. Improvements in export to RTF - you can use the tags , ,
2.840 1. Added the ability to export to XML using a template
2.836 1. Scheduled import improvements
2.834 1. Improvements on import, the ability to import on a schedule 2. Ability to view the 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 columns of tables" in the form for generating a Word document from a template 2. Ability to store template files in a separate database table - tblTemplates
2.828 1. Improvements for "Many-to-many" relationship type 2. Improvements in document generation based on 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. Processing of the form "Export to CSV" - the ability to export the main and subordinate, as well as export by template
2.801 1. Improvements to reminders in the case of "Show all reminders in one form" 2. Improvement of SMS mailing - new parameter "XML request"
2.790 1. Completion of email newsletters - the ability to insert more than one picture in HTML format, the ability to use bookmarks from subordinate tables
2.781 1. Completion of the "Print receipts and labels" form, a new item in the "Service" menu, support for new equipment and the ability to use the RTF template
2.767 1. A new checkbox in the field settings "Allow to select 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 by condition from the script 3. Refreshing commands RefreshTable, RefreshActiveTable, RefreshActiveSubTable
2.761 1. Added the ability to customize the toolbar for subordinate tables 2. In the field properties, the functionality of creating composite indexes on several fields has been improved
2.752 1. Completion of the form "Printing receipts and labels", new equipment
2.751 1. Refinement of the VBScript interpreter 2. Refinement of the functionality Condition on the value 3. Refinement of the color selection rules
2.743 1. Refinement of the "Receipt Print" form - the Fprint-11 receipt printer has been added, the ability to set a script for the operation of POS equipment 2. Improvement of the conditions for the value - the ability to call procedures 3. New commands GetControlValue, SetControlValue 4. Improvement of the color rendering rules - the ability to recognize NULL values
2.733 1. Refinement of 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 an entry, after deleting an entry 3. Improvements in image fields - output to the panel on the right from another table with the ability to edit and so on
2.726 1. New context menu item on the right click on the subtable tab "Show filter panel" 2. Improved export to CSV - the ability to select fields
2.725 1. New button on the toolbar "Export table to XML"
2.723 1. Displaying file fields in the form for editing 2. Storing user images directly in the database for the form for editing, color selection rules 3. Ability to set a command when clicking on a user image for the form
2.705 1. Refinement of the functionality of storing images in the database, displaying links to images. 2. New types of links - "Link to a picture file" and "Link to a file - short name" 3. Improvements in integration with the PsPhone IP telephony program - displaying the caller's card, calling PsPhone from the program with dialing 4. New internal commands : SetTab, HideTab, relevant for flexible customization of the form for editing using conditions
2.700 1. Implemented integration with PsPhone IP-telephony program - customer card is shown on an incoming call 2. New internal SetTab command to set the current main tab or form tab for editing 3. The checkbox "Print all records in one file" is implemented in the form "Export to HTML" and other improvements
2.688 1. New ability to quickly search across multiple fields
2.671 1. New checkbox in the properties of the table "Arbitrary tree settings"
2.670 1. Ability to pass parameters to user procedures 2. Improvement in duplication of records - second-level subordinate tables are taken into account
2.663 1. New link type in field properties - link to file-short name
2.657 1. New type of trigger - when double clicking on records 2. New ability to set hyperlinks in the edit form and user 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 "Combine by fields"
2.642 1. Completion of the "Field settings" form - the panel on the left and the field rules are now personal settings
2.637 1. Completion of the form "Internet Search" to receive XML
2.633 1. Two new types of triggers: When opening a table and When switching to a tab 2. Improvements in export by template to RTF documents
2.626 1. New help version
2.612 1. Improvements in the "Add a lot" functionality
2.611 1. The ability to create forms and display them, for example, at the start of the program or by a command. List of Forms in the Database Properties Window
2.604 1. Ability to add custom buttons and pictures to forms for editing. 2. Improvements in document generation based on templates
2.601 1. Implementation of the checkbox "Print all records in one file" for Excel 2. Implementation of labels or for highlighting a repeating block in Word and Excel template files and in reports
2.600 1. Form for generating documents from templates - instead of one, two checkboxes "Print all records in one file" and "From a new sheet for each record"
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 filters-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 on 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 in reports - highlighting 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 in export to Excel - picture fields are saved in the file itself 2. Improvements in reports - the ability to output a report to Excel grouped by template
2.577 1. Improvements on import - buttons for saving and loading all form settings
2.575 1. Improvements in export to Word and Excel in terms of color highlighting, as well as in reports 2. Improvements in export to RTF. The ability to specify the # symbol in tabs of the form tblTable_#_Field2_Field3, which prints the serial number of the record 3. In the import forms, a new checkbox "Call the procedure when finished"
2.569 1. In the color selection rules, a new opportunity has appeared to set a picture (BMP file) 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 in reports - the ability to specify complex SQL statements containing nested queries, as well as several statements, not necessarily SELECT
2.545 1. A new checkbox in the "Print grid" settings in the "Export table to Excel" form 2. When generating a document based on a template, selected records of a subordinate table are displayed 3. Improvements to the VBScript interpreter
2.534 1. New form "Import from client-bank" 2. Improvements on import, redesign of the import form
2.532 1. Improvements in tooltip settings - they can be set for form fields 2. Improvements when displaying reports in Excel - when several SQL statements are specified, all tables are shown sequentially with headings 3. An algorithm for automatically placing the Tab-sequence for form fields has been implemented
2.528 1. Improvements in tooltip settings 2. New internal commands: InputDate, InputDateRange, SetStatusText, SetMousePointer, SetVisibleFields, SetInvisibleFields, SetFieldsVisibility 3. Improvements in importing from Excel files 4. Improvements in the VBScript interpreter
2.519 1. Setting tooltips to show additional information when hovering the mouse, you can set formulas depending on the text under the mouse. Called from the "Table properties" form
2.518 1. In the field settings, added the ability to fix certain columns of the table 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 in import from Excel files - automatic search for the beginning of the table 3. Improvements in export to Excel by 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 meet 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 an Excel document), _LETTERSOVER#, LCASE, UCASE, _LEFT#, _RIGHT#, _MID#, _MID#AND# 2. Improved analyzer of custom SQL expressions and formulas 3. Improvements when working with MS SQL Server 4. Added new SMS providers
2.472 1. Implemented access rights "By roles" 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 type "Picture" - the path to the file
4. New link type "Link to image file" in field properties, images will be displayed in the same way as stored image fields
2.467 1. New form "Send e-mail by template"
2.452 1. New checkbox in the import form "Run triggers"
2. New trigger time - "After adding a record"
3. Improvements in VBScript
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. Improvements on the tree - the ability to set arbitrary formulas for building levels and for filtering data
4. Improvements in exporting a table to Excel
5. Improvements in VBScript
2.413 1. New autoform setting SubTablesEditInForm, 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 in exporting a table to Excel - color highlighting is picked up
3. Improvements in entering into tables - the inability to leave the table when the required fields are not filled in, saving the sorting of the drop-down list
4. Updates on reports - you can specify several SQL statements separated by a semicolon and get, respectively, several tables in the report
5. Improvements in VBScript
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 to block the fields of the current record and buttons by condition. See screenshots in Gallery #25 and #26
2.391 1. A new user button "Print receipt" has been added to the configuration of the demo database, to the table "Sales"
2. New report setting - "Send report by email" when generating on 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 given to a custom button to invoke a form.
2. The form for editing 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, a code in this language has been added. Example in Gallery screenshot #23
2.381 1. Added implementation of second-level subtables in the editing form (when setting ShowSubTables=1)
2.380 1. Improvements to highlighting rules - new parameter "Field for highlighting" (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 padding from 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 all"
2. Improvements when working with a barcode scanner
3. Improvements in capturing images from a webcam
4. Changes in the form "About the program" - the ability to query the database "Simple Soft" 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 predefined values ​​​​is added - the day of the week (for example, "Sunday") and the month with the year ("January 2013" or 01.2013 or 2013-01)
2.372 1. Improved performance when importing
2. New internal commands (MakeSnapshot, Emailing, Smsing, SendEmail, SendSms)
2.370 1. Added the value "(Any field)" to the table with filters to search for any field in the table using filters
2. Added a new provider for SMS-mailings sms16
2.367 1. Setting the field "Combine" is no longer dependent on sorting and is always in effect
2. Added error handling in triggers
3. New preset values ​​for the filters of the "Date and time" fields - "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 the internal command of the program
3. In the import form, the "Add", "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 a table and a tab
2.361 1. In the demo database, the "Supplier" field has been added to the "Incoming goods" table, and the "Total sold" totals have been set, showing the total number 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 possibility of selecting another one
2. Implemented the InputBox(Prompt, Title, Default) command, which can be specified in angle brackets in triggers and expressions
3. Improvements in search with the option "Output results in a list"
2.356 1. Improvements on reminders - a new "Message" parameter that will appear immediately before the reminder is triggered. Useful for Email or SMS mailing
2. In the "Help" menu, a new menu item "Check for a new version" allows you to easily upgrade
3. Improvements on import
2.353 1. Improvements "Value conditions" - new option "Show message without prohibition"
2. Improvements to the field properties in the part "Link to the program"
3. Improvements in SMS-mailing
2.351 1. New context menu item for fields - "Assign value to all field records..."
2. New context menu item for numeric fields - "Number all values ​​in the field..."
3. Import improvements
2.347 1. Improvements in email distribution - added the ability to attach multiple files
2. Improvements in SMS distribution - added the ability to maintain a log file
2.344 1. The structure of the demo database has been slightly changed - the trigger has been improved during production, some calculated fields have been replaced with stored ones
2. Improvements in exporting to Word by template - now you can specify bookmarks directly in the text of the document 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 on triggers - now they also work for sub-tables in case of deleting the main record along with subordinate records
3. Improvements on the tree - it is correctly built and filters in the case of fields with the "Multiple choice" checkbox checked
2.339 1. Improvements in SMS messaging - a new provider has been added
2. Updates on reports - when using custom filters in SQL type, the table with filters shows possible values
2.336 1. Added the ability to send SMS 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 statement, for example, "call dbo.sp1("param1")". But with the subsequent creation of the Access database, all the logic of 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 subordinate tables instead of a calculated one
2.320 1. Improvements on triggers - you can refer to the calculated fields of the saved record
2.315 1. Added the ability in triggers (and not only) to indicate a link to the previous value of the field (which was before editing) by specifying the field in curly brackets.
2.311 1. Improvements in the generation of Word documents
2. Improvements in SMS distribution
2.305 1. Improvements in SMS distribution
2.303
2.301 1. Improvements on import
2.300 1. Improvements when working with a barcode scanner
2. New checkbox in the form "New Word/Excel document by 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 setting "Show a list of databases at startup" is enabled, the ability to select a DBMS has been added
2.295 1. Implemented setting "Show list of databases at startup" in 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 "Incoming goods" and "Components" tables that change prices and the total cost of products
2. Added "Link to folder" to 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 field properties
- correct work with nested subqueries in the FROM part
2.285 1. Added the ability to set the rules for highlighting individual cells in the table
2.283
2.280 1. Improvements on multiple selection in the subtable by the button "Add many"
2. Improvements when working with MS SQL Server
2.276 1. In the access rights, in the 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. Changed demo database structure
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 items of the context menu
2. Changes in the structure of the demo database - block "Production"
2.270 1. In the "Field settings" form, a new checkbox "Show context menu for records"
2. Fixed some reports in the demo database configuration
2.268 1. Added 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 in the logic of creating a database on MS SQL Server using the current Access database
2.248 1. Improvements in the logic of creating a database on MS SQL Server using the current Access database
2. Improvements in export to XML
2.247 1. Added the ability to specify the encoding when exporting to XML and CSV
2.245 1. Added the functionality of exporting 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 has now been moved to two separate physical tables tblProduction and tblProductionProducts
2. The view qdfStoresState ("Status of warehouses") now shows goods, taking into account the accepted orders-reserves
2.243 1. Expanded the possibilities of fields with a link to the file - by clicking on the button with an ellipsis, menu items are displayed, incl. item "Assign a link to a file with copying to the server"
2.238 1. Improvements in access rights - for horizontal filtering rules in the "Value" column, you can set via AND or OR and other conditions
2.236 1. Improvements on subordinate tables of the second level - now you can assign to any subtable
2. Improvements in the functionality of multiple adding to subtables
3. Improvements on triggers
4. Improvements on the conditions for the value
2.227 1. Reconstruction of the Condition on the value form, which now allows you to set the construction "If ... Then ... Otherwise ..."
2. Panel on the right is now personalized

2.225 1. Reconstructed two reports "Customer Balance" and "Supplier Balance"
2. Improvements to filters in reports with custom filters
2.224 1. The structure of the demo database has been changed - in the "Sold goods" table in the "Product code" field, the choice is made with the display of stock balances
2. When sending an email on a trigger, it is now possible to simultaneously execute a SQL statement
2.222 1. The "Allow input in the field of another table" checkbox now works in the case of MS SQL Server when editing in a table
2. Improvements in export to Word and Excel using templates
2.221 1. Improvements when copying text through the clipboard - questions instead of Russian letters no longer appear
2. Improvements to filters in reports - a list of possible values ​​is shown in case of custom filters
2.219 1. Improvements in the algorithm for creating a database in the MS SQL Server format according to the current structure of the Access database
2.217 1. Improvements when working with drop-down lists when editing in a table
2. Improvements on the conditions for the value when editing in the table
3. For the "Sold goods" table, a condition is set on the value of the "Quantity" field, which warns if the quantity is entered more than in stock
2.216 1. Improvements according to trigger conditions
2.211 1. For custom buttons on the toolbar, the ability to set the command type "Execute SQL" has been added
2. Added a new type of triggers "When updating the table" ("When triggered" parameter)
3. Improvements in the algorithm for creating an Access database based on the current MS SQL Server database
2.208 1. Improvements in access rights settings (horizontal filtering rules)
2. Added the ability to set the type of relationship "Many-to-many" between views
2.204 1. Changed the view qdfBuyPrices ("Last purchase prices") for portability under MS SQL Server
2. Improvements in creating an Access database based on MS SQL Server database and vice versa
3. The "Proxy server" parameter has been added to the functionality of mailing lists
2.201 1. The structure of the demo database has been changed - a new table "Currency rates", assigned as a subordinate table for the "Currencies" table
2. Improvements in creating an Access database based on MS SQL Server database
2.196 1. Added a new table "Commodity groups" to the demo database
2. Reminder improvements
3. Improvements on import
2.195 1. Improvements when working with a barcode scanner
2.190 1. Implemented integration with a barcode scanner - if there is a BarCode ("Barcode") field in the subordinate 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 the display of the subordinate table 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 sub-tables in the form
2. A number of other improvements
2.185 1. Improvements on the "Add a lot" button - added the ability to work with a barcode scanner
2. Import improvements
3. Security improvements
4. Improvements in toolbar customization
2.184 1. In the toolbar settings, the ability to set many parameters during the operation of generating a document from a template has been added
2. Added a new type of trigger that fires when opening and closing the edit form
3. Quick search improvements
2.183 1. Refinement of the condition for the value
2. Import improvements
2.179 1. Added the ability to exclusive login
2.177 1. New trigger time - "When opening the form"
2.175 1. Improvements on the panel on the right - you can set arbitrary calculated fields
2. A number of other improvements
2.170 1. Improvements on triggers - new trigger activation time "After adding, changing, deleting a record"
2.167 1. Improvements on triggers - now they also work with some multiple operations
2.164 1. Quick search improvements
2.157 1. Improvements on triggers: in the "Confirmation" column, you can specify bookmarks in angle brackets - links to the fields of the current record
2. Added a new checkbox to the form "Make all ID values ​​consistent" - "Make a backup copy of the database"
2.153 1. Improvements on import
2. Quick search improvements
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 "Contains""
2. A number of other fixes and improvements
2.144 1. Added a button for multiple adding to subordinate tables when selecting from the reference book while holding Ctrl or Shift (when editing in a form)
2. Improvements in working with MS SQL Server - the algorithm for creating a new MS SQL database according to 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 by the ProductID field, as it was previously in DemoDatabase_3.mdb
2. A single database was chosen as the basis, the rest of the databases were abolished. Now only DemoDatabase.mdb will be developed
3. Introduced the concept of "Product set" - the given amount of certain components. When selling a set, its components are written off
4. A number of improvements and improvements in the program
2.141 1. Improvements in database migration under 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. Changed the document template "Invoice"
3. The template of the new document "Invoice M11" is included
2.137 1. Improved logic for constructing default values ​​for "Date and time" fields
2. A number of other improvements
2.130 1. Improved export to HTML and office documents
2. Added a new form to customize form tabs for editing
3. Improved logic for deleting fields
2.129 1. New field type - "File" for storing relatively small files in the 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 the database table field (up to 1024 Kb)
2. Added the second parameter "Parameter 2" in the customization table of the toolbar - you can save the name of the generated file in the field when you click on the custom button
3. In the configuration of the demo databases in the "Products" table, totals have been added showing the actual 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 set a hard 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 - the "Schedule" button has been added to the report settings form
2. Performance optimization when working with complex views
2.113 1. Improvements to the "Printing price tags" report - price tags go in two columns
2.111
2.109 1. Added the ability to add fields from other tables to complex views (such as "Status of warehouses", etc.)
2. Improvements in security - added encryption of passwords for the database
2.107 1. Improvements on triggers
2.106 1. Improvements to the structure of DemoDatabase.mdb - added the table "Outgoing payments" and 2 reports: Balance of customers and Balance of suppliers
2. Improvements in export to Excel - data types are converted more correctly and formatting is applied
3. Improvements in deletion triggers
2.105 1. Trigger improvements - new "send e-mail" operation type
2. Newsletter improvements - new "Delete Duplicates" button
2.104 1. Improvements in the functionality of triggers
2. Newsletter improvements
2.101 1. Improvements on triggers - improved triggers for deletion, added events for triggers: every minute, every hour, when the program starts, when the program exits
2. Improvements in the history of changes - the operation of deletion is recorded in the history of changes
3. Improvements in the functionality of removing fields from complex views
2.100 1. Improvements for working with MS SQL Server

2.96 1. Added quick search bar. Enabled from the right-click menu on the toolbar
2. Added drop-down calendars for the fields "Date and time" in the format without time
3. Improvements in the structure of the demo database - in the table "Products" a new field "Supplier"
2.92 1. Improvements in creating a database structure in MS SQL according to the structure of the Access database
2.87 1. Added the ability to customize the form toolbar for editing (custom buttons)
2.85 1. Updated toolbar
2. Improvements in the functionality of generating Excel documents based on templates
2.84 1. Added a template for the document "Consignment note" Template ТТН.xls
2. Improvements to the drop-down lists of the table (changing the size of the list with multiple selection, etc.)

4. Refinement of the condition for the value
2.82 1. New toolbar design
2. Added a new checkbox "Apply post style" in the table export form to Excel and HTML
3. Completion of the condition for the value in the field properties - you can set the form "= "
4. Improvements in the functionality of Bulk update - you can add a range of records to the table from a specific index and with a given step
2.80 1. Improvements in the form designer - you can set flexibly arbitrary inscriptions and frames
2. Improvements on adding new records to subordinate tables when editing in the table - can be added with an unsaved record in the main
2.79 1. Improvements for working with MS SQL Server
2.78 1. Added the ability to add several fields at once from another table in the field properties
2. Added a vertical scroll bar in case of 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 on triggers
2. Improvements in 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 "In x minutes" for filter or reminder values ​​of "Date and time" type fields.
2. Improvements on triggers
3. Improvements for working with MS SQL Server
2.73 1. Improvements on import in case of using the checkbox "Update data"
2. Improvements in 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 constructor for editing
2.65 1. Added form builder - the ability to design custom forms for editing with grouping by tabs
2. When generating office documents using templates, processing of one more _spellmoneyint ending 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 table of goods, the program will also offer to change this value in related tables
2. Added the ability to set subordinate tables of the second level (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 period 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 field "Type of operation": Return of goods and Resorting
2.62 1. The structure of the demo database has been changed: all product links are again made using the ProductCode (Article) field
2. By right-clicking on any foreign key field of any table, an item will always be shown to go to another table (if it is present among the main tabs)
2.61 1. Improvements on triggers
2.60 1. Improved functionality to remove fields present in complex views
2. Added the ability to set triggers for deletion and movement through records in the table
3. Slightly improved the structure of the demo database DemoDatabase.mdb
2.58 1. The structure of the demo database has been changed: triggers have been improved in accordance with the new relationship structure 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 by 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, to the "State of warehouses" view, display a field from the "Goods" table
2.52 1. Changes in the structure of the demo database: one more subordinate table "Chronology" has been added to the main table "Products"
2. Changes in the structure of the demo database: to the "Sales" table, a custom button - "Receipt" with the associated PrintCheck.vbs script has been added to the toolbar to print a receipt through the fiscal registrar. There are detailed comments in the script file.
3. Improvements in reports (graphs in reports, etc.)
2.50 1. Improvements in reporting performance
2. Two service buttons have been added to the field properties: "Copy settings of this field to another field" and "Copy settings of all fields of the table"
3. A text field has been added to the mailing list form to specify the port number of the SMTP server
2.46 1. Fixed several bugs
2.40 1. In the properties of the field, a new artrubut "Value condition" with the ability to enter a formula with the construction "If ... Then ..."
2. In the properties of the field, a new checkbox "Fill in the default value only when the focus arrives"
3. Optimized the speed of working with the database and a number of improvements in working with MS SQL Server
2.38 1. Changes in the structure of the demo database: the report "Sales, expenses and profit for the period" has been improved
2. Changes in demo database structure: updated views qdfArrivalsProducts, qdfProductsHistory, qdfStoresState, qdfStoresStateWithReserve
2.34 1. Improvements when working with MS SQL Server
2. A number of other improvements and fixes
2.28 1. A new attribute "Value condition" has been added to the field properties
2. Added "Link to Skype" to the list of link types in the field properties
2.27 1. A new report "State of warehouses on the date" has been added to the configuration of the demo database
2. Another filter "Warehouse code" has been added to the "Turnover sheet (quantity)" report
3. Improved "Calendar" in the mode of filtering by the condition "From ... to"
2.25 1. In the field settings, a new checkbox "Calendar" has been added to display calendars in the preview panel on the right
2.23 1. Fixed a bug in the work of triggers
2.22 1. Improved search: added new options "(All fields)" and "(All fields of the main and subordinate tables)"
2. In the configuration of the demo database, a bug was fixed in the report "Sales, expenses and profit for the period"
2.21 1. The following fields have been added to the "Status of warehouses" view: Product group, Family, Type, Unit of measure, Limit
2. On the main tab "Sales" in the subtable "Sold goods" for the field "Article" a formula is set to select only those goods 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 with the same name have been added to the configuration of the demo database
2. Added another demo database with a simplified structure (no documents and ProductCode field)
2.6 1. New version of the help system
2.5 1. The structure of the demo database has been changed: the error of incorrect calculation of the balance of goods 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 the field has a default value defined)
3. Improved some triggers
2.1 1. Added export and generation of documents by template in RTF format
2. Added the ability to search in all fields
3. In the properties of the field and the properties of the table, 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 the positions of the fields on the form in the format "Field1:left,top Field2:left,top"
1.31 1. When you check the "Completed" checkbox in the customer's order, it is transferred to sales. When you check the "Completed" checkbox in the order to the supplier, it is transferred to the receipt. Implemented on triggers that can be flexibly adjusted
2. A number of improvements on triggers - the ability to set the trigger condition, the text of the confirmation message, etc. Added triggers
3. Improvements in duplicating and deleting records
1.29 1. Two templates have been added to the distribution kit, the PKO.doc Template and the RKO.doc Template, the generation of documents for which is done from the "Cashier" 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 reports in HTML format with pictures. New report "Products with pictures"
3. New checkbox "Combine" in the properties of the field
4. New checkbox "Read only" in the table properties, the ability to set the style of highlighting the current record
5. A number of other improvements and fixes (reminders, reports, speed optimization)
1.23 1. Changed demo database structure
2. Improved the functionality of entering values ​​into a calculated field from another table when editing in a table
3. A number of other improvements and fixes (reminders in one form, scrollbar 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. Changed demo database structure
2. A number of other improvements and fixes
1.14 1. Redesigned templates for all documents
2. The structure of the demo database has been changed: fields for VAT have been added to the table "Sold goods". (In the case of posting without VAT, these fields can be hidden or removed.)
3. Improvements in exporting to Excel by template: the ability to set bookmarks of the type and , as well as
4. Additional settings in the field settings
1.13 1. Added a new report "Business cards of employees"
2. Fixed a bug with incorrect filling of the recipient 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 to change field positions by dragging and dropping" (valid for all users)
3. Implemented row shifting when inserting tables when generating an Excel document from a template
4. Ability to copy an entry to the clipboard and paste an entry from the clipboard
1.11 1. Added new tables: Expenses, IBP Expenses, Cashier, Salaries
2. Modified report "State of warehouses with reserves" and others
3. Two fields have been added to the "Incoming goods" table: "Price in currency" and "Currency"
4. The "Payment Amount" field has been added to the "Sales" table
1.9 1. Added new report "Printing price tags"
2. Added the ability to set the HTML template for the report in the report properties
1.7 1. Added new tables: "Orders to suppliers", "Expenses", "Cashier"
2. Added the ability to change the field type
1.5 1. Added new reports: "State of warehouses with reserves" (with ordered goods), "Chronology of receipt", "Chronology of expense"
2. The report "Turnover sheet" became in two versions: only quantity and with amounts
1.2 1. Improvements in multiplayer mode
2. New context menu item for records "Filter by text" for quick filtering of the table by the text in the cell
3. Ability to set styles for reports (in the report settings form)
4. New report "Turnover sheet"

This is undoubtedly the best program for inventory management. The advantages of the program include a simple user interface and ease of use. The program allows you to keep a full account of goods and money from a kiosk to a large wholesale base. For users who care about mobility, there is a version created using portable application technology (portable edition). The program in this version can be installed both on the computer's hard drive and on removable media (USB-flash, etc.) and freely move from computer to computer.

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

The program is intended for conducting operational warehouse accounting. The program allows you to track the balance of goods and materials in the warehouse and receive reports on the balance for any date. Commodity accounting is based on the maintenance of warehouse accounting cards.

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

As in other FOLIO programs, no special knowledge is required for operation, except for familiarity with MS Windows.

Warehouse accounting "Warehouse+" is a very simple and convenient program that has the most necessary features. Formation of incoming and outgoing documents. Printing invoice, invoice, invoice and credit note. Calculation of three sales prices with given coefficients relative to the purchase price, with the subsequent possibility of choosing one of these prices to form sales prices for a specific buyer.

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

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

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

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

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

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

"Warehouse and trade" - a simple, reliable program for the automation of trade and warehouse accounting. It allows you to easily and quickly create primary documents (invoices, invoices, waybills, contracts, etc.), control stock balances, keep records of sales and receipts of goods, make reservations, keep records of customer and supplier debts, take into account purchase prices and calculate the cost of products in production, calculate the profit received and much more. The program has a wide range of interface settings.

Inventory management in Excel is a great solution for any trading company or manufacturing organization that needs to keep track of the quantity of materials used, raw materials used and finished products.

Who can benefit from spreadsheets

Large firms acquire ready-made solutions in electronic format for these purposes. However, they are quite expensive, and some complex programs require a qualified employee with a high salary to work in the warehouse. This is not possible for start-ups or small companies. Fortunately, there is a way out, and you can use Excel spreadsheets. This electronic tool, which is inferior in popularity only to the Word office program, has functionality that is quite sufficient for solving warehouse accounting problems.

A few important rules

Those who are interested in the question of how to keep inventory records should seriously approach the issue of creating their own computer program from the very beginning. In this case, from the very beginning, adhere to the following rules:

  • All directories should initially be created as accurately and in detail as possible. In particular, one should not be limited to simply indicating the names of goods and should also indicate articles, codes, expiration dates (for certain types), etc.
  • Opening balances are usually entered into tables in monetary terms.
  • You should follow the chronology and enter data on the receipt of certain goods at the warehouse earlier than on shipment to the buyer.
  • Before filling in Excel spreadsheets, it is imperative to conduct an inventory.
  • It should be foreseen what additional information may be needed, and enter it, so that in the future you do not have to specify the data for each of the goods.

Before you start developing a spreadsheet to ensure the normal functioning of your warehouse, you should consider its specifics. General recommendations in this case are as follows:

  • It is necessary to compile directories: "Buyers", "Suppliers" and "Points of accounting for goods" (small companies do not need them).
  • If the list of products is relatively constant, then we can recommend creating their nomenclature in the form of a database on a separate sheet of the table. In the future, the expense, income and reports must be filled out with links to it. A sheet in an Excel table with the heading "Nomenclature" must contain the name of the product, product codes, product groups, units of measurement, etc.
  • The report is generated using the PivotTable tool.
  • Receipt to the warehouse should be taken into account on the "Incoming" sheet.
  • It is required to create sheets "Expense" and "Remains" to track the current state.

We create directories

To develop a program to keep inventory in Excel, create a file with any name. For example, it may sound like "Warehouse". Then we fill in the reference books. They should look something like this:

Suppliers

Least

Legal address

A comment

Moscow LLC

OOO "Summer-3"

CJSC Morning

In order for the headers not to “run away”, they need to be fixed. To do this, on the "View" tab in Excel, you need to click on the "Freeze Panes" button.

The "Customers" table looks exactly the same.

It will be able to provide a convenient and partially automated free service if you create an auxiliary directory of goods release points in it. True, it will be required only if the company has several outlets (warehouses). As for organizations that have one point of issue, it makes no sense to create such a directory for them.

Accounting points

Least

A comment

Shop 1

Own program "Warehouse": create a sheet "Incoming"

First of all, we need to create a table for the nomenclature. Its headings should look like "Product name", "Sort", "Unit of measure", "Characteristic", "Comment".

  • Select the range of this table.
  • In the "Name" field, located directly above the cell with the name "A", enter the word "Table1".
  • Do the same with the corresponding range on the "Suppliers" sheet. In this case, "Table 2" is indicated.
  • Fixing of income and expenditure transactions is carried out on two separate sheets. They will help you keep inventory records in Excel.

For "Incoming" the table should look like the figure below.

Arrival of goods

The supplier

Accounting point

Unit meas.

Accounting automation

Inventory accounting in Excel can be made more convenient if the user can choose from a ready-made list of the supplier, the name of the product and the accounting point.

Wherein:

  • the unit of measurement and the supplier's code should be displayed in the table automatically, without the participation of the operator;
  • invoice number, date, price and quantity are entered manually;
  • the program "Warehouse" (Excel) calculates the cost automatically, thanks to mathematical formulas.

To do this, all directories need to be formatted as a table and a drop-down list should be created for the "Name" column. For this:

  • select a column (except for the header);
  • find the "Data" tab;
  • click on the "Data Check" icon;
  • in the "Data Type" field, look for "List";
  • in the "Source" field, specify the function "=INDIRECT("item!$A$4:$A$8")".
  • check the boxes next to "Ignore empty cells" and "List of valid values".

If everything is done correctly, then when filling in the 1st column, you can simply select from the list. At the same time, in the column "Unit. rev.» the corresponding value will appear.

Similarly, auto-completion is created for the "Code" and "Supplier" columns, as well as a drop-down list.

To fill in the column "Cost" use the multiplication formula. It should look like - "= price * quantity".

You also need to create a drop-down list called "Points of Accounting", which will indicate where the incoming goods were sent. This is done in exactly the same way as in the previous cases.

"Turnover sheet"

Now that you have almost created a convenient tool that allows your company to keep inventory records in Excel for free, all that remains is to teach our program to correctly display the report.

To do this, we start working with the corresponding table and set zeros at the beginning of the time period, since we are still going to keep inventory records. If it was carried out earlier, then this column should display the balances. In this case, the units of measurement and names of goods should be taken from the nomenclature.

To facilitate inventory control, the free program should fill in the "Shipments" and "Receipts" columns using the SUMIFS function.

The balance of goods in the warehouse is calculated using mathematical operators.

This is how we got the Warehouse program. Over time, you can independently make adjustments to it in order to make accounting for goods (your products) as convenient as possible.

On this page you can download the free warehouse program "Info-Enterprise". It differs from paid versions in somewhat limited functionality, but it is quite suitable for novice entrepreneurs who are not yet ready to purchase a program for accounting for goods. See below for the features that are disabled.

The advantage of using free goods accounting programs that you do not need to look for it, order it, purchase it. You just need to download it from the site. It is easy to install, easy to learn. Won't work - use the tutorial videos! They are installed with the program.

Attention!

This is not a demo version, it is a full-fledged working product accounting program, but free. It does not contain any restrictions on work, including restrictions on time, date, number of documents, volume of turnover, printing of documents, etc. Its capabilities correspond to the documentation (with the exception of the functions below).

If you are now accounting for goods in other programs, then you do not need to enter everything again. You can transfer directories from Excel. In addition, if you have such commodity accounting programs as "1C: Trade and Warehouse" or "1C: Trade Management", then you can transfer not only directories, but also most of the entered documents.

Why is it free? What's the catch?

Due to the great competition in the software market, more and more companies are forced to release free products in order to somehow lure a potential buyer to their side. And our free inventory management software is no exception. Our main calculation is based on the fact that you will like our product, you will get used to it and at some point you will want some more service, more opportunities. And then we will offer our paid products.

What features are disabled in the free version

To account for the goods in the program has all the functions! Only those that are not needed by small or start-up companies are disabled:
  • Possibility of simultaneous work of several users with a common database over the network.
  • Differentiation of user access rights to different data and areas of work.
  • Database administration tools: optimization tools, logging user actions, etc.
  • You cannot program in the built-in language, modify existing ones and develop your own forms, reports, change the principles of work.
  • The free product accounting program cannot be integrated with our other products for complex enterprise automation.

You can compare the features of the free program and paid versions in more detail at. If you still need any of the listed functions in your work, write to us by mail. If you are not alone in this desire, we will include it in one of the next versions.

She is constantly improving

Starting to work in the program now, later you will receive some new functions for accounting for goods and more conveniences. She herself notifies about the release of new versions and offers to install them. Sometimes these versions contain legislative changes, such as new forms of invoices, payment orders or some other documents.

By downloading the free warehouse program, you will be able to use limited technical support, consisting of consultations on the user forum. And by switching to one of the paid versions, you can already use all types of support, including the Hotline and the Remote Support service. On paid versions it is possible after a year of using the free one.

The need for inventory control software happens to every entrepreneur. A wide variety of products is the main reason for such an acquisition. Moreover, business automation helps to optimize the workflow, and reporting becomes much easier and faster.

Warehouse accounting program provides a tool whose functions allow you to control and build all the necessary processes in the right direction. These are purchases, storage and sale of goods. And with the help of excellent software, it is better to engage in the implementation of such actions than a long and uninteresting manual accounting of products.

There are such best prostock control grams, which make up the TOP-20:

Each of them has its own specific functionality, advantages and disadvantages of use.

Program warehouse accounting : features of choice

When selecting the most suitable software, it is necessary to take into account certain factors that affect its further use.

  1. Simple and user-friendly interface, without bright design and unnecessary functions.
  2. Compatibility with other similar programs, in case of possible data transfer or comparison.
  3. The likelihood of software being tailored to a particular type of business.
  4. Ease of use, the ability to easily solve the problem of accounting for goods in the warehouse.

Warehouse and trade programs - main types

There are many different software for reporting in the warehouses of an entrepreneur. They differ primarily in the possibility of installation on a computer or using a network (cloud application).

  1. accounting of own and commission goods;
  2. printing of documents;
  3. sales statistics and profitability calculation for each product;
  4. integration with fiscal registrar or other equipment.

Others include the possibility of comprehensive work with the client base and data exchange.

Pros and cons

Warehouse accounting program in production"MySklad" has a number of significant advantages. According to those who started their business, among them they distinguish the possibility of using any operating system and the presence of a special application for iOS and Android. In addition, the quick connection of new warehouses or other premises to the system and the reliability of the service with the ability to save data without the risk of losing them are the main tasks that the software performs.

There are also disadvantages to this system. These include a difficult to understand interface, the inability to delete your account on your own, difficulties with installing the service for a specific business. But, despite this, the MySklad program is constantly updated and improved, turning disadvantages into its advantages.

"Big Bird"

Online material inventory program is one of the most common services for small businesses. This system, which works only on the Internet, controls reporting and sales.

Service functions

The main tasks that the software performs are:

  1. accounting for all types of goods;
  2. integration with other programs, such as, service;
  3. registration of any operations with products: write-off, movement or inventory;
  4. accounting for multiple companies.

Fitness club tricks: a slim body and an empty wallet

Advantages and disadvantages

Among the main advantages of http://bigbird.ru is the ability to automatically save the latest changes and an excellent interface that allows the user to quickly navigate. The disadvantages include partial malfunctions and problems associated with the online store module.

"Super Warehouse"

This simplewarehouse programcouple, which is set is free as a demo. With such a service, automation of accounting in a warehouse or in a company will be easy due to the lack of complex accounting terms in the interface.

Software features

"SuperSklad" performs a number of diverse and very important functions. These include:

  1. keeping records of the availability and movement of finance, goods;
  2. registration, printing of various documents;
  3. analytical reports on the structure and dynamics of sales;
  4. the ability to maintain a large number of warehouses in one database, the movement of goods between them;
  5. setting access restrictions to some documentation of other users of the system.

Pros and cons

"SuperSklad" can be used in two ways. It could be free warehouse and trade accounting software in the form of a demo version or purchase of the full version. The advantages of using http://sklad-prog.ru include a very simple interface. In case of difficulties, you can watch the training video tutorial. It will help you understand how to use the software. The system provides for the possibility of using a cloud service with saving data on the network.

The disadvantages of the program include the impossibility of maintaining inventory records at large trading enterprises, where the number of warehouses exceeds 100 pieces.

"Commodity-Money-Commodity"

This warehouse management software makes it possible to carry out comprehensive control of the activities of any wholesale or retail enterprise. It can be a small or medium business.

System properties

Definition of citizenship and its relationship with citizenship

The main functionalities of the http://tdt.info/tdt software include carrying out all kinds of warehouse and trading operations, financial reporting and control of mutual settlements with partners and customers, as well as maintaining documentation and analyzing the company's activities.

Advantages and disadvantages

The main advantages of the program look like this:

  • the possibility of using in the production of an assembly type;
  • work with software remotely;
  • combining information about the activities of several warehouses or retail outlets in a single database.

In addition, there is free softwareamma for inventory control in the form of a demo version, which is available for 3 months.

Among the shortcomings of the software is a significant number of flaws on the part of the manufacturer. The result of this is various inconsistencies and the possibility of committing illegal actions with reporting. In addition, "Product-Money-Product" updates are provided only for the first 6 months. Later, users must pay a subscription fee for subsequent improvements.

"Info-Enterprise: Trade Warehouse"

This service is one of the most used in the field of warehouse accounting. Together with IP: Accounting, it makes it possible to get twice as good a result in business automation.

Functionality

Educational programand materials in stock performs a number of key tasks:

  1. Carrying out write-offs and return of goods from warehouses;
  2. moving products from one warehouse to another;
  3. accounting for any type of product or service;
  4. calculation of the cost of goods by different methods.

Cons and pros


2022
polyester.ru - Magazine for girls and women