JD Edwards E1 Advanced Pricing

Oracle JD – Edwards Kundenevent FSS
JD Edwards EnterpriseOne
Advanced Pricing
2
Types of Price Adjustments (sales or purchasing)
•
By a specified percentage of the base price.
•
By a percentage of the current net price.
•
By a percentage currency amount of cost.
•
By a specific amount.
•
By selecting a price adjustment as the new base price.
•
By a sliding rate for multiple discounts to a sales order line.
•
•
The sliding rate can be based on quantity, weight, or amount.
Based on a formula.
•
For example, you can create formulas that reference a field in the sales order detail or pull data
from variable tables to create pricing for items with prices that fluctuate frequently.
•
Based on a price override incl. specified rounding
•
Based on one of your company's custom programs (type 8)
•
Based on a minimum or maximum price adjustment rule.
3
Dependencies
•
Customer Prices, accruals, rebates can depend on:
•
Limited Time Offers
•
Multi-currency Pricing
•
Multiple Units of Measure
•
Volume Incentives
•
Volume Upselling
•
Free Goods
•
Level Breaks
•
Buying Structure
•
Repricing, discounts depend on quantities, weights, or amounts on an order
•
Price approvals on price change
4
Features
•
Multiple adjustments per line item.
•
Detailed adjustment feature definition.
•
Hierarchical adjustment search sequences.
•
Order-specific pricing characteristics.
•
Free goods processing.
•
Online review of adjustment history.
•
Procurement and receipt adjustments.
•
Reprice a batch of purchase orders or receipts.
•
Price matrix to maintain adjustment detail records.
5
Control Code pro Adjustment
•
Do not print on Document
•
Print on Document
•
Add to Sales Detail File
•
Accrued to G/L
•
Rebate
•
Print on Invoice – Detached
•
Supplier Proof of Sales
•
Rounding Adjustment
•
Line Level Adjustment
•
Basket Level Adjustment
•
Order Level Adjustment
•
Volume Level Adjustment
6
Setting Up Adjustment Definitions
•
Level Break Type
•
Menge  bestellter Menge
•
Gewicht  Gewicht pro Auftragszeile
•
Preis  Errechneter Preis pro Auftragszeile
•
Qualität  Resultat des QM Moduls (43)
•
Up Sell Adjustment
•
Override Price
•
Manual Add/Change
•
Mandatory Adjustment
•
Absolute Value (verwendet für SO/CO)
•
Apply on Override Price
•
Min/max Rules  Adjustment hat ein Min/Max Wert
7
UDC
•
40/SU: Default UOM responsible for pricing (40/PU: purchasing)
•
43/RU: rebate category
•
40/AP: preference schedule
•
40/RU: preference retrieval UOM
•
01/TS: organizational structure
•
40P/PS: Promotions System Flag
•
40/CO: Adjustment control codes
•
H95/RO: relational operator for rounding rules
8
System Setup P41001
9
Rabatt pro Artikel ab einer gewissen Menge
10
Zusätzliche Adjustments
•
Free Goods (Gratisartikel, Marketingartikel)
•
Quantity Per Ordered Factor = [(Quantity Ordered) − (From Level)] / (Quantity Per Ordered)
•
Total Free Goods Quantity = (Free Good Quantity Ordered) × (Quantity Per Ordered Factor)
•
zB: From Level = 10, Quantity per Ordered = 3, Free Good Quantity Ordered = 1
•
•
Volume-based Upselling
•
Information über nächsten Level-Break via Toleranzregel
•
•
Total Free Goods= (1) x (25-10)/3 = 5
Verkauft 9, Level Break bei 10, Toleranz 15%  9+15%=10.35  Info auf Screen, dass es bei
10 einen besseren Preis gibt
Rounding Rules
•
zB: 1.4583  1.4600 und 1.4547 1.4500
11
Zusätzliche Adjustments
•
Sliding rate discounts
•
zB: sliding rate für ein Artikel mit Basispreis 100.00.
•
Menge 0–99
Rabatt 0%
•
Menge 100–199
Rabatt 10%
•
Menge 200–299
Rabatt 20%
•
Menge >300
Rabatt 30%
•
Bestelle 250 (Artikel):
•
•
•
•
99 (Artikel) * 100.00 = 9’900.00.
100 (Artikel) * 90.00 = 9’000.00.
51 (Artikel) * 80.00 = 4’080.00.
Total 250 (Artikel)
22’980.00 (total) / 250 (Artikel) = 91.92 (Preis pro Artikel).
Beispiel aus dem Chemie-Leben
12
Lösung aus dem Chemie-Leben
13
Beispiel aus dem Öl-Business
=WENN(('Preis Formula'!$C$22-5)<('Preis Formula'!$C$7);('Preis Formula'!$C$7);WENN(('Preis
Formula'!$C$7+1.5)>('Preis Formula'!$C$22-5);('Preis Formula'!$C$22-5);('Preis
Formula'!$C$7+1.5)))
14
Lösung für das Öl-Business 1/2
$MIN(&C22-5|&C7+1.5)+$MAX(&C7-&C22+5|0)
15
Lösung für das Öl-Business 2/2
16
Fragen
Ihr Berater
Roland Rüegg
+41-41-922 28 28
[email protected]
17