Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0012250
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2010-02-12 17:192010-03-10 18:30
ReporternetworkbView Statuspublic 
Assigned Todalsasua 
PriorityimmediateResolutionfixedFixed in Version2.50MP12
StatusclosedFix in branchpiFixed in SCM revisiondc25d171ca95
ProjectionnoneETAnoneTarget Version2.50MP12
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP11SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0012250: The posting process on the Matched Invoices window does not work properly.

DescriptionThe posting process on the Matched Invoices window does not work properly.
If the invoice is created using a purchasing list price in a foreign currency
the posting process does not convert the amount to the system currency.
Besides one of the gl journal uses an incorrect account. (the proper account should be "fixed assets" defined on product category accounting tab instead of expenses account used)
Steps To ReproduceUsing a application with EURO as system currency (an standar application with sample data):
-Create conversion rate from EUR to USD with multiplier rate 1.5
-Create a conersion rate from USD to EUR with divide rate 1.5
-Create a price list for purchasing in USD
-Create a new product. Add a price using the created pricelist in USD with price 150. Add a cost to the product.
-Create a new Purchase Order using the pricelist in USD created previously.
-Create a line with the product created. Qty=1, price=150 tax=exempt.
-Complete the order.
-Execute the process "pending goods receipt" to create a receipt for the order created in a previous step.
-Complete and post the receipt. (to be able to post the receipt you should activate the m_inout table for posting, and add a cost to the product used. The cost in EUR is 100)
*See the receipt.png file from the attached compressed file
-Create a purchase invoice using the partner used on the order and on the receipt. Use also the price list in USD.
-Use the create lines from to select the line of the shipment created on a previous step.
-Complete and post the invoice.
*See the invoice.png file from the attached compressed file
-Finally go to the Matched Invoices window and select the entry for the invoice created.
-Post it.
*See the matchinvoice.png file from the attached compressed file
In red appears the account that is not correct. It should be the
the 350 account that is used in the gl_journal shown after post the receipt.
In blue is the row that is incorrect. This is because the amount has not converted from USD to EUR.

The DocMatchInv.java and DocMatchinv_data.xsql files does not do any conversion.
TagsNo tags attached.
Attached Fileszip file icon files.zip [^] (45,254 bytes) 2010-02-12 17:19

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0024263)
dalsasua (reporter)
2010-02-15 11:58
edited on: 2010-02-15 11:59

 After having a look to the whole process, and to the code, I founded the issue with the currency conversion, and this is going to be fixed in following hours.

About the account to use, actual behavior is the desired one: use goods receipts as a perpetual inventory method. If user wants to use another account, can implement easily an accounting template.
(0024275)
hgbot (developer)
2010-02-15 16:02

 Repository: erp/devel/pi
Changeset: dc25d171ca9529b04710cd11fa0c78c00b07a819
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Mon Feb 15 16:02:58 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/dc25d171ca9529b04710cd11fa0c78c00b07a819 [^]

fixes issue 12250. getConvertedAmount is now used in DocMatchInv.java

---
M src-db/database/sourcedata/AD_FIELD.xml
M src/org/openbravo/erpCommon/ad_forms/DocMatchInv.java
M src/org/openbravo/erpCommon/ad_forms/DocMatchInv_data.xsql
---
(0024518)
hudsonbot (developer)
2010-02-18 00:30

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/dc25d171ca95 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/7c1b489fb0a0 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16459.obx [^]
(0024589)
sureshbabu (reporter)
2010-02-18 12:52

 Tested

- Issue History
Date Modified Username Field Change
2010-02-12 17:19 networkb New Issue
2010-02-12 17:19 networkb Assigned To => dalsasua
2010-02-12 17:19 networkb File Added: files.zip
2010-02-12 18:04 dalsasua Severity critical => major
2010-02-12 18:06 dalsasua Steps to Reproduce Updated View Revisions
2010-02-12 18:19 dalsasua Steps to Reproduce Updated View Revisions
2010-02-15 11:58 dalsasua Status new => scheduled
2010-02-15 11:58 dalsasua Note Added: 0024263
2010-02-15 11:58 dalsasua fix_in_branch => pi
2010-02-15 11:59 dalsasua Note Edited: 0024263 View Revisions
2010-02-15 16:02 hgbot Checkin
2010-02-15 16:02 hgbot Note Added: 0024275
2010-02-15 16:02 hgbot Status scheduled => resolved
2010-02-15 16:02 hgbot Resolution open => fixed
2010-02-15 16:02 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/dc25d171ca9529b04710cd11fa0c78c00b07a819 [^]
2010-02-18 00:30 hudsonbot Checkin
2010-02-18 00:30 hudsonbot Note Added: 0024518
2010-02-18 12:52 sureshbabu Note Added: 0024589
2010-02-18 12:52 sureshbabu Status resolved => closed
2010-02-18 12:52 sureshbabu Fixed in Version => 2.50MP12
2010-02-19 00:01 anonymous sf_bug_id 0 =>
2010-03-10 18:30 anonymous sf_bug_id => 2968060

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker