Projects:PriceListVersionGeneration&action:User Guide
Contents |
Introduction
This project implements a process to generate new price list version. Some parameters need to be defined and new price list version is generated.
How to define Price List Version Calculator
Header
Organization: new price list version will have this organization
Date price list: new price list version will have this 'valid from date'
Discount: subtract discount to the price to get A
Manipulation: add manipulation to A to get B
Transport: add transport to B to get C
Margin: add margin to C to get final standard price
Price List: where the new price list version is going to be created
Price List Schema: new price list version will have this price list schema
Generate: when pressing this button the new price list version will be created.
Lines
Discount: discount % to be applied to the origin price list version's product's standard price. Calculated price will be used for header's parameter's operations.
Change: the change rate to be applied when price list version origin and destiny have different currencies.
Price List Version: price list version origin. It will be used to take products and their prices to calculate new price list version
Price List Version -Product // Product - Price
Discount %: The percentage defined in Calculator header Discount value: value after subtracting discount to origin standard price Transport %: The percentage defined in Calculator header Transport value: value after adding transport % to discount value Manipulation %: The percentage defined in Calculator header Manipulation value: value after adding manipulation % to transport value Margin %: The percentage defined in Calculator header Margin value: value after adding manipulation % to manipulation value
When some of those value are changed the values are recalculated.
User case 1
- Price List Version A:
- Currency: USD
- Product: Product1 and Product2
- Product1
- Standard Price: 2.00
- Price List Version Calculator Header:
- Organization: España-Region Norte
- Date: 16-06-2013
- Discount: 10
- Transport: 12
- Manipulation: 11
- Margin: 13
- Price List: Destiny Price List 1
- Price List Schema: Esquema de tarificación
- Price List Version Calculator Lines:
- Discount:
- Change:
- Price List Version: Price List Version A
When pressing 'Generate' button the following price list version will be created:
- Destiny Price List 1 - 16-06-2013
- Product 1:
- List Price: 2.00
- Unit Price: 2.53
- Discount: 10
- Discount value: 1.8 (2.00-(2.00*0.10))
- Transport: 12
- Transport value: 2.02 (1.8+(1.8*0.12))
- Manipulation: 11
- Manipulation value: 2.24 (2.02+(2.02*0.11))
- Margin: 13
- Margin value: 2.53 (2.24+(2.24*0.13))
- Product 1:
User case 2
- Price List Version A:
- Currency: USD
- Product: Product1 and Product2
- Product1
- Standard Price: 2.00
- Price List Version Calculator Header:
- Organization: España-Region Norte
- Date: 16-06-2013
- Discount: 10
- Transport: 12
- Manipulation: 11
- Margin: 13
- Price List: Destiny Price List 1 (CURRENCY EUR)
- Price List Schema: Esquema de tarificación
- Price List Version Calculator Lines:
- Discount:
- Change: 0.5
- Price List Version: Price List Version A
When pressing 'Generate' button the following price list version will be created:
- Destiny Price List 1 - 16-06-2013
- Product 1:
- List Price: 4.00
- Unit Price: 2.53
- Discount: 10
- Discount value: 3.06 (4.00-(4.00*0.10))
- Transport: 12
- Transport value: 3.97 (3.06+(3.06*0.12))
- Manipulation: 11
- Manipulation value: 4.41 (3.97+(3.97*0.11))
- Margin: 13
- Margin value: 4.99 (4.41+(4.41*0.13))
- Product 1: