Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020501Openbravo ERP07. Sales managementpublic2012-05-15 09:372012-09-01 01:02
Reportermaite 
Assigned Tonaiaramartinez 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0MP15 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket15455
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020501: Be able to calculate commissions based on margin amount instead of total amount
DescriptionAbility to calculate commissions based on margin - either for "Any invoices" and for "Fully paid invoices"- (additional to commissions based on net amounts currently supported)
Steps To ReproduceFor example: specific product is sold for 100€. But this product had cost of 25€. Commission will be calculated based on 75€ (which is margin for this product) instead of 100€ (which is price for this product)
Proposed SolutionAdd a new property to commissions: "Basis amount" (Net amount, Margin). Needs to be mandatory. Margin will only work for invoices
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-05-15 09:37maiteNew Issue
2012-05-15 09:37maiteAssigned To => mirurita
2012-05-15 09:37maiteModules => Core
2012-05-15 09:37maiteOBNetwork customer => Yes
2012-05-15 09:37maiteSupport ticket => 15455
2012-05-23 13:52gorkaionAssigned Tomirurita => gorkaion
2012-08-06 09:35gorkaionStatusnew => scheduled
2012-08-06 09:35gorkaionAssigned Togorkaion => naiaramartinez
2012-08-06 09:35gorkaionfix_in_branch => pi
2012-08-06 12:20psarobefix_in_branchpi =>
2012-08-06 12:20psarobeDescription Updatedbug_revision_view_page.php?rev_id=3702#r3702
2012-08-06 12:20psarobeProposed Solution updated
2012-08-23 10:01hgbotCheckin
2012-08-23 10:01hgbotNote Added: 0051484
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/05cc2ec23463b38aacc9ac372c6563c3f017beac [^]
2012-08-23 10:01hgbotCheckin
2012-08-23 10:01hgbotNote Added: 0051487
2012-08-23 10:02hgbotCheckin
2012-08-23 10:02hgbotNote Added: 0051492
2012-08-27 12:35hgbotCheckin
2012-08-27 12:35hgbotNote Added: 0051565
2012-08-29 09:14hgbotCheckin
2012-08-29 09:14hgbotNote Added: 0051612
2012-08-29 09:43psarobeStatusresolved => closed
2012-08-29 09:43psarobeFixed in Version => 3.0MP15
2012-09-01 01:02hudsonbotCheckin
2012-09-01 01:02hudsonbotNote Added: 0051726

Notes
(0051484)
hgbot   
2012-08-23 10:01   
Repository: erp/devel/pi
Changeset: 05cc2ec23463b38aacc9ac372c6563c3f017beac
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Fri Aug 03 08:25:26 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/05cc2ec23463b38aacc9ac372c6563c3f017beac [^]

fixed bug 20491, fixed bug 20501, fixed bug 20468: commissions (semi-monthly, fully paid doc, margin)

---
M src-db/database/model/functions/C_COMMISSION_PROCESS.xml
M src-db/database/model/tables/C_COMMISSION.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_REFERENCE.xml
M src-db/database/sourcedata/AD_REF_LIST.xml
M src-db/database/sourcedata/AD_VAL_RULE.xml
---
(0051487)
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
---
(0051492)
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
---
(0051565)
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
---
(0051612)
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
---
(0051726)
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