0020053: Advance Matching algorithm is not working properly in some circumstances

Openbravo Issue Tracking System - Openbravo ERP
View Issue Details

ID	Project	Category	View Status	Date Submitted	Last Update
0020053	Openbravo ERP	09. Financial management	public	2012-03-16 18:56	2012-04-02 06:11

Reporter	psarobe
Assigned To	eduardo_Argal
Priority	urgent	Severity	major	Reproducibility	always
Status	closed	Resolution	fixed
Platform		OS	5	OS Version
Product Version	pi
Target Version		Fixed in Version	3.0MP10
Merge Request Status
Review Assigned To
OBNetwork customer	No
Web browser
Modules	Advanced Payables and Receivables Mngmt
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency Pack	No

Summary	0020053: Advance Matching algorithm is not working properly in some circumstances
Description	Advance Matching algorithm is not working properly in some circumstances. When there are 2 sales orders in one sales invoice it gets confused. It wonly takes the amount of the first sales order and not the whole sales invoice
Steps To Reproduce	1. Create 2 sales orders and complete 2. Create one sales invoice that contains both orders 3. Go to financial account and create a bankstatement with a line with same business partner and amount as the newly sales invoice 4. Click match statement 5. Notice takes the amount of only one sales invoice
Proposed Solution
Additional Information
Tags	No tags attached.
Relationships
Attached Files

Issue History
Date Modified	Username	Field	Change
2012-03-16 18:56	psarobe	New Issue
2012-03-16 18:56	psarobe	Assigned To	=> eduardo_Argal
2012-03-16 18:56	psarobe	Modules	=> Core
2012-03-16 18:56	psarobe	OBNetwork customer	=> No
2012-03-16 19:59	psarobe	Modules	Core => Advanced Payables and Receivables Mngmt
2012-03-20 13:31	eduardo_Argal	Status	new => scheduled
2012-03-20 13:31	eduardo_Argal	fix_in_branch	=> pi
2012-03-21 17:58	hgbot	Checkin
2012-03-21 17:58	hgbot	Note Added: 0046615
2012-03-21 17:58	hgbot	Status	scheduled => resolved
2012-03-21 17:58	hgbot	Resolution	open => fixed
2012-03-21 17:58	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/d105fb5e8e0868d930504aa7b78fc971533262ae [^]
2012-03-23 10:39	hgbot	Checkin
2012-03-23 10:39	hgbot	Note Added: 0046668
2012-03-23 10:39	hgbot	Fixed in SCM revision	http://code.openbravo.com/erp/devel/pi/rev/d105fb5e8e0868d930504aa7b78fc971533262ae [^] => http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicematchingalgorithm/rev/4f6e189bec66312279ec26f091fb7290f90ab8f4 [^]
2012-03-29 11:06	mirurita	Note Added: 0046864
2012-03-29 11:06	mirurita	Status	resolved => closed
2012-03-29 11:06	mirurita	Fixed in Version	=> 3.0MP9
2012-03-30 08:25	mirurita	Note Added: 0046949
2012-03-30 08:25	mirurita	Status	closed => new
2012-03-30 08:25	mirurita	Resolution	fixed => open
2012-03-30 08:25	mirurita	Fixed in Version	3.0MP9 =>
2012-03-30 08:26	mirurita	Status	new => scheduled
2012-03-30 08:26	mirurita	Status	scheduled => resolved
2012-03-30 08:26	mirurita	Fixed in Version	=> 3.0MP10
2012-03-30 08:26	mirurita	Resolution	open => fixed
2012-03-30 08:26	mirurita	Status	resolved => closed
2012-04-02 06:11	hudsonbot	Checkin
2012-04-02 06:11	hudsonbot	Note Added: 0047190

Notes

Testing Plan:

Basic flow:
1. Create 2 sales orders for 'Sleep Well Hotels' business partner and complete.
2. Create one sales invoice that contains both orders.
3. Go to financial account and configure it to use 'Advanced Matching Algorithm'.
4. Create a bankstatement with a line with same business partner and amount as the previous sales invoice.
5. Click match statement button.
6. The sales invoice should match with bank statement line and the amount should be the sum of both sales order.
7. Click on cancel button.
8. Create the payment and deposit the transaction for the previous invoice.
9. Go to financial account and click on match statement button.
10. The matching should be done with the existing transaction.
11. Click on cancel button
12. Delete the transaction.
13. Click on match statement button.
14. The matching should be done with the existing payment.
15. Reactivate the payment.
16. Configure the payment method of the sales invoice to be automatic and deferred.
17. Click on match statement button.
18. The matching should not be proposed because the payment method of the sales invoice is configured to be automatic.
19. Reactivate the sales invoice
20. Click on match statement button.
18. The matching should be done creating credit to the business partner.

Alternative flow
1. Create 1 sales orders for 'Sleep Well Hotels' business partner and complete.
2. Create two sales invoices that contains previous order.
3. Create a payment containing both sales invoices and deposit in the financial account.
4. Go to financial account and configure it to use 'Advanced Matching Algorithm'.
5. Create a bankstatement with a line with same business partner and amount as the previous payment.
6. Click match statement button.
7. The transaction should match with bank statement line.
8. Click on cancel button.
9. Delete the transaction.
10. Click on match statement button.
11. The matching should be done with the existing payment.
12. Reactivate the payment.
13. Click on match statement button.
14. The matching should be done with the existing order.
15. Reactivate both sales invoice and the order.
16. Click on match statement button.
17. The matching should be done creating credit to the business partner.