Plan Type

Preset plan type for transfer notes. (Closer description in chapter Plan type).

Matching Symbol

Matching Symbol for transfer notes.

Posting key of transfer notes (TRN)

Preset posting key for counting of transfer notes.

Double confirmation of transfer notes

If the selection is activated, it is necessary to confirm transfer notes in two phases. After first confirmation there is no possibility to make any changes in document, you can change only some data on items (field On location, On handling units). After first confirmation the document is indicated by an icon . After second confirmation things goes into transfer of articles. Transfer note can be accounted only after the second confirmation.

Assign batches and locations to releases when saving

Activated - upon transfer note saving, the batch is added automatically by FIFO method into all items which at once contains the evidence of transfer notes and no transfer note is entered. K2 evaluates the order of batches for a release according to FIFO method on the basis of batch abbreviation created by the date of batch formation and by the ordinal number in terms of a date. Appointing is also for a location. Just location with the active selection Automatic release is automatically inserted respectively according to the location abbreviation.

Deactivated - the user must complete the batch and the location upon a release by himself. Nevertheless You can use adding automatically by means of Ctrl+F6 key (on the 2nd in a transfer note in Change mode)

From warehouse

Preset releasing warehouse for transfer notes.

From Zone

Preset releasing zone for transfer notes. Contents of an offer is filtered according to settled releasing warehouse.

To warehouse

Preset receipt warehouse for transfer notes.

To zone

Preset releasing zone for transfer notes. Contents of an offer is filtered according to receipt warehouse.

Post unsettled balance

It is able to book the released note where non-zero difference between total and posted amount exists.

Ignore receipt prices

Preset selection for transfer notes documents. Within warehouses with the price according to batches the preset selection can be used for internal transfer of batches because at the same time the activation of this selection switches off the control of batches receipt.

General meaning: if the selection on warehouse document is activated, the real price of incomes is ignored and the item is valued like a release (according to method - valuation of an appropriate warehouse).

Book

Mark the Books of warehouses. It is not possible to change the abbreviation of book after you save it.

Period from to

Setting of book validity from - to.

Description

Description of Books of warehouses.

Post unsettled balance - transfer notes

It is able to book the transfer note where non-zero difference between total and posted amount exists.

Post unsettled balance - job card

Enables to account the job card that has the non-null difference between the whole amount on the job card and the accounted amount.

Posting key of Transfer note

Posting key of transfer note - selection from Correspondence table.

Posting key of Job card

Posting key of job card - selection from Correspondence table.

Matching Symbol

Matching Symbol for documents of stock.

Ignore receipt price - transfer notes.

Preset the selection for documents of transfer notes. To preset the selection is useful for an internal transfer in terms of stocks with the price according to batches. As the activation of this selection deactivates the check the multiple income of batches.

General meaning: if the selection on the stock document is activated then the real price of incomes is ignored and the item is evaluated as a release (according to the method of corresponding warehouse evaluation).

Ignore receipt price - job card

Preset the selection for documents of job cards.

If the selection on the job card is activated then the receipts on stock are evaluated as a release (according to the method of corresponding warehouse evaluation).

Double confirmation of transfer notes

If the selection is activated, it is necessary to confirm transfer notes in two phases. After first confirmation there is no possibility to make any changes in document, you can change only some data on items. After first confirmation the document is indicated by an icon. . After second confirmation things goes into goods transfer The transfer note can be accounted after the second confirmation.

Type of plan

Preset plan type for documents. (Close description is in a chapter Type of plan).

Type of job cards

Selection of type of job card (normal, planning, completion, correction) for a particular book. Documents of job cards have a type preset according to a book where they have been created.

Do not register real state

Preset the selection for documents of job cards.

If the selection in job card is activated then the real amount is not registered there and the 4th page of job card is empty. Then the Routing is only on the 2nd page of job card (planned amount).

Time buffer (days)

It is for job card planning. It expresses at about how many days the job card realization should be done compared with the date set on the reserving card. It is valid for job cards schedule by method according to date from reserving card Dispatcher - Schedule of job cards tree - selection Date from reserving card).

Ctrl+T

If in a Change mode on the 1st page of warehouses you set the cursor in a numbering the documents (or specimens) to the one from the Current field, then the program automatically fills a current number of an appropriate existed document (thus the highest number).

Abbreviation

A warehouse abbreviation. The filling of this field is obligatory.

Name

Name of a warehouse.

No.

Order number of a record.

Summing, Accounting, Default accounting

Warehouse type.

• Summing: a simulated warehouse created by basic (physical) warehouses which display summary data about states and activities on those warehouses.
• Accounting: a warehouse enters into accounting. You set the method of how to value the articles on the accounting stock. If the accounting warehouse is at the same time the summing warehouse then the value is copied on all the basic warehouses.
• Default accounting: sliding price on the 2nd page of Articles will be always displayed from this warehouse, not from the accounting one according to a current selected warehouse in the field Information from a warehouse.

Firm

Setting of the firm of your own. The firm which is currently set by the User does not see any warehouses in the book of Warehouses that do not refer there.

Warehouse type

A code list for a special edit. Standard does not work with this field.

Stock price

The method of how to value the Articles on warehouses. You set it in accounting warehouse. If the accounting warehouse is at the same time the summing warehouse then the value is copied on all the basic warehouses.

K2 program supports these methods of stock evaluating:

• Sliding price: is calculated with each receipt. At the same time it ensures the correct release price in real time.
• Fixed price: guarantees the same prices of receipt and release free from "reality".
• According to batches: the fixed price according to a batch. Each batch is evaluated by the price of the first receipt.

Address

Field for entering the address (city, street, state, postcode) of the warehouse.

Cost centre

Cost center which the specified warehouse will be connected with. Upon transfer notes and job cards issuing the cost center is copied into these documents.

Account

An account from chart of accounts. In case it is entered all the movements of the articles on this stock will be booked on this account regardless of articles types. If you want to distinguish stock accounts according to Articles category then the field is not completed and the accounts for particular articles category are set in code list called Posting kind. Afterwards the account in this code list takes precedence over the account in this field. If proper Article category does not find the account in code list Posting kind, the account from this field (if the field is not completed, the error report will come up upon the document liquidation) is inserted into an accounting document.

Posting kind

Code list can define setting of how to book various article categories into various accounts from chart of accounts. In case it is entered all the Article movements of this stock will be booked according to this setting. In code list you paste abbreviation, description, posting kind, date and the account from chart of accounts. By using the date field in a code list, it is possible to limit that record. E.g. if there is a record with the kind of accounting A, the account 1, date 00/00/0000, a kind of accounting A, the account 2, the date 31/12/2009, all the stock documents with the date of confirmation earlier than 31/12/2009 will be accounted on the account number 1 a and all the documents with the date later than 31/12/2009 will be accounted on the account number 2.

Location records

If the option is activated, it is registered on the location warehouse upon an article which has the selection Register location on the card.

Contract codes records

If the option is activated, contact codes upon an article which has the selection Contract codes register activated, are registered on the warehouses.

Register of handling units

If the option is activated, a warehouse register of article cards can be extended for handling units. Handling units are placed as a part of an auxiliary warehouse register upon a warehouse movements of Articles.

Machine is just for Articles on the 1 location

Deactivated: location is added into releases according to an abbreviation automatically.

Activated: location is added into releases just in case the articles are on one location.

The date of blocking of warehouses movements

The date when all the movements on an appropriate warehouse are blocked. For instance You can use it for movements blocking in consequence of stocktaking closing over the appropriate warehouse.

