Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0021446 | Openbravo ERP | 09. Financial management | public | 2012-08-24 14:57 | 2012-09-26 17:20 |
|
| Reporter | psanjuan | |
| Assigned To | naiaramartinez | |
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 20 | OS Version | Ubuntu 8.04.1 |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | dmiguelez |
| OBNetwork customer | |
| Web browser | Google Chrome |
| 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 | 0021446: "Deposit" transactions wrongly created |
| Description | "Deposit" transactions wrongly created in case of completing a sales invoice in a different currency (USD) than the Financial Account currency (EUR) if the Payment Method used has below checkbox set us YES:
* Automatic Deposit
* Automatic Withdrawal
|
| Steps To Reproduce | Navigate to Price List and create a Sales Price List in "USD" named "Tarifa de ventas en USD" and get few products configured for it.
Create a Customer in F&B España and assign the just created Sales Price List in USD to it.
Make sure the customer has a Financial Account and a Payment Method assigned in the tab "Customer". For instance:
Financial Account = "Cuenta de Banco" (in EUR)
Payment Method = "Transferencia"
Location/Address should be in USA.
Navigate to the financial account "Cuenta de Banco" and make sure that the Payment Method "Transferencia" is setup as described below:
* Payment In allowed = yes
* Automatic Receipt = yes
* Automatic Deposit = yes
* Receive Payments in multiple currencies = yes
* Execution Type = Manual
* Upon Deposit Use = Deposited Payment Account
Navigate to the "Conversion Rates" window and make sure there is a conversion rate between EUR/USD and USD/EUR for 2012 (01-10-2012 to 31-12-2012).
Navigate to Sales Invoice window and enter a sales invoice for the customer dated on 24-08-2012 and for a Total Gross Amount = Total Net Amount = 5.000,00 USD
Complete the invoice. Due date is 24-12-2012
Realize that a payment has been created.
Navigate to the Payment In window and check that the payment is there. The currency is USD and the Received amount is 5.000,00
Navigate to the Financial Account and verify that a new transaction dated on 24-12-2012 has been created for that Business Partner.
As you shown in the image attached the deposit amount is 5.000,00 and the currency USD. But that is not right.
|
| Proposed Solution | The deposit amount should be 5.000.00 * the corresponding exchange rate
The currency should be EUR
The Foreing amount should be 5.000.00
and the Foreign currency should be USD
|
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  21446.png (123,591) 2012-08-24 15:15
https://issues.openbravo.com/file_download.php?file_id=5522&type=bug
|
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2012-08-24 14:57 | psanjuan | New Issue | |
| 2012-08-24 14:57 | psanjuan | Assigned To | => mirurita |
| 2012-08-24 14:57 | psanjuan | Web browser | => Google Chrome |
| 2012-08-24 14:57 | psanjuan | Modules | => Advanced Payables and Receivables Mngmt |
| 2012-08-24 15:02 | psanjuan | Web browser | Google Chrome => Google Chrome |
| 2012-08-24 15:02 | psanjuan | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=3760#r3760 |
| 2012-08-24 15:07 | psanjuan | Web browser | Google Chrome => Google Chrome |
| 2012-08-24 15:07 | psanjuan | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=3761#r3761 |
| 2012-08-24 15:12 | psanjuan | Web browser | Google Chrome => Google Chrome |
| 2012-08-24 15:12 | psanjuan | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=3762#r3762 |
| 2012-08-24 15:12 | psanjuan | Proposed Solution updated | |
| 2012-08-24 15:15 | psanjuan | File Added: 21446.png | |
| 2012-09-18 09:23 | naiaramartinez | Assigned To | mirurita => naiaramartinez |
| 2012-09-18 12:39 | naiaramartinez | Status | new => scheduled |
| 2012-09-18 12:39 | naiaramartinez | fix_in_branch | => pi |
| 2012-09-18 12:48 | naiaramartinez | Note Added: 0052197 | |
| 2012-09-20 09:57 | hgbot | Checkin | |
| 2012-09-20 09:57 | hgbot | Note Added: 0052248 | |
| 2012-09-20 09:57 | hgbot | Status | scheduled => resolved |
| 2012-09-20 09:57 | hgbot | Resolution | open => fixed |
| 2012-09-20 09:57 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/ce64e9cc6a7d4a9b9a7dcb57ac422c5332d614d9 [^] |
| 2012-09-20 09:57 | dmiguelez | Closed by | => dmiguelez |
| 2012-09-20 09:57 | dmiguelez | Note Added: 0052250 | |
| 2012-09-20 09:57 | dmiguelez | Status | resolved => closed |
| 2012-09-26 17:20 | hudsonbot | Checkin | |
| 2012-09-26 17:20 | hudsonbot | Note Added: 0052792 | |
|
Notes |
|
|
|
Test Plan:
Navigate to Price List and create a Sales Price List in "USD" named "Tarifa de ventas en USD" and get few products configured for it.
Create a Customer in F&B España and assign the just created Sales Price List in USD to it.
Make sure the customer has a Financial Account and a Payment Method assigned in the tab "Customer". For instance:
Financial Account = "Cuenta de Banco" (in EUR)
Payment Method = "Transferencia"
Location/Address should be in USA.
Navigate to the financial account "Cuenta de Banco" and make sure that the Payment Method "Transferencia" is setup as described below:
* Payment In allowed = yes
* Automatic Receipt = yes
* Automatic Deposit = yes
* Receive Payments in multiple currencies = yes
* Execution Type = Manual
* Upon Deposit Use = Deposited Payment Account
Navigate to the "Conversion Rates" window and make sure there is a conversion rate between EUR/USD and USD/EUR for 2012 (01-10-2012 to 31-12-2012).
Navigate to Sales Invoice window and enter a sales invoice for the customer dated on 24-08-2012 and for a Total Gross Amount = Total Net Amount = 3.000,00 USD
Complete the invoice. Due date is 24-12-2012
Realize that a payment has been created.
Navigate to the Payment In window and check that the payment is there. The currency is USD and the Received amount is 3.000,00
Navigate to the Financial Account and verify that a new transaction dated on 24-12-2012 has been created for that Business Partner. Notice that:
- deposit amount: 2.068.97
- currency: EUR
- foreign Amount: 3000
- foreign currency: USD |
|
|
|
(0052248)
|
|
hgbot
|
|
2012-09-20 09:57
|
|
Repository: erp/devel/pi
Changeset: ce64e9cc6a7d4a9b9a7dcb57ac422c5332d614d9
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Tue Sep 18 12:38:05 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/ce64e9cc6a7d4a9b9a7dcb57ac422c5332d614d9 [^]
fixed bug 21446 "Deposit" transactions wrongly created
---
M modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml
---
|
|
|
|
|
|
|
|
|
|