0018372: Wrong message in Generate Average Costs: not all documentno are showed when checking if cost used in posting

Description

Wrong 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 Reproduce

1. 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 Solution

1. 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)

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

depends on

backport

0018373

2.50MP34

closed

maite

Wrong message in Generate Average Costs: not all documentno are showed when checking if cost used in posting

Notes
(0040546) hgbot (developer) 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 (developer) 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 (developer) 2011-08-31 12:28	verified

Issue History
Date Modified	Username	Field	Change
2011-08-29 12:13	maite	New Issue
2011-08-29 12:13	maite	Assigned To	=> jonalegriaesarte
2011-08-29 12:13	maite	Modules	=> Core
2011-08-29 12:14	maite	Status	new => scheduled
2011-08-29 12:14	maite	fix_in_branch	=> pi
2011-08-29 12:59	jonalegriaesarte	Assigned To	jonalegriaesarte => maite
2011-08-30 08:25	hgbot	Checkin
2011-08-30 08:25	hgbot	Note Added: 0040546
2011-08-30 08:25	hgbot	Status	scheduled => resolved
2011-08-30 08:25	hgbot	Resolution	open => fixed
2011-08-30 08:25	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/197035979c965f801a200b73fe3438a0b0785a65 [^]
2011-08-30 19:38	hudsonbot	Checkin
2011-08-30 19:38	hudsonbot	Note Added: 0040567
2011-08-31 12:28	egoitz	Note Added: 0040613
2011-08-31 12:28	egoitz	Status	resolved => closed
2011-08-31 12:28	egoitz	Fixed in Version	=> 3.0MP3