Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0039341 | Openbravo ERP | 09. Financial management | public | 2018-09-13 20:27 | 2018-10-02 10:25 |
|
| Reporter | AtulOpenbravo | |
| Assigned To | AtulOpenbravo | |
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | 3.0PR18Q3.2 | Fixed in Version | 3.0PR18Q3.2 | |
| Merge Request Status | |
| Review Assigned To | Sandrahuguet |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | Production - Confirmed Stable |
| Regression date | 2014-04-03 |
| Regression introduced in release | 3.0PR14Q2 |
| Regression introduced by commit | https://code.openbravo.com/erp/devel/pi/rev/f7078a85289e6c61918f567b28d2df3fe17ddb47 [^] |
| Triggers an Emergency Pack | No |
|
| Summary | 0039341: Business Partner current balance is wrongly updated when using Reconciliation |
| Description | Business Partner current balance is wrongly updated when using Reconciliation |
| Steps To Reproduce | Test Plan
- Login as F&B International Group admin role
- Create a new Business Partner in F&B International Group
- Create a Payment In for F&B España, S.A. and that business partner
- Add an amount 100 and do not select any document to be paid. Leave the amount as credit
- Check the payment has been deposited in a financial account.
- Check that business partner current balance is set as -100.
- Go to Financial Account where the payment was deposited.
- Either leave the Matching Algorithm empty or keep it as Standard
- Click on Reconcile or Match Statement button
- Select the previously created payment or match the previous payment with similar record in bank statement.
- Again check the current balance of business partner now it is set as -200.
This is not correct. |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | blocks | defect | 0039290 | | closed | AtulOpenbravo | Business Partner current balance is wrongly updated when using Reconciliation |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2018-09-24 11:58 | AtulOpenbravo | Type | defect => backport |
| 2018-09-24 11:58 | AtulOpenbravo | Target Version | => 3.0PR18Q3.1 |
| 2018-09-25 05:59 | AtulOpenbravo | Note Added: 0106978 | |
| 2018-09-25 06:08 | AtulOpenbravo | Note Added: 0106981 | |
| 2018-09-25 06:21 | AtulOpenbravo | Note Edited: 0106981 | bug_revision_view_page.php?bugnote_id=0106981#r17671 |
| 2018-09-26 13:45 | Sandrahuguet | Target Version | 3.0PR18Q3.1 => 3.0PR18Q3.2 |
| 2018-10-01 20:33 | AtulOpenbravo | Note Added: 0107095 | |
| 2018-10-01 20:34 | AtulOpenbravo | Note Added: 0107096 | |
| 2018-10-01 20:34 | AtulOpenbravo | Note Added: 0107097 | |
| 2018-10-02 10:21 | hgbot | Checkin | |
| 2018-10-02 10:21 | hgbot | Note Added: 0107108 | |
| 2018-10-02 10:21 | hgbot | Status | scheduled => resolved |
| 2018-10-02 10:21 | hgbot | Resolution | open => fixed |
| 2018-10-02 10:21 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/backports/3.0PR18Q3.2/rev/094648eda7a592a5517fc448c5c54eed8ed5758b [^] |
| 2018-10-02 10:25 | Sandrahuguet | Review Assigned To | => Sandrahuguet |
| 2018-10-02 10:25 | Sandrahuguet | Note Added: 0107110 | |
| 2018-10-02 10:25 | Sandrahuguet | Status | resolved => closed |
| 2018-10-02 10:25 | Sandrahuguet | Fixed in Version | => 3.0PR18Q3.2 |
|
Notes |
|
|
|
Test Plan
- Login as F&B International Group admin role
- Create a new Business Partner in F&B International Group
- Create a Payment In for F&B España, S.A. and that business partner
- Add an amount 100 and do not select any document to be paid. Leave the amount as credit
- Check the payment has been deposited in a financial account.
- Check that business partner current balance is set as -100.
- Go to Financial Account where the payment was deposited.
- Either leave the Matching Algorithm empty or keep it as Standard
- Click on Reconcile or Match Statement button
- Select the previously created payment or match the previous payment with similar record in bank statement.
- Again check the current balance of business partner it is as it is -100. |
|
|
|
(0106981)
|
|
AtulOpenbravo
|
2018-09-25 06:08
(edited on: 2018-09-25 06:21) |
|
Test Plan
- Login as F&B International Group Admin
- Go to Financial Account and select Bank - Account 1
- Navigate to Payment Method: Wire Transfer
Uncheck Automatic Deposit and Automatic Withdrawn Go to Sales Invoice
- Go to sales Invoice and create a new invoice with this values:
Organization: F&B US, Inc.
Bussiness Partner: Healthy Food Supermarkets, Co.
Payment Method: Wire Transfer
- Create new 2 lines:
Product: Lemonade, Quantity: 10
Product: Orange Juice bio, Quantity: 5
- Complete the invoice
- Check business partner balance is set as 15.
- Click in Add Payment button,
- Make sure that actual payment is 15 and click process
- Action regarding document: Process Received Payment(s)
- Notice that Payment complete in sales invoice header is Yes.
- Check business partner balance is set as 0.
|
|
|
|
|
Test Plan
- Login as F&B International Group Admin
- Create a preference "Allow to use invoice paid status control" with value = Yes
- Logout and Login
- Create a new financial account "39290 Financial Account", currency = USD,
create a payment method for "Wire Transfer",
set Invoice Paid Status = Payment Received,
Automatic Deposit = No in Payment In section.
- In Payment Out, set Automatic Withdrawn = No, Invoice Paid Status = Payment Made
- Create a new business partner "39290 business partner"
and its location in organization "F&B Us Inc",
set Payment Method = "Wire Transfer".
- Go to sales Invoice and create a new invoice with this values:
Organization: F&B US, Inc.
Bussiness Partner: Healthy Food Supermarkets, Co.
Payment Method: Wire Transfer
- Create new 2 lines:
Product: Lemonade, Quantity: 10
Product: Orange Juice bio, Quantity: 5
- Complete the invoice
- Check business partner balance is set as 15.
- Click in Add Payment button,
- Make sure that actual payment is 15 and click process
- Action regarding document: Process Received Payment(s)
- Notice that Payment complete in sales invoice header is Yes.
- Check business partner balance is set as 0.
- In Financial Account "39290 Financial Account", add transaction and select
previous payment in.
- Process Financial Account Transaction.
- Check business partner balance is 0.
- In Financial Account "39290 Financial Account" make sure
Matching Algorithm is set as blank.
- Click on Reconcile.
- Select previous payment in and set ending balance as 15, Save record.
- Check business partner balance is 0.
- Click on Reconcile: Uncheck previous payment in, set ending balance = 0, Save record.
- Check business partner balance is 0.
Similar test plan executed for purchase flow. |
|
|
|
|
Test Plan
- Login as F&B International Group Admin
- Create a preference "Allow to use invoice paid status control" with value = Yes
- Logout and Login
- Create a new financial account "39290 Financial Account", currency = USD,
create a payment method for "Wire Transfer",
set Invoice Paid Status = Deposited Not Cleared,
Automatic Deposit = No in Payment In section.
- In Payment Out, set Automatic Withdrawn = No, Invoice Paid Status = Withdrawan Not Cleared
- Create a new business partner "39290 business partner"
and its location in organization "F&B Us Inc",
set Payment Method = "Wire Transfer".
- Go to sales Invoice and create a new invoice with this values:
Organization: F&B US, Inc.
Bussiness Partner: Healthy Food Supermarkets, Co.
Payment Method: Wire Transfer
- Create new 2 lines:
Product: Lemonade, Quantity: 10, Tax = Exempt
Product: Orange Juice bio, Quantity: 5, Tax: Exempt
- Complete the invoice
- Check business partner balance is set as 15.
- Click in Add Payment button,
- Make sure that actual payment is 15 and click process
- Action regarding document: Process Received Payment(s)
- Notice that Payment complete in sales invoice header is set as No.
- Check business partner balance is set as 15.
- In Financial Account "39290 Financial Account", add transaction and select
previous payment in.
- Process Financial Account Transaction.
- Check business partner balance is 0.
- Check Payment Complete in previous Sales Invoice header is set as Yes.
- Reactivate previous financial Account Transaction.
- Check business partner balance is set as 15.
- Check Payment Complete in previous Sales Invoice header is set as No.
- Process Financial Account Transaction.
- Check business partner balance is 0.
- Check Payment Complete in previous Sales Invoice header is set as Yes.
- In Financial Account "39290 Financial Account" make sure
Matching Algorithm is set as blank.
- Click on Reconcile.
- Select previous payment in and set ending balance as 15, Save record.
- Check business partner balance is 0.
- Click on Reconcile: Uncheck previous payment in, set ending balance = 0, Save record.
- Check business partner balance is 0.
Similar test plan executed for purchase flow. |
|
|
|
|
Test Plan
- Login as F&B International Group Admin
- Create a preference "Allow to use invoice paid status control" with value = Yes
- Logout and Login
- Create a new financial account "39290 Financial Account", currency = USD,
create a payment method for "Wire Transfer",
set Invoice Paid Status = Payment Cleared,
Automatic Deposit = No in Payment In section.
- In Payment Out, set Automatic Withdrawn = No, Invoice Paid Status = Payment Cleared
- Create a new business partner "39290 business partner"
and its location in organization "F&B Us Inc",
set Payment Method = "Wire Transfer".
- Go to sales Invoice and create a new invoice with this values:
Organization: F&B US, Inc.
Bussiness Partner: Healthy Food Supermarkets, Co.
Payment Method: Wire Transfer
- Create new 2 lines:
Product: Lemonade, Quantity: 10, Tax = Exempt
Product: Orange Juice bio, Quantity: 5, Tax: Exempt
- Complete the invoice
- Check business partner balance is set as 15.
- Click in Add Payment button,
- Make sure that actual payment is 15 and click process
- Action regarding document: Process Received Payment(s)
- Notice that Payment complete in sales invoice header is set as No.
- Check business partner balance is set as 15.
- In Financial Account "39290 Financial Account", add transaction and select
previous payment in.
- Process Financial Account Transaction.
- Check business partner balance is 15.
- Check Payment Complete in previous Sales Invoice header is set as No.
- In Financial Account "39290 Financial Account" make sure
Matching Algorithm is set as blank.
- Click on Reconcile.
- Select previous payment in and set ending balance as 15, Save record.
- Check business partner balance is 0.
- Check that Payment Complete flag in previous Sales Invoice is set as Yes.
- Click on Reconcile: Uncheck previous payment in, set ending balance = 0, Save record.
- Check business partner balance is 15.
- Check that Payment Complete flag in previous Sales Invoice is set as No.
Similar test plan executed for purchase flow. |
|
|
|
(0107108)
|
|
hgbot
|
|
2018-10-02 10:21
|
|
Repository: erp/backports/3.0PR18Q3.2
Changeset: 094648eda7a592a5517fc448c5c54eed8ed5758b
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Tue Sep 25 00:35:58 2018 +0530
URL: http://code.openbravo.com/erp/backports/3.0PR18Q3.2/rev/094648eda7a592a5517fc448c5c54eed8ed5758b [^]
Fixes Issue 39341: Business Partner current balance is wrongly
updated when using Reconciliation
** In case of prepayment invoice paid should be kept as false
in PaidStatusEventHandler.
---
M src/org/openbravo/event/PaidStatusEventHandler.java
---
|
|
|
|
|
|