Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0021446 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | major | always | 2012-08-24 14:57 | 2012-09-26 17:20 | |||
| Reporter | psanjuan | View Status | public | |||||
| Assigned To | naiaramartinez | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | ce64e9cc6a7d | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | Oracle | Java version | 1.6 | |||
| OS Version | Ubuntu 8.04.1 | Database version | 11.1.0.6.0 | Ant version | 1.7.0 | |||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | dmiguelez | |||||||
| OBNetwork customer | No | |||||||
| 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 | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  21446.png [^] (123,591 bytes) 2012-08-24 15:15
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0052197) naiaramartinez (viewer) 2012-09-18 12:48 |
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 (developer) 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 --- |
|
(0052250) dmiguelez (viewer) 2012-09-20 09:57 |
Code Review + Testing OK |
|
(0052792) hudsonbot (viewer) 2012-09-26 17:20 |
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/b780e90c6452 [^] Maturity status: Test |
|
Notes |
|
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 14:57 | psanjuan | OBNetwork customer | => No |
| 2012-08-24 15:02 | psanjuan | Web browser | Google Chrome => Google Chrome |
| 2012-08-24 15:02 | psanjuan | Steps to Reproduce Updated | View Revisions |
| 2012-08-24 15:07 | psanjuan | Web browser | Google Chrome => Google Chrome |
| 2012-08-24 15:07 | psanjuan | Steps to Reproduce Updated | View Revisions |
| 2012-08-24 15:12 | psanjuan | Web browser | Google Chrome => Google Chrome |
| 2012-08-24 15:12 | psanjuan | Steps to Reproduce Updated | View Revisions |
| 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 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |