Recalculation

The Recalculations menu is intended for service interventions in  the event of a data breach in any  way and it is necessary to recalculate the cash balances,  account turnovers and stocks. With a larger volume of data, it is assumed to run overnight, resp. over the weekend.

Picture: Open menu module Administrator - Recalculations

When recalculating warehouses, it is important to pay attention to the exclusion of the possibility of negative stocks in the warehouse. Negative stocks in the warehouse can arise, for example, by confirming the issue before confirming the receipts, by issuing the articles without indicating the receipts cards, or by exchanging a specific product for another. To prevent this, do not check the Negative status allowed field on  the Article tab on page 2. After recalculating warehouses, the user will always be notified of such conditions. In such cases, it is necessary to analyze the problem and correct it, either by changing the date of confirmation, or finding missing receipts, correcting the articles (there may have  been confusion), etc. Here it is necessary to look at the original documents and compare with the actual stock.

Stock recalculation

The Stock recalculation function is used to check and correct stock records and stock prices. As a user, this is the only  function that internally consists of the following partial recalculations:

• Accounting recalculation - sliding price: recalculates stock prices on receipts, release notes, credited receipts and credited release notes for combinations where the Article card does not have batch records and the Warehouse card has the "sliding" stock price type set.
• Accounting recalculation - by batches: this is an accounting recalculation of additional stock records for the combination, when the Batch registration option is enabled for the Article cards and the Warehouse tab has the stock price type "by batch" set.
• Physical recalculation: recalculates stock records on the basis of documents on stock movements - receipts, release notes, transfers and job cards. The physical recalculation calculates not only the quantity, but also the accounting balances in the warehouses.
• Batch and location recalculation: this is basically a physical recalculation of the additional stock records on Article cards, where the Batch Record or Location Record or Order Code Record option is enabled.

As part of the recalculation of warehouses, the recalculation of the ordered and reserved quantity is also performed, and the stock records for the batch parameters are also recalculated.

Picture: Stock recalculation form with Other option displayed

Fields' description:

Blocked period		Period in which recalculations for the current own company are blocked.
Company		Display the name of the current own company. Stock recalculation will take place for this company if the Recalculate all companies option is not activated. During the recalculation, stocks and documents belonging to the given own company are processed, as well as stocks without the specified own company.
Period from		The period from which the recalculation will be performed. Movements before this period are not recalculated. As a rule, we set the next period after the blocking period. Blocked periods cannot overlap with recalculated ones - blocked periods cannot be recalculated.
Recalculate all companies		The option is available if there are several own companies in K2 and they all have the same currency. Then you can recalculate the data of all companies at once.
Article container		If this option is enabled, the recalculation will take place on the current article container. If the option is not enabled, it will take place on the entire code list of the Article.
Other option		Expands the form to see more recalculation options. This field is accessible only to users with the right Administrator - Recalculation - Change recalculation settings. The field settings are not remembered, the fields are set by default every time the function is started again. There is a registered point to change the default field settings according to customer requirements.
	Recalculate the stock price on document items	Ensures recalculation and correction of stock prices on documents.
	Insert the price from the  invoice into the stock price  on receipts	Ensures the insertion of the price from the confirmed invoice in into the stock price of the item.
	Recalculate the cost price on document items	Ensures the recalculation of the cost price on the documents.
	Insert the price from the Invoice into the  Cost price	Ensures the insertion of the price from the confirmed invoice in into the cost price of the item.
	Calculate the price of the product on the job cards	Calculates product prices from the prices of items on page 4 of the job cards according to the calculation formula.
	Evaluate scrap and  recycled	If there is the same product on the 4th page of the job card as in the job card header, but with a negative amount and a different batch, then it is scrap or recycled. These will be valued according to how much material or other resources were on  their production consumed (they are valued at a relative price with respect to the price of the product). The price is calculated only from the items that are listed before the scrap item!
	Recalculate all levels	In the event that the stock price of the job card item changes,   the goods from the  job card header will also be recalculated, even though this may not be intended content to recalculate. The recalculation runs from materials through semi-finished products to products.
	Recalculation of daily balances in stocks	Calculate the daily stocks of articles in warehouses both in quantity and in monetary value. Data are filled into table "DailyInventory". Note: If it is needed to initially calculate daily balances even for blocked periods, it is necessary to start the Stock Recalculation of daily balances function, which can be found in the tree menu in the Administrator / Recalculations section.
	Write changed documents to the log	The error log will contain detailed information about the performed recalculation and the  changed documents. Otherwise, the log contains only basic information about the start of the recalculation and information about the negative stocks in the warehouse.
	Write a warning to the log for more revenue per batch	Information about multiple receipts of one batch is written to the error log.
	Write article with a negative state enabled in the log	Off (default state): situations in which a negative stock status appears in article cards that have the Negative status enabled option enabled are not written to the log. (Enabling negative status in the Article data / Warehouse item and on the Batch tab is not evaluated.) The negative transition message that results from the accounting recalculation for the sliding price is always displayed. On: Negative stocks in the warehouse are written to the log even if the article card has negative stocks enabled.
	Number of period	The number of periods that will be recalculated from the set Period from. It can be used  with a large volume of data for gradual recalculation by periods. However, recalculations must always be completed up to the current period! When recalculating periods that are not the current period, only turnovers are recalculated, only in the current period is the status of stock records calculated.

Note.: If, for any reason, the recalculation function does not complete correctly, then the user is asked the next time the function is started whether he wishes to continue with the incomplete recalculation. Pressing the Yes button continues the interrupted processing, pressing the No button starts a new recalculation run.

Schedule the recalculation run to the application server

You can use the Schedule button to schedule a one-time recalculation run on the application server (via the Task Scheduler). The output of the action is a simplified protocol, which can be sent in the standard way using notifications (using the "Scheduled task" action). This log contains information about the run of the action and on the tab 2 - Output then a simplified overview of errors and also the number of the standard error log.

Recalculation of daily balances on warehouses

The function is important for daily states calculation on warehouses from entered period. It is possible to enter even period in blocked periods. The importance of recalculation is mainly for one-time calculations of daily balances even in blocked periods.

To actualize daily balances, just use the shortcut Stock recalculations with the active option calledCalculate daily stock levels.

Picture: The recalculation of daily stock levels form

Invoicing calculation

Invoicing calculation includes:

• Invoicing calculation and payments on 2 nd page of Suppl./Cust. tab,
• credits calculation on 1 st page of Suppl./Cust. tab,
• Recalculation of invoice payment.

Picture: Recalculation of invoicing and payments form

Turnover recalculation

This function is used to recalculate turnovers and  balances in the turnover balance. In the form it is necessary to enter the period from which the recalculation is to be performed.

Picture: Turnover recalculation form

Recalculation of a customs warehouse

It is used to compare expenditures and receipts in the customs warehouse.

Picture: Recalculation of a customs warehouse form

Error logs

Book of Error logs registers running and progress of various users actions (recalculations, calculations etc.) in K2 program. Each action is classified into a particular type of log. If you want to filter a required type, make active the field Type of protocol and choose the type from an offer.

Detailed information about compiled records and about development of each log is displayed by means of Display log button. Error protocol is interactive, by means of buttons from particular items you can switch to a particular record in a program (each type of protocol contains different buttons according to protocol and displayed information). You can create filters of records in some protocols (documents, articles, serial numbers). You need to take the stars into consideration if you want to create filters of documents and articles.

You can delete protocols by means of Delete protocols buttons and then by filling Data to.

Book is available for users from tree menu Administrator / Recalculations / Recalculation - Error logs.

Picture: Book Error logs

Picture: Book Error logs - items - Stock recalculation

Stock recalculation

Selected fields description:

Action	Type of realized recalculation. Types are closely described in chapter Administrator/Recalculations/Stock recalculations.
Level	Information what level of articles has been recalculated from production point of view (see recalculation parameter Recalculate all levels).
Error Number	Expression in number of error type; fits the error (action) from Description column. The column is able to use for fast sorting according to error.