0030184: Wrong commission amount if the invoice has fractionated payment terms but it is paid in the same commission period - Openbravo Issue Tracking System

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

ID

Project

Category

View Status

Date Submitted

Last Update

0030184

Openbravo ERP

07. Sales management

public

2015-06-15 16:07

2015-06-23 16:47

Reporter

ngarcia

Assigned To

aferraz

Priority

immediate

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS

5

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

vmromanos

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Production - QA Approved

Regression date

2015-02-18

Regression introduced in release

3.0PR15Q2

Regression introduced by commit

https://code.openbravo.com/erp/devel/pi/rev/a1c3c8123501 [^]

Triggers an Emergency Pack

No

Summary

0030184: Wrong commission amount if the invoice has fractionated payment terms but it is paid in the same commission period

Description

Wrong commission amount if the invoice has fractionated payment terms but it is paid in the same commission period

Steps To Reproduce

As group admin role:
   Create a Commission
      Basis Document: Invoice
      Basis Status: Fully paid documents
      Basis Amount: Net amount
   Add a line to it:
      Based on Sales Rep.: 'Y'
      Business Partner Category: 'Customer - Tier 3'
      Multiplier amount: 0.13
   Create a Payment Term:
      Overdue Payment Days Rule: 60
   Add a line to it
      Percentage Due: 50
      Overdue Payment Days Rule: 30
   Create a Sales Invoice for 'Hoteles Buenas Noches, S.A.'
   Add the previously defined sales representative and payment terms
   Add a line with any product and quantity and tax: Ventas exentas
   Complete it
   Pay it in one payment
   Go to Commission window and click on Generate Commission process
   Go to Commission Payment window and check there is only one line with the Actual Amount different from the invoice's total net amount

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

related to	defect	0027280	3.0PR15Q1	closed	reinaldoguerra	Commission payment details are duplicated if the invoice has fractionated payment terms
depends on	backport	0030192	3.0PR15Q2.3	closed	aferraz	Wrong commission amount if the invoice has fractionated payment terms but it is paid in the same commission period
caused by	defect	0028772	3.0PR15Q2	closed	AtulOpenbravo	Commission payment details are duplicated if the invoice is paid in two different months
related to	defect	0031107		closed	vmromanos	Only the commission related with the payment amount of the last payment is considered when invoice has split payment plan

Attached Files

Issue History

Date Modified

Username

Field

Change

2015-06-15 16:07

New Issue

2015-06-15 16:07

Assigned To

=> Triage Finance

2015-06-15 16:07

Modules

=> Core

2015-06-15 16:07

Resolution time

=> 1436738400

2015-06-15 16:07

Triggers an Emergency Pack

=> No

2015-06-15 16:08

Relationship added

caused by 0027280

2015-06-15 16:09

Issue Monitored: networkb

2015-06-15 16:18

Issue Monitored: heccam

2015-06-15 18:08

Assigned To

Triage Finance => aferraz

2015-06-16 19:31

Relationship deleted

caused by 0027280

2015-06-16 19:31

Relationship added

related to 0027280

2015-06-16 19:31

Relationship added

caused by 0028772

2015-06-16 19:32

Relationship added

related to 0026553

2015-06-16 19:41

Regression level

=> Production - QA Approved

2015-06-16 19:41

Regression date

=> 2015-02-18

2015-06-16 19:41

Regression introduced in release

=> 3.0PR15Q2

2015-06-16 19:41

Regression introduced by commit

=> https://code.openbravo.com/erp/devel/pi/rev/a1c3c8123501 [^]

2015-06-16 19:42

Status

new => scheduled

2015-06-16 19:51

Note Added: 0078330

2015-06-16 19:52

Relationship deleted

related to 0026553

2015-06-16 19:57

Note Edited: 0078330

bug_revision_view_page.php?bugnote_id=0078330#r8843

2015-06-16 19:58

Steps to Reproduce Updated

bug_revision_view_page.php?rev_id=8845#r8845

2015-06-22 11:30

Checkin

2015-06-22 11:30

Note Added: 0078405

2015-06-22 11:30

Status

scheduled => resolved

2015-06-22 11:30

Resolution

open => fixed

2015-06-22 11:30

Fixed in SCM revision

=> http://code.openbravo.com/erp/devel/pi/rev/eb4384a42e54d1e4b3584e2ab205fab64291475d [^]

2015-06-22 11:32

Review Assigned To

=> vmromanos

2015-06-22 11:32

Note Added: 0078406

2015-06-22 11:32

Status

resolved => closed

2015-06-23 16:47

Checkin

2015-06-23 16:47

Note Added: 0078440

2015-10-08 16:48

Relationship added

related to 0031107

Notes

Test plan 1:

As group admin role:
   Create a Commission
      Basis Document: Invoice
      Basis Status: Fully paid documents
      Basis Amount: Net amount
   Add a line to it:
      Based on Sales Rep.: 'Y'
      Business Partner Category: 'Customer - Tier 3'
      Multiplier amount: 0.13
   Create a Payment Term:
      Overdue Payment Days Rule: 60
   Add a line to it
      Percentage Due: 50
      Overdue Payment Days Rule: 30
   Create a Sales Invoice for 'Hoteles Buenas Noches, S.A.'
   Add the previously defined sales representative and payment terms
   Add a line with any product and quantity and tax: Ventas exentas
   Complete it
   Pay it in one payment
   Go to Commission window and click on Generate Commission process
   Go to Commission Payment window and check there are two lines, each one with half of the invoice's total net amount

Test plan 2:

- Login as International Group Admin.
- Create a Payment Term header:
   Overdue Payment Days Rule: 30
   Add a line to it:
      Percentage due: 50
      Overdue Payment Days Rule: 0
- Create a Commission with:
      Business Partner / Sales Rep.: define one
      Frequency Type: Monthly
      Basis Document: Invoice
      Basis Status. Fully paid docuemnts
      Basis Amount: Net amount
   Add a line to it:
      Based on Sales Rep. = Y
      Multiplier amount: 0.5
- Create a Sales Invoice and associate the previously created payment terms and the sales representative to it. Complete it
- Pay it in two payments: one in each due date
- Generate Commission for the month which contains the first payment
- Generate Commission for the month which contains the second payment
- Go to the Commission Payment window and check amount for each month is not whole invoice amount. It is properly split as per the payment amount done month wise.

Test plan 3:

Test plan used:
1- Login into Openbravo ERP
2- Go to Payment Term window and create a new header record.
3- Set Overdue Payment Days Rule: 30
4- Add a new line to it
5- Set Percentage due: 50 and Overdue Payment Days Rule: 0
6- Go to Commission window and create a new header
7- Select a Business Partner / Sales Rep (create a new one if is required).
   Set Frequency Type: Monthly
   Basis Document: Invoice
   Basis Status. Fully paid docuemnts
   Basis Amount: Net amount
8- Go to lines tab and create a new record
9- Check Based on Sales Rep. flag and set Multiplier amount: 0.5
10- Go to Sales Invoice window and create a new one selecting the same sales representative and the previously created payment terms.
11- Add a line with a product
11- Complete it
12- Pay the whole amount by clicking add payment button, realize that two record are selected in the invoice grid as the invoice has fractionated payment terms. Complete the process.
13- Go back to Commission window, select previous commision record and click in Generate Commission button
14- Go to the Commission Payment window, select created record, go to Amounts tab and then select Details tab.
15- Realize that one record per invoice is shown.