Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005651Openbravo ERP03. Procurement managementpublic2008-10-24 11:022009-04-24 13:51
Reporterrafaroda 
Assigned Torafaroda 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 7.10
Product Versionpi 
Target VersionFixed in Versionmain 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005651: New C_Currency_id column in M_Inout for Shipper Report
DescriptionShipper Reports shows the cost of the freights of receipts if these are calculated. The amount of these freights have no currency.
Steps To Reproduce1) Go to 'Procurement Management || Transactions || Goods Receipt || Header' and create a new good shipment.
2) Select 'Freight Cost Rule' = Calculated then a Freigt Category and a Shipping Company.
3) Then type a Freight Amount or calculate it pressing 'Calculate Freight Amount' (for this you need to have defined a freight amount in 'Warehouse Management || Setup || Shipping Company || Shipping Company >> Freight').
4) Add some lines to the good receipt and complete it.
5) Go to 'Warehouse Management || Analysis Tools || Shipper Report' and select Purchase.
Proposed SolutionAdd a new freight_currency_id column to M_Inout table and add 'Freight Currency' field to the following tabs:
* Sales Management || Transactions || Goods Shipment || Header
* Procurement Management || Transactions || Goods Receipt

Modify M_Freight_Calculate in order to set the currency of the freight amount into freight_currency_id column of M_Inout table.
Additional Information
Tagsmain
Relationships
related to defect 0005564 closed rafaroda Multi currency issues in some processes and tables 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-10-24 11:02rafarodaNew Issue
2008-10-24 11:02rafarodaAssigned To => rafaroda
2008-10-24 11:02rafarodasf_bug_id0 => 2191441
2008-10-24 11:02rafarodaRegression testing => No
2008-10-24 11:05rafarodaRelationship addedrelated to 0005564
2008-10-27 09:56psarobeStatusnew => scheduled
2008-10-27 09:56psarobefix_in_branch => trunk
2008-10-27 17:08svnbotCheckin
2008-10-27 17:08svnbotNote Added: 0009769
2008-10-27 17:08svnbotStatusscheduled => resolved
2008-10-27 17:08svnbotResolutionopen => fixed
2008-10-27 17:08svnbotsvn_revision => 9262
2008-12-08 16:36psarobeStatusresolved => new
2008-12-08 16:36psarobeResolutionfixed => open
2008-12-08 16:36psarobeNote Added: 0011025
2008-12-09 13:30pheenanAssigned Torafaroda => gorkaion
2008-12-10 10:26rafarodaAssigned Togorkaion => rafaroda
2008-12-18 10:18rafarodaStatusnew => scheduled
2009-01-10 13:06svnbotCheckin
2009-01-10 13:06svnbotNote Added: 0012088
2009-01-10 13:06svnbotStatusscheduled => resolved
2009-01-10 13:06svnbotResolutionopen => fixed
2009-01-10 13:06svnbotsvn_revision9262 => 11784
2009-03-26 18:52hgbotCheckin
2009-03-26 18:52hgbotNote Added: 0015023
2009-03-26 18:52hgbotFixed in SCM revision11784 => http://code.openbravo.com/erp/devel/pi/rev/b8c467b82fe8d1be3342b2e85171a1a8564cd3a4 [^]
2009-03-26 18:52hgbotCheckin
2009-03-26 18:52hgbotNote Added: 0015024
2009-03-26 18:52hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/b8c467b82fe8d1be3342b2e85171a1a8564cd3a4 [^] => http://code.openbravo.com/erp/devel/pi/rev/b792fe332330057662fc2049979efd6c8266fde8 [^]
2009-03-26 18:52hgbotCheckin
2009-03-26 18:52hgbotNote Added: 0015025
2009-03-26 18:52hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/b792fe332330057662fc2049979efd6c8266fde8 [^] => http://code.openbravo.com/erp/devel/pi/rev/59e4a284b5e253fae134db946440fdfa9522ccac [^]
2009-03-26 18:52hgbotCheckin
2009-03-26 18:52hgbotNote Added: 0015026
2009-03-26 18:52hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/59e4a284b5e253fae134db946440fdfa9522ccac [^] => http://code.openbravo.com/erp/devel/pi/rev/4ab8b002a0d5940d1648f58025d3ea2b02bfc704 [^]
2009-04-22 11:24psarobeTag Attached: main
2009-04-24 13:51sureshbabuStatusresolved => closed
2009-04-24 13:51sureshbabuNote Added: 0015695
2009-04-24 13:51sureshbabuFixed in Version => main

Notes
(0009769)
svnbot   
2008-10-27 17:08   
Repository: openbravo
Revision: 9262
Author: rafaroda
Date: 2008-10-27 17:08:17 +0100 (Mon, 27 Oct 2008)

Fixes bug 0005651 Added 'Freight_Currency_ID' to 'M_INOUT' table and 'Freight Currency' field to 'Goods Shipments' and 'Goods Receipts' windows.

---
U trunk/src-db/database/model/functions/M_FREIGHT_CALCULATE.xml
U trunk/src-db/database/model/tables/M_INOUT.xml
U trunk/src-db/database/sourcedata/AD_COLUMN.xml
U trunk/src-db/database/sourcedata/AD_ELEMENT.xml
U trunk/src-db/database/sourcedata/AD_FIELD.xml
U trunk/src-db/database/sourcedata/AD_MESSAGE.xml
U trunk/src-db/database/sourcedata/AD_REFERENCE.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=9262&sc=1 [^]
(0011025)
psarobe   
2008-12-08 16:36   
Cannot find the field in Procurement Management || Transactions || Goods Receipt || Header
(0012088)
svnbot   
2009-01-10 13:06   
Repository: openbravo
Revision: 11784
Author: rafaroda
Date: 2009-01-10 13:06:32 +0100 (Sat, 10 Jan 2009)

Fixes bug 0005651 Added 'Freight Currency' field to 'Goods Receipts' windows.

---
U trunk/src-db/database/sourcedata/AD_FIELD.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=11784&sc=1 [^]
(0015023)
hgbot   
2009-03-26 18:52   
Repository: erp/devel/pi
Changeset: b8c467b82fe8d1be3342b2e85171a1a8564cd3a4
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Thu Mar 26 17:55:33 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/b8c467b82fe8d1be3342b2e85171a1a8564cd3a4 [^]

Issue 0005651 Updated sampledata/SmallBazaar.xml

---
M referencedata/sampledata/SmallBazaar.xml
---
(0015024)
hgbot   
2009-03-26 18:52   
Repository: erp/devel/pi
Changeset: b792fe332330057662fc2049979efd6c8266fde8
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Thu Mar 26 18:17:14 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/b792fe332330057662fc2049979efd6c8266fde8 [^]

Issue 0005651 Updated sampledata/Accounting_Test.xml

---
M referencedata/sampledata/Accounting_Test.xml
---
(0015025)
hgbot   
2009-03-26 18:52   
Repository: erp/devel/pi
Changeset: 59e4a284b5e253fae134db946440fdfa9522ccac
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Thu Mar 26 18:20:25 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/59e4a284b5e253fae134db946440fdfa9522ccac [^]

Issue 0005651 Added onCreateDefault to M_Inout table for Freight_Currency_Id column

---
M src-db/database/model/tables/M_INOUT.xml
---
(0015026)
hgbot   
2009-03-26 18:52   
Repository: erp/devel/pi
Changeset: 4ab8b002a0d5940d1648f58025d3ea2b02bfc704
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Thu Mar 26 18:47:22 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/4ab8b002a0d5940d1648f58025d3ea2b02bfc704 [^]

Issue 0005651 Modified M_Freight_Calculate function

---
M src-db/database/model/functions/M_FREIGHT_CALCULATE.xml
---
(0015695)
sureshbabu   
2009-04-24 13:51   
Tested working fine