Load Balancer
Introduction
Load Balancer is an element of the K2 architecture that can be used to distribute the load among multiple application servers. The K2 API thus has the ability to connect to multiple application servers simultaneously. When sending a request, the least busy server is evaluated first and it receives the request for processing.
Picture: Load Balancer and K2 API
Example of using Load Balancer and K2 API:
The K2 API receives the request for processing. Load Balancer is addressed for the fastest request processing. The Load Balancer sends a request to all ASs and finds out their current load. It evaluates the least busy server and passes this information to the K2 API. The K2 API thus sends the request directly via the selected application server to the Load Balancer.
LoadBalancer can also be used for web K2, which when the user logs on, finds the most suitable application server and connects the user to it.
Picture: Load Balancer and Web K2
Example of using Load Balancer and Web K2:
Web K2 accepts the user's login request. The web K2 Load Balancer will contact the request to process the request as quickly as possible. The Load Balancer sends a request to all AS and finds out their current load. Web K2 passes the information on the least busy server. Web K2 will use the best evaluated server and thus the fastest processing of the user's login request will take place. Every other request of a given user is already processed by a specific selected AS.
Each K2 API and K2 web installation has its own Load Balancer. In the installation, you can set a specific list of application servers and the configuration of the Load Balancer, which can affect the algorithm for selecting a suitable application server.
Load Balancer evaluates the most suitable application server for request processing in two modes:
- Loading and evaluating the best AS before each connection request (preLoadingEnabled = false)
- Before each request to create a connection, the application servers are bypassed with a request for their statistics, which are processed and evaluated. The most appropriate AS is then used for the given request.
- Load and evaluate the best AS continuously (preLoadingEnabled = true)
- Statistics are read in the specified time interval and the best AS is evaluated. Each connection request is evaluated based on the calculated result of the statistics.
Load Balancer parameters
- requestTimeout:(default 1s) Each connection request is evaluated based on the calculated result of the statistics. If a connection fails with the AS by this time, or the AS does not respond by this time, the AS will be dropped for this particular evaluation. Upon the next request, it will be added to the list of possible application servers again.
- validTimeout: (default 0 u preLoadingEnabled = false, 1000- preLoadingEnabled = true) - the time for which the detected statistics and thus the best AS are valid.
- maxHistoryCount:(default 0) - number of records in history. If the number is 0, the history is not recorded. It is used only for debugging the optimal setting of parameters, when we can look into the history of the distribution of requests and adjust the parameters accordingly.
- preLoadingEnabled:(default false) - enable / disable mode with continuous loading of statistics. If set to true, then validTimeout means the time interval in which the statistics are updated.
- The appServers section defines the application servers that will be used by the Load Balancer. The default is the one used in the K2 API / K2 Web configuration
- Ex. for K2 API (Web K2 is similar only, configuration is done in JSON) "<add server =". "pipe =" ScriptService "/>”
- server: IP or PC name
- pipe: pipe AS name
- the multiplier section is used to set the weight of individual statistics and thus to influence the calculation algorithm
- Ex. for K2 API (Web K2 is similar only, configuration is done in JSON) <add uid="bscSystemCPUAvg" value="1"/>"
- uid: statistic identifier
bscSystemCPUAvg - average CPU usage over time
bscSystemFreeMemory - currently free operation memory
bscAppPoolSpandAvg - average waiting time for the K2 AS request before it is serviced
bscAppNCLSessions - number of connected web K2 users
bscAppAnonymousSessions - number of anonymous threads for K2 API
bscAppSchedulerSessions - number of running scheduled tasks
- value: the value by which the received statistic value will be multiplied by AS. This makes it possible to influence the weight of a given parameter.
A value of 0 disables the evaluation of this parameter during the calculation.
If in any mode the Load Balancer does not connect with the AS in the required time interval, or the AS does not supply statistics in the specified time, it is excluded from the evaluation for the given AS pass. In the next pass, the Load Balancer will try to connect to the AS again.
News in version
News in K2 alba.03
Universal Forms
Possibility of sorting and searching in simple lookups - parameter LABS_SIMPLELOOKUPLOCATOR
A new LABS parameter LABS_SIMPLELOOKUPLOCATOR has been created, which allows to toggle the sort (Alt+Z) or activate the search (Ctrl+Shift+F) in simple lookups.
Meaning of parameter values:
0 ... original behavior - cannot search or switch sorting (Alt+Z)
1 ... in lookups you can change the sorting (Alt+Z) and turn on the search (Ctrl+Shift+F)
2 ... in lookups, you can change the sorting (Alt+Z) and turn on the search (Ctrl+Shift+F), in addition, compact information about the filter is displayed at the moment of active search.
Communication
Response on received message
It is now possible to send a data message from the Inbox book using the option in the Reply to a received message ribbon - the data regarding marks, numbers and paragraphs are taken over, the sender and recipient data are exchanged and the prefix 'Re:' is added to the subject text.
Sale/Purchase
Extension of the functionality of the user parameter Copy reference number in sales to other receivables and received advances
The functionality of the parameter Copy reference number in sales has been extended for other receivables and received advances. Until now, the parameter only worked for issued invoices.
Copy reference number in sale:
• On - when creating a new free document with the F6 key, the reference number is copied from the invoice, other receivables or advances received on which we stand with a cursor. If we copy a document that has an attached contract, the reference number from the contract is copied.
• Off - when copying an invoice issued, other receivables or advances received, the reference number is generated according to the preset definition from the sales book or we can add it manually. It works in the same way with a free document.
Retail sale parameters - Article filter field (K2 alba.03)
Article Filter field has been added to the Retail sale Parameters. In this field, you can set an already existing filter that can be run over Article. Items from this filter will then appear in the menu when entering a business case in retail sale.
Setting EKO-KOM packaging according to the other article card (K2 iris.07 and K2 alba.03)
Added a feature to allow starred article cards or container item records to add packaging that another article card already has set in bulk. The function is called EKO-KOM packaging settings and can be launched from the ribbon of article tab from the Bulk actions tab. After running, article card that already has packages set is selected in the form, and these packages are set to article cards being processed after the function is completed.
Disount (%) from customer
If the Apply discount from the customer card field is specified in the Price List Settings, then if the Discount (%) field on the customer card (Sales tab) is filled in, then the price of the item in the sales documents will be reduced by the value from this field. A record of this discount will be displayed in the Progress of price calculations. However, if a discount is also entered in the Definition of price groups section, then this discount from the Definition of price groups takes precedence.
Logistics
Handling of requirements - nonvisual mode
The functions Handling of requirements - Create purchase orders / transfer notes / internal sales orders support the nonvisual mode. With this mode activated can be these functions used in the Task scheduler for the automatic ordering.
Support fro EAN13
We added support for barcodes in EAN13 format to IS K2. There is now a new option in the barcode definition function to create barcodes in this format. At the same time, we included a new IsEAN13 parameter in the reports for printing labels (BarCodeLabel100x50.am and BarCodeLabel100x50_A4.am), based on which it is possible to print barcodes in the EAN13 format.
Projects
Projects - Completed
Display of the [b][i]Completed[/i][/b] (CompletedCalc) field in the [i]Projects[/i] module has been adjusted.
It now displays an orange color when less than 100 percent complete. If [i]Completed[/i] is 100 percent, then the color is green.
Contracts
New Supplier Contract Number field on purchase contract
We have added the Supplier Contract Number field to the Contract - purchase document.
Creating advance from the contract
We have added Advance check box to the contract item. When creating documents from the contract using the Periodic invoicing and Installment invoicing functions, an advance received / provided is created for the items marked in this way.
Contracts – display of contracts with the same code on the Documents tab
In the Contract - sale and Contract - purchase documents, we have added the Contracts tab to the Documents tab - contracts that have the same Contract Code as the current document (addenda to the contract) will be displayed here.
Transfer of comments, header and footer text from the contract to the created documents
We have added the section Transfer from the contract to the created documents and checkboxes Comments, Header Text and Footer Text to the Books of Contracts for Sale and Cpntracts Books for Purchase.
In the Periodic invoicing and Installment invoicing functions, when creating documents, entered comments, header and footer texts are also transferred from contracts (depending on what is enabled in the contract book settings).
In the event that the contract creates a Contract with invoice / Contract with invoice, comments, header and footer text are transferred from the contract to the issued order / contract, and these data are added to the invoice according to the settings of the user parameters Copy comments and Copy header, footer and item text.
Contracts - planned tasks Periodic invoicing and Installment invoicing
We have created functions Periodic sales invoicing, Periodic purchase invoicing, Sales installment invoicing and Purchase installment invoicing that can be included in the Task Scheduler. Documents can thus be created automatically from contracts. After the action is completed, a notification with a link to the protocol with information about the created documents is sent to the user who is linked to the set contact person.
Finance
Automate for creating and sending reminders
A new script for creating and sending reminders (RemindersCreateAndSend.PAS) is available from version K2 alba.03. According to the set parameters, the script creates reminders and sends them by email or to customer mailboxes. The script can be scheduled as a scheduled task that will run automatically at pre-defined intervals.
Termination of the calculation of late payment interest
A new function, End of interest calculation, has been implemented in K2, which will allow you to set and change the end of interest calculation date on unpaid invoices issued, invoices received, other liabilities and other receivables. The function is intended for use on documents issued to a customer who is insolvent. The function is launched from the Ribbon of the Payments tab. After the date is set, the accrual of late payments and the calculation of late payment interest will stop. It is also possible to restart the calculation of late payment interest by entering the date of Resumption of late payment interest calculation.
In this context, new fields were created on the invoice received, invoice issued, other liability and other receivable documents on the Payments tab in the Maturity and late payment interest button:
• Termination of interest calculation
• Restarting the interest calculation
A new right Purchase and sale/General/Change of interest calculation dates for arrears has been added, which will allow the user to enter a date for ending the calculation of arrears even in the blocked period.
Adjustments in the books Open item to date and Open items to date - comparison
From the K2 iris.07 and K2 alba.03 versions, the books Open item to date and Open item to date comparison have been split.
Open item to date
When starting the Open item book to date, the user is prompted to enter the date to which the Open item book should be calculated. Netto and Netto C columns have been added, which the user can sort into columns.
Open item to date - comparison
When starting the Open item to date - comparison, the user is prompted to enter Values as of date and Comparison as of date, and then the data will be calculated according to the entered dates.
Copy reference number option in the Create repeated documents function
The option Copy reference number symbol has been added to the function Creating repeated documents in advances and other receivables/commitments. If the option is active, the reference number is copied from the document on which the ruler is set.
Offset of invoices in the container
We have added a new option Only invoices in the container to the offset configuration. If this option is set, only documents that are in the received and issued invoices container are included in the offset.
Exchange rate on paid advance
The function Change rate on paid advance has been added to the received and provided advance module. To use the function, you need to have the Purchase and Sell/General/Rate Change right set on the paid advance. After changing the exchange rate on the advance, the payments on the bank statement (cash receipt, internal receipt) will be updated and the receipt must be rebilled.
Management reports
Dashboards - Copy including elements
There is new possibility how to create a dashboard - the function Copy including elements. This creates a new dashboard by copying the current one and at the same time it copies also the dashboard elements.
Accounting
Editing fields on purchase/sale items when subordinate documents are confirmed
Editing of certain fields on purchase/sales items is forbidden if subordinate documents are confirmed. Editing fields is now not allowed:
- Posting key I , Account number and Matching symbol if a confirmed invoice is issued/received
- Posting key of the warehouse document, if the delivery/receipt note is confirmed
- Posting key R, if the reservation sheet is confirmed
New functions in economic analyses
In the Rows of Economic Analysis, we have added the Book of Accounting to the Conditions for Analytical Axis. In this way, data from different accounting books can be loaded into different rows or columns of the analysis.
We have created a bulk action Populate the list of rows. The action will allow you to insert the sum or difference of other analysis columns into the List of rows section on economic analysis rows in bulk.
Control report - cancellation of the item Data box identifier
Due to the information of the Financial Administration regarding the forms for value added tax for the year 2024, we have canceled the filling of the item Identifier of the data box (Id_Dats) in the xml file of the control report.
Assets
Assets - for the "Contract Validity until" field, the validity history has been added
The "Validity of the contract until" field, which is on the Basic data of asset card under the Additional data button, has been supplemented with an "alarm clock". When you press the alarm clock icon, the validity history of the field value is displayed.
Deletion of the last annual asset depreciation
The last Annual Depreciation can be deleted on the asset card, if no other items are created on the card for the given year (e.g. monthly depreciation) and the previous year's depreciation is processed.
Payroll
Attendance - working time model setting- adjustments
In the working time model settings, the settings for early arrival and late departure have been split. Until now it was only possible to set them together, now separate settings are possible for both situations.
Electronic filing - modifications
The [i]Default settings[/i] tab of books for [i]Electronic submission[/i] has been made the following changes regarding communication with the CSSS:
- personal certificate field has been renamed to [i][b]Signing Certificate (Qualified)[/b][/i]
- a new field was added [i][b]Encryption certificate (Commercial)[/b][/i] - this is a commercial certificate that will be used to encrypt the response data of the CSSS. If the [i]Signature certificate (Qualified)[/i] is also encryption, then there is no need to fill in the encryption certificate and a qualified certificate is used for data encryption.
- the Personal certificate download from contact person check box was renamed to [i][b]Signature and encryption certificate download from contact person[/b][/i] and at the same time an encryption certificate (qualified) was also added to the settings on the contact person.
[u]If you have electronic filing books set up and communicate with the CSSA using electronic filings, then there is no need to change anything in the book settings after reinstallation.[/u]
Editing selected reports - employee name
The parameter SuppressName - Hide the employee's name was added to the Wage expenses (MZD_NAKLS), Overview of paid wages (MZD_PREHL) and Payslip (MZD_VYPL.AM) reports. Defaults to NO. When the value is set to YES, the employee's name is not printed on the reports.
Interval type - Priority
A new "Priority" field has been added to the Interval Type dial.
Until now, it was not possible to process a worksheet if an overlay of planned absences was entered. The system warned of an error.
Now, if this happens and absences with different priorities overlap, then the higher priority absence will be used in processing. When two absences with the same priority overlap, the behavior remains the same, the worksheet cannot be processed.
The priority is set by initialization when switching to modified versions, after which it can be modified by the user.
1 = highest priority - the lower the number, the higher the priority.
Web and e-shop
Email Order confirmation with QR code for payment
When creating an order from the e-shop, it is possible to send the customer an order confirmation email including a QR code for payment.
A new icon for generating a QR code has been added to the email body (for a template in K2 format - WYSIWYG).
Payment data is taken according to this logic:
if the method of payment is an advance payment - take over from the advance payment,
if not and there is already an invoice for the order - take over from the invoice,
if not - take VS directly from the order.
Rounding of the stock quantity on the e-shop
In the e-shop, the method of rounding the actual disposition in the warehouse has been changed.
The stock quantity is now rounded down to the whole unit. Previously, the quantity in stock was rounded mathematically.
The display of the number of decimal places for the stock quantity depends on the Web and e-shop settings / Shopping basket - field Number of des. Place the quantity in the shopping cart:
number of decimal places in the basket = 0, then 12.5 => 12
number of decimal places in the basket > 0, then 12.5 => 12.5 Rounding of the stock quantity in the e-shop
Minimum weight for transport method
It is also possible to define the Minimum weight for the given transporter in the Transport method codelist.
If article do not reach the minimum weight specified in transport method codelist in the order, then this carrier will not be offered in the selection of the transport method.
Allowed method of payment / transport - invalidation of record
We have added the option to invalidate a record to the Allowed payment methods and Allowed transport methods lists on the Supplier/Customer tab.
If the record is blocked and at the same time set on the customer, then this restriction is not taken into account and all available payment/shipping methods are displayed.
Display of free documents on the e-shop
The filter conditions for displaying documents/items have been modified on the e-shop.
If we check the options "Display documents by customer" and "Display documents created outside the e-shop" in the Settings of the website and e-shop / Documents section, then free invoices, delivery notes and their items will also be displayed in the account of the logged-in user (with a set partner) .
In the account of the logged-in user (without a partner), only documents related to the order on which he is listed as a contact person will still be displayed.
Administrator
Task scheduler - Export customizations to file
The Export customizations to file function can be used in the Task scheduler using newly created shortcut for this function.
Management reports - new rights
In the Management reports module, we have created new rights for Management reports - definitions:
Viewing the definition of management statements
Editing of the definition of management reports
New type of alert - license expiration
We have created a new type of alert that will warn about the upcoming license expiration (ID 2000000010).
If there are less than 10 days left until the license expires, an alert will be triggered containing information about how many days are left until it expires. The check of this type of alert cannot be started manually from the Alerts book, but only via the scheduled Diagnostics task.
User parameters - Copy links
Added Copy Links option to User Parameters. If it is set, then when creating a copy of the document, a copy of the links will also be automatically created. If it is disabled, links are not copied when creating a copy of the document.
The parameter defaults to the value of the Copy Items parameter.
Web K2
Own desktop with buttons
We added support for creating a custom desktop with book (module) buttons for web K2. Detailed instructions for preparation are given in the documentation, in the section Web K2, chapter Preparing your own desktop with buttons for books.
Add to favourites
From version K2 alba.03, it is possible to add modules/nodes from the tree menu and the default desktop to your favorites in web K2.
It is also possible to add to the favorites with the right mouse button: a book, a script, a report, a function,...
And you can also use the option to copy and paste from the clipboard.
Keyboard help in K2 web
In web K2, from version K2 alba.03, it is possible to view keyboard help using the Ctrl + F1 shortcut, or the Keyboard Help function in the ribbon.
News in K2 alba.02
Universal Forms
Record Change History function
From version album.02, the History of record changes function is available, which clearly displays all changes made to a given record in a table or graph (only for fields with history).
If the "Record change, new and confirmation actions in the changes" option is checked in the client's parameters, records of changes to the document as such will also be loaded.
The function is included in the System / Others ribbon and is available on all modules that have a field on which history is monitored.
Basic Code Lists and Supporting Modules K2
Bulk action VAT rate change on Article tab - added Legislation
We have added the Legislation field to the VAT rate change bulk action form above the Article tabs. It is now possible to collectively enter a VAT Rate valid from a certain date even for legislation other than the current multi company legislation.
Sale/Purchase
Editing simple code lists
A new right Code lists/General/Edit simple dials has been added. The right allows the user to edit code lists:
- shipping method,
- terms of delivery,
- order form,
- type in personal data.
New parameter Copy values of analysis axes when copying an item in purchase and sales documents
The parameter When copying an item, transfer values from the analytical axes of the copied item has been added to the Sales books and Purchase books settings. If it is checked, when copying an item in the document, the values of the analytical axes will be copied according to the copied item. If unchecked (the default), then the current item copy behavior will be preserved.
Definition of price groups
Adjustments were made to the Definition of price groups function (Customer/Supplier book, Sales tab), when the option to define the validity from-to was added to individual records. Now you can define two records with the same price group and different discount for different periods, or you can set different price groups for customers for different periods.
The decisive period for selecting records from the Definition of price groups is the setting of the Prices by date field in the Price List Settings.
Change of bank account number on confirmed invoices
A new function Change bank account number has been created above invoices received and issued. The function is located in the ribbon in the Functions tab in the Others section. The function will make it possible to change the bank account of the given customer/supplier on confirmed invoices even in blocked periods. It is intended especially for the case when the confirmed credit note needs to be supplemented with the bank connection to which the credit note is to be reimbursed and the document may already be in the closed period.
Purchase and sale/General/Change bank account right on the confirmed invoice is required to use the function.
Check for duplication of the External number on invoices received and advances provided
If, when saving the document of the received invoice or advance payment, the External number field contains a value that is already in these documents for the given supplier, then the program will alert you to this duplication, similar to the way it already does with the Reference number field.
Automatic advance withdrawal for contract/order issued
A new option, Automatically withdraw advance for contract/order, has been added to the sales and purchase books. If the option is active, when a new invoice is saved, advance for contract/order issued will be automatically charged.
Bulk items inserting (Shift + F6)
From version K2 alba.02, the behavior is modified if items are inserted into the document with the function [i]Bulk insertion of items[/i] (Shift + F6). If there is an item on the document and other items are inserted using this function, information from the first item is no longer copied. This unifies the behavior as is the case when an item is inserted with the [i]Ins[/i] key.
Logistics
Handling of requirements - by batches
The functions Handling of requirements - Create purchase orders / transfer notes / internal sales orders support ordering according to requirements for particular batches.
Worker performance
We have created a new function for monitoring and evaluating the activity of warehouse workers during their shift. This function is based on the entries in the Mobile Terminal Statistics book and, when started, displays a graph (gantt) that compares the activity of warehouse workers within a shift. The form also contains 3 additional sub-graphs for evaluating warehouse performance in terms of time or number of events.
Contracts
Contracts - total amounts
On the header of the contract - sale and contract - purchase, we have changed the fields with the Net and Gross amounts - the fields cannot now be edited and are calculated as the sum of the contract items.
We have added the total amount of VAT to the contract header.
Creation of documents from the contract - contract
If Create document = "Contract" ("Order") was entered on the contract, when creating documents from the contract, a contract (issued order) with a subordinate invoice was always created until now. Only a new contract (issued order) without a subordinate document will be created.
For creating documents from the contract, we have added new options "Contract with invoice" and "Order with invoice" - when creating a document from the contract, a contract / order issued with a subordinate invoice is created.
When reinstalling to version K2 iris.06 or K2 album.02, the value in the Create document field changes from "Contract" to "Contract with invoice" and from "Order" to "Order from invoice" on the contract documents and in the Type of financial performance of the contract number list - this preserves the existing functionality when creating documents from the contract.
Finance
Offset - marking Default configuration
From versions K2 iris.06 and K2 alba.02, there has been a change when starting offset from the button [i]Offset[/i] from the ribbon above Cust./Suppl.
Until now, the "Default" label was not used in the credit configuration, and the credit configuration last started by the user was launched from the Offset button.
The [i]Offset[/i] button will now start Offset configuration, which will be marked as "Default".
Offset to date
We added new functionality to the Offset function from version K2 iris.06 and K2 album.02. After starting the Offset, a form for entering the Offset date will be displayed, and then only documents with an issue date less than or equal to the Offset date will be displayed.
If the Offset date is changed in the Offset form (top left), the documents will be reloaded according to the entered date.
Until now, it was only possible to set the offset date and the documents were displayed for the current day.
Also, a new field Issued/Acquired (IssueDateCalc) was added to the columns in the Offset form, in which the date of issue of the document is displayed. Users can pull it into the offset form.
Offset - the right to Edit Offset Configuration
A new Right Offset Configuration Editing has been added. Without this right, you cannot edit, delete, add or copy a new configuration.
Offset - a check on the payment of documents was added to the editing of the offset proposal
A check to see if the document has not been paid was added to the Editing of offset proposals. If a document has been paid in full, a red exclamation point will be displayed for the customer and the document.
Management reports
OLAP - tree structure of the Officer dimension
There is the support to display the Officer dimension in the OLAP views as a tree structure. To activate the tree structure of the Officer dimension please turn off the new parameter: Referent jako lineární (single-level).
Accounting
Change in the VAT rate from 1 January 2024
The approved consolidation package 2024 also represents, among other things, changes in VAT rates from 1 January 2024. The basic VAT rate of 21% will continue to apply, but from 1 January 2024 only one reduced rate will be introduced, namely 12%.
Most of the items from the reduced rates will remain at the reduced rate, the new 12%. However, some items of article or services are also moved between reduced and basic rates. The delivery of books will be exempt from VAT from 1 January 2024 and will be reported on line 26 of the tax return.
As a result of these changes, there will also be minor adjustments to the control report form and the VAT tax return. Packages with the necessary modification will be published when the necessary documents are available on the website of the Financial Administration.
Due to legislative changes in VAT rates, the following steps need to be taken in the K2 system:
1. Creation of a new VAT rate (SS 12%) in the codebook with the relevant legislation
2. Change in the VAT rate with effect from 1 January 2024 on the relevant article cards
3. Addition of zero VAT rate and "RN" tax type on article cards - books
4. In the Client Parameters, it is advisable to turn on the Update VAT rate according to the Article tab parameter
5. Adding a new VAT rate to the Settings for the VAT return form in the VAT Book
6. Adding a new VAT rate to the VAT accounting settings
7. Setting the new VAT rate in other code books (Travel Order Cards, Cash Receipt Cards, ...)
8. Change in the VAT rate on contract items
9. Change of the VAT rate in the sales price lists
10. Change of VAT rate in EDI
Invoices with an ac. transac. date from 1 January 2024, on which advances with the old VAT rate were deducted, must be corrected.
A more detailed procedure is given in the attachement.
OSS parameters - Sales books and Tax types can be entered by selecting from the code list
In Multi Company Management, on the OSS Parameters tab, where Sales Books and Tax Types for OSS (One Stop Shop) mode are entered, it is now possible to enter these data by selecting from the given code lists.
Road tax return - rounding when calculating the tax
According to the new [url=https://www.financnisprava.cz/assets/tiskopisy/5408_31.pdf?202401041550]Instructions[/url] for filling out the road tax return for the year 2023, the values of column 21 (Road tax in CZK without application of exemptions and discounts), 24 (Exemption), 25 (Tax discount) and 26 (Partial vehicle tax) are rounded to two decimal places.
In this context, we have made the necessary adjustments to the xml file.
The modification package for versions K2 ori.09, K2 iris.05 and K2 alba.01 is available in Partial Updates (Admin - System - K2 Partial Updates).
New VAT return form from 1 January 2024
On the website [url=https://www.financnisprava.cz/cs/dane/danove-tiskopisy]Finanční zpravá[/url] a new form, model 24, for [i]Value added tax return[/i is published ].
This new sample form will be used for the period from January 2024.
Packages with modified [i]VAT Declaration Form [/i]for versions K2 ori.09, K2 iris.05 and K2 alba.01 are available in [i]Partial Updates[/i] (Admin - System - Partial Updates K2).
Editing the default reduced VAT rate in a column in the List of tax documents report
Due to the change of the reduced VAT rate to 12%, the default value of the reduced rate in the column of the List of tax documents report ( VATD_SEZ01.AM ) for VAT Documents was adjusted from 1.1.2024.
Control report - new parameter for saving xml in the document attachment
We have added the DocumentTypeAbbr - Document type parameter to the Control report - calculation (VATD_KHCZ.PAS) function. The document type abbreviation can be entered in the parameter to save the xml in the attachment of the Inspection report document. By default, the parameter is empty - the xml is not saved in the attachment of the Inspection Report document.
New tab "Accounting items of attached internal documents" in posting
For the initial documents that are charged, we have added another tab to the Accounting tab in the accounting table - Accounting items of attached internal documents.
The posting of the attached internal document is displayed on this tab. Above the table of this tab, it is possible to use the icons to switch to the Initial or Accounting document of the given internal document.
Accounting document - multiple foreign currencies
Items in different foreign currencies can now be booked on one accounting document (until now, only one foreign currency could be on an accounting document).
If several foreign currencies appear on one accounting document, the fields Foreign currency and Amount in foreign currency will not be filled in the header of the accounting document.
Creation of adjustment items for other receivables
We have added the possibility to create correction items for other receivables in the Adjustment items for receivables function.
If we want to use this functionality, in Multi company Management, in the Adjustment items for receivables setting, we check the box Create adjustment items also for other receivables. If correction items are to be created only for documents from certain books, we enter these books in the Other receivables books table.
Other receivables are loaded together with the invoices issued into the Adjustments to receivables form.
Creation and cancellation of adjustment items can also be done using bulk actions on other receivables.
Assets
Consolidation package - asset depreciation
1. The possibility to apply extraordinary property depreciation was extended, but only for road motor vehicles that are also emission-free vehicles and are purchased from 1.1.2024 to 31.12.2028.
2. The application of tax write-offs for M1 category vehicles (a vehicle with a maximum of eight seats in addition to the driver's seat) was limited to a maximum of CZK 2,000,000, regardless of the actual entry price.
Reports Statement of assets – parameter for displaying the account balance from the General Ledger
New parameters have been added to the Asset Statement (AssetStatement.AM) and Asset Statement - basic (BasicAssetStatement.AM) reports, which will enable the accounting balance on a given asset/depreciation/amortization account to be displayed on a given date. These are the parameters:
AccBooks – Semi-separated accounting books.
CurrentMulticompanyAccountingBook – Accounting book according to the current multi company.
ShowGenLedgerBalance – Show account balance from General Ledger.
If the report is then run with the parameter GroupBy = 106 (grouping by account), the account balance in the General Ledger is displayed in the report and the Difference is calculated.
Changes to real estate tax from January 2024
Based on the changes in the area of real estate tax from 1 January 2024, resulting from the approved consolidation package, we have made the necessary changes in the K2 system.
More information on legislative changes can be found on the website of the Financial Administration.
In the K2 system, we made adjustments for property cards on the Property Tax tab:
New entries "Q" and "W" have been added to the Land Type codebook, entry "D" has been invalidated and the description for "G" has been modified.
Added new fields "Plot Type" and "Inflation Coefficient".
Furthermore, the script Real estate tax - export (ZAR_DNEM.PAS) was modified for the export of returns and the calculation of real estate tax.
?
Payroll
Attendance - scripts
The Employee Portal (PERS_EmployedPersonPortal.PAS), Person Attendance Terminal (ATTT_PersonalTerminal.PAS) and Attendance Terminal (ATTT_Terminal.PAS) scripts, if they have the TerminalAbbr parameter specified, now require the user to have right #2029 - Attendance Terminals - View to run the scripts .
Attendance - worksheets
Adjustments have been made regarding worksheets:
A sub-tab Additional data per worksheet has been added to the Account Totals tab on the worksheet, where Entitlement to food stamps is now displayed
A checkbox has been added to the attendance books Check confirmation of work sheets when exporting to payroll documents - if checked, only payroll files from confirmed work sheets can be exported
Worksheet Day form has been reworked - data on passes, intervals, work accounts, comments and attachments have been placed on separate tabs and an Additional Data tab has been added with information about who changed the given day
Added All Days Confirmed check box to the Record Preview to indicate that the days on the worksheet have been confirmed
Icons for confirming and disconfirming the day of the worksheet have been added to the Worksheet Days tab
Web and e-shop
Language versions for links (images, videos, files, etc.)
Added support for language definition for links (images, videos, files, etc.).
If there is a link for that language (e.g. English), this link will be displayed (e.g. image for banners). If there is no link for that language, the link for the default language will be displayed.
Administrator
List od scripts and reports
The newly created report F9FormationInfo.AM will display the listed scripts and reports above each module.
Administration of application servers
Starting with version album.02, a new book called Application Server Management was created. The book is included in the tree menu Administrator - System - Administration of application servers.
The book provides information about all running application servers, and part of the functionality over logged-in users, which was previously in License Management, is transfered to it.
News in K2 alba.01
Basic Code Lists and Supporting Modules K2
Division of fields for setting floating maturity separately for purchase and sale
On the Suppl/cust tab in the purchase and sale tabs, the fields for setting the floating maturity have been divided:
• Month shift,
• Number of days since the beginning of the month.
It is now possible to define a variable maturity in the Payment Terms section, one for purchase and another for sale.
Marketing
Create Activities script
As of version 2024.01, the original scripts that created activities for the parenthetical records in the listed books have been deprecated. These are scripts PartCreateActivity.PAS (Partners), Kont_akt.pas (Person Kont.) and also Act_FromDoc.PAS (purchase and sales documents in general). These scripts have been replaced by the new CreateActivity.pas script.
Communication
Canceling the Internal mail client and the "Setting up mail accounts" function
As of K2 album.01, [b]Internal Mail Client[/b] has been cancelled to work in K2, leaving only [b]External Mail Client [/b]to set up mail accounts for the script.
In the tree menu, instead of the original function [i]Mail[/i], the function [i]Mail account settings[/i] is included.
Sale/Purchase
Cancellation of EDI scripts (EDI.pas and EDI_Purchase.pas) - K2 alba.01
As of version K2 alba.01, the scripts for the original EDI were deprecated from the standard. These are EDI.pas and EDI_Purchase.pas scripts.
News in the Pricelists module (K2 alba.01)
1) From version 2024, the old pricing will be cancelled, including user right 312 (Browsing the 5th page – Sales prices).
2) In current Pricelists the option to define External lots has been added to the "Other items of the price list" section. The price then applies only if the value of this external lot is entered in the sales item.
Patterns (cancellation)
Starting with the K2 album version (2024), support for creating records using Patterns (keyboard shortcut Shift + F6) is ended.
News in EDI
An option to define default sales and purchase ledgers for importing EDI messages has been added to the EDI tab on the Customers and suppliers tab. If the field is filled, then the value from this field will take precedence over the value of the parameters of the same name from the EDI configuration.
In the EDI Message Queue book, an option was added to attach an xml file with a message for a given record in the book. The automatic connection occurs after the successful processing of the record in the EDI Message Queue book. The prerequisite for automatic connection of xml files is to have the Connect EDI message parameter set in the EDI configuration in multicompany and to have the type defined in the Document configuration code list in the next parameter Document type for EDI messages (see documentation description).
Cancellation of article ordering scripts
The following scripts for ordering article have been moved to the Archive:
Creating orders for article in demand (GoodsOrder.pas)
Creation of orders for article in demand - Order (GoodsOrder_Order.pas)
Creation of orders for article in demand - plan (GoodsOrder_Plan.pas)
Create orders for article in demand (GoodsOrder_Script.pas)
For ordering article - creation of orders, transfers, internal production orders - the action of the Realization of requirements module is used. Detailed description of individual parts: creation of orders, creation of transfers, creation of internal production orders.
Logistics
Warehouse locations - new right, enhancement in bulk creation
For working with warehouse locations we made following enhancements:
- Format of location abbreviation: To create, to edit and to delete formats of location abbreviations is allowed only for users with the right Code lists / Locations / Edit formats of location abbreviations.
- Bulk creation of locations: In the step, in which the proposals of location abbreviations are generated, is possible to adjust the items - to delete, to edit or to add new location abbreviation.
New parameters in the Warehouse Recalculation function
Recalculation of warehouses was supplemented with two new options:
Automatic creation of a queue of article for recalculation - after turning on this option, the recalculation will automatically select article that need to be recalculated. These are article that have moved in the given period or that are in stock.
Do not recalculate stock records - if this option is checked, the recalculation of stock records is not corrected. There is no deletion and filling of stock tables.
Barcodes
We have included a new Barcode module in IS K2. This module is a list of all barcodes created across all of K2. At the same time, it is also possible to set a definition for barcodes in which the formatter can be used. Based on this definition, barcodes are then created.
The ability to enter a barcode has also been added to all WMS modules.
Script Start the mobile terminals function
We have created a new Run MTModule function script (RunMTModule.PAS). Based on the specified RID, this script can start a specific function of mobile terminals. This option can also be used within the web K2.
Contracts
Contracts - Links added
We have added Links to the documents Contract - sale, Contract - purchase and Contract - others on the Attachments tab.
Finance
Cancellation of the Internal Bank module
Since the K2 version of the album, support for the Internal Bank modules has been cancelled.
Penalty in the K2 alba version
The original penalty tool (FAV_PEN0M.PAS), which was used to calculate late payment interest for late payment of invoices, has been replaced by a new Penalty function (InvoicePenalty.PAS). The function is triggered on invoices issued and other receivables. In the function, it is possible to filter the documents that we want to penalize according to the specified criteria. The function creates penalty invoices for the selected documents with the calculation of interest for late payment. You can find a description of the function in the attached file.
Management reports
OLAP - Costs and incomes: dimensions Code3 - Code6
The Costs and incomes cube supports creation of dimensions for Code3, Code4, Code5 and Code6.
Accounting
Cancellation of the report Economic analysis - shortened
The report Economic analysis - shortened (UCT_EKAZ.AM), which displayed only non-zero rows of the current economic analysis, was canceled. Instead of this report, the report Economic Analysis - 4 Columns (UCT_EKAN4S.AM) is available, to which the parameter Show_Null_lines = No can be added.
A new book with a list of control reports
In the Control report - calculation script, after pressing the List of control reports button, a book containing all calculated control reports will be displayed.
The book with the list of Control reports can now also be added to favorites on the desktop.
To view the List of Control Reports, you must have the new right - Control Reports - Viewing (2250).
New law - Control report - Viewing
To display the List of control reports, you must have the right - Control reports - Viewing (2250).
Splitting Account Name into multi company
In the Chart of Accounts, divided into multi companies, different Account Names for individual multi companies can be entered on one account.
Automatic posting of documents function
We have created a new function Automatic posting of documents, which posts selected types of documents for the specified period. The function can be included in the Task Scheduler and run automatically.
Road tax - new button on the vehicle card for tax exemptions and discounts
A new Exemptions and discounts button has been added to the Vehicles tab for the purposes of calculations for the Road Tax Return. Under the button, the Tax Exemption § 3 fields are available - by choosing from the number list, the necessary letter of the paragraph is selected and the Tax Discount Percentage field - the number of percentages is entered.
When moving from a lower version, these fields are filled according to the type of notes for exemption and discount indicated in the lower version.
Intrastat
Script for transferring customs tariffs to other legislations as well
From version K2 iris.04, a script was added to the standard to facilitate the filling of the Customs Tariff field for other legislations on the goods cards. The Customs tariff field is divided into legislations, because each country can have its own legislation regarding the division of goods into customs tariffs, but in practice it is common that the customs tariffs are the same with exceptions.
Therefore, if the article cards have the Customs Tariff field filled and additional legislations are added to the goods card, then this script, after running, will allow the current value of the customs tariff from the legislation, which is set to the current multicompany (own companies), to be transferred to other legislations for the cards as well article. Therefore, the same customs tariff value will be filled for all legislation defined on the product cards (if the customs tariff for another legislation is already filled, then the record will be skipped). At the same time, the given record will also be created in the Customs tariff code for the given legislation, if the record is not found.
The script is executed above a product card filter that the user creates, which will not include those article cards where the customs tariff value will be different.
Assets
New Depreciation posting key field on the asset card
On the asset card, we have added a Depreciation posting key field to the Basic data tab (under the Additional data button).
When creating an asset card, the Depreciation posting key field is not filled in automatically – posting key is added to the depreciation from the Asset book settings.
If we enter the Depreciation posting key on asset card, when creating or recalculating depreciation, this posting key will be entered into the "Depreciation" and "Depreciation of partial removal" movement.
Stocktaking processing – when codes are changed, the description field is filled in for asset movements
During stocktaking processing, the description: Stocktaking processing + number of Stocktaking Document is now added to the created asset movements of the "Code change" type.
Addition of texts to asset stocktaking reports
Lines with texts were added to the Asset stocktaking (AssetStocktaking.AM, AssetStocktaking_X.AM) and Asset Stocktaking List (AssetStocktakingList.AM, AssetStocktakingList_X.AM) reports on the last page of the reports:
Asset stocktaking + Stocktaking number / Stocktaking sheet + Stocktaking sheet number, Initiation of stocktaking, End of stocktaking, Method of ascertaining the actual conditions, Signature of the person responsible for ascertaining the fact, Signature of the person responsible for carrying out the stocktaking.
Cancellation of old asset
In the K2 Alba version, the old asset is canceled. In this context, the following were removed from the tree menu and from the menu of print reports and functions:
- Books of old asset
- Node for Old asset
- Old asset scripts, reports and filters
When reinstalling on K2 Alba from a lower version, Use new assets must be checked in the Client Parameters. You can no longer convert to new assets in K2 Alba.
Payroll
Canceling scripts for Payroll, Human Resources and Payroll standard extensions
As of the K2 ALBA release, the following scripts and their related reports above the payroll module have been deprecated:
- [i]Collective employer notification[/i] (MZD_HOZ.PAS)
- [i]Notice of employment[/i] (MZD_ONZ.PAS)
- [i]Attachment to the application for benefit[/i] (MZD_NEM.PAS)
- [i]Pension insurance record sheet [/i](MZD_ELDP.PAS)
- [i]Notification by employer upon termination of incapacity for work[/i] (MZD_HZUPN.PAS)
- [i]Notification of intention to apply discount on insurance premium[/i] (PREMP_OZUSPOJ.PAS)
- [i]ISPV9[/i] (MZD_ISPV9.PAS)
All these scripts are fully replaced by new books that will be available from the tree menu after installing the standard extension for [i]Personnel and Payroll[/i].
[b]If the [i]Payroll and Human Resources[/i] module is used, the following steps must be performed after reinstalling the K2 ALBA version:[/b]
- Installation of the standard extension for [i]Personnel and Payroll[/i]
- Running an optional version initialization - [i]Initialize data for K2HR[/i] - this action will populate the newly created books with data, i.e. transfer the data from the original scripts to the standard extension tables so that all the records stored in them are also available within this new functionality. This initialization must be run before new ledger entries are created.
Web and e-shop
Flag "Paid" x "Unpaid" - change in logic for confirmed contracts
On the e-shop, in the [b]List of contracts[/b] section, the logic of the flag [b]"Paid" x "Unpaid"[/b] has changed.
For confirmed orders, only whether all invoices or advances, paid. It is no longer resolved whether there are invoices for all items.
If there is no invoice or advance for the confirmed contract, the "Unpaid" flag will be displayed.
For unconfirmed contracts, the logic remains unchanged.
Administrator
License management - obtaining AS callstacks
In [i]License management[/i], tab [i]Logged in users[/i], buttons were added above the record for AS for the possibility to remotely [b]obtain the callstack [/b]of the application server, or [b]a series of callstacks [/b]of the application server.
The result of the operation will be stored in the user directory of the user who started the action.
New K2.ini parameters - switching surfaces
New parameters have been added to K2.ini to hide the option to switch surfaces and environment settings (visual styles, display size and universal forms preferences):
DISABLELAYOUTMENU=1 ... Menu [i]Settings \ Desktops [/i] is disabled - cannot switch desktops or manipulate them
DISABLEUIMENU=1 ... Menu [i]Settings \ Environment Settings[/i] is disabled - cannot switch visual styles, display size and preferences of universal forms
DISABLEVCXMENU=1 ... Menu [i]Settings \ Environment Settings \ Visual Styles[/i] is disabled - cannot switch visual styles
Administration of Scheduled Tasks - adding checks to the "Administration of Scheduled Tasks" right
Starting with versions ori.09, iris.05 and alba.01, we modified the options for working with [b]scheduled tasks[/b]. For the [i]Administration of Scheduled Tasks[/i] right, we have added controls for other actions.
A user without this right cannot now:
- run scheduled tasks
- delete records from history
- terminate running tasks
- create and edit scheduled tasks.
Administration of Scheduled Tasks - Setting of scheduled background actions
In the Task Scheduler, there is a new option to enable [u]separate threads that will quickly process one-off immediate tasks[/u].
In [i]Administration of Scheduled Tasks[/i], we can turn this feature on using the [b][i]"Setting Scheduled Tasks in Background" button[/i][/b]. We will set the maximum number of threads to be created, the user under which jobs will be processed and the number of days after which jobs will be automatically deleted.
In basic scheduler mode, threads for processing one-time immediate jobs are processed only on the default server.
In Balancer mode, threads for processing one-time immediate jobs are processed on all K2_AS with a scheduler.
Scheduled Tasks administration - New occurrence of "Once with multiple attempts on error"
We have added a new occurrence type [b]"Once with multiple attempts on error"[/b] to the [i]Scheduled Tasks[/i] settings.
After selecting this occurrence, 2 new parameters will be displayed:
- How many times to try to run the task again
- Delay between individual attempts
If the task does not end with the status "OK", "OK with a warning" or "OK with an error", the system will try to start the task again after a set delay, and this will do so a maximum of as many times as specified in the parameter "How many times to try to start the task again".
Elasticsearch search
In IS K2, you can use the Elasticsearch tool, which is used for fast and efficient searches within the e-shop and IS K2.
Web K2
Marking records in web K2
In web K2, records can now be marked with the mouse using the keyboard shortcut:
Ctrl + mouse click, or
Shift + mouse click.
Selection of calendar color in web K2
In web K2, it is possible to define your own color for individual calendars.
New style of web K2
In the new Web style in web K2, the user can customize the appearance according to his preferences (color, transparency,...).