PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Expand]Guide for PANTHEON
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Collapse]User Manual for PANTHEON
   [Expand]Getting Started
   [Expand]User Manual for eBusiness
   [Collapse]Settings
    [Expand]Subjects
    [Collapse]Items
      Creating a New Item
      Entering Data for Item Pricing
      Entering Contract Prices for Item
      Entering Item Specification
     [Expand]Entering Custom Fields
      Transfer Movements between Items
      Tax Rate Correction
     [Expand]Using Item Types
     [Expand]Serial Numbers
     [Expand]Pricing Formulas
      Using Find Item Function (Ctrl+F)
     [Expand]External Identifiers
    [Expand]POS
     Manufacturing
    [Expand]Program
    [Expand]Personnel
     Calendar
    [Expand]Financials
    [Expand]Customs
    [Expand]Documentation
    [Expand]Program
     Change user
   [Expand]Orders
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]Service
   [Expand]Help
   [Expand]Personnel
   [Expand]Financials
   [Expand]Analytics
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
  [Expand]Old products Archive
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
  [Expand]Old products Archive
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
  [Expand]Archive
[Expand]User Site

Load Time: 390.6293 ms
"
  6457 | 6864 | 339310 | Updated
Label

Pricing Formulas

Pricing Formulas

Pricing Formulas

010379.gif010380.gif010381.gif010411.gif010382.gif010383.gif

1. Selecting a Register

First open the Pricing Formulas register from the menu.

30660.gif

 

You can also open the register using by clicking the shorcut; icon, set in the taskbar.

30661.gif

 

2. Creating a New Formula

Click the new record 30662.gif button in taskbar 016036.gif. A blank form made ready for entering of a new formula is opened.

 

 

30663.gif

Enter formulas used in non-standard pricing in the Formula register.

Formulas are an exceptionally powerful tool for determining non-standard pricing. You can use them wherever prices are variable and can then be set on the basis of defined criteria.

Most often they are used for contract prices and with pricing of different prices according to the quantity of consumption with Fixed nonstandard margin (e.g. a certain customer has 7% margin on gross purchase price).

Enter in the register:

ID
A maximum three-digit formula ID can be entered to this field.
Name
Formula name used to make selecting easier.
Formula
A correctly formulated expression used in pricing.

For detailed treatment on syntax and operators that can be found in formulas see the following topics:

020873.jpg Click this button to test formula (see testing and correcting formulas).

The formula test checks normally used controls and whether you put the appropriate variable name between the number signs (#) (see the list below). If you refer to the variable between the number signs (#) which cannot be found in the list below, the formula test returns an error (see Variable XX is not defined at this location!).

Description
Here you can enter any text on how the pricing formula is carried out.
020874.jpg By using this button copies the selected formula to a new one. Change the formula ID and enter any other required change.

Formula is a mathematical expression that can be created by using the variables, mathematical symbols and logical expressions.

Variables Used in Pricing

KOLICINA
Denotes quantity.
CENRAZRED
Denotes price bracket, which can be 1, 2 or 3.
POGCENA
Denotes a special price (from Contract Prices).
CENA
Denotes a price valid on the basis of the price bracket set with the subject.
MPCENA
Denotes retail price (excluding tax) that can be found in Pricing/Costing panel of Items register or separate pricing (LKPC) according to the selected warehouse.
VPCENA1
Denotes wholesale price that can be found in Pricing/Costing panel of Items register or separate pricing (LKPC) according to the selected warehouse.
VPCENA2
Denotes wholesale price that can be found in Pricing/Costing panel of Items register or separate pricing (LKPC) according to the selected warehouse.
SESTAVNICA
Denotes price in specification that can be found in Pricing/Costing panel of Items register or separate pricing (LKPC) according to the selected warehouse.
KOSOVNICA
Denotes a price calculated using the formula in specification (as set in the Program Parameters).
NABACENA
Denotes purchase price (as set in Program Parameters).
NABACENA
Denotes a supplier's price (Supplier Price field from the costing in the Items register).
BNABACENA
Denotes a purchase price (Gross in LCY field from the costing in the Items register).

Additional Variables

010413.gif 010414.gif 010415.gif 010416.gif 010417.gif

They are used for valuating prepartion and production resource costs in manufacturing MF. For instances where this formula is used see:

#RESURSTPZ1#
Denotes fixed resource costs 1 (first field for preparation resource costs).
#RESURSTPZ2#
Denotes fixed resource costs 2 (second field for preparation resource costs).
#RESURSTPZ3#
Denotes fixed resource costs 3 (third field for preparation resource costs).
#RESURSTPZ4#
Denotes fixed resource costs 4 (fourth field for preparation resource costs).
#RESURSTPZ5#
Denotes fixed resource costs 5 (fifth field for preparation resource costs).
#RESURSTN1#
Denotes variable resource costs 1 (first field for production stroškov resursa).
#RESURSTN2#
Denotes variable resource costs 2 (second field for production stroškov resursa).
#RESURSTN3#
Denotes variable resource costs 3 (third field for production stroškov resursa).
#RESURSTN4#
Denotes variable resource costs 4 (fourth field for production stroškov resursa).
#RESURSTN5#
Denotes variable resource costs 5 (fifth field for production stroškov resursa).

 

000001.gif Instead of the above specified foreseen variables you can perform pricing also by creating a stored procedure (see Using stored procedures in pricing formulas).
000001.gif To see how prices are generated on the basis of the entered data see Hierarchy in setting prices!
000001.gif See Taskbar for a general description of its functions.



 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!