Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0012367
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2010-02-19 19:402010-04-17 00:00
ReporternetworkbView Statuspublic 
Assigned Todalsasua 
PriorityimmediateResolutionfixedFixed in Version2.50MP15
StatusclosedFix in branchpiFixed in SCM revision8925b5958741
ProjectionnoneETAnoneTarget Version2.50MP14
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP11SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0012367: 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.

TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0024705)
hgbot (developer)
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 (developer)
2010-02-24 09:52

 The solution has been tested and it does not work properly
(0024798)
hgbot (developer)
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 (developer)
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 (developer)
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 (manager)
2010-04-16 11:02

 Tested by the end user and worked fine

- Issue History
Date Modified Username Field Change
2010-02-19 19:40 networkb New Issue
2010-02-19 19:40 networkb Assigned To => dalsasua
2010-02-22 18:05 dalsasua Status new => scheduled
2010-02-22 18:05 dalsasua fix_in_branch => pi
2010-02-22 18:08 hgbot Checkin
2010-02-22 18:08 hgbot Note Added: 0024705
2010-02-22 18:08 hgbot Status scheduled => resolved
2010-02-22 18:08 hgbot Resolution open => fixed
2010-02-22 18:08 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/04e7af9646a04da87d7222bb7908f95b594d1f2c [^]
2010-02-24 09:52 networkb Note Added: 0024764
2010-02-24 09:52 networkb Status resolved => new
2010-02-24 09:52 networkb Resolution fixed => open
2010-02-24 18:58 hgbot Checkin
2010-02-24 18:58 hgbot Note Added: 0024798
2010-02-24 18:58 hgbot Status new => resolved
2010-02-24 18:58 hgbot Resolution open => fixed
2010-02-24 18:58 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/04e7af9646a04da87d7222bb7908f95b594d1f2c [^] => http://code.openbravo.com/erp/devel/pi/rev/8925b5958741ce82222186d3d4bcd35c7e128532 [^]
2010-03-03 13:48 hudsonbot Checkin
2010-03-03 13:48 hudsonbot Note Added: 0025006
2010-03-08 16:05 jpabloae Target Version 2.50MP13 => 2.50MP14
2010-03-12 22:39 hudsonbot Checkin
2010-03-12 22:39 hudsonbot Note Added: 0025318
2010-04-16 11:02 psarobe Note Added: 0026307
2010-04-16 11:02 psarobe Status resolved => closed
2010-04-16 11:02 psarobe Fixed in Version => 2.50MP15
2010-04-17 00:00 anonymous sf_bug_id 0 => 2988597

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker