Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023735Openbravo ERP02. Master data managementpublic2013-05-06 10:482013-07-02 10:31
Reporterngarcia 
Assigned ToioritzCia 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP25Fixed in Version3.0MP25 
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
Summary0023735: 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-05-06 10:48ngarciaNew Issue
2013-05-06 10:48ngarciaAssigned To => dmiguelez
2013-05-06 10:48ngarciaModules => Core
2013-05-06 10:48ngarciaOBNetwork customer => Yes
2013-05-06 10:48ngarciaSupport ticket => 20908
2013-05-06 10:48ngarciaResolution time => 1374012000
2013-05-06 10:48ngarciaTriggers an Emergency Pack => No
2013-05-06 10:48ngarciaIssue Monitored: networkb
2013-05-06 10:53dmiguelezAssigned Todmiguelez => jonalegriaesarte
2013-06-24 09:29jonalegriaesarteAssigned Tojonalegriaesarte => ioritzCia
2013-06-26 17:19hgbotCheckin
2013-06-26 17:19hgbotNote Added: 0059686
2013-06-26 17:19hgbotStatusnew => resolved
2013-06-26 17:19hgbotResolutionopen => fixed
2013-06-26 17:19hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ae900525a10a3247b393e4eaa750bdab304ca5b0 [^]
2013-06-27 12:56hudsonbotCheckin
2013-06-27 12:56hudsonbotNote Added: 0059704
2013-07-01 10:25hgbotCheckin
2013-07-01 10:25hgbotNote Added: 0059791
2013-07-01 10:25hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/ae900525a10a3247b393e4eaa750bdab304ca5b0 [^] => http://code.openbravo.com/erp/devel/pi/rev/6ef821be18eb8cbc35216aa69fdd893d2b0e13c2 [^]
2013-07-01 13:27ngarciaReview Assigned To => ngarcia
2013-07-01 13:27ngarciaNote Added: 0059792
2013-07-01 13:27ngarciaStatusresolved => closed
2013-07-01 13:27ngarciaFixed in Version => 3.0MP25
2013-07-02 10:31hudsonbotCheckin
2013-07-02 10:31hudsonbotNote Added: 0059802

Notes
(0059686)
hgbot   
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   
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   
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   
2013-07-01 13:27   
verified
(0059802)
hudsonbot   
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