Projects:PriceListVersionGeneration&action:User Guide

Contents 1 Introduction 2 How to define Price List Version Calculator 2.1 Header 2.2 Lines 3 Price List Version -Product // Product - Price 3.1 User case 1 3.2 User case 2

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

900px

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

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