Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||
| ID | |||||||||||
| 0024165 | |||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||||
| design defect | [Openbravo ERP] 09. Financial management | major | always | 2013-06-21 14:33 | 2013-06-26 12:29 | ||||||
| Reporter | RenateNieuwkoop | View Status | public | ||||||||
| Assigned To | dmiguelez | ||||||||||
| Priority | high | Resolution | open | Fixed in Version | |||||||
| Status | acknowledged | Fix in branch | Fixed in SCM revision | ||||||||
| Projection | none | ETA | none | Target Version | |||||||
| OS | Any | Database | Any | Java version | |||||||
| OS Version | Database version | Ant version | |||||||||
| Product Version | 3.0MP24 | SCM revision | |||||||||
| Review Assigned To | |||||||||||
| Web browser | |||||||||||
| Modules | Core | ||||||||||
| Regression level | |||||||||||
| Regression date | |||||||||||
| Regression introduced in release | |||||||||||
| Regression introduced by commit | |||||||||||
| Triggers an Emergency Pack | No | ||||||||||
| Summary | 0024165: Exchange rate on Sales Invoice is not used for posting | ||||||||||
| Description | When using a specific exchange rate for a product it is not used for the posting. I think this was already reported on closed bug 21743. Also maybe related to issue 17267. In the posting I don't really know what exchange rate was used, but it wasn't the one in the exchange rates tab. From Eur to USD for today's date (conversion rates screen) would be 1200 X 0.735294 = 882.3528 while in accounting tab it reflects 833.33, but maybe that is a rounding issue. | ||||||||||
| Steps To Reproduce | For F&B US: - Create a payment method that is allowing for foreign currency - add the payment method to a US BP - set up a pricelist for EUR called in Int Price list - add a product Cola for example to pricelist with price of 10 - add the pricelist to the same US BP - Enter a sales invoice for the BP with the product - Enter exchange rate (that is different from conversion rate of the org) for example 1.2 - Complete the invoice and post You see that the foreign amount on the exchange rates tab is different that the amount in the Accounting tab | ||||||||||
| Tags | No tags attached. | ||||||||||
| Attached Files |  Exchangerate1.png [^] (107,734 bytes) 2013-06-21 14:33
exchangerate2.png [^] (84,094 bytes) 2013-06-21 14:34
exchangerate3.png [^] (126,552 bytes) 2013-06-21 14:34
| ||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0059670) pramakrishnan (developer) 2013-06-26 11:29 |
The exchange rate must have been defined for EUR -> USD for this case to consider the document level exchange rate. But its defined for USD -> EUR and so the posting considers the exchange rates from the conversion rate window |
|
(0059671) pramakrishnan (developer) 2013-06-26 11:35 |
The "from currency" in the exchange rate tab should always be same as the document's currency. But when we do the following steps, its causing inconsistencies. 1. Create a sales invoice in Organization F&B US East Coast with currency USD. 2. Now enter the exchange rate from USD-> EUR. Do not add lines 3. Update the business partner and the pricelist(with currency EUR) in the invoice header. 4. Notice that the document currency becomes EUR, but we have the exchange rate defined for USD->EUR which will never be used. |
|
(0059676) RenateNieuwkoop (reporter) 2013-06-26 12:29 |
The currency that is set up in the exchange rate tab is the following: Go to the [Exchange rates] tab. Enter a new record Organization = F&B US, Inc., Currency = EUR, To Currency = USD, Invoice = leave to default, which is this invoices number. Rate = 1.2, So that was done correctly if I understand Prama's reasoning correctly, yet that exchange rate was not used for the posting. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2013-06-21 14:33 | RenateNieuwkoop | New Issue | |
| 2013-06-21 14:33 | RenateNieuwkoop | Assigned To | => dmiguelez |
| 2013-06-21 14:33 | RenateNieuwkoop | File Added: Exchangerate1.png | |
| 2013-06-21 14:33 | RenateNieuwkoop | Modules | => Core |
| 2013-06-21 14:33 | RenateNieuwkoop | Triggers an Emergency Pack | => No |
| 2013-06-21 14:34 | RenateNieuwkoop | File Added: exchangerate2.png | |
| 2013-06-21 14:34 | RenateNieuwkoop | File Added: exchangerate3.png | |
| 2013-06-26 10:33 | dmiguelez | Assigned To | dmiguelez => jonalegriaesarte |
| 2013-06-26 11:21 | pramakrishnan | Assigned To | jonalegriaesarte => pramakrishnan |
| 2013-06-26 11:22 | pramakrishnan | Status | new => scheduled |
| 2013-06-26 11:22 | pramakrishnan | fix_in_branch | => pi |
| 2013-06-26 11:29 | pramakrishnan | Note Added: 0059670 | |
| 2013-06-26 11:35 | pramakrishnan | Note Added: 0059671 | |
| 2013-06-26 11:36 | pramakrishnan | Type | defect => design defect |
| 2013-06-26 11:36 | pramakrishnan | fix_in_branch | pi => |
| 2013-06-26 11:37 | pramakrishnan | Status | scheduled => acknowledged |
| 2013-06-26 11:37 | pramakrishnan | Assigned To | pramakrishnan => dmiguelez |
| 2013-06-26 12:29 | RenateNieuwkoop | Note Added: 0059676 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |