Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018373Openbravo ERP04. Warehouse managementpublic2011-08-29 12:132011-08-31 12:28
Reportermaite 
Assigned Tomaite 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP33 
Target Version2.50MP34Fixed in Version2.50MP33 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket12452
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0018373: Wrong message in Generate Average Costs: not all documentno are showed when checking if cost used in posting
DescriptionWrong message in Generate Average Costs: not all documentno are showed when checking if cost used in posting.
Also, when referencing to Matched Invoices, dateordered is shown instead of dateinvoiced.
Steps To Reproduce1. Go to Product "Beer" and define Cost for: Org=Main; Type=Average; Starting date=29-03-2006; Ending Date= 30-03-2006
2. Go to Accounting Schema Tables and set as ACTIVE "MaterialMgmtShipmentInOut" for both schemas
3. Go to Process Request window and unschedule acct server process
4. Go to Goods Receipt window and unpost all existent goods receipts
5. Create new Goods Receipt for Org=Main; any business partner and Movement Date = Accounting Date = 29-03-2006. Add any line. Complete and Post
6. Run Generate Average Costs function and you will obtain error without proper documentno indicated.
    
Error:
One or more Goods Receipt documents are posted using a cost that will be modified if the Generate Average Cost process is run. Please unpost the document with Document No. .
Proposed Solution1. Problem is that same dates are not being considered.
When comparing with "v_MinDateCosting", >= should be used instead of >
(lines affected: 117, 142, 166, 191, 220)

2. Show DATEINVOICED instead of DATEORDERED (lines 214, 221 and 229)
Additional Information
TagsNo tags attached.
Relationships
blocks defect 00183723.0MP3 closed maite Wrong message in Generate Average Costs: not all documentno are showed when checking if cost used in posting 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-08-29 12:14maiteTypedefect => backport
2011-08-29 12:14maitefix_in_branch => 2.50
2011-08-29 12:59jonalegriaesarteversion3.0MP2 => 2.50MP33
2011-08-29 12:59jonalegriaesarteTarget Version3.0MP3 => 2.50MP34
2011-08-29 12:59jonalegriaesarteAssigned Tojonalegriaesarte => maite
2011-08-29 14:31maiteSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=2630#r2630
2011-08-30 08:26hgbotCheckin
2011-08-30 08:26hgbotNote Added: 0040547
2011-08-30 08:26hgbotStatusscheduled => resolved
2011-08-30 08:26hgbotResolutionopen => fixed
2011-08-30 08:26hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/c73098d54299e672f9995296431071062882c5c5 [^]
2011-08-31 12:28egoitzNote Added: 0040614
2011-08-31 12:28egoitzStatusresolved => closed
2011-08-31 12:28egoitzFixed in Version => 2.50MP33

Notes
(0040547)
hgbot   
2011-08-30 08:26   
Repository: erp/stable/2.50
Changeset: c73098d54299e672f9995296431071062882c5c5
Author: Maite Elizari <maite.elizari <at> openbravo.com>
Date: Mon Aug 29 15:07:14 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/c73098d54299e672f9995296431071062882c5c5 [^]

Fixes issue 0018373: Generate Average Cost shows DocumentNo when accounting date is MinDateCosting

---
M src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml
---
(0040614)
egoitz   
2011-08-31 12:28   
verified