Contacts

The program for accounting for office equipment at the enterprise. The program "Accounting computers" and computer equipment, an inventory software. What is needed for this

This program is necessary to system administrators, IT managers, owners of computer shops, home network holders, owners large number components I. computer equipment.

Basic functions of the program

  1. Maintaining the base of computers and office equipment
  2. Storing information about all computers and office equipment of your organization (device type, specifications, inventory and serial numbers, supplier, cost, purchase date, term and date of the end of the warranty, responsible person, etc.).

  3. Accounting for repairs and upgrades. Monitoring warranty terms
  4. Fixation of manufactured repairs and upgrades, replacement of consumables and parts, preventive work. It is indicated by the date, view and description of the work produced, their cost.

  5. Accounting established software
  6. Fixing the name of the software, its description, registration key, the number of copies, cost. Control of the need to install new versions of software products, as well as in the acquisition of "new products" under the necessary tasks.

  7. Fastening objects for responsible employees
  8. All accounting objects can be fixed for responsible employees with dividing departments and branches.

  9. Maintaining the base of suppliers and other partners
  10. Storage in the database of complete contact information for all partners. The ability to analyze the history of work with suppliers, estimates of the prospects, drawing up plans for the future.

  11. Computer Inventory, Scanning local network, hardware resources of computers
  12. Export and import of any data
  13. Selection, search, grouping, data sorting on various criteria
  14. Flexible database structure with setting for any tasks
  15. Network and multi-user modes, flexible setting of access rights with restrictions on the fields and by recordings
  16. Creating and configuring reports, reminders on various conditions, E-mail mailing
  17. Customization - Setting up the menu, toolbars and other items personally under each user

Standard features of the platform

With the help of the program you can do the following:

  • Create, modify, delete records, fields, tables
  • Import data to any database table from text files
  • Sort tables on any field, including sorting over multiple fields (up to 3) holding the SHIFT key
  • Filter the table on any field using the following statements: \u003d,\u003e,\u003e \u003d, "contains", "does not contain", "begins with", "does not begin with", "ends on", "does not end on", Like, NOT LIKE
  • Group identical data in any field when the table is sorted by this field (for marked fields in the properties of the table)
  • Check records as "Favorites", then they will be displayed in orange. Color is set in the properties of the table
  • Check records as a "dead" ("uninteresting"), then they will be displayed with gray (or other)
  • Customize the rules of colorwriter. You ourselves define what lines, which color and under what conditions to allocate.
  • Build a tree according to any fields with an arbitrary number of levels for hierarchical display of data of any table
  • Change the data in any field (except ID and calculated fields) directly in the table or in a separate form (selected in the settings), mark multiple entries, delete, print, export marked
  • Change or delete several entries at once in any database table using the form " Group update"
  • Create new stored fields for tables of the following types: text, numeric, yes / no, date and time, picture
  • Create calculated fields for tables, for example, you can create a field with formula "[Field 1] / [Field 2]"
  • Create calculated fields whose values \u200b\u200bwill be taken from other tables. For example, you can withdraw the name of the debtor from the "debtors" table.
  • Create new tables with absolutely the same features for action with them, like any other table
  • Tie the drop-down listing of fields to other tables for easy selection of values \u200b\u200bof them when editing in the table or to select from other forms when editing in form
  • Set an arbitrary number of subordinate tables for any table, for which it is necessary to specify binding in the field properties
  • Change the order of fields in any table using dragging 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. (More precisely, their labels.)
  • Print the current representation of any table, taking into account the visibility of fields, their widths and order
  • Export data of any table in MS Excel or text CSV file with current table presentation
  • Export the current entry in MS WORD based on the template file with bookmarks corresponding to the names of the fields
  • Work with multiple database files, create new databases, of course, can also be opened with MS Access.

Program installation

To install the program you must:

  • Download Comp Cuest.msi.
  • Run the Installation Program Making Double Click on the downloaded file
  • Following the instructions of the installer program to install the program on hDD
  • Run the program by selecting it in the "Programs" menu by pressing the "Start" button or the shortcut on the desktop.

To replace your current version of the new program, you must first delete the current one and then install a new one.

Certificate of Rospatent

History of versions

VersionWhat's new
2.674 1. The ability to personalize the scheduled import tasks - a check mark "for a user" 2. Improves for exports in RTF
2.668 1. In the form of exports in XML, a new check mark Create a separate file for each record
2.657 1. Imprinting VBScript interpreter
2.655 1. When you move the recording up or down, the subordinate records are now taken into account.
2. New internal commands GenerateBarcode and GenerateBarcodeean13
2.653 1. Two new forms - export to a folder with CSV files and import from a folder with CSV files
2.652 1. Improved performance when importing from XML and CSV
2.648 1. New form "Counter Setup" (called from the context menu by right click on the ID field)
2.639 1. Forming SMS-mailing form
2.636 1. Finalization: Interpreter, Internal Commands
2.621 1. Models of SMS-mailing 2. Implementing an interpreter VBScript
2.597 1. Import improvements
2.590 1. Integration with new check printer models - Atol 30f, PTK strokes
2. Reflecting the functionality of "Simple filters"
2.585 1. Added the ability to set wood personalization
2.582 1. New tick in the properties of the table - "Simple filters"
2.581 1. Added the ability to set business rules for subordinate tables - a different set of tables, depending on the condition
2.568 1. Refinement of exports in XML and import from XML 2. Refinement of reminders with a check mark "All reminders in one form"
2.566 1. A new property font size "Field Size" has been added to the color entry rules 2. New internal commands: AddRecordSintoschedule (Fill out a year calendar ahead), SetValueForcellRange (add to the cell group), SUM (sum)
2.555 1. Export improvements - in export forms of any type, you can select a file template from the DB Table 2. Export to RTF - You can use labels ,,
2.550 1. Added the ability to do export to XML by template
2.546 1. Import to Scheduled Scheduled
2.544 1. Import improvements, the ability to import on schedule 2. Ability to view a list of databases on different servers MS. SQL Server
2.542 1. Configuration protection form improvements - New options 2. Implementing the Replace function in the default value and other places
2.539 1. A new tick "Do not print empty columns of tables" in the form of generating a Word document on the template 2. The ability to store template files in a separate database table - TBlTemplates
2.538 1. Refinemers with the type of communication "Many-ko-many" 2. Improving the generation of documents on templates with labels and
2.537 1. Ability to set more than one custom button for subordinate tables 2. Ability to enable the "Add" button on the toolbar of the main 3. Implementation of the VBScript interpreter
2.533 1. Processing of the form "Exports to CSV" - the ability to export the main and subordinate, as well as exports by the template
2.512 1. Modification of reminders in the case of "Show all reminders in one form" 2. Redemble SMS-mailing - new parameter "XML request"
2.501 1. Refinement of email-mailings - the ability to insert more than one picture at HTML format, the ability to use bookmarks from subordinate tables
2.492 1. Refinement "Print checks and labels", a new item in the "Service" menu, support for new equipment and the ability to use the RTF template
2.479 1. New tick in the settings of the fields "Allow allocate the cells group", useful for tables-calendars when entering the name in the date range
2.478 1. New Internal TRANSLIT command - To write Russian Latin's text 2. The new internal setVisibletabs command - to install visible tabs on the form for editing the condition from the script 3. Refreshtable, refreshActiveTable, refreshActiveSUBTable
2.473 1. Added the ability to customize the toolbar for subordinate tables 2. In the field properties, the functionality of creating compound indices for several fields
2.464 1. Refinement of the shape "Print checks and labels", new equipment
2.463 1. Implementation of the VBScript interpreter 2. Finalization of the functional Condition to value 3. Refinement of the rules of color entry
2.456 1. Refinement "Check Print" - Added Printer Checks FPRINT-11, the ability to set a script to work POS equipment 2. Refinement of the conditions for the value - the ability to call procedures 3. New commands GetControlValue, SetControlValue 4. Refinement of the coloring rules - the ability to recognize NULL
2.446 1. Refinement of the generation of Word documents - the new endings _letters to insert each letter to a separate cell of the Word table, _days, _WorkDays 2. New types of triggers - after adding a record, after removing recording 3. Refinery on the fields - output to the panel on the right from another table with the ability to edit and so on
2.439 1. New item Context menu on the right click on the Subbalance tab "Show Filter Panel" 2. Refinement of exports in CSV - Possibility of selecting fields
2.438 1. A new button on the Table Export to XML toolbar "
2.436 1. Display field files in the form for editing 2. Storage of custom pictures directly in the database for editing form, colorwalk rules 3. Ability to set the command when clicking on a user picture for form
2.418 1. Refinement of the storage functional in the database, display links to the pictures. 2. New link types - "Link to File Image" and "File Link - Short Name" 3. Configurations to integrate with PSPhone IP-telephony program - Show Calling Card, PSPhone Call from Number Set 4. New Internal Commands : Settab, hidetab, topical for flexible setting for editing using conditions
2.413 1. Integration with the PSPhone IP telephony program is implemented - with incoming call Customer card is shown 2. New internal SETTAB command to install the current master tab or tab form for editing 3. Tick "Print all entries in one file" is implemented in the form "Export to HTML" and other improvements
2.401 1. New possibility of quick search by several fields
2.384 1. New tick in the properties of the table "Arbitrary Tree Setup"
2.383 1. The ability to transmit parameters to custom procedures 2. Refinement to duplicate records - the subordinate tables of the second level are taken into account
2.376 1. New link type in field properties - link to file-short name
2.370 1. New trigger type - with double click on recording 2. New ability to set hyperlinks in the form for editing and in custom forms
2.368 1. New internal GotourlandImportXML command, designed to receive various information from sites (currency courses, counterparty in Inn, etc.)
2.361 1. New setting In the reports "Combine by fields"
2.357 1. Refining "Field Setup" - Panel on the left and field rules Now Personal settings
2.352 1. Refinement of the "Internet Search" form to obtain XML
2.347 1. Two new types of triggers: when opening a table and when switching to a tab 2. Improve exports by template in RTF documents
2.326 1. Refinement on the functionality of "add a lot"
2.325 1. The ability to create forms and show them, for example, when starting a program or team. List of forms in the "Database Properties" window
2.318 1. Ability to add custom buttons and pictures on editing forms. 2. Improves for generating documents on templates
2.315 1. Print all entries in one file for Excel 2. The implementation of labels or to highlight a repeating block in Word and Excel templates and in reports
2.314 1. Shape of the generation of documents by templates - instead of one two checkboxes "Print all entries in one file" and "from a new sheet each entry"
2.312 1. Ability to change the width of the drop-down list in the main or subordinate tables
2.309 1. New ability to set up the panel on the left, where you can arrange filters-lists to filter the table with one click, as well as a calendar
2.308 1. New Input Input FRUMLIST 2. New Ending tab _Noformat and _Code128 for printing barcodes in office documents
2.301 1. Refinement on the reports - you can use filters for any type of reports, the drop-down calendar is shown for the fields "Date and Time"
2.298 1. Refinemers on reports - ColorMind and other settings can be used when withdrawing to Excel in various combinations, by template and taking into account styles
2.295 1. Improve export to Excel - field-fields are saved in the file itself 2. Refinement on the reports - the ability to output a report to Excel with a template grouping
2.291 1. Import improvements - buttons for saving and downloading all form settings
2.289 1. Improvement for exports in Word and Excel in the color management plan, as well as in the reports 2. Exports to the RTF. The ability to specify the symbol # in the TBLTABLE _ # _ Field2_Field3 view, printing sequence number of recording 3. In the form of imports a new check mark "At the end to call the procedure"
2.283 1. A new feature appeared in the colorwalk rules (BMP format file) appeared to display it in the table cell
2.276 1. A new check mark in the settings "Automatically check updates when starting" and a new form of checking for the presence of a new version 2. Refinement on the reports - the ability to specify complex SQL expressions containing invested requests, as well as several instructions, not necessarily SELECT
2.261 1. A new check mark in the "Print Mesh" settings in the form "Export Table in Excel" form 2. When generating a document on the template, dedicated records of the subordinate table 3. Imprinting VBScript interpreter
2.250 1. New form "Import from Customer-Bank" 2. Import improvements, finesyn forms of import
2.248 1. Reflecting the tip settings - they can be set for fields for form 2. Refinement when reporting in Excel - When you specify multiple SQL instructions, all tables are shown in series with headers 3. Implemented by an automatic Tab sequence algorithm for form fields
2.244 1. Reflecting Tips Settings 2. New Internal Commands: InputDate, InputDateRange, SetStatustext, SetMousePointer, SetVisibleFields, SetInVisibleFields, SetfieldSvisibility 3. Importing from Excel Files 4. Imprinting VBScript Interpreter
2.236 1. Setting up tips to show additional information when you hover the mouse, you can set formulas with text dependency under the arm. Called from the "Table Properties" form
2.235 1. In the field settings, the ability to fix certain table columns is added so that they do not scroll through the horizontal scrolling 2. Imprinting VBScript interpreter
2.230 1. New preset values \u200b\u200bfor dates and time field filters: current quarter, last quarter, searched quarter, next quarter 2. Import improvements from Excel files - automatic search The start of the table 3. Export refinement to Excel by template
2.226 1. New types of command types for triggers: sending email for all, sending SMS for all, VBScript for all that will be triggered for all records that satisfy the condition prescribed in the "Condition" parameter, and not for the current record. 2. Export refinement to Excel
2.211 1. New types of bookmarks when generating documents: _Letters (each letter in a separate cell excel document), _Lettersover #, lcase, ucase, _left #, _right #, _mid #, _mid # and # 2. Improved Analyzer of custom SQL expressions and formulas 3. Refinery when working with MS SQL Server 4. Added new SMS providers
2.190 1. Implemented access rights "on roles" with the ability to create user roles
2. Added the ability to backup databases every time interval
3. Added the ability to specify the default value for the "picture" type fields - the path to the file
4. New link type "Link to File Image" in field properties, pictures will be displayed in the same way as stored fields pictures
2.187 1. New form "Send e-mail by template"
2.146 1. New tick in the field settings "Aligning headers of fields in the center"
2. Added the ability to specify the "any field" in the color management rules
3. Tree refinement - the ability to set arbitrary formulas for building levels and to filter data
4. Refinement on the export of the table in Excel
5. VBScript refinement
2.144 1. Added new exporttabletoexcel internal commands, LoadFilters, CheckFilters
2. Implementing the export of the table in Excel - collapse colors
3. Improvement to the table - the inability to leave the table with the replenishment of the required fields, preservation of the sorting of the drop-down list
4. Reports on reports - you can specify several SQL instructions through a point with a comma and obtain, respectively, several tables in the report
2.140 1. Added internal ENABLEFIELDS commands, Disablefields, Enabletoolbarbuttons, DisableToolbarButtons to block the fields of the current entry and buttons by condition. See screenshots in gallery №25 and №26
2.137 1. Added new internal commands: Gotorecord, GototableAndRecord, CopyRecord, CopyRecordandSubTable, which can be used for custom buttons, as well as in triggers, reminders, etc.
2. For user toolbar buttons, you have the ability to specify the VBScript command and, accordingly, code in this language. Example in Gallery Screenshot №23
2.133 1. Added the implementation of the second-level subtabilities in the form for editing (when setting upshubtables \u003d 1)
2.131 1. A new form "Export to a text file" that allows you to make various conversions of existing text files (including HTML files) or generate new
2.128 1. New item context menu for fields - "Assign a value for all field entries ..."
2. New context menu item for numeric fields - "Number all values \u200b\u200bin the field ..."
3. Import improvements
2.126 1. For MS SQL Server, you can specify a call to the stored procedure, for example "Call DBO.sp1 (" Param1 ") as SQL instructions. But upon the subsequent creation of the ACCESS database, all logic of stored procedures will be lost.
2. Implementing to Excel - In the template file, you can specify the type bookmarks
3. Trigger modifications - you can refer to the calculated fields of the stored recording when adding
2.124 1. A new check mark in the form of imports - "Fill the default values"
2.121 1. Refinement on SMS mailing
2.119
2.117 1. Refinery when working with barcode scanner
2. New check mark " new document Word / Excel on the template "-" not print empty tables "
2.115 1. A new form "Import from the XML file" with the possibility of setting the schedule for this task.
2. Changing the report parameter form - Added the name of the target report file with the ability to save reports in a specified folder
3. When you enabled "Show Database List at Start" Added the ability to select DBMS
2.114 1. Configuring "Show Database List at Start" in the case of MS SQL Server
2.111 1. In the field properties added "Link to the folder"
- Correct work with subqueries in part from
2.109 1. In the properties of the table added the ability to set the colors of individual cells for the table
2.108
2.105 1. Refinery in setting menu and toolbars
2.103 1. Added function block for SMS mailing
2. Refinery when working with MS SQL Server
2.101 1. Refinery when working with MS SQL Server
2.95 1. Filter modifications in reports - more parameters
2. Refinery when working with MS SQL Server
3. Improving the logic of creating databases on MS SQL Server on the current associate database
2.94 1. Added the ability to specify an encoding when exporting to XML and CSV
2.91 1. The capabilities of the fields with reference to the file are expanded - by pressing the Trootch button, menu items are shown, incl. Item "Note a link to a file with copying to the server"
2. Improvement of access rights - for the rules of horizontal filtering in the "Value" column can be set via and or OR and other conditions
3. Improvement on subordinate second-level tables - can now be prescribed for any subtlety
4. Improves on the functionality of the multiple adding to the subtabilities ("Add a lot" button)
2.85 1. Reconstruction of the form condition to a value that now allows you to set the design "if ... then ... otherwise ..."
2. The panel on the right is now personal setting

