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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0020917
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementminorN/A2012-07-03 12:452012-07-17 12:53
ReportergorkaionView Statuspublic 
Assigned Togorkaion 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionc250255214e2
ProjectionnoneETAnoneTarget Version3.0MP13
OSLinux 32 bitDatabaseOracleJava version1.5.0_15
OS VersionGentooDatabase version11gAnt version1.7.0
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0020917: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0050484)
hgbot (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
2012-07-17 12:53

 Code review + testing OK

- Issue History
Date Modified Username Field Change
2012-07-03 12:45 gorkaion New Issue
2012-07-03 12:45 gorkaion Assigned To => gorkaion
2012-07-03 12:45 gorkaion Modules => Core
2012-07-03 18:08 gorkaion Priority normal => immediate
2012-07-03 18:08 gorkaion Target Version 3.0MP14 => 3.0MP13
2012-07-03 18:09 gorkaion Severity major => minor
2012-07-11 13:14 hgbot Checkin
2012-07-11 13:14 hgbot Note Added: 0050484
2012-07-11 13:15 hgbot Checkin
2012-07-11 13:15 hgbot Note Added: 0050485
2012-07-11 13:15 hgbot Checkin
2012-07-11 13:15 hgbot Note Added: 0050486
2012-07-11 13:15 hgbot Checkin
2012-07-11 13:15 hgbot Note Added: 0050487
2012-07-11 13:15 hgbot Checkin
2012-07-11 13:15 hgbot Note Added: 0050488
2012-07-11 13:15 hgbot Checkin
2012-07-11 13:15 hgbot Note Added: 0050489
2012-07-11 13:15 hgbot Status new => resolved
2012-07-11 13:15 hgbot Resolution open => fixed
2012-07-11 13:15 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/fb1a916d4aa2af8663c880601bca562d56e21c56 [^]
2012-07-11 13:15 hgbot Checkin
2012-07-11 13:15 hgbot Note Added: 0050490
2012-07-11 13:15 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/fb1a916d4aa2af8663c880601bca562d56e21c56 [^] => http://code.openbravo.com/erp/devel/pi/rev/c250255214e2a4c26121d22fd1cd8bc7ea57b899 [^]
2012-07-17 12:53 Sandrahuguet Note Added: 0050669
2012-07-17 12:53 Sandrahuguet Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker