Openbravo Issue Tracking System - Openbravo ERP
* Starting date = 01-01-2000
* Discount % = 50
* Business Partner = All Selected
* Product = All Selected
2) Move to Business Partner tab and select one business partner
3) Move to Product tab and select one product
4) Create a new Sales or Purchase Order for the business partner of the price adjustment
5) Create one line for the product of the price adjustment.
Notice that the Discount field is correctly calculated as:
* Standard Price = SP (hidden)
* List Price = LP
* Discount = D = 100*(1-(SP/LP))
6) Save this line
7) Go to price adjustment tabs and see that the price adjustment has been correctly applied.
* List price: price used as reference in a Price list
* Standard price: price applied to customers after discount in Price list (this price is not shown in the sales order window, it is hidden)
* Discount: percentage (List price - Standard price)/List price
* Unit price: price finally applied after price adjustments
* Price adjustments: zero, one or many changes in the price applied in an order line. All of them together are the difference between Standard Price and Unit price
For further clarification see attached PricesRelations.png
From a technical perspective:
* There is no need to decouple price adjustments and order completion since they are already decoupled. Price adjustments are calculated when the line is entered through a trigger (c_orderline_trg2).
* Currently it is not possible to cancel (not to apply) price adjustments
* To achieve it, add a new column and a make a change to change c_orderline_trg2 trigger.
* This will be implemented using a check box in the order line ("Cancel Price Adjustments"), by default set to false (N).
* If the user wants avoid applying price adjustments in a particular line he has to check this check-box and save the line.
* The trigger would remove all the changes over the standard price through price adjustements.
* Visibility of price adjustments will also be improved by showing 'Standard Price' right-only field. Right now Standard price is hidden, so it is not easy to understand how the numbers are calculated. It will be clearer for the user how the discount is calculated and what lines have price adjustements (Unit price different from Standard Price)
Eg.
List price: 10
Unit price: 5
Discount: 20%
Standard price: 8 (not shown)
The distribution of fields in Order Lines would be like OrderLines.png.
* 'Standard Price' text field would display below 'Unit Price' field and will be read-only.
* 'Cancel Price Adjustment' check-box would display below Currency' field.
* These two fields will be shown based on the following display logic: UP != SP OR CPA = Y (UP = Unit Price; SP = Standard Price; CPA = Cancel Price Adjustments)
| related to | defect | 0008275 | acknowledged | jonalegriaesarte | Correctly document Prices relations | |
| related to | feature request | 0009005 | pi | acknowledged | rmorley | Delete one Price Adjustment for Sales Order line |
| related to | feature request | 0029623 | new | Triage Omni OMS | It would be fine to have the Cancel Promotions option in invoice lines not to apply the Price Adjustments |
PricesRelation.png (19,705) 2009-03-25 10:17https://issues.openbravo.com/file_download.php?file_id=1061&type=bug
OrderLines.png (83,362) 2009-03-25 10:17https://issues.openbravo.com/file_download.php?file_id=1062&type=bug