Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0021006Openbravo ERP04. Warehouse managementpublic2012-07-11 13:182012-07-18 05:20
gorkaion 
gorkaion 
immediatemajorN/A
closedfixed 
20Gentoo
 
3.0MP13pi 
Core
No
0021006: Add currency to calculated costs
The costs have to persist the currency in which they were calculated to avoid differences in posting.

This is also necessary to avoid problems if the currency of the legal entity is changed.
N/A
Store the currency of the costs in M_Costing, M_TRansaction and M_Transaction_Cost.

Modify needed processes and reports to take into account the currency.
No tags attached.
Issue History
2012-07-11 13:18gorkaionNew Issue
2012-07-11 13:18gorkaionAssigned To => gorkaion
2012-07-11 13:18gorkaionModules => Core
2012-07-12 17:15hgbotCheckin
2012-07-12 17:15hgbotNote Added: 0050536
2012-07-12 17:23hgbotCheckin
2012-07-12 17:23hgbotNote Added: 0050537
2012-07-12 17:31hgbotCheckin
2012-07-12 17:31hgbotNote Added: 0050538
2012-07-12 17:37hgbotCheckin
2012-07-12 17:37hgbotNote Added: 0050539
2012-07-12 19:15hgbotCheckin
2012-07-12 19:15hgbotNote Added: 0050544
2012-07-12 19:26hgbotCheckin
2012-07-12 19:26hgbotNote Added: 0050545
2012-07-12 19:57hgbotCheckin
2012-07-12 19:57hgbotNote Added: 0050546
2012-07-13 09:39hgbotCheckin
2012-07-13 09:39hgbotNote Added: 0050548
2012-07-13 13:36hgbotCheckin
2012-07-13 13:36hgbotNote Added: 0050555
2012-07-13 13:36hgbotCheckin
2012-07-13 13:36hgbotNote Added: 0050556
2012-07-13 13:37hgbotCheckin
2012-07-13 13:37hgbotNote Added: 0050557
2012-07-13 13:37hgbotCheckin
2012-07-13 13:37hgbotNote Added: 0050558
2012-07-13 13:37hgbotCheckin
2012-07-13 13:37hgbotNote Added: 0050561
2012-07-13 13:37hgbotCheckin
2012-07-13 13:37hgbotNote Added: 0050562
2012-07-13 13:37hgbotCheckin
2012-07-13 13:37hgbotNote Added: 0050563
2012-07-13 13:37hgbotCheckin
2012-07-13 13:37hgbotNote Added: 0050564
2012-07-13 13:37hgbotCheckin
2012-07-13 13:37hgbotNote Added: 0050565
2012-07-16 12:04gorkaionStatusnew => scheduled
2012-07-16 12:04gorkaionfix_in_branch => pi
2012-07-16 12:04gorkaionStatusscheduled => resolved
2012-07-16 12:04gorkaionFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/354939ec1bf9e2da1f60327ce29e65dcf4dad82b [^]
2012-07-16 12:04gorkaionResolutionopen => fixed
2012-07-16 17:24dmiguelezNote Added: 0050617
2012-07-16 19:33hgbotCheckin
2012-07-16 19:33hgbotNote Added: 0050639
2012-07-17 11:30hudsonbotCheckin
2012-07-17 11:30hudsonbotNote Added: 0050660
2012-07-17 12:26hgbotCheckin
2012-07-17 12:26hgbotNote Added: 0050664
2012-07-17 17:43hgbotCheckin
2012-07-17 17:43hgbotNote Added: 0050679
2012-07-17 19:16hgbotCheckin
2012-07-17 19:16hgbotNote Added: 0050690
2012-07-17 19:16hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/354939ec1bf9e2da1f60327ce29e65dcf4dad82b [^] => http://code.openbravo.com/erp/devel/pi/rev/6804b6847bf424ac1354a69dc7b8fc2da81153a0 [^]
2012-07-17 19:17dmiguelezNote Added: 0050692
2012-07-17 19:17dmiguelezStatusresolved => closed
2012-07-17 19:17dmiguelezFixed in Version => pi
2012-07-18 05:19hudsonbotCheckin
2012-07-18 05:19hudsonbotNote Added: 0050694
2012-07-18 05:20hudsonbotCheckin
2012-07-18 05:20hudsonbotNote Added: 0050700
2012-07-18 05:20hudsonbotCheckin
2012-07-18 05:20hudsonbotNote Added: 0050702

Notes
(0050536)
hgbot   
2012-07-12 17:15   
Repository: erp/devel/pi
Changeset: 6fbdda197479beb2e3172715103e9f824f5f51dd
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Thu Jul 12 17:11:05 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6fbdda197479beb2e3172715103e9f824f5f51dd [^]

Related to issue 21006.Modify costing migration process to set currency.

---
M src/org/openbravo/costing/CostingMigrationProcess.java
---
(0050537)
hgbot   
2012-07-12 17:23   
Repository: erp/devel/pi
Changeset: d38c92f283ae42103748f23905d602998dfc7cf1
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Thu Jul 12 17:19:51 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d38c92f283ae42103748f23905d602998dfc7cf1 [^]

Related to Issue 21006: Fixes Costing Server and Average Algorithm

---
M src/org/openbravo/costing/AverageAlgorithm.java
M src/org/openbravo/costing/CostingServer.java
---
(0050538)
hgbot   
2012-07-12 17:31   
Repository: erp/devel/pi
Changeset: fc56c603b5acbb1a02f1c8d66ef29e210c5b9470
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Thu Jul 12 17:28:16 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/fc56c603b5acbb1a02f1c8d66ef29e210c5b9470 [^]

Related to issue 21006.Fix issue in AverageAlgorithm

---
M src/org/openbravo/costing/AverageAlgorithm.java
---
(0050539)
hgbot   
2012-07-12 17:37   
Repository: erp/devel/pi
Changeset: e8611c4b66a1140f693646661d9b36d09bd5f941
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Thu Jul 12 17:37:18 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/e8611c4b66a1140f693646661d9b36d09bd5f941 [^]

Related to issue 21006.Reenable migrated check.

---
M src/org/openbravo/costing/CostingMigrationProcess.java
---
(0050544)
hgbot   
2012-07-12 19:15   
Repository: erp/devel/pi
Changeset: 002bf8742323829fea2313ec1d1699ee5db996d1
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Thu Jul 12 19:13:54 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/002bf8742323829fea2313ec1d1699ee5db996d1 [^]

Related to issue 21006.Add currency to CostingUtils methods.

---
M src/org/openbravo/costing/AverageAlgorithm.java
M src/org/openbravo/costing/CostingAlgorithm.java
M src/org/openbravo/costing/CostingRuleProcess.java
M src/org/openbravo/costing/CostingUtils.java
---
(0050545)
hgbot   
2012-07-12 19:26   
Repository: erp/devel/pi
Changeset: 2485a404b16d536ce40f0608e39cfab26edd32cd
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Thu Jul 12 19:25:16 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/2485a404b16d536ce40f0608e39cfab26edd32cd [^]

Related to issue 21006: Adjusts invetaries when closing.

---
M src/org/openbravo/costing/CostingMigrationProcess.java
---
(0050546)
hgbot   
2012-07-12 19:57   
Repository: erp/devel/pi
Changeset: a69c8f16a4d22404619cf25e57450c3dfa277590
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Thu Jul 12 19:57:00 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a69c8f16a4d22404619cf25e57450c3dfa277590 [^]

Related to issue 21006.Add order by to query.

---
M src/org/openbravo/costing/CostingMigrationProcess.java
---
(0050548)
hgbot   
2012-07-13 09:39   
Repository: erp/devel/pi
Changeset: d5055e9080bfce7272efe693e9835adbeeb34a92
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Fri Jul 13 09:32:06 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d5055e9080bfce7272efe693e9835adbeeb34a92 [^]

Related to issue 21006.Fix issue in migration process.

---
M src/org/openbravo/costing/CostingMigrationProcess.java
---
(0050555)
hgbot   
2012-07-13 13:36   
Repository: erp/devel/pi
Changeset: b1cb8aa752744433e247ab03b40cca5b4c233d70
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Fri Jul 13 13:27:22 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/b1cb8aa752744433e247ab03b40cca5b4c233d70 [^]

Related to issue 21006.Fix issue in migration process.

---
M src/org/openbravo/costing/CostingMigrationProcess.java
---
(0050556)
hgbot   
2012-07-13 13:36   
Repository: erp/devel/pi
Changeset: 689e3dbe20bed17f88daee8823a121e2d8979d89
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Fri Jul 13 13:31:04 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/689e3dbe20bed17f88daee8823a121e2d8979d89 [^]

Related to issue 21006.Adapt db functions to currency in cost.

---
M src-db/database/model/functions/M_GET_NO_TRX_PRODUCT_COST.xml
M src-db/database/model/functions/M_GET_TRANSACTION_COST.xml
M src-db/database/model/functions/M_GET_TRX_AND_PRODUCT_COST.xml
---
(0050557)
hgbot   
2012-07-13 13:37   
Repository: erp/devel/pi
Changeset: d651e86397b8e2a39699e3c7ebcf56413649cfc1
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Fri Jul 13 13:31:23 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d651e86397b8e2a39699e3c7ebcf56413649cfc1 [^]

Related to issue 21006.Add constraint in m_transaction for currency.

---
M src-db/database/model/tables/M_TRANSACTION.xml
---
(0050558)
hgbot   
2012-07-13 13:37   
Repository: erp/devel/pi
Changeset: 7bd1880ac28ffceae080e9cbe61a94046708cff4
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Fri Jul 13 13:31:36 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/7bd1880ac28ffceae080e9cbe61a94046708cff4 [^]

Related to issue 21006.Add error message.

---
M src-db/database/sourcedata/AD_MESSAGE.xml
---
(0050561)
hgbot   
2012-07-13 13:37   
Repository: erp/devel/pi
Changeset: e06bb4b24ce2785f7bcffce3b3f2986d3aa62fe3
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Fri Jul 13 13:33:12 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/e06bb4b24ce2785f7bcffce3b3f2986d3aa62fe3 [^]

