Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0020501Openbravo ERP07. Sales managementpublic2012-05-15 09:372012-09-01 01:02
maite 
naiaramartinez 
urgentmajoralways
closedfixed 
5
 
3.0MP15 
Core
No
0020501: Be able to calculate commissions based on margin amount instead of total amount
Ability to calculate commissions based on margin - either for "Any invoices" and for "Fully paid invoices"- (additional to commissions based on net amounts currently supported)
For 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)
Add a new property to commissions: "Basis amount" (Net amount, Margin). Needs to be mandatory. Margin will only work for invoices
No tags attached.
Issue History
2012-05-15 09:37maiteNew Issue
2012-05-15 09:37maiteAssigned To => mirurita
2012-05-15 09:37maiteModules => Core
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