Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021317Openbravo ERP07. Sales managementpublic2012-08-06 13:342012-09-01 01:02
Reporterpsarobe 
Assigned Tonaiaramartinez 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version3.0MP15 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0021317: Ability to better manage complex commissions
DescriptionScenario:
* 1 "exempt" rule for "exempt" Business Partner
* 10 "exempt" rules for "exempt" products
* 1 “exempt” rule for product category
* 10 rules for products at 10% rate
* 1 rule for "all other" business partners/products at 5%

See proposed solution
Steps To ReproduceN/A
Proposed SolutionSolution at high level:
* First line: Calculate commission at 5% for all business partner and products
* Second line: But for these 10 products the commission must be 10%. Not 10 % plus the 5% calculates in the first line. So this line will remove what was calculated previously for these 10 products (5%) and apply a new commission of 10%
* Third line: Remove commissions calculated for a specific business partner, that is, ability to exclude a business partner
* Fourth line: Remove commissions calculate for a specific product category
* Fifth line: Remove the commission calculated for this product (in complex scenario for 10 products), that is, ability to exclude a product.

So finally the result of the commission will be the combination of these five lines (in fact there will be more lines since each specific product or business partner requires a line)

It will also possible to exclude a business partner category or a product category
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-08-06 13:34psarobeNew Issue
2012-08-06 13:34psarobeAssigned To => naiaramartinez
2012-08-06 13:34psarobeModules => Core
2012-08-21 14:44naiaramartinezStatusnew => scheduled
2012-08-21 14:44naiaramartinezfix_in_branch => pi
2012-08-23 10:01hgbotCheckin
2012-08-23 10:01hgbotNote Added: 0051489
2012-08-23 10:01hgbotStatusscheduled => resolved
2012-08-23 10:01hgbotResolutionopen => fixed
2012-08-23 10:01hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d4fff8c92a1031aaf37086db17fefb8612772b72 [^]
2012-08-23 10:02hgbotCheckin
2012-08-23 10:02hgbotNote Added: 0051490
2012-08-27 12:35hgbotCheckin
2012-08-27 12:35hgbotNote Added: 0051567
2012-08-27 14:53hgbotCheckin
2012-08-27 14:53hgbotNote Added: 0051573
2012-08-29 09:14hgbotCheckin
2012-08-29 09:14hgbotNote Added: 0051610
2012-08-29 09:42psarobeStatusresolved => closed
2012-08-29 09:42psarobeFixed in Version => 3.0MP15
2012-09-01 01:02hudsonbotCheckin
2012-09-01 01:02hudsonbotNote Added: 0051724

Notes
(0051489)
hgbot   
2012-08-23 10:01   
Repository: erp/devel/pi
Changeset: d4fff8c92a1031aaf37086db17fefb8612772b72
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Fri Aug 17 14:19:10 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d4fff8c92a1031aaf37086db17fefb8612772b72 [^]

fixed bug 21317, Related to issue 20491, related to issue 20501, related to issue 20468
Ability to better manage complex commissions.

---
M src-db/database/model/functions/C_COMMISSIONRUN_PROCESS.xml
M src-db/database/model/functions/C_COMMISSION_PROCESS.xml
M src-db/database/model/tables/C_COMMISSION.xml
M src-db/database/model/tables/C_COMMISSIONDETAIL.xml
M src-db/database/model/tables/C_COMMISSIONLINE.xml
M src-db/database/sourcedata/AD_CALLOUT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
M src-db/database/sourcedata/AD_MODEL_OBJECT.xml
M src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml
A src/org/openbravo/erpCommon/ad_callouts/SL_Commission_ListDetails.java
---
(0051490)
hgbot   
2012-08-23 10:02   
Repository: erp/devel/pi
Changeset: 04a9113ccbfc833d533a216bb757c76e9659c5de
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Mon Aug 20 14:44:27 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/04a9113ccbfc833d533a216bb757c76e9659c5de [^]

Related to issue 21317, Related to issue 20491, related to issue 20501, related to issue 20468
Change ad_sequence_next for get_uuid(). Delete commented text and delete an if that is
an impossible case. Modify a query that included innecessary tables.
Improve the error message.

---
M src-db/database/model/functions/C_COMMISSION_PROCESS.xml
M src-db/database/model/tables/C_COMMISSION.xml
M src-db/database/model/tables/C_COMMISSIONDETAIL.xml
M src-db/database/model/tables/C_COMMISSIONLINE.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
---
(0051567)
hgbot   
2012-08-27 12:35   
Repository: erp/devel/pi
Changeset: f6bb391d61647754c46ab28a373f59e80d299459
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Mon Aug 27 12:31:59 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f6bb391d61647754c46ab28a373f59e80d299459 [^]

Related to issue 20501, Related to issue 20491, Related to issue 21317, Related to issue 20468
Hide fields in grid view and change their order.

---
M src-db/database/sourcedata/AD_FIELD.xml
---
(0051573)
hgbot   
2012-08-27 14:53   
Repository: erp/devel/pi
Changeset: 8d97dad9745c96067316cdf1e10010d86dbcfeef
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Mon Aug 27 14:51:48 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/8d97dad9745c96067316cdf1e10010d86dbcfeef [^]

related to issue 21317 Add read only logic to fields that have display logic
in order to not be able to edit them in grid view

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0051610)
hgbot   
2012-08-29 09:14   
Repository: erp/devel/pi
Changeset: 0f98157d9e2b0fc156fcd43c51c5313d2a8cdf1f
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Wed Aug 29 09:11:25 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/0f98157d9e2b0fc156fcd43c51c5313d2a8cdf1f [^]

Related to issue 21317, Related to issue 20491, related to issue 20501, related to issue 20468
Get the uuid in a variable and use that variable.

---
M src-db/database/model/functions/C_COMMISSION_PROCESS.xml
---
(0051724)
hudsonbot   
2012-09-01 01:02   
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/05b3ea484705 [^]

Maturity status: Test