0005544: Running commissions gives an incorrect error

(0009646)
psarobe (viewer)
2008-10-20 11:31

This should be the first validation

(0010252)
azabaleta (viewer)
2008-11-13 17:11

When creating a comission there is a "product" field. This field is not mandatory. I create a comission without selecting a product.

After, when you want to create purchase invoices of this comissions (to pay your sales representatives) in comission payment if you click the button create invoices, you will get an error saying that the business partner does not have an address or something similar.

The real error is that the comission does not have a product selected, so the PL should be revised.

(0010406)
Dowid (viewer)
2008-11-19 13:57
edited on: 2008-11-19 13:59

The PL has been modified to operate correctly when the "Invoice Product" field is empty.

The following code has been replaced:

SELECT com.C_Currency_ID, com.C_BPartner_ID, pl.C_BPartner_Location_ID,
            PaymentRulePO, PO_PaymentTerm_ID, PO_PriceList_ID,
          POReference, IsDiscountPrinted, p.SalesRep_ID, com.M_Product_ID, C_UOM_ID, p.name as bpartnername
         FROM M_Product prd, C_BPARTNER p, C_COMMISSION com LEFT JOIN C_BPARTNER_LOCATION pl ON com.C_BPartner_ID = pl.C_BPartner_ID
         WHERE com.C_Commission_ID = CUR_ComRun.C_Commission_ID
           AND com.C_BPartner_ID = p.C_BPartner_ID
            AND com.M_Product_ID = prd.M_Product_ID

New code:

SELECT com.C_Currency_ID, com.C_BPartner_ID, pl.C_BPartner_Location_ID,
            PaymentRulePO, PO_PaymentTerm_ID, PO_PriceList_ID,
          POReference, IsDiscountPrinted, p.SalesRep_ID, com.M_Product_ID, C_UOM_ID, p.name as bpartnername
         FROM C_BPARTNER p, C_COMMISSION com LEFT JOIN C_BPARTNER_LOCATION pl ON com.C_BPartner_ID = pl.C_BPartner_ID
                                LEFT JOIN M_Product prd ON com.M_Product_ID = prd.M_Product_ID
         WHERE com.C_Commission_ID = CUR_ComRun.C_Commission_ID
           AND com.C_BPartner_ID = p.C_BPartner_ID

(0010408)
svnbot (viewer)
2008-11-19 14:16

Repository: openbravo
Revision: 10236
Author: dowid
Date: 2008-11-19 14:16:54 +0100 (Wed, 19 Nov 2008)

Fixed bug 0005544: Running commissions gives an incorrect error

---
U trunk/src-db/database/model/functions/C_COMMISSIONRUN_PROCESS.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=10236&sc=1 [^]

(0010621)
psarobe (viewer)
2008-11-25 11:51

You can find the commission in:

Sales management->Setup->commision
Click new and fill the mandatory fields. Don't fill the product
save
click on Generate commission. click OK.
A message should show up saying that the product is not filled

(0010947)
azabaleta (viewer)
2008-12-03 18:24

I dont understand why a bug can be marked as resolved before the person who reported it test the solution or at least give the ok.

In this case Im not happy with the solution, nor with the user experience for realizing the problem in the commision.

(0011295)
psarobe (viewer)
2008-12-13 19:03

dowid,

If you read the propuse solution says: Before validating if the sales representative has address, payment form, terms... the PL should validate if the commission has a product.

So the first thing it's to validate the product but given that it's not even doing that. When the user clicks the button Create invoice in Sales Management || Transactions || Commission Payment || Header you first have to check if exists a product in Sales Management || Setup || Commission || Header

Regards

(0011296)
psarobe (viewer)
2008-12-13 19:04

Please take also a look if you also did wrong in the backport

(0011426)
Dowid (viewer)
2008-12-16 16:48

Azabaleta thank you for advice.
I've made a decision to use another solution for this bug. Below is an explanation of my solution.

Step for test.

1. Go to Sales management->Setup->commision. Click new and fill the mandatory fields. Don't fill the "invoiced product"
2. click on "Generate commission".
3. Go to Sales Management->Transactions->Commission Payment->Header. Select generated commission and click "Create Invoice"

My solution allows process "Create invoice" to complete with an empty "invoiced product".

Because:

The field "Invoice Product" is not mandatory. (In the Sales Management-> Setup -> Commission -> Header)
The field "Product" in the generated purchase invoice is not mandanatory too.

So, I think that the "Create invoice" process shouldn't stop if "Invoice Product" field is empty.

On the other hand, If you beleive that the Commission should have the "Invoiced Product" field filled in, then this field should be set in the Application dictionary as mandatory.

(0011544)
svnbot (viewer)
2008-12-18 17:48

Repository: openbravo
Revision: 11390
Author: dowid
Date: 2008-12-18 17:48:44 +0100 (Thu, 18 Dec 2008)

Bug fixed 0005544: Running commissions gives an incorrect error
Fixed according to the solution proposed by azabaleta and Pablo Sarobe.

---
U trunk/src-db/database/model/functions/C_COMMISSIONRUN_PROCESS.xml
U trunk/src-db/database/sourcedata/AD_MESSAGE.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=11390&sc=1 [^]

Notes
(0009646) psarobe (viewer) 2008-10-20 11:31	This should be the first validation

(0010252) azabaleta (viewer) 2008-11-13 17:11	When creating a comission there is a "product" field. This field is not mandatory. I create a comission without selecting a product. After, when you want to create purchase invoices of this comissions (to pay your sales representatives) in comission payment if you click the button create invoices, you will get an error saying that the business partner does not have an address or something similar. The real error is that the comission does not have a product selected, so the PL should be revised.

(0010406) Dowid (viewer) 2008-11-19 13:57 edited on: 2008-11-19 13:59	The PL has been modified to operate correctly when the "Invoice Product" field is empty. The following code has been replaced: SELECT com.C_Currency_ID, com.C_BPartner_ID, pl.C_BPartner_Location_ID, PaymentRulePO, PO_PaymentTerm_ID, PO_PriceList_ID, POReference, IsDiscountPrinted, p.SalesRep_ID, com.M_Product_ID, C_UOM_ID, p.name as bpartnername FROM M_Product prd, C_BPARTNER p, C_COMMISSION com LEFT JOIN C_BPARTNER_LOCATION pl ON com.C_BPartner_ID = pl.C_BPartner_ID WHERE com.C_Commission_ID = CUR_ComRun.C_Commission_ID AND com.C_BPartner_ID = p.C_BPartner_ID AND com.M_Product_ID = prd.M_Product_ID New code: SELECT com.C_Currency_ID, com.C_BPartner_ID, pl.C_BPartner_Location_ID, PaymentRulePO, PO_PaymentTerm_ID, PO_PriceList_ID, POReference, IsDiscountPrinted, p.SalesRep_ID, com.M_Product_ID, C_UOM_ID, p.name as bpartnername FROM C_BPARTNER p, C_COMMISSION com LEFT JOIN C_BPARTNER_LOCATION pl ON com.C_BPartner_ID = pl.C_BPartner_ID LEFT JOIN M_Product prd ON com.M_Product_ID = prd.M_Product_ID WHERE com.C_Commission_ID = CUR_ComRun.C_Commission_ID AND com.C_BPartner_ID = p.C_BPartner_ID

(0010408) svnbot (viewer) 2008-11-19 14:16	Repository: openbravo Revision: 10236 Author: dowid Date: 2008-11-19 14:16:54 +0100 (Wed, 19 Nov 2008) Fixed bug 0005544: Running commissions gives an incorrect error --- U trunk/src-db/database/model/functions/C_COMMISSIONRUN_PROCESS.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=10236&sc=1 [^]

(0010621) psarobe (viewer) 2008-11-25 11:51	You can find the commission in: Sales management->Setup->commision Click new and fill the mandatory fields. Don't fill the product save click on Generate commission. click OK. A message should show up saying that the product is not filled

(0010947) azabaleta (viewer) 2008-12-03 18:24	I dont understand why a bug can be marked as resolved before the person who reported it test the solution or at least give the ok. In this case Im not happy with the solution, nor with the user experience for realizing the problem in the commision.