Note: The date entered in this field is not related with the selection Blocking... upon this field.

Blocking...

Various movements on warehouses regardless of movements date can be blocked by activation of those selections. Blocking is controlled upon documents saving.

Load the items with non assigned planned warehouses into Reserved and Ordered

If the field is checked, in the book of Articles, in columns Ordered and Reserved, the amount for items of purchase and a sale is counted for this warehouse. They have no selected warehouse or this one in the Planned warehouse field.

Note: This field is displayed and accessible just in case there is not checked the field Independence of coverage on the informational warehouse in the client parameters.

Changed

The date and name of the user who made the last change in the Contract.

Warehouse

Required whse for evidence monitoring.

Zone

Required whse zone.

Empty

Displays locations which are fully empty (any items) on the warehouse.

Stock up

Displays locations which are stocked up items (not empty) on the warehouse.

Non-zero

Selection is displayed just in case the book Locations is activated for the specific article card. In the list, only these locations are displayed where the non-zero state of an article is recorded.

Unit

Selection is displayed just in case the book Locations is activated for the specific article card. It offers the selection of stock items of articles where the stock information are stated.

Configuration of formats for creation of location abbreviation.

Location abbreviation can be set up from the following members: area, aisle, row, bay, shelf, position. Set the required number of signs which must be from 1 to 3 signs upon each member that you need to use for the abbreviation structure. You can set a separative mark - breakpoint for each member as well.

You can add a format to the Location card. In this case upon record saving it is checked if the location abbreviation meets the given format.

Format

By button In a Change mode there is possible to set the form of abbreviation structure for locations. Closer description of the form is in chapter Logistics / Warehouses / Stock settings / Locations - Book of locations.

Location

Location abbreviation. If the format is set for location, then the abbreviation structure is controlled upon saving if it meets the selected format. If not, then the record cannot be saved.

The abbreviation can be set by pressing the button with respect to format structure .

Description

Description of a location.

No.

Location number.

Warehouse

A warehouse abbreviation where this location links.

Zone

Zone where the location is.

Handling technique

Handling technique that should be used during logistic operations on specific location.

Location type

Location type. Define a width, a height, a depth and a load rating.

Width, Height, Depth, Load rating

The data are displayed from a defined location type.

Customer

Link to the Suppliers/Customers book. You can for instance define whom customer the given location belongs to in the stock.

Automatic release

The option that defines if the location is possible to be entered automatically to the releases items. The field is activated default when creating a new location.

Blocked

Blocking or a record cancelation. A blocked record will not be displayed longer, it will not be possibly specified even in the document items.

Article abbreviation 1, 2, Article name

Identification of the article where you exactly activate the form.

Received, Available, Assigned

The topical information about the stock level of articles on location.

Warehouse, Location

Current location of handling unit in the stock. It means that all the items of articles on the handling unit are in this place of this stock.

Total available, Total Assigned

Available and assigned for all the articles on the handling unit. Information is loaded according to whse settings.

Item count

The number of various cards of articles on handling unit.

Total weight (kg)

Weight of all the articles on handling unit.

Available, Assigned

Available and assigned of given card of articles where the code list was opened for. Information is loaded according to whse settings.

Type

Type of handling units. Closer description is followed in the text.

Handl. u.

Unique identification of a handling unit (abbreviation). It is possible to make the abbreviation unit automatically in Type of Handling units. In this case, an abbreviation in a new card in format "@AUTO@" will be generated after you choose the type and then upon saving it is written according to setting in a unit type again.

Description

Description of handling units.

Warehouse, Location

Location of a handling unit in the stock. It means that all the items of articles are in this place in the whse. These fields are just for reading.

Length, Width, Height, Weight, Max load, Stacking weight

Values are valid for handling units. They are just displayed in handling units, attributes of an unit are defined in a Type of Handling units.

Length, Width, Height, Unit

Size defining of handling units in a chosen length unit.

Weight (kg)

Weight of handling units in kilos.

Max load (kg)

Loading capacity of handling units in kilos.

Stacking weight (kg)

Maximum of stacking weight in kilos. It defines (e.g. in containers) how many kilos the container can carry, it means how many another fully-loaded containers it has.

Prefix, Number from, Number to

It is able to define the structure of generated abbreviation of handling units. Unit abbreviation is created as a Prefix + Ordinal number in terms from - to.

Current number

It displays current used number when the abbreviation of handling units is generated. In case of need the number is able to be changed by the user.

Warehouse

Current Warehouse from which all the information are taken. It is called as "information stock" too. Data about states of the goods, which you can see on the screen, are from a current Warehouse. Abbreviation of a current warehouse is displayed in the upper blue bar on the screen too.

You can change a current Warehouse in this field or by pressing Alt+F10 keys. The Set period and stock form will be displayed by this way where you can set a Period and a current Warehouse in the Warehouse field.

Physical stock

A stock that is implicitly entered to stock documents, if they are bounded with a superior document (a sales order, a purchase order). On this stock, there occurs to real movements of goods. A physical stock is shown in the lower status bar. It is automatically changed pursuant to information stock. Also it is possible to change it independently on information stock by a click by the mouse right button in the status bar over its current value.

Current period

Interval of displaying of a stock records. The Set period and stock form is activated by the Alt+F10 keys on the 0th, 6th, 7th and 8th page of the Article card. Here a current period can be set in the Period from and Period to fields. In the book (on the 0 page), there the Period to field can be changed.

Plan type

In the Article book, the information about a current state of goods are displayed for a selected plan type in the Assigned, Reserved and Ordered columns according to the status that is entered on items of the purchase, sale, production or warehouse documents.

Transfer Note

Transfer note identification: Book / Period / Number

From whse

The whse that the items of transfer notes are transferred from. If the releasing whse is preset in Books of warehouses, then it is completed automatically. Filling the field From whse the appropriate cost centre will be set into the field From Cost centre.

From Cost centre

Cost centre of releasing whse. It is filled with the whse assignment automatically.

From Zone

Stock zone that the items will be transferred from. If the releasing zone is preset in the Books of warehouses, then it is completed automatically. The Offer content is filtered according to settled releasing warehouse.

To whse

The whse that the items of transfer notes are transferred to. If the releasing whse is preset in the Books of warehouses, then it is completed automatically. Filling the field Whse level the appropriate cost centre will be set into the field To Cost centre.

To Cost centre

Cost centre of incoming whse. It is filled within the whse assignment automatically.

To zone

Stock zone where the items will be transferred to. If the releasing stock is preset in the Books of warehouses, then it is completed automatically. Contents of the zone offer is filtered according to receipt stock warehouse.

Status

Status of document. The field can be completed with the figure from user-defined code list. Importance of that field is mainly for making interconnection with Workflow processes. The field has an evidence of historical changes.

Price

Total price of a Transfer note.

From Contract code

Preset Contract code for items - release page.

To Contract code

Preset Contract code for items - receipt page.

Date of issue

The date of issue of the document. The current date is set automatically here, but you can change it.

Maturity date

Date of reservation or date of requirement for transfer as well.

No. of maturity dates

Number of a customer order.

Method of transport

Link to the Method of transport code list.

Posting key

Posting key of a Transfer note. If the posting key for transfer notes is preset in the Books of warehouses, then it is replaced from that book.

Description

User description of document.

Document

Any purchase or sale document can be added to the transfer note and then the transfer note document and to recopy into the transfer note items as well. From job cards it is possible to copy just those cards of Articles, where the Types of Articles the Connection of Transfer notes and Job cards selection are activated.

Suppl./Cust.

The customer that the transfer note is created for (when you select the Sale order, then it is automatically completed from the Sale order heading).

Ignore receipt prices

If the selection is activated, then the receipts on the stock are evaluated by the method the Stock evaluation (one which is receiving), it means that the item is evaluated in the same way as in release. The activation of selection turns off the control over the multiply reception of the batch at the same time.

Type of plan

This field serves for another dividing of documents (see Plan type).

Queue

A queue where the document is placed for processing. The example is: dividing of whse-men into the specified groups. If you enter the queue into a stock document, the ordinal number for that document for entering it into process will be generated upon saving. Current order number is displayed in the Queue code list on the first page of the record.

Priority

Priority of the document for categorization into a job queue.

Whse-man

The person who works with the document. Warehouseman is chosen from the Officers book.

Date from / Date to

How long the warehouseman is making the logical task (transfer).

From vehicle, to vehicle

Analytical axis the Vehicle.

From Code1, To Code 1

Analytical axis Code 1.

From Code2, To Code 2

Analytical axis Code 2.

From the officer / To the officer

Analytical axis the Officer.

1st confirm., 2nd confirm.

Date, time and the name of K2 user who has created the record.

Issued by

The name of the user who has issued the document.

Changed

The date and name of the user who has made the last change of the Contract.

Transfer from the stock.

Reservation of a transfer.

EAN

EAN code.

Article

Selection of goods from the book Articles.

Reserved

Setting of reservation indication.

Released

Setting of release indication.

Variant

Selection of a variant of product routing.

Name

An additional name of article.

From Contract code

The contract code that the goods will be transferred from. A Contract code from the 1st page of the Transfer note from the field From Contract Code is placed into the field by default.

To Contract Code

A new contract code that that goods is transferred on.

Batch

Batch of transferred goods.

From location

Location that the goods will be transferred from.

To location

New location that that goods is transferred to.

There are some rules for an automatic suggestion of a suitable location described in chapter Basic data of the Articles, field Location - Auto. A new proposal of location can be done by a button after the change of amount in the Transfer note item .

Note: In case of two confirmation of Transfer notes the filling of this field is not checked after the first one. Then before the second confirmation the location can be fulfilled by means of Change items in bulk button.

Note 2: Pay attention to a different function upon the record selection from the help offer (button "?"). When you select the record then the combination of stock helping evidence will not be set into the item but just location.

From handl. u.

Handling unit where the Articles will be transferred from.

To handl. u.

Handling unit where the Articles will be transferred to.

Note: In case of two confirmation of Transfer notes you can set the handling unit just before the second confirmation by means of Bulk change of items button.

Note 2: Pay attention to a different function upon the record selection from the help offer (button "?"). When you select the record then the combination of stock helping evidence will not be set into the item but just handling unit.

From Code1, To Code 1

Analytical axis Code 1.

From Code2, To Code 2

Analytical axis Code 2

From Cost centre / To Cost centre

Analytical axis Cost centre.

Unit

Stock unit of Articles.

Quantity

Transferred amount.

Required par.

Required batch parameters.

Posting key

Posting key of a Transfer note item. If you do not set a Posting key then after the document confirmation the preset Posting key will be set from 1st page of the Transfer note.

Original code

Article Code. It is set from the 1st page of an Article card. There is just displayed in this field.

Article Code

A new Article Code of transferred Articles.

Price from whse

A price the Article is sold for. A planned stock price is set after the item inserting. After a transfer note confirmation, the price is set according to method of a stock evaluating.

Price to whse

A price of the Article is received. A planned price is set after the inserting of an item, after confirmation it equals the release price. In case of Ignore the income price selection the reception is valued according to method called whse evaluation where the items are received.

From vehicle, to vehicle

Analytical axis the Vehicle.

From the officer / To the officer

Analytical axis the Officer.

Plan Type

Selection from a Plan Type code list (see the description of the 1st page of transfer note).

Supplier

Supplier selection.

Paid in total

The total amount which has been already settled.

Paid by archive

The amount settled by the documents which have been already moved to an archive.

Remaining amount

The amount that is to be settled.

Maturity date

The maturity date of a document.

Number of maturity days

Number of maturity days.

Last payment

The date of the last payment.

No. of delayed days

The payment delay in days.

F7

Booking of the transfer note. It is activated over the filter on. Account assignment and posting functions are described in a chapter called Accounting / Account assignment and posting in a detail.

F4

Function of the release test. It evaluates the possibility of release of all the items with "v" sign. If some items could not be released, the sign of reservation with "r" sign replaced them. The function is activated on the 2nd page in Change mode.

At+F2

The document confirmation. If there is an item without "v" sign on the document, you cannot confirm it.

At+F5

All V+. Bulk assignment of releasing "v" sign into all the items. In case the sign of release is not able to assign because of not enough availability, the reservation "r" sign will be set there. The function is activated on the 2nd page in Change mode.

At+F5

Change mode of the stock price - on the 2nd page of confirmed document.

At+F5

Release from a Handling unit. The function serves for inserting of all the items from a chosen handling unit into a document (2nd page in the Change mode).

At+F7

All R+. Bulk assignment of reservation "r" sign into all the items. The function is activated on the 2nd page in Change mode.

Ctrl+Enter

If Suppl./Cust. field is fulfilled then the book of Suppl./Cust. will be opened on the 1st page in Browse mode.

On the 2 nd page in Browse mode and Change mode as well you can open the Book of Articles and set the cursor on the item where the cursor is set on items of transfer note.

Ctrl+F5

All V-. Bulk assignment of releasing "v" sign into all the items. The function is activated on the 2nd page in Change mode.

Ctrl+F6

Filling batches and locations into items of releases (2nd page in Change mode). The function is same as function of programme in activated parameter of user When saving enter batch and location.

Ctrl+F7

All R+. Bulk assignment of reservation "r" sign into all the items. The function is activated on the 2nd page in Change mode.

Ctrl+F6

Separation of a stock document. It creates a new Transfer note and then it transfers all the items without a "v" sign (from a topical Transfer note) into a recently created Transfer note.

Ctrl+F7

Account assignment and posting of a Transfer note. It is activated over the filter on.

Shift+F4

It adds Transfer notes into the filter of Articles. The function is launching on all of the pages in Browse mode.

Shift+F4

The function of a releasing test for one item. It evaluates the possibility of releasing of a topical marked with "v" sign. If the item is not able to release, the releasing sign is replaced by "r" sign of reservation. The function is activated on the 2nd page in Change mode.

Shift+F5

Coverage of demanded article - on the 2 nd page of Change mode and Browse mode. The closer description is in chapter Basic Code Lists and Supporting Modules K2 - Articles - Coverage of demanded articles.

At+F2

Confirmation of a stock document. If there is an item without "v" sign on the document, you cannot confirm it.

Alt+Shift+F2

Confirmation of stock document with negative level control off.

In case there is an Article card with the evidence of serial numbers on a document, then the serial numbers are not taken into consideration (i.e. state of SČ on the stock is not actualised). In this kind of document, the sign where the serial numbers are incorrect is activated, i.e. the icon is not displayed in the field "CFNeshodaSN" . You cannot confirm or undo confirm by a standard way till the stock evidence of serial numbers are not actualised and the document is not correct (close description is in the chapter Consistency, part the Consistency of serial numbers).

The function implementation is always logged into changes.

The function is usually accessible just to users with the right (Administrator/Code Lists/Articles - Permission change of negative state).

