Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 07. Sales managementminorhave not tried2009-05-12 12:422011-02-04 09:12
ReporterpmagninView Statuspublic 
Assigned Tormorley 
PrioritynormalResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Versionpi
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40MP3SCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0009005: Delete one Price Adjustment for Sales Order line

DescriptionWe develop for the FR 0008161 new functionalities to inactivate the Price adjustments associated to a Sales Order Line. We can only activate or inactivate all of them. The current functionality does not allow you inactivating only on Price Adjustment, or inserting a new Price Adjustment.

1) To develop this FR, you need first to activate the “Edit” mode of the price adjustment page (see attachment PriceAdjustmentPageEdittable.png)
2) ant compile.development –Dtab=”Sales” + Restart Tomcat
3) Check you have a Price adjustment for the Business Partner “MyBP” and the product “MyProduct” (Master Data Management\Pricing\Price Adjustments).
4) Create a new Sales Order, for MyPB and MyProduct
5) Verify you have the line(s) of price adjustment and check the calculation :

List Price (LP) = A
Standard Price (SP) = A –Discount*A/100
Price Adjustment (PA)=B
Unit Price (UP)=SP-PA= A –Discount*A/100-B

Trigger Events:
Origin table: C_Orderline_Offer
Target table: C_OrderLine

On Delete: Check you have UP=SP
On Insert: Check you have UP=SP – new PA
On update: Check you have UP=SP – modified PA

For all the events, check you have a Line Net amount recalculated as regard the Unite price amount.

This FR could be package as a module with the FR 0008161.
Proposed Solution1 - Modify as "Edditable" the Price Adjustment page.

2 - Inactivate trigger on UNIT PRICE (PU) (modified by Process “Apply Price Adjustment”)

3 - Button “Apply Price Adjustment” that calculate the PU as regard the c_ordeline_offer table (and not the m_offer table).

Warning1: If the user modify the price adjustment list (c_orderline_offer) and don’t go back to the sales order line page to click on the button “Apply Price Adjustment”, the Unit Price won’t be recalculated (impossible to activate a trigger based on c_orderline_offer to modify the c_orderline).

Warning2 : Any modification on the sales order line (except PU) will re-generated as usually the list of Price adjustments..

Warning3: This workaround is client specific.
Attached Filespng file icon PriceAdjustmentPageEdittable.png [^] (25,749 bytes) 2009-05-12 12:42

- Relationships Relation Graph ] Dependency Graph ]
related to feature request 0008161 closedgmauleon Not possible not to apply price adjustments for a specific order line 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2009-05-12 12:42 pmagnin New Issue
2009-05-12 12:42 pmagnin Assigned To => rafaroda
2009-05-12 12:42 pmagnin File Added: PriceAdjustmentPageEdittable.png
2009-05-12 12:42 pmagnin Regression testing => No
2009-05-12 14:04 rafaroda Assigned To rafaroda => gmauleon
2009-05-12 14:04 rafaroda Status new => acknowledged
2009-05-12 14:04 rafaroda Relationship added related to 0008161
2009-05-12 14:04 rafaroda Tag Attached: tictech
2009-05-12 16:12 gmauleon Status acknowledged => scheduled
2009-05-12 16:12 gmauleon fix_in_branch => pi
2009-05-14 16:59 pmagnin fix_in_branch pi =>
2009-05-14 16:59 pmagnin Steps to Reproduce Updated
2009-05-26 21:43 pjuvara Priority immediate => urgent
2009-08-06 15:42 rafaroda Assigned To gmauleon => pjuvara
2009-08-06 15:42 rafaroda Priority urgent => normal
2009-08-06 17:39 rafaroda Status scheduled => acknowledged
2011-02-04 09:12 jpabloae Assigned To pjuvara => rmorley

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker