0009005: Delete one Price Adjustment for Sales Order line

Description

We 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.

Solution:
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 Solution

1 - 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.

Tags

tictech

Attached Files

PriceAdjustmentPageEdittable.png [^] (25,749 bytes) 2009-05-12 12:42

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

feature request

0008161

closed

gmauleon

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