(0011295) psarobe (viewer) 2008-12-13 19:03	dowid, If you read the propuse solution says: Before validating if the sales representative has address, payment form, terms... the PL should validate if the commission has a product. So the first thing it's to validate the product but given that it's not even doing that. When the user clicks the button Create invoice in Sales Management \|\| Transactions \|\| Commission Payment \|\| Header you first have to check if exists a product in Sales Management \|\| Setup \|\| Commission \|\| Header Regards

(0011296) psarobe (viewer) 2008-12-13 19:04	Please take also a look if you also did wrong in the backport

(0011426) Dowid (viewer) 2008-12-16 16:48	Azabaleta thank you for advice. I've made a decision to use another solution for this bug. Below is an explanation of my solution. Step for test. 1. Go to Sales management->Setup->commision. Click new and fill the mandatory fields. Don't fill the "invoiced product" 2. click on "Generate commission". 3. Go to Sales Management->Transactions->Commission Payment->Header. Select generated commission and click "Create Invoice" My solution allows process "Create invoice" to complete with an empty "invoiced product". Because: The field "Invoice Product" is not mandatory. (In the Sales Management-> Setup -> Commission -> Header) The field "Product" in the generated purchase invoice is not mandanatory too. So, I think that the "Create invoice" process shouldn't stop if "Invoice Product" field is empty. On the other hand, If you beleive that the Commission should have the "Invoiced Product" field filled in, then this field should be set in the Application dictionary as mandatory.

(0011544) svnbot (viewer) 2008-12-18 17:48	Repository: openbravo Revision: 11390 Author: dowid Date: 2008-12-18 17:48:44 +0100 (Thu, 18 Dec 2008) Bug fixed 0005544: Running commissions gives an incorrect error Fixed according to the solution proposed by azabaleta and Pablo Sarobe. --- U trunk/src-db/database/model/functions/C_COMMISSIONRUN_PROCESS.xml U trunk/src-db/database/sourcedata/AD_MESSAGE.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=11390&sc=1 [^]

Issue History
Date Modified	Username	Field	Change
2008-10-16 10:15	azabaleta	New Issue
2008-10-16 10:15	azabaleta	Assigned To	=> cromero
2008-10-16 10:15	azabaleta	sf_bug_id	0 => 2170921
2008-10-20 11:31	psarobe	Status	new => scheduled
2008-10-20 11:31	psarobe	Note Added: 0009646
2008-10-20 11:31	psarobe	Assigned To	cromero => Dowid
2008-10-20 11:31	psarobe	fix_in_branch	=> trunk
2008-11-13 17:11	azabaleta	Note Added: 0010252
2008-11-19 13:57	Dowid	Note Added: 0010406
2008-11-19 13:59	Dowid	Note Edited: 0010406
2008-11-19 14:16	svnbot	Checkin
2008-11-19 14:16	svnbot	Note Added: 0010408
2008-11-19 14:16	svnbot	Status	scheduled => resolved
2008-11-19 14:16	svnbot	Resolution	open => fixed
2008-11-19 14:16	svnbot	svn_revision	=> 10236
2008-11-25 11:51	psarobe	Note Added: 0010621
2008-12-03 18:24	azabaleta	Note Added: 0010947
2008-12-13 19:03	psarobe	Status	resolved => new
2008-12-13 19:03	psarobe	Resolution	fixed => open
2008-12-13 19:03	psarobe	Note Added: 0011295
2008-12-13 19:04	psarobe	Status	new => scheduled
2008-12-13 19:04	psarobe	Note Added: 0011296
2008-12-16 16:48	Dowid	Note Added: 0011426
2008-12-18 17:48	svnbot	Checkin
2008-12-18 17:48	svnbot	Note Added: 0011544
2008-12-18 17:48	svnbot	Status	scheduled => resolved
2008-12-18 17:48	svnbot	Resolution	open => fixed
2008-12-18 17:48	svnbot	svn_revision	10236 => 11390
2009-04-21 11:07	psarobe	Status	resolved => closed