System
It is able to run the function for database administration, books of modules, task scheduler administration fromSystem offer in Administrator module.
Picture: Open menu module Administrator - System
Administration of Books
Administration of Books is a new module, which is important for books inserting of particular data modules. It has been created for better clarity and easier entering of particular data modules. In present days it is able to create the modules Service, Internal documents, Reminders, Cashes, Marketing, Bank accounts, Projects, Purchase, Sale and Payrollpayables in administration. The function is in tree menu Administrator - System - Administration of books.
For the work with Administration of books it is necessary to have the right Service administration, which you find on the 5th page of user Administration / General.
Administration of books has compared to "old" book (Books of warehouses, Books of assets) the advantage that you can create books with the abbreviation longer thank 2 signs. You can distinguish the books according to partner office (e.g. firm "Service - Ostrava" and "Service - Prague" (see picture)).
Picture: Administration of Books
Example of "old" and "new" book usage.
Picture: The Received Letter Post document - old version
Picture: Document Service Order - new version
Administration of books contains module books, which are divided in lower folders of the form (Service, Internal documents, Reminders, etc.). Use either Ins key or icon to create a new book Enter the book by means of Enter key, by double click of left mouse button or by button to adjust current book It is forbidden to delete records. Arrows are used for moving the ruler on the records. are used for exporting of table contents into Excel. These buttons have the same function on other forms Administration of Books as well.
Form description for a record inserting or editing
Administration of Books
Picture: Administration of Books - folder Administration of Books
Field Description:
No. |
Generated number of book automatically. Numbering goes through all books created in administration of books (through all modules in folders in lower part of form, see above). |
Abbreviation |
Abbreviation of a newly created book. Maximal length is 6 characters. |
Company |
Choose a company from the Own Companies form (the list of companies defined for currently logged-in Client). Only the users of this company in terms of the set Client can work with this book. If field is not filled, then book will be for all firms in that client. |
Description |
Description of book is closely specified that particular book. |
Language description |
The description that is set in the Language fields book (the Descr. translation button). The language description will be displayed in the table. |
Changed |
Date and time, when the book was created and changed last time. |
Changed |
Abbreviation and name of a user, who has created the book and has made the last change. |
Descr. translations |
After button pressing the book Language fields, where you can save Description of book for various languages (field Language in User parameters). |
Group of rights |
After pressing this button or Ctrl+Shift+F5 keys the book Group of rights will be opened and you can select the group of rights that the created book is accessible for. Group of rights are described in the chapter Administrator - Group of users. |
Default settings
The Default Settings folder is different for each module. Description of this tab is mentioned in the appropriate part of user manual that the book is related to.
Picture: Administration of Books - Default Settings
Numbering folder
Numbering does not differ from numbering in "old" books (Books of warehouse, Books of assets).
Picture: Administration of Books - the Numbering tab
Insert new record of numbering
Picture: The form for inserting a new record of numbering
Field Description:
Document |
Drop-down field to select a type of document, where you set the numbering. |
Numbering |
In this field you can set your own numbering. E.g. "1", which is numbered e.g. from 2000. |
From |
You can set here, which number the documents will be numbered from. If you do not enter the field, documents will be numbered from 1. |
Current |
Automatically entered number according to the last created document. |
To |
Set max number, which you will be numbered to. Default value - "9999999". |
Settings for business years
It is the same for all periods by default. It means that the setting in the Default Settings folder will be valid for all periods. You cannot enter settings for each period separately as in"old books". If you want to set other conditions for particular period, you need to create the period in the Settings for Business Years folder. (E.g. Period for 2012 has been created on the picture.)
Picture: Administration of Books - Settings for Business Years
Insert new period
Contrary to original books (Bank accounts, Cash registers) in new books the period is set just for stated year. (Period from, to has not been set any more.) You need to choose particular year from Period book after you open drop-down menu Period.
Picture: Business Years - Administration of Books
Settings for business years
You can set parameters for particular business year in this folder. Fields are the same as in the form Administration of books - General settings.
Picture: Business Years - Settings
In Numbering folder in the form for new period inserting there is a button Find current. After you press it, the number of the last record will appear in the Current field.
Picture: The form for inserting a new record of numbering
Licence administration
The function offers detailed information about K2 licence including overview of licence modules and currently signed users. The function is tree menu Administrator - System - Licence administration.
Picture: Administrator - System - Licence administration - folder Licence administration
Fields Description:
Edition type |
Type of bought program edition (Business, Professional, ...). |
Brach No |
Brach No. |
Branch Name |
Name of particular branch. |
Code |
Safety producer code. |
Licence owner |
Name of licence owner (company). |
Licence number |
Licence number (see contract of sale). |
Concurrent users |
The number says the amount of signed users in total. |
Version |
Generation number of version. |
Subversion |
Second part of version number (e.g. 129, 130, 132 etc.). |
Application servers |
Number of application servers. |
Notification service |
If this field is checked, it means that the user has bought the licence for Notification service. |
Scheduled tasks service |
If this field is checked, it means that the user has bought the licence for Payroll. Scheduled tasks service. |
Analytic services |
If this field is checked, it means that the user has bought the licence for Analytic services. |
Managerial evaluation |
The checked field means that the user has bought the licence for Managerial evaluation. |
Payroll |
If this field is checked, it means that the user has bought the licence for Payroll. |
Factory setting |
User with this licence is able to administer the setting specified just for administrators. |
Number of shared users |
Number of computer connection used by a server of web services. Meant for Internal use. |
Number of users for analysis services |
Number of bought module licence Analytic services. |
Number of users for workflow |
Number of bought module licence Workflow. |
Created by |
User who has created the licence. |
Created on |
Date and time of licence creating. |
Legislation |
Within one K2 it is possible to keep several own companies with Czech or Slovak legislation. A checked box indicates what legislation the user has purchased. |
List of reserved users
Users with reserved licence for logging. The number of (reserved) "users" is free. It is included into the whole number of accessible licences (see Concurrent users field). This way you can take licences for users or for running planned automatic tasks.
Logged-in users
The list of users currently logged-in K2 program is displayed in Logged-in users folder. For each logging-in there is a client that the user is signed as. Then you can find there name, additional information, workstation, session, login time and licence type. The total number of logins (consumed licenses) can then be read from the total number of records in the table - a numerical value in the lower left corner (current record number / total number of records).
Picture: Administrator - System - Licence administration - Logged-in usersfolder
Licence limits for clients
You can limit the number of logged-in users for clients. In the book Administrator in Basic data (1st page) chapter you can set with whose clients are the users logging as.
The Import button is important for import of licence file into database. The button has the same importance as Licence import upon finishing program installation. In this form you can use this button for e.g. licence changing.
Button Set production is important for setting the K2 installation as production. The button has the same importance as Production upon program installation.
Picture: K2 installation settings
Both the K2 installer and the K2 application send online license usage information to K2 atmitec. Among these information is Name, version and K2 edition, server name, catalogue and client, number of users and identification of database platform.
These information is important for efficiency improvement for another plans of K2 development and for prevention of possible incompatibility. To differentiate whether a given K2 installation serves as a production, it is necessary to use the option of registering the installation as a production in the K2 installer or directly in the K2 application (Administrator - System - License Management).
Non-production K2 are understood as testing, their function is limited. If K2 program is set as "Production", red line with "Test Test Test Test" text will be displayed on the main form. This text is displayed as watermark in reports as well. K2 icon will get grey in non-production state.
Picture: K2 Desktop - "Non-production" K2
Picture: Main Task-bar of Windows Operating System, icon shortcut "Non-production" K2
Administration of clients
There are two clients preset in the program, these are DEMO client and INIT client. In the DEMO client, there are introduced the demonstration data for individual K2 modules, where the user can practice the K2 functionality. The client INIT does not contain data, because it serves to create a new client. Administration of clients serves for creating new clients and for maintenance of the existing databases by means of K2.
The list of clients you can see on the page 0.
Picture: The Administration of clients form - book
The first page of the form is different for editing an existing client and another for creating a new client by using the Insert key. When editing the existing client, only the description can be changed (the abbreviation must remain the same, because the databases and directories are named by it).
Picture: The Administration of clients form - page 1 in Change mode
When inserting a new client, the check boxes are displayed on the form. They can be checked arbitrarily. Users who work and manage K2 only from K2 must check all fields.
Picture: Inserting a new client - Ins
Selected fields description:
Create directories |
If this checkbox is checked, a directory with the same name as it is specified in the Abbreviation field is created in the main K2 directory. |
Create SQL database |
If it is checked, the database is created on the server. A name of the database consists of the master database name and the client abbreviation. [Database K2 entered at installation] _ [Client abbreviation]. |
Import data from directory |
If it is checked, the data from the selected directory will be imported into the created database. All "*.des" and "*.hes" files of all data tables must exist in this directory. The files for creating INIT and DEMO databases are delivered with the K2. INIT serves for the creation of a new real company, DEMO can be used for testing on data which are prepared by the company "K2 atmitec s.r.o." All "*.des" a "*.hes" files has to be placed in one directory. The directory can be changed by using Change directory button. |
After pressing F2 key, the changes are saved and actions selected by the user are executed. The user is informed on currently running actions by means of dialogue boxes with the client creation progress. It is not possible to work in K2 during this time.
Clients - 2nd page
On 2. page of the Clients form, there are buttons that are used to preset directories and databases for the company. This buttons are started when creating a new client.
Note: To work with this page it is necessary to set the right Administrator - Clients - Client, page 2.
Picture: The Administrator of clients form - 2nd Page chapter).
This page is accessible only in Browse mode. It can be used, for example, when you create a new client by means of Insert key, enter the Abbreviation and Name fields and save the changes. On 2. page inBrowse mode you can set the required data, i.e. the first line of buttons (Directories, Databases and Data Import) has the same meaning as check boxes on the 1st page.
Buttons Description:
Directories |
After pressing the button, a subdirectory DATA, which is saved in the directory called "CLIENT ABBREVIATION", will be created. |
|
Database |
After pressing the button, the empty tables will be created on SQL server. After only creating the SQL database, the client is not working. |
|
|
If you want to import the data to a new client, a database must be firstly created by means of this button and then the import can be carried out. |
|
|
Note: To create the SQL database, the user logged onto Windows must have the rights of SQL administrator. |
|
Data import |
Data are imported from the set directory to the client, providing that the data exist in "*.DES" and "*.HES" files format. |
|
|
When creating a new client, it is recommended to use data from the INIT directory. If you need to change the set directory, use the Change directory button and select another data source. |
|
OLAP support |
The database called FIRM_DM will be created on SQL server. The database will serve as OLAP support. |
|
Add to login window |
After pressing the button, the client name will be added into the options of Client drop-down menu in the login window of K2 system. |
To copy data from one client to another:
- In the original client, enter intothe Database Administration book in the Administrator module and indicate the files, which you want to copy, by means of asterisks (Shift+F2 keys indicate all the files).
- From theDatabase Administration module menu select the function Form - Bulk Actions - Database Export.
- The data are exported to the directory "CLIENT"/DATA in "*.DES" and "*.HES" format.
- In the Change client form, enter the 2nd page of the new client and press the Data import button. In The offered form select the path, which the files are to be copied from, and press OK button.
Other recommendations:
K2 IS presupposes rather that users are assigned to a client which they will work with. If one user is to work with data of more clients, it is recommended to enter the user with more names. The main advantage is that the different rights can be assigned to a user for each client.
It is important to prohibit users from Administration of Users right what prevents from changing users' rights, and Switch over the client right to prevent them from logging into a different client than that is preset for the users.
Note: If you have any ambiguities about the definition of the client, please, contact your consultant.
Administration of own companies
By means of this function Administration of own companies it is possible to share the common data among more companies (e.g. parent and subsidiary companies). The function is in tree menu Administrator - System - Administration of own companies. It is necessary to set the right Set own companies (Administrator - General) to create and delete companies.
After starting the function, the Administration of own companies form will open, where you can insert individual companies with the Insert key or the button. Button or Enter key opens the existing record and enables to change it.
Picture: Setting of own companies
Own companies tab
The form for the own companies setting contains two tabs: Basic setting and Users.
Picture: Own companies form - Basic setting tab
Basic Settings
Fields Description:
Company No. |
Automatically generated number of a created record (company). |
Blocked |
The checked field means that the company is not offered at the bottom part of the K2 screen. You cannot switch into. |
Customer |
Selection from Suppl./Cust. book (companies), where you will switch to. |
Member of group |
You can create a group, which includes more companies. E.g. for a case that a company has more branches. |
ID-no. |
Added Company ID-no. from customer card automatically. |
VAT reg.no. |
Added VAT reg.no. from customer card automatically. |
Address |
Address prefilled from customer card automatically. |
Country code |
Displays an own company country (from a customer). |
Partner |
Number of a partner linked with a customer is displayed. |
Business register |
The possibility to set a text for the business register. It is possible to enter multi-line text after you press the button. |
General information |
It is possible to enter a random text that can be displayed in reports for a purchase and a sale. It is possible to enter multi-line text after you press the button. |
Company colour |
Possibility to set the background colour for a particular company. If the colour is not filled, the company colour is taken. In your own desktop, the colour from your own desktop, if is filled, is overtaken. If the colour is not filled, the colour is taken from this field). |
Status bar colour |
Possibility to set the status bar colour for a particular company. If the colour is not filled, the company colour is taken. |
Company icon |
Path to the image of the company icon for display e.g. in reports, in the menu of this function or on the desktop. |
Company logo |
Path to the image of the company icon for display e.g. in reports, in the menu of this function or on the desktop. |
Header picture |
Path to a picture for report header. |
Footer picture |
Path to a picture for report footer. |
Company stamp |
Path to a picture for the company stamp. |
Currency |
Currency of the own company. |
Organizational structure |
Possibility to choose an organizational structure. |
Visual style |
Possibility to choose an own visual style. |
Own exchange list |
If it is checked, the company uses the own exchange list. If it is off, company uses the common exchange list. |
Inverse exchange rate |
If enabled, foreign exchange rates are displayed in all documents and in the exchange rate list in the ratio "x" of foreign currency units to 1 unit of the base currency (currency set on the 1st page of the client's parameters). If off, foreign exchange rates are displayed at a ratio of "x" base currency units to 1 foreign currency unit. |
Legislation |
To determine the legislation of your own company. |
Licence I. CA |
License file from I. CA for signature certification. Without a license, signing is non functional. License files can be per company or per user. In this field, enter the multi-license file for multiple users registered with the "ID-no". |
In Basic settings you can run these functions:
- Accounting - the description of functions is stated in the Accounting manual,
- Set up of VAT posting and Parameters for reverse charge documents - the description of functions is stated in the Accounting manual,
- Parameters for reverse charge documents - the description of the function is stated in the Accounting manual,
- Set-up of EET service - the description of the function is stated in the chapter Settings of EET service,
- Discount parameters - the description is in the Finance manual,
- Consolidation exch. rate,
- Rounding - the description is in the Rounding.
Users
Here you can select the users, who will have the access to this company. When you press the Insert key or button the form divides into two parts - Available records and Selected records. In the Available records, double-click the left mouse button or the button to select the user. This will move them to the Selected Records section. If you want to put them back intoAvailable records you need to use double click again or
Note: The user with the right Administrator - General - Configure own companies has always access to all own companies, regardless of this setting. If no user is defined on the Users tab, all users have access to this own company.
Picture: Own companies - Users tab
We switch between individual companies in K2 either in the navigation panel or at the bottom of the screen by clicking the left mouse button on the currently switched on company and selecting the desired company.
Picture: Switching among companies - navigation bar
Picture: Switching among companies - the bottom part of the screen
Reports take the company, where you are currently switched.
If you switch to other company, the K2 interface will be updated, all unsaved docked folders will be closed.
Picture: Own companies form - Rounding folder
Selected Fields Description:
Rounding constants |
The set value is added or subtracted for rounding purposes to the relevant amount in the tax recapitulation (Net, VAT or Gross) or to the price in the invoice header (Gross only). Only mathematical rounding is applied to the resulting amount. You can achieve rounding up or down by this one. For example, if the tax should be rounded GBP up, then set +0,499 into constant and set value 1 into order. Then the tax amount 3,02 in document with constant will be increased to 3,519, which is mathematically rounded to 4. |
Rounding order |
It rounds the appropriate amounts in Tax summary or in the invoice header to a multiple of the specified value in the parameters. E.g., if the Invoice In Net price equals 100,16 and you have 0,10 value in purchase order, then the Net invoice price will be mathematically rounded to "integer", those to 100,20. |
Gross of invoice |
It evaluates the whole (header) Gross invoice price. We do not recommend this type of rounding, as it rounds just the final amount with tax and that one cannot meet the total sum Net + VAT. We recommend to round by means of Payment method on invoice instead. More about rounding is described in an appropriate documentation. |
Rounding error |
It means a value of the document currency. It is useful either in foreign or domestic currency. In case of payment in foreign currency, it is possible that the paid amount that is different with invoice price (exchange rate change) can change to basic currency after transfer. If this difference is in the Rounding Error tolerance, the payments are considered settled and the payment and invoice amounts will be compared (see Bank statements - Item (1st page). In the case of payment s in the base currency, 6. Page of invoice follows the Remaining Payout field. If this one if lower than the value of Rounding errors, the invoice is signed as paid (see Payments 6th page). |
When creating a new own company, rounding is set automatically:
In purchase:
Net - order of 0.01
Gross - order of 0.01
In sale:
Net - order of 0.01
Gross - order of 0.01
Gross invoices for calculation from above - order of 0.01
The rounding error is set to 0.1 for the CZK currency and 0.01 to the other currencies.
If a new own company is created, the currency of the own company is set (before selecting the customer of the own company) according to the currency in the parameters of the client and the rounding is set accordingly. So when there is a currency other than CZK in the client's parameters, the rounding error is set to 0.01.
Split code lists tab
Picture: Administration of own companies - the 2 Split code lists tab
Some code lists can be divided within your own companies. Each own company can use a different part of the code list.
After dividing:
- After being split, the selected fields of the code list have a different value in each own company (VAT rate in Articles, Bank Account and Currency in Customer).
- In each own company the code list may have different content, some records may be shared between own companies.
Note: If the Customer code list is split, the Partners for marketing code list will also be automatically split and vice versa. Matching symbols for accounting and Employments code lists are split obligatorily. For the code lists Personnel data of the employee and Deduction from wages, the field "Divided" is checked automatically when creating a new client.
Attention: Before performing the partition, it is necessary to back up the K2 database and set the reinstallation mode. If K2 is not in reinstallation mode, the program will notify us.
Picture: K2 system message
Picture: The record for splitting the Articles code list.
The code list can be split by means of the Split button. On the Divide form, we will select our own companies, to which the entire content of the existing code list will be transferred. A company that we do not check when dividing will have the given code list empty after the division. To transfer specific records to other own companies, you can use the bulk function for assigning records to own company.
Picture: Divide form
Splitting can then be canceled with the Cancel Split button. A split can be cancelled only if the code list is not shared in a group. When canceling the division, we will select our own company, whose code list will be retained. The contents of the code list of other own companies will be deleted.
Picture: Cancel dividing form
Note: It is always necessary to restart K2 after making changes in the dividing of code lists.
Attention: If a user is authorized to work in multiple companies at the same time and some code lists are split, it is necessary in order to all data modules used in the scripts and reports set the correct context of the own company by using the functions SetDataMContext and ReleaseDataMContext.
Sharing in groups tab
Picture: Administration of own companies - the 3 Sharing in group tab
On this tab, you can define groups of own companies for which the selected code lists will be common, ie when you create an entry in a given code list, a record is created in all companies in the group.
We create new group by Ins key or button . On the tab 2 Own companies check all own companies for which you want to share the code lists. On the tab 3 Shared Code lists, check all the code lists we want to have in common for the given companies group. There are only code lists, which have been divided in the form Administration of own companies, see the Split code lists tab.
Picture: The Group for sharing the code lists form - the 1 Group for sharing tab
Picture: The Group for sharing the code lists form - the 2 Own company tab
Picture: The Group for sharing the code lists form - the 3 Shared code lists tab
Assigning records to/from own company
If a code list is split see The tab Split code lists , the marked records from the given code list may be assigned in bulk to the code list of the different own company by using the function Assign record to. own companies.The function is available in the Menu - Bulk actions - Assign record to. own companies.In the same way, a share record can be removed from a company by the Exclude record from own company function. Excluded record will be invalidated.
Picture: The Articles code list - the function Assign record to own company
The Companies button shows in brackets the number of own companies in which the record is included. You can display these own companies after clicking the button. You can manually add additional companies here using the Ins key. With the Delete key we can then manually delete the record from individual own companies.
Picture: The Articles code list - Companies button
Discarding a record will invalidate the record in that company's own business. The display of such invalidated records is governed by the user parameter Display inactive records.
Own companies in different currencies
This document describes the basic specifics and necessary settings of K2 for the possibility to run your own companies with different currencies in one K2.
In K2 there are installation files and setups for Czech K2 (CZ) and Slovak K2 (SK). Both setups contain all standard functions. Different DEMO, INIT, Tree, files in DOC and Support Files. The Support Files are also largely the same (at least the Lang3 and Lang5 folders). Files that are not in LangX are different, such as POST CODETOWN.CSV. These are in the CZ setup Czech and in the SK setup Slovak.
Most of the standard functions, scripts and reports that are common to SK and CZ take into account the state of the own company. They can behave differently when the state is CZ and when it is not CZ. differently E.g. The VF_Dok01.AM report for the SK state prints one additional tax number (Slovak VAT number). It prints only 2 tax numbers for the state of CZ. What is VAT in the Czech Republic is called IČDPH in Slovakia. What they call the VAT number in Slovakia has no equivalent in the Czech Republic.
The division of code lists is generally described in the K2 manual in the Administrator / System / Own companies administration module. If there are own companies with different currencies, it is recommended to divide the code lists:
- Article so that each own company can enter its VAT rates.
- Customer so that each company can enter its bank account and currency on the Customer.
- Bank accounts so that each company can mark a different bank account as the default.
When evaluating your own companies with different currencies, the following behavior should be considered:
- It is recommended to always show only companies with the same currency.
- In the administration of own companies, it is possible to enter the Consolidation Course, which is used in some reports to display totals even through own companies with different currencies, e. g. the Openitem report (OpenItemList.AM).
- When filtering in the general ledger, the Book of Accounting must be entered !!!! It is not possible to filter through accounting books with own companies with different currencies.
- The book of accounting of your own company is entered in the Administration of your own companies, in the Accounting tab. From versions K2 luna.04 and K2 mia.08, Openitem reports by account (OpenItemList.AM) or Inventory by account (ZB_INV8.AM) will work with this information. In these reports, it is possible to set the Book of Accounting by current own company parameter to display only the balance from the current own company.
- Consolidation in OLAP - data evaluation also for companies conducted in various currencies. The principle of consolidation consists in determining the consolidation rate. It must be entered in the book Administration of own companies on the tab Consolidation rate. This exchange rate is entered on a specific date and is then used to recalculate the values of consolidation rates into the client main currency. Other prerequisites for using consolidation are setting OLAP parameters. It is necessary to set the parameter Show own companies. A new axis is then added to OLAP for evaluation across our own companies. Another parameter that must be set is Accept multiple currencies in the client. Consolidation rates are then included in several OLAP cubes (Invoices out for Sale, Invoices in for Purchase, Contracts, Orders, General Ledger). More about this issue is described in the K2 manual in the Managerial Reports section in the chapter Consolidation of own companies.
The VAT methodology for a Slovak company is described in the manual under the Accounting module in the Slovak VAT in Czech K2 chapter. This material will only contain information about the necessary settings.
- In the Client's Parameters it is necessary to register a script for VAT calculation according to Slovak legislation. In the tree menu Administrator / Parameters / Officer parameters. On the 5th page, after pressing the Registered client scripts button, we will add a new entry to the list of registered scripts - in the field Script enter "SK_RF_K2STD_VATD" and check the Enabled option.
- To code list. Taxes types we will add types of taxes that are different for Slovak legislation and that we will use. The same scripts are used to import tax types as in CZ. The values in the code list are filled in based on the country of your own company.
- To code list. VAT Rate we will add VAT rates valid for Slovak legislation (if they are not already in the code list). We run code list from tree menu Basic data - VAT rates.
- In code list Member of group create a new record (start the code list from the tree menu Accounting - VAT - Basic settings), press the VAT calculation parameters button and check Slovak VAT in the Czech K2 in the parameters. After agreeing on the parameters, we save the record.
- VAT calculation parameters created on Member of group We filled parameters according to slovak legislation.
- In the tree menu Accounting / VAT / VAT / Slovak VAT in the Czech K2, Slovak forms for VAT are available - VAT Control Report and VAT Summary Report.
- When calculating and setting VAT, it is necessary to select the right own company. Based on the state of your own company, it is decided whether SK or CZ VAT will be run.
They use their own reports in letter mail:
- Posting list (SK_PostingList.AM)
- Posting sheet (SK_PostalFilingSheetNew.AM).
They use their own scripts to import the exchange rate list:
- KurzListok_ECB_XML.PAS or
- KurzListok_ECB_CSV.PAS.
They use the exchange rate list history to import
- KurzListok_ECB_CSV_Historia.PAS.
If your own company has its Own exchange rate list checked in the administration of its own companies, the scripts for importing the exchange rate list of these own companies must be run with the CompanyId parameter filled in.
They use their own function for road tax:
- SK_DanMotoroveVozidlaVypocet.PAS.
They have their own scripts for micro entities:
- Scripts SK_Uct_EA2014.PAS and SK_Uct_Ea2014Muj.PAS.
They are based on the K2 standard for intrastat, they have their own scripts for
- Customs Tariff Import (SK_IST_CSImp.PAS)
- Export intrastat (SK_ISD_EXP.PAS).
For proper operation of your own companies, it is necessary to use a Group Member in which the parameters for a specific own company are defined. It is necessary to list the books of documents of your own company.
To complete the data of the company according to the entered ID number, they use:
- Script (SK_BazPart_FillDataByICO.PAS).
The script also sets the VAT payer's flag. Bank accounts are not imported.
It is possible to use the CZ standard for VAT number verification, because the Slovak VAT number and the Czech VAT number are already in the same fields. In Slovakia they use:
- Auxiliary script to control VIES over Suppl./Cust. or a VAT document (SK_CrpDphCheck.PAS).
For some common standard sets and functions, a slightly different setting is suitable when used for Slovakia:
- List of coins Parameter Currency = EUR
- Script for credit notes Parameter CorrTaxTypes = True
- Discount In Parameters they have on: “Change tax type”.
Task scheduler
Action in Task scheduler runs on application server, users can log in to it from anywhere and without having to run K2. You can check the tasks from any K2.
Standard action
Most shortcuts support running over a record filter. To do this, you need to activate the Process records from filter option. If the Create filter from selection option is no longer activated, then records from the filter of the user under which the application server is running will be processed. If the Create filter from selection option is activated, then it is necessary to select a saved selection on the basis of which the filter will be filled.
Stock recalculation
The Stock recalculation function is described in detail in the chapter Recalculation - Stock recalculation.
In addition, the function executable from the Task Scheduler has the following setting options:
Fields Description:
Period from |
Unlike the standard Stock recalculation form, you can also enter a zero period ("initial state") in the shortcut. This setting can ensure that the recalculation automatically run from First not blocked period. |
Company |
Own company which will be recalculated. If it is not entered, current own company is recalculated. |
Maximal level |
If the Recalculate all levels option (in production) is activated, you can restrict the scrolling to a certain number of levels (immersion) by entering a number. Default value = 100. Value 1 Means only current level. Example: If the product consists of a semi-finished product and in the article filter we have only the material card from the semi-finished product job card, then for example when changing the input price of the material only the material price is recalculated at 1, the semi-finished product is recalculated at 2. Job card header) and at a value of 3, the product card would also be recalculated. |
Minimum allowed period |
Recalculation insurance - documents are never recalculated before the specified period (e. g. if the blocking period is set incorrectly so that periods that have already been closed are not recalculated). |
Number of period - 1. confirmation |
The number determines how many periods the recalculation should look back to from the blocking period and look for documents with the first confirmation. |
Fixed batch price |
If the item in the purchase is split, the batch price will not be averaged. |
Batch price - ignore transfer cards |
Transfer cards are ignored when searching for the first batch receipt. |
The cost price is does not charge |
If the option is activated, then the recalculation does not match the "L" and "Z" flags of the documents in the event of a change in the cost price of the document item. |
Warehouses without control, Article without control, Species without control |
List of numbers of warehouses, articles and types of article for which negative stocks are not recorded in the recalculation protocol (no check for negative stocks is performed). However, recalculation recalculates items by default |
Stock recalculation - current period
Stock recalculation function automatically processing only the current period.
Recalculation of daily balances in stocks
It is used to calculate daily stocks in warehouses from the specified period. You can also enter a period in blocked periods. The significance of this recalculation is for a one-time calculation of daily balances from the history, which is already in blocked periods. Restarting over scheduled actions is not advantageous because it always runs from a specified period. For regular updating of daily balances, the Stock recalculation shortcut is used with the option Recalculate daily balances on stock is activated.
Product recalculation
The function is described in detail in the chapter Form - Actions above the Article database.
Coverage recalculation, Coverage recalculation by definition
A more detailed description of the function can be found in the chapter Bulk actions on job cards and orders.
Recalculation - ABC analysis
Calculates the ABC analysis of the specified configuration or all configurations.
Shift (days) |
Specifies on which day the analysis will be calculated with respect to the launch date in the planned actions. Example: In the Scheduler, we have set the analysis to start every day after midnight. A value of "1" then means that the calculation will be performed on the previous day (i. e. the current start day minus 1). |
All configurations |
By activating, we determine the calculation of all configurations. |
Configuration |
Use the Configuration button (at the bottom of the form) to select specific configurations for the calculation. |
Inventory turnover recalculation
Recalculate inventory turnover of the specified configuration or all configurations.
Shift (days) |
Specifies on which day the turnover will be calculated with respect to the launch date in the planned actions. Value 0 can be also entered. Example: In the Scheduler, we have set the turnover to start every day after midnight. A value of "1" then means that the calculation will be performed on the previous day (i. e. the current start day minus 1). |
All configurations |
By activating, we determine the calculation of all configurations. |
Configuration |
Use the Configuration button (at the bottom of the form) to select specific configurations for the calculation. |
Recalculation of stock prices
The function is described in detail in the chapter Form - Actions above the Article database.
Recalculation of article prices
The function is described in detail in the chapter Form - Actions above the Article database.
Invoicing calculation
The function is described in detail in the chapter Recalculation - Invoicing recalculation.
Recalculation of planned job cards
The function is described in detail in the chapter Form - Bulk actions above the Job cards. When assigning an action to the Task Scheduler, it is necessary to select a selection from the Job card book, which defines the content of the recalculation.
Recalculation reserved ordered
Recalculate the "Reserved" and "Ordered" values for product cards.
Finance
Recalculations of cash register balances
Function Recalculation of cash register balances is closely described in documentation Finance - Cash register - Functions over cash register documents - Recalculation of cash register balances.
Recalculation of bank account balances
Function Recalculation of bank account balances is closely described in documentation Finance - Bank - Bank statements - Functions over bank statements - Recalculation of bank account balances.
Marketing
ARES
It will start ARES function, which adds or actualises data of a customer or a partner. It will run upon the selection of customers or partners defined in the filter.
Function will run with parameters, which has ARES function set in Administration/Parameters/ARES parameter.
Workflow
New process
Batch creates new process from a procedure, which is defined in the field Procedure. Procedure does not have entered any user interface in the beginning event (definition of variables, filter of users).
Administration of objects
The Stored Object Manager function is intended primarily for working with filters (TxFilter class). The main purpose of this function is display of invalid filters and their editing. In addition to filters, other objects are loaded here, which we can delete, edit, move between levels and check. The function is in tree menu Administrator - System - Administration of objects.
If a user has set the right Service actions (Administrator - General), all objects available for that user will be loaded and displayed here. For a user without the Service Interventions right, the filter for the current user is always applied by default when loading the list of all objects. The Invalid Objects, Initialization, and Function Removal of Inconsistency and Conversion Rules buttons under the Tools button are not available to users without the Service Interventions right.
After After starting the function, the Saved Objects Manager form will open, where (depending on the setting of the Service Interventions right) all objects accessible to the user will be displayed.
Picture: Saved object manager - set the right Service actions
Picture: Saved object manager - set without right Service actions
Filter button
After pressing Filter button the form for setting filter conditions will be opened.
Picture: Setting of conditions for filtering saved objects
Fields Description:
Class |
Select classes from Filter - Class, where you run the filter over. E.g. class TxFilter represents a filter. |
Context |
Select classes from Data modules, where you run the container over. |
User |
Select the user from The book Users, whose objects you want to be displayed. For a user without the Service Interventions right, this field is read-only and cannot be changed. |
Client |
Select the client from The book Clients, whose objects you want to be displayed. |
Level |
Selection of a setting objects level, which you want to be displayed: Factory, Global, Client, Group and User. |
Button Default gives the filter back, it means to delete set conditions.
After confirmation of filter conditions by means of OK all objects meeting the set conditions will be displayed.
The button Invalid objects
If there are invalid objects (e.g. selections),, their list will be displayed afte pressing the button Invalid objects An invalid object can be deleted or modified in the Saved Objects Manager. Button is approachable just for those users who have the right Service actions.
Invalid "Factory" objects can be deleted in the case of:
1. The user has the right "Administrator / Access settings level / Global"
2. The object is marked as invalid, it is a part of a result " Invalid actions"
Picture: Saved object manager - button Invalid objects
The button My objects
Deals with special case of filtering, when the parameters are set in the way all objects are entered with a log-in user. The same result is also achieved by means of general filter.
Picture: Filter of objects of currently signed user "K2" - the button My objects
Button Initialization
The Initialize button runs the function Initialization, which is a part of required K2 initialization after reinstallation. The Initialization function checks for and automatically corrects invalid objects in some classes. The button is accessible to user with Service actions right.
When the Initialize button is run, an AlterFields.unknown.xml file is created in the user directory, listing the unknown fields (OldFields) and their data modules (DataMClass). This file can be renamed, copied to {MainPath}, and used as the basis for Conversion Rules.
Tool button
There are 4 functions under the Tools button: Remove inconsistencies, Conversion rules, Export and Import.
Remove inconsistencies
After reinstallation to the higher version, it is possible, through the action Remove inconsistencies, to find and remove invalid records from the tables ObjRow, ObjStorage and ObjAssign, in which the configuration objects (eg. filters, columns) are stored.
When the action is complete, a log containing a log about the found problems is displayed. Each object, that is evaluated as an invalid or unnecessary object, is saved into a directory, which name is specified in the log, before deletion.
Picture: Remove inconsistencies - the log of found problems
Conversion rules
Use the Conversion Rules action to edit the contents of the {MainPath} \ AlterFields.xml file. Conversion rules allow you to define <old ProgName, new ProgName> identifier pairs for data module classes. File can be actualised either by Object manager editor in or by copying. This information attempts to use the "Initialization” function to automatically correct some invalid objects. The classes TxFilter/Selections and TxGridColumns/Columns as are supported.
Conversion rules allow you to automatically fix some objects when it is actually possible to formally replace one identifier with another.
Picture: Conversion rules - AlterFields.xml file exists
AlterFields.xml factory file exists and contains the list of renamed and conversioned fields, which can be replaced freely. AlterFields.xml file contains serialised TxAlterFields collection. Each item of TxAlterField class contains these properties:
DataMClass: string - DM class, which concerns OldFields and NewFields fields. If it makes sense, an abstract ancestor class (such as TDPrask) can also be used.
OldFields: string - the original field, which has been renamed. Value can include one identifier or more separated from each other by means of semicolons.
NewFields: string - new field. Value can include one identifier or more separated from each other by means of semicolons. Value must define valid field, otherwise upon an attempt of replacement the exception will appear.
Example
TD_DoNP_P: NakPro -> SaleItemsChild
TD_DoNP_P: NakPro -> PurchaseItemsChild
Export
The function exports all objects that are currently loaded into the memory. You can limit the list of loaded objects by using the Filter button.
Picture: Export
Import
The function imports the objects from the file.
Picture: Import
Set Internet connection
The Internet connection settings function is used to set up an Internet connection (e. g. web services, exchange rate list import) in case we use a proxy server.
Function runs from a tree menu Administrator - System - set internet connection.
Picture: Tree menu - Set Internet connection
Picture: Form Set Internet connection - proxy
Select communication protocol with proxy server into Type case we use a proxy server. (You can find "HTTP", "SOCKS 4", "SOCKS 4A" or "SOCKS 5" definitions of particular types here on http://en.wikipedia.org/wiki/SOCKS). Authentication field in proxy server enables to select if you use the name and password (value "name and password") for logging or no (value " without authentication").
SOCKS in any variant cannot be used for web services. Web services are: Creditcheck, Octopus, Reliability of VAT payer, PPL and other, for which you can use "THTTPRIO".
Reinstallation manager
Reinstallation manager is used to ensure the correct reinstallation of the K2 system. Manager is situated in tree menu in Administrator - file System. For work with Reinstallation manager it is necessary to user has set the right Service interventions.
Picture: Administrator- Reinstallation manager
When the function starts, Reinstallation Manager form appears.
Picture: Reinstallation manager
The Ban Login check box prevents users from logging in IS K2 with the exception of the user who set the login ban. This ensures that the reinstallation process is not disrupted by the presence of users in IS K2 Ban login from field allows to set, from when user cannot log in. If the login time is before the set ban, a message will be displayed that it will not be able to log in to IS K2 from the set time. User sets the report in Message after login field. The abbreviation of the currently logged in user who performs the settings in is then automatically added to the User field in Reinstallation manager
Picture: Login window IS K2 - checked field Ban login
Picture: Login window - after filling field Ban login from
While the Ban login box is checked, the Reinstallation allowed box can also be activated. This confirms that the user is not prevented from reinstalling and can take place. To check the box, it is necessary that all users are logged out of K2 and all mandatory initializations in the given version have been performed. If the box is not checked, the installer will not allow us to continue the reinstallation.
If the box is not checked, the reasons appear in the Reasons for not checking the box.
Picture: Reinstallation manager
There is also a Automatically apply updates check box on the Reinstallation Manager form. A checked box means that when installing K2, available updates that were released after the release of the installed version are installed immediately, and the user does not have to bother with them later.
Picture: Reinstallation manager
The Check structures button checks whether the database structures correspond to the definitions in K2. The check can be run at any time because it is not bound to check the Ban Login or Reinstallation allowed fields. The same check is also performed in preparation of the installer for reinstallation.
Picture: Reinstallation manager - Check structures
If certain actions need to be performed before reinstalling from a lower version, an "Preparing for" that version "button will also appear in the Reinstallation Manager, which contains the necessary initializations.
Warning: After the reinstallation is completed, K2 is still in reinstallation mode and you cannot log in to it. The user who made the settings in the Reinstallation Manager must after the reinstallation is complete log in to K2 and in Reinstallation manager undo the check Ban login. Then it is possible to K2 log in by any user.
Note.: As long as K2 is in reinstallation mode, the user who sets the reinstallation mode will be notified when K2 exits with the message "K2 has login banned. End anyway?”. If the user selects Yes, K2 will exit, if No, the user will remain logged in.
Picture: K2 system message at K2 termination
Modules
All inputs to individual modules are written in the Modules book. The book displays the date of entry, the module number, its name (description), license number, the number of entries into the module (the presence of each user lasts longer than 1 minute) and the Difference column shows the specific value when the user enters module for which it is not licensed. In the book, we can sort the records by date of entry or module number.
Picture: Modules book
Application statistics
Application statistics enable you to monitor numbers of runs of monitoring actions. A monitoring action can be any transaction, computer action, script or a report. It is possible to monitor how intensive is the use of particular function or system customization. E.g. it is possible to capture all running scripts and reports and thus better prepare for transitions to newer versions of K2. Statistics can also be used to increase the efficiency of investments in the system.
In the evaluation in the form of dashboards, it is then possible to trace who used the function at what time.
By using the application statistics, you also agree to the sending of a certain sample of anonymised statistical data (i. e. data without user identification) to K2 atmitec. In hose data there are no specific or even delicate information, just statistical information about usage of particular functions. This data is further used to optimize K2 applications and related services.
Administration of application statistics
The setting of the Application statistics module is defined in the Administration of application statistics. The function is added in Administrator - System - Application statistics - Administration of application statistics tree menu and is accessible just to users with Statistics settings (Administration - General).
Picture: Administrator - System - Administration of application statistics - folder Administration of statistics
Fields Description:
Taking statistics - I do not agree with the above mentioned terms and conditions |
Unchecked field means that K2, which is set as production, collects statistic information and sends anonymous data in K2 atmitec. In administration of task scheduler a new planned task "Send statistics" will be created and it will send it into K2 atmitec. By default it is set for Saturday. Without the use of the task scheduler, it is possible to invoke the sending of statistics by running K2.exe with the parameter FUNCTION = 779, or to ensure its regular start using Scheduled Windows tasks. Just fabric statistics will be monitored without any other settings. |
Sampling interval |
An interval, after that the statistics are saved from the memory into the database. The value 480 min is set by default . |
Other two fields are important for reduction of the statistics data size. Data can be limited by the time and number of records.
Maximum age of statistical data |
Statistics, which set number of days are surpassed of, will be deleted. |
Maximum size of statistical data |
If the set size of collected statistical data are surpassed, the oldest records will be deleted. |
Standard fabric group for statistics monitoring is set for module monitoring across the whole K2 IS. You can monitor other functions in IS K2 except this group as well. These check boxes are important.
Selected fields description:
Automatically offer to performed calculation blocks to analysts |
Checked field means that you will collect all computing blocks, i.e. not just factory ones. |
Automatically offer to analyst executed scripts |
Checked field means that you will collect all performed scripts, i.e. not just factory ones. |
Run monitoring for these scripts |
A checked field means that we will monitor all executed scripts, ie. we will monitor all scripts in the Statistics Viewer. These scripts are important for the internal purposes and are not sent into K2 atmitec. |
Automatically offer to analyst executed reports |
Checked field means that you will collect all performed reports, i.e. not just factory ones. |
Run monitoring for these reports |
A checked field means that we will monitor all executed reports as well, ie. we will monitor all reports as well in the Statistics Viewer. These reports are important only for the internal purposes and are not sent into K2 atmitec. |
Automatically offer to analyst running universal form |
Checked field means that you will collect all performed universal form, i.e. not just factory ones. |
Run monitoring for these queries |
A checked field means that we will monitor all running universal forms, ie. we will monitor all reports as well in the Statistics Viewer. These universal forms are important only for the internal purposes and are not sent into K2 atmitec. |
Other four fields give the information about the last planned action "Send statistics".
Statistics - latest sent date |
The date and time, when the latest task scheduler was performed . |
Size - latest sent statistics |
Statistics size, which was sent into K2 atmitec last time. |
Sending duration - latest statistics |
Duration, when the scheduled task ran for sending statistics. |
Factory analytics- latest update date |
Date and time of the last factory analytics update. The update occurs when you run a scheduled task "Sending statistic". |
Monitored analytics
Within the Monitoring analytics tab, the performed actions are included in the particular tabs Transactions, Computing block, Scripts, Reports and Uniform.
Picture: Administrator - System - Administration of application statistics - the Monitoring analytics tab
Transaction |
Database file of operations when either all operations or no of them will be executed. |
Computing block |
A block of operations that logically belong together and create one step in the K2, e.g. saving document, run selection, run filter etc. |
Script |
|
Report |
|
Uniform |
|
You can monitor either all of them (by checking the appropriate field on Administration of statistics tab) or just the selected ones. If you want to monitor just some actions, check the field in Factory monitoring column on the appropriate line or Press on appropriate record on the Administration of statistics - Monitored analytics form and check Factory monitoring field. Those signed actions will be monitored in Local statistics monitoring. Factory monitoring field is checked by the programme.
Picture: Setting of Computing block for the Customer monitoring
Button Delete statistics is used to delete all collected local application statistics and analytics for monitoring.
Browser of outgoing statistics
The list of anonymous groups of application statistics, which are sent to K2 atmitec, is places in tree menu in Administrator - System - Application statistics - Browser of outgoing statistics.
Display of Browser of outgoing statistics is conditioned by the right Setting of statistics (Administrator - General).
Browser of local statistics
The list of application statistics, which are monitored just K2 atmitec, is places in tree menu in Administrator - System - Application statistics - Browser of outgoing statistics.
Display of Browser of local statistics is conditioned by the right Setting of statistics (Administrator - General).
ooks called Browser of outgoing statistics and Browser of local statistics are important just for check, or for export to excel. OLAP and dashboards works for evaluation of local statistics.
Not used scripts and records
This function is important to generate the list of all not used scripts and reports.
It is a good idea to register scripts and reports before running.
Open the Scripts and Reports book and press F9 to start the report book. Then press Ins key and the list of scripts and records will be displayed. You can run script registration by means of Alt+F3 keys. Now you can run the Not used scripts and reports function.
Transfer of customization
Transfer of customization is consisted of two functions: Export Export ofcustomizations to file and Import of customization from file. The right Service actions(Administrator - General - Service actions) is necessary for the work with these functions.
Function Export customizations to file and Import customizations from file works with .zip file, in which are saved user K2 modification except for the data. They allow you to transfer scripts and reports, form modifications, registered scripts, object designer files, file module extensions, INI files, views, coverage configuration, external additional fields, and annotations.
Export customizations to file
The function is in tree menu in Administrator - System - Transfer customizations - Export customizations to file and is accessible just to a user with the right Service actions (Administrator - General - Service actions).
Picture: Function Export customizations to file
An offer, where you sign the modification you want to save, will be displayed after running of function.
Fields Description:
Path to file |
Selection of way, where you should save the file called RestorePackage.zip with selected modifications |
Import customizations from file
The function is tree menu Administrator - System - Customization transfer - Import of customization from. file and is accessible to user with right Service actions (Administrator - General - Service actions).
Picture: Function Import customizations from file
After starting the function, a menu will appear in which we will indicate which modifications from the loaded .zip file we wish to transfer to IS K2. After loading the .zip file, all of the possibilities that have been ticked when exporting are automatically checked.
Fields Description:
Path to file |
Select the path, which the .zip file for import should be loaded from. |
||
Apply to current client |
If this option is checked, all extensions and settings (forms, RF_Firm.pas, extension of file modules, etc.) from the selected client in the Select client for transfer field will be applied to the current client in the running K2. If this option is not checked, the folders and files will be created according to the source K2. |
||
|
Select client for transfer |
Selection of the client whose extensions and settings are to be applied to the current client. |
Partial K2 update
The K2 Partial Update function is used to upload fixes or new functions to the IS K2 without having to install a new version. Concerning actualization of legislative changes, which are solved by means of scripts or reports.
The function is tree menu Administrator - System - Updates of. K2 or creating by Other - Partial K2 Updates button on desktop. Favourites tab. To work with this function, it is necessary to have the Service Interventions right (Administrator – General – Service actions).
The form, where available actualizations are displayed automatically, will be displayed after you run this function. In case there is an empty form, no actualization is available for this version. Suitable records for K2 actualization are signed by stars automatically.
Picture: Partial K2 update form
You can install the signed records by pressing the button Install packet. To sign or sign off is able to do by means of Ctrl+Space and Shift+Enter.
Before the first installation of actualizations it is suitable to set, which kind of legislative you want to get the list of actualizations. You can do it by means of Setting button.
Picture: Partial K2 update setting form
The list of installed actualizations, which have been installed on particular K2, is available in setting as well. You can delete the list, not proper actualizations, which have been installed inK2, by means of Delete actualizations button. Then they are available for installation and you can install them again.
The choice Apply actualizations automatically has been added to reinstall manager. It can assure that available actualizations, which have been issued aftera new version publishing, will be installed immediately upon K2 installation. The user cannot bother with them.
Picture: Reinstall manager
The function Partial K2 update uses web services and you need a connection to internet.
Replacement of units in scripts
The Script Translation Assistant function replaces the prescribed unit names in the selected file in the uses section.
The function is in tree menu Administrator - System - Replacement of units in scripts . To run the function, you need to have the rights Change K2 script (384) and Change coded K2 script (385) (Administrator - Reports and functions (F9)) set.
Picture: Script Translation Assistant function
Fields Description:
Substitution definition file U_ |
Individual lines are definitions of what to look for and what to replace. "original unit"; "new unit", Const is automatically added to the name "new unit" at the end. |
Path to scripts or AM reports |
Location where the units are to be replaced. |
Special scripts and AM reports in the database |
According to the right of access, it performs replacement in special scripts in the database. |
Keep deleted units |
If the box is checked, then if the original drive has no replacement, the original name will not be deleted from the script or AM assembly. |
Fulltext keys setting
The full-text key settings are used to additionally define keys above tables, similar to adding indexes in file module extensions.
Some standard keys can be defined by running the CreateFullTextIndexes.pas script, which defines indexes on some standard tables.
These keys are then available to create full-text conditions in the selections.
Definition of fulltext keys is possible after running function no. 778. A list of tables for which keys have already been defined is displayed. The user can insert a definition for a new table or change an existing setting.
Picture: List of fulltext keys setting
To define a new fulltext key, you need to select a table and a unique one-element key.
Picture: Fulltext keys setting
Description of Fields:
For table |
The table for which the fulltext key will be defined |
Based on a one-element unique index |
A unique single-element key, preferably based on a number |
In the next step, the fields that can be assigned to the fulltext key are defined. The system will automatically offer command fields such as string, widestring, clob, xml and dynstring.
Picture: Fulltext key setting
Reinstallation
If text fields are changed or cancelled during conversions, the full-text key is automatically cancelled to avoid errors during the execution of conversion SQL queries. After the conversion is complete, the version initialization is run. The initialization tries to recover the cancelled full-text keys by definition in K2: Administrator - set fulltext keys, function 778.
Fulltext key recovery can be a time-consuming operation that is performed on the SQL Server background. Keys are therefore available for quering only after the operation is over in the background.
If an error, that can be caused by missing fields in the fulltext or by changing the primary key of the table, occurs during the restoration, the error is written into the log in the SetupLogs\repairfulltext_(client).log. file. These incorrect full-text keys need to be checked and corrected, see. chapter Setting full-text keys.