Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0026553Openbravo ERP07. Sales managementpublic2014-05-15 10:492014-08-08 18:53
VictorVillar 
daniOpenbravo 
immediatemajoralways
closedfixed 
5
pi 
3.0PR14Q43.0PR14Q4 
AtulOpenbravo
Core
No
0026553: The Actual Amount in Details tab of the Commission Payment is wrong calculated under some circumstancies
The Actual Amount in Details tab of the Commission Payment is wrong calculated when you are working with Returns from Customer
As group Admin role,
Go to Commission window:
 create a new one:
   Org: Región Norte
   Basis Amount: Margin
   Sales Rep: Javier Martín
   Frequency Type: Monthly
   basis document: Invoice
   Cascade: Yes
   List Details: Yes
   Name: Commission
 Go to Lines tab:
   Based on Sales Rep: Yes
   Multiplier Amount: 1

Go to Sales Order:
   Create a new one for 1 unit of product Agua sin Gas 1L
   Business Partner: Alimentos y Supermercados
Go to Goods Shipment window:
   create one related to the Sales Order
Go to Sales invice window:
   create the one related to the Goods Shipment
   Sales Representative: Javier Martín

Go to Return from Customer window:
  create a new one for the Shipment created before
Go to Return Material Receipt window:
  select the Return from Customer created before.
Go to Sales invice window:
   create the one related to the Return from Customer
   Document type: Return Material Sales Invoice
   Sales Representative: Javier Martín

After that realise that the Costing Backgorund Processa has calculated all that new warehouse transactions (Goods Shipment and Return Material Receipt transactions), please check Transactions tab of the Product: Agua sin Gas.
Once those transactions will have been calculated:
 Go to Commission window:
   Generate the Commission
Then check the values in Commission Payment
  You can check the Amount value of the Details tab for the Return Line, which is the substract of the Invoice amount - Cost, but it should be the Margin = Invoice Amount + Cost

As a result of that the line of the original invoice line and the return invoice line will sum 0.
No tags attached.
related to defect 00259203.0PR14Q3 closed AtulOpenbravo The Actual Amount in Details tab of the Commision Payment is wrong calculated under some circumstancies 
Issue History
2014-05-15 10:49VictorVillarNew Issue
2014-05-15 10:49VictorVillarAssigned To => dmiguelez
2014-05-15 10:49VictorVillarModules => Core
2014-05-15 10:49VictorVillarTriggers an Emergency Pack => No
2014-05-15 10:57VictorVillarRelationship addedrelated to 0025920
2014-05-15 10:58VictorVillarIssue Monitored: networkb
2014-05-26 13:16ngarciaSummaryThe Actual Amount in Details tab of the Commision Payment is wrong calculated under some circumstancies => The Actual Amount in Details tab of the Commission Payment is wrong calculated under some circumstancies
2014-05-26 13:16ngarciaDescription Updatedbug_revision_view_page.php?rev_id=5877#r5877
2014-06-02 18:43jonalegriaesarteResolution time => 1403388000
2014-06-30 12:53eduardo_ArgalTarget VersionPR14Q3 => PR14Q4
2014-07-04 07:51dmiguelezAssigned Todmiguelez => jonalegriaesarte
2014-07-10 11:47daniOpenbravoAssigned Tojonalegriaesarte => daniOpenbravo
2014-07-10 11:47daniOpenbravoStatusnew => scheduled
2014-07-17 16:36hgbotCheckin
2014-07-17 16:36hgbotNote Added: 0068707
2014-07-17 16:36hgbotStatusscheduled => resolved
2014-07-17 16:36hgbotResolutionopen => fixed
2014-07-17 16:36hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/1939f4cf8828ca2089e90d13a03c5645a5891ac8 [^]
2014-07-17 16:50daniOpenbravoReview Assigned To => AtulOpenbravo
2014-07-17 16:50daniOpenbravoNote Added: 0068711
2014-07-17 16:50daniOpenbravoStatusresolved => closed
2014-07-17 16:50daniOpenbravoFixed in Version => 3.0PR14Q4
2014-08-08 18:53hudsonbotCheckin
2014-08-08 18:53hudsonbotNote Added: 0069178
2015-06-16 19:32aferrazRelationship addedrelated to 0030184
2015-06-16 19:52aferrazRelationship deletedrelated to 0030184

Notes
(0068707)
hgbot   
2014-07-17 16:36   
Repository: erp/devel/pi
Changeset: 1939f4cf8828ca2089e90d13a03c5645a5891ac8
Author: Daniel Ruiz <daniel.ruiz <at> openbravo.com>
Date: Thu Jul 10 18:12:58 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/1939f4cf8828ca2089e90d13a03c5645a5891ac8 [^]

Fixes Issue 26553: ActualAmount (Details tab,Commission Payment) is wrong calculated

---
M src-db/database/model/functions/C_COMMISSION_PROCESS.xml
---
(0068711)
daniOpenbravo   
2014-07-17 16:50   
Verified.
(0069178)
hudsonbot   
2014-08-08 18:53   
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/4450016dee64 [^]
Maturity status: Test