Book Contents

Book Index

Basic Data

Book Contents

Book Index

Customers

For further description, see the Suppliers/Customers chapter.

Book Contents

Book Index

Articles

For further description, see the Articles chapter.

Book Contents

Book Index

Price Lists

To be able to use Price Lists, you need to run the function Configure Price List, which is available in the tree menu Sale / Processing of Sales Orders / Basic Data / Price Lists, and to check the field called Apply New Price Lists.

At the same time, you need to define the books in the Books of Price Lists function. The function may also be activated from the tree menu Basic data/Books of Price Lists.

It is also necessary to set the particular rights on the 5th page in the Users - Set Rights book, if you want to work with the Price Lists book.

Book Contents

Book Index

Price List Settings

Price List Settings form runs from the tree menu Sale/Basic Data/Price List Settings.

pic_6201

Pict.: Price List Settings code list

It is necessary to have the Use New Price List field checked if you want to use new price lists in business transaction. If this field is not checked, you can work in the Price Lists book (to insert new price lists, to edit the existed ones), but the prices will be added according to the original pricing.

In the field Prices by date we select according to the date the prices are placed on the sales documents. Field has options:

If the flag Prices by Date of Issue is checked, the prices will not be considered by the current date, but by the date of issue from the Sales Order in the case that it will concern a Sales Order or a subordinate document, or eventually the date of issue from the free document will be applied.

If the flag Prefer Prices from Other Price List Items is checked and the articles are defined in the price list of the Other Price List Items table and there are one or more simultaneously existing other price lists derived from this price list, the price from the Other Price List Items section will be set into the business transaction even though a lower price might be found in the derived price lists.

If the flag Prices is checked only from the price lists by a suitable combination of customer and prices group, then the condition for both the customer and the price group must be met for the application of the price from that price list on the document.

If the Use catalog price lists field is checked, then a valid price list with the Catalog flag is searched for the article as part of determining the catalog price (the Catalog price on the sales document item, in offers, the "catalog" price source in the price list definition and price recalculation for e-shops). If it is not found, then the price is searched according to the original logic.

If the Allow use of price lists across companies box is checked, then it is possible to save the price list book without filling in your own company. It is used for price lists that are shared for all own companies. It is then up to the user to set other conditions of the price lists so that these price lists are activated only in the required cases (eg restrictions on a specific currency, sales books, e-shops). At the same time, this option should not be active if the articles are divided into own companies and some article cards are only available in some own companies.

Note: This field is intended only for price lists. If promotions or loyalty programs are created in a book that does not have its own company saved, then when saving those promotions or loyalty programs, an error message will be displayed and records of promotions and loyalty programs will not be saved.

This category is accessible as a new field on the Article card in the Sale folder in the bottom part of the table if you check the Use field (Notice: available only in the new user interface). You can define particular records for that category in this field. At the same, time you can choose the category in the Definition of Price Calculation (Definition folder, upper part) in the price list.

Price lists can be defined for particular Article cards, product groups, and product keys. You can create a new price list from an already existing price list, but you can also define your own Article Categories for price lists. Clicking pic_956i button from the Price Lists folder tab, we may recalculate the price lists only for the given Article card.

Book Contents

Book Index

Books of Price Lists

You can insert Price lists into particular books. The books can be set in the Administration of Books function, or you can run the Book of Price Lists function from the tree menu Basic Data / Books of Price Lists or Sale / Processing of Sales Orders / Basic Data / Price Lists. Switching between individual books is usually executed by Alt+F10 keys.

pic_4235

Picture: Administration of Books of Price Lists

Book Contents

Book Index

General settings of Books of Price Lists

It is necessary to enter the abbreviation if you insert a new book (via the Ins key).

pic_4239

Picture: Books of Price Lists

Field description:

Abbreviation

Used to sign given books.

Company

Client company.

Description

Description of a Price List book.

Language Description

Potential language description of a book of Price Lists. Language descriptions can be defined by the Description Translations button.

Group of Rights

Particular books of Price Lists can be accessible only to users who have the particular group of right defined. You can add the group of rights by the Gr. of Rights button.

Changed

The date and time of the last change is added automatically.

Changed By

The user is added automatically as well.

You can define the language translation of the book via the Description Translations button. It is displayed in the Language Description field.

You can set the group of rights for a particular book by means of the Gr. of Rights button. Information will be displayed in the Group of Rights field.

pic_4832

Picture: Books of Price Lists - Default Settings

Field description:

Price List Priority

The higher the number, the greater priority of the price list.

If two price lists for applying a price are found, the one with the lower price will be selected by default. However, if the situation occurs where a price list with the higher price should be applied for specific customers, this can be set via the price list priority. Such price list will be set with a higher priority. When a price list is being created, the priority field will be entered to the price list document.

Price List Currency

When a price list is being created, the Currency field will be filled in with this value.

If the option Set Price List as Active While Confirming is checked, the option Active will be set on the price list document during the confirmation.

If the option Set Price List as Inactive While Confirming is checked, the option Active will be deactivated on the price list document during the cancellation of confirmation.

Book Contents

Book Index

Settings for Business Year of Books of Price Lists

You can set the business year and numbering of documents in the Settings for Business Year tab.

Book Contents

Book Index

Price Lists

Book Contents

Book Index

Price Lists - Book

The Price Lists module keeps the records of individual price lists. Switching between individual books is usually done with the Alt+F10 keys. The marked price lists may be recalculated via the function Bulk Actions - Recalculation.

The condition (except for the active option Use new price lists in Price list settings) for the use of the price list document in sale must have the price list confirmed and the Active field checked on the Basic data tab. The field may be checked with the F7 key on the current record.

pic_4238

Picture: Price Lists - Book (List folder)

Book Contents

Book Index

Price List

Book Contents

Book Index

Basic Data

Other information is compulsory and shows details of the price list. You can set the validity interval of price list, select the particular suppliers who relate to the price list, or define the price groups.

If the Prices only from price lists with a suitable customer and price group combination box is not checked in the price list settings, then for the application of the price list it is sufficient that at least one of the conditions for Validity for customers is met. Thus, there is a customer on the document, defined here or has any customer (even other than the one defined here) the price group selected here. If the field Prices only from price lists with a suitable combination of customer and price group is checked, then the price list is applied only if there is a customer defined here on the document and at the same time has a defined price group selected here.

A price list can be set only for the particular books of Sale, or only particular cost centres may be selected. By checking the field Direct Price Entering, we can set whether we will allow to enter a price directly from an Article card. To be able to actively use a price list on Sale documents (except for the confirmation of a price list), the user must check the Active field (manually or by pressing F7 in the case of a previously confirmed document).

If the Use catalog price lists field is checked in the price list settings, then it is possible to check the Catalog field. If it is checked, then in order to find out the catalog price, it first tries to find a valid price list with the catalog flag for the article on the sales document item. If it is not found, then the price is searched according to the original logic.

You can add comments to a specific price list, or use the folders as a header or footer text.

If there are more price lists found during inserting the articles to a Sale document, the price list with the lower price takes priority over the others. This can be changed by setting a priority. If a price list is set with a higher priority, the price from this price list will be applied even though this price would be higher than the others. The priority field is in the Preview, where it cannot be changed. To be able to change it, you must add the field to your columns. If the field is in the columns and manual editing is enabled, you may manually edit the value. Its value is set according to the settings in book of Price Lists by default.

pic_6202

Pict.: Price Lists - Basic Data page

pic_4833

Pict.: List - Priority Column page

Book Contents

Book Index

Definition

You can define the items of price lists on a card called Definition. An Article card can be the source of items for a price list. You can also use product groups, product keys, user-defined categories, or an already existing price list as a source. The list of articles from this source is displayed for that source from the second part of Definition card. A user-defined category will appear in the list if these categories in Price List Settings have the Use flag.

If some articles are contained in various sources repeatedly, the lowest price will be applied either for the amount or for the unit in the document.

It is possible to set the source of the original price for each price list source mentioned above, and, depending on the source of the price, also additional data (rounding, amount, unit).

In the second part of Definition Items is a list of all article cards, which belong to the above-selected product key, product group, category, or price list. If you go through the items in the Price Lists - Definition of Price Calculation part, the list will be updated in this part.

The Other Price List Items part defines the definition of Article cards for a particular price list, whose price is not derived from e.g. margin. It is thus used to set fixed prices and quantities. If a price list has the Direct Price Entering flag checked, it is possible to set the price of this price list directly from an Article card. A price entered this way will then display in this table.

pic_4241

Pict.: Definition card

Book Contents

Book Index

Price Lists - Definition of Price Calculation

The Price Lists - Definition of Price Calculation form will be displayed after you press Ins.

pic_4242

Picture: Price Lists - Definition form

You can select the source type in the Items Source section:

pic_4244

Picture: The form with the option Other Price List

pic_4243

Picture: Form with the option Article card

pic_4245

Picture: Form with Product Group selection

pic_4246

Picture: Form with the option Product Key

If a category is defined in the Price List Settings and the flag Use is checked, these categories will also be displayed as an option for further choice.

In the Original Price Source section, you can select:

In the Dependency part, you can define for what quantity and unit of measure the price should be defined. If the Apply Price List Item Only When Selling in the Set Unit flag is checked, the price will be applied only if the unit of measure from the Unit field in the document is selected. If the Only for quantity multiple field is checked, then the price list is applied only if there is a quantity (or quantity multiple) specified in the Quantity field on the document item.

Example: In quantity field is 15. If the Only for multiple of quantity field is checked, then the price is applied to the document if there is a quantity of 15, 30 and other multiples of 15 on the item quantity. This price list does not apply to other values (eg 1 to 14, 16 to 29, 31 ....).

Tip.: It can be designed for cases where we allow the customer to give a lower price if he buys a quantity of article that do not need to be unpacked.

You can set a discount in the Price Calculation section. Positive number means discount, negative one would mean surcharge. If you check the Entered in % flag, you will define if you deal with a surcharge in percentage or an absolute amount.

Set the way of rounding in the price rounding section.

Book Contents

Book Index

Definition items

Displays the list of definition items from the Price Lists - Definition of Price Calculation part. If you go through the items from Price lists - definition of price calculation part, then items of this definition will be displayed in Definition items part.

pic_4247

Picture: Definition Item

Book Contents

Book Index

Other Definition Items

You can use the last part of Other Definition Items if you enter fixed prices and the amount of Article cards. The Price List Item form opens after pressing the Ins key. Select an Article card, and optionally add an amount, a unit and a Net and Gross price. If you want to apply this for a particular unit of measure, just check the Apply Price List When Selling in the Set Unit flag. In this case, the discount will be applied only if the unit of measure is selected on the Sale document.

The Other Price List Items part defines the definition of Article cards for a particular price list, whose price is not derived from e.g. margin. It means that it enters fixed prices and amounts.

Book Contents

Book Index

Summary

A Summary card displays the list of articles from a price list in the upper part. If one Article card is in the price list more than once, a record with the lowest price will be displayed in the summary.

In the lower part, there is a list of all customers that the price list relates to. If the conditions for customers or price list groups are not on the Basic Data card (price list applies to all of them), the list of all customers on the Summary card is not displayed.

pic_4248

Picture: Summary card

Book Contents

Book Index

Sale Items

The card displays an overview of Sale items, where the price from the applied price list is stated.

pic_4249

Picture: Sale Items card

Book Contents

Book Index

Attached Docs.

A card where you can add document and ext. documents

Book Contents

Book Index

Functions over Price Lists

Book Contents

Book Index

Recalculation

The recalculation may be run over one price list (the Recalculate button in the user menu) or for several selected price lists. More price lists at once may be recalculated via the function Bulk Actions - Recalculation.

After running the script, a window with two options will appear:

Recalculate All Subordinate Price Lists and Recalculate All Superior Price Lists. If checked, an automatic search for, an arrangement of, and a subsequent recalculation of all subordinate/superior price lists will occur.

pic_4376

Picture: Dialogue for Price List Recalculation

If the user chooses to Recalculate by Article Container (the option Menu / Recalculate By Article Container), the prices of only those articles in the container in the Article module will be recalculated.

Book Contents

Book Index

Set Active

The function may be activated with F7 in the current record. The function will set/cancel the checking of the Active field in the Basic Data folder tab. The condition is to have the Confirm Price Lists user right (after the setting) and Cancel Confirmation of Price List (after cancelling the flag).

Book Contents

Book Index

Price List Recalculation in Task Scheduler

You may also recalculate price lists via the Task Scheduler. After pressing the Ins key in the Other / Recalculation folder in the Batch Items section, the option Price List Recalculation becomes available.

pic_4717

Picture: Inserting Price List Recalculation into the Task Scheduler

pic_4716

Picture: Task Scheduler - Price List Recalculation

You can set the price list recalculation in three ways:

In the Own company field, we can define our own company for which the recalculation is to be started. If the field is empty, the recalculation is started for all own companies to which the user who starts the recalculation using the task scheduler has the rights.

Book Contents

Book Index

Scripts and Reports

Book Contents

Book Index

Price List Export

Process No.: CIS008a

Id. Script number: FZAK047

File: PriceListExport.pas

Script description: The script export the items of a price list (section Definition Items). The user chooses the type of a file and enters its name. The information about a number, article abbreviation, unit of measure, quantity, and prices will be exported. You may optionally choose to check the field for article description, its EAN, its selling price, its abbreviation 2 or its language name.

Address in the tree:

Script parameters:

Without parameters.

Book Contents

Book Index

Price List Import

Process No.: CIS008a

Id. Script number: FZAK046

File: PriceListImport.pas

Script description: The script imports the items of a price list in the xls or xml format. The items are imported into the section Other Price List Items (module Price Lists) records from the file. In the case of import from Excel, the user maps the columns themselves. They will choose whether to import according to the article number, abbreviation 1, abbreviation 2, EAN, and whether to import the Net price or the Gross price. In the case of import from a xml file, the information are not mapped.

 

The RewriteItems parameter allows you to rewrite the current items if a combination of articles, quantity and a unit of measure is found in a price list already.

 

The ConfirmPriceList parameter will automatically confirm a price list after the import.

Address in the tree:

Script parameters:

RewriteItems - No

Yes - allows current items to be rewritten if a combination of articles, quantity and a unit of measure is found in a price list already. No - imports only those items that do not yet exist for the given article, unit of measure and quantity.

ConfirmPriceList - No

Yes - confirms a price list after the import

Book Contents

Book Index

Data for Price Lists in the Book of Customers and Sale Documents (New User Interface)

There are new fields - Price List and Special Offer - which are related to the new price making. They may be found in the Customer code list on a Sale card, and in the Sale documents on the Items card. These fields are accessible only in the new user interface.

On the Customers tab, there is a Define price groups button, which allows you to set a different price group in the Change state for the selected product group than in the Price group field and thus ensure that the price for articles from the product group is obtained according to the price group defined here. take precedence over the price group defined in the Price group field. After pressing the button, the form Price group for the customer will be displayed. Press the Ins key to display a list of product groups. Press the Enter key to confirm the selection and a list of price groups will be displayed. Again, confirm the selection of the price group with the Enter key. A record with the product and price group will be added in the definition of price groups. By line editing we can also set a discount for this combination. The amount of the discount will be reflected in the Discount field on the sales receipt.

pic_5099

Picture: Form Definition of price groups

Price list - if the Price List field is entered in Sale documents, the prices in documents will be preferably taken from this price list; otherwise a selling price will be added from articles (the Selling Price field in the Articles code list on a Sale card). If you enter this field in Customers, the Sale document can be issued for a particular customer, and the prices on items will be added from the price list selected in the Price List field in Customers.

Special Offer - if a Special Offer is entered, only the price lists which have this offer will be taken into consideration.

pic_4286

Picture: The Price List field and a Special Offer on a Sale card in Customers

pic_4287

Picture: The Price List field and a Special Offer on an Items card

Book Contents

Book Index

Article - Price list

The list of price lists in which the article card is available on the Sales tab and the Sales prices sub-tab. By default, all price lists are displayed. If it is desired to see only active price lists, then this can be achieved by pressing the Show only active price lists icon. Price lists that do not have the Active flag set will not be displayed in this case.

If the articles are on an already canceled price list, then these price lists will not appear in this list by default. If the Show inactive records user right is checked, then these canceled records will also be displayed

If the price list has the Direct Price Entering flag checked, you may insert the price for the chosen price list directly on an Article card. You may manually edit the Net, Gross or Quantity columns and set a price and quantity for the selected price list on the Sale tab in the bottom table Price Lists - Direct Price Entering. A record with the price and quantity will be inserted into the Other Price List Items section of the selected price list. Should the edited price list have its own subordinate price lists, a query asking whether you wish to recalculate the subordinate price lists as well will appear.

pic_4237

Picture: Article Card - Sales price tab