Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020917Openbravo ERP04. Warehouse managementpublic2012-07-03 12:452012-07-17 12:53
Reportergorkaion 
Assigned Togorkaion 
PriorityimmediateSeverityminorReproducibilityN/A
StatusclosedResolutionfixed 
PlatformOS20OS VersionGentoo
Product Version 
Target Version3.0MP13Fixed in Version 
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
Summary0020917: A function to get new cost type costs for products that are not in the m_transaction should be available
DescriptionIn the new cost engine only products that are Item type and stocked are calculated. Remaining products such as services or no stocked items are configured in the Costing tab using the Standard cost type.

Currently there are functions that return the cost based on a transaction, but there isn't anyone that return the cost based by product.

This makes hard to create sql based reports or processes.
Steps To ReproduceN/A
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-07-03 12:45gorkaionNew Issue
2012-07-03 12:45gorkaionAssigned To => gorkaion
2012-07-03 12:45gorkaionModules => Core
2012-07-03 18:08gorkaionPrioritynormal => immediate
2012-07-03 18:08gorkaionTarget Version3.0MP14 => 3.0MP13
2012-07-03 18:09gorkaionSeveritymajor => minor
2012-07-11 13:14hgbotCheckin
2012-07-11 13:14hgbotNote Added: 0050484
2012-07-11 13:15hgbotCheckin
2012-07-11 13:15hgbotNote Added: 0050485
2012-07-11 13:15hgbotCheckin
2012-07-11 13:15hgbotNote Added: 0050486
2012-07-11 13:15hgbotCheckin
2012-07-11 13:15hgbotNote Added: 0050487
2012-07-11 13:15hgbotCheckin
2012-07-11 13:15hgbotNote Added: 0050488
2012-07-11 13:15hgbotCheckin
2012-07-11 13:15hgbotNote Added: 0050489
2012-07-11 13:15hgbotStatusnew => resolved
2012-07-11 13:15hgbotResolutionopen => fixed
2012-07-11 13:15hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/fb1a916d4aa2af8663c880601bca562d56e21c56 [^]
2012-07-11 13:15hgbotCheckin
2012-07-11 13:15hgbotNote Added: 0050490
2012-07-11 13:15hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/fb1a916d4aa2af8663c880601bca562d56e21c56 [^] => http://code.openbravo.com/erp/devel/pi/rev/c250255214e2a4c26121d22fd1cd8bc7ea57b899 [^]
2012-07-17 12:53SandrahuguetNote Added: 0050669
2012-07-17 12:53SandrahuguetStatusresolved => closed

Notes
(0050484)
hgbot   
2012-07-11 13:14   
Repository: erp/devel/pi
Changeset: a0cb0d75ac642b5b6ad89dfc32f412278ed5adf6
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Wed Jul 04 11:42:04 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a0cb0d75ac642b5b6ad89dfc32f412278ed5adf6 [^]

Related to issue 20917.Move ad_get_doc_le_bu out of postcripts.

---
M src-db/database/model/excludeFilter.xml
M src-db/database/model/postscript-Oracle.sql
M src-db/database/model/postscript-PostgreSql.sql
A src-db/database/model/functions/AD_GET_DOC_LE_BU.xml
---
(0050485)
hgbot   
2012-07-11 13:15   
Repository: erp/devel/pi
Changeset: 6345635cf5ff6df4b55124784265e0e19ba7b3af
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Wed Jul 04 11:54:41 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6345635cf5ff6df4b55124784265e0e19ba7b3af [^]

Related to issue 20917.Add ad_get_org_le_bu function.

---
M src-db/database/model/functions/AD_GET_DOC_LE_BU.xml
A src-db/database/model/functions/AD_GET_ORG_LE_BU.xml
---
(0050486)
hgbot   
2012-07-11 13:15   
Repository: erp/devel/pi
Changeset: a1c093f9393e1a1d279c9c3f49e036c387b0a5ad
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Wed Jul 04 15:49:40 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a1c093f9393e1a1d279c9c3f49e036c387b0a5ad [^]

Related to issue 20917.Fix db consistency issues in procedures.

---
M src-db/database/model/functions/AD_GET_DOC_LE_BU.xml
M src-db/database/model/functions/AD_GET_ORG_LE_BU.xml
---
(0050487)
hgbot   
2012-07-11 13:15   
Repository: erp/devel/pi
Changeset: fae24ce2e5437fb79c47d2e63aa84c574a2898a7
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Wed Jul 04 17:06:47 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/fae24ce2e5437fb79c47d2e63aa84c574a2898a7 [^]

Related to issue 20917.Add new functions M_GET_NO_TRX_PRODUCT_COST M_GET_TRX_AND_PRODUCT_COST.

---
A src-db/database/model/functions/M_GET_NO_TRX_PRODUCT_COST.xml
A src-db/database/model/functions/M_GET_TRX_AND_PRODUCT_COST.xml
---
(0050488)
hgbot   
2012-07-11 13:15   
Repository: erp/devel/pi
Changeset: 043915b301974b19a3f300ed4a814d508edb99f0
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Wed Jul 04 19:02:42 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/043915b301974b19a3f300ed4a814d508edb99f0 [^]

Related to issue 20917.Fixed issue in M_GET_NO_TRX_PRODUCT_COST.

---
M src-db/database/model/functions/M_GET_NO_TRX_PRODUCT_COST.xml
---
(0050489)
hgbot   
2012-07-11 13:15   
Repository: erp/devel/pi
Changeset: fb1a916d4aa2af8663c880601bca562d56e21c56
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Wed Jul 04 19:36:03 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/fb1a916d4aa2af8663c880601bca562d56e21c56 [^]

Fixed issue 20917.Fixes in ReportInvoiceCustomerDimensionalAnalysesJR report

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
---
(0050490)
hgbot   
2012-07-11 13:15   
Repository: erp/devel/pi
Changeset: c250255214e2a4c26121d22fd1cd8bc7ea57b899
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Thu Jul 05 10:35:27 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/c250255214e2a4c26121d22fd1cd8bc7ea57b899 [^]

Fixed issue 20917.Null costtype return cost on any new costtype.

---
M src-db/database/model/functions/M_GET_NO_TRX_PRODUCT_COST.xml
---
(0050669)
Sandrahuguet   
2012-07-17 12:53   
Code review + testing OK