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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0023735
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 02. Master data managementminoralways2013-05-06 10:482013-07-02 10:31
ReporterngarciaView Statuspublic 
Assigned ToioritzCia 
PriorityhighResolutionfixedFixed in Version3.0MP25
StatusclosedFix in branchFixed in SCM revision6ef821be18eb
ProjectionnoneETAnoneTarget Version3.0MP25
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned Tongarcia
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket20908
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0023735: Products with cost calculated by the background process are not included in price lists based on costs under some circumstances

DescriptionCases:

1. The 'Valid From Date' matches the first Starting Date of the Costing entries and it was not calculated at 00:00:00
2. They are gaps between costing entries because you have manually edited the ending date of one of them and the 'Valid From Date' matches that date

In 'Product - Costing' tab, entries created by the Costing Background Process have their Starting Date and Ending Date saved as DateTime while they are shown as Date in the application. 'Price List - Price List Version - Valid From Date' field is saved as Date. The check made is

AND datefrom<=v_validfromdate AND dateto>v_validfromdate
Steps To ReproduceAs group admin role:
   Create a new product
   Add a price to it in 'Tarifa Bebidas Alegres' price list version
   Create two goods receipts with this product in order to get two entries in the 'Product - Costing' tab (Business Partner: Bebidas Alegres) and complete them
   Launch the Costing Background process and check that the cost has been calculated
   Create a record in the Price List window
      Sales Price List: Y
      Price List Based On Cost: Y
      Price List Version Valid From Date: <today>
   Create the Price List
   Check that the product has not been included in the list
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0059686)
hgbot (developer)
2013-06-26 17:19

 Repository: erp/devel/pi
Changeset: ae900525a10a3247b393e4eaa750bdab304ca5b0
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Wed Jun 26 17:17:50 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/ae900525a10a3247b393e4eaa750bdab304ca5b0 [^]

Fixes issue 23735: Create price list for costing based price lists.

---
M src-db/database/model/functions/M_PRICELIST_CREATE.xml
---
(0059704)
hudsonbot (viewer)
2013-06-27 12:56

 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/badcced5427d [^]

Maturity status: Test
(0059791)
hgbot (developer)
2013-07-01 10:25

 Repository: erp/devel/pi
Changeset: 6ef821be18eb8cbc35216aa69fdd893d2b0e13c2
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Mon Jul 01 10:25:06 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6ef821be18eb8cbc35216aa69fdd893d2b0e13c2 [^]

Fixes issue 23735: Create price list for costing based price lists.
Now the cost is taken too.

---
M src-db/database/model/functions/M_PRICELIST_CREATE.xml
M src-db/database/model/prescript-Oracle.sql
M src-db/database/model/prescript-PostgreSql.sql
---
(0059792)
ngarcia (viewer)
2013-07-01 13:27

 verified
(0059802)
hudsonbot (viewer)
2013-07-02 10:31

 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/62f36c5324f7 [^]

Maturity status: Test

- Issue History
Date Modified Username Field Change
2013-05-06 10:48 ngarcia New Issue
2013-05-06 10:48 ngarcia Assigned To => dmiguelez
2013-05-06 10:48 ngarcia Modules => Core
2013-05-06 10:48 ngarcia OBNetwork customer => Yes
2013-05-06 10:48 ngarcia Support ticket => 20908
2013-05-06 10:48 ngarcia Resolution time => 1374012000
2013-05-06 10:48 ngarcia Triggers an Emergency Pack => No
2013-05-06 10:48 ngarcia Issue Monitored: networkb
2013-05-06 10:53 dmiguelez Assigned To dmiguelez => jonalegriaesarte
2013-06-24 09:29 jonalegriaesarte Assigned To jonalegriaesarte => ioritzCia
2013-06-26 17:19 hgbot Checkin
2013-06-26 17:19 hgbot Note Added: 0059686
2013-06-26 17:19 hgbot Status new => resolved
2013-06-26 17:19 hgbot Resolution open => fixed
2013-06-26 17:19 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ae900525a10a3247b393e4eaa750bdab304ca5b0 [^]
2013-06-27 12:56 hudsonbot Checkin
2013-06-27 12:56 hudsonbot Note Added: 0059704
2013-07-01 10:25 hgbot Checkin
2013-07-01 10:25 hgbot Note Added: 0059791
2013-07-01 10:25 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/ae900525a10a3247b393e4eaa750bdab304ca5b0 [^] => http://code.openbravo.com/erp/devel/pi/rev/6ef821be18eb8cbc35216aa69fdd893d2b0e13c2 [^]
2013-07-01 13:27 ngarcia Review Assigned To => ngarcia
2013-07-01 13:27 ngarcia Note Added: 0059792
2013-07-01 13:27 ngarcia Status resolved => closed
2013-07-01 13:27 ngarcia Fixed in Version => 3.0MP25
2013-07-02 10:31 hudsonbot Checkin
2013-07-02 10:31 hudsonbot Note Added: 0059802

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker