Book Contents

Book Index

Methodologies - Shared Purchase and Sale Elements

Book Contents

Book Index

Pricing in IS K2

In IS K2, it is possible to define a price system to reflect the company's pricing policy. Prices can be set for different currencies, price (dealer) groups, specific customers, graduated according to quantity, etc.

In the description, we will also look at purchase prices to make it clear what  basis sales prices are based on.

Book Contents

Book Index

Purchase Prices

In the K2 IS, we register purchase prices in Article cards. We make use of these prices for instance in temporary article valuation before an Invoice arrives. We may edit and update the prices in various ways.

Book Contents

Book Index

Article card - Purchase prices

Purchase prices are defined on the 2nd page of Article card.

pim_338.png

Picture: Article card - 2nd  Page

Description of the fields on the 2nd page of Article card is defined in the User Guide of the K2 IS.

The purchase price, purchase cost, planned stock price and amount of overheads are defined there.

The meaning of purchase prices in IS K2.

There are several variants of setting the stock price in the purchase documents. The ideal case occurs when you have a confirmed Invoice to a received article firstly. This price from  the Invoice is also the price of a receipt on stock (the price in the S field on the item of a Receipt Card).

If any of the items of a Receipt Card are not on the confirmed Invoice, it means that the Invoice price is not determined exactly; the Planned Stock Price from the Article card is entered into the stock price of the item. This entered price can be edited. If you confirm a Receipt Card earlier than an Invoice, the system notifies you and the receipt will be executed in a price that is defined in the S field on the Receipt Card item. Then the Invoice price will be saved only in the Invoice and it does not change the Stock price of the Receipt card any more. In this case, the stock price on a Receipt card  will be edited later when Stock Recalculation. It can be run from the initial menu from the Module - Administrator - Recalculations - Stock Recalculation menu.

Pl. stock price from an Article card will be used in the Purchase documents if the price of the receipt article is not defined by the price from an Invoice In. This price is further used when pricing products with fixed prices.

Price entered in Field Purchase price field is automatically inserted into the order price (field O (net price / MJ) on the purchase item) and into the invoiced price (field F (net price / MJ) on the purchase item). If the Give the last price in purchase option is activated in the User Parameters, then the price from the Last price field is entered into the Order, it means the price from the last confirmed Invoice In. In the case, that the Supplier price lists are defined, the price defined in the Purchase price field is not entered into a price of Order (the O and I fields).

In The even that user wants to include the acquisition incidental costs in the article stock price, enter the actual amount of those costs into the C field (Net price / UM) on the purchase item. After executing the Stock Recalculation, these incidental costs are projected into the stock price. (In  the Client Parameters is necessary to activate the option Stock Price with Incidental Costs).

Planned incidental costs related to the acquisition of articles and that are defined in the Purchase Costs on the Article card, will be inserted into the Purchase item into the field In (Net price/UM) in case that the Stock price with Incidental Costs. In the case when you allocate the real incidental costs into the Purchase item by means of the Allocation of Incidental Costs function, the value, that has been inserted from the Article card, will be deleted.

Book Contents

Book Index

Update the purchase price on the Article card

On the Article card there are lots of fields or columns that are necessary to be updated by means of recalculation.

Book Contents

Book Index

Updating the Sliding price field

The Sliding price filed is calculated as a current contribution of a value of Article on a stock and an amount on the stock. You can also update it by the Stock Recalculation function.

When pricing the stock by prices according to batches, the Sliding price field has no importance.

Example

A firm that prices with the sliding price has done the following stock movements:

1st February

receipt

1 pc

per 5 EUR

15th February

receipt

1 pc

per 4 EUR

16th February

release

2 pc

per X EUR

28th February

receipt

1 pc

per 3 EUR

10th March

receipt

1 pc

per 6 EUR

20th March

release

1 pc

per Y EUR

30th March

receipt

1 pc

per 5 EUR

By which price will be priced the releases from 16th February and 20th March and which will be the sliding price to the 31st March?

Solution:

The Release price of 16th February:

2 pcs are currently in the stock,  1 pc per 3 EUR and 1  pc per 6 EUR, it means the release price is calculated as (1pc * 3 EUR + 1 pc * 6 EUR)/2pcs = 4.5 EUR.

The Release price of 20th March:

2 pcs are currently in the stock, 1 pc Per 3,5 EUR and 1 pc per 7 EUR, it means the release price is calculated as (1pc * 3,5 EUR + 1 pc * 7 EUR)/2pcs = 4.5 EUR There is also the 1pc on the stock that is priced by a sliding price that is 4.5 EUR.

The sliding price to 31St March:

On the stock there are 2 pcs of articles, 1 pc per 4.5 EUR and 1 pc per 5 EUR. The sliding price is also (1 pc*4.5 EUR + 1 pc*5 EUR)/2 = 4.75 EUR.

Book Contents

Book Index

Update planned stock price

It is necessary to remember that the Planned Stock Price on the 2nd page of the Article card does not have to correspond with a stock price on a purchase item and a stock card.

A Planned Stock Price on the 2nd page of an Articlecard can be updated via the Recalculate Stock Prices function. You can run this function either over a specific Article (i.e. over the 1st - 9. Th page of this Article card) or on Articles container from the Action - Stock price recalculation module menu.

It is necessary to update it regularly in the case when you use the stock price to define the selling price (see the Margin chapter).

pim_210.png

Picture: The Recalculate Stock Prices form

By means of the recalculation, the stock price is updated according to the last, a current, a sliding, a purchase price, a price of an optimal supplier or a net price of an optimal supplier, some of which of these values are displayed in the fields on the 2nd page of an Article card. The detailed description of this function is stated in the Basic manual in theForm - Actions - Articles chapter.

Book Contents

Book Index

Example: Definition of purchase prices

Example: You will buy a men's leather briefcase. Insert a new card for this article firstly. The supposed purchase price is 300 EUR. The incidental purchase costs are not supposed. The stock price will be also 300 EUR. Issue an Order for this article on the 300 EUR. Invoiced and Stock price is automatically predefined on 300 EUR.

pim_211.png

Picture: Purchase Order - Purchase item form

pim_212.png

Picture: Invoice In - Purchase item form

pim_213.png

Picture: Card Article - Purchase prices -2. Page

The Planned stock price has not been altered. The Last price is the price from the confirmed invoice. The Sliding price is calculated according the price in the Receipt card.

Neither the stock price has been changed in the Purchase item. Execute the Stock recalculation. It is necessary, to this stock price match the reality.

pim_356.png

Picture: The Purchase item form after Stock Recalculation

The recalculation has updated the Sliding price on the Article card.

pim_355.png

Picture: Article card - 2nd Page - after Stock recalculation

If you want to set the price as a Planned stock price, use the Stock price recalculation function. We run the recalculation in status Browse in card Article for briefcase from the Action - Stock price recalculation module menu.

Book Contents

Book Index

Supplier Prices

Supplier prices enable us to register fixed prices that were agreed on with concrete suppliers. These prices are then automatically filled in the Purchase Item when we select an article and a supplier corresponding to the set definition of supplier price. The using of supplier prices may be overridden by the user parameter Do Not Use Supplier Prices.

Book Contents

Book Index

Supplier Prices

Defining of supplier Prices in IS K2 is used for the case when a business partner delivers goods by the system of fixed prices and its adjustments according to the product groups, multipliers and the codes of article. Supplier price is valid for the currency for which it is defined.

Supplier Prices are register on 4. Page of card Article or on 5. Page of Suppl./Cust. card (eventually, we define supplier date prices on the 8thpage of the Suppl./Cust. card).

If we add supplier prices on the 4th  page of the Article tab, these prices will be displayed on the 5th  Page of Suppl./Cust. card It is also true that if we define supplier prices on page 5  Page of the Suppl./ Cust. card, then these will be displayed on the 4th. page of an Article card.

Picture: Article card - 4thpage Page chapter).

This page of Suppl./Cust. card is accessible in the Changemode and in a New Record as well. By pressing the Ins key or the Insert button, we define new supplier prices to a card via the Supplier Prices form.

Picture: Form Supplier Prices - 4 page of an Article card

Descriptions of the individual fields of Supplier Prices form are stated in the User Guide of the K2 IS.

Complete the individual fields with the data from a supplier. A Supplier Product Group is always assigned to a given supplier. Select a product group from the table Supplier Product Groups. There you can define a new product group by pressing the F6 key (or Ins), or change (including multiplier values) whichever product group by the F5 key. We We have an option to set multiplier values and rounding within a Product Group, which will be applied to the calculation of net purchase price.

Multiplier is a figure that provides the option to take various variances of supplier prices into consideration (discounts,... - multiplier <1; transport, surcharges >1 etc.). You may assign 4 factors to each Product Group, which will further project into the net purchasing price of articles via multiplying all coefficients and the entered price. For instance, if we select one multiplier =0,5 and we do not enter the others, then after entering the price of 100 CZK the final net price will be equal to 100 x 0,5 = 50 CZK.

We can run the Overview of Supplier Prices report over the Article card/book. This report will show the overview of prices that have been defined for individual suppliers.

Example: We have a Purchase Order for a supplier for whom we have defined supplier prices. The currency of the Purchase Order is GBP, but the supplier prices are defined in EUR.
The supplier prices will not be completed into the Purchase Order, as the currency of the price is not identical with the currency of the document. In this case, the price defined in the Purchase Price field from the Article card (if set) will be completed into the Purchase Order. If we want the supplier prices to be completed also in the CZK currency, they must be defined in this currency.

Book Contents

Book Index

Supplier Card - Supplier Prices

Inserting supplier prices on the Supplier Card is similar; however, instead of choosing a supplier, we choose article to which the price is applied. Prices set in this way will then appear also on the Article card.

PIM_656

Picture: The Supplier Prices form from the Supplier card

Book Contents

Book Index

Selling Prices

Selling prices can be entered using Price Lists (they must be activated in the Configure Price Lists) or in the original way. The description of Price lists is stated in the chapter Sale / Basic data / Price lists. The following chapters deal with setting the selling prices in the original way.

We have several means at selling prices that allow us to merge our customers into groups and correctly evaluate their sales orders according to their classification or contracts. Customer prices are the prices of certain groups of articles for specific customers (in the picture below the relation no. 3). Customer prices are determined by the direct relationship between the articles and the customer (relationship No. 4 in the picture).

PIM_657

Picture: Price Creation options

Book Contents

Book Index

Elementary Devices for Definition of Sale Prices

Among the important elements of a company's price policy of sale belongs margin, product groups and price groups. Following options offer various parameters and flags.

Book Contents

Book Index

Margin

The selling price can be determined as the sum of the acquisition costs and the surcharge. The surcharge can be entered either in absolute terms or as a  percentage of the acquisition cost. In addition to the term surcharge, the margin is further defined, which is given as the difference between the selling price and acquisition costs, or as the ratio between the selling price and  the acquisition cost of the articles.

Note: IS K2 does not work with  the term surcharge, but a bottom or top margin is used. Therefore, we will use the term margin in  the next interpretation.

The margin can be entered either in absolute terms or as a percentage. Insert a new margin into the price list via the Ins key or the F6 key.

Picture: Form Margin - 1. Page chapter).

The description of the fields is stated in the User Guide of the K2 IS.

The initial price is the basic price from which the calculation of the selling price is based. The offer displays the purchase price, net purchase, supplier (from the optimal supplier), sliding, last, sales, stock or actual.

Note: All types of prices are displayed in the offer, but not all of them make sense as basic. E.g. the selling price cannot be based on the "selling price" value, so we will not use this option.

Book Contents

Book Index

Price groups

In the database of Suppl./Cust., customers are divided into different price levels according to the so-called price groups. This enables the members of different price groups to assign various discounts or surcharges.

Insert a new price group via the Ins key or the F6 key.

Picture: The Price Groups Code List

Picture: Price Groups - 1stpage Page chapter).

The description of the fields is stated in the User Guide of the K2 IS.

When entering the optimal number of a price group, we must consider whether these groups are sorted, and whether we work with their gradation or create them randomly. This affects the use of the Unsorted Price Groups Client parameter. This parameter affects the procedure for setting the selling price in case the price is not defined directly for the selected price group.

Example: We have the article 'Telephone' with a price defined only for the M1 and M2 groups (see the figure above: Price Groups Code List). We wish to sell the Telephone to a customer who has the C1 group. If we activate the Client parameter Unsorted Price Groups, basic price from the catalogue will be added automatically if the price for the C1 group is not found. If you turn off the parameter, the price with the closest lower number will be added, i.e. the M1 group price.

Book Contents

Book Index

Product Groups

Product groups divide the Article database into groups and, from the viewpoint of pricing, we treat them identically.

Picture: Product Groups Menu Table

Insert a product group to a menu table via the Ins key or the F6 key. You cannot delete a product group from  the menu table.

Picture: Product Groups - 1stpage Page chapter).

The items of the product group, which we enter on the 1st  page with the Ins key, determine the discounts for price groups or specific customers.

Picture: The Product group item form

Descriptions of the individual fields of the Product Group Item form are stated in the User Guide of the K2IS. the User Guide of the K2 IS.

To delete a product group item, use the Del key in the Change mode.

Book Contents

Book Index

Related Options, Parameters and Flags

In the case of Batch records, we may choose the option Selling Prices According to Batches on the 2nd page of the Article card. We can also select the flag Customer Prices in Product Group which will lower the number of records in selling prices on the Suppl./Cust. card, and the price will be numbered when it is used in accordance to a definition in the product group.

In the User Parameters, we may further set whether we wish to insert the price in the Sales Order according to the main customer or addressee (Customer Prices According to Addressee), whether the selected user even uses customer prices, or if it always should be derived from the basic selling price (Do Not Use Customer Prices). We may also override the display of stock and catalogue prices in Sale items (Display Catalogue (Price List) Price and Do Not Display Stock Prices in Sale). We can further choose whether we wish to copy the price group from the document header or a previous item into the items (Price Group on Item from Header). If we select a copy from the document header, we may specify whether we wish to keep the original price group in the item, or if we want to insert the resulting price group (Insert the Resulting Price Group). If we activate this parameter, it may occur that the Price Group field in the Sale Item will be empty - this is how the customer price or eventually the price written directly into the Sale Item manifests.

We may now take a closer look at the picture from the introduction of the chapter about Selling Prices - in the picture on Demonstration Data of K2: Link 1 defines the price of groups of Article (Product Groups) cards for the group of Customers (Price Groups). Link 2 values a specific Article card for the groups of Customers. Link 3, on the other hand, defines the price of the Article group for a specific Customer. The last relationship defines the price of one Article card for one specific Customer. There is one last option - writing the price directly into the Sale Item. However, with regard to the fully automatized process of price creating, this option is not essential.

PIM_658

Picture: Price Creating Options in Demonstration Data

Beside the Price Group field, there are icons displayed in the Sale Item. Both these elements facilitate orientation in the way in which the price has been defined. General description of these icons is provided in the User Guide to K2 IS. Here, we will list several particular examples.

Price group filled in, without icons

The price is defined by a product group for a price group.

PIC_007i PIC_006i

The price is defined by a product group for a specific customer.

Price group filled in, PIC_006i

The customer has set a different price group than their own one from the Article card for the given product group. I.e. The price in the product group is defined as a basic price that is in fact a different price group; the price is not edited anymore.

PIC_005iPIC_006i

The price for a specific customer is written to a specific Article card.

PIC_005i

The price is written directly into a Sale Item.

Book Contents

Book Index

Article card - Selling prices

If the new price lists are not activated (for more details see Sale / Basic Data / Price Lists), then on the 5th page of the Articles card we define both permanent and date selling prices of the selected article.

At the upper part of the screen is the header of the selected article, in the middle you can define selling and date prices. At the bottom of the screen, there is a list of prices for each customer or price group corresponding to the selling or date price, on which the cursor in the central part of the screen is placed.

Picture: Article card - 5thpage Page chapter).

Book Contents

Book Index

Preparing of the price list

By pressing the Ins in the Change Mode in the middle part of the screen, we open the Price List Preparation form. In the 1st line the basic sales price is entered, in next lines the date prices.

We select respective margin (or eventually selling price) and a product group in the Price List Preparation form.

Picture: Form Price list preparation - 5 page of an Article card

Descriptions of the individual fields of the Price List Preparation form are stated in the the User Guide of the IS K2.

Upon leaving after a change in the field Margin, the user is asked whether the selling price stated on this form should be recalculated. The same goes with the query after leaving the Product Group field and finishing work with the form, where the user is asked whether they wish to recalculate price groups. In the bottom part of the 5th page of an Article card, the prices for price groups defined within the product group will be stated here after recalculation; that is, if the cross Customer Prices in Product Group is not ticked on the given Article card. In that case, the prices will not appear in the bottom part. The price will be enumerated when it is supposed to be used according to its definition in Sale. An advantage is the overview on the 7th page of the Supplier / Customer card, where the prices defined by a product group are stated in one part, while the customer prices defined directly by the Customer - Article relationship are stated in another.

The resulting selling prices derived from this form is also called Basic Selling Price. This selling price is then inserted in the moment of creating a new Sale item into this item as Catalogue Price. The user cannot influence its value or further recalculate it. If the Sale in Foreign Currency option is checked in the form and the currency of the document is identical, the Catalogue Price defined this way will be pasted into the document. If the currency of the selling price is different from the one on the document, the Catalogue Price will be transferred in the Client's currency and subsequently recalculated according to the exchange rate of the document.

Book Contents

Book Index

Article Prices

In the bottom part of the 5th page of Article card there are displayed data that relate to price groups setting, alternatively to customer prices. You can set the prices in two ways:

Picture: Form Article Prices - 5. page of an Article card

Descriptions of the individual fields of the Article Prices form are stated in the User Guide of the IS K2.

Book Contents

Book Index

Display Selling Prices

Selling prices may be browsed in several ways:

Book Contents

Book Index

Buyer Prices

We understand Buyer Price as a selling price of group of Articles defined for a specific customer.

Customer Price is then the selling price of a specific article for a specific customer.

Buyer and customer prices we define on 5. Page of card Article or on 7. Page of Suppl./Cust. card

pim_351.png

Picture: Buyer Prices - 7. The Suppl./Cust. card

On this page, we enter the records via the buttons Delete, Edit and Insert in the Browse mode. After pressing the button Insert or Edit, the form Product Group Item, or eventually Buyer Article Prices, is opened, according to the part in which we set the light indicator. In the upper table, we define buyer prices. We write in a new item of a product group. This method is an alternative to creating product group item from this group; the record is subsequently projected on both locations. Closer description and purpose is provided in the preceding chapter.

In the bottom part of the form, all prices defined for a specific customer are displayed, or only the customer prices (this depends on the features of the given Article Buyer Prices in Product Group).

Picture: Customer Article Prices form

Descriptions of the individual fields of the Buyer Article Prices form are provided in the User Guide of the IS K2.

Book Contents

Book Index

Example: Definition of Selling Price

Example: A company produces and sales two kinds of articles: flowers and vegetables. These articles are sold to he retailers and  wholesalers. Retailers and wholesalers can have defined various surcharge for various kind of articles.

PIM_611.png

Picture: Product and Price Groups

The basic selling price is based on the stock price to which a 25 % margin is added. Flowers and vegetables are sold to ordinary customers at this price. The firm sells to the permanent - registered customers flowers with 5 and vegetables with 12% discount. For wholesale, the price is 12 % lower for flowers and 18 % lower for vegetables.

Solution:

PIM_357

Picture: 'Gardening' margin

PIM_358

Picture: 'Regular Customer' price group

PIM_359

Picture: 'Wholesale' price group

PIM_360

Picture: Form of "Flowers" product group item for "Regular Customers"

pim_361.png

Picture: Form of "Flowers" product group item for "Wholesale"

pim_362.png

Picture: Form of "Vegetables" product group item for "Regular customers"

PIM_363

Picture: The Item of product group 'Vegetables' form for 'Wholesale'

pim_364.png

Picture: The Bulk change of articles form - 2. Page chapter).

PIM_365

Picture: The Recalculate Article Prices form

The function calculates a selling price according to a defined margin and a product group on the individual Article cards for both price groups.

This function is also used for a regular update of a selling price on an Article card.

After defining the selling prices in  IS K2, you can print the Article Price List. Above the filter of the Articles for flowers and  vegetables cards, print the report Price list of article.

PIM_397

Picture: The Article Price List report

Selling prices that are defined on the 5th page of the Article card are displayed in the report. In other words, it is an input price adjusted for margin or a directly defined selling price.

If you want to display  also the prices that have been adjusted according to a defined surcharge (discount) for the selected price group or for the supplier in the price list, print the Price List for Customer report over the selected customer or over the filter of customers.

PIM_398

Picture: The Price List for Customer report

The selling prices for a specific customer are displayed in the report. Category of prices (e.g. Catalogue, Supplier - a price group is displayed) displays a way how the result price has been determined.

Date prices are not taken into account in the reports.

Book Contents

Book Index

Example: Definition of Buyer and Customer price

Example: A company and its greatest Buyer (i.e. Bravo company) have agreed on the following trade conditions:

1. The Buyer is granted a 15% discount on flowers. . When purchasing more than 50 pc of the same article, the Buyer will achieve a 20 % discount; with purchase over 100 pc, a 25% discount will be provided to the Buyer .

2. The Buyer is offered a 15% discount on vegetables . If the Buyer purchases more than 20 pc, he/she will get an 18% discount .

3. The 'Fried almonds' article is provided to the Buyer for the selling price of 24 CZK . When purchasing 2 pcs, the price for 1 pc will be 22 CZK.

Solution:

Point 1 and 2 are filled in by a buyer price. Point 3 means to define a customer price.

Customer Price:

In the previous examples, we defined selling price for flowers equal to a stock price + 25 % margin and the product group 'Flowers'. Now we add three more items with buyer prices to this product group for the Bravo company.

pim_379.png

Picture: Product Group Itemfor buyer price for purchase up to 50 pc

pim_380.png

Picture: Product Group Itemfor buyer price for purchase over 50 pc

pim_381.png

Picture: Product Group Itemfor buyer price for purchase over 100 pc

We proceed similarly with Vegetables. We add two more items for buyer prices into the 'Vegetables' product group.

pim_382.png

Picture: Product Group Itemfor buyer price for purchase up to 20 pc

pim_383.png

Picture: Product Group Itemfor buyer price for purchase over 20 pc

We Recalculate Article Prices over the Article filter in which are the Article cards with the product group 'Flowers' or 'Vegetables'; there, we also Recalculate Buyer Prices.

pim_384.png

Picture: The Recalculate Article Prices form

We can see the defined prices on the 7th Page of Suppl./Cust. card If the cross Buyer Prices in Product Group is checked on some of the Article cards, this article would not have its records in the bottom part of the form. During its sale, the definition directly from the product group would be applied.

pim_387.png

Picture: The Suppl./Cust. card - 7. thpage - Buyer Prices

Customer Price:

What remains to do is to define a Buyer Price for 'Fried Almonds'. We enter it on the 7 Th page of the Suppl./Cust. card in the bottom part of the screen via the button Insert(x); we can do the same on the 5th page of an Article card in the bottom part of the form.

pim_385.png

Picture: Buyer price for 'Fried Almonds' when purchasing up to 2 pc

pim_386.png

Picture: Buyer price for 'Fried Almonds' when purchasing up to 2 And more pcs

Defined prices are completed on the 5th page of the Article card as well.

pim_388.png

Picture: Article Card - 5th Page chapter).

Book Contents

Book Index

Example: Change value settings to calculate the sale price

Example: The company changes the pricing policy for vegetables. So far, the selling price has been calculated as stock price + 25% margin, the company sells vegetables to steady - registered customers with a 12% discount, for wholesale, the price is 18% lower.

Newly the firm wants to create a selling price with a margin of 30 % to the stock price. The company will then provide a discount of 14 % for wholesalers and 8% for steady customers .

Solution:

pim_366.png

Picture: Margin 'STOCK+30%'

pim_368.png

Picture: The edited items of the 'Vegetable' Product group

pim_369.png

Picture: The Bulk change of articles form

pim_370.png

Picture: The Recalculate Article Prices form

Book Contents

Book Index

Date Prices

The so-called Date Prices are another tool of price policy. Its are prices whose are valid at concrete date. Date prices are defined in the same way as sales prices on the 5th page of an Article card with difference that in the Price list preparation form we state the date from - until which the price is valid, ie the period of validity of the price.

pim_345.png

Picture: Date Price in the Price List Preparation form - 5th page of an Article card

Outside this set interval, permanent prices are valid, i.e. basic selling price and prices derived from it, to which there is no date defined (i.e. it is in the format '0/0/0000' or eventually '31/12/3000').

In order for the date price to be automatically inserted into the items of the order and invoice out, it is necessary to  have the Use online prices of article item field checked in the Client's Parameters.

We methodically recommend not to overlap the date prices. When evaluating a valid price, the price whose Date From is newest will be found, i.e. the price which started yesterday takes precedence over a price that started three days ago. The evaluation will decide whether the price is still valid (meets the Date To). If the price is not valid anymore, a general price will be used regardless of the fact that there could be another existing date price. At the same time, if there are more existing prices starting on the same day, the price that is valid and ends the earliest is used. If none of the date prices is valid, a price with no entered end date will be used.

Book Contents

Book Index

Hot Deals

Example: A company has defined current price for the article 'Radishes' (the date is in the format '0/0/0000'), which is derived from the set selling net price 5,75 CZK; the discount of 14 % is granted to wholesalers, 8 % discount is granted to regular customers (product group 'Vegetables').

pim_371.png

Picture: The Price List Preparationfor basic price

In addition, a date price is defined for 'Radishes' that is valid from 1/8/2009. Its validity to  date is not set. This date sale price is defined as the acquisition price including acquisition costs + 20 % margin ,wholesalers - the discount of 20 % and for steady customers 10 %. The Purchase price of the article is 3,90 CZK and it is necessary to add 10 % of purchase costs.

Thus, the 'Hot Deal' margin and 'Veg_deal' product group are activated.

pim_373.png

Picture: Margin 'Hot Deal'

pim_374.png

Picture: Product group 'Veg_deal'

pim_372.png

Picture: The Price List Preparation form for a date price valid from 1/8/2009

A company has decided to organize a 'Vitamin Week' event at the start of the school year - Radishes will be reduced from 1/9/2009 to 7/9/2009 from their special offer to regular customers and wholesalers with a discount of 20 %. As the default price we use special offer, i.e. the 'Special Offer' margin.

Solution:

pim_375.png

Picture: Product Group Item'Hot Deal 09/2009' for 'Regular Customers'

pim_377.png

Picture: The Price List Preparation form for a date price valid from 1/ 9 to 7/ 9/2009

Define a hot deal for radishes. This date price will be valid from 1/ 9 to 7/ 9/2009 and temporarily cancels the validity of date price set from 1/8/2009.

Book Contents

Book Index

Discounts

During Sale, we may also grant a one time discount for a specific Sale item, for selection or for every item of a given document. We may enter an absolute discount or a percentage discount. An absolute price is always entered as a unit one. This means that if we sell 5pc and enter a discount of 10 CZK, the result discount on the item will be 50 CZK.

We can also enter a discount directly in the Sale Item in the Discount field and eventually by checking the % flag, or do so in bulk on more items via the Bulk Change of Items button, which is available in the Change Mode on the 2nd page of all Sale documents. After pressing this button, a form for bulk change of data in items will appear. Check the 'Discount' cross, write in the value of the discount and eventually check the '%' flag. Here we may also choose whether we wish to apply this change to the current, marked, unmarked, non-filled in items (i.e. without discounts), or to all items. Finish the change via the OK button. The discount will appear in the Discount field in the Sale Item and also in the S column with the flag pic_249i or pic_250i in case of surcharge.

Data about the discount may be entered also in the field Change of Discounts of Items next to the Edit button; in this case, they will be pre-completed into the open form.

pim_367.png

Picture: The Bulk Change of Items form - entering a discount

Closer description of the form and the discounts is provided in the User Guide to the K2 IS in the chapter 'Purchase/Sale Items'.

A discount defined this way may be highlighted (individually numbered) in printed documents at individual items.

Note: There is also a button called User Discount of Items in the form. This becomes active if a special script called UsrReduction.pas exists. This button enables to consider various specifications of the individual firms and users of K2.

The discount is applied on both Sales Order and Invoicing prices. The option of applying a discount is subject to the same rules as the manual edit of Sale prices in the Sale Item. If a Sales Order price is unavailable (e.g. due to confirming a subordinate document), the price will be applied only to the Invoice price and the flag F Price Only will be checked. In that case, the Sales Order price will differentiate from the Invoice price. A repeatedly entered discount does not load, it is overwritten. If we set a discount of 10 % and later decide to change it to 15 %, we enter the result value into the Discount field, i.e. '15'.

If we want to apply such discount for a customer regularly, we can set the discount rate on the 1st page of a Suppl./Cust. Card in the Discount field. In such case, the value from the Suppl./Cust. Card will appear in the documents in the Change mode. The user then decides whether or not to apply the discount. Only after applying the discount (i.e. via the Edit and following OK button) the change will manifest in the prices of documents.

The whole methodology can be used analogically also in Purchase to mark a received discount, if we wish to e.g. numerate it individually.

Book Contents

Book Index

Example: Discount set on a Sale document item

Example: A company has decided to grant a discount of 20 % on a Sales Order that is being processed (1000pc of big roses).

Solution:

No preparation is needed for granting a discount. We create a Sales Order with the item 'Big Rose', to which we wish to apply a discount of 20 %. We write in the discount into the Discount field.

pim_464.png

Picture: The Sale Item form for 'Big Rose'

Continuation: The customer has decided to expand the Sales Order - add also 500pc of Blue Roses. As the customer expanded the Sales Order, the company has decided to raise the discount on all items to 25 %.

Solution:

In the Sales Order, we create a 2nd item for the requested article. This time, we will not enter the discount directly in the item, but will use the option of bulk correcting the discount on all items.

Into the Change Discounts of Items field, we enter the value '25' and check the % field. Next, we click on the Edit button. A form with the entered data will appear. We leave the variant All Items checked and press the OK button. The discount of 25 % will be inserted into all items of the given document.

PIM_500

Picture: The Bulk Change of Articles form

Book Contents

Book Index

Recalculate Prices

Price recalculation enables the user to manipulate with prices in bulk. To run them, you will need the right Run Price Recalculation in Articles in Administrator - part General.

Book Contents

Book Index

Recalculate Article Prices

This offers an update of article prices, i.e. of purchase prices and basic selling price, as well as price groups and customer prices. It also allows you to create a date price based on the calculated values.

The function is run over one Article tab (i. e. over a page other than 0 .) or over the Article container from  the menu of the Action - Recalculation of article prices module.

Picture: The Recalculate Article Prices form

Descriptions of the individual fields of the Recalculate Article Prices form are provided in the User Guide of the IS K2.

Book Contents

Book Index

Recalculate Customer Prices

This function enables the user to recalculate customer prices of one specific customer for all the Article cards in a container. It is possible to change the method of the calculation of the customer prices by means of the recalculation (edit min. purch. quantity for this price - the Quantity field, the default price - the Base price field, percentage of a surcharge or discount - the Surcharge field).

The function is run over one Article tab (i. e. over a page other than 0 .) or over the Article container from menu of the module Action - Customer price recalculation and recalculates the prices of the selected customer according to the set parameters in the Customer price recalculation form. These changes are reflected in the bottom part of the page 5  of the Article card, no into the Product groups.

Picture: The Recalculate Customer Prices form

Descriptions of the individual fields of the Recalculate customer prices form are stated in the User Guide of the IS K2.

Book Contents

Book Index

Article Repricing

It executes the change of prices of articles selected into the container. This change (percentage surcharge) is offered for Supplier Prices (according to the selected supplier), Purchase Price, Selling Price, Price Groups (it is possible to define an interval of the price groups that should be corrected), as well as Customer Prices (again for the selected customer).

The function is run over one Article tab (i. e. over a page other than 0 .) or over the Article container from the menu of the Action - Repricing of article module. It is also possible to create date prices there. The prices can also be rounded according to a defined order and constant.

Picture: The Articles repricing form

If you run the recalculation by using the Recalculate button, the prices of the articles in container are recalculated and the articles will be removed from the container.

Book Contents

Book Index

Change Exch. Rate and Recalculate Prices

This function enables to change purchase and selling prices of each articles in container, prices of which are defined in the selected currency (article that uses the other currency for pricing, remains in the original prices).

The function is run over one Article tab (i. e. over a page other than 0 .) or over the Article container from module menu Actions - Change exch. rate and Recalculate Prices

Picture: Form Change Exch.Rate with Recalculate Prices

When the Purchase Prices or Sales Prices fields are checked, the function recalculates prices in  the base currency according to the exchange rate entered in the form Change rate with  price recalculation. If these fields are not checked, only prices in the selected foreign currency will be recalculated.

Book Contents

Book Index

Bulk actions - Change record

The function is run from the module menu Form - Bulk actions - Change record on the Articles container or on the records indicated by asterisks. It serves to the bulk changes on the selected articles.

The fields important for pricing are stated on the 2nd page of The Bulk change of articles form

pim_364.png

Picture: Form Bulk change of articles- 2. Page chapter).

By checking the fields Currency and Exch. rate, prices according to the selected currency and exch. rate will be recalculated. You can choose whether the change relates to purchase or sales prices.

Note: Unlike the Change exch. rate with  recalculate prices function, this function may also change a currency.

Further, it is possible to change all data, related with a price making, in bulk for the Article container, whereas a selling price will be edited after running the Recalculate article prices function.

Book Contents

Book Index

Recalculate Date Prices

To change current prices to date prices, or to change date prices to current prices, use the Recalculate Date Prices function that is activated from Module Menu - Actions - Recalculate Date Prices. This function may also be used to change the date of a date price (i.e. both borders of the action), or it is also possible to delete the date price set for a given interval.

Picture: Recalculate data prices form

Descriptions of the individual fields of the Recalculate Date Prices form are stated in the User Guide of the IS K2.

Book Contents

Book Index

Overview of parameters and selected fields that relate to the price creation of the K2 IS

This chapter involves the useful flags and parameters that can influence behaviour of the K2 in the price creation. It is not the complete list and simultaneously you cannot find here an exact description. For detailed studying use this methodology or User Guide of the K2 IS - the Basic modules, Shared Purchase and Sale Elements and Administration - User parameters and Client parameters section.

Purchase

User parameters

Client Parameters

Sale

Article Card

User parameters

Client Parameters

Date Prices

Client Parameters

Book Contents

Book Index

EKOKOM - Records of packaging materials for the report on packaging production

Components of the Contract on Joint Performance between the Authorized Packaging Company EKO-KOM, a.s. and the company selling the packaging or packaged article (or the liable person) is a quarterly report on the production of packaging.

The filled statements are used to:

The report consists of two parts:

Based on the procedures set out below in IS K2 it is possible to prepare documents for filling in the report on packaging production.

The principle of the tool used  for the registration of packaging in  IS K2 is a list of packaging (type, quantity) on  the Article card, which is linked to the  sale or purchase of these article. The function that processes invoices out (or release note) on the sales side or then received invoices (receipts) on the purchase side, then calculates the data for each type of packaging. The Ekokom - Export to Excel function (launched from the Scripts and Reports book) will then allow the export of the calculated data to the current Excel file, which is published by EKOKOM every quarter.

Book Contents

Book Index

Financing of E-waste collection - recycling fees

According to the amendment to the Waste Act, producers have been obliged to ensure the take-back, treatment and disposal of old electrical appliances since 13 August 2005. The cost of this system is to be covered by the recycling surcharge, which will be listed separately on the receipt for the purchased product.

In IS K2, information on the amount of the fee is provided on the Article tab in  the universal forms in the Basic Information on the Electrical Waste tab. Based on the entries in this tab and the registered function, an additional purchase/sale item with the enumerated recycling fee value will be automatically created for the item with an article requiring the recycling fee in the purchase documents (purchase orders) and the sales documents (sales orders).

Recycling fee registration works in IS K2 under the following conditions:

Book Contents

Book Index

E-waste Tab

Information on the existence and amount of the recycling fee is stated in universal forms on the Article card in the Basic Data on the E-waste tab. It is therefore necessary to insert a record representing the waste on the E-waste tab on the article card (electrical appliances).

pic_4535

Picture: The E-waste tab on the Article card

PIM_587

Picture: The E-waste form

Field Description:

Abbr 1

The article card of non-stock items type, it has a 21% VAT rate, the E-waste brand and further in abbreviation it carries information about the group of electrical equipment that it represents. The following pictures show how these cards can look like. (It is not necessary to follow the proposed structure of the abbreviation, as well the cards could be named EO_3.1, EO_3.2, EO_3.3, ...).

This field is obligatory.

Additional name

If we select only one card for the group (in the example, these are cards 3.1 to 3.6), then it is possible to specify the item on the invoice by means of an additional name. (Or you can choose the way, as cards 3.7_1 and 3.7_2, when the card carries detailed information about what type of electrical appliance it belongs to, and the additional name is then unnecessary.) It is also possible to choose the path of a single article card (non-stock items type) and then insert it into the document items. However, this can cause reporting problems, when it is necessary to report the sum of the groups specified in Annex No. 7 of the Act.

Price

Recycling fee in CZK, price excl. VAT. If the price is not specified, then the script inserts in the sale the selling price of the article card listed in the Abbreviation 1 field. In the Purchase, the price entered in the Purchase price field of the article listed in the Abbreviation 1 field.

Coefficient

Multiplier of a fee (e.g. for a luminaire that has 3 bulbs). If it is blank (0 is displayed), it does not enter into the calculation.

PIM_588

Picture: Demonstration of cards for recording recycling fees

Book Contents

Book Index

Bulk Adding/Editing of the E-waste Records

To facilitate insertion of E-waste record onto the Article cards, the Bulk Adding/Editing of the E-waste script was created (the technical details are stated below).

PIM_591

Picture: The form for bulk inserting, changing or deleting an E-waste record

1. Bulk creation of records:

In the Article container, fill in the right part of the form. Define the field values and activate it by ticking the field.

PIM_592

Picture: Using the script for a bulk insertion of E-waste records

2. Bulk change:

Fill in and activate a selection criterion in the left part of the form, then activate the fields that should be changed by the entered value in the right part. If you run the script in the Article book (in the 'Book' mode), then all the Article cards that contain an E-waste record complying the left part of the form,will be inserted into a container and they will be changed according to the definition in the right part of the form. If the script runs on the container of articles, then only those records from the filter which correspond to the left side of the form will be changed. Values are changed according to the right part of the form.

PIM_593

Picture: Using the script for a bulk change of E-waste records

3. Search and filter:

If you run the script in the Articles book in the 'Book' mode and you use only the left part of the form, then all the article cards, that contain the E-waste record complying the left part of the form, will be inserted into container.

PIM_594

Picture: Using a script to search for E-waste records

4. Delete all E-waste records:

The Delete All field works only in the Container mode. It removes all the E-waste records from the articles cards in container.

PIM_595

Picture: Using a script to delete E-waste records

Book Contents

Book Index

Adding a fee to a sales order

Adding the fees to sales orders is ensured by a registered function that runs the script Adding fee to sales order - E-waste. The script can be run separately without registered function. The technical details are stated below.

Registered Functions in the sales order book adds an additional sales item (or items, if there are multiple entries) to all new sales items, article cards of which have record in E-waste. The article, specified in the E-waste record, with price and name will be added. The price shall be multiplied by the coefficient and the quantity sold, taking into account also sales in alternative units. However, the charge is given for the quantity in the  base unit. If the price in the E-waste record is zero, the selling price from the E-waste card is taken.

If the item of the type Stock item is on an UNCONFIRMED invoice, then the created fee will be inserted on the same invoice.

Example:

PIM_596

Picture: The Sales order created in the standard way

PIM_597

Picture: A Sales Order after saving

The Sales Order items:

If the fee is deleted after saving the order, the registered function will not complete it (E-waste is added to new items only). If you change the sold quantity, the amount of fees does not change. This change must be handled by the user. After inserting fees on sales order, these fees are not checked any more.

PIM_598

Picture: Print of an Invoice Out including a fee

Book Contents

Book Index

Adding Fee to a Purchase Order

Adding fees to Purchase Orders is ensured by a registered function that runs the script Adding Fee to Purchase Orders - E-waste. The functionality in the Purchase module is the same as in the Sales module. The script can be run separately without registered function. The technical details are stated below.

Book Contents

Book Index

More Settings
Correcting Already Created Fees:

Considering the fact that registered functions create fees for E-waste only to new items and the additional quantity adjustments of items are not being taken into account, the Change Fee in Sales Order/Purchase Order - E-waste script has been created. If the user is on the 2nd page of a Sales Order (Purchase Order) and the document is not in the Change mode, the E-waste items that are not assigned to subordinate documents or that are on unconfirmed subordinate documents will be deleted and created again.

Posting Key:

It is possible to be set in the unity U_RegGlobalVarEO.pas; the template of the unit may be found in the directory K2\SESTAVYW\STANDARD\K2R under the name XU_RegGlobalVarEO.pas. This unit will be copied and pasted into the directory K2\SESTAVYW\STANDARD with the name U_RegGlobalVarEO.pas and will be filled in with rows with posting keys for Posting keys of Sale and Purchase. The posting keys identified by their own unique ID will be automatically inserted into the Sale (Purchase) Items.

 

Posting key_EO_ZAK = 0;

 

Posting key_EO_OBV = 0;

Restrain Creating of Fees in Books of Purchase or Sale:

Fees do not necessarily have to be inserted into Purchase or Sale documents in all books (rows), the creating may be suppressed in particular books. This may be set in the unity U_RegGlobalVarEO.pas in a way similar to posting keys.

Note: If it is the case of selling articles from e-shops, E-waste are by default inserted into documents from values of books in the variables Rada_EO_ZAK and Rada_EO_OBV. The support of these variables for e-shop requires the assistance of a consultant.

 

Rada_EO_ZAK = ''; //books into which the fees are not to be inserted

 

Rada_EO_OBV = ''; //separate the books by a semicolon, e.g. '10;20'

Book Contents

Book Index

Technical details

List of files:

Registered Functions:

Book Contents

Book Index

EDI - Sale

EDI.PAS - import / export of messages for electronic data exchange

The script works in Xml format

InHouse format is not supported

The script is used for:

Book Contents

Book Index

Installation

PIM_616.png

Picture: Settings of Order form in IS K2

Setting the path to files:

The path consists of  the period specified by the Edi_Dir parameter and the postfix with which the script works. The directory structure is created when the script is run for the first time.

The directory structure for the default settings will look like this:

C:\K2EDI\XML\IN\Orders

Directory from which xml orders are imported into IS K2

C:\K2EDI\XML\IN\IMPORTED

Directory where successfully imported xml orders are stored.

C:\K2EDI\XML\IN\RecAdv

Directory from which xml confirmation of receipt are imported into IS K2.

C:\K2EDI\XML\IN\BadAddr

Directory where incorrect xml orders are stored.

C:\K2EDI\XML\OUT

Directory in which all exported xml messages are stored.

Entering EAN codes in  IS K2 for K2 – EDI:

Customers

enter the EAN code on the  1. st page of the Suppl./Cust. card to field Abbreviation 2. EAN can also be entered in a special field. In this case is necessary to set the parameter BuyerEANField.

Articles

The EAN code can be entered either in the Abbreviation 2 field on the 1. st page of the Article card, or as a “bar code” on the  1. st page of the Article or on the 4th page of the Article in Supplier Prices as a supplier code. EAN can also be set in a special additional field, both on the 1st page of the Article card and on the 4th page. The parameter GoodsEANField is use for that.

EAN usage priority: If the parameter of the SupplierCode script is set to True (by default it is False), then the EAN, which is entered in the supplier codes for the given supplier on page 4 of the Article card in Supplier Prices, is used. If the GoodsEANField parameter is set, it is taken from the corresponding additional field. If no EAN is entered in the supplier codes, the EAN from the bar codes is used, if it is not entered here either, then the EAN from Abbreviation 2 is used.

If the EAN is entered in the barcode grid (multiple codes can be entered), the one with the EAN flag checked is used in EDI (and at the same time the warehouse unit is equal to the one on the document). If more than one EAN tag is checked, the first one is used, which meets the condition that the storage unit is equal to the one on the document.

Book Contents

Book Index

Script parameter:

Parameters description:

Parameter name

Data type

Description

Default value

AllowSameOrderNo

Boolean

True - Add to order number 001.002....

False

autoGen

Boolean

If it is True,then messages INVRPT will be created automatically.

False

AutomaticFill

Boolean

True - Automatic filling with appropriate invoices, delivery notes and stock levels

True

basicRate

Integer

The standard VAT rate. According to the abbreviation SR from the code list Periods and taxes. When exporting a document with a different basic tax rate than the implicit (SR), it is necessary to enter this tax in the parameters (numerical value).

 

BatchPath

String

Initial batch for data preparation

‘‘

bookOrd_from_delivery_ean

Boolean

The order import range is searched for CDo or CD1.

True

BuyerEANField

String

Parameter for specifying the field from the Suppl./Cust. tab, in which the EAN code is entered and from which this code will be read.

Abbr1

CDoToBuyer

Boolean

If the value is True, then the buyer is CDo, otherwise CD1.

True

CDoToDelivery

Boolean

If the value is True, then delivery spot is CDo, otherwise CD1.

False

CDoToInvoice

Boolean

If the value is True, then invoice spot is CDo, otherwise CD1.

True

CDoToOrderer

Boolean

If the value is True, then customer is CDo, otherwise CD1

True

ContractCode

String

Contract code.

-

CostCentre

String

Cost centre

-

ChangeCdoCd1

Boolean

If it is False, then the CDo belongs to the customer from buyer_ean. If it is True, then the CD1 belongs to the customer from buyer_ean.

False

CreateBookingNote

Boolean

True - Create a reserving Card.

False

DeleteOldLogFiles

Boolean

True - Each time you run the script, all previously created and saved log files are deleted (sales log files only).

False

DeliveryNoteOnInvoice

Boolean

True - Exports the delivery note number on the invoice.

False

DeliveryTerms

String

Shipping method.

-

DeliveryTime

String.

Time of delivery.

-

DisableEANFormatCheck

Boolean

True - Checking the EAN format for articles is suppressed.

False

Edi_Dir

String

Path to Exported and imported files.

‘C:\K2EDI\'

EDITEL_tag_interchange

Integer

Data in XML file header

0

EDITEL_tags

Boolean

If the value is True, then EDITEL_tag_interchange is added to the header

False

Export_VarS

Boolean

True - Exports a variable symbol (for invoices) instead of the invoice number in K2 form.

False

FillOrderLineNumber

Boolean

True - the "order_line_number" element in the ORDRSP message is being filled. The value from the OrigItemZ field from the invoice items is filled here.

False

foreign_ex

Boolean

If True, then the currency is taken according to the customer.

False

genTime

TTime

The time when INVRPT messages start to be generated.

23:59:59

GoodsEANField

String

Parameter for specifying the field from the article card from which the EAN code will be read (eg in the case of using a special field).

 

idTypeGoods_G

Integer

Item type number

1

idTypeGoods_P

Integer

Item type number - Packaging

4

impPrefix

Integer

Prefix

0

ItemPlaceOfDeliveryFromReleaseNote

Boolean

Yes - some fields are filled in from the release note when exporting the invoice; No - the field is filled in from the delivery note. These are the fields Delivery note number, Delivery note issue date, Delivery date and Delivery place.

False

MyEANCode

String

My EAM code.

999999999999.

MergePackaging

Boolean

True - Turns on the function of merging articles and packaging into one item

False

ModeOfTransport

String

Type of transport.

-

NoGoodsEANItemsSearch

Boolean

If the parameter is set to True, the script ignores (during import and export) the barcodes set on the 1st page of the article card (in the table).

False

OldAddressFillingLogic

 

False - the invoicing and delivery address is always exported exactly according to the settings of these addresses in the IS K2 documents. Also during import, these addresses are filled according to the addresses specified in the imported "* .xml" file. If the addresses are not listed in IS K2 or in the imported file, they are not filled in. If the parameter is set to Yes, the address filling logic does not change.

True

paymentMethod

String

Payment method on sales orders

“Transfer”

PoznCiDLV

String

The type of note in the book that defines the format of the delivery note number.

E.g. the format KKYY @ CI (NXX) is inserted into the CD type note (Note type "description for 60 characters"), where the characters 'KK' serve as the book identifier (eg series '10'), the characters 'YY' represent the prefix (eg . '10' for the year 2010), XX is a number in the form eg '06', which defines the number of places for the document number.

Example: If a CD note in the format 1010 @ CI (N06) is inserted on the sales book for the relevant prefix, then the delivery note number 10/2010/234 will be in the EDI format 1010000234. If the parameter is not filled in or the note does not exist, the format in EDI will be 10/2010/234.

‘‘

PoznCiFAV

String

The type of note in the book that defines the format of the invoice number. (See parameter PoznCiDLV description) If the format for the invoice is to be different than for the delivery note, it is possible to define another note on the sales book, eg 'CV'

‘‘

Price4DecPlaces

Boolean

Display prices to 4 decimal places in "* .xml" documents.

False

radaDok

String

Document series

‘10,20‘

radaZak

String

Series for sales orders import

‘10‘

reducedRate

Integer

Reduced VAT rate. According to the abbreviation RR from the code list Periods and taxes. When exporting a document with a reduced basic tax rate than the implicit (RR), it is necessary to enter this tax in the parameters (numerical value).

 

rounding

Boolean

Undissolved

False

RoundQuantity

Integer

Rounding of the quantity on the invoice determines the number of digits for rounding (-3 = 3 decimal places).

-3

RozsireniAdresati

Boolean

If the value is True, then fill the extended recipients when creating the order

False

StorehouseEAN

String

Explicit EAN code of the supplier's distribution warehouse

‘‘

SupplementAbbrBI

String

Parameter for entering the abbreviation of the client's addition with the file mark.

OR

supplier

Boolean

If True, then in creating an INVRPT message they are taken in consider only those customers who are suppliers.

False

SuppressUnitControl

Boolean

True - Restricts the check of the unit of measure when importing to EAN (when the parameter is switched off, it searches further according to the unit abbreviation)

False

UnitDescription

Boolean

True - When importing an order, the unit of measure is set according to the description of the EAN (it must contain the abbreviation of the set unit, the quantity does not change) + export of the description of the EAN as a unit of invoices and delivery notes

False

UseICDPH

Boolean

True - For SVK use IČDPH from the client's supplement instead of DIČ

False

setEncoding

String

Encoding xml messages. Other alternatives are:

  • ‘windows-1250' ... Central European alphabet
  • ‘windows-1252 ... Windows Code Page
  • 'UTF-16' ... Unicode 16

'UTF-16'

showXmlLog

Boolean

A value of True displays the log after importing and exporting xml messages.

True

SloucitPolozkyFAV

Boolean

When loading invoices out, it summarizes items with the same item number C_Zbo.

False

SloucitPolozkyDLV

Boolean

When loading delivery notes, it summarizes items with the same item number C_Zbo.

False

SupplierCode

Boolean

True - Takes the EAN from the Code field on the supplier prices on the 4th page of the articles.

False

ZobrazLogCen

Boolean

True - Show log prices

False

Book Contents

Book Index

Description of individual pages

K2 – EDI contains a tab for importing orders and confirming receipts into IS  K2, as well as tabs for exporting notifications of delivery, invoices, delivery notes and stock status. Last tab is K2–EDI settings. The user sees only those tabs that are allowed on the Settings page. You can switch between the individual tabs by clicking the left mouse button on the respective tab, or by using the Alt + keyboard shortcuts the first letter of the  tab name:

Purchase Order

Alt+O

Receipt confirmation

Alt+P

Notification of delivery

Alt+A

Invoices

Alt+F

Delivery notes

Alt+D

Stock levels

Alt+S

Settings:

Alt+N

Book Contents

Book Index

EDI - (Purchase)

Import / export of messages for electronic data exchange Purchase

Edi._K2_Purchase.pas

The script works in Xml format

InHouse format is not supported

The script is used for:

Settings:

In IS K2 is required to have the order form set to EDI for orders issued and invoices in. It is also necessary that all EAN codes of customers (in  the field Abbreviation  2) and article (in  the field Barcode or Abbreviation  2 or on page 4 of the Article in Supplier Prices). The first time you start, you must be logged in as user "K2ATMITEC" or "K2". Then it is possible to add in Tab Settings other users and their rights. Set the script parameter MyEANCode on right value.

Setting the path to files:

The path consists of The period specified by the Edi_Dir parameter and the postfix with which the script works. The directory structure is created when  the script is run for the first time.

The directory structure for the default settings will look like this:

C:\K2EDI\XML\LOG\

For log files.

C:\K2EDI\XML\IN\Invoice

For files which will be imported to IS K2

C:\K2EDI\XML\IN\NotImported\

For files which will be imported to IS K2

C:\K2EDI\XML\IN\Imported\

For files imported to IS K2

C:\K2EDI\XML\OUT\

For files exported from IS K2

Book Contents

Book Index

Script parameter:

Parameters description:

Parameter name

Data type

Description

Default value

AutomaticFill

Boolean

Yes - documents suitable for export are loaded automatically. No - documents are loaded only after switching to a specific tab in the form.

True

BatchPath

String

Initial batch for data preparation

"

BookDocExp

String

The book from which the documents for export will be loaded.

11/21

BookDocImp

String

The book from which the documents for import will be loaded.

11.

BuyerEANField

String

Parameter for specifying the field from the Suppl./Cust. tab, in which the EAN code is entered and from which this code will be read.

 

DeleteOldLogFiles

Boolean

True - Each time you run the script, all previously created and saved log files are deleted (purchase log files only).

False

DisableEANFormatCheck

Boolean

True - Checking the EAN format for articles is suppressed.

False

Edi_Dir

String

Path to Exported and imported files.

‘'C:\K2EDI\XML\'

ExtendedLogging

Boolean

Mode of extended logging.

False

GoodsEANField

String

Parameter for specifying the field from the article card from which the EAN code will be read (eg in the case of using a special field).

 

GroupOrderItems

Boolean

True - when exporting an order, its items are grouped by item number (C_Zbo) and unit.

False

ImpPrefix

Integer

Default documents prefix.

0

MyBuyerName

String

If the parameter is specified, its value overwrites the name of the buyer when exporting the order.

 

MyEANCode

String

My Ean code EAN - buyer code

999999999999.

NoGoodsEANItemsSearch

Boolean

If the parameter is set to True, the script ignores (during import and export) the barcodes set on the 1st page of the article card (in the table).

False

NoVATFillForForeignInvoices

Boolean

True - when importing an invoice (for invoices from abroad), the VAT rate is not overwritten. The condition is that the Suppl./Cust. status whose invoice is imported, is different from the country set in the client's parameters.

False

OldAddressFillingLogic

Boolean

False - the invoicing and delivery address is always exported exactly according to the settings of these addresses in the IS K2 documents. Also during import, these addresses are filled according to the addresses specified in the imported "* .xml" file. If the addresses are not listed in IS K2 or in the imported file, they are not filled in. If the parameter is set to Yes, the address filling logic does not change.

True

SetEncoding

String

Type Encoding xml messages.

'UTF-16'

ShowXmlLog

Boolean

If True, then a log file will be displayed for imports and exports. In case of error they will are always displayed.

False

SupplierCode

Boolean

True - Takes the EAN from the Code field on the supplier prices on the 4th page of the articles.

False

Book Contents

Book Index

Description of individual pages

K2 – EDI - Purchase contains a tab for invoices received for import into IS  K2, then a tab for exporting orders issued, a tab for exporting receipts and a tab for  K2-EDI settings. You can switch between the individual tabs by clicking the left mouse button on the respective tab, or by using the Alt + keyboard shortcuts the first letter of the tab name:

Purchase Order

Alt+O

Receipt Card

Alt+P

Invoices

Alt+F

Settings:

Alt+N

Book Contents

Book Index

EDI - Import of invoices in

As of PORTAL 4, it is possible to import EDI invoices received in the INVOIC format using the newly created function. This function is general and will be supplemented by the possibility of importing documents of other formats, such as ISDOC. The function includes 3 basic scripts.

Book Contents

Book Index

EDI Import settings

Process number:

Id. Script number:

File: DocImpEdiSettings.pas

Script description: Script for configuration of EDI invoice import

Address in the tree:

Script parameter:

Without parameters.

 

The first step for importing EDI invoices in INVOIC format is to set up the import. We set up and configure the basic aspects of importing an EDI invoice using the EDI Import Settings script. When you run the script, the configuration forms file appears.

Book Contents

Book Index

Excise Taxes - PaSSE

Book Contents

Book Index

Definition of terms

According to Act No. 353/2003 Coll., On excise duties, excise duties are:

The law collectively designates all products subject to excise tax as selected products.

The tax liability arises from the production of selected products in the tax territory of the European Community or by the import of selected products into the tax territory of the European Community.

We also distinguish the obligation to declare and pay the tax, which arises

The obligation to declare and pay the tax also arises

Selected products can only be produced in  a tax warehouse and these products are in  a conditional tax exemption regime. The obligation to declare, assess and pay the tax until the day the selected products are released for free circulation is therefore postponed. Selected products under  the conditional tax exemption regime can be stored in  a tax warehouse or transported in compliance with the conditions stipulated by law.

Taxpayers are the operator of the tax warehouse, the authorized recipient or the producer, who is obliged to declare and pay the tax in connection with  the release of selected products into free tax circulation or in connection with their loss or depreciation. Furthermore, the payer is a person who has incurred the obligation to declare and pay the tax in  the above-mentioned cases or claims a tax refund.

The right to a refund of excise tax can be claimed when exporting selected products to third countries, when returning selected products from the customer (their reintroduction into the conditional tax exemption regime) or as soon as selected products released for free circulation in the Czech Republic are transported to another member state for business purposes (if the conditions stipulated by law are met).

The tax period for these taxes is one month, but if no tax liability arises in this month, a tax return does not have to be filed, but according to § 136 para. 5 of the Tax Code, the taxpayer is obliged to inform the tax administrator of this fact. The tax return is filed either on the next working day after the tax liability arose or by the 25th day of the month following the tax period in which the tax liability arose,  except for  tobacco products for which the tax return function is performed by ordering tobacco labels. The tax return is filled in for each tax separately, ie for mineral oils, alcohol, wine, beer and tobacco products (types of excise taxes). The amount of excise tax is rounded up to the whole CZK.

According to the Act on Excise taxes, it is necessary to keep records of selected products produced, processed, received, issued and used for own consumption.

Taxation of selected products released for free circulation is evidenced by a tax document, confirmation of sale or confirmation of transport. The legitimate acquisition of selected exempt products is proven by a special permit and confirmation of exemption of selected products.

Book Contents

Book Index

Evidence of excise taxes in IS K2

In IS K2, selected products are registered on the Article stock cards. The cards are assigned the rate of excise tax and the number of the selected product for tax return. For the correct calculation of the excise tax on the Purchase and Sale documents, it is necessary to state the ethanol concentration for products subject to alcohol tax and the number of whole Plato degrees for products subject to beer tax. (see also the chapter Article Card with excise tax records)

The information on the Article Card is automatically received in the Purchase and Sales documents, and if the Excise Tax flag is checked on the document, the amount of excise tax is calculated according to the entered amount. (see also the chapter Calculation of excise tax on documents)

When the obligation to declare and pay the tax arises, we create an Invoice out or Release note in IS K2, where we check the Excise tax flag. If there is an Invoice out and Release note for the selected product, we check the Excise tax flag only on the Invoice out. If the flag is checked on both documents, there would be a double entry in the  Register of selected products subject to excise tax and thus double taxation. The right to a refund of excise tax can be claimed when exporting selected products to third countries (in IS K2 it is an Invoice out, where we do not check the Excise tax flag, because the tax has already been paid), when returning products from the customer (in IS K2 we create a credited Invoice out, where we check the Excise Tax flag), when receiving products for processing, processing or as a material for production (in IS K2 we create an Invoice in and check the Excise Tax flag).

Book Contents

Book Index

Article card with excise tax records

On the Article tabs for selected products, fill in the Nomenclature and Concentrations fields, which can be found on page 2.

pim_078.png

Picture: Article tab - page 2 - Nomenclature and Concentration fields

In the Nomenclature field, select the number of the selected product, under which it will be stated in the excise tax return. The rate of excise duty is assigned to the nomenclature.

Pict.: Nomenclature code list

If the Nomenclature code list is not filled in, then use the Insert key to add the necessary numbers of the selected products. We will enter the Abbreviation, i.e. the number of the selected product, then the Description, i. e. the text that deciphers the numerical designation, and the Excise Tax, i. e. the rate of excise tax, which we collect from the Excise Tax code list.

pim_245

Picture: Nomenclature code list - 1st page

If the required rates are not listed in the Excise tax code list, then we will add them with the Insert key. We fill in the Abbreviation, Description, Rate and Unit. However, we must follow the following rules:

Excise tax type

First two characters Abbreviation

excise tax on mineral oils

MO

excise tax on alcohol

AL

excise tax on wine and intermediate products

WI

excise tax on beer

BE

excise tax on tobacco products

TP

pim_255

Picture: Excise tax code list

pim_306

Picture: Excise Taxes code list - 1st page

On the Article tab, fill in the Concentration field. For selected products subject to alcohol tax, we state the percentage of alcohol concentration in the product in the form of a decimal number, ie we write 38% as 0.38. For beer storage cards, enter the number of whole Plato degrees in the Concentration field.

Book Contents

Book Index

Tax document

The taxation of selected products is proved by issuing a tax document, which the payer is obliged to issue when putting the products into free tax circulation. We obtain the tax document in IS K2 by printing the Invoice out report.

pim_313

Picture: Printed report Invoice out - tax document with excise tax

Book Contents

Book Index

Examples

Book Contents

Book Index

Example 1

Sales of selected product (mineral oils, MJ thousand liters), invoice issued

The manufacturer produced and sold (invoice out SD / 2008/1) 100 l of Natural 95 petrol (nomenclature code 27101145) for the price of CZK 25 without VAT per 1 liter. The rate of excise tax is CZK 11,840 per thous. liters, the product code for the tax return is 271001. Excise tax is calculated as a quantity in thous. liters * tax rate = 100 l / 1000 l * 11840 CZK = 1 184 CZK.

Solution:

We enter the rate of excise rate of CZK 11,840 in the code list of excise rate, we state the unit "thousand l". Enter the product code for the tax return (271001) in the Nomenclature code list and assign the excise tax rate. On the Article tab "Natural 95" we add the alternative unit "thousand l" and then insert the product code (271001) in the Nomenclature field.

Create an Invoice out, check the Excise Tax flag. The net amount (excluding VAT) must already have excise tax included. The product code (271001) and the excise duty rate (11 840) were inserted in the invoice item. After saving the invoice, the recapitulation of the excise tax, which we will display on the Excise Tax tab, calculates the amount of excise tax of CZK 1,184.

Book Contents

Book Index

Example 2

Sales of selected product (mineral oils, MJ tonnes), invoice issued

The manufacturer produced and sold (invoice out SD / 2008/2) propane-butane in 10 pressure vessels weighing 25 kg (nomenclature code 27111211) for a unit price of CZK 500 without VAT. The rate of excise tax is CZK 3,933 per 1 tonne, the product code for the tax return is 271101. Excise tax is calculated as the quantity in tonnes * tax rate = (10 pieces * 25 kg / 1000) t * 3933 CZK = 0.25 t * 3933 CZK = 983.25 CZK.

Solution:

We enter the rate of excise rate of CZK 3,933 in the code list of excise rate, we state the unit "t". Enter the product code for the tax return (271101) in the Nomenclature code list and assign the excise tax rate. On the Article tab "Propan-butan" we add the alternative unit "t" and then insert the product code (271101) in the Nomenclature field.

Create an Invoice out, check the Excise Tax flag. The net amount (excluding VAT) must already have excise tax included. The product code (271101) and the excise tax rate (3 933) were inserted in the invoice item. After saving the invoice, the excise tax recapitulation calculates the amount of excise tax of CZK 983.25.

Book Contents

Book Index

Example 3

Refund of excise tax (mineral oils), invoice received

The manufacturer has accepted (invoice in SD / 2008/1) 1,000 l of polluted aviation fuel (nomenclature code 27101131) for processing for CZK 50 per 1 liter and will claim a refund of excise tax. Gasoline is taxed at an excise tax rate of CZK 13,710 per thousand liters, the product code for the tax return is 271002. Excise duty included in the price is the amount in thous. liters * excise tax rate = 1 * 13710 CZK = 13 710 CZK.

Solution:

