Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012367Openbravo ERP09. Financial managementpublic2010-02-19 19:402010-04-17 00:00
Reporternetworkb 
Assigned Todalsasua 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP11 
Target Version2.50MP14Fixed in Version2.50MP15 
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
Summary0012367: Matched puchase invoice not balanced (shipment posting)
DescriptionThe not balanced amount happens when the average cost of the product change between the shipment posting and the purchase invoice posting. This error produce a critic diference in fixed asset account and the pending invoice payables, that should be balanced with the purchase invoice posting.
Steps To Reproduce1. create a product with cost type=average

2. create a manual entry in product costing tab, with cost=1.

3.
Create a shipment receipt for the dates defined in [2]
Posted a shipment with
qty=100
averagecost=1
Not Invoiced Receipt is increased in 100

4.
Create the invoice and post it

5. create a manual entry in product costing tab, with cost=1.5 for the date of the invoice.
 
6. Post the matched invoice. In this moment, the average cost is recalculated and change from 1 to 1.5.
Then the Not Invoiced Receipt is decreased in 150.
So, we have a not balanced amount of 50 in this account and in the product assest account.

Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-02-19 19:40networkbNew Issue
2010-02-19 19:40networkbAssigned To => dalsasua
2010-02-22 18:05dalsasuaStatusnew => scheduled
2010-02-22 18:05dalsasuafix_in_branch => pi
2010-02-22 18:08hgbotCheckin
2010-02-22 18:08hgbotNote Added: 0024705
2010-02-22 18:08hgbotStatusscheduled => resolved
2010-02-22 18:08hgbotResolutionopen => fixed
2010-02-22 18:08hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/04e7af9646a04da87d7222bb7908f95b594d1f2c [^]
2010-02-24 09:52networkbNote Added: 0024764
2010-02-24 09:52networkbStatusresolved => new
2010-02-24 09:52networkbResolutionfixed => open
2010-02-24 18:58hgbotCheckin
2010-02-24 18:58hgbotNote Added: 0024798
2010-02-24 18:58hgbotStatusnew => resolved
2010-02-24 18:58hgbotResolutionopen => fixed
2010-02-24 18:58hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/04e7af9646a04da87d7222bb7908f95b594d1f2c [^] => http://code.openbravo.com/erp/devel/pi/rev/8925b5958741ce82222186d3d4bcd35c7e128532 [^]
2010-03-03 13:48hudsonbotCheckin
2010-03-03 13:48hudsonbotNote Added: 0025006
2010-03-08 16:05jpabloaeTarget Version2.50MP13 => 2.50MP14
2010-03-12 22:39hudsonbotCheckin
2010-03-12 22:39hudsonbotNote Added: 0025318
2010-04-16 11:02psarobeNote Added: 0026307
2010-04-16 11:02psarobeStatusresolved => closed
2010-04-16 11:02psarobeFixed in Version => 2.50MP15
2010-04-17 00:00anonymoussf_bug_id0 => 2988597

Notes
(0024705)
hgbot   
2010-02-22 18:08   
Repository: erp/devel/pi
Changeset: 04e7af9646a04da87d7222bb7908f95b594d1f2c
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Mon Feb 22 18:10:25 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/04e7af9646a04da87d7222bb7908f95b594d1f2c [^]

Fixes issue 12367: Matched puchase invoice not balanced
Now the cost of the product is calculated using
the accounting date of the order

---
M src/org/openbravo/erpCommon/ad_forms/DocInOut_data.xsql
M src/org/openbravo/erpCommon/ad_forms/DocMatchInv.java
M src/org/openbravo/erpCommon/ad_forms/DocMatchInv_data.xsql
---
(0024764)
networkb   
2010-02-24 09:52   
The solution has been tested and it does not work properly
(0024798)
hgbot   
2010-02-24 18:58   
Repository: erp/devel/pi
Changeset: 8925b5958741ce82222186d3d4bcd35c7e128532
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Wed Feb 24 19:00:37 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/8925b5958741ce82222186d3d4bcd35c7e128532 [^]

fixes issue 12367: Matched puchase invoice not balanced
Now the cost of the product is calculated using
the accounting date of the order

---
M src/org/openbravo/erpCommon/ad_forms/DocMatchInv.java
M src/org/openbravo/erpCommon/ad_forms/DocMatchInv_data.xsql
---
(0025006)
hudsonbot   
2010-03-03 13:48   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/04e7af9646a0 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/17ddf2c3af51 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16508.obx [^]
(0025318)
hudsonbot   
2010-03-12 22:39   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/8925b5958741 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/631c626866c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16685.obx [^]
(0026307)
psarobe   
2010-04-16 11:02   
Tested by the end user and worked fine