2.84 1. When sending an email on the trigger, it is now possible to simultaneously execute SQL instructions.
2. Refinery when working with drop-down lists when editing in the table
3. Tick "Allow input to the other table" now works and in the case of MS SQL Server when editing in the table
4. Refinery when copying text through the clipboard - Issues instead of Russian letters no longer appear
5. Filter modifications in reports - shows a list of possible values \u200b\u200bin case of custom filters
2.83 1. Refinement under the terms of the triggers
2. Import improvements
2.82 1. For user buttons on the toolbar added the ability to set the type of SQL command type
2. Added a new type of trigger "when updating the table" (option "when triggered")
3. Improvements in the ACCESS database creation algorithm for the current MS SQL Server database
2.80 1. Improves on settings for access rights (horizontal filtering rules)
2. Added the ability to set the type of communication "Many-ko-many" between representations
2.76 1. Added the ability to set a formula to build a path to a folder with documents.
2. The "Proxy server" parameter has been added to the functionality of email mailings.
3. Improvement on triggers and reminders - the ability to generate a document on the fly and sending it by email
2.72 1. Refinement on the functionality of the display of subordinate tables in the form for editing
2. Import improvements
2.71 1. Added the ability to set multiplayer regime not only for employees, but also for any other person (customers, partners ...) contained in any table with Login and LoginPassword fields.
2.69 1. Added new property in settings for editing - showsubtables, allowing you to show subordinate tables in the form
2. A number of other improvements
2.67 1. Improvements on the functionality of "Conditional visibility of fields"
2. Trigger refinement and rapid search
2.62 1. Added the ability to monopol entrance
2.60 1. Replication refinement
2. Refinery on the panel on the right - you can set arbitrary calculated fields
2.59 1. New item in the context menu for fields "Insert buffer"
2.51 1. Improved operation with filters - Filters are saved when the table is opened in the selection mode
2. In the reports, the processing of user filters specified in the SQL expression is improved.
3. You can set a rigid search box to quickly search. This is done from the right click
4. New new value for triggers "When" - "-" when adding, changing and removing recording "
2.49
2. A new feature of the scheduled reports - the "Schedule" button is added to the report settings form.
3. Added the ability to rename the table name in the table properties.
4. Improvements on working with MS SQL Server
5. Performance Improvements
2.48 1. Added two items in the context menu for entries: "Move Record Back" and "Move Recording Down"
2.47 1. Trigger modifications

3. Minor final designer forms
4. Safety refinement - Added password encryption for database
2.46 1. The improvement of the functionality of the conditional visibility of the fields - now in conditions you can specify a subqueries
2. Improvements on triggers - a new type of operation "Sending E-Mail"
3. Improvements on mailing list - new button "Remove Dupil"
2.44 1. The structure of the DB demo is changed - the subordinate table "Characteristics", showing one or another set of parameters depending on the type of device
2. Improvers on MS SQL Server
2.37 1. Added drop-down calendars for fields of type "Date and time" when format without time ("dd.mm.yyyy" and other)
2. Added a quick search panel - available from the context menu by right click on the toolbar
3. Refinement on MS SQL Server
2.36 1. Added the ability to customize the toolbar for editing form (Custom buttons)
2. A new check mark "Report non-sharpened bookmarks" has been added to the templates
3. Recycled and improved functionality "Condition to" in the field properties
4. Improvements when working with MS SQL Server - Refinement when creating a database based DB database Access
2.35 1. Added a new check mark "Apply Style Records" in the form of exports of the table in Excel and in HTML
2. Improve the conditions for the value in the properties of the field - you can set the type "\u003d "
3. Reflecting functionality Group update - You can add a set of records from a specific index to the table and with a specified step
2.34 1. Improvements when working with MS SQL Server - refinement when creating a database based on the associate database, as well as performance improvements
2. The functionality of the "Condition" in the field properties is redesigned and improved.
2.33 1. Improvement according to the forms constructor - you can set flexible arbitrary inscriptions and frames
2. Improving the addition of new entries into subordinate tables when editing in the table - you can add when not saved in the main
2.32
2.29 1. Added vertical scroll ruler in the case of using customized forms to edit
2 In the field properties, you have the ability to add several fields from another table.
3. Refinement to fill the default values
2.27 1. Refinement on working with MS SQL Server
2. Implementing the exports to RFT format (support for composite bookmarks, global constants, summits in words)
3. Import improvements in case of use of the check mark "Update Data"
2.24 1. Added Form Designer - Ability to design Custom Molds To Edit Tab Grouping
2. When generating office documents on templates added to the processing of another end of _SpellmoneyInt - amount in words without instructions 00 kopecks
2.22 1. Added the ability to set the subordinate tables of the second level (3 tables on the tab - the main, subordinate and subordinate subordinate). To do this, in the configuration table, in the main table field, you must specify the name of the first subordinate table, point and field name.
2. Improved functionality for copying field properties for other fields (in the form of field properties)
2.19 1. Improved algorithm for scanning of the local network computers

2.13 1. In the field properties added the condition for the value
2. In the field properties in the list of link types Added "Link to Skype"
3. Added the ability to display the "Calendar" element to filter fields of type "Date and Time" on the panel on the right
2.6 1. Added the ability to set several values \u200b\u200bthrough a point with a comma to adjust the conditional visibility of fields, colors, etc.
2. Improvements when working with MS SQL Server
2.4 1. Improved local network scanning functionality - can be scanned with firewall on remote computer
2. Added the ability to generate RTF documents on a template and without template
3. A new version certificates
2.3 1. Updated certificate
2. Added the ability to search for all fields
2.0 1. Added support for MICROSOFT SQL Server DBMS
1.115 1. Optimization of the speed of work with the database
2. A number of other improvements and corrections
1.112 1. In the setting of reminders added a check mark "Show all reminders in one form"
2. Added the ability to set the quick viewing panel to the right, the fields for which are set in the field settings.
1.109 1. Added a button on the toolbar setup form to copy to other tables.
1.107 1. Improvements for scanning computers on the local network
2. Added two scannetwork.vbs and scannetwork2.vbs scripting, which can be run from any computer to read its configuration and subsequent imports in the database
1.106 1. Improves in setting up the main tabs
2. Improvements in exports in Word on a template
3. Added GETCOMPUTERINFO.VBS script that can be run from any computer to read its configuration.
1.103 1. Optimized the speed of working with the database
2. Additional settings In field settings
3. Improvements on exports in Excel by template
1.102 1. Improved functionality "Scan Computers on Local Network"
2. A number of other improvements and corrections
1.85 1. Improved functionality "Scan folder file System": You can import different properties of a file in different fields of the Tax Database Table
2. Improved functionality "Scan Computers on Local Network"
3. A number of other improvements and corrections
1.81 1. The ability to accurately specify the type of stored links: Link to the file, on the site, on the e-mail, on the phone (in case the link is stored)

1.78 1. From general settings In the properties of the table, setting "Selecting the current entry text", which can now be specified for each table separately
2. Improves for tuning the tree: the ability to specify the data source for each level (from the table itself or from the directory); Ability to save and load a tree settings from files (called from the right clicking)
3. A number of other corrections and improvements.
1.73 1. In the "Service" menu, a new item "Scanning computers in the network ..." to import configurations in the database. (If you do not see this item, recharge the menu by clicking the "Default" button in the menu setting form.)
2. A number of other corrections and improvements.
1.71 1. New reports
2. A number of other corrections and improvements.
1.67 1. Changed the structure of the demo database: new table "Movement", changed some fields
2. A number of other improvements: Table exports in Word, Field Uniqueness Control, Flower Employment Rules, Conditional Fields, Saving Report Settings, Displaying Search Results in the list, etc.
1.65 1. Improvements external view Interface - New Some Icons
2. Fixed copying status string panel settings
1.62 1. Improved imports from Microsoft Excel format
2. Added the ability to configure the status string for each user.
3. A more flexible ability to copy custom field settings (and others) from one to another
4. A number of other improvements and corrections
1.58 1. Improved exports to microsoft format Excel on the template: New check mark "fitting the width of cells"
2. New reports "Reports", added new reports.
3. Flexible setup of the main menu

1.55 1. Enhanced the duplication algorithm of records: records of subordinate tables are now duplicated
2. Improved functionality for creating backups Database, new settings
3. A number of improvements and corrections
1.50 1. Enhanced the algorithm for duplicating records: now it works more correctly, taking into account the unique fields
2. New setting: highlighting the current entry "floating text" - the entire recording color is not allocated, but the text of the current cell "floating text" is highlighted for conveniently copy it to the clipboard
3. New setting: auto-update tables every minute to see records added by other users
4. New functionality - Export to Microsoft Excel by template, generating a package of documents
5. New Autoform Properties: Showcalcfields - Show Calculated Fields, ShowHiddenfields - Show Hidden Fields, ShowpictureFields - Show Pictures, PictureControlHeight - Picture Height, ColumnMaxHeight - Maximum speaken height with fields
1.47 1. Redesign form properties of the table, new settings: short description Tables, font, row height, number of lines in field headers
2. New properties in field settings: Combination of values, field background color
3. Improved exports to HTML
4. New functionality - a set of phone number
1.45 1. Improved reminder functionality
2. New form "Field Setup" with the ability to copy all settings
3. New functionality - the conditional visibility of fields
4. A number of improvements and corrections
1.37 1. New functionality - triggers to add and update records that allow you to prescribe the necessary SQL instructions for other tables
2. Field Add Forms Redesign - Some settings can now be specified for the calculated fields.
3. New button in the settings "Set the current setting of tabs for all users"
4. Enhanced the search for a double: Added the ability to set the second field
5. New item in the context menu to write a subordinate table "Go to entry in the main table ..."
1.36 1. New functionality - replication, to create copies of databases and use in different offices with subsequent data synchronization
2. New functionality - Flexible setting of reminders for any field of type "Date and Time" of any table
3. Improved algorithm for building calculated fields from other tables (now without subquery)
4. Added more information About the current database in the status string
5. Fixed several errors
1.33 1. New buttons on the toolbar: "Enable all filters" and "Turn off all filters" (defaults are hidden)
2. New functionality "Search for a dub" to search for duplicate records in a specified table for a given field
3. Fixed several errors
1.31 1. Creating tabs is now performed by selecting a table from the list
2. Changed the structure of the demo database: new table "Workshops"
3. A number of other improvements and corrections
1.29 1. Added new property of the "Input Mask" field
2. Added a new check mark "Sort the list values" in the field properties
3. A number of other improvements and corrections
1.26 1. Added flexible user access rights
2. A number of other improvements and corrections
1.24 1. Improved form to create new tables
2. Modified form with settings: Many settings are personalized
3. Improved menu configuration form: The visibility settings of the menu items are personalized
4. All the latest platform refinements
1.23 1. New feature of the main menu
2. A new feature of displaying numeric fields on the chart
3. New setting in the properties of the field "Transfer according to"
1.16 1. New features of the flexible toolbar
2. New setting "Show buttons for filters to the right of the table with filters"
3. New setup in the properties of the table "Table description" and "Show table description"
4. A number of other improvements (main tabs, work with filters, etc.)

convenient program for taking into account equipment, equipment, repairs and services. This tool will allow you to perform the following actions and operations: Accounting for computers, equipment, software ...

4 months ago License: Conditionally free Language: Russian OS: 7/8/8.1/10 The size: 15.47 MB

The program is designed for automated accounting and inventory of computer equipment and other equipment in organizations. The program is vital to managers of the departments of computerization, hell ...

A year ago License: Conditionally free Language: Russian OS: XP / Vista / 7/8 / 8.1 / 10 The size: 38.92 MB

The program for accounting and inventory of computer equipment in the enterprise. Passports are triggered to all devices, the history of the movement of devices, their repair and prevention is monitored.

A year ago License: Conditionally free Language: Russian OS: XP / Vista / 7/8/10 The size: 38.08 MB

