Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0032080 | Openbravo ERP | Z. Others | public | 2016-02-01 21:25 | 2017-04-19 08:47 |
|
| Reporter | fmolina | |
| Assigned To | Triage Omni OMS | |
| Priority | high | Severity | major | Reproducibility | always |
| Status | new | Resolution | open | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | 3.0PR15Q2.5 | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0032080: Payment Report conversion rate considered |
| Description | When the payment report is executed, the amount is converted using the conversion rate defined in the Conversion Rates window at system level, but it should consider the Exchange Rates defined for the payment if it has one. |
| Steps To Reproduce | 1. Take a Payment Out with USD (can be any other) currency and in the Exchange Rates tab add a record with target currency EUR with a rate different than the active for this two currencies in the Conversion Rate window.
2. Execute the Payment Report with the proper parameters.
Verify that the Base Amonut for that Payment was converted using the record defined in the Conversion Rates window, ignoring the record defined in the Exchange Rates tab for that partiular payment.
I can provide access to an instance with the data needed for reproduce the problem. |
| Proposed Solution | Proposed Solution needs to be modify.
The exchange rate that payment report needs to take into account does not have to be always the system conversion rate for the conversion date entered while launching payment report, but could also be the one entered in the header of the payment.
See scenario below for a better understanding. |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2016-02-01 21:25 | fmolina | New Issue | |
| 2016-02-01 21:25 | fmolina | Assigned To | => Triage Finance |
| 2016-02-01 21:25 | fmolina | Modules | => Core |
| 2016-02-01 21:25 | fmolina | Triggers an Emergency Pack | => No |
| 2016-02-03 18:59 | heccam | Issue Monitored: heccam | |
| 2016-04-13 23:36 | rbianchini | Issue Monitored: rbianchini | |
| 2016-04-19 08:48 | egoitz | Resolution time | => 1463263200 |
| 2016-04-21 10:21 | aferraz | Assigned To | Triage Finance => AtulOpenbravo |
| 2016-04-26 11:41 | AtulOpenbravo | Note Added: 0085978 | |
| 2016-04-26 11:42 | AtulOpenbravo | Status | new => scheduled |
| 2016-04-26 12:28 | psanjuan | Note Added: 0085979 | |
| 2016-04-26 12:33 | psanjuan | Note Edited: 0085979 | bug_revision_view_page.php?bugnote_id=0085979#r11865 |
| 2016-04-26 12:35 | psanjuan | Note Edited: 0085979 | bug_revision_view_page.php?bugnote_id=0085979#r11866 |
| 2016-04-26 12:36 | psanjuan | Note Edited: 0085979 | bug_revision_view_page.php?bugnote_id=0085979#r11867 |
| 2016-04-26 12:40 | psanjuan | Note Edited: 0085979 | bug_revision_view_page.php?bugnote_id=0085979#r11868 |
| 2016-04-26 12:46 | psanjuan | Note Edited: 0085979 | bug_revision_view_page.php?bugnote_id=0085979#r11869 |
| 2016-04-26 12:53 | psanjuan | Note Edited: 0085979 | bug_revision_view_page.php?bugnote_id=0085979#r11870 |
| 2016-04-26 12:56 | psanjuan | Note Edited: 0085979 | bug_revision_view_page.php?bugnote_id=0085979#r11871 |
| 2016-04-29 12:21 | psanjuan | Note Edited: 0085979 | bug_revision_view_page.php?bugnote_id=0085979#r11906 |
| 2016-04-29 12:35 | psanjuan | Note Edited: 0085979 | bug_revision_view_page.php?bugnote_id=0085979#r11907 |
| 2016-04-29 12:37 | psanjuan | Note Edited: 0085979 | bug_revision_view_page.php?bugnote_id=0085979#r11908 |
| 2016-04-29 12:44 | psanjuan | Note Edited: 0085979 | bug_revision_view_page.php?bugnote_id=0085979#r11909 |
| 2016-04-29 12:51 | psanjuan | Note Edited: 0085979 | bug_revision_view_page.php?bugnote_id=0085979#r11910 |
| 2016-04-29 13:45 | psanjuan | Proposed Solution updated | |
| 2016-04-29 13:46 | psanjuan | Proposed Solution updated | |
| 2016-04-29 14:03 | psanjuan | Note Edited: 0085979 | bug_revision_view_page.php?bugnote_id=0085979#r11911 |
| 2016-04-29 14:05 | psanjuan | Note Edited: 0085979 | bug_revision_view_page.php?bugnote_id=0085979#r11912 |
| 2016-04-29 14:05 | psanjuan | Note Edited: 0085979 | bug_revision_view_page.php?bugnote_id=0085979#r11913 |
| 2016-04-29 14:10 | psanjuan | Note Edited: 0085979 | bug_revision_view_page.php?bugnote_id=0085979#r11914 |
| 2016-04-29 14:11 | psanjuan | Note Edited: 0085979 | bug_revision_view_page.php?bugnote_id=0085979#r11915 |
| 2016-04-29 14:12 | psanjuan | Note Edited: 0085979 | bug_revision_view_page.php?bugnote_id=0085979#r11916 |
| 2016-05-04 13:37 | psanjuan | Note Edited: 0085979 | bug_revision_view_page.php?bugnote_id=0085979#r11964 |
| 2016-05-04 13:48 | psanjuan | Note Edited: 0085979 | bug_revision_view_page.php?bugnote_id=0085979#r11965 |
| 2016-05-04 13:54 | psanjuan | Proposed Solution updated | |
| 2016-05-04 14:15 | psanjuan | Note Edited: 0085979 | bug_revision_view_page.php?bugnote_id=0085979#r11966 |
| 2016-05-04 15:19 | psanjuan | Note Edited: 0085979 | bug_revision_view_page.php?bugnote_id=0085979#r11969 |
| 2016-05-04 15:23 | psanjuan | Type | defect => feature request |
| 2016-05-04 15:23 | psanjuan | Proposed Solution updated | |
| 2016-05-04 16:58 | aferraz | Note Added: 0086185 | |
| 2017-04-19 08:39 | AtulOpenbravo | Assigned To | AtulOpenbravo => Triage Finance |
| 2017-04-19 08:47 | AtulOpenbravo | Status | scheduled => feedback |
| 2017-04-19 08:47 | AtulOpenbravo | Status | feedback => new |
|
Notes |
|
|
|
Test Plan
- Login as F&B International Group Admin
- Go to Financial Account "Bank Account 1".
- In Payment Method, for Wire Transfer register, set make payment in multiple currency flag = Yes for both Payment In and Out.
- Register a Payment Out with EUR currency and in the Exchange Rates tab add a record with target currency USD with a rate different for eg: 1.5 than the active rate (for eg:1.09) for this two currencies in the Conversion Rate window.
- Execute the Payment Report with the proper parameters to include above created Payment Out in it.
- Verify that the Base Amount for that Payment was converted using the conversion rate defined in the Exchange Rate Tab in Payment Out window. |
|
|
|
(0085979)
|
|
psanjuan
|
2016-04-26 12:28
(edited on: 2016-05-04 15:19) |
|
This is not an issue, payment report works as designed, see user guide:
http://wiki.openbravo.com/wiki/Payment_Report [^]
where it says that:
- the "Conversion date" field allows to define a date to select the system conversion rate to exchange transaction amounts.
Payment Report does not currently support to take the conversion rate defined in the payment but system conversion rate taken based on the date entered in Payment Report field "Conversion Date".
Payment Report could be changed as described below:
- a new check would need to be created to defined whether "Payment Conversion Rate" needs to be taken or not.
** in case it is set as "Yes" "Conversion Date" field needs to be hidden, as it is not needed. In that case the "Conversion Rate" entered in the header of the "Payment" would need to be used. See Proposed solution scenario below.
** in case it is set as "No", Payment Report should behave as it is working now.
- or set Conversion Date field as not mandatory, therefore if a conversion date is entered system behave as it behaves now, and if no conversion date is entered conversion rate set in the header of the payment is used.
Proposed solution scenario:
- Go to Financial Account window, select "Cuenta de Banco". Go to Payment Method tab and set "Transferencia" as "Receive/Make Payments in Multiple Currencies". Verify that "Cuenta de Banco" currency is EUR.
- Go to Price List window and create a new sales price list in USD for F&B España. Do the same for a Purchase Price list in USD. Enter a price list version valid from 01-01-2014 for instance. Select any product and enter a purchase price list of 100.00 and a sales price list of 200.00
- Go to Business partner window and create a Vendor and a Customer for F&B España located in the USA and with the price lists in USD created before. Financial Account = Cuenta de Banco, Payment Method = Transferencia.
- Go to conversion rates window and check below conversion rates:
EUR to USD (01-04-2016 to 30-06-2016) 1.09
USD to EUR (01-04-2016 to 30-06-2016) 0.917431
- Go to Sales invoice and create a new invoice dated on today's date (29-04-2016) for USA customer of 1 unit of the product, therefore total gross amount of the invoice is 200.00 USD. Complete the invoice. Ppst the invoice.
- Verify below posting for EUR general ledger (Sales invoice ie 10000194):
183.49 (200.00 * 0.917431) (43000) Cliente DEBIT
183.49 (70000) Venta Mercaderías CREDIT
- Back in the sales invoice press Add Payment. Enter 30-04-2016 as payment date. Check that the conversion rate used is 0.917431, system conversion rate. Change it to 0.95, therefore amount in EUR changes from 183.49 to 190.00. Process the payment and do not deposit it.
- Go to the payment in created (ie. payment in number 1000203). Vefiry that the exchange rate set in the payment header is 0.95, same as the one shown in the exchange rate tab.
- Post the payment and verify below posting for EUR General Ledger:
190.00 (200.00 * 0.95) (5555) Partidas Pendientes aplicación DEBIT
183.49 (430000) Clientes CREDIT
6.51 (76800) Diferecias positivas de cambio CREDIT.
All of the above is correct.
- Go to payment report and select F&B España, Cuenta de Banco financial account, Convert to Currency EUR, Payment type "Receivables". Run the report.
- Check that the payment is shown there with status "Payment Received", as described below:
* Trans. Amount = 200.00 USD. OK
* Base Amount = 183.49 EUR (this is not correct, the correct amount should have been 190.00 EUR 8200.00 USD * 0.95, as that is the amount that is going to be deposited, see below.)
- Go to Cuenta de Banco financial account, tab "Transaction" and create a new one dated on today. Click on magnifying glass icon to select payment in USD created above. Save it and Process. Post the payment and verify below posting for EUR General Ledger:
190.00 (57200) Bancos DEBIT
190.00 (55500) Partidas Pendientes de Aplicación CREDIT.
Unpost and delete the transaction created in the financial account.
- Go to the payment in created and unpost it and reactivate it. Change payment date to 01-05-2016. Press Add Details once more and enter a new exchange rate there, for instance: 1.10. process the payment. Press Done.
- Verify that the conversion rate shown in the "exchange rate· tab remains as 0.95 while the exchange rate in the header is the new one entered 1.10.
- Post the payment. Verify below posting for EUR general ledger (same as before):
190.00 (200.00 * 0.95) (5555) Partidas Pendientes aplicación DEBIT
183.49 (430000) Clientes CREDIT
6.51 (76800) Diferecias positivas de cambio CREDIT.
- Go to the financial account and deposit the payment.Process it and Post it. Verify below posting for EUR General Ledger:
220.00 (200.00 USD *1.10) (572000) Bancos DEBIT
190.00 (55500 ) Partidas pendientes de aplicación CREDIT
30.00 (76800) Diferencias positivas de cambio CREDIT.
All of the above is correct.
- Go now to payment report and launch it for F&B España, Cuenta de Banco, EUR currency, Receivables. Search for the payment now as "Deposited not cleared" and verify below info is shown (that is NOT correct):
* Trans. Amount = 200.00 USD. OK
* Base Amount = 183.49 EUR (this is not correct)
Correct info should have been:
* Trans. Amount = 200.00 USD. OK
* Base Amount = 220.00 EUR (200.00 USD * 1.10 exchange rate entered in the header of the payment)
|
|
|
|
|
Possible solution:
Make conversion date field not mandatory.
Take conversion rate from document in case conversion date field is not filled and from system (for the given date) in case it is. |
|