Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0020020Openbravo ERP09. Financial managementpublic2012-03-14 12:112012-04-02 12:16
dmiguelez 
eduardo_Argal 
immediatecriticalalways
closedfixed 
20Community Appliance
pi 
3.0MP9 
Core
No
0020020: When completing an Invoice it creates a Payment Schedule Detail line that should not exist
A negative Sales Order is created.
A Payment is made to this order and then is canceled.
Then an Invoice is created using this order.
It creates an unexpected line In the Payment Schedule Details.
Test Cases from [EPPh010] to [EPPh050]

[EPPh010]
Create the Sales Order.

Login as:

Username: QAAdmin
Password: QAAdmin
Go to Sales Management || Transactions || Sales order:
Click New and select:

“Transaction Document”: Standard Order
“Business Partner”: Type CUSA and press enter key. Customer A should be showed instead.
“Payment Method”: 2.1 (Spain)
“Payment Terms”: 90 days
“Invoice Terms”: Immediate
Move to Lines. Click new and select:

“Product”: Type FGA and press enter key. Final good A should be showed instead.
“Order Quantity”: - 500
Click the “Book” button. Click OK.

[EPPh020]
Create a Canceled Payment for the Order.

Login as:

Username: QAAdmin
Password: QAAdmin
Go to Financial Management || Receivables & Payables || Transactions || Payment In:
Click New and select:

“Received From”: Type CUSA and press enter key. Customer A should be showed instead.
“Payment Method”: 2.1 (Spain)
“Amount”: -200.00
Then click the “Add Details” button.
In the pop-up select:

“Transaction Type”: Orders
And then make sure that the line with:

“Sales Order No.”: The order created in [EPPh010].
Click the “Process” button and then OK.
Click on the “Reactivate” button. In the selector box select “Void” and click OK.

[EPPh030]
 Create an Executed Payment for the Order.

Login as:

Username: QAAdmin
Password: QAAdmin
Go to Sales Financial Management || Receivables & Payables || Transactions || Payment In:
Click New and select:

“Received From”: Type CUSA and press enter key. Customer A should be showed instead.
“Payment Method”: 2.1 (Spain)
“Amount”: -200.00
Then click the “Add Details” button.
In the pop-up select:

“Transaction Type”: Orders
And then make sure that the line with:

“Sales Order No.”: The order created in [EPPh010].
Click the “Process” button and then OK.
Click on the “Execute Payment” button and then Execute.

[EPPh040]
Create a Payment for the Order in status Awaiting Execution.

Login as:

Username: QAAdmin
Password: QAAdmin
Go to Financial Management || Receivables & Payables || Transactions || Payment In:
Click New and select:

“Received From”: Type CUSA and press enter key. Customer A should be showed instead.
“Payment Method”: 2.1 (Spain)
“Amount”: -200.00
Then click the “Add Details” button.
In the pop-up select:

“Transaction Type”: Orders
And then make sure that the line with:

“Sales Order No.”: The order created in [EPPh010].
Click the “Process” button and then OK.

[EPPh050]
 Create the Sales Invoice.

Login as:

Username: QAAdmin
Password: QAAdmin
Go to Sales Management || Transactions || Sales invoice:
Click New and select:

“Business Partner”: Type CUSA and press enter key. Customer A should be showed instead.
“Payment Method”: 2.1 (Spain)
“Payment Terms”: 90 days
Click on the button “Create Lines From”:
In the order combo box select the order created in [EPPh010].
Mark all the records that appear in the grid and press OK.
Click the “Complete” button. Click OK.

Check that, in the database, there is a Payment Schedule Detail line with amount of +200.00 that should not exist in the first place.
No tags attached.
Issue History
2012-03-14 12:11dmiguelezNew Issue
2012-03-14 12:11dmiguelezAssigned To => dmiguelez
2012-03-14 12:11dmiguelezModules => Core
2012-03-14 13:05eduardo_ArgalAssigned Todmiguelez => eduardo_Argal
2012-03-14 13:05eduardo_ArgalStatusnew => scheduled
2012-03-14 13:05eduardo_Argalfix_in_branch => pi
2012-03-14 17:37hgbotCheckin
2012-03-14 17:37hgbotNote Added: 0046424
2012-03-14 17:37hgbotStatusscheduled => resolved
2012-03-14 17:37hgbotResolutionopen => fixed
2012-03-14 17:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/aa9bbdcfead5592d03f78d9415933117f8b14350 [^]
2012-03-20 11:50gorkaionNote Added: 0046538
2012-03-20 11:50gorkaionStatusresolved => closed
2012-04-01 20:33hgbotCheckin
2012-04-01 20:33hgbotNote Added: 0047009
2012-04-01 20:33hgbotStatusclosed => resolved
2012-04-01 20:33hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/aa9bbdcfead5592d03f78d9415933117f8b14350 [^] => http://code.openbravo.com/erp/devel/pi/rev/79c1c6515ec90bfcf26450172581916df164fc17 [^]
2012-04-02 06:10hudsonbotCheckin
2012-04-02 06:10hudsonbotNote Added: 0047139
2012-04-02 12:16gorka_gilNote Added: 0047299
2012-04-02 12:16gorka_gilStatusresolved => closed
2012-04-02 12:16gorka_gilFixed in Version => 3.0MP9

Notes
(0046424)
hgbot   
2012-03-14 17:37   
Repository: erp/devel/pi
Changeset: aa9bbdcfead5592d03f78d9415933117f8b14350
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Wed Mar 14 17:36:05 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/aa9bbdcfead5592d03f78d9415933117f8b14350 [^]

Fixes issue 0020020: Discards canceled Payments of an Order

---
M modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml
---
(0046538)
gorkaion   
2012-03-20 11:50   
code reviewed and tested
(0047009)
hgbot   
2012-04-01 20:33   
Repository: erp/devel/pi
Changeset: 79c1c6515ec90bfcf26450172581916df164fc17
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Wed Mar 14 17:36:05 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/79c1c6515ec90bfcf26450172581916df164fc17 [^]

Fixes issue 0020020: Discards canceled Payments of an Order

---
M modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml
---
(0047139)
hudsonbot   
2012-04-02 06:10   
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/7814864461ac [^]

Maturity status: Test
(0047299)
gorka_gil   
2012-04-02 12:16   
Reopened by merge.