Ctrl+Shift+F2

Undo confirmation of a stock document with the check of negative state.

In case there is an Article card with the evidence of serial numbers on a document, then the serial numbers are not taken into consideration (i.e. state of SČ on the stock is not actualised). In this kind of document, the sign where the serial numbers are incorrect is activated, i.e. the icon is not displayed in the field "CFNeshodaSN" . You cannot confirm or undo confirm by a standard way till the stock evidence of serial numbers are not actualised and the document is not correct (close description is in the chapter Consistency, part the Consistency of serial numbers).

The function implementation is always logged into changes.

The function is usually accessible just to users with the right (Administrator/Code Lists/Articles - Permission change of negative state).

Ctrl+Shift+F6

For a currently signed item it opens a form called Stock wizard and enables to enter a selected combination manually (sales order code + batch + location) into document items right away from lines of document items. (2nd page, in Change mode).

Ctrl+Shift+F7

In the book Transfer notes items it creates a selection from items of current document or from documents in a filter (or signed by stars). (0 and 2nd page in Browse mode).

Change posting key

The bulk change of posting key of the document headers or items. The contract code, article code or cost centre can be also changed in the document items.

The following options can be checked in the form:

Insert from Article Card

Article code entered in the Article card is inserted into transfer note items.

Article filter

The change will be executed only at those transfer note items that have been selected at the same time in the article filter.

Delete from filter

The transfer notes will be removed from filter after executed action.

For empty ones only

The data will be changed only at those transfer note items for which the appropriate field has been not pasted yet (it means that the posting key or code will be added).

Change Bits

Displays the Change Flags on Stock Documents form. After ticking the Ignore Receipt Price field, the Ignore Receipt Price field will be ticked on the 1st page of transfer notes which are selected in the filter. If the field in the form remains unticked, the tick on the Ignore Receipt Price will be removed in all documents selected in the filter.

If you want to change the ticking on confirmed document, too, tick the Also on Ticked Documents (also superior) field.

Shift+F2 / Ctrl+F2

Put the document into the queue / cancel it.

Shift+F3 / Ctrl+F3

Add a warehouseman into a document / canceling a warehouseman.

Shift+F4 / Ctrl+F4

Match the handling techniques into the document / cancel the handling techniques.

Shift+F5

Add document priority.

Shift+F6

Change cash voucher

Ctrl+Alt+F5

Change the state of a document.

Abbr.

Unique identification of stocktaking. The abbreviation is compulsory as two pieces of stocktaking cannot have the same abbreviation.

No.

Number of stocktaking, which is created automatically by IS K2.

Description

Description and marking of stocktaking.

Whse.

Whse. where stocktaking is created. It is necessary to enter a physical whse. (basic). This field is obligatory.

Stocktaking date

Date of stocktaking says which day the stocktaking will be processed.

Allow duplicate items

After an activation of this selection you can insert the same combination of various stocktaking lists on the 2nd page. In the opposite case it is impossible to save the same combination on several stocktaking lists.

Anyway, it is forbidden to set the same combination on one stocktaking list.

Confirmed by:

The date and user name who has confirmed the stocktaking. It is just displayed on this page.

Changed by:

The date and user name who made the last change of the record. It is just displayed on this page.

Check up

In this part it is said which data is necessary to be controlled within the stocktaking of the Articles. You can set more possibilities all at once. These fields are offered to be controlled:

• Location,
• Batch,
• Contract Code,
• Serial Number.

No.

Ordinal number of stocktaking lists which is created by IS K2 automatically.

Whse.

The stock abbreviation that the stocktaking is created for. It is only displayed in the form.

Stocktaking

Abbreviation of a stocktaking that the stocktaking list is connected with. This abbreviation also is displayed in the upper blue bar in the screen.

Description

The description of stocktaking list.

Check up requested articles

If the selection is activated, then it is able to choose the items from the list of required articles which are set in the lower part in the Required articles window. They are set on the 2 nd page of stocktaking list.

During the processing of stocktaking just the articles from this list are being processed.

If the selection is not activated, then the articles are chosen from the Articles book and the processing of stocktaking is made for all the cards of the Article book.

Requested articles

The list of Articles where the stocktaking should be done. It is necessary to activate the selection Control on the required articles.

Check up requested locations

If the selection is activated, then you need to control the real actuality and to choose the location just from the list of the required location which is set in the lower part in the Required location window.

Requested locations

The list of locations where the stocktaking should be done. It is necessary to activate the selection Control on the required location.

Carried out by:

The date and the name of the user who is doing the stocktaking, it means the first counting of articles.

Checked by:

The date and the name of the user who is controlling that part of stocktaking, it means the second counting of articles and so the checking of data correctness that made the previous colleague as well.

Changed by:

The date and name of the user who made the last change. It is only displayed in the form.

Process No: SKL004

Report ID: SSKL021

File: INV_SOUP_LIST02.AM

Report description: The stocktaking list with the possibility to enter the number of founded articles over its running.

Address in the tree: [Stock] [Stocktakings]

Abbr2 - No

Yes - prints Abbr 2 of the Article. No - prints Abbr 1.

According_to_name - No

Yes - sorting according to the name of the article. No - sorting according to the name of the article.

DecimalPlaces_Quantity - 3

The number of decimal numbers for value amount.

EmptyLines - 0

The number of empty lines for particular articles.

GroupByOptLocation - No

Yes - groups the articles according to the ideal location on the stock.

ShowAccLevel - No

Yes - displays register state of articles (IS K2 amount).

ShowBatch - No

Yes - displays batches with the availability on the stock.

EAN

It is a field for a supplementary bar code. After you enter a bar code, the name of article and other data from the Article card are entered automatically. The cursor is set in this field when Enter additional bar code for new items flag is checked. In the User parameters on the 2nd page - Purchase and sale and on the 1st page of a stocktaking list the field Check up requested articles is not checked. In the opposite case the cursor is set directly in the Article field.

Article

It is a field for entering the really founded item of the articles during stocktaking. The offer depends on if the Check up requested articles field is activated on the 1st page of a stocktaking list.

• The field is activated - the only requested items of an article are in the offer. The items are entered on the 1st page of stockt. list.
• The field is not activated - it is a selection of Articles items (or filter).

Whse.

It is an abbreviation of whse where stocktaking is executed. It is only displayed here.

Location

The field for entering the really founded location of the articles. The field is available when the Check up location flag is checked on the 1st page of the Stocktaking card and concurrently the Location records field is checked on the 1st page of the Article card.

Note: If the Check up requested location flag is checked, then only location is offered on the 1st page. list is offered in this form.

Batch

A really founded batch of the articles upon stocktaking. The field is available when Check up batch flag is checked on the 1st page of the Stocktaking card and concurrently the Batch records field is checked on the 1st page of the Article card.

Code

A contract code that was found within stocktaking. The field is available when Check up contract code flag is checked on the 1st page of the Stocktaking card and concurrently the Contract code records field is checked on the 1st page of the Article card.

Serial No.

A really founded serial number of an appropriate article. The field is available when Check up serial number flag is checked on the 1st page of the Stocktaking card and concurrently the Serial number records field is checked on the 1st page of the Article card.

Current time

Date and time of entering an actual item to stocktaking list. It is only displayed in this form.

Quantity 1

The field for entering a quantity founded during the first article counting. It is a number founded by a person who executed this stocktaking.

Quantity 2

Quantity discovered upon the control of stocktaking. It is a number discovered by a person who executed this stocktaking.

Stock unit

Display of a stock unit from the Article card.

Ctrl+F3

Bulk items removing of required articles - on the 1st page in Change mode.

Ctrl+F4

Bulk items removing of required articles - on the 1st page in Change mode.

Shift+F3

Items loading from filter of articles into the required articled - on the 1st page in Change mode or in a New record.

Shift+F4

Items loading from the book of Locations into the required location - on the 1st page in Change mode or on New record. By pressing Enter key, the currently signed location or all the locations signed by stars are loaded.

Shift+F4

Items loading from real items of stocktaking lists into filter in the book of Articles - 2nd page in Browse mode.

Shift+F5

Requested items loading of Articles from the 1st page of stocktaking lists on the 2nd page into the real items - on the 1st and 2nd page in Change mode or in a New record.

Stocktaking,
Stocktaking list

It is a list of articles with data about the state of stocktaking. By default, data in the report are grouped pursuant to articles cards and their sorting is given by setting of the „Name“ and „Abbr2“ parameters.

Print attributes of articles to columns (batches, contract codes, locations, serial numbers) is implicitly ensured according to settings. And the setting is about the control of these attributes on stocktaking.

Stocktaking level is a quantity upon a stocktaking in a warehouse.

Accounting level is a status of stocks from K2 IS made by the date of stocktaking.

Stocktaking difference is between Stocktaking level - Accounting level. A negative value represents a deficit, a positive value represents a surplus on a warehouse.

Empty stocktaking list

The report loads articles from required items from the 1st page of Stocktaking list. It enables to enter actually determined data and status on a warehouse to empty rows. Number of empty rows can be set by the "EmptyLines" parameter. Its default value is set on zero. In dependence on which fields are checked on the 1st page of a Stocktaking in the Check up part, columns with empty rows are printed. But empty rows are not shown at articles if those attributes that are controlled during a stocktaking, are not registered on a given Article card. If no fields are checked on the 1st page of a Stocktaking in the Check up part, the "EmptyLines" parameter can not be used. And the empty row is printed for each item of stocktaking list.

In the report, there it is possible to show levels of particular items - by setting the "ShowAccLevel" parameter on "Yes". Implicitly, the level is not displayed.

Sorting1 to Sorting5

Assigning numbers to these parameters determines which attributes of articles are printed in reports and how items will be grouped.

Sorting 1: main parameter which determines which items will be grouped in the report. It is implicitly set on the '1' value (i.e. articles).

Sorting 2 to 5: represents the particular columns in a report and displays Article, Contract code, Location, Batch or Serial number pursuant to a number, which is assigned by a user. Implicitly value is set on zero.

• Article - 1
• Contract code - 2
• Location - 3
• Batch - 4
• Serial number - 5

If neither the „Abbr2“ parameter, nor the "Name" parameter is set on "Yes", then the Abbreviation1 is printed at article. In the case of "Sorting"="1", the Abbreviation and Name is printed.

It is possible to define random combination of sorting in reports. To reports in height, there can be classified maximum of 4 parameters, to landscape reports all 5 parameters.

SortingAuto

Parameter ensures automatic printing of the columns with article attributes by setting of these attributes to control stocktaking by default.

Parameter

Default value

Description

Abbr2

No

If the parameter is set on "Yes", Abbreviation 2 is printed on the article. If the parameter „Sorting1“="1", Abbreviation 2 and Name are printed on the article and items of articles are grouped pursuant to this combination too.

Name

No

If the parameter „Sorting1“="1", you can set on "Yes" both the "Name" and "Abbr2" parameters. Then the Name and Abbreviation 2 are printed and items of articles are grouped in a report pursuant to this combination.

NotCheckedItems

1

The parameter influences display of uncontrolled items, i.e. items entered on the 1st page but not shown on the 2nd page of a Stocktaking list:

0 - the report displays only founded items pursuant to the 2nd page of a Stocktaking list.

1 - the report displays uncontrolled items according to "Sorting" parameters as these items would be controlled with zero quantity.

2 - the report displays uncontrolled items at the end with zero quantity.

ShowActualPrices

No

It influences display of unit price at stocktaking items and thus preliminarily valuation of surpluses and deficits. It adds price per UM to items:

The "No" value of the parameter - a planned stock price.

The value of the "Yes" parameter - a sliding price.

The parameter has got meaning only when:

- an article has not got the batch records

- an article has got the batch records, stocktaking is executed on warehouse with the price pursuant to batches, a stocktaking is without the control of batches, an inventory surplus exists (i.e. a planned receipt of a new batch to the system)

- an article has got the batch records, a stocktaking is executed on warehouse where the price is not according to batches

ShowTotalDif

Yes

If it is set on "Yes", it displays a total difference of a stocktaking or a stocktaking list in GBP (the basic currency). A price of surplus, of a deficit and the total difference are shown separately.

ShowNull

No

If it is set on "Yes", the items, where a zero inventory difference is, are displayed too. If it is set on "No", items with zero inventory difference are not displayed.

ShowTotalInvState

Yes

It displays a total inventory level in GBP (the basic currency) per a stocktaking list or a stocktaking.

Process No: SKL004

Report ID: SSKL009

File: STOCKTAKING.AM

Report description:

Address in the tree: [Stock] [Stocktakings]

Abbr2 - No

Yes - prints Abbr 2 of the Article. No - prints Abbr 1 of the Article.

DecimalPlaces_Quantity - 3

The number of decimal numbers for value amount.

Name - No

Yes - sorting according to the name of the article.

ShowActualPrices - No

Yes - it evaluates the stocktaking in sliding prices (by the date of stocktaking); No - the evaluation is displayed in planned stock prices.

Parameter is important just in case that:

- the article does not have any batch record

- the article has a batch record, stocktaking is made on the stock where the price is not accounted according to batch

- the article has a batch record, stocktaking is made on the stock where the price is accounted according to batch, stocktaking is without the check of batch and the surplus is there as well.

NewBatchLastPrice - Yes

Yes - new batch is evaluated according to price from the latest article batch. No - reception of new batch is evaluated according to "ShowActualPrices" parameter (thus planned or sliding price by the date of stocktaking).

Parameter is important just in case that:

- stocktaking is executed on the stock with the price accounted according to the batches. The batches are not controlled in the stocktaking.

PreferFIFO- No

Parameter is important just in case that:

- the article has a batch record

- stocktaking is executed on the stock with the price accounted according to the batches

- stocktaking is without the control of batches

- stocktaking deficit exists (batches releasing from system).

In this case the report counts the value of that deficit according to the average price of releasing batches. The setting of "PreferFIFO" parameter in the script "Stocktaking1.pas" says which batches will be K2 preferring for releasing. In a record the parameter should be set for the same value for the right evaluation of the deficit.

Yes - batches with the active FIFO selection are preferred in batches appointing into releasing. The appointing order is: 1) batches with FIFO in Available, 2) batches with FIFO in Assigned, 3) batches without FIFO in Available, 4) batches without FIFO in Assigned. No - the selection FIFO is not taken into consideration upon batches assigning into releases, the order is: 1) batches in Available, 2) batches in Assigned.

ShowNull - Yes

Yes - either displays items with null stocktaking difference.

ShowSumForGroup1 - No

Yes - displays a sum line for sort group 1 (default for articles).

ShowTotalDif - Yes

Yes - displays the total difference of stocktaking in company currency.

ShowTotallnvStat - Yes

Yes - displays information about the total stocktaking state.

Sorting1 - 1

1 - Articles

