Book Contents

Book Index

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.

Book Contents

Book Index

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:

  • confirm of receipt card (positive item);
  • confirm of release notes (negative item);
  • confirm transfer note;
  • confirm job card (product, negative item).

 

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 iconpic_256i

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:

  • a positive item on a Release Card;
  • an item of interim warehouse Job Card with the release flag "v",
  • a positive Job Card item with the release flag "v".

 

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:

  • a reserving card item;
  • a negative Job Card item with reservation flag "r";
  • an item of interim warehouse Transfer Note with reservation flag "r".

 

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:

  • purchase order item without Receipt card;
  • item of intermediate warehouse transfer note with reservation flag "r".
  • product item on the "Planning" job card with active option Realization;
  • negative job card item with reservation flag "r".

 

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:

  • positive item receipt;
  • negative release note item;
  • negative job card item with release flag "r".
  • job card item with release flag "r".

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:

  • Disposition + Ordered + In reception + Internal reservations - Reservation - Minimum of warehouse

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:

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.

pic_349i

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.

Book Contents

Book Index

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.

Book Contents

Book Index

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 pic_278i.

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.

Book Contents

Book Index

Packet type

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.

pic_3985

Picture: Packet type

Book Contents

Book Index

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
batches

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.

Book Contents

Book Index

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.

  • No variant: when creating a new copy of Article card, no routing variant is copied from the default card
  • Default variant: when creating a new copy of Article card, only the default routing variant is copied from the default card
  • Valid variants: when creating a new copy of Article card, all valid (invalid) routing variants are copied from the default card

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.

pic_2446

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.

pic_3611

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:

  1. 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.
  2. 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.

Book Contents

Book Index

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.

PIC_1084

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.

Book Contents

Book Index

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.

Book Contents

Book Index

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.

Book Contents

Book Index

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.

Book Contents

Book Index

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.

Book Contents

Book Index

Preparing of the price list

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),
Purchase price,
Purchase cost, Sum,
Stock price, Overheads, VAT/CT

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 /
Gross 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.

Book Contents

Book Index

Margin

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:

  • Purchase price Purchase price from The 2. page of the Article.

 

  • Rebate-adjusted purchase price - price defined on 5. Page of The Suppl./Cust. card In field rebate-adjusted purchase price.

 

  • Supplier - supplier price defined on 5. Page of The Suppl./Cust. card Field Net supp. price. The field Optimal supplier must be filled in for the given articles card.

 

  • Sliding - price from Field Sliding price on 2. nd page of Article card.

 

  • The last - price from Field Last price on 2. nd page of Article card.

 

  • Selling - selling price from form Price list preparation (see chap Preparing of the price list). But the price refers on itself so this option isn't too much importance in creation of a price list.

 

  • Stock - price from Field Plan. stock price on 2. nd page of Article card.

 

  • Actual - price from Field Actual on 2. nd page of Article card.

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.

Book Contents

Book Index

Product groups

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.

Book Contents

Book Index

Price groups

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:

Book Contents

Book Index

Article prices

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.

Book Contents

Book Index

Date prices

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.

Book Contents

Book Index

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

Book Contents

Book Index

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).

Book Contents

Book Index

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:

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).

Book Contents

Book Index

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).

Book Contents

Book Index

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.

pic_2151

Picture: Book Articles - page Parameters

Editing of the parameter values

The parameter values you can change by three ways:

  1. During the inserting of free parameter you enter the value directly in form for selection of parameter.
  2. 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.
  3. 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".

pic_2200

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.

Book Contents

Book Index

Parameters book

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.

pic_2176

Picture: Parameters book

Book Contents

Book Index

Parameter - Basic data

Tab Basic Data card Parameter is used for parameter settings definition.

pic_2177

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.

Book Contents

Book Index

Parameter - Places of use

On this page of a parameter the overview of groups is displayed and also Sorting where a parameter is saved as a predefined.

pic_2178

Picture: Book Parameter - Places of use

Book Contents

Book Index

Code list of Groups

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.

pic_2196

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.

Book Contents

Book Index

Classification book

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

pic_2185

Picture: Classification Book - Basic Data

To a table you insert parameters list. Parameters are divided to the groups (marked pic_327i). Two options are available:

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:

pic_3977

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.

Book Contents

Book Index

Bulk change - Change of article parameters (only in universal resolution)

In the universal resolution, a bulk change Change of parameters of article is available, which can be used to change the parameters of article.

pic_4928

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.

pic_4929

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.

Book Contents

Book Index

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.

pic_2723

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.

Book Contents

Book Index

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"

Book Contents

Book Index

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.

Pic_3587

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 PIC_005i.

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 pic_278i.

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.

Book Contents

Book Index

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:

If the user does not have any of the listed rights, the "V" page will not be displayed.

Book Contents

Book Index

Daily stock

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:

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.

pic_3569

Picture: Articles - page V Daily stock

Book Contents

Book Index

Inventory turnover

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:

pic_3570

Picture: Articles - page V Inventory turnover

Turnover configuration

You can see the configuration overview using the button pic_349i

pic_3571

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:

  • Sale (Sale items);
  • Production (Production items);
  • Logistics items (they contain items of all documents (purchase, sales, transfers, job cards), filtering as needed).

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:

pic_3572

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 .

Book Contents

Book Index

ABC analyses

It contains information resulting from the calculation of ABC analyzes.

pic_3568

Picture: Article - page V - ABC analysis

Book Contents

Book Index

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.

pic_4614

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.

Book Contents

Book Index

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 pic_1098i 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.

pic_4804

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.

pic_260.png

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.

Book Contents

Book Index

Module Menu Functions of Articles

Book Contents

Book Index

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 is 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.

pic_3036

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.)

pic_4754

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

pic_1130

Picture: Change internet shop parameters

Book Contents

Book Index

E - shop - ES

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.

pic_3652

Picture Bulk change - E - shop - ES

Book Contents

Book Index

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,
Acquisition pric

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.

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.

pic_1955

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:

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.

Book Contents

Book Index

Reports of Article

Book Contents

Book Index

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.

Book Contents

Book Index

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.

ARTICLEPICT

Book Contents

Book Index

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.

Book Contents

Book Index

Methodologies of Article

Book Contents

Book Index

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.

Book Contents

Book Index

Article card setting

Article, for which you want to use multidimensional quantity, must has set these data:

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.

PIM_512

Picture: A created Article card "Sheetmetal 1200x1500x1,5"

Switch to the 'P' side and apply the classification "Sheet metal" in the Classification field.

pic_2750

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.

PIM_536

Picture: You create an Article card "Glass"

pic_2751
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.

pic_4662

Picture: "Pipe" card storage units

pic_4664

Picture: Pipe tab with assigned classification "Pipes"

Book Contents

Book Index

Classification settings

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.

PIM_511

Picture: Set parameters for ClassificationSheet 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.

PIC_1095.png

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.

pic_1094.png

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.

PIM_537.png

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.

.PIM_541

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.

pic_4664

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.

pic_4663

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.

pic_4665

Picture: Formula to determine pipes coefficient

Book Contents

Book Index

Purchase - Examples

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.

PIM_513

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.

pic_2755

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.

pic_4133

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.

PIM_514

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.

PIM_538

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.

PIM_539

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.

PIM_540

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.

pic_4666

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:

pic_4667

Picture: Disposition of pipes in stock - for the article card and in batches

Book Contents

Book Index

Sale

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.

pic_2756

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.

pic_2757

Picture: Item of sale - alternative unit "pcs"

If you change alternate unit on "kg", you will see the quantity 12 kg.

pic_2758

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.

pic_2759

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.

pic_2760

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.

pic_2761

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.