Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018372Openbravo ERP04. Warehouse managementpublic2011-08-29 12:132011-08-31 12:28
Reportermaite 
Assigned Tomaite 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0MP2 
Target Version3.0MP3Fixed in Version3.0MP3 
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
Summary0018372: 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 "Ale Beer" and define Cost for: Org=F&B US East Coast; Type=Average; Starting date=02-07-2010; Ending Date= 03-07-2010
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=F&B US East Coast; any business partner and Movement Date = Accounting Date = 02-07-2010. 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
depends on backport 00183732.50MP34 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:13maiteNew Issue
2011-08-29 12:13maiteAssigned To => jonalegriaesarte
2011-08-29 12:13maiteModules => Core
2011-08-29 12:14maiteStatusnew => scheduled
2011-08-29 12:14maitefix_in_branch => pi
2011-08-29 12:59jonalegriaesarteAssigned Tojonalegriaesarte => maite
2011-08-30 08:25hgbotCheckin
2011-08-30 08:25hgbotNote Added: 0040546
2011-08-30 08:25hgbotStatusscheduled => resolved
2011-08-30 08:25hgbotResolutionopen => fixed
2011-08-30 08:25hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/197035979c965f801a200b73fe3438a0b0785a65 [^]
2011-08-30 19:38hudsonbotCheckin
2011-08-30 19:38hudsonbotNote Added: 0040567
2011-08-31 12:28egoitzNote Added: 0040613
2011-08-31 12:28egoitzStatusresolved => closed
2011-08-31 12:28egoitzFixed in Version => 3.0MP3

Notes
(0040546)
hgbot   
2011-08-30 08:25   
Repository: erp/devel/pi
Changeset: 197035979c965f801a200b73fe3438a0b0785a65
Author: Maite Elizari <maite.elizari <at> openbravo.com>
Date: Mon Aug 29 13:08:07 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/197035979c965f801a200b73fe3438a0b0785a65 [^]

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

---
M src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml
---
(0040567)
hudsonbot   
2011-08-30 19:38   
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/dfde2574ecaf [^]

Maturity status: Test
(0040613)
egoitz   
2011-08-31 12:28   
verified