We enter the rate of excise rate of CZK 13,710 in the code list of excise rate, we state the unit "thous. l". Enter the product code for the tax return (271002) in the Nomenclature code list and assign the excise tax rate. On the Article tab "Gasoline" we add the alternative unit "thousand l" and then insert the product code (271002) in the Nomenclature field.

Create an Invoice in, check the Excise Tax flag. The net amount (excluding VAT) must already have excise tax included. The product code (271002) and the excise tax rate (13 710) were inserted in the invoice item. After saving the invoice, the excise tax recapitulation calculates the amount of excise tax of CZK 13,710.

Book Contents

Book Index

Example 4

Refund of excise duty (export), invoice issued

The seller exported (invoice out SD / 2008/3) 50 bottles of Metaxy 7 * (nomenclature code 22082012) for the price of CZK 403.00 without VAT for 1 bottle with a content of 0.7 liters with an alcohol content of 40%. The rate of excise tax is CZK 26,500 per 1 hl of ethabolu, the product code for the tax return is 220810. The amount of excise tax, which is included in the price of article, is calculated as the amount of alcohol in hectoliters of ethanol * tax rate = {[(50 * 0.7) liters / 100] hl * 40/100} hl of ethanol * CZK 26,500 = 0 , 14 * CZK 26,500 = CZK 3,710. The seller will claim a refund of excise tax.

Solution:

We enter the rate of excise rate of CZK 26,500 in the code list of excise rate, we state the unit "hl". Enter the product code for the tax return (220810) in the Nomenclature code list and assign the excise tax rate. On the Article tab "Metaxa 7" we add the alternative unit "hl" and then insert the product code (220810) in the Nomenclature field and in field Concentration we will fill 0.40.

Create an Invoice out, we will not check the Excise Tax flag. The net amount (excluding VAT) must already have excise tax included. The product code (220810) and the excise tax rate (26 500) were inserted in the invoice item. After saving the invoice, the excise tax recapitulation calculates the amount of excise tax of CZK 3,710.

Book Contents

Book Index

Example 5

Refund of excise tax (return of articles), invoice issued, corrective tax document

The brewery sold (invoice out SD / 2008/4) to the restaurant 12 barrels of 10-degree beer with a volume of 50 l (nomenclature code 22030010) for the price of 10 CZK without VAT for 1 liter. He/she paid excise tax on the invoiced delivery. The restaurant returned 2 barrels from the delivery and required the issuance of a corrective tax document (invoice out SD / 2008/5). The rate of excise tax on beer is CZK 24.00 per 1 hl and for each entire Plato stage, the product code for the  tax return is 220306. The amount of excise tax is calculated as the product of the amount of beer in hl * number of degrees Plato * tax rate = (2 * 50/100) hl * 10 degrees * CZK 24.00 = 1 * 10 * 24.00 = CZK 240.

Solution:

We enter the rate of excise rate of CZK 24.00 in the code list of excise rate, we state the unit "hl". Enter the product code for the tax return (220306) in the Nomenclature code list and assign the excise tax rate. To the card Article "Beer 10 st." add the alternative unit "hl" and then insert the product code (220306) in the Nomenclature field and enter 10 in the Concentration field.

Create an Invoice out, check the Excise Tax flag. In the item we state the amount - 2 barrels. The net amount (excluding VAT) must already have excise tax included. The product code (220306) and the excise tax rate (24.00) were inserted in the invoice item. After saving the invoice, the excise tax recapitulation calculates the amount of excise tax of CZK - 240.

Book Contents

Book Index

Example 6

Conditional tax exemption (mineral oils), invoice received

The tax warehouse operator received (invoice in SD / 2008/2) 1,000 l of Natural 95 petrol for the price of CZK 20 per 1 liter without VAT. Gasoline is in a conditional tax exemption regime.

Solution:

The product code 271001 has already been filled in on the "Natural 95" Article tab (see Example 1).

Create an Invoice in, we will not check the Excise Tax flag. The net amount (excluding VAT) will be without excise tax. The invoice does not have an excise tax - it will not be included in the tax return.

Book Contents

Book Index

Example 7

Sales of selected product (alcohol, 40 %), invoice issued

The manufacturer produced and sold (invoice out SD / 2008/6) 10 bottles of Metaxy 7 * (nomenclature code 22082012) for the price of CZK 403.00 for 1 bottle with a content of 0.7 liters with an alcohol content of 40%. The rate of excise tax is CZK 26,500 per 1 hl of ethabolu, the product code for the tax return is 220810. The amount of excise tax is calculated as the amount of alcohol in hectoliters of ethanol * tax rate = {[(10 * 0.7) liters / 100] hl * 40/100} hl of ethanol * CZK 26,500 = 0.028 * CZK 26,500 = CZK 742.

Solution:

We enter the rate of excise rate of CZK 26,500 in the code list of excise rate, we state the unit "hl". Enter the product code for the tax return (220810) in the Nomenclature code list and assign the excise tax rate. On the Article tab "Metaxa 7" we add the alternative unit "hl" and then insert the product code (220810) in the Nomenclature field and in field Concentration we will fill 0.40.

Create an Invoice out, check the Excise Tax flag. The net amount (excluding VAT) must already have excise tax included. The product code (220810) and the excise tax rate (26,500) were inserted in the invoice item. After saving the invoice, the excise tax recapitulation calculates the amount of excise tax of CZK 742.

Book Contents

Book Index

Example 8

Sale of selected product (beer, 10 degrees, invoice issued)

A small independent brewery with a production of 60,000 hl of beer per year will supply (invoice out SD / 2008/7) 5 barrels of 10-degree beer with a volume of 50 l (nomenclature code 22030010) to a restaurant for CZK 10 without VAT per 1 liter. The rate of excise tax on beer for a small independent brewery with a production of up to 100,000 hl of beer per year is CZK 16.80 per 1 hl for each entire Plato stage, the product code for the tax return is 220303. The amount of excise tax is calculated as the product of the amount of beer in hl * number of degrees * tax rate = (5 * 50/100) hl * 10 degrees * CZK 16.80 = 2.5 * 10 * 16.80 = CZK 420.

Solution:

We enter the rate of excise rate of CZK 16.80 in the code list of excise rate, we state the unit "hl". Enter the product code for the tax return (220303) in the Nomenclature code list and assign the excise tax rate. To the card Article "Beer 10 st." add the alternative unit "hl" and then insert the product code (220303) in the Nomenclature field and enter 10 in the Concentration field.

Create an Invoice out, check the Excise Tax flag. The net amount (excluding VAT) must already have excise tax included. The product code (220303) and the excise tax rate (16.80) were inserted in the invoice item. After saving the invoice, the excise tax recapitulation calculates the amount of excise tax of CZK 420.

Book Contents

Book Index

Example 9

Loss of selected products, release note

During the inventory in the tax warehouse, a shortage (VY SD / 2008/1) of 15.6 l of Natural 98 petrol (nomenclature code 27101149) was found at a price of CZK 30 without VAT per 1 l. Petrol was stored in the regime of conditional tax exemption, but by loss the obligation to declare and pay the tax arises. The rate of excise tax is CZK 11,840 per thous. liters, the product code for the tax return is 271001. Excise tax is calculated as a quantity in thous. liters * tax rate = 15.6 l / 1000 l * 11840 CZK = 0,0156 * 11840 = 184,70 Kč.

Solution:

We enter the rate of excise rate of CZK 11,840 in the code list of excise rate, we state the unit "thous. l". Enter the product code for the tax return (271001) in the Nomenclature code list and assign the excise tax rate. On the Article tab "Natural 98" we add the alternative unit "thousand l" and then insert the product code (271001) in the Nomenclature field.

We will create a Release note, the customer is a customer representing their own company, we will check the Excise Tax flag. The stock price is without excise duty. The product code (271001) and the excise duty rate (11 840) were inserted in the Release Note item. After saving the release note, the amount of excise tax is calculated at CZK 184.70.

Book Contents

Book Index

Example 10

Sales of selected product (tobacco products), invoice issued

The manufacturer produced and sold (invoice out SD / 2008/8) 100 cartons of cigarettes. Each carton contains 10 boxes of 20 cigarettes. The set selling price of one box of cigarettes is CZK 100 including VAT. The fixed part of the excise tax rate is CZK 1.03 per 1 piece, the percentage part of the excise tax rate is 28% of the final price for consumers incl. DPH,, The minimum rate of excise tax is CZK 1.92 per 1 pc and the product code for the tax return is 240201. Excise tax is a percentage of the tax rate * price for the end. consumer / 100 + fixed part of the tax rate * number of pieces = 28 * 100 * 10 * 100/100 + 1.03 * 20,000 = CZK 48,600.00.

Solution:

The rate of excise tax on cigarettes has two components - a fixed and a percentage. In IS K2 we enter only one rate and therefore we must first calculate the rate of excise tax.

Excise tax rate for 1 piece = 100 CZK / 20 pieces (final price for one cigarette) * 28% + 1.03 CZK = 1.4 + 1.03 = 2.43 CZK.

We enter the rate of excise rate of CZK 2.43 in the code list of excise rate, we state the unit "pc". Enter the product code for the tax return (240201) in the Nomenclature code list and assign the excise tax rate. On the Article tab "Cigarettes" we add the alternative unit "pc" and then insert the product code (240201) in the Nomenclature field.

Create an Invoice out, check the Excise Tax flag. The product code (240201) and the excise tax rate (2.43) were inserted in the invoice item. After saving the invoice, the excise tax recapitulation calculates the amount of excise tax of CZK 48,600.