Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0023629 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 03. Procurement management | major | always | 2013-04-24 17:06 | 2013-05-02 11:26 | |||
Reporter | VictorVillar | View Status | public | |||||
Assigned To | jonalegriaesarte | |||||||
Priority | urgent | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | aae254b2941b | ||||
Projection | none | ETA | none | Target Version | 3.0MP23 | |||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | pi | SCM revision | ||||||
Review Assigned To | VictorVillar | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0023629: currency order lines does not update its value regarding currency order header | |||||||
Description | currency order lines does not update its value regarding currency order header | |||||||
Steps To Reproduce | As Admin role, Go to Purchase order window, Create a new register business partner: Bebidas Alegres Price list: Tarifas Bebidas Alegres Save it, realise currency= EUR Lines tab: Create a new register Save it. Go to Price List window, Select Tarifa Bebidas Alegres Currency: USD Save it Go to the Purchase order created before, select again the Price List and save the header. Realise that the order now is in USD, but you can check via database that the lines linked are in EUR yet. | |||||||
Proposed Solution | in the c_order_chk_restriction_trg() add the COALESCE(old.C_Currency_ID, '0') <> COALESCE(NEW.C_Currency_ID, '0') to the following IF condition: IF (COALESCE(OLD.C_BPartner_ID, '0')!=COALESCE(NEW.C_BPartner_ID, '0')) OR (COALESCE(OLD.M_PriceList_ID,'0') != COALESCE(NEW.M_PriceList_ID,'0')) THEN SELECT COUNT(*) INTO v_n FROM C_ORDERLINE WHERE C_Order_ID = NEW.C_Order_ID; IF v_n>0 THEN RAISE EXCEPTION '%', '@20502@' ; --OBTG:-20000-- END IF; END IF; This could be an option | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0058307) hgbot (developer) 2013-04-29 18:10 |
Repository: erp/devel/pi Changeset: aae254b2941b185e4181cca708b83138e304adae Author: Jon AlegrÃa <jon.alegria <at> openbravo.com> Date: Mon Apr 29 18:10:06 2013 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/aae254b2941b185e4181cca708b83138e304adae [^] Fixes issue 0023629: currency order lines does not update its value regarding currency order header --- M src-db/database/model/triggers/C_ORDER_CHK_RESTRINCTIONS_TRG.xml --- |
(0058385) hudsonbot (developer) 2013-04-30 21:05 |
A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/3ea22ca7a348 [^] Maturity status: Test |
(0058403) VictorVillar (developer) 2013-05-02 11:26 |
Verified |
Issue History | |||
Date Modified | Username | Field | Change |
2013-04-24 17:06 | VictorVillar | New Issue | |
2013-04-24 17:06 | VictorVillar | Assigned To | => dmiguelez |
2013-04-24 17:06 | VictorVillar | Modules | => Core |
2013-04-24 17:06 | VictorVillar | Resolution time | => 1369346400 |
2013-04-24 17:06 | VictorVillar | Triggers an Emergency Pack | => No |
2013-04-24 17:06 | VictorVillar | Issue Monitored: networkb | |
2013-04-24 17:20 | VictorVillar | Proposed Solution updated | |
2013-04-24 17:31 | dmiguelez | Assigned To | dmiguelez => jonalegriaesarte |
2013-04-29 18:10 | hgbot | Checkin | |
2013-04-29 18:10 | hgbot | Note Added: 0058307 | |
2013-04-29 18:10 | hgbot | Status | new => resolved |
2013-04-29 18:10 | hgbot | Resolution | open => fixed |
2013-04-29 18:10 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/aae254b2941b185e4181cca708b83138e304adae [^] |
2013-04-30 21:05 | hudsonbot | Checkin | |
2013-04-30 21:05 | hudsonbot | Note Added: 0058385 | |
2013-05-02 11:26 | VictorVillar | Review Assigned To | => VictorVillar |
2013-05-02 11:26 | VictorVillar | Note Added: 0058403 | |
2013-05-02 11:26 | VictorVillar | Status | resolved => closed |
Copyright © 2000 - 2009 MantisBT Group |