By number matching to these parameters we can determinate which attributes of articles will be print in records and how the items of the record will be grouped (arranged). Closer description of parameters and records is at disposal in User guide, in the part Stock - Stocktakings, in the chapter Description of records.

Sorting2 - 0

Sorting3 - 0

Sorting4 - 0

Sorting5 - 0

SortingAuto - Yes

An automatic setting of parameters "Sorting2" till "Sorting5" according to article attributes which are being controlled in the a stocktaking. E.g. If batches and location are being controlled then data about batches and location would be automatically printed for articles in columns.

ShowStateAfterCorrections - No

Yes - displays the stock states also with including corrective documents of a stocktaking. If stocktaking is processed properly, then there must be null stocktaking differences in all the lines. No - Displays the stock states without including corrective documents of a stocktaking - it means that after the processing the record displays the differences like before the processing.

Process No.:

Report ID: SCIS124

File: ZB_INVROZ1.AM

Report description: The goal of the report is to show the state of articles in K2 before stocktaking, after processed stocktaking (or by the date of stocktaking) and their differences (either in amount or in the price). In column "The quantity after a stocktaking" displays the state either by date of a stocktaking (set in "StocktakingDate" parameter) or at the end of period (a period, when the stocktaking was running, must be set in the book of Articles; the parameter of a stocktaking date is not filled). The values in a column "Quantity before a stocktaking" are counted on the basis of corrective documents, which made the correction of stocktaking differences with. Correction Release Notes is detected by means of parameter of a report "ReleaseNote". The report is able to be run in the book of Articles.

Address in the tree:

ReleaseNote - ' '

Numbers of corrective released notes in a format Book/Period/Number dividing by semicolon (e.g. "IN/2011/8").

ShowDetail - Yes

Yes - in a detail of an article it displays data from the items of a corrective document (contract code, batch, location, price)

Sorting - 0

0 - sorting by Abbr1; 1 by Abbr2; 2 - by Name.

Sorting - 0

Numbers of stocks divided by semicolon. 0 - current stock.

StockTakingDate- 0.0.0000

Date of stocktaking. The availability is displayed in the column "The amount after stocktaking" by that date. If the date is null, then the availability is displayed at the end of period, which is set in the Articles currently (in this case there must be set the period where the stocktaking is taken).

Process No.: SKL004

Identification number of the report: SSKL010

File: INV_SOUP_LIST.AM

Report description: Stocktaking list for stocktaking.

Address in the tree: [Stock] [Stocktakings]

Abbr2 - No

Yes - prints Abbr 2 of the Article. No - prints Abbr 1 of the Article.

DecimalPlaces_Quantity - 3

The number of decimal numbers for value amount.

Name - No

Yes - sorting according to the name of the article.

NotCheckedItems - 1

Not checked items: 0 - to not display; 1 - to display according to sorting; 2 - to display at the end.

ShowActualPrices - No

Yes - it evaluates the stocktaking in sliding prices (by the date of stocktaking); No - displays planned stock price.

Parameter is important just in case that:

- the article does not have any batch record

- the article has a batch record, stocktaking is made on the stock where the price is accounted according to batch, stocktaking is without the check of batch and the surplus is there as well

- the article has a batch record, stocktaking is made on the stock where the price is not accounted according to batch

NewBatchLastPrice - Yes

Yes - new batch is evaluated according to price from the latest article batch. No - reception of new batch is evaluated according to "ShowActualPrices" parameter (thus planned or sliding price by the date of stocktaking).

Parameter is important just in case that:

- stocktaking is executed on the stock with the price accounted according to the batches. The batches are not controlled in the stocktaking.

PreferFIFO- No

Parameter is important just in case that:

- the article has a batch record

- stocktaking is executed on the stock with the price accounted according to the batches

- stocktaking is without the control of batches

- stocktaking deficit exists (batches releasing from system).

In this case the report counts the value of that deficit according to the average price of releasing batches. The setting of "PreferFIFO" parameter in the script "Stocktaking1.pas" says which batches will be K2 preferring for releasing. In a record the parameter should be set for the same value for the right evaluation of the deficit.

Yes - batches with the active FIFO selection are preferred in batches appointing into releasing. The appointing order is: 1) batches with FIFO in Available, 2) batches with FIFO in Assigned, 3) batches without FIFO in Available, 4) batches without FIFO in Assigned. No - the selection FIFO is not taken into consideration upon batches assigning into releases, the order is: 1) batches in Available, 2) batches in Assigned.

ShowNull - No

Yes - either displays items with null stocktaking difference.

ShowTotalDif - Yes

Yes - displays the total difference of stocktaking in company currency.

ShowTotallnvStat - Yes

Yes - displays information about the total stocktaking state.

Sorting1 - 1

By number matching to these parameters we can determinate which attributes of articles will be print in records and how the items of the record will be grouped (arranged). Closer description of parameters and records is at disposal in User guide, in the part Stock - Stocktakings, in the chapter Description of reports.

Sorting2 - 0

Sorting3 - 0

Sorting4 - 0

Sorting5 - 0

SortingAuto - Yes

An automatic setting of parameters "Sorting2" till "Sorting5" according to article attributes which are being controlled in the a stocktaking. E.g. If batches and location are being controlled in stocktaking then data about batches and location would be automatically printed for articles in columns.

ShowStateAfterCorrections - No

Yes - displays the stock states also with including corrective documents of a stocktaking. If stocktaking is processed properly, then there must be null stocktaking differences in all the lines. No - Displays the stock states without including corrective documents of a stocktaking - it means that after the processing the record displays the differences like before the processing.

Verify if all requested items were checked up

A button for verification of all article items on the stocktaking lists. Its meaning is described in the Control of all required items part.

Book of correction rel. note

A book for a resulting correction release note.

Book of correction transfer note

A book for a resulting correction transfer note. If the field is not filled, it is not possible to use the corr. transfer notes in other phase of the processing.

Book of correction job cards

A book for a resulting correction job card. The field is available only if the value of the BookOfJobCard parameter is entered. In the case the correction of a warehouse is not executed by release note but by job card.

Customer

A customer who resulting correction sales order and release note is issued for.

Process No.: SKL004

Id number of script: FSKL003

File: STOCKTAKING1.PAS

Description of script: The script processes stocktakings and makes the article correction on the stock.

Address in the tree[Stock][Stocktakings]

BookOfReleaseNote - IN

Book for the final corrective released note.

BookOfTransferNote - IN

Book for the final corrective transfer note.

CustomerAbbr

Customer abbreviation for corrective released note.

NoInteractive - No

No - not to display the initial form.

Centre

Centre, it is generally taken from the stock.

OrderCode

Contract code for corrective released note and sales order.

TypeOfTax - TU

Type of tax for corrective released note and sales order.

FormOfOrder

Form of an order for corrective released note and sales order.

WithdrawalType

Withdrawal type for corrective released note and sales order.

ModeOfTransport

Mode of transport for corrective released note and sales order.

PaymentMethod

Payment method for corrective released note and sales order.

DateOfDelivery

Date of delivery for corrective released note and sales order.

DocumentCurrency - Kč

Document currency for corrective released note and sales order.

ArticleFilter - Yes

Yes - makes article filter from the items of a corrective released note.

PIMiReleaseNote - No

It divides the items into positive and negative released notes.

BookOfJobCard

Book for corrective released notes.

DateOfStockTaking - Yes

Yes - date from the 1st page of Stocktaking. No - date and time from the items of a stocktaking list.

NewBatchInNegativeAmount - Yes

To create a new batch for the item with negative amount on the corrective released note and sales order.

JoinToContract - No

Yes - note of ZK type will be looked for in a stocktaking and the corrective released note will be added into this sales order.

AutomatForBatchLocat - Yes

Yes - the batch will be automatically appointed into a released note.

ConfirmReleaseNotes - No

Yes - confirms a released note. No - does not confirm a released note.

ShowActualPrices - No

Way of evaluating of corrective incomes (surpluses): No - incomes are evaluated by Planned stock price from the card of Articles. No - incomes are evaluated by sliding price.

NotCheckedItems - 0

Not checked items: 0 - Found out amount is not found; 1 - Found out amount will be according to K2 amount.

OnlyContract - No

Just create a sales order.

PreferFIFO- No

Yes - batches with the active FIFO selection are preferred in batches appointing into releasing. The appointing order is: 1) batches with FIFO in Available, 2) batches with FIFO in Assigned, 3) batches without FIFO in Available, 4) batches without FIFO in Assigned. No - the selection FIFO is not taken into consideration upon batches assigning into releases, the order is: 1) batches in Available, 2) batches in Assigned.

AutoTransfers_SplitBatch - No

The parameter influences the possibilities of an automatic transfers during the location control. Yes - It is able to use such transfer notes when the batch available is divided into more locations. No: The whole batch available must stay on one location otherwise the transfer could not be done.

NewBatchLastPrice - Yes

Way of corrective incomes (surpluses) evaluating in batches: Yes - incomes are evaluated by the price from the last batch. No - batch incomes are evaluated according to setting of "ShowActualPrices" parameter, it means either planned stock price or sliding price.

RegOffSave - No

Yes - registered function is switched off for another item adjustment, it switches on at the end.

K2 level

Quantity that was registered in K2 IS by the date of stocktaking.

Note: The right adjustment of Received quantity (reception after the 1st confirmation) is just when the actual date is the same as the date of stocktaking. Received quantity is ignored, it does not work with it. If the date of stocktaking is in the past, the Received quantity is included in Available. In this case the information about available could not be right. In the case of double confirmation of reception, for correct stocktaking procession it is necessary to make a correction always by the date of stocktaking!

Stocktaking level

A real quantity that was discovered on the stock and written into a stocktaking list.

Difference

Differences between K2 and Stocktaking levels. This field is editable, i.e. field value can be changed by means of Enter key to smaller one. This way a new item, which contains a new value in the field of Differences, will be created (the rest of original value in the Differences field). This function is advantageous particularly in case that the item has created a collision state on a released note. Negative state on the stock would be created (e.g. there is no enough available on the batch).

Cur. K2 level

The quantity that is in K2 IS nowadays regardless time, when the stocktaking was made, is registered.

Column

Value

Description

S

Items, which are processed into a corrective document (released notes, transfer notes), are signed in this way. The items, where the differences were found out during a stocktaking, can be signed in this way. The items, which are not signed, were not put on a corrective released note.

Id

E.g. 1, 2, and so on.

In case, where two items that have the same number of the article, have their sum = 0 in Difference column on one side and these items differ just from the sales order codes on the other, you can make a corrective transfer note, where 1 item will be transferred in terms of a stock e.g. for another sales order code.

To sign these items you need to sign them with the same number. You can do it in the table on 0 page.

P

The row with this sign says that this item is a part of a transfer note.

N

The item has incorrect serial numbers.

Filter

After pressing the button there is a form, where you can find data according to which you can filter in the list of items. It is possible to filter according to:

Date, Sales order code, Batch, Location, Serial number, Articles or Collision current state.

Collision current state means that the signed items which you cannot release currently, because there would be a negative state on the stock.

Transfer

After pressing the button it selects items, which are connected by means of same number in 'id' column. The icon in 'P' column will be displayed in these items.

Article book

After pressing this button the book of Articles will be displayed.

Coverage of articles

After pressing this button the form Coverage of required articles will be displayed.

Calculate analysis

It causes a form to set analysis configurations and to run calculations of analyses. Closer description below.

Delete till

It deleted analysis till an entered date. A Date to is evaluated.

Delete selected ones

Analyses signed by stars are deleted.

Configuration

It causes a form to set analyses configurations. Closer description below.

Abbr., Name

Identification of a configuration, a compulsory abbreviation and a name.

Data module

Data module for data loading. You can choose:

• items of purchase;
• items of sale;
• items of transfer notes;
• items of production;
• logistic items;
• daily states of supply on stock.

Period type

Period count

These fields help us to set the length of period for data loading for calculation of values by the date of analyses calculation. The type of period can be: date, week, month. Then you can set the number of those periods.

Note: The date by which the analysis is calculated is set in a calculation of analysis.

Example: You want to calculate month turnovers. I.e. you need to load the sale up a month upon the calculation by specific date. Set the combination for a 'month, 1'.

Selection

Selection for data extent determination (items, which are going to be processed).

Grouping field

Evaluate either cards of articles or cust./suppl. You can select an identification from a preset code list according to book of items (for items of documents such as 'C_ZBO' or 'MainCustomerId').

Expression

Expression for value calculation. The calculation runs over the server, you can use just database fields in term (not calculated fields). As aggregate function you can use functions such as SUM, COUNT, etc.

Example: For calculation of turnover value from the invoicing prices, the term would be: SUM(Quant * Ce_Jedn).

The correctness of a term can be verified by Verify SQL query button.

Date field

Data field according to which the time belongs to record.

Example: If you evaluate the turnover of sale, then the data from confirmed invoices will be loaded. The date of accounting case will be determinative for an invoice classifying into period. A date field is 'InvoiceOutRID;DVyst'.

Last count

By the date, the configuration was calculated for the last time, is displayed here.

Book

The identification of final data module (articles, suppl./cust.) is displayed here.

Verify SQL query

It verifies the validity of a term set in Term field.

Date

The date, by which the analyses will be calculated. In case of repeated calculation it is important to set the date of the first calculation. If the selection The last day in a month is activated in a setting of repetition, then just the month and the year is important, not the day.

Calculation recurrence

Recur

Setting of calculation recurrence. The first analysis is done by assigned date, the last one by the last possible date before the current date of running.

Every

You can set the frequency of repetition here. You can select a day, a week, a month as a type of a repeated period.

Example: You can calculate the week turnovers. In a configuration you can set the type of a period for 1 week. The date is 05/01/2014 (Sunday). The repetition is 1 week as well. The first calculation will be on 5/1/2014 and it contains the sales for a week (the configuration says). Another configuration will be on 12/1/2014 (the frequency of repetition says) and for a week again (the configuration says), etc.

Last day of month

Says that the analysis are always calculated by the last day in a month.

Example: Calculate the month turnovers and have all of them by the last day of a month (to eliminate the shift of calculations because of differently long months). In a configuration you can set the type of a period for '1 month'. The date is 1/1/2014. Activate this selection. The first calculation will be on 31/1/2014, the second one on 28/2/2014. Due to a setting of period types, there always will be the 'date from' of the first day of a particular month in a configuration.

Calculation scope

All configurations

The calculation of all configurations will be set by an activation.

Configuration

By means of Configurations button you can choose the particular configuration for a calculation (the selection is done by an activation of a check-field in the list of configurations).

Lead time (days)

Delivery deadline of articles. In the meantime between the plan for real order and delivery of articles, the system does not suggest any other orders. The value influences the calculation of height of insurance supply.

Service level (%)

The ratio of demand satisfaction or the final articles availability. The value influences the calculation of height of insurance supply.

Stock cover (days)

Time for the supply that should cover the predicted demand. The value influences the calculation of ordered quantity.

Seasonal

It enables the user to set if it refers to articles with seasonal sales. During the selection of a forecast model, the seasonal model working with a sale forecast is also evaluated for these cards.

Note: Evaluation of a seasonal model is a quite time-demanding operation.

Unit

Stock unit of articles, where we want to display the data.

Show amounts

Display values in financial part. It counts with a planned stock price of an article card.

Daily / Weekly / Monthly / Default

The selection of summation dealing with displays of sales / consumption (real even the forecast values). In case of week or a month summation the signs of particular months are located in a graph at the end of a period. "Default" summation meets the type of aggregation in a model.

Forecast configuration. Close description in a chapter Forecasts configuration.

Red vertical line

Divides the reality (the left part of graph) from the forecast part (the right part of graph). Represents the day that the forecasts are calculated from.

Dark blue square graph

Historical supplies development on the stock (the reality).

Dark pink line graph

Real sale / consumption in history.

Light blue square graph

Suggestion of supplies.

Light pink line graph

Forecast of sales / consumptions.

Green horizontal line

Insurance supply (SS - Safety stock).

Brown horizontal line

A point of order (ROP - Reorder Point). The quantity, at which the order of articles should be done.

Purple column graph

Existing orders.

Note: The types of coverage, which create the existing orders can be set in Forecasts configuration by means of Coverage configuration. The quantity of ordered from types of coverage 'In reception' and 'Receipted' is not inserted into this set. But the value is added into a state of supplies into the first date of forecasts (as these types have null date in coverage).

Yellow and orange graph

The height of minimum and maximum quantity on the stock from the card of articles.

Grey / black discontinuous curve

The lower and upper bounds of intervals of forecast reliability. These sets are available only during the setting of 'default' display of aggregation models.

Abbr., Name

Identification of configuration.

Data module

Module selection for Forecasts:

• Production: for forecast of consumption in production;
• Sale: for sales forecasts.

Setting up models (months)

Number of months from that date the forecasts are counted by (the date is set in Run forecasts function). It is set for a period where comes a comparison between future sale (consumption) and real sale (consumption) and a selection of the best forecast model. Description is described in a chapter Run forecasts as well.

Forecast period (days)

Number of days where the forecasts are created for.

Warehouse

Sales forecasts: whse where the sales are loading as real historical sales. If there is no selection (in Selection field), then the items from confirmed released notes from this whse will be loaded.

Forecast of consumption: whse where the consumptions are loading as real historical sales. If there is no selection (in a Selection field), then the items from confirmed job cards from this whse will be loaded. (Attention: the selection of job cards is necessary in case of documentation of planning / completion job card. Otherwise the consumption is loaded twice times.)

If the selection is entered, then the condition is always added on defined whse.

Selection

Selection into Sale items / Production items to determine the real sales (consumptions) that will be under process. The selection is always extended of condition on the stock (entered in Stock field). The setting of selection is not compulsory (see description in Stock field).

Date from

Date the real sales (consumption) are loaded in the history from.

Ignore predecessors

Yes - in calculations the succession of the article cards is ignored (it is set on the 4th page of article card)

No - sales (consumptions) and states of cards available contain the data of forerunner (or rather of all forerunners in the tree of the forerunners). The date of the validity end is not taken into consideration.

Aggregation

It is written here how the aggregation values of sales / consumptions (monthly, weekly) forecasts are divided into days.

Explanation: The amount of forecast sales (consumptions) is always saved in a database in daily base. However, the forecast model can return even the aggregated values (according to structure of historical sales / consumptions). You need to re-divide them into days after saving them.

Average method

It calculates an average per day from the aggregate value.

Example: A month calculated forecast for September is 90 pieces. Daily value is 90/30, so 3 pieces daily.

Ration method

For every day it finds out the ratio of sale among days. Ratio of one day (this one) in aggregation period to the whole sale in comparing period. Then an aggregate value is being divided into days by this ratio.

Example: A month calculated forecast for September is 90 pieces. The period to compare it is set 24 months. For daily value of a forecast on 1st of September it finds out what percentage is made for sales for the 1st day monthly in a comparing period to the whole sale for those 24 months. Suppose that in the first date of months 2% of sales are sold. The value 1,8 pieces is calculated for the 1st September.

Example2: Week calculated forecast for the first week in 2015 in September is 90 pieces. The period to compare it is set 6 months. For daily value of a forecast on 1st September (Tuesday) it is found out that the percentage of a sale is always on Tuesdays during previous 6months to the whole sale in this period. Suppose that in the first date of months 15 % of sales are sold. The value of 13,5 pieces is calculated for Tuesday for 1st September.

Comparison period (months)

The length of period going to the past where the calculations of sales ratio for particular days in the view of the whole sale in this month are done. The setting is for an average method.

Coverage -

Abbr., Plan type

By means of Plan type and selection Coverage configuration you can influence the existing orders from a Coverage function. Close description is in a chapter Article card - V page - Forecasts folder in the part of Chart description.

Confidence interval (%)

The lower and the upper limit of forecast sales can be calculated by means of the interval of reliability. By this it is determined with what probability the future sales will be in the ration between the lower and upper limit. The extent of reliability should be within 50 till 99%. The higher responsibility interval the higher difference between the lower and upper limit of a forecast will be.

Set up model

For each processed card of an article the program selects the most suitable forecast model on the basis of real sales. Real sales are being loaded in the interval of:

- from the date set in configuration in the field Date from

- to the date the forecast is calculated (set in this form in the field Date). The date is cut short of the number of months set in configuration in the field Setting of models (months).

The forecast is suggested on the basis of this history. It is compared with the real sales in the period which is reserved for the setting of models. The model, which is the most closer to real sales, is selected as the best model and on the basis of this the future forecasts will be calculated.

Calculate forecast

The calculation of sales on the basis of best model.

Supply suggestion

The calculation of safety supply, the calculation of supply quantity and the suggestion of ordered quantity.

Date

The date the forecasts are calculated from.

Configuration / All configurations

The selection of configuration / forecast configurations, which are going to be processed.

Articles

The abbreviation and the name of an article card. The fields are empty over the summation models.

Basic model

The final, used model for a forecast.

Type

Type of a filter for data smoothing.

Aggregation

Used data aggregation.

Configuration

Forecast configuration.

Evaluable number

Internal valuable number of a model. On the basis of this number, upon the forecast the best model for particular cards of Articles are selected.

Archive date

This field has not been used so far.

Description

Close description of used model.

Inventory safety stock

The quantity of safety supply.

Order point

The amount of supplies, when it is necessary to order the articles.

Ordered amount

Suggested amount to order.

Date of order

The date when the decrease of supply will be under the point of an order, e.g. the date when the order should be issued.

Absence

The date when the articles run out on the stock.

Absence length

The length of articles absence on the stock.

Process No.: SKL007

Id number of script: FSKL006

File: PRE_KOR1.PAS

Description of script: The script creates the corrective transfer notes among particular basic stocks of an accounting stock. The articles are not transferred physically, just in accounting way and in this way it adjusts incorrect prices (accounting value) on stocks.

Address in the tree:

Pre_Rada - IN

Book for corrective released notes.

Period - 0

Number of period where the correction will be executed.

UctSkl - 255

Number of accounting stock.

FilterZbo - Yes

Yes - just the cards from filter of Articles will be processed.