Master Data

Customers

For further description, see the Suppliers/Customers chapter.

Articles

For further description, see the Articles chapter.

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.

Price List Settings

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

pic_4236

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.

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.

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. When pressing the button ' ' from the Price Lists folder tab, we may recalculate the price lists only for the given Article card.

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: The Category field in the Sale folder of an Article card

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

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.

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.

Price Lists

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 to use a price list document in Sale (apart from the active option Use New Price Lists in Price List Settings) is to have the given price list confirmed and to check the Active field in 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)

Price List

Basic Data

This page defines the price list attributes. The field Apply Currency on Docs is obligatory. You can choose the way of applying currency to the selected currency (the currency of your own company is predefined):

Any Currency - the price list refers to the selected currency,
The Same Currency - the price list refers only to the document which is to be issued for the same currency as is the value in the Currency field in the price list,
The Same or Own Currency - the price list will be applied to the document which is to be issued for the selected currency or the currency of your own company.

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

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_4240

Pict.: Price Lists - Basic Data page

pic_4833

Pict.: List - Priority Column page

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 a given source from the second section of a 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

Definition Items

Displays the list of definition items from the Price Lists - Definition of Price Calculation part. If you go through the items in the Price Lists - Definition of Price Calculation part, the items of this definition will be displayed in theDefinition Items section.

pic_4247

Picture: Definition Item

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 section directly defines 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.

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

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

Attached Docs.

A card where you can add document and ext. documents

Functions over Price Lists

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.

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

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:

Recalculate All Price Lists - if checked, all price lists will be recalculated
Recalculate Specific Price List - if you choose this option, you need to specify whether also the superior and subordinate price lists should be recalculated. The recalculation does not concern other price lists.
Recalculate Specific Articles - articles will be selected from the book. A recalculation of the given price lists which contain the articles will follow. Note: The date and time of recalculation of a given price list will not manifest in the Recalculated By field in the price list document Preview.

Scripts and Reports

Price List Export


Process No.: CIS008a	Script Id: 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.

Price List Import


Process No.: CIS008a	Script Id: 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