Related to issue 21006.Modify utils functions and adapt java classes.

---
M src/org/openbravo/costing/CostingAlgorithm.java
M src/org/openbravo/costing/CostingStatus.java
M src/org/openbravo/costing/CostingUtils.java
M src/org/openbravo/costing/StandardAlgorithm.java
---
(0050562)
hgbot   
2012-07-13 13:37   
Repository: erp/devel/pi
Changeset: e4b8450dc81557be5f4ce87f9854daf326d38ee1
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Fri Jul 13 13:33:33 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/e4b8450dc81557be5f4ce87f9854daf326d38ee1 [^]

Related to issue 21006.Adapt accounting to currency in cost.

---
M src/org/openbravo/erpCommon/ad_forms/DocInOut.java
M src/org/openbravo/erpCommon/ad_forms/DocLine_Material.java
M src/org/openbravo/erpCommon/ad_forms/ProductInfo.java
---
(0050563)
hgbot   
2012-07-13 13:37   
Repository: erp/devel/pi
Changeset: 4c25e6433b895771bff460952f887eec3c7da16a
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Fri Jul 13 13:33:59 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/4c25e6433b895771bff460952f887eec3c7da16a [^]

Related to issue 21006.Adapt pareto report to currency in costs.

---
M src-db/database/model/functions/M_GET_PARETO_ABC.xml
M src-db/database/model/functions/M_UPDATE_PARETO_PRODUCT.xml
M src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct.java
M src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct_data.xsql
---
(0050564)
hgbot   
2012-07-13 13:37   
Repository: erp/devel/pi
Changeset: 5ffd226b45c8011609ed6889759d3258e97bc02e
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Fri Jul 13 13:34:19 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/5ffd226b45c8011609ed6889759d3258e97bc02e [^]

Related to issue 21006.Adapt valuation stock to currency in cost.

---
M src/org/openbravo/erpCommon/ad_reports/ReportValuationStock.java
M src/org/openbravo/erpCommon/ad_reports/ReportValuationStock_data.xsql
---
(0050565)
hgbot   
2012-07-13 13:37   
Repository: erp/devel/pi
Changeset: 354939ec1bf9e2da1f60327ce29e65dcf4dad82b
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Fri Jul 13 13:34:39 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/354939ec1bf9e2da1f60327ce29e65dcf4dad82b [^]

Related to issue 21006.Adapt dimensional report to currency in cost.

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
---
(0050617)
dmiguelez   
2012-07-16 17:24   
https://code.openbravo.com/erp/devel/pi/rev/1da2f0ebc0ef [^]

Related to issue 21006: Adds New currency column to M_Transaction table and M_Transaction_Cost table
(0050639)
hgbot   
2012-07-16 19:33   
Repository: erp/devel/pi
Changeset: 73a884a0a73c72150cc47f775f337e2c76b09ee0
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Jul 16 19:31:49 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/73a884a0a73c72150cc47f775f337e2c76b09ee0 [^]

Related to Issue 21006: Fixes m_get_transaction_cost function.

---
M src-db/database/model/functions/M_GET_TRANSACTION_COST.xml
---
(0050660)
hudsonbot   
2012-07-17 11:30   
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/e0c03882496c [^]

Maturity status: Test
(0050664)
hgbot   
2012-07-17 12:26   
Repository: erp/devel/pi
Changeset: 73c19e6fd0cffb664ef7ccaa3363f011864eba1f
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Tue Jul 17 12:25:10 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/73c19e6fd0cffb664ef7ccaa3363f011864eba1f [^]

Related to Issue 21006: Fixes issues in Costing Utils + Costing Migration Process

---
M src/org/openbravo/costing/CostingMigrationProcess.java
M src/org/openbravo/costing/CostingUtils.java
---
(0050679)
hgbot   
2012-07-17 17:43   
Repository: erp/devel/pi
Changeset: ba96c5cba8c2fcc04ada91278782fd3991f515e4
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Tue Jul 17 17:42:47 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/ba96c5cba8c2fcc04ada91278782fd3991f515e4 [^]

Related to issue 21006 Add c_currency in ReportInvoiceCustomerDimensional

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
---
(0050690)
hgbot   
2012-07-17 19:16   
Repository: erp/devel/pi
Changeset: 6804b6847bf424ac1354a69dc7b8fc2da81153a0
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Tue Jul 17 19:15:39 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6804b6847bf424ac1354a69dc7b8fc2da81153a0 [^]

Fixes issue 21006: Fixes issue in Pareto Report.

---
M src-db/database/model/functions/M_GET_PARETO_ABC.xml
M src-db/database/model/functions/M_UPDATE_PARETO_PRODUCT.xml
M src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct_data.xsql
---
(0050692)
dmiguelez   
2012-07-17 19:17   
Code Review + Testing OK
(0050694)
hudsonbot   
2012-07-18 05:19   
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/d76f48fbf254 [^]

Maturity status: Test
(0050700)
hudsonbot   
2012-07-18 05: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/d76f48fbf254 [^]

Maturity status: Test
(0050702)
hudsonbot   
2012-07-18 05: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/d76f48fbf254 [^]

Maturity status: Test