Articles
The Article database contains a list of all article, materials, products, semi-finished products and other special types of items, which are linked to the documents used in the individual modules of the K2 program. The Article tab contains all information about the article: VAT rate, minimum stocks in warehouses, purchase and sales prices, turnovers and movements of article, etc.
Each article has its internal number that is automatically assigned by system (after saving by pressing F2 key) and that serves to an unique identification of articles in K2 IS.
You cannot cancel created Article card. It is possible to execute only invalidation at the selected cards by pressing of the F8 key. Making records invalid means that the cards aren't visible in the Book mode and it isn't possible to work with them. The inactivated cards are accessible only in Evaluation filter off/on. Invalid cards have a red cross icon next to the Abbreviation 1 field on the 1st side of the card. By again the pressing of the F8 key you can make an appropriate record invalid again.
Articles book
From the point of monitoring stock records, setting the requested stock and the current period is essential. The display of stock information is tied to this. These data are also essential for the printing of stock reports. The set period and stock are displayed in the upper blue bar on the screen. Changing the period and stock may be done by pressing the Alt+F10 key.
Picture: Articles book
Columns Description:
Abbr 1 |
Abbr 1 from 1. page of the Article card is inserted into the planned stock price. |
Lang name |
Name from 1. page of the Article card is inserted into the planned stock price. |
Kind |
Category from the 1st page of an Article card. |
Available |
The number of the article units that are available in a warehouse at the moment. Article will get into available by confirmation stock documents:
Note: In the case of two documents confirmation the quantity stated on a receipt card will be added to the Received column (it is not a default column) during first confirmation of a receipt card. During second confirmation this quantity will be transferred to the Available column. By displaying the "BFIsAvailable" column, the program will indicate the availability levels of articles in some of the company's warehouses to the user - in this case, the icon |
Assigned on |
Number of Article units that is blocked for a particular customer, branch, or production. This quantity is still physically in stock. The blocking occurs if the Article is located on a Release item of an unconfirmed stock document. By the type of blocking, we distinguish the following:
Confirming the document will automatically deduct the quantity of units from Assigned, while the article is no longer physically in stock. The value is displayed only if the user has set the current period. Note: Articles on internal transfer notes within the warehouse are not blocked (does not enter to the Assigned). If we wish to treat the internal Transfer Notes as interim Transfer Notes, we may activate the Client parameter Count Internal Transfer Notes to Assigned. Note: 2: The value in the column is not affected by the set Plan Type (the Plan Type field in the bottom part of the screen), as it is not being calculated from the document items, but from the stock records. |
Reserved |
A number of the Article units which is necessary to ensure for a customer, a branch or for a production. You can miss an article on a warehouse at the moment and it is important to order or to produce it. In article is on a warehouse and customer (branch, production) asks for it. However, the reservation is not blocked for the customer. Depending on the nature of the request, these are items on the following documents:
The displayed values are independent of the selected period. The quantity read from the job cards and reservation sheets is independent of the stock, but respects the display settings of your own companies. For the quantity loaded from the transfer notes, the warehouse is respected. Note: The quantity from the documents, whose Plan Type is selected in the lower part of the screen in the Plan Type field, is loaded to the column (the description of Plan Types is in the chapter Basic Code Lists and Supporting K2 Modules - Plan type). Note: 2: Items of internal transfer notes with a flag "r" are not counted into Reserved. Also, free reserving cards are not counted. |
Ordered |
That is the quantity of Articles units that is ordered by suppliers, branches or will be produced by their own production. Depending on the nature of the request, these are items on the following documents:
The displayed values are independent of the selected period. The quantity read from the job cards and reservation sheets is independent of the stock, but respects the display settings of your own companies. For the quantity loaded from the transfer notes, the warehouse is respected. Purchase Orders: Issuing an unconfirmed Receipt Card to a Purchase Order item will deduct the quantity from Ordered and will add it to the In Receipt column. The quantity will be moved from In Receipt to Available only after confirming the Receipt Card. Confirmation or cancellation of a Purchase Order is then treated as a cancelled request to purchase and the quantity will be removed from the column Ordered. Note: The quantity from the documents, whose Plan Type is selected in the lower part of the screen in the Plan Type field, is loaded to the column (the description of Plan Types is in the chapter Basic Code Lists and Supporting K2 Modules - Plan type). Note: 2: The items of internal Transfer Notes with the flag "r" are not counted into Reserved. Note: 3: In the book, you can also see a column showing the ordered quantity only from the Purchase module (ignoring the quantity of a Transfer Note and production) - this is the field Ordered Purch. ("OrderedPurchCalc" / "OrderedPurchUMCalc"). |
In receipt |
Contains the quantity from Receipt items of unconfirmed stock documents:
|
Optional columns (not shown by default):
Received |
Units number of article received by the first confirmation of the stock document. |
Dispatch |
Units number of article issued by the first confirmation of the stock document. |
Available (CFAvailable) |
Units number of article available on contract code "-". It is "free" available. If the order code records are not tracked (article, warehouse), then the value is the same as the classic Available column (CFDisp). |
Offered (OfferedCalc, OfferedAUCalc) |
The number of Article units (in the case of the OfferedAUCalc field also in alternative units) that is found on non-realized offers (in offered items). |
Coverage Status |
Displays the value of coverage status requirements on given goods. Its value is calculated as follows:
|
Internal Reservation |
The level of internal reservations for products. Internal reservations are defined by the items of internal Sales Orders with a Reserving Card and without a Job Card with Realization. Closer description is provided in the chapter Internal Sales Orders - Internal Reservation for Production |
Note: In the individual columns, it is possible to display the quantity not only in basic, default units, but also within a specific unit as well (see below).
Columns of stock records for any warehouse
In the book of Articles are the so-called parametric columns available, which allow you to monitor the stock records data on requested warehouses. The adjustable parameter of these columns is therefore "warehouse". These are the columns for the following data:
- Available - the column Available [warehouse]
- Assigned - the column Assigned [warehouse]
- In Receipt - the column In Receipt [warehouse]
- Reserved- the column Reserved [warehouse](the classification is important in the “dependent coverage on warehouses” setting).
- Ordered- the column Ordered [warehouse](the classification is important in the “dependent coverage on warehouses” setting).
In the Column Settings, it is necessary to fill in the Stock field - by abbreviation of the warehouse. The column then displays the values for this warehouse regardless of the currently set user information warehouse.
Use is in the situation where the user needs, for example in addition to his/her warehouse (information warehouse), to constantly monitor data at another selected warehouse / other selected warehouses.
Field description in the lower part of the screen:
Whse. |
Current warehouse. which are all the information taken from. Data about articles states that you can see in the screen are from Current warehouse. The abbreviation of the current warehouse is also displayed in the upper blue bar on the screen. You can change the current warehouse in this field or by pressing the 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. |
Price Group |
It affects the display of the selling prices in the Price group "CFDealC" column - the column is not default. When you enter the appropriate price group it will show the sales price valid for the given price group. If there is no existing selling price for an article in the given Price Group, the price in accordance with the Unsorted Price Groups parameter settings will be displayed. |
Firm |
It affects the display of the selling prices in the Price group "CFDealC" column - the column is not default. When you set the selected company, the Price Group applied for its given supplier will appear. Displaying a Customer price has a priority over displaying a Price Group. If the Customer price of an article of this company does not exist, the price of a selected Price Group will be displayed in the Price Group column. |
Currency |
It affects the display of the selling prices in the Price group "CFDealC" column - the column is not default. When you set currency, the selling prices (for the set Price Group or customer) defined in the given currency will be searched for. If such price exists, it will be displayed. However, if such price does not exist, a price in accordance to the rules described in the Price Group and Company fields will be applied, and this price will then be recalculated into the rate of the requested currency. |
Unit |
Unit that is selected in this field will influence values in columns that display quantity of articles (e. g. Reserved, Ordered,...). A unit into which the article is calculated will display in the UM column. In this field, you can select a basic unit, a default unit for Purchase/Sale, a unit for production, a unit for Transfer Notes, or a specific unit of measure (value "other" and unit selection from the displayed menu). The values for Article cards that do not have the required unit are displayed in the basic unit. |
Type of plan |
The selection of a plan type from Plan type code list. According to the plan type the quantity for Ordered and Reserved fields will calculated. A detailed description is provided in the Basic Code Lists and Supporting K2 Modules - Plan Type chapter. |
|
The button for coverage setting. Settings of coverage influence loading records into Coverage of article demanded function. This setting influences requirements loading and their coverage. |
Articles card
Articles card is divided into 9 numbered pages, pages relating to concrete modules follow. These pages are marked by the letters. If in the Browse mode in the Articles book you select by the cursor a concrete Article card and press F4 or Enter key, you get on the previous opened page of a selected card in the Articles book. The same data you can see in a Change mode after pressing F5 key.
Basic Data (page 1)
On 1 st page of an Article card the basic data a stated.
Picture: Articles - 1st Page chapter).
Field Description:
Abbr 1 |
Obligatory unique article identifier. By this abbreviation can be hidden either article name or its part of name or random code (e.g. numeric). According to the abbreviation 1 you can search an article from a book. Abbreviation is standard given in quantity 30 characters. Note: Notion abbreviation has got English meaning in the database Suppl./Cust. and in the database Article. |
|
Abbr 2 |
Filling of the field Abbr 2 isn't obligatory. It is possible to use it for example for PLU, etc. |
|
Name |
Field for entering of complete name of article. |
|
No. |
It is a registration number of an article which is created automatically during the first saving of the Article card. Actually a registration number is an order number of entered article. Note: In the Client parameters on the 2nd page it is possible to check the option Enter article No. which enables to manually enter an article number on a new card. |
|
Type |
Type of Article. Obligatory detail. |
|
|
Other than goods |
For items other than goods a stock level is counted. By conversion you can count only turnovers. |
|
Packing |
It behaves as a commodity item, only it is always valued at fixed prices (i. e. the accounting part of the Warehouse Recalculation function does not process these cards, the physical part of the recalculation does). The turnover record is calculated for packaging regardless of the Customer / article record option in the Client's Parameters. |
|
Breakdown |
When inserting a "Breakdown" card into the documents of purchase, sale, transfer notes and job cards, the article card itself is not inserted into the document, but the cards that form the items of this card are inserted. For purchase, sale and transfer documents, we define breakdown items on page 3 of the Article tab in the Breakdown Items section. The breakdowns for production you define in the Alternative routing book. The article card with a Breakdown or Article breakdown type has to have its own alternative in a Alternative routing book and items of breakdown entered as routing items for usage in the production. Example: You set up e. g. Computer card and on the 3rd page you define breakdown of article which you sell with name Computer (e.g. monitor, keyboard, mouse). When inserting this card to order, a list of article from the 3rd party is inserted, but the Computer card is not inserted into the document. |
|
Article breakdown |
For cards of the "Article breakdown" type, the same rules apply as for cards of the "Breakdown" type, with the difference that in addition to the items of the schedules, the card itself is also inserted into the documents. Example: You set up e. g. Computer card and on the 3rd page you define breakdown of article which you sell with name Computer (e.g. monitor, keyboard, mouse). When inserting this card to order, a list of article from the 3rd page including the Computer card. |
|
Discount |
Value had got meaning in the lower versions of IS K2. |
|
Master Cards |
Type of article used for eshop. Article card with this type serves as a superior article card for various variants of article. Article card with this type cannot be inserted on documents, information on the availability is the sum of the dispositions of the subordinate variants. |
|
Goods |
Goods items have got influence on stock records. |
Group |
Group is a random number or text which every article has to have assigned. Instead of this text in this field can be entered dash too, that means it won't have got assigned a concrete group. By this division the database Article breaks up to the smaller and clearer groups with the collective properties (e. g. groups Grocery, Tools, Spare parts ...). Note: Record from the Groups code list cannot be deleted if the given group is used on a Article tab. |
|
Article Code |
Article code is a random number or text which every article has to have assigned. Even in This case, can be in This field dash entered. According to the article code it is possible to divide goods for example to inland software or foreign software, alcohol to beer, wine, spirits,plain bearings for split and undivided, etc. Article code can enter to accounting as a complementary (helping) analytics of appropriate accounts. |
|
VAT |
Code list VAT rate. |
|
Type |
The type of article is the key code for production. Is used to distinguish article into materials, outputs, semi-finished products, products, etc. Each type of article has different properties that determine its behavior in production. We set the type properties on 1. Page of Type card. In the types, we also define costing models for calculating the prices of products and semi-finished products. Article category influence option of sorting of the Article card to the individual documents and option of separated print in the documents too. On the Type it is possible to preset auxiliary stock records for articles cards. Detail description is described in the chapter Master Data of Production module - Article - Article category. |
|
Brand |
Brand or article producer. You can select record from the Brand dial (TD_WebBrand). |
|
Packing |
Packing connected with articles card. When inserting article into the document, the packaging card is also automatically inserted into the document. |
|
Opt. suppl. |
Here you can set an optimal supplier that means supplier who satisfies your requirements best. The selection is executed from The Suppl./Cust. card. The field is important when recalculating of stock prices according to the optimal supplier price in the case that the price is defined on the 5th page of this supplier and when ordering by Create POs for requested articles function. |
|
Packet type |
The type of package is used to define the possible modes of transport by which article can be transported, including the weight limit for each method of transport. Field is used mainly for Eshop. |
|
Stock units |
In stock records, the economic records (at energy deliveries, at transport) is kept in this stock unit e. g. pcs, m, kg/pcs, GBP/km (of transport), GBP/hour (of training) MWh, etc. Apart from basic stock unit, on each Article card the next stock units that have a certain proportion to the basic stock unit can be defined. E. g. The basic stock unit can be pcs and the others stock units can be package and kg. By pressing Ins key in the table of stock units you can insert a new stock unit. The usage of stock units is applicable so that a quantity of high numbers did not have to be placed in the documents. If you use the possibilities of next stock units, it is methodologically recommended to select the smallest unit as a basic (first entered) unit. |
|
Blocked units |
By this button you display the stock units that had been blocked and they are not used at the moment. |
|
No stock unit |
The button simplifies the setting of unit in the Article cards where the unit is not important (especially a card other than articles). By using of this function you save manual filling of data - record of basic unit with unit of measure "-" will be automatically created. |
|
|
No. |
Unique number of stock unit. User doesn't influence this number. Unit with number 0 = is basic stock unit. This fact is described at this unit too. In a column of the flags at the units on the 1st page of Article card the symbol "•" informs about basic unit. |
|
Unit of measurement |
Abbreviation selected from code list of units of measure. |
|
Proportion basic / current unit |
Ratio determined quantity of basic units to one currently entered unit. It is in inverted value at the field Cur./basic unit ratio and after change of one of these fields the second value will automatically count. |
|
Cur./basic unit ratio |
Ration determined quantity current entering units in one basic. Towards the field Basic ratio / cur.unit is in inverted value and after change of one of these fields the second value will automatically count. |
|
Width, height, Depth |
Field for entering of unit dimensions. Field uses only to records, it isn't used by standard. |
|
Unit of dimension |
Abbreviation of selected stock unit. |
|
Net weight (kg) |
Weight of article without package. This weight is used the function Calculate product weight. It enters only on basic unit. |
|
Gross weight (kg) |
Weight of appropriate stock unit of article with package. This weight is used during the calculation of item's weight and than document. |
|
Capacity / Capacity unit |
Capacity of stock unit. The field is used only for record, it is no longer used by the standard. |
|
Area / Area unit |
Area of stock unit. The field is used only for record, it is no longer used by the standard. |
|
Handling equipment |
Assignment of handling equipment to the stock unit. By this assignment, we express how to handle with the appropriate unit in the warehouse by the personnel (e.g. the stockkeeper wears it in hand or has to use a trolley, etc.). For each manipulation technique it is also possible to determine which group of stockkeepers should work with this technique. We do this on the 1st page of the dial in the Queue field (for example, the queue for handling equipment "truck", which is assigned to the storage unit "pallet", is queue "A", which workers are authorized to drive a forklift). |
|
Integer unit |
When using this unit, you can not enter a decimal value in the items. |
|
Default for purchase |
By checking this field the stock unit is automatically set after articles selecting in the Purchase item. The field can be checked only in one unit. If the flag is cancelled in any unit, it will be automatically set in a basic unit. |
|
Default for sale |
By checking this field the stock unit is automatically set after articles selecting in the Sale item. The field can be checked only in one unit. If the flag is cancelled in any unit, it will be automatically set in a basic unit. |
|
Default for production |
By checking this field the stock unit is automatically set after articles selecting in the Job card item. The field can be checked only in one unit. If the flag is cancelled in any unit, it will be automatically set in a basic unit. |
|
Default for transfer notes |
By checking this field the stock unit is automatically set after articles selecting in the Transfer notes item. The field can be checked only in one unit. If the flag is cancelled in any unit, it will be automatically set in a basic unit. |
|
Default unit for inventory |
The warehouse unit implicit for inventories is automatically preset when entering items into the list sheet, and inventory processing is also performed in this unit (calculation of inventory differences, creation of documents). |
|
Default for internet shop |
By checking this field the stock unit is automatically set after articles selecting in the Internet shop item. The field can be checked only in one unit. If the flag is cancelled in any unit, it will be automatically set in a basic unit. |
|
Quantity unit for i-shop |
If this field is checked, it is possible to order the goods in the internet shop only in this quantity unit in the given ratio to the base unit. The field can be checked only in one item. |
|
Block the unit / Unblock the unit |
If you do not want to use any stock item for this article card, you can block it. The unit will be neither offered nor displayed, if the button Blocked units is not on. Blocking will automatically cancel possible checking of Default units fields at the same time and displays the flag . On a blocked unit the button will be changed to the Unblock the unit button. This operation can be executed only on the last entered unit with an appropriate unit of measure. |
|
Save as New One |
This button enables to save actually edited unit as a copy and it blocks the original unit at the same time. It is very suited to use this function especially if the ratio of a unit changes to a basic unit, because the correction of a previous unit would cause very important change of existing documents. |
Bar code |
The table of bar codes enables to register the various bar codes to various units of an one Article card. A new code you insert by pressing Ins key in the table. The code also records whether we use it for EDI or whether it is the default bar code. This information is used in the internet shop to export goods for price comparators. |
|
Supplementary article numbers |
Define additional identification information for that article card. This can be the "Product Number" (P / N), which is often displayed in e-shops and is used to find, for example, a suitable spare or alternative part. |
|
Serial no. records |
Serial no. monitoring in stock records. If this field is activated, then the items with this article in the stock documents have to contain serial numbers. Note: The option can not be changed by default if there is a record in the stock records (non-zero Received or In receipt or Available or Assigned or Dispatch) for a article card. Detail description is described in the Purchase and Sale Shared Elements - Serial numbers chapter. |
|
|
Auto |
This value enables to create automatically the serial numbers when confirmation of a receipt card. Detail description is described in the Purchase and Sale Shared Elements - Serial numbers chapter. |
Batch records |
Batch monitoring in stock records. By checking of this field the batch will be required in all stock documents items. Note: The option can not be changed by default if there is a record in the stock records (non-zero Received or In receipt or Available or Assigned or Dispatch) for a article card. |
|
|
Auto |
If this option is activated, batch for receipt items: positive item of receipt card, negative item of job card, header of job card, is automatically created when confirmation the stock document. |
Location records |
Location monitoring in stock records. Stock location record are counted only in warehouses, that have the Location records field enabled. In this case, the location entering is required on all stock documents. Note: The option can not be changed by default if there is a record in the stock records (non-zero Received or In receipt or Available or Assigned or Dispatch) for a article card. |
|
|
Auto |
If the option is activated, then there is a proposal of location for the receipt of article to the warehouse. Location for the item is proposed at the time of inserting the article card into the receipt item. Release notes: location is proposed according to the optimal location defined for warehouse / zone / Business year (the 4th page of the article, Article/warehouse data table). Receipt cards, transfer notes: location is searched according to the existing inventory of the specified article card at first, if an article is not found at any location, then according to an optimal location, which is defined for warehouse / zone / period. A rule, that a proposal for a location takes a current location load into account, it means that it is compared, whether a location capacity will not be exceeded by the receipt of a current item, always holds. |
Contract code records |
Contract code monitoring in stock records. Stock contract code record are counted only in warehouses, that have the Contract code records field enabled. Note: The option can not be changed by default if there is a record in the stock records (non-zero Received or In receipt or Available or Assigned or Dispatch) for a article card. |
|
Electronic weight |
Electronic weight is used in the bar codes where the weight is coded. |
|
Do not show article names |
By checking the Do not show article names field you define that in the documents, where the article is, only the text entered in the Description field (on an item of purchase or sale) or in the Name field (on an item of a transfer note or a job card) displays. In the text will be understood as a supplement of an article name. |
Note: Activation / deactivation of the option of an auxiliary stock records
The options for monitoring auxiliary warehouse records can also be changed if the goods are in stock records only if the client parameter is activated Do not check stock records settings on article card.
Insert image
If you have the article image, you can add it by pressing the Insert picture button. The picture appears to the right of the bar code. These pictures serve to creating of offers in the Marketing module. A picture you delete by pressing of the Delete picture button. Associated pictures will add automatically on the 9th page into the Attached documents part. By double click on this picture, you can open it separately in a browser.
Tabs at the bottom of the form
You can use the Notes tab to work with notes. Further description of work is stated in the chapter Basic Code Lists and Supporting Modules K2 – Notes
You can also use the Business text and Internal text tabs. The business text is automatically printed on the Offers, it is possible to display it on other purchase and sales documents. If the SupplFromArticle parameter is empty on these documents, the Business text is printed. The value 0 would not print the text. (Note: In addition to the mentioned values, the parameter can also be used to enter the abbreviation of the addition, which is inserted on the goods, if the text from the addition should appear on the document).
The Product keys tab is used to work with discount coupons. In Change mode, you can assign product keys to article card or delete existing ones. By pressing Ins you get to the Product Keys list. Here you can create additional keys, edit existing, confirm or undoconfirm records. If article is assigned to the Product key then the article appears on the 1st page of the given key in the list of goods.
On the Language names tab, you can enter and edit foreign-language article card names. Enter the description into the editable Text column.
The packet type is used to define the special and possible methods of transport for the goods. For a packet type, the user assigns specific methods of transport, which in addition may limit the maximum weight. It is used especially in Eshop where, if the packet type is defined for the goods including the methods of transport, then in the second step of the basket, users are offered only convenient transport methods.
Picture: Packet type
Prices and others data (2nd page)
On 2 nd page of an Article card the informations about purchase prices are contained.
Picture: Articles - 2ndpage Page chapter).
Field Description:
Currency |
Change mode: Off: Prices are set in the base currency. By changing the rate, the amount in the base currency will not change, the amount in foreign currency will be recalculated. On: Prices are entered in the selected foreign currency. By changing the rate, the amount in the base currency will not change, the amount in foreign currency will be recalculated. By saving the Article card, you also save the settings (off / on) of this option.
Browse mode: Activation / deactivation only temporarily shows the amounts (in / without currency).
The currency is considerate when selecting of a suited supplier price when calculation of a Purchase price by the Recalculate article price. |
Purchase price |
Estimated purchase price excluding VAT. |
Purchase cost |
Cost associated with the acquisition of articles (e. g. transport, premium, commissions etc.). They are given either as a percentage of the purchase price (the absolute value of the purchase cost will be automatically derived from the purchase price and from defined percent) or in absolute value. This field is used to compute the costs associated with the acquisition of articles. The value of the field is set when the item is placed in the PC item field (planned incidental costs). |
Sum |
The sum of Purchase costs and Purchase price appears automatically. In the Article card is only displayed. |
Pl. stock price |
This field does not calculate K2 IS, but a user can enter it. If the invoice price (price of invoice in) is unknown when incoming of article, then the value of this field is entered into the receipt card as a receipt price. Price From this field serves for product praising too, if you price the products by a fixed stock price. The field is updated by Recalculating of stock prices (it is possible to enter it by a sliding price, last price, etc.), at products and semi-finished products by Recalculate products (it calculates the price on the basis of the routing variant). |
The last price |
The price of the last confirmed received invoice, which also has a confirmed receipt for the given article (at least the 1st receipt confirmation). The price is determined from the documents according to the currently set own company. |
Sliding price |
Sliding price of article for an accounting warehouse. It is calculated as the current share of the value of the article in stock in CZK and the quantity in stock. It displays the value from an accounting warehouse where the basic stock that is actually defined in the Article book is included. Or a value from a warehouse that has the Default accounting option enabled. It is also updated with the Stock recalculation function. Note: With zero inventory availability, the value of the sliding price is equal to the price of the last move (for reasons of fair pricing). |
Overheads |
In this field you can enter a surcharge (a production overheads) that serves for production evaluating absolutely or in percent. This also enters into the calculation of the stock price of the product according to the specified costing model (see the Master data of production module - Article - Article category chapter). |
Nomenclature |
The field you fill only in the article cards that subjects to an excise. In the field you select a six-digit code under that it will be stated in an excise return. This code has attached the excise rate. The excise rate is stated in relate to an unit of measure that is specified in law on excise and this unit has to be stated as the one of the alternative stock units in the Article card, otherwise K2 IS declares an Error. The defined value and associated excise rate are automatically copied into the purchase and sale item. |
Concentration |
This field you fill only in Article cards that subjects to a excise on alcohol (you enter the percentage content of alcohol in the product as a decimal, i. e. 40% enter as 0.40) or a excise on beer (you enter the number of whole degrees Plato). |
New CZ-CPA |
Standard classification of production issued by the Czech Statistical Office. It serves to ensure international comparability of statistical indicators. |
Customs Tariff |
The code list Customs tariff is described detailed in the Basic code lists and supporting modules K2 - VAT rate / Customs tariff chapter. |
Duty |
This field serves only for displaying of the percentage amount of duty. |
UM for Intrastat |
It displays the unit of measure for Intrastat. The value is to be entered in the Customs Tariff. Fields can not be edited, change is possible in the Customs Tariff. |
Basic unit / unit |
Assign the ratio of the Intrastat unit to the base unit. Note: If the value remains zero, then the Intrastat calculation will be notified of this fact and the article will not be loaded into Intrastat. If the card does not enter Intrastat, the value may remain zero. |
Country of orig. |
To the Article card you can assign country of origin that can have continuity in the Purchase and Customs module. |
Account - purchase |
Account from Chart of accounts. It fills in Non-stock cards, it is used on purchase documents. |
Account - sale |
Account from Chart of accounts. It fills in Non-stock cards, it is used on sale documents. |
Account - sale consol. unit |
Account, which you can apply to purchase documents, when on the 1 st page of Suppl./Cust. card is on the flag Company of consolidation unit. |
Account - sale consol. unit |
Account, which you can apply to sale documents, when on the 1 st page of Suppl./Cust. card is on the flag Company of consolidation unit. |
Tax type - purch. |
Tax type that will be filled in the purchase item. |
Tax type - sale |
Tax type that will be filled in the sale item. |
Tax type RC - purchase |
If Check amount for RC system is enabled on the Article tab, this type of tax is automatically added to the invoice item if the query "Do you want to set the tax type for RC system from article?" upon confirmation of the invoice received. A more detailed description is in the documentation Accounting / VAT / Methodologies of VAT, import and export / Regime of transfer of tax liability. |
Tax type RC - sale |
If Check amount for RC system is enabled on the Article tab, this type of tax is automatically added to the invoice item if the query "Do you want to set the tax type for RC system from article?" upon confirmation of the invoice out. |
Type of accounting |
The kind according to that the articles will be charged on the stocks. The field can be edited if there is no stock movement on the article card in the period blocked for accounting changes. Note: This field was created from the field Type on the 1st page of Article card. For the needs of production is needed to distinguish several types of goods, while for the needs of accounting just fewer species. |
Cost centre |
The cost centre that will be filled in the purchase or sale item. |
Contract code |
The contract code that will be filled in the purchase or sale item. |
Device |
The device that will be filled in the purchase or sale item. |
Code 1 |
Arbitrary code. It serves for user identification. It will be filled in the purchase or sale item. |
Code 2 |
Arbitrary code. It serves for user identification. It will be filled in the purchase or sale item. |
Code 3, Code 4, Code 5, Code 6 |
Another identification arbitrary code. The fields (Code 3 to Code 6) are only available in universal identification. They are not displayed by default. The method of activation is described in the chapter... It will be filled in the purchase or sale item. |
Planning group |
The selection from a code list that you can define. This field is used for products and semi-finished products separation to various groups for planning. This separation is possible to use in the Capacity plan script (plan_capaplan.pas) where by GroupByPlanGroup parameter you can display requirements for source separated according to the planning groups. Example: The product A is produced in the source Line 1 and has defined the planning group A. The product B is produced in the source Line 1 too and has defined the planning group B. The requirements for this source that result from the cards booking to the product A and B are then divided in the capacity plan according to these two planning groups. |
Officer |
It enables to add e. g. a responsible person to the article, it is a link to the Officer book. After selecting of this articles into the document the data will be copied to the item. |
Selling price acc. to |
If on the 1 St page of the Article card the Batch record field and Selling price acc. to batch are checked simultaneously, it is ensured that the final selling (invoice) price is the price according to the batch edited according to the defined price and product groups. In their definition the value Relative has to be checked. The condition is to have checked this field by An appropriate batch too (1st page of the Batches book), what occurs automatically according to the setting of this field. |
Negative stock level allowed |
By checking this flag the negative status are allowed in stock records. Note: It is not recommended to allow it for the goods that is normally purchased and sold. It is used e. g. at any Article cards used in production. |
Do not create SAD |
By checking the flag it is impossible to create SAD. That means if you create e. g. SAD from invoices in, then the SAD will not been created for these invoice items that has this flag on. |
Customer price in Product groups |
Check the field if you define customer prices in the product group on the customer card and do not perform recalculations of price groups and Customer prices. In this case the customer price will be found directly in the definition of a product group regardless if down on the 5th page of an Article is this price calculated. |
Do not create Intrastat |
By checking the flag, it is impossible to create Intrastat for the article. If the article is on the invoice entering Intrastat, then the good that have the field checked do not enter Intrastat. |
Check amount for RC system |
It will be checked on the Article cards, which are subject to the regime of transfer of tax liability if the amount of the tax base exceeds CZK 100,000. |
Created |
Date and time of creation of the Article card and an user who created the record. |
Changed |
The date and name of the user who made the last change. |
Routing (3rd page)
Third page of the Article card is divided into three parts.
Routings
The first table serves for displaying of individual variants of a routing. The setting of the routing is executed in the Alternate routings book. Two fields in the header of this page are linked to the routings:
Field Description:
Variant |
A default (basic) routing alternative of a product. Alternative will be entered according to the setting of Default value in alternate routing. Or vice-versa, by setting of an alternative to this field the activation of a value Default in the routings will be adjusted. By invalid of a default alternative in the Alternate routings book the value in this field will be deleted. |
Copy |
Setting which variants of routings will be copied when copying the article cards with the F6 key.
|
Show blocked routings |
Invalid Alternate routings are not default displayed. Activation of this value you can display them. |
Detail description is described in the chapter Basic Data of Production module - Routings.
Picture: Articles - 3rd Page chapter).
Breakdown items
The next table serves for definition of the breakdown items. The breakdown items you define to the article cards with the type Breakdown and Goods breakdown. The definition of Breakdowns on the 3rd page of an Article card serves only for Purchase, Sale and Warehouse modules. The breakdowns for production you define in the Alternative routing book. The article card with a Breakdown or Goods breakdown type has to have its own alternative in a Alternative routing book and items of breakdown entered as routing items for usage in the production. The detailed description in the Basic code lists and supporting modules K2 - Articles - Article card - Basic data (1st page) chapter.
Picture: Articles - 3rd Page - Breakdown item
Selected fields' description:
Price/MJ |
Breakdown item price. The field is not used in the standard, it is used for special program modifications. |
Related articles
The third part of this form serves for expression of a relationship of various article cards. The type of relation you define in the Relation field. Standardly it deals with the type "relate, alternative” and "alternative” artices, e. g. for usage of the e-shop. You can add next types of the relation according to your needs.
Article variants
The fourth part of the form concerns the K2 online store and serves to a group of articles under one product, which will represent its variants.
Picture: Articles - 3rd Page - Article variants of web shop K2
If we also want to see some (especially distinguishing) parameters for the Article tabs, we must set The property Parameter for distinguishing the variant of the articles to such parameters in the Classification. In table shows the first 5 parameters with this flag.
To adjust the order of the tabs displayed, you need to:
- Include the parameter according to which we want to sort in the Classification, where it must have the properties Parameter for distinguishing the variant of article (this parameter will also appear in the column in this table) and Sort by comparison value.
- Fill in the value of the parameter for comparison (field Val. to comp.) on the Article tab: To fill in the value, it is necessary to call up the change form with the Shift + enter key. We enter a numeric value - e. g. in a previously used unit, the order of sizes XS = 1, S = 2,M = 3 etc.
Supplier prices (4th page)
The 4. Th page of Article card is used for case when a business partner delivers articles by system of fixed prices and its adjustments according to the product groups, multipliers and the codes of article. Added customer price will display on the 5th Page of the Suppl./Cust. card
Picture: Articles - 4th Page chapter).
Upper part of the card can be controlled in the Browse mode by the buttons over the table, in the Change mode extra by the standard keys. In the called Supplier prices form you insert the new supplier prices by Ins key or by the button Insert (x). You open the same form for performance changes in existing records by the button Change or by Enter key. The button Delete or by pressing Delete key you use for deleting of selected Supplier price.
If the light indicator is positioned on submitted supplier, you can open the Suppl./Cust. book by pressing Ctrl+Enter key in a Browse mode and you can see the card of a selected business partner.
Picture: Supplier prices form
Field Description:
Supplier |
Supplier. |
Unit |
The field for a stock unit setting to which the price applies. |
Amount |
Quantity of articles from which above (including) the supplier price is valid. Default quantity should be equal to zero. |
Suppl. code |
It is marking of an article used by supplier. |
Description |
In a Description field you can set the next comment to this article. |
Changed |
The date and an user name who made the last change of the record. |
TP variant |
Some articles delivered can have more routing variants. Is used to User identification. |
Code 1 |
Possibility of setting any code. Is used to User identification. |
Code 2 |
Possibility of setting any code. Is used to User identification. |
Joint Contract Code |
It indicates contract which the supplier price related to. |
Currency |
The currency in which the price is specified. If the field is not set, the price is in a basic currency. |
Date |
This field is useless in the IS K2. |
Product group |
Product group is relevant only if you edit the multipliers of a price or if you want to set supplier price rounding. Product group is assigned to a specific supplier. We select it from Book Supplier product groups book. Here you can define a new product group by pressing F6 key (or Ins) or change (including multiplier values) whichever product group by F5 key. After selecting of a product group the multiplier values will be automatically entered into the appropriate fields. Set rounding applies on calculation of the field Rebate-adjusted purchase. |
Multipliers |
Multiplier means a figure that provides the possibility to take into consideration various variances of supplier prices (discounts,... - multiplier <1; transport, surcharges >1 etc.). For each product group, you can specify four such factors that are further reflected in the net purchase price of articles. Values of multipliers are entered on 1, Supplier product groups book page. |
Supplier's net, gross price |
By entering of data to this filed you state which initial price is valid for appropriate product group per one stock unit. This is a price that the supplier has in his price list. Net price will be automatically recalculated to Supplier's gross price according to VAT rate defined in the Article card. The same calculation is valid vice versa too - after setting of Supplier's gross price the Supplier's net price will be calculated. Note: If the supplier is listed as optimal on the Article tab (Opt. Supply field on the 1st page of the Article tab), the delivery net price is taken over after the recalculation (function above the article filter Article price recalculation prices - Acquisition price) to the relevant Article card as the Acquisition Price (2nd page of the Articles Card). |
Rebate-adjusted purchase price |
Rebate-adjusted purchase price is calculated from the Supplier's net price that will be multiple all 4 multipliers. Correspondingly Gross purchase price is calculated from Supplier's gross price. A Rebate-adjusted purchase price is automatically entered into an order. Purchase prices only display in a form. |
Delivery time |
According to the provided data from supplier you fill the delivery time. |
Purchase in sets of |
Value indicate after which sets the goods can be take from a supplier. You fill a field according of the supplier data. For example script Create POs for requested goods works with field standard. |
Min. purch. qty. |
Value states minimum quantity which is possible to take from a supplier. You fill a field according of the supplier data. For example script Create POs for requested goods works with field standard. |
Available |
Here you can fill the quantity of articles that is in the supplier warehouse. You proceed from supplier's provided data. Note: If you change unit of measure in the field Stock units, than the data in this field will display according to new selected unit of measure. |
After checking of the field Filter of item the entered supplier prices are possible to filter according to selected supplier by selection of supplier in the field Supplier.
You can get to the supplier prices also from the Purchase item form by the button Supplier prices. Items of supplier's pricelist are default filter on supplier of the document. If you cancel checking of the field Filter of item, you can turn off this filter and than you will see all items of supplier's priceslist of all suppliers.
By Enter key or by double clicks by the mouse the price from supplier's pricelist, where the light indicator is, inserts to the form Purchase item.
Picture: Supplier prices form activated from purchase item
By the button Save into... it is possible to save data from a purchase item (quantity and price of order) to the item of supplier's pricelist where the light indicator is. Before saving of change the Supplier prices form will open where you can edit particular data yet. It can be executed by F2 key too.
By the button New you can save data from purchase (quantity and price of order) item as a new item of supplier's pricelist. Before saving of change the Supplier prices form will open where you can edit particular data yet. It can be executed by Ins key too.
By the button Change you get to the change mode of supplier's pricelist item where the light indicator is. It can be executed by F5 key too.
By the button Copy you get to the copy mode of supplier's pricelist item where the light indicator is. It can be executed by F6 key too.
Min / max quantity, lagers, successor
In the middle part of 4th page of Article card you can preset data:
Unit |
Selection of unit of measure for entering/display of quantity in the for min. and max. quantity. |
Min. quantity |
Minimum quantity which has to be on stock. Checking of field and given quantities have got importance for Coverage (see the subchapter Coverage of article demanded), some functions and output reports (for example moreover Create POs for requested article). |
Max. quantity |
Maximum quantity which can be on stock. Checking of field and given quantities have got importance for Coverage (see the subchapter Coverage of article demanded ), some functions and output reports (for example moreover Create POs for requested article, Stocktaking / stock article). |
Dead stock (days) |
Checking of the field Dead stock (days) activates pursuance of the dead stocks for appropriate article card. Given number of the days influences some output reports (for example Dead stock stocktaking). |
Successor, Valid to |
Successor Articles card The evaluation of this card (Daily reports, Turnover, ABC analyzes) includes the data of the predecessor card after the expiration of the predecessor card - displayed in the Valid to field. Data are only displayed. We enter it on the successor card in the Ancestors overview sub-tab. |
Article / Stock data
In the lower part of 4th page of Article card, on tab Items article/warehouses, we set data for articles / warehouse / zone / periods combination.
Picture: Article / Stock form
Field Description:
Whse. |
Warehouse to which the other data apply. |
Zone |
Zone of warehouse to which the other data apply. |
Month from, Month to |
Period (range of months), after which the set data is valid. |
Optimal supplier |
Optimal supplier for a given combination. |
Optimal location |
Optimal location of goods for a given store / zone / period combination. Description of the rule for adding the location into a receipt is stated in the Basic dataof article chapter, Location - Auto field. |
Estimated releases of period |
Sales / consumption estimate for prediction. If no model is found in the prediction calculation, or if there is insufficient historical data to calculate predictions, the future sale / consumption is given by this data. We enter the value on a daily basis, for longer (week, month) inputs, you can choose the input for the simplified input (estimate). |
Minimum quantity, Maximum quantity |
The minimum and maximum allowable quantity for a given combination of warehouse and period. |
Lager, Minimum, Maximum |
The meaning of the fields is the same as the settings for the Article card in the middle of the form. |
Negative stock level allowed |
By activating the option, we enable negative states for the set data combination. |
Overview of predecessors
On the Ancestors Overview tab page, enter the predecessors of the given article card. Use the Valid until field to specify the expiration date of the predecessor card. After the entered date, all data necessary for the logistical evaluation (Daily Reports, Turnover, ABC analyzes) are moved to the calculations for the successor card. That is, daily stocks and sales after this date are included in the calculation of turnover and ABC analyzes of the successor card.
Selling prices (5th page)
Selling Prices are defined on 5. page of Article card.
Picture: Articles - 5th Page chapter).
In Header on 5. Page of Article card a button “n/b” is stated, with which can be in Change and in Browse mode switched between net and Gross price. For change of these prices you can use Ctrl+Alt+B key as well.
In the upper part in 1. St line the basic selling price (actual price) will be automatically created, in the next lines you can define date price by pressing Ins key in Change mode and then filling of the Price list preparation form (see subchapter Date prices). The same form you can activate by pressing Enter key in Browse Mode.
Picture: Form Price list preparation
Field Description:
Date |
The initial date of the validity of the appropriate Price list. The field is used for setting of a validity of a date price. |
Valid to |
The last possible date of a validity of a price list. The field is used for setting of a validity of a date price. |
Name |
Name of the price list. |
Curr. (currency), |
In the case of an actual price these fields will be pre-filled from the appropriate fields on 2nd page of the Article card. Values can be changed, the appropriate fields will be updated on the 2nd page of Article card. In a case of a data price the updating will not be done. |
Margin |
In this field you select an appropriate margin, or you can define a new one (see Margin subchapter). |
Sale in Foreign currency |
By checking of this field the selling prices and price group will be recalculated according to the specified currency and rate. |
Net sell. price / |
The selling price is the base price which the creating of the final prices in the individual price groups is derived from. It is entered manually or it depends on inserted input price and margin. Switching between Net and Gross prices is performed by the button 'n/b', which is accessible in Browse mode and Change mode too. A name of the field Net sell. price or Gross sell. price informs which of the prices is currently displayed. After pressing the button n/b the displayed prices will be switched within The prices group. |
Product group |
In this field you select appropriate product group (see the Product group subchapter). After filling in the Product group field and finishing work with the form, you will be asked if you want to recalculate the price groups. In the lower part of 5th page of Articles card the prices for prices group which is defined within the product group will be inserted. |
Margin is determined as the difference between selling price and purchase cost, eventually as a proportion between selling price and purchase cost of the Articles. Margin can be set either in absolute amount or percentage. A new margin you can insert into a code list standardly by Ins or F6 key.
Picture: The Margin code list
Field Description:
Name |
Margin name. |
Input price |
An input price is a basic price which correspond to the calculation of a selling price. You have 8 possibilities:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Margin |
Level of margin entered absolutely or in percent (by checking flag %). |
Margin from above |
If you count price from above, i.e. you subtract margin, you will check the field Margin from above. Example: Input price is 100 GBP and margin is 20%. If you count margin from below, than selling price is 120 GBP. If the field Margin from above checked, than the selling price 125 GBP. |
Min. margin and Max. margin |
The fields can affect on some output reports. Standard IS K2 doesn't use it. |
Purchase cost |
You mark this field in case, that you want the purchase costs, inserted on the 2nd page of Article card, will be entered to calculation of selling price. |
Duty |
If we want the customs price entered in the customs tariff on page 2 of the Article card to be included in the sales price, we mark this field. |
Excise Tax |
This field has no Meaning in current IS K2. |
Product groups divided database of article to the groups according to discount (sign '-') or surcharge (sign '+')to basic selling price of appropriate article. The surcharges (discounts) are given in percent of selling price.
Picture: Code list Product group
You insert new product group by Ins key or F6 key. Deleting from the book Product groups isn't possible. Language Description of product group is possible to insert too.
Picture: Product groups - 1st Page chapter).
On 1 list of the items of concrete product group (of the particular customers and price groups with defined surcharges) is given. In the Change mode you can define new (by Ins key) or edit existing price groups. For deleting of product group item you use key Del in Change mode.
Picture: The Product group item form
Field Description:
Currency |
By the Search field you select the currency in which the price should be counted and displayed. It is counted according to an actual rates. |
Price Group |
By checking the field Price group you define that the entered price will refer to a price group. Note: If you check the field Price group, the field for entering of customer will be inaccessible. |
Customer |
By checking this field you define that the entered price will relate to selected customer - the so called customer price. Note: If you check the field Customer, the field for entering of price group will be inaccessible. |
Amount |
The minimum quantity of articles, from which (including) the entered price is valid. Attention: When entering the quantity is suitable to cover the whole interval, i.e. e. g. in a different price since 10 pc to create 2 records: for 0 - p and for 10 and more. Otherwise the price according to price category will be entered for less quantity. |
Surcharge |
In this field you set a surcharge amount or discounts (if you set negative sign) that will be added to the basic price. The surcharge you can set either by an absolute amount or in the percentage. |
Base price |
If we want the price of a given price group to be based on the price of another price group, we will fill in this field by selecting from the book Price groups. |
Relative |
By checking of this field the price is zero in a current display (in a Change mode) and it is calculated according to a specified percentage or amount up to define of an article into a sale item. In this case the same field is checked when displaying the price by the Article prices form on the 5th page in the lower part of Articles card. |
Deduct % of margin |
During the turned on the option the percent of a surcharge, entered in the field Surcharge, is deducted from the selling price. It concerns only to the prices group. Example: You have a basic selling price 100 GBP and surcharge for the price group -10%. Resulting selling price for the price group than will be 90 GBP. After checking of the field Deduct percent of margin the resulting price will be 90,91 GBP. (Amount 100 GBP isn't 100% but 110%). |
Rounding |
During the calculation of the price groups the programme executes rounding of the prices according to the given algorithm: (Price + Constant, Order) + Baťa Note: "Price" is a selling price edited about surcharge. |
Constant |
Constant is an amount which will be ascribe to a selling price edited about a surcharge. It serves to rounding up or down (thus not mathematically). |
Order |
To the field you enter how many places you want to rounding. It is possible to enter not only the decimal numbers, but also rounding off to units, tens etc. |
Baťa |
If you want that a resulting price ended by concrete number, you can enter amount to this field. This price ascribes to the price. Example: If you want to have the final prices set as Baťa's, that means the prices has to final by nine, than during the pricing you will enter rounding on the tens (the field Order) and to the field Baťa number "-1". Than the value "-1" will deduct to the calculated selling price. |
Round gross prices |
By checking the flag you ensure rounding of a gross prices according to set algorithm, that means, set rounding in the left part of a form, relates to the gross prices. |
Currency |
By checking you enable to enter the price in foreign currency which is selected on the Article card. Recalculation between the currencies executes by a course from the Article card. |
Excl. excise tax |
Current IS K2 doesn't use the field. |
Do not recalculate |
By checking of this field you set that the appropriate price should not be recalculated when price groups/customer prices recalculating. Theirs value will stay the same, the percentage of displayed surcharge will be adjusted. Check mark is transferred into the Article prices form when creating of this record, a later change here and in the Article prices form will not reflected in the next - bundled form. |
By price groups you can divide the Suppl./Cust. database into the smaller units. Price groups are mutually different by size of price surcharge or discounts in the sale of articles.
Picture: Code list Price groups
By pressing Ins or F6 key you can set a new price group.
Picture: Price groups - 1stpage Page chapter).
Field Description:
No. |
A price group number that you have to enter manually. Two price groups can not have the same number. The number you can not change subsequently. The number is important when the parameter Unsorted price groups is not checked (see Client parameters (2nd page)). |
Name |
Price group name. |
Description |
Brief price group description. |
Base price |
The price is not changed when recalculating. The field has the same function as the field Do not recalculate in the Product group item form. |
Local price |
The price is not transferred to the branch. |
Do not show |
The price group is not displayed after displaying of Article prices form by pressing F7 key in Article card. |
In the lower part of 5thpage of Article card there are displayed data that relate to price groups setting, alternatively to customer prices. The prices you can set by two ways:
- Filling in the Product group field in the Price list preparation form and recalculating the price groups will Run automatic registration of these prices, unless the Customer Price option in the product group is checked on page 2.
- By pressing Ins key you display the Article prices form where we can set the appropriate data. These prices, however you can update only manually by display the same form, the price recalculation will not affect them (they can just delete them).
Picture: Article prices form
Field Description:
Currency |
The currency in which the price is specified. If this currency is the same as the basic currency, it does not fill. |
Price group |
A price group from which the price will be unfolded. If you check the field for price groups the field Customer will be inaccessible. |
Customer |
You select a costumer for who this price will be valid. If you check the field for a customer the field Price groups will be inaccessible. |
Unit |
The prices that are displayed in the lower part of the form are related to a selected unit. |
Valid from quantity |
Quantity of articles from which above (including) the price is valid. After setting of an appropriate quantity the field Valid from amount will be calculated by multiplying of the fields Valid from quantity and Net price. Attention: When entering the quantity is suitable to cover the whole interval, i.e. e. g. in a different price since 10 pc to create 2 records: for 0 - p and for 10 and more. Otherwise the price according to price category will be entered for less quantity. |
Valid from amount |
The field is automatically filled depending on the value of the field Valid from quantity. |
Base price |
A price group on which depends the surcharge. If the field doesn't completed, surcharge relates to a Selling Prices from The 5. page of the Article. |
Promotion |
This field is useless in the IS K2. |
Relative |
By checking of this field you enable to calculate the price when using of it. A relative price is defined by a percent of a Basic price and its concrete value (how it would be calculated at the moment) is displayed in a Browse mode. If the field is not checked, it deals with an absolute price which amount is fixed at the moment of inserting and it remains the same unless it is changed manually or calculated in bulk. |
TP variant |
The routing variant of a product or a semi-finished product for that the price is valid. Field is used to user identification, the standard of K2 does not work with this field when price formation and inserting of prices in the documents. |
Code 1 |
Possibility of setting any code. Is used to User identification. |
Code 2 |
Possibility of setting any code. Is used to User identification. |
Net price |
Net price automatically enters after filling of the field Article as a selling price from Articles card. Here it is possible to set other price than is given on the Article card. Change will take effect in the fields Valid from amount, Gross price and Percentage price. Note: If a foreign currency is entered in the field Currency, an amount in this currency is entered inthe right part of the field Net price . Recalculation of the foreign currency executes according to the current exchange rate. |
Gross price |
Also, the gross price is automatically substituted after filling in the Article field as the sales price from the Article card after adding the relevant VAT rate. Change of Gross price will take effect in fields Valid from amount, Net price and Percentage price. Note: Way of display gross price corresponds with display net price. |
Percentage price |
Percentage price indicates how much percent it should be added to the original selling price stated on the Article card or to the price according to the price group entered in the Basic price field. You can set the percentage price with a negative sign, the original selling price will decrease. If you set the percentage price, the field Valid from amount, Net price and Gross price will change. |
Do not recalculate |
By checking this field you set that the price will be entered manually and it should not recalculate. The price is not deleted neither in that case when price recalculation you check the Delete current price groups/customer prices field. |
Its are prices whose are valid at concrete date. Date prices are defined by the same way as selling prices on the 5th page of the Article card with the difference that you enter Date (date from) and Valid to (date to) in the Price list preparation form, that means in which interval is price valid.
Except this entered interval is given by so called current prices, where date doesn't define (that means it is display in format 0.0.0000). Current price will create automatically with creating article card. This price you can only edit, not delete.
In order for the date price to be automatically inserted into the invoice issued, it is necessary to have the Use online prices of article item field checked in the Clients Parameters.
You find detail description of work with date prices in the chapter Price Creation methodology in K2 IS.
Stock volumes (6th page)
On 6 of article turnovers by periods per concrete period and per concrete stock is displayed on the 6thpage of Article card. Selection of displayed interval and warehouse is started in Browse mode by pressing Alt+F10 key. Interval and abbreviation of a stock will display in an upper blue bar.
In The upper part of 6. page of Article summing data (opening balance, turnover, balance) are displayed.
Picture: Articles - 6th Page chapter).
Selected fields' description:
Amount I |
Amount of incomes ( positive movements on receipt cards) |
Amount I - cred. |
Amount of incomes on credits ( negative movements on release notes) |
Amount E |
Amount of expenses ( positive movements on release notes) |
Amount E - cred. |
Amount of expenses on credits ( negative movements on receipt cards) |
Calculation of movements to the sum of the turnover in the header
Negative movement does not increase turnover, but only decreases the relevant side of turnover. It follows that credit stock documents should only be used to correct the original movement.
Movement |
Calculation of movements to the sum |
Income by receipt card |
Positive value on the income side |
Expense by release notes |
Positive value on the expense side |
Income by release note |
negative value on the expense side |
Expense by receipt card |
negative value on the income side |
Suppl./cust. turnovers (7th page)
On 7 page of Article the suppliers/Customers turnover are displayed in the case that the Customer / Articles records in the client parameters is checked. Selection of displayed interval is started in Browse mode by pressing Alt+F10 key.
Picture: Articles - 7th Page chapter).
Stock card (8th page)
On 8 page of Article card the stock movements of article display in a selected business year and warehouse. They will be automatically updated by a stock document confirmation or by a Stock recalculation. Set period and stock is performed by pressing Alt+F10 key.
In the header of a stock card the summing data (Op. level, Turnover, Balance, Cl. level) are displayed.
A stock movement is realized by the following documents: Receipt card (RP), Release note (RL), Transfer note (TR), Job card (JC). It is possible to switch directly to the concrete document by pressing Enter key on the appropriate line. By pressing Ctrl+F5 keys, it is possible to change the confirmation date of document from the currently highlighted line. After making the change, the line automatically moves, the ruler stays on the changed record.
Picture: Articles - 8th Page chapter).
By pressing Shift+F6 keys, you can select between displaying in quantity or in monetary amounts. Change will take effect in the Header of a screen inTurnover and Balance fields and in a Receipt, a Release and a Level columns.
By checking the field Filter of item you can define documents filtering according to the contract code or according to the batch, or by their combination. By pressing right mouse button on Contract code and Batch fields and by using the function Copy from current row you can fill quickly the fields with values from item that is marked at the moment (you can use it for searching associated movements e. g.). Using the Internal transfer notes option, you can specify whether or not the movements of internal transfer notes (transfer notes within one warehouse) will be displayed.
Furthermore on this page the field Unit is accessible where you can select the basic unit in which you want to display the values. You select from active stock units defined on the Article card.
By pressing Sup. document button you display:
- a purchase order for a receipt card,
- a sales order for a release note,
- a superior sales order or a superior job card for a Job card or a Transfer note.
The adding of the stock movements into the summing turnover in the heading with regards to credited items is described in the Stock turnovers (6th page).
Documents (page 9)
On 9 page of Article you can assign ext. documents or documents to an appropriate articles as in other modules. In At article it can be for example connection of instruction, Declaration of conformity and other items. Detail description is described in Basic Code Lists and Supporting Modules K2 – 9th Page chapter).
Articles - page Parameters
The page enables to register the structured information of often technical character to the Article cards - so called Parameters. Their list can be created separately for every card by Ins key, or it is possible to use predefined lists - so called Classification. This predefined list on the Article card you can arbitrarily complement by other parameters (this inserted parameter will have flag of manual insertion) but these parameters will remain on the card only in case that they will be filled a value. Every parameter on the Article card or in Classification has to have assigned Group from list of groups. On the one Article card or in one Classification the parameter can occur only once.
If you change Classification on Article card, a list of the parameters will automatically changed too. But the parameters with filled values remain as manually inserted.
Picture: Book Articles - page Parameters
Editing of the parameter values
The parameter values you can change by three ways:
- During the inserting of free parameter you enter the value directly in form for selection of parameter.
- You edit the particular parameters by so called line editing - in the column Value you press Enter key, you enter/select required value from the list and by Enter key you confirm entered value. At parameters with option of enumeration values the same form opens as during the inserting of parameter (point 1). In a list of the values you mark values, which are valid for appropriate goods. By pressing of the button OK you close the form. These selected values, consecutively separated by semicolon, will display in the column Value.
- If you enter all values to the one group, you could use form for entering of more values at once. On the group you press combination of keys Shift + Enter. Form for entering of the parameter values in the group will display. Here you enter the required values directly to the fields Value to the particular parameters. In case of order (selection of a list or enumeration values) the list of predefined values you opens by F12 keys, you choose value by Enter key, the required values mark with at enumeration and close order by Enter or Tab.
- Also you use this variant in case that you enter so called the comparative values at parameter or you want to change unit of parameter value.
Note: Comparative value - the parameters exist its value enough to develop that the earlier used unit subside be practical (well-arranged) and other unit states in some case. However if you want to search according this parameter, subsequently for example in eI-shop, it will need that the system compare absolute value in the same unit. Example of this use are "hard drives". Previously their capacity stated in "GB" (gigabyte) but today the common capacity is in "TB" (terabyte). Therefore you state value "1 TB" to the disc and to the comparison value you write number "1000".
Picture: Form for entering of the parameter values in the group
In Assignment in the Change state, it is possible to move the item (parameter or group) on which the cursor stands, using the gray + and -. The parameter form can be displayed from the 1st page of the Assignment or in the table on the 'P' side using the Ctrl + Shift + Enter keys.
By the Parameter the characteristic is register that is related to an Article card. The colour, weight, material, length, speed, Supported file formats etc. might be an example.
Picture: Parameters book
Tab Basic Data card Parameter is used for parameter settings definition.
Picture: ParameterBook - Basic Data
Field Description:
Name |
The parameters name. |
Description |
The description that can be exported e. g. to the e-shops as a explanation of a content of a parameter. |
App. field |
A working description for a better orientation among the similar parameters, it can briefly summarize the parameter setting. |
Unit |
The link to the code list of unit parameters. If it is filled, it has to correspond to the record from Code list. |
Keywords |
For the possibility of exporting to the e-shop. |
Data type |
The kind of an expected value. Text, Integer number, Decimal number, Date, Time, Field from article card are offered. If the number is selected, the next field is displayed where you can define a number format. In the case of the Field from article card option the next field will be displayed too, where you have to select to which field or note the parameter will refer from an Article card. It is also possible to use a binding field, in this case the connection is represented by a semicolon.. The link to a note type is written as "P@type" of a note, also e. g. to a business text you link by "P@DH". |
Selection from code list of values |
The option provide a possibility to display to an user the list of predefined values. |
Par. value required |
If a parameter is obligatory, the Article card, where this parameter is inserted by the Classification, can not be saved without filling of a parameter value. This applies only to users who have the right to fill in the parameter values??. |
Value is defined in batch or in requested parameters |
This option does not allow entering parameter values on the 'P' side. To distinguish individual deliveries of articles or production batches, we enter values directly on batches. The parameter is therefore not generally valid for articles. In Batch Type is also stored internally in the batch. Assignments with parameters containing the flag "Value is defined on the batch or on the required parameters" will be generated with a new batch type with each relevant change of the Assignment (i. e. especially items) or parameters (flag, data type). Without this symptom, old batches would report inconsistencies in this case. |
Default required parameter |
The parameter with this option will be inserted by default when the newly created required parameter is created on the N / P item in the Parameters tab. The option is active only if the option Value is defined on the batch or on the required parameters is checked. |
Do not transfer from the required parameters to the batch |
A parameter with this option will not be transferred from the required parameters to the batch when it is created (eg by acknowledging receipt) and will not be displayed on the 'P' side. The option is active only if the option Value is defined on the batch or on the required parameters is checked. This parameter can be used as an auxiliary parameter when defining a multidimensional quantity. |
Preserve the required parameter when splitting the item |
Selecting a parameter causes the values to be copied to the newly created set of required parameters when the buy / sell item is split. We recommend checking the option for such parameters for which we do not want to lose their values when dividing the item. Conversely, for parameters that explicitly require re-entry of values after splitting the item, this option does not have to be checked, but we recommend checking the Mandatory data option for such a parameter so that in case the new value is omitted, the document with an empty value is not confirmed. |
List of values allowed |
It enables to select and mark more values, that the Article card fulfils, from the list of predefined values. This possibility is useful e. g. if you want to create for cameras the list of supported picture formats. In the predefined values you define all known and used picture formats and then at a concrete camera you mark all these that the camera can create or process. |
Checked reference |
It solves the possibility for users to write another than predefined value, in a selection from the predefined values. In the case of enumeration the control is obligatory, that means it is possible to select values only from the list. Example: We predefine parameter values, e.g. Color to "black", "white", "blue". If the Checked binding field is checked, then we will not enter any option other than "black", "white", "blue". If the field is not checked, then another value can be entered. |
Export to web |
It serves for ignore or placing of a parameter in the export to the e-shops. |
OLAP |
This option provides the ability to export parameter values as OLAP axes. |
On this page of a parameter the overview of groups is displayed and also Sorting where a parameter is saved as a predefined.
Picture: Book Parameter - Places of use
Parameters groups have got double meaning. It enables to sort the list of the parameters in the Classification or on the Article card how its belong together. In this case you insert parameter and than you choose an appropriate group.
Picture: Parameters groups book
The second option is use meaning of group which you often use for the same parameters list. For example group Packaging always contains the same parameters: English instructions (yes/no); Size of the box (small, middle, large); Content of packaging (text string for listing of the content). During the setting up of the group you directly add these parameters to the group. Any time in the Classification you want to describe package, you insert all group with predefined parameters.
You insert the parameters to the list by Ins key, you delete by Delete key. You can edit an order of the parameters by Gray Plus (numeric keyboard +) and Gray Minus (numeric keyboard -). On the parameters used in the group than an appropriate group will be visible on the 2nd page. Updating of the parameters list in the group doesn't show in the existing classifications.
Classification serves for predefining of parameters list, its sorting to the groups and determining of order, in which they will be display. You can use the predefined classification on a random number of the article cards.
Basic data
Picture: Classification Book - Basic Data
To a table you insert parameters list. Parameters are divided to the groups (marked ). Two options are available:
- You can insert them one by one by Ins key - to select parameter, to assign group to it and insert to the list by OK button.
- The second option of using of the predefined lists of the parameters in the groups - if you press Shift+Ins keys, from the list of the groups you will choose the one and this you will insert to the Classification. The group will insert with all its predefined parameters. You cannot observed order of the parameters and group content. Groups serve only for simplified inserting.
You can randomly delete the parameters by Delete key. By the same way you can delete whole group - if you press Delete key when the light indicator is on the group. You can randomly edit an order of the parameters by Gray Plus (numeric keyboard +) and Gray Minus (numeric keyboard -). Later change of the parameters classes will display to the article cards where the parameters classes is used.
Field Description:
Blocked |
Block / make invalid parameters classes. |
Multidimensional quantity support (VRM support) |
If there is at least one formula for multidimensional quantity on the 3rd page of Parameters classes, then the program automatically activates this option. For a more detailed description of the meaning and use of a multidimensional quantity, see the Basic code lists and Supporting Modules K2 / Articles / Articles Methods / Multidimensional Quantities. |
By clicking the parameter, we will display a form with settings for eshop:
Picture: Parameter class
Field Description:
Lower value is better |
It is not implemented |
Higher value is better |
It is not implemented |
Parameter to distinguish article variants |
Parameter to distinguish article variants on the 3 rd article card. |
Do not show in internet shop |
The parameter does not appear in Eshop |
Formulas for VRM
On the Formulas for VRM tab, we add formulas for multidimensional quantities.
Field Description:
Unit |
It specifies for which stock unit the formula applies. In the case of activated option Valid for release or Valid for receipt is the formula used in the case of agreement stock unit with unit in the sale item respectively purchase. In the case of activated option Formula to determine coeff. is stock unit important if the same unit is selected by the user in the Batch book - then the quantitative values (Disposition, Assigned) are recalculated based on the coefficient in batch. |
Formula |
Formula for calculating the value. Enter individual parameter identifiers (eg V67) in the field. |
Variables for entering quantities |
Here are the variables you need to enter on the Purchase / Sales item (in the Multidimensional quantity form that we call the Quantity button). |
List of available variables |
List of parameters, which user define in Classses. |
Formula to determine coefficient |
If the option is enabled, then this formula calculates coefficient to convert the quantity between the base and the alternative stock unit. This coefficient is saved when a batch is created. It is always calculated regardless of the stock unit, the meaning of the unit input is described above for the Unit field. |
Validation for release, Validation for income |
This formula will be used for release or receipt, if the specified unit matches the unit in the sale / purchase item. |
For a more detailed description of the meaning and use of a multidimensional quantity, see the Basic code lists and Supporting Modules K2 / Articles / Articles Methods / Multidimensional Quantities.
In the universal resolution, a bulk change Change of parameters of article is available, which can be used to change the parameters of article.
Picture: Change article parameters
When setting values, the parameters are inserted with the Ins key, and after selecting a specific parameter, a form is displayed to specify the settings for bulk value change.
Picture: Settings of the parameter values
You can select a group to add a parameter. If the group is filled in, then if the given parameter is not on some articles, it is added as a free parameter to this particular group. If it is not filled in, then the parameter is not added (only the value will change if it already exists on the article).
If it is a parameter with a possible enumeration of values, there is an option to check the field Add to the list of values, when it is checked, the value will not be overwritten, but will be added (if it does not already exist).
You can set a specific value to compare in the Value to compare field.
Article - Complaints and service (page S)
On the 'S' side of the Article tab, the records of service sheets, defects, service operations that are issued for these articles are displayed.
Picture: Articles - page “S”
Field Description:
Service card |
Assigned article card, which has defined variants of the routings of product repair. |
Classification for service |
Assigned assignment for service with parameters that will be in the Parameters tab on Service sheets |
Guarantee for the End Customer |
The warranty period If the customer does not have on Suppl./Cust. card filled in the ID number, this length of the warranty is preset to the sales item and subsequently serves to take into account the type of service (Warranty / Post-warranty) in the case of creating a service sheet above the sales item. |
Guarantee for the Companies |
The warranty period If the customer have on Suppl./Cust. card filled in the ID number, this length of the warranty is preset to the sales item and subsequently serves to take into account the type of service (Warranty / Post-warranty) in the case of creating a service sheet above the sales item. |
Articles - view (page O)
If in the User parameters check box Display page O - views in OLAP, then on the "O" side we can create views In OLPA serves for Data evaulation in IS(K2).
Picture: Articles - page "O"
Articles - page ES
The E-shop page is intended for the specification of all data on articles sold on the K2 E-shop. The page is seen only by the user who has the right to View the ES page in the Article book in the section Webs and e-shops - Articles - Viewing the ES page in the Article book. Only those who have the right to change the ES page in the Article Book (Websites and e-shops - Article - Change the ES page in the Article Book) can change the data here.
Picture: Articles - page Eshop
Field Description:
Name for E-shop |
The unique name of the article, which will be named in the eshop. |
Group for E-shop |
Group of article for assignment of article to eshop. |
Short Description |
A description of the article that should inform the customer about what the product is and why he should buy it. It is displayed in detail and in the product catalog just below the product name. |
Note |
The text of the note will be published in the detail of the article, in the pre-basket, basket and comparison. |
Text at Zero Stock |
The text is displayed on the e-shop only if the articles are not in stock and at the same time the Alternative text is not filled in. Texts can be suppressed in bulk with the Display actual stock statuses flag in Web and E-shop Settings. |
Alternative text* |
The text that is displayed when the warehouse status is specific. Texts can be suppressed in bulk with the Display actual stock statuses flag in Web and E-shop Settings. Web and e-shop settings |
Default price |
The original price shown in this field is displayed / hidden in the detail of the article depending on the - flag Show "default price” in Web and E-shop Settings - Catalog of articles. We enter the price without VAT, then it is displayed on the e-shop according to the price display settings without tax or with tax. |
Transport / Payment |
The option will be ticked if it is a Article card representing transport / payment. The designation will allow cards to not be transferred to the order created as a copy of another order - only Article cards are then transferred. At the same time, the marked article will be displayed on the eshop even if they have a zero price set (regardless of the Do not show Article With zero price in Web and e-shop settings. |
*Text at Zero Stock and Alternative Text can also be suppressed with the option Disallow Sale of Available Articles. It can be found in the Web and E-shop Settings on the Goods Catalogue tab. The user can thus limit the article sale for which, for example, the Text at Zero Stock is set to 2 weeks. In this case, the customer does not have a Buy button available on the e-shop.
At the bottom of the page you find several tabs:
The Long description tab contains text in which you can explain in more detail which product it is. The long description is displayed in the product detail under the Description tab.
The Page Info tab serves as a so-called search optimization. The content of these fields is only the content of the page code for automata. They are not displayed to a regular e-shop/web user, but they can significantly affect the web traffic if they are set up correctly.
On the Info for price search engine tab are stated the data needed to actively use the information on the internet store in various search engines and comparative prices.
Searched words tab contains passwords, that are associated with the Article and which the customer can look for in the internet store. It can be, for example, colloquial names, usual customer typos, but also, for example, 1 + 1 text for free, etc.
On the Article category tab, it is possible to assign article to a category. If the item has Article group assigned to it, the category where that group is used is automatically added here. An entry added here using the Ins key is indicated in the table by a manual edit icon .
On the Flags for shops tab we can set flags Hide on e-shop (articles are not filled into EsGoods and EsGoodsPrice tables after recalculation, then not available on eshop), New, Promotions, Discount, Sale, Free shipping, Tip, We are preparing, Used goods, Non-sale article (article cannot be added to the cart) and Sale to registered users (articles are added to the cart only by the logged-in user). The Default category is also set here, which is to be displayed if the articles are included in more than one category of the same website / e-shop. The Only Ask flag is not implemented yet. All the above-mentioned flags can be set for individual stores manually using line editing. If we exclude article from the e-shop, the line will be marked as invalid with an icon .
Shift + F8 delete the e-shop on the tab Flags for shops
If we have canceled the entire e-shop and no longer want to see the flag on the articles on the flags tab for shops, it is possible to use the Shift + F8 function.
Function is available in book Webs and eshops. Above the invalid e-shop / website, press the Shift + F8 keys - this function deletes the entries (in the Article book on the Flags for shops tab) for all article that have been assigned to the e-shop.
Function is active for right: Webs and eshops/Administration/Deletion of data from web, eshop
Note:
- If the articles were first discarded, i. e. the e-shop has a red circle flag (see above), after the e-shop validation, article will not be assigned back to the e-shop.
- If the articles are still connected to the e-shop and we use the Shift + F8 function, after e.shop validation (and starting the conversion), the goods remain assigned to the e-shop.
Evaluation (page V)
On the individual tabs, the user will find various evaluations of the article card from the point of view of logistics.
Tab contains these subfolders:
- Daily reports: displayed if the user has the right Codelists / Article / Display daily reports.
- Stock turnover: displayed if the user has the right Codelists / Article / Display stock turnover.
- ABC analyses: displayed if the user has the right Codelist / ABC analyzes / Viewing ABC analyzes.
If the user does not have any of the listed rights, the "V" page will not be displayed.
On the tab, you can find the graphical form of daily stock for the selected period and warehouse (Alt + F10). Daily balances of articles in warehouses are counted using the function Stock recalculation. In addition to the inventory display, you can activate the display of other preset series in the graph:
- Sales: displays the daily value of sales. The calculation is performed from the items of confirmed release notes of the currently set warehouse, the decisive date for inclusion in the timeline is the date of confirmation of release notes.
- Production consumption: shows the daily value of production consumption. The calculation is performed from the items of confirmed job cards of the currently set warehouse, the decisive date for inclusion in the timeline is the date of confirmation of job cards.
- Minimum status, Maximum status: displays the set minimums and maximum stocks for a given warehouse or period.
All values can be displayed in both quantities and amounts. We activate the display in amounts using the Show amounts option. The "Sales" and "Production Consumption" series can be displayed as a daily, weekly, or monthly aggregation.
To display, you can specify whether data will be read only for the current card, or whether data will also be read from cards for which the current card is the successor in the successor tree. We influence the loading by selecting Load successor tree.
Note: Negative stocks are shown in a pale red color.
Picture: Articles - page V Daily stock
On this tab, you can find turnover or inventory turnover times.
Inventory turnover
Indicates how many times the average inventory is reversed for a given period (the period is set in the Configuration). Turnover is calculated as Sales / Average Stock.
Turnover time
Indicates how long (how many days) one inventory turnover lasts, or how long the average inventory is in stock. We calculate turnover time as Length of period / turnover.
On tab user will find these information:
- In the header it is possible to define the required minimum and maximum speed, and then the value of the speed from the last calculated default configuration is stored in the Current field. The default turnover configuration can be set using the button (if the user has the Code list / Article / Turnover configuration - selection right).
- The table shows the records of the last calculated revolutions of the individual configurations. The user has all the data needed to calculate the turnover: Turnover in quantity, Turnover in stock prices, Turnover in sales prices, Turnover, Turnover time and in addition Profit.
- The lower part graphically shows the development of individual values over the history of calculations. Select the displayed value by selecting View. If the turnover value is displayed, then in the case of setting the minimum and maximum turnover, the series of minimum and maximum are also displayed. If we wish to monitor or compare values in the graph for more configurations, we mark the individual records in the table with asterisks.
Picture: Articles - page V Inventory turnover
Turnover configuration
You can see the configuration overview using the button
Picture: Turnover configuration
Field Description:
Abbreviation, Name |
Configuration identification, mandatory abbreviation and name. |
Data module |
Select a data module to calculate the turnover. As a data source, you can choose:
|
Type of period Number of periods |
These fields help us to set the length of a period for data loading for calculation of values by the date of analyses calculation. Note: The date by which the turnover is calculated is set in a calculation of an turnover. |
Container |
Filter from the selected data module to determine the data range(items, which are going to be processed). If the filter is not selected, all items are loaded with respect to the field filled in the Date field. |
Recalculate stock prices |
When activating the option, the turnover will not be calculated from the quantity values but from the stock prices (Turnover in stock prices / Average book value of inventories). |
Date field |
Data field according to which the time belongs to a record. |
Whse. |
Warehouse for which we count the turnover. Summing warehouses can also be entered. Note: The filter for items is always automatically temporarily supplemented by a condition for the warehouse specified here. Therefore, it is not necessary to have a stock condition in the conditions of the used filter. At the same time, however, the warehouse is used to calculate the average stock, so it must always be entered. |
Last recalculation |
By the date, the configuration was calculated for the last time, is displayed here. |
Test SQL Query |
Verifies the validity of the configuration entry - specifically whether a valid date field is defined when entering the selection. |
Calculation
We start the turnover calculation from the menu Form / Bulk actions / Inventory turnover calculation. The calculation processes the goods from the container, possibly marked with asterisks.
Two types of calculation with the respect of number of repetition will be done:
- Calculation with repetition, which guarantees repeated loading for various periods. Example: once a year we will calculate the turnover to individual months.
- One-time calculation for a one required period. Example: in the beginning of every month you will calculate the turnover for the previous month.
Picture: Inventory turnover calculation
Field Description:
Date |
The date, by which the turnover 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. |
|
Repeat calculation |
Repeat |
Setting of calculation repetition. 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. |
|
Last day of the month |
Specifies that the turnover is always counted on the last day of the month. Example: We calculate the (annual) turnover and we always want it on the last day of the month. The date is 1/1/2014. Repeat set to 1 month. Activate this selection. The first calculation will be on 31/1/2014, the second one on 28/2/2014 etc. |
The extant of calculation |
All configurations |
The calculation of all configurations will be set by an activation. |
|
Configuration |
By means of the Configuration button (in the lower part of the form) you can select the particular configuration for thecalculation. |
Delete history |
Before calculating the selected configurations, all existing calculation records of the given configurations will be deleted. |
Representative for calculating turnover
The turnover can also be started using the shortcut Inventory turnover recalculation, which can be started as a button from the desktop or included as an automatic action in the Task Scheduler. The shortcut can only be used for a one-time calculation of turnover, without the possibility of repetition. Description of functions and possible setting in shortcut of recalculation is in chapter Administrator / System / Task scheduler / Standard action .
It contains information resulting from the calculation of ABC analyzes.
- The table lists all calculated configurations of the current analyzes.
- There is an ABC Group field in the header bar. To save the relevant ABC group on the Article card, it is necessary to specify the so-called default configuration. This can be set on this tab using the button (if the user has the right Codelists / ABC analyzes / Configuration of ABC analyzes - selection). In this case, the group from the current (last calculated) implicit analysis is then stored in the item header.
- If the Redefine ABC group option is not activated on the Article tab, the resulting group will also be written in the nest field. However, this field can be redefined by the user to another group (e. g. for assortment reason, due to the goal, where we want the article to belong, etc.). In this case, it is no longer overwritten during the calculation.
- At the bottom is a graph showing the history of the development of the monitored value for the currently marked configuration. If we wish to monitor or compare values for more configurations, we mark the individual records in the table with asterisks.
Picture: Article - page V - ABC analysis
Article - EKO-KOM packaging (universal forms only)
The EKO-KOM packaging tab and related books and code lists are only available in universal forms. The EKO-KOM Packaging tab is available on the Sales tab in the Article book. It records possible packaging for article and serves as a basis for the Eko-Kom report. For further description see the chapter Sale.
Picture: Tab EKO-KOM Packaging
The EKO-KOM Packaging tab contains a list of all packaging for the given article. Records are selected and defined in the book EKO-KOM packaging. We enter as many records on the Article tab as there are types of packaging related to the sale of these article. For each basic or alternative storage unit, all packaging that is used for that unit must be defined.
Functions over Article database
Functions description:
F7 |
Displaying Prices of a concrete article for individual price groups in the Article price in the Browse mode. You can select a customer whose customer prices should be displayed. The function consider neither the data prices nor the checked option Customer prices in product group. |
Picture: Article prices form
F8 |
Function for invalid/undo invalid of record. Make record invalid means that in the Book mode the cards are not visible and are accessible only in All mode. On 1 on the 1st page of the card a red check mark is visible and next to the field Abbr 1. |
Alt+F3 |
Display the default variation of the routing. |
Alt+F10 |
On 0th, 6th, 8th page the form Set period and stock display where you define period and warehouse. On 7 Page in the Browse mode the form Set period and stock display where you define period. |
Ctrl+Enter |
On 4 Page in Browse will display on 1. Page of Suppl./Cust. card |
Ctrl+F3 |
It displays the book of Locations with information about Article state on the locations of the set store (on page 0for a specific Article card). |
Ctrl + Shift + F3 (universal forms only) |
Starts the recalculation of price lists for articles we are currently standing on. If articles are included in a product group, product key or category for price lists, then the recalculation adds the article to the current price lists that the product keys, groups and categories contain. |
Picture: Locations book
Ctrl+F4 |
It displays the book of Locations with information about Article state on the individual batches (on page 0 for a specific Article card). |
Ctrl+F5 |
It displays the book of Contract code with information about Article state on the individual codes (on page 0 for a specific Article card). |
Picture: Book Contract codes
Ctrl+F5 |
It changes confirmation date of stock document from the currently marked line on the stock card (8thpage). |
Ctrl+F6 |
It displays the Stock wizard, which shows the stock status of the goods in warehouse in the decomposition to the auxiliary stock records - contract codes, batch, location and handling unit (on page 0 for a specific Article card). |
Picture: Stock wizard
If we call the Help form from the document item (using the button next to the Batch, Order Code, Location, Handling Unit fields), we insert the whole combination of order code, batch, location and handling unit into the item by selecting the currently selected line If you use the Release entire avail. quantity button, then all disposal of this combination will be automatically entered in the item. If you use this function in a purchase item, then the flag of a negative quantity will be automatically entered as well.
Ctrl+F7 |
On 0 it calls up the book Serial Numbers in Stock for the current item. The history of the serial number is displayed on the 1-History tab. |
Picture: Serial numbers in stock form
Ctrl+F11 |
Displays a form with all translated fields on the article. Translations can be changed using line editing, or if it is a field with a description, you can use the form for editing text with a toolbar. |
Picture: Field Translations form
Shift+F2 |
On 0 page Dispatcher function displays. Detail description is described in Production - Production planning and supplying - Dispatcher chapter. |
|
Shift+F4
|
On 0 page the function BOM decomposition is displayed, that serves for creating of item filter from product routing. The container is filled with cards according to the conditions entered in form. From Obligatory items, Supplements or Substitutions fields must be activated at least one. |
|
TP variant |
Selection of a routing variant. |
|
Filter of cat. |
It reduces BOM decomposition only to the specified species. |
|
Categories |
After pressing this button, the Article type book will open, where we use the Ins key to enter the types of article according to which we wish to filter the article cards. |
|
Obligatory items |
In the container of article all routing items will be added except from substitutions and supplements. |
|
Supplements |
In the container of article the supplements will be added. |
|
Substitutions |
In the container of article the substitutions will be added. |
|
Go through all levels |
It scans all levels of routing variant, i. e. TP semi-finished products. |
|
Products and semiproducts |
In addition to inputs, products and semi-finished products are also added to the article container. Otherwise only inputs will be added. |
|
Add to container |
Articles that satisfy the defined parameters will be added in the existing container. |
|
Create filter |
A new container with articles that satisfy the defined conditions will be created. |
Picture: BOM decomposition - Shift+F4 form
Shift+F5 |
Displays the coverage of the demanded goods (page 0) (more detailed description of the Coverage in the chapter Coverage of the demanded article). |
Shift+F6 |
On 8 page of Articles book it switches display of the Amount and Quantity (see the stock card). |
Shift+F7 |
On 0 page the Stock levels form and information, in which warehouse and in which quantity of the at the moment marked article is located, will be displayed. If you mark the row with a different warehouse than we have displayed in the Articles book, after pressing Enter key you will set this warehouse also in Article. |
Picture: Stock levels form
Alt+Shift+F4 |
Filtering of Batch parameters (see the Articles - Batches chapter). |
Ctrl+Shift+F4 |
Filtering of Batch characteristic of a selected Article (see the Articles - Batches chapter). |
Alt+Ctrl+Shift+F4 |
Characteristics of the searched batches over all Articles database (see the Articles - Batches chapter). |
Ctrl+Alt+F5 |
The function allows you to select the Status of Article card. |
Module Menu Functions of Articles
Form - Bulk actions
Picture: Form - Bulk actions - Module Menu Functions of Articles
Bulk actions work over a Container state or over records marked with an asterisk.
Actions description:
Change record |
Enables edit in bulk data of the 1st and 2nd page of selected article cards. Checked option with Delete from container performs deleting records from container after launching this action. |
|
Rate |
When changing the exchange rate, the setting of the Currency option on the Article tabs is ignored, the change proceeds as if the option was turned off. This means that the values of the prices in the base currency do not change. There is only a recalculation of prices in the currency. Note: To change the amounts so that it respected whether the Currency option on the Article tabs is enabled / disabled, use the action from the menu Form - Action - Change exchange rate with price recalculation. |
Picture: The Bulk change of articles form - 1. Page chapter).
Picture: The Bulk change of articles form - 2. Page chapter).
Change of VAT rate |
The feature allows you to change the VAT rate on the Article card with validity from a certain date.
Picture: Change of VAT rate form |
Bulk editing of article / warehouse data |
Allows you to add, change and delete records with data for selected warehouses (page 4 Article, bottom table, tab Article / warehouse data; eg minimum and maximum quantities for warehouses, optimal location, etc.)
Picture: Bulk editing of article / warehouse data, Add action |
Make records invalid |
Function for bulk cancellation of the records with concurrent deleting of the records from Container. |
Make records valid |
Function for bulk validation of unvalid records with concurrent deleting of the records from Container. |
Change Record to Right |
Assignments of the group of rights for browsing and changing for the selected cards. Those cards can be browsed and changed only by those users that have been assigned to the appropriate group of rights. Other users see only crosses instead of cards. The record rights can be granted on 4th page of the Users book. |
Insert Note |
A note of the same type can be inserted to the selected records. At the same time executes deleting of the records from filter. Notes are selected from book Kinds of notes |
Delete Note |
It performs deleting of the selected notes of the appropriate records. These functions are described in Basic function - Module Menu Functions - Form chapter. |
Change Status |
It allows to bulk change the Status field of the selected entries. |
I - shop |
Enables edit in bulk data of the "E" page of selected article cards. The fields, you want to edit, you check in Change internet shop parameters form. For every selected field you set a value which you want to entered on individual Article cards or you want to delete from the cards. |
Include to key/delete from key |
Allows you to include / delete the address key for selected article records |
Picture: Change internet shop parameters
Bulk actions for the ES online store (ES side) work in the same way as bulk actions for other pages of the Article card. They work above the evaluation filter enabled or above the entries marked with an asterisk.
On the 1st page, we can change the ES data in bulk Of page of selected article cards. Check the boxes you want to change. For each of the selected fields, set the value that you want to have listed on the individual article cards, and if it is possible to select an action, then choose whether the value should be removed from the card or added.
On the Flags for Stores page, we can set the listed flags for individual or all online stores.
Picture Bulk change - E - shop - ES
Form – Actions
Picture: Form - Actions - Module Menu Functions of Articles
Nett / gross prices |
It affects displaying of Article prices on the 5th page of Article card. For this function you can use the Ctrl+Alt+B keys combination. |
Recalculate stock prices
The function is used to update the planned stock price on 2. page of Article card. We run the conversion either over a specific product or over a container of goods.
Picture: Recalculate stock prices form
Field Description:
Last price, Add incidental costs |
The last price from the 2. page of the Article card is inserted into the planned stock price. If the Add ancillary costs option is activated at the same time, then the last ancillary costs from the purchase item (in the Article field "CFLastCosts") are also added. |
Sliding price, |
The relevant stock price from the 2. page of the Article card is inserted into the planned stock price. |
Price of optimal supplier |
The planned stock price includes the price from the supplier's price list of the optimal supplier (price list for the given goods on the 5th page of the card of the relevant Suppl./Cust., Or the price list on the 4th page of the Article for the optimal supplier card). |
Price of opt. suppl. (rebate-adjusted) |
The planned stock price includes the price from the supplier's price list of the optimal supplier (price adjusted for multipliers). |
Purchase cost |
The purchase costs from the 2nd side of the Article card will also be added to the selected price. |
Supply also zero price |
The required price will be added to the planned stock price even if it is zero. |
Create data prices |
Creates or updates date sales prices. If the date sale price already exists, the stock price in the definition of this price will be recalculated. If the date price does not exist, it will be created. The selling price remains unchanged. If this option is activated, then the stock price on the 2nd page of the article card is not recalculated. |
Recalculate article prices
It offers updating of the article prices that means of the purchase prices, selling prices, price groups and customer prices. The Function is activated either over an Article card (that means do not over a Book) or over the Article filter. Recalculating is related to purchase price and selling price.
Picture: Recalculate article prices form
Field Description:
Purchase price |
Recalculates the purchase price on the 2nd page of the Article card according to the price of the optimal supplier. If in the card the currency is saved, the first found price that is defined in the same currency will enter. If this price does not exist, a price in a basic currency or a first founded price will enter. |
|
Supply rebate-adjusted purchase price |
Recalculates the purchase price on the 2nd page of Article card according to the price of optimal supplier that is edited about multipliers. The Purchase price field has to be checked. |
|
Selling price |
It recalculates the selling price on the 5th page of Article card either according to a selected margin or according to margin that is set on 5th page of Article card. However it does not recalculate the prices of individual group prices and customer prices. |
|
Margin |
The selling price will be recalculated according to this margin. This margin is not entered into the price, only the value will be calculated according to this margin. |
|
Price groups |
Either the prices of selected price groups (if the Price group from - to field is checked in this form) or the prices of all price groups (if the Price group from - to field is not checked in this form) will be recalculated. The customer price will not be recalculated. In any of following fields is checked, only these price groups will be recalculated whose values match the specified values. |
|
|
Currency |
These price groups will be recalculated that are set in the a defined currency. |
|
Price group from - to |
You select the interval of price groups of which the price recalculation will concern. |
|
Do not recalculate |
By checking of this field the prices that has checked the Do not recalculate field in the Article prices form will be recalculated. All recalculated prices will have set this field according to the definition in Product groups If you check the field Value in addition, then each new recalculated price will have checked the Do not recalculate field according to the value that is selected in Code lists |
|
Delete current price groups |
Before you run recalculation the prices for price groups from the bottom of the 5th page of the Article card will be deleted. If the field is not checked, the prices that should have loaded according to the current (recalculated) definition will overwrite. The prices that are not replaceable remain unchanged - they will be against the definition in addition. |
Customer prices |
The customer prices will be recalculated. If the customer price proceed from a certain price group, you have to check the Price groups field. |
|
|
Do not recalculate |
The meaning is analogous as for the price groups, i. e. as a definition if the records with checked the Do not recalculate field and respectively which value should be set in the new prices. |
|
Customer Currency |
Only the records that are in accordance with the entered values will recalculate in these fields. |
|
Delete current customer prices |
Deletes current customer prices, i. e. all prices related to customers at the bottom of the 5th page of the Article card. |
Create data prices |
A data price will be counted - its Selling price, Price groups or Customer prices. If the Date from and Date to is identical with any price that is already created, its values will change. If any of the data (From or To) is different, a new data price is created. |
Recalculate customer prices
The function is activated over an Article card (that means different from 0th page) or over the Article filter and recalculates the prices of the selected customer according to the set parameters.
Picture: Recalculate customer prices form
Field Description:
Currency |
You select the currency if you want the defined customer price in a different currency as well. |
Customer |
You define the customer whose prices you want to recalculate. |
Amount |
You define the quantity to which the recalculation will relate to. If you set a different quantity than is in the defined customer prices, a new customer price will be created. |
Base price |
You select a price group from which it will be proceeded when recalculating. If we do not enter a price group, it is based on the basic selling price on 5 page of Article card. |
Relative |
If you check the field Relative in the Article prices form will be checked after recalculation. |
Surcharge |
You enter the surcharge absolutely or as percentage (if you check the % field) |
Create data prices |
A data price will be counted - its Selling price, Price groups or Customer prices. If the Date from and Date to is identical with any price that is already created, its values will change. If any of the data (From or To) is different, a new data price is created. |
Recalculate products
The function is activated either over an Article card, over cards marked with an asterisk or over an article filter and it serves for calculation of planned stock price, selling price or weight according to a selected costing model.
- Running over the card container: only the routings of those cards that are in the container are browsed, i. e. if the product contains a semi-finished product, then the routings of this semi-finished product is browsed only if this semi-finished product is also in a container.
- Running over one card or over cards marked with asterisks: in this case, you can browse through all levels of the routings (i. e. all semi-finished products without having to add them to the container) by activating the Browse all levels option. The function fills all subordinate products / semi-finished products (according to the settings in the Article Type) in the card queue for processing and processes them without affecting any existing container.
If a level of the production tree is no longer recalculated, then, if a specific variant is not specified in the item of the semi-finished product, the data from the card of the given semi-finished product is used. If a variant is listed, then the current data from the given variant (applies to the calculation of the stock price and weight).
The recalculation does not recalculate invalidated variants of technological procedures. If such a variant is encountered during the conversion, it is written to the conversion error log. The product / semi-finished product is then valued in the calculation at the current price of the invalidated variant.
Note: Recalculation goes throw the cards sorted according to the Abbr 1 field till all the cards will value correctly. That means if any semi-finished product will be praised after a product, the recalculation of this product card will run again. That is why it is recommended to have named the product cards and semi-finished product cards by this way that these semi-finished products that are generally on the lowest levels of produced trees were alphabetically according to the Abbr 1 field. You provide the faster the recalculation process.
Picture: The Recalculate products form
Field Description:
Planed stock price of product |
According to the chosen costing formula, they will evaluate the implicit variants of the routing of recalculated products / semi-finished products. The price is entered in the Plan. stock. Price field / MJ on the 1st page of the variant. If the Recalculate all variants option is simultaneously marked, then a stock price will be recalculated in all routing variants. The price of the implicit routings is also entered in the Plan. stock price on the 2 nd page of Article card. If a costing base is defined in the routing variant (the Costing base field is filled in), then this quantity is taken into account for the calculation of the unit planned price. Example: Routing is defines for amount of 1 pc article. It contains materials for CZK 10,000 and overheads independent of the quantity produced in the amount of CZK 1,000. Planned unit price is then 11,000 CZK. However, if we normally produce batches of 5 pieces (costing basis), then the planned stock price for one product is CZK 10,200 (CZK 10,000 x 5 pieces + CZK 1,000 overhead / 5). |
Selling price of product |
According to the selected costing model the selling price will be recalculated and entered on the 5th page of Article card in so called current price (price where the date is defined in a format "0.00.0000"). |
Product weight |
According to the chosen costing formula, they will evaluate the implicit variants of the routing of recalculated products / semi-finished products. Weight will be add into the field Weig.(kg) / MJ on the 1st page of the variant. If the Recalculate all variants option is simultaneously marked, then a weight will be recalculated in all routing variants. The weight from the implicit routings is also entered in the field Net weight (kg) for the basic stock unit of the Article. |
Costing model |
The selection of a costing model according to which the final value will be calculated. If you do not define a costing model, the recalculation will run according to a costing model that is defined on the Article category card (for a stock and selling price according to CM - planned; for a weight according to the CM - weight). |
Recalculate all variants |
If these value is marked, all routing variants will be recalculated and entered appropriate values in these variants in a case of Recalculation of planned stock prices and Recalculation of weight. The function does not recalculate variants that are invalidated or blocked for selection. |
Go through all levels |
The option can be activated when starting the conversion over one item card or over the cards marked with an asterisk. The activated option ensures the recalculation of all levels of the production tree - a more detailed description above in the introduction to the description of this function.
|
Create data prices |
If the Product Sales Price option is activated, it creates and calculates a date sales price for the recalculated products. Of the calculated items, only the date price valid from-to the same as the created date price for the product is taken into account. If the Date from and Date to is identical with any price that is already created, its values will change. If any of the data (From or To) is different, a new data price is created. |
Articles repricing
The Function is activated either over an Article card (that means different from 0th page) or over an Article filter and it serves for repricing (recalculation) of Contractor prices, Purchase prices, Selling prices, Price groups and Customer prices based on an entered surcharge. Also here it is possible to create the date prices. The prices can also be rounded according to a defined order and constant.
Picture: The Articles repricing form
Note: The meaning of each field corresponds to the fields in the other forms for recalculations.
Change exch. rate with price recalculation
This function allows you to change the purchase and sale prices of articles that have the appropriate selected currency set. When changing the exchange rate and activating the Purchase Price or Sell Price fields, the saved settings of the Currency option are taken into account:
- The Currency option is off on the Article tab: the amount in the base currency does not change, only the exchange rate changes (and the amount in the foreign currency is converted).
- The Currency option is on on the Article tab: changing the exchange rate does not change the amount in the foreign currency, the amount in the base currency is transferred in the database.
If the Purchase Price or Sales Price option is not activated, then only the exchange rate changes (the conversion behaves as if the Currency option were turned off).
The function is activated over an Article card (that means different from 0th Page), or over the article container.
Picture: The form Change of rate with price recalculation
Recalculate data prices
The function enables to recalculate the current prices to the data prices and the data prices to the current prices. If you copy from the data prices to the current prices, you can check the fields that should have been copied by the recalculation to the price. Further you can edit the data of existing data actions or delete data prices in a selected interval.
Picture: Recalculate data prices form
Field Description:
Current prices - date prices |
It serves for recalculation of a date price according to a current price. In this field you enter a data price that you want to recalculate (both dates have to be identical), respectively that you want to create (If at least one date will be different from the existing date price). |
Date prices - current prices |
It serves for recalculation of a current price according to an entered date price. If this variant is used, the options Delete current prices and the fields in the Copy section have a relevance. |
Delete current prices |
When converting date prices to current ones (i. e. the Date prices -> current field is marked), the current price groups are deleted and replaced by date price groups. |
Copy |
You can define which items should be copied when recalculating of prices. Note: It is valid for a recalculation of the date prices to the current prices only! |
Change from Date on date |
It serves for change of Date from and Date to of the date prices. That means that you can change all date of a date action by this way. |
Delete from date to Date |
It enables to delete date prices that are valid in a defined interval. |
Inventory turnover calculation
The form for inventory turnover calculation will appear. The detailed description in the Basic code lists and supporting modules K2 - Articles - Article card - Evaulation - Inventory turnover chapter.
Reports of Article
Articles price list
Process No: CIS008, ZAK007 |
Report ID: SCIS017 |
File: ZB_CEN01.AM |
|
Report description: Articles price list. |
|||
Address in the tree: [Sale/Processing of sale orders] [Basic data] [Prices] [Price lists] |
Reports parameters:
DisplZer - Yes Yes - display as zero. |
ShowDealCat - Yes Yes - price groups will display. |
ShowInEuro - No Yes - conversion to EUR according to current rate will display. |
ShowNonArticle - Yes Yes - item other than goods will display too. |
Catalogue of articles
Process No: CIS007 |
Report ID: SCIS056 |
File: ARTICLEPICT.AM |
|
Report description: Catalogue of articles with information about price, quantity. The displayed price corresponds to the current sales price for the price group or customer according to the settings of the Price group, Company and Currency fields in the bottom panel in the Article book. (The price can be displayed in the Price Group ("CFDealC") column). If the article has got image preview, picture of article will display. |
|||
Address in the tree: [Sale/Processing of sale orders] [Basic data] [Articles] [List of articles] |
Reports parameters:
ConclusionText Text at the end of a report. |
HideDescription - No Yes - hide text over the picture. |
MainTitle Main title of a report. |
PictureFolder - PICTK2 Type of picture. |
ShowAmount - Yes Yes - display current amount in the warehouse. |
ShowOrder - Yes Yes - current entered task is displayed. |
ShowPrices - Yes Yes - information about the price is displayed. Off - the selling price will be not displayed in the item. |
SubTitle Text below the main title. |
Goods turnover
Process No: CIS007 |
Report ID: SCIS028 |
File: ZB_SKE09.AM |
Report description: Article turnover per selected time interval. Output can be printed in prices or quantities. Internal turnovers (transfers within one warehouse, or between warehouses of one summation warehouse when processed above the summation warehouse) are not counted. |
||
Address in the tree: [Sale/Processing of sale orders] [Basic data] [Articles] [Stock levels] [Purchase/Processing of purchase orders] [Basic data] [Articles] [Stock levels] |
Reports parameters:
CurrentWarehouse - Yes Current warehouse. It is important when the summation warehouse is set. Yes - data is printed for the summation warehouse as a whole. No - data is printed for each physical warehouse belonging to the summation warehouse separately. |
OtherUnit - ' ' Abbreviation of the warehouse unit for evaluation. The parameter is only relevant when set to 5 in the "UnitType" parameter. If the Article card does not have a given unit, it is evaluated in the base unit. |
ShowBatches - No Yes - turnovers of batches will display. |
Show_prices - No Yes - data in the prices will display; No - in quantity. |
ShowZeroItem - No Yes - article with zero turnover will display. Note: Cards with zero turnover and zero initial state are never printed. |
UnitType - -1 Type of storage unit for evaluation. Corresponds to the Unit dial on the zero page of the Article book (bottom panel). The default value "-1" means processing according to the settings in the Article book. |
Methodologies of Article
Multidimensional quantity
Multidimensional quantity offers several variants of use. With Classification, a variable conversion factor can be used, which is calculated and saved in the batch after entering the required properties upon receipt. On a release this coefficient will be used instead of a defined ratio of Articles card.
Example 1 - Sheet metal
From your supplier you buy sheets in pieces with fixed size. But you pay him in kilograms, while one piece of metal weighs differently by the delivered doses. We would like to account this difference during a release, resp. during a pricing.
This case, simply said, works by way that you enter total weight during a receipt and number of pieces. During a confirmation of receipt the coefficient will save to batch characteristic, how much one piece weights. During the release of batch than the one piece counts by coefficient to correct weight and thus a price per this piece counts correctly, because a selling price applies to basic unit, it means to kilograms.
Other option of use of multidimensional quantity is for example selling of goods where you want to register its proportions or according them count a selling price.
Example 2 - glass sheets
You purchase and sell the glass sheets which its proportions you want to simply enter and display. You lead stock records in square meters which you derive from properties of tables. Selling price you specify on square meters too.
In this case you enter proportions to batch characteristic. After entering of proportions and number of pieces a total area will automatically count in. square meters on receipt and release
Attention!!! Multidimensional quantity cannot be used in production, it is intended only for purchase and sale. It isn't possible cut for example table with concrete proportions - a standard production process must take place.
Article, for which you want to use multidimensional quantity, must has set these data:
- Bath records (machine isn't significant - currently this field is ignored and batch is created automatically in purchase; inside out during a release batch always must beentered manually).
- Stock units have to contain units, where you will deal, whether it is Purchase or Sale. For the recalculation between units, the batch from article card will be used in the issue until the batch is selected, after selecting a specific batch, the coefficient from the batch will be used.
- Batch type - see the next chapter.
- All other fields do not affect the functionality of multidimensional quantity and follow general meaning in IS K2.
Example 1 - Sheet metal:
You create an Article card "Sheetmetal 1200x1500x1,5". As a basic Stock unit you select kilograms and as the next stock unit pcs as a default unit for sale. Activate the Batch Registration and Automatic options. You fill all the others demanded fields.
Picture: A created Article card "Sheetmetal 1200x1500x1,5"
Switch to the 'P' side and apply the classification "Sheet metal" in the Classification field.
Picture: Article tab with assigned classification "Sheet metal"
Example 2 - Glass:
You create an Article card "Glass". As a basic stock unit you select square metre, in this unit you purchase and sell. Activate the Batch Registration and Automatic options. You fill all the others demanded fields.
Picture: You create an Article card "Glass"
Picture: Article tab with assigned classification "Glass"
Example 3 - Pipes
We buy pipes of different diameters, for each type of pipe we require to have one card of articles. Each pipe of a given diameter can be purchased in a different standardized length, the pipes are then cut even further. We buy meters of the required lengths of pipes (eg 5 pieces of eight-meter pipe). In the stock records, we need to see the total length of a given pipe in meters in stock and also have an overview of how many pieces and meters we have individual lengths of pipe. We will use batches for this.
Create a product card "Pipe" (identification will also include the diameter) and enter the storage units: meters (base unit) and pieces. We will leave the ratio unspecified. Activate the Batch Registration and Automatic options.
Picture: "Pipe" card storage units
Picture: Pipe tab with assigned classification "Pipes"
In order to work with a multidimensional quantity, the item must have a Classification selected in which the formulas are set on page 3. A more detailed description of the individual Classification and Parameters fields is given in the Parameters chapter in the Basic code lists and K2 support modules section. If there is at least one formula on the 3rd page of the Classification, then the program automatically activates the Multidimensional Quantity Support option on the 1st page of the Classification form. Checking this option cannot be changed manually
Example 1 - Sheet metal
We will create a new Classification "Sheet metal" and a group "Sheet metal", we will establish parameters for the weight of the delivery and the number of pieces in the delivery. The "Number of boards (pcs)" parameter will contain the entered quantity in pieces. To the "Weight kg" characteristic you set the total weight of a delivery. Both parameters will have the option Value defined on batch or required parameters and Default required parameter activated.
Picture: Set parameters for Classification “Sheet metal”
Then we enter the formula Classification on the 3rd page. The formula valid for receipt will be defined for the storage unit "kg" because we buy sheets in this unit. The result of entering the weight (calculated value that is entered in the purchase item in the Quantity field) must be this weight (because we buy in kilos). Therefore, enter the identifier of the "Weight" parameter (V67) in the Formula field. In the Variables for entering the quantity field, enter the parameters that you wish to enter when receiving. In our case, in addition to the weight, the number of purchased sheet metal plates (V67, V168).
The entered formula therefore means that in the Quantity field in the purchase item there will be the same value as we enter using the form via the Quantity button into the "Weight" parameter.
Picture: Setting the formula for receipt
For the "pcs" unit, a formula will be entered to calculate the coefficient (ratio between kg and pcs for each batch). This ratio replaces the fixed ratio from the articles card when calculating the quantity in pieces. This formula has to be checked the field Formula to determine coefficient. Formula displayed on the picture counts coefficient as a contribution of total weight and total quantity. You determine the weight of the one piece. The value of the coefficient is saved in the batch when the batch is created.
Picture: Set formulas for "Plech ks"
After entering the formulas on the 3rd page of the Classification form, the Multidimensional Quantity Support option on the 1st page of the Classification form will be activated automatically.
Example 2 - Glass
We create a new Classification "Glass" and enter the parameters for height, width and number of pieces in in the delivery. Properties "Dimension A" and "Dimension B" contain height and weight, property "Quantity" contains number of received pieces in appropriate proportions. All parameters will have the Value from batch option checked.
Picture: Set characteristic for the Classification "Glass"
We enter the formulas on the 3rd page of the Classification code list. In this example you buy and sell in square meters which you calculate by multiplying of both proportions and by number of pieces. Thus you count purchase and sale according to the same formula "Dimension A x Dimension B x Quantity". You don't need other formula.
.
Picture: Set formula for the Classification "Glass"
Example 3 - Pipes
We will create a new Classification "Pipesl" and a group "Pipes", we set the parameters for the number of pieces in the delivery and the length of the pipe. The "Number" parameter will contain the entered quantity in pieces. We will enter the length of the pipe in the "Length" parameter. Both parameters will have option Value is defined in batch or in requested parameters activated.
Picture: Set parameters for Classification “Pipes”
Then we enter formulas on the tab Formulas for VRM. The formula valid for receipt will be defined for the storage unit "Metric" because we buy pipes in this unit. In the Variables for entering the quantity field, enter the parameters that you wish to enter when receiving -pieces and pipes length. The result of the entry must be the total purchased length, i. e. the product of the number of pipes and the length of the given pipe. Therefore, in the Formula field, enter the product of the identifiers of the "Number" (V177) and "Length" (V178) parameters.
Picture: Formula for receiving tubes
A formula will be entered for the "pcs" unit in order to calculate the coefficient so that the user can display not only meters in stock for individual batches, but also the number of pieces in stock. This ratio replaces the fixed ratio from the articles card when calculating the quantity in pieces. This formula has to be checked the field Formula to determine coefficient. To convert meters to pieces, we need to have a coefficient value equal to the length of the pipe. Therefore, we enter the identifier of the "Length" parameter. The value of the coefficient is saved in the batch when the batch is created.
Picture: Formula to determine pipes coefficient
Example 1 - Sheet metal
We have ordered 2130 kg of sheets from the supplier. The supplier sent 100 pieces weighing a total of just 2130 kg. You want to receive this article to the stock.
You set up Purchase order by standard procedure. You choose article "Sheetmetal 1200x1500x1,5" to the sale item. The button Quantity will be accessible. By this button you activate the Multidimensional quantity form We enter the required value of the order into it - we order in kilos, so we enter 2130 kg in the "Weight" parameter. The resulting quantity, which is displayed at the bottom of the Result Value field, is calculated according to the formula that has the Valid for Receipt option activated and that is displayed at the top of the form. This value is inserted in Purchase item.
Picture: Purchase item on an Order issued with the Multidimensional Quantity form open
A record of the required parameters is created (in the Required par. Field) with the parameters "Number of boards" and "Weight" filled with the values entered in the Multidimensional quantity form.
Picture: Required parameters of the planned batch after entering the order
We will include the item on the receipt and enter the missing values via the Quantity button, or we will modify the existing ones according to the actual delivery. In our example, we will keep the weight and add the parameter "Number of boards", ie 100 pcs. The parameter values in the required parameter record are updated. We will go to the receipt card and confirm here. During confirmation a batch will be automatically created where the values from Required characteristics will be copied. At the same time, the batch coefficient is calculated according to the formula for determining the coefficient - in our case the total weight / number of pieces. Therefore, the average weight of one piece of this batch (21.3 kg) is calculated.
Picture: Values in the batch after adding the quantity to the recipient and confirming the receipt card
To display the value of the coefficient, it is necessary to display a column with the program name "Coefficient" in the Batch book. The Availability ("CFDispMJ") column then shows:
- when setting the storage unit "kg", the value in kg (according to the actual value of receipt);
- when setting the storage unit "pcs", the value in pcs (calculated on the basis of the batch coefficient).
If you wish to monitor the status in pieces (alternative unit) at the same time as the selected unit "kg" (basic storage unit), then the column Coef disposition can be displayed. ("CFDispCoef"), which displays the value converted from kilos to pieces according to the batch coefficient.
Picture: Batches - book
Example 2 - Glass
The supplier sent 40 pcs glass sheets with proportions 0,2 X 0.5 m.
You set up Purchase order by standard procedure. You choose article "Glass" to the sale item. The button Quantity will be accessible. By this button you activate the Multidimensional quantity form (hereinafter referred to as Quantity). There you set required values - proportion A, proportion B and number of sheets. According to the formula the final quantity will be calculated that will be inserted into a Purchase item. If you want to insert next characteristics by this way, you would have to state them in the formula multiplied by the zero, like in the previous example.
Picture: Pasted proportions and number of glass sheets in the order item
In the required characteristics a planned batch (i. e. required characteristics) with "Proportion A", "Proportion B" and the "Quantity" characteristics with their content identical with inserted values in the Quantity form will be created after setting of an item. You insert an item into a receipt card (or other documents that are not important for you at the moment) and you confirm the receipt card. During confirmation a batch will be automatically created where the values from Required characteristics will be copied.
Picture: The characteristic of automatically created batch on a receipt card
So we have 40 pieces of glass panes measuring 0.2 X 0.5 M. Availability the Articles book has increased by 4 square meters.
Picture: Increased disposal of the "Glass" article
Example 3 - Pipes
We bought 10 pieces of eight-meter pipes and 10 pieces of twelve-meter pipes from the supplier.
Picture: Receipt of pipes to the warehouse - detail of entering an item for 10 pieces of twelve-meter pipes
In the stock records we see the data as in the following picture:
- for the product card "Pipe" we see the availability of 200 meters
- in the records of batches we then see a detailed breakdown by type of pipes, their availability in meters and pieces
Picture: Disposition of pipes in stock - for the article card and in batches
Example 1 - Sheet metal
A customer wants to buy 40 pcs of an article "Sheetmetal 0,05 pcs" and he wants to know the price. You want to sell the sheetmetal for the price 175.50 GBP/kg always on the whole pieces to corresponded price with a specific sheet according to its weight.
You set in Article card a selling price 175.50 GPB Detailed information about how to set sales prices are stated in the chapter Price Creation methodology in K2 IS
You create a standard Sales order as you used to. You choose article " úSheetmetal 0,05pcs" to the Purchase item. Thus the button Quantity activates by which you open Quantity form. In this form you enter only value "Quantity-pcs" (it means a number of pieces which you want to sell), because this one property is given in formula with validate for sale.
Picture: Purchase item with the open Multidimensional quantity form
Entered quantity automatically enters to Quantity in Sale item, because you have got set default sale unit of this Article card on "pcs". Before a batch isn't selected a conversion on the kilograms will execute according to a proportion which is set in alternate unit on the Article card. Price 2 106,- CZK (52,65 CZK/pcs, which is 175,50 CZK/pcs) is only preliminary price and doesn't correspond with concrete delivery.
Picture: Item of sale - alternative unit "pcs"
If you change alternate unit on "kg", you will see the quantity 12 kg.
Picture: Item of sale - unit "kg"
Change unit on the pieces backward.
For specification of a price you have to choose a batch. Parameter "pcs" will use for exact calculation of weight of required 40 pcs. After at selection of batch a price will change on 66,69 CZK per piece. This price is exact.
Picture: Sales item with selected batch
If you change unit on "kg", you will see the quantity 15.2 kg will display, because required batch weighs 0,38 kg/pcs against 0,3 kg/pcs in ration for the alternate unit.
Picture: Sales item with selected batch and changed unit to "kg"
After confirmation of a created release note an available of article "Sheetmetal 0,05 pcs" will decrease on 22,8 kg.
Attention! A batch in release has to always be selected manually, auto-completion batch doesn't work here. An item could be divided and thereby damaging the data, because the values about quantity are saved in the properties which are copied to a newly automatic created item!
Example 2 - Glass
A customer wants to buy 30 pcs glass sheets with proportions 0,2 X 0.5 m and he agrees with the price 300 CZK per square meter.
You create a standard Sales order as you used to. You choose article "Glass" to the Sale item. Thus the button Quantity activates by which you open Quantity form. In this form you enter the required proportions and a quantity. Calculated area (according to a formula for sale) will automatically entered to the field Quantity to the Sale item.
Picture: Item of sale - unit "m2"
You create a release note. From the column Available in the Article book the 3 square meters will displaced to the column Assigned. On the basis of required characteristic (proportions and number) you select an appropriate batch. Now you can confirm a release note. Released quantity deducts from the column Assigned, on the stock the one square meter will remain.
Attention: If we confirm the older stock document and the formula has changed in the meantime, the document cannot be reconfirmed due to a change in the algorithm calculation! In this case, it is necessary to delete the batch and the required parameter and re-enter the values via the Multidimensional Quantity form to create a new required parameter and, by confirming the document, also a new batch according to the new formula.