0009005: Delete one Price Adjustment for Sales Order line

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0009005

Openbravo ERP

07. Sales management

public

2009-05-12 12:42

2011-02-04 09:12

Reporter

pmagnin

Assigned To

rmorley

Priority

normal

Severity

minor

Reproducibility

have not tried

Status

acknowledged

Resolution

open

Platform

OS Version

Product Version

2.40MP3

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

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.

Steps To Reproduce

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.

Additional Information

Tags

tictech

Relationships

related to

feature request

0008161

closed

gmauleon

Not possible not to apply price adjustments for a specific order line

Attached Files