0033082: Payment Schedule Detail duplicated when using "Modify Payment Plan" process under certain circumstances - Openbravo Issue Tracking System

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

ID

Project

Category

View Status

Date Submitted

Last Update

0033082

Openbravo ERP

Z. Others

public

2016-05-31 11:27

2016-06-17 19:38

Reporter

maite

Assigned To

AtulOpenbravo

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS

5

OS Version

Product Version

Target Version

3.0PR16Q3

Fixed in Version

3.0PR16Q3

Merge Request Status

Review Assigned To

aferraz

OBNetwork customer

OBPS

Web browser

Modules

Advanced Payables and Receivables Mngmt

Support ticket

41642

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0033082: Payment Schedule Detail duplicated when using "Modify Payment Plan" process under certain circumstances

Description

Payment schedule detail is duplicated when "Modify Payment Plan" process is run from a partial payment plan record which has payment in Void status

Steps To Reproduce

0. As system administrator, access to "Windows, tabs and fields" and go to Sales Invoice window | Payment Plan tab to set "Modify payment plan" field as DISPLAYED. Logout/login
1. Access Payment Terms window and configure new record as "Overdue Payment Days Rule"=30 in Header. Add Line with "Percentage due"=30 and "Overdue Payment Days Rule"=15
2. Register Sales invoice for España org using this payment terms. Add any line and process invoice
3. Access Financial Account "Cuenta de banco", go to Payment Method tab and set "Transferencia" payment method as "Automatic", "Simple exec process" and "Deferred=YES"
4. From invoice header, run "Add Payment" process. Select only first payment plan record and process
5. Navigate to created Payment In document, which should be in "Awaiting Exec" status. Click on "Reactivate" button and select VOID action. Realize that payment is correct and it only has one detail related
6. Access Sales Invoice and go to Payment Plan tab. Run "Modify Payment Plan" process from previous record and change Payment Method info to "Cheque". Process
7. Access again to previous Payment In record, refresh document and realize that it has 2 details, which is not correct
8. Access Sales Invoice and go to Payment Plan tab, select second line, the one that still has Transferencia as Payment Method. Check that it has a payment detail and that is not correct. (Received Amount = 30 and Amount = 70, related to payment in (1000513).
9. Run Modify Payment Plan for this second payment plan line, change it to Cheque. Press Submit. Refresh. Check that now this payment plan has two payment details lines which is not correct.

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

related to

defect

0033260

closed

Triage Omni OMS

Error message shown in Modify Payment Plan after changing Payment Method field

Attached Files

Issue History

Date Modified

Username

Field

Change

2016-05-31 11:27

New Issue

2016-05-31 11:27

Assigned To

=> Triage Finance

2016-05-31 11:27

OBNetwork customer

=> Yes

2016-05-31 11:27

Modules

=> Advanced Payables and Receivables Mngmt

2016-05-31 11:27

Support ticket

=> 41642

2016-05-31 11:27

Resolution time

=> 1465855200

2016-05-31 11:27

Triggers an Emergency Pack

=> No

2016-05-31 11:27

Issue Monitored: networkb

2016-05-31 11:27

Target Version

=> 3.0PR16Q3

2016-05-31 11:37

Issue Monitored: heccam

2016-05-31 13:13

Assigned To

Triage Finance => AtulOpenbravo

2016-06-06 11:11

Status

new => scheduled

2016-06-08 08:47

Note Added: 0087081

2016-06-14 13:08

Note Edited: 0087081

bug_revision_view_page.php?bugnote_id=0087081#r12372

2016-06-14 13:13

Note Added: 0087251

2016-06-14 13:25

Steps to Reproduce Updated

bug_revision_view_page.php?rev_id=12374#r12374

2016-06-14 13:26

Steps to Reproduce Updated

bug_revision_view_page.php?rev_id=12375#r12375

2016-06-14 14:00

Note Added: 0087254

2016-06-14 14:00

Steps to Reproduce Updated

bug_revision_view_page.php?rev_id=12376#r12376

2016-06-14 14:11

Note Edited: 0087254

bug_revision_view_page.php?bugnote_id=0087254#r12378

2016-06-14 14:14

Note Edited: 0087254

bug_revision_view_page.php?bugnote_id=0087254#r12379

2016-06-14 15:24

Note Edited: 0087254

bug_revision_view_page.php?bugnote_id=0087254#r12380

2016-06-14 15:28

Relationship added

related to 0033260

2016-06-14 15:28

Note Edited: 0087254

bug_revision_view_page.php?bugnote_id=0087254#r12381

2016-06-15 10:08

Note Edited: 0087254

bug_revision_view_page.php?bugnote_id=0087254#r12391

2016-06-15 10:08

Note Added: 0087289

2016-06-15 14:23

Checkin

2016-06-15 14:23

Note Added: 0087303

2016-06-15 14:23

Status

scheduled => resolved

2016-06-15 14:23

Resolution

open => fixed

2016-06-15 14:23

Fixed in SCM revision

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

2016-06-15 14:23

Checkin

2016-06-15 14:23

Note Added: 0087304

2016-06-15 14:27

Checkin

2016-06-15 14:27

Note Added: 0087305

2016-06-15 14:28

Review Assigned To

=> aferraz

2016-06-15 14:28

Note Added: 0087306

2016-06-15 14:28

Status

resolved => closed

2016-06-15 14:28

Fixed in Version

=> 3.0PR16Q3

2016-06-17 19:38

Checkin

2016-06-17 19:38

Note Added: 0087620

2016-06-17 19:38

Checkin

2016-06-17 19:38

Note Added: 0087621

2016-06-17 19:38

Checkin

2016-06-17 19:38

Note Added: 0087622

Notes

Test Plan

- As system administrator, access to "Windows, tabs and fields" and go to Sales Invoice window | Payment Plan tab to set "Modify payment plan" field as DISPLAYED. Logout/login.
Cheque
- Access Payment Terms window and configure new record as "Overdue Payment Days Rule"=30 in Header. Add Line with "Percentage due"=30 and "Overdue Payment Days Rule"=15.

- Register Sales invoice for F&B España org using this payment terms. Add any line and process invoice.

- Go to payment plan tab and check that there are two payment plan lines, first one with an expected date 15 days after invoice date for a 30% of the total gross amount of the invoice, for instance 30.00 (total gross amount 100.00).

- Access Financial Account "Cuenta de banco", go to Payment Method tab and set "Transferencia" payment method as "Automatic", "Simple exec process" and "Deferred=YES".

- From invoice header, run "Add Payment" process. Select only first payment plan record and process.

- Navigate to created Payment In document, which should be in "Awaiting Exec" status. Click on "Reactivate" button and select VOID action. Realize that payment is correct and it only has one detail related.

- Access Sales Invoice and go to Payment Plan tab. Run "Modify Payment Plan" process from previous record and change Payment Method info to "Cheque". Process.

- Verify that there is only one line in Payment Details sub tab, still referring to Transferencia Payment Method in Status Void.

- Access again to previous Payment In record, refresh document and check that it has only 1 detail, which is correct.

- Go back to the sales invoice. Go to Payment Plan tab and select second line. Change Payment Method to Check by using "Modify Payment Plan" button.

- Check that payment method is changed to Cheque and that there is no payment details associated to this payment plan line.

Repeat same steps as above for another method of payment that is not an "Automatic" one.

- Add a payment for the payment plan line changed to Cheque (that is setup as Manual one).
- Reactivate that payment once received and delete its lines.
- Change that payment plan line to "Transferencia".
- Check it is possible to make that change while no additional payment detail line is created.