Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020491Openbravo ERP07. Sales managementpublic2012-05-14 14:012012-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 ticket15456
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020491: Not be able to generate commissions until invoice is paid
DescriptionNot be able to generate commissions until invoice is paid
Steps To ReproduceCurrently way to generate commissions in Openbravo is based on invoice's amount but process is not considering if invoice is paid or not. It would be nice to be able to generate commission only once invoice is fully paid.
Proposed SolutionAbility to define commissions based on "Fully paid invoices".

- Change the label of "Commissions basis" to "Basis document" (Order, Invoice). Needs to be mandatory
- Add a new property to commission: "Basis status" (All documents, Fully paid documents)
- Add a validation rule, so when "Basis document" is Order then "Basis status" is restricted to "All documents" and "Basis amount" is restricted to "Net amount"
Additional Information
TagsNo tags attached.
Relationships
has duplicate feature request 0020720 closed mirurita Commissions do not take into account if an invoice is paid or partially paid 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-05-14 14:01maiteNew Issue
2012-05-14 14:01maiteAssigned To => mirurita
2012-05-14 14:01maiteModules => Core
2012-05-14 14:01maiteOBNetwork customer => Yes
2012-05-14 14:01maiteSupport ticket => 15456
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 11:52naiaramartinezRelationship addedhas duplicate 0020720
2012-08-06 12:13psarobefix_in_branchpi =>
2012-08-06 12:13psarobeProposed Solution updated
2012-08-23 10:01hgbotCheckin
2012-08-23 10:01hgbotNote Added: 0051483
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: 0051486
2012-08-23 10:02hgbotCheckin
2012-08-23 10:02hgbotNote Added: 0051491
2012-08-27 12:35hgbotCheckin
2012-08-27 12:35hgbotNote Added: 0051566
2012-08-29 09:14hgbotCheckin
2012-08-29 09:14hgbotNote Added: 0051611
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: 0051725

Notes
(0051483)
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
---
(0051486)
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
---
(0051491)
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
---
(0051566)
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
---
(0051611)
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
---
(0051725)
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