Inventory accounting of computers and office equipment at the enterprise. The ability to automatically fill the database information on devices and network settings. Passports come to all devices. UTS ...

2 years ago License: Conditionally free Language: Russian OS: XP / Vista / 7 The size: 61.27 MB.

If you keep records of computers in your organization in Excel files or even in my head system administrator And you can no longer determine where there is any computer, printer or laptop ...

2 years ago License: Conditionally free Language: Russian OS: 7/8/10 The size: 26.57 MB

an application for inventory of computers on the network. Maintains a database, finds computers connected to the local network, creates a report on the configuration of equipment installed by, updates, driver ...

4 years ago License: Conditionally free Language: English OS: XP / Vista / 7 The size: 1.93 MB

The program is designed to solve a wide range of diverse tasks associated with the most a variety of resources and the calculation of certain parameters on them.

5 years ago License: Conditionally free Language: Russian OS: XP / Vista / 7 The size: 7.48 MB

Program for accounting computer equipment in the organization. Supports data load from AIDA32 and ASTRA. It is allowed to create multiple reports - computer passport (reinforcement card), report р ...

ArtConfig: Inventory

A convenient, functional, scalable program for equipment accounting in an enterprise in any field of activity, where the inventory of fixed assets is necessary.

Introduction

This configuration was written for yourself, to keep the equipment and other property in the organization in which I work. The main task of the configuration is to have an idea of \u200b\u200bwhere, what equipment is, how many times was the repair, how many years a computer is required, and whether it is required to modernize, where, what monitors, there is a need to purchase additional multiplinary equipment, accounting of cartridges and consumables Materials, as well as accounting for the consumable paper. Accounting for the purchase of equipment. And the added functionality with Helpdesk was very facilitated by the work of the whole of our IT department. Of course, I tried the application systems: OTRS and Redmine, but our employees will be much easier to call or write to the corporate chat, rather than leave a request in the browser. Therefore, taking a call, promptly feed the service request, you appoint a responsible person on this application and do not worry about what you will forget that someone does not work. And in the head to keep all applications - it's easy, it is impossible! Starting from applications: ".. I have something not working there," ending with budgets for the year. So, this configuration It is intended to keep taking into account the entire property of the enterprise, as well as the maintenance of its life cycle from acquiring to write off. That is, you can raise the entire history of the property. I am confident that this inventory program will be an excellent assistant in your work!

Capabilities

  • Equipment inventory in the enterprise (inventory of computers, monitors, printers, scanners, cameras, laptops, flash drives, furniture, cars, cars and other equipment, and everything else);
  • Accounting for the movement of equipment using the acquisition documents, acts of acceptance and transfer, movement, repair and write-off equipment. The entire life cycle inventory of fixed assets from its acquisition to write-off;
  • The conclusion of reports on the movement of equipment at the enterprise, as well as the history of the "life" of equipment from its acquisition to write-off;
  • Control of the acquired licenses of software products in the enterprise;
  • Accounting for the number of actually installed and acquired software licenses;
  • Accounting cartridges and consumables at the enterprise (paper, discs, etc.);
  • Accounting for electronic keys of software products (accounting for their movement);
  • Drawing up applications for the purchase of equipment, consumables, etc.;
  • Building schematic plans for the location of inventory equipment and furniture attributes for cabinets (departments, rooms, and on the offices in general);
  • Conclusion to print a report on the performance of computers;
  • Conclusion to print passports of employees' workplaces;
  • Conclusion to print overhead reception equipment (admission to the warehouse, moving between warehouses, etc.);
  • Output to print reports on issued equipment;
  • Conclusion to print a report on warehouse equipment;
  • Conclusion to print a report on written off equipments;
  • and many many others.

For whom?

For IT departments, accounting and administrative departments in small and medium-sized enterprises, where equipment, furniture, car park is required, and everything.

Benefits

  • Deployed functionality.
  • No additional modules - no additional costs.
  • The configuration applies to an unlimited number of users. The restriction depends only on the limitation of the 1C platform itself.
  • 1C allows you to use configurations online from any device (smartphone, tablet, computer, laptop, etc.) from anywhere in the world;
  • Customizable forms of reports and printed forms
  • Operative technical support, Individual approach to each client!

Terms of Use

Terms of use are described in.

Mandatory conditions.

You must have 1C platform (legally, illegally, this is an individual business).

Important! For configurations, you need 1C version Prof..

The program is designed to help you resolve the following questions:

  • Do you use any software, To maintain equipment inventory within your company?
  • Can you, easily and quickly, determine where your equipment is at a given time?
  • Do you have inconvenience to keep records of equipment in Excel signs or in notebook? Do you spend a lot of time searching for equipment, and sometimes, and lose it altogether?
  • Do you know how many times the equipment was in repair?
  • Can you promptly prepare a report on issued equipment or warehouse equipment?
  • Can you promptly take all the equipment from the employee who fired?
  • Can you, easily and quickly, print a desktop passport?
  • Can you, without unnecessary movements, compare computer performance?
  • Is it easy for you to control applications for the purchase of equipment? Budget formation for month, quarter, year?
  • Will you be able to determine how much refueling is this or another cartridge? Is it sufficient for a toner fills its servicing organization?
  • If you already have an inventory program, can it solve all the above issues? Is it easy for you and your colleagues use your program for inventory? Is the interface completely and convenient? Is the collective work possible?

Output

For those who need to keep records of fixed assets in order to always have topical information about its equipment and property, inventory program It will be an indispensable tool in your work.

* The demo through the browser is not always well displayed. Those who want to provide access in terminal mode. This is nothing complicated and terrible. Write me to email.
If the demo version of the equipment inventory does not start or you find some error in the configuration, I will be very grateful if you write to me on

Competitively configured taking into account computer equipment will protect you from facaps in the infrastructure and keep tens of hours of worker and personal time. About how to achieve such a result, read in this article.

Immediately I want to warn that all the below is not subtracted in the books of Best Practice, and my squeezing, sometimes not always successful experience. Therefore, with gratitude to accept constructive criticism.


So, let's begin. Why the IT service need to keep records of computer equipment? After all, the entire computer equipment is taken into account in the accounts of the organization and the equipment on equipment is already in the accounting system. Why then distract technical specialists from the development of software / administration of systems / equipment repair and shipping them "accounting" work?
The fact is that the data collected in the accounting system will not save you from problems, for example, with a viral attack.


"Infect computer in corporate network, raise privileges, access the administrator domain and one button to stop the company's activities of any size " - so described the specifics of work wannacry virus His author.


To stop this to the right of at least you need to know the location of infected computers. In the accounting system there will be a pantry in which the computer is listed, and the user (but this is not exactly). The actual location of the computer and its IP address you will not recognize.


The more time it will be spent on finding out, what kind of snack is an infected machine, the lower the chances of stopping the spread of the virus and the degradation of the infrastructure. As you understand, financial and reputational losses from stopping business processes will be an order of magnitude higher than the cost of keeping IT equipment. However, Wannacry is still flowers. There is a threat and more serious ...


Remember the old joke, that winter in Russia always comes unexpectedly, so utilities do not have time to prepare for it? A similar misfortune with the preparation of the budget for the next year - everything seems to be about the timing, but for some reason, the application for replacement for technology is submitted at the very last moment. And the IT specialist is usually the IT specialist, which is responsible for the distribution of equipment - did not provide, did not take due measures, did not show persistence, etc. etc. If a viral attack can get around you with a side, then the treasures due to not in time the devoted technique will accurately come into your head.


But there is a way out: stop collecting applications for replacement. Start keeping accounting parameters for which the technique should fall into the modernization program (for example, the volume of HDD, monitor diagonal, printer print speed, etc.). In this case, you can form a list of techniques to replace automatically from your accounting system. There are no applications - no problem.


What else will help the established IT equipment accounting system? The fact that on any, even the most trummy question of the manual you can give an answer in 5-15 minutes, and not in "Tomorrow from the morning." For example, the financial director asks: "How many printers are in the storage room, how much to repair, how many users have, how many were recycled this year, in which printer departments are idle?". If you are taken into account the stages of the life cycle of IT equipment, then on all (!) These questions you will give the answer within 15 minutes. Otherwise, it will have to collect data from different sources within 2-3 hours (if not more).


I suppose with the question "Why do I need my accounting of IT equipment" figured out. It is smaller from the evils compared to the situation when you have only scattered accounting data and raw SCCM reports.


Let's now we will design such an IT equipment accounting system that will help solve the problems indicated above. We will need:

  1. determine the boundaries of the accounting system;
  2. develop a directory of equipment categories;
  3. develop a life cycle model;
  4. decide with the rules for identifying equipment;
  5. develop an attribute model.

Step 1. Determine the borders of the accounting system

Do not spray efforts and try to establish account immediately and everywhere. Examine data on incidents / problems and find a "bottle of neck". Equipment groups that deliver you most trouble. Start building accounting in these groups.


In my experience most often in "get stuck in bottle neck»Computers and office equipment. Less frequently, the components and consumables (as a rule there are enough warehouse accounting data).

Step 2. Develop a directory of equipment categories

To make it easier to form reports, every group of equipment should be divided into categories. For example, you decided to establish accounting of custom equipment. We take the group "Computers". What categories will it consist of? Personal computer, laptop, tablet, etc. Then take the next group - "display devices" and divide it into it. As a result, you will have something like this category directory:



Thanks to this division, you can quickly make samples from the database and receive reports both by the Computers group and for each category of this group.

Step 3. Develop a model life cycle model

To quickly receive information about what status is the equipment needs to be developed by the so-called. " equipment Life Cycle Model».


I advise you to start with a simple model and detail it as necessary:


Event Status What tracks status?
New equipment entered the warehouse, unused equipment returned to the warehouse Storage in warehouse Tracks actual warehouse stock
Equipment transferred to IT professionals to customize, repair, upgrade Setup / repair Tracking the load on IT service staff
The equipment is transferred to the user Exploitation Track the actual number of equipment in the work
The user quit, but the equipment remains at the workplace (waiting for a new employee) Storage in the division Tracking hidden reserves
Equipment removed from the workplace as unsuitable for operation Preparation for disposal Tracking the trash to dispose
Transmitted equipment for disposal contractor Disposal Tracking the fulfillment of the contract for disposal

In my experience fast way Increase the efficiency of the IT equipment accounting system, it is to start tracking the statuses of the life cycle. Do not neglect this step!

Step 4. Determine the method of equipment identification

Because you have to search for a search and equipment inventory, you need to determine in advance how you will identify the found technique. I know five ways of identification:


Method of identification Benefits disadvantages
Tag with number. A paper tag with an account number is glued to the equipment or the account number is applied with a marker. Low costs for consumables and labeling equipment High labor costs to update data and accounting of equipment movements. Low wear resistance of paper tags.
Manufacturer's serial numbers. A label with SN and barcode are used in the manufacture of equipment. No cost of equipment and consumables for labeling Not suitable for identifying "self-assembling" PC. High labor costs to update data and accounting of movements, because serial numbers are in hard-to-reach places.
Label with barcode. A wear-resistant label with an account number and barcode is applied to the equipment. Low costs for labeling equipment and consumables. Reducing labor costs to update data and accounting of equipment movement. Individual flaws did not reveal.
RFID label. Radiometric is applied to the equipment. High cost of equipment and consumables. The inability to identify the equipment without using the RFID scanner.
Barcode + RFID. The equipment is applied to the radio player with a barcode and account number Significant reduction in labor costs for inventory and accounting for moving a large number of equipment. High cost of equipment and consumables.

I consider the label with a barcode label to be labeled. By the way, Yurich back in 2013 wrote step-by-step instructions for the manufacture of labels. Irrenestly recommend his article to reading.

Step 5. Develop an attribute model

Now let's go to the most important thing - to develop an attribute model. My list of attributes recommended for accounting, with the indication for which they are needed, is shown below. Use it as a starting point when developing your attribute model.

  • The generally accepted name of the manufacturer and model. Please note that in the overhead names of the manufacturer and models can be distorted. Try to record the generally accepted names to technical information The model was easier to find on the manufacturer's website.
  • Nomenclature numberunder which the equipment model is headed in the reference book of the accounting system. It should be taken into account to quickly find the same type of equipment.
  • Inventory numberassigned to equipment when setting accounting. It should be taken into account to search for equipment in the accounting base. Please note that according to the accounting rules, the inventory number may be the same in multiple devices (for example, a PC, monitor and printer in the laboratory installation). In addition, the inventory number is necessarily assigned only to fixed assets, i.e. Equipment cost above 40 000 rubles (more in PBU 5/01, PBU 6/01). Therefore, the overwhelming number of computer equipment in your organization inventory may not be. In return, it can be used by a complex-composite number, for example<номер кладовой>/<количество этой номенклатуры на учете в кладовой>.
  • Registration numberassigned to an IT unit when making equipment for service. In many organizations, the IT service is more convenient to assign their ID equipment than to use inventory numbers.
  • Serial numberassigned to the equipment manufacturer. It is worth considering in case of warranty repair and as a spare identifier if it is impossible to determine the inventory / nomenclature / equipment accounting rooms.
  • Postal address of the building, name or room number (if there are several buildings at one address), cabinet number(or the title of the site and building axes of the building, if it is a production room). Such a set of details will help to find techniques, in whatever it is not located.
  • Division in which the user works, full name and user phone. User contacts need to get physical access to equipment. Division, you will be useful for groupings in reports and to access the manager if the user turns out to be unavailable. It is also useful to know the table number and ... the date of dismissal of the user. On the table number it is convenient to build summary reports if you need to see what other TMTs are following the employee. Date of dismissal will help to identify inconspicuous equipment.
    In my practice there was a funny case. In a small factory, the head of one of the divisions several weeks sought him more than computer computer. There was no budget for the technique, therefore decided to search for idle technique in the divisions. Two days of search and more powerful computer Found ... in the office of this boss, behind the next table. The computer stayed after the employee's dismissal. The fact that this is a more productive staff, the staff did not know. The IT service was not warned about the dismissal of the user of this computer.
  • Technical attributesThrough which you can decide on the upgrade equipment. For example, such:

At first glance, the attributes are too much and the staff will take a lot of time to maintain the accounting system in the actual state. Let's check if it is.


Depending on the interface of the accounting system on the primary registration of each device, it will take 5-10 minutes to actualize data 1-2 minutes. Suppose you in organizing 350 users, devices for accounting 1,000 pieces. A year is replaced by 20% of the fleet of technology (based on the service life of 5 years), 10% of the park is repaired and upgrades. So every year you will need:

  • contribute to the system of 200 new records (200x10 \u003d 2000 minutes);
  • twice update statuses in 200 new devices (200x2x2 \u003d 800 minutes);
  • updated the status of 200 output from the operation of devices (200x2x2 \u003d 800 minutes);
  • twice updating the statuses of 100 in the repair of devices (100x2x2 \u003d 400 minutes).

Total will spend 4,000 minutes a year. We throw another 10% for unforeseen movements. We get 4,400 minutes per year or 17 minutes a day. I suppose these are quite acceptable labor costs to maintain up to date the accounting system for 1,000 units of technology.


In addition, they can be reduced to 10-12 minutes: technical attributes take from SCCM, user data from the personnel system. But these are questions of architecture, I plan to reveal them in the second part of the article. Also in the second part, I will show how to quickly organize the introduction of a designed accounting system. In the meantime, let's take a pause.


Please give in the comments feedback. This will help me more than disclose your questions in preparing the continuation of the article.

Tags: Add Tags

Accounting program.

Software accounting - this is an indispensable program For those people who create network administration in different offices of enterprises, companies and organizations and of course home networks. Compsoft-SL has the ability to even remotely receive the desired information closely attached with the software of the local network computers, monitor the removal and installation of all new programs on your computer.

This program, from the very beginning of its creation and release, was intended for preliminary accounting for all computer equipment, the program also allows you to carefully track what is happening any changes in the computer and the software installed on it. The data of the computer recorded can be used as to inventory any personal computers and inventory of your software.

The maintenance of computer technician is given the following:

  • Accounting for all the very important characteristics of the computer (the main characteristics of your computer are automatically removed).
  • Memory accounting and all available properties operating system (removed automatically).
  • Accounting for other data (inventory or serial number).
  • Accounting software located in a personal computer (all having data is also removed automatically).
  • Control of mandatory, adjacent licenses for this software.
  • Accounting for additional technique connected to this personal computer (printers, modems, computer monitors etc).

To provide an inventory of computers, as well as your software, this program Formats any reports to account for computers. Work with reports permits in detail to analyze the entire condition of the used computer equipment and downloaded software in a very high quality as well as quantitative relations. The necessary reports of reports provide a unique opportunity to record all licenses for installed software. All computer accounting documents are changed in the format - (HTML), and then automatically start in the browser available on your computer. In addition, all documents can be opened in any of word programs or Excel.

The program makes accounts on any personal computer, where all having properties of this software and the data of this computer are shown. The account card of your personal computer is always created in format (RTF), it allows you to work with a card in any case you have text editor Which you need.

This unique program for keeping accounting has such launch types:

  • With the usual start from the program with hard diskShe is always in keeping accounting.
  • When starting a program from a removable medium of a computer, this program automatically removes the properties of a personal computer and all that is included in the software set, saving them in the file until the next inclusion in the main base.

The program for accounting computers as well as its software in the installation does not need and does not make changes to your personal computer.

The interface of this program is provided in Russian. As well as there is a built-in Russian-language reference service and makes it possible in improved work with this program.

Until 11 personal computers, this program tracks completely free. To work with large networks, it is necessary to have a license, the price of which depends on the number of built-in machines.

Size: 1 MB
Interface: Russian
Platform: Windows XP / VISTA / 7/8



Did you like the article? Share it