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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0012408
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 03. Procurement managementmajoralways2010-02-23 11:132010-03-12 22:41
ReporternetworkbView Statuspublic 
Assigned Todalsasua 
PriorityimmediateResolutionfixedFixed in Version2.50MP14
StatusclosedFix in branchFixed in SCM revisionb73fdfd848cc
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

0012408: Error in the fact_acct when a Matched Invoice is eliminated.

DescriptionWhen a Matched Invoice is eliminated, its line on fact_acct is not eliminated.
Steps To Reproduce-As Openbravo Admin go to Financial Management || Accounting || Setup || Accounting Schema || Accounting Schema >> Account Schema Tables
-Select ProcurementReceiptInvoiceMatch, set Active and save.

-Go to Procurement Management || Transactions || Goods Receipt
-Create a new record (BP: John Moneymaker) save and go to lines.
-Create a new record (Product: Donut, Movement Quantity: 20)
-Go back to the Header and complete.

-Go to Procurement Management || Transactions || Purchase Invoice
-Create a new record, create lines from the Good Receipt created and complete.

-Go to Procurement Management || Transactions || Matched Invoices
-Realize that a line has been generated.

-Go to Procurement Management || Transactions || Purchase Invoice
-Unpost the Invoice (Set Delete accounting entry) and reactivate it.
-Realize that the line on Matched Invoice has been eliminated.

-On your DB:
   select * from fact_acct order by created desc

-Realize that the lines of the Matched Invoice has not been eliminated.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0024890)
psarobe (manager)
2010-03-01 10:12

David,

To me the solution should be the same with what it happens with the Bank statement and the settlement (the one created automatically when completing the bank statement)
(0025073)
hgbot (developer)
2010-03-05 09:03

Repository: erp/devel/pi
Changeset: b73fdfd848cc51b9fef77ec4347c5f826b8c58e0
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Fri Mar 05 09:07:01 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/b73fdfd848cc51b9fef77ec4347c5f826b8c58e0 [^]

Fixes issue 12408: Error in the fact_acct

---
M src-db/database/model/functions/C_INVOICE_POST.xml
---
(0025109)
arunkumar (reporter)
2010-03-08 10:03

Tested & working fine
(0025394)
hudsonbot (developer)
2010-03-12 22:41

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/b73fdfd848cc [^]
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 [^]

- Issue History
Date Modified Username Field Change
2010-02-23 11:13 networkb New Issue
2010-02-23 11:13 networkb Assigned To => adrianromero
2010-02-23 13:40 adrianromero Status new => scheduled
2010-02-23 13:40 adrianromero fix_in_branch => pi
2010-02-26 11:07 adrianromero Assigned To adrianromero => dalsasua
2010-02-26 16:28 networkb Priority urgent => immediate
2010-02-26 16:28 networkb fix_in_branch pi =>
2010-03-01 10:12 psarobe Note Added: 0024890
2010-03-05 09:03 hgbot Checkin
2010-03-05 09:03 hgbot Note Added: 0025073
2010-03-05 09:03 hgbot Status scheduled => resolved
2010-03-05 09:03 hgbot Resolution open => fixed
2010-03-05 09:03 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b73fdfd848cc51b9fef77ec4347c5f826b8c58e0 [^]
2010-03-08 10:03 arunkumar Note Added: 0025109
2010-03-08 10:03 arunkumar Status resolved => closed
2010-03-08 10:03 arunkumar Fixed in Version => 2.50MP13
2010-03-08 16:04 jpabloae Fixed in Version 2.50MP13 => 2.50MP14
2010-03-08 16:05 jpabloae Target Version 2.50MP13 => 2.50MP14
2010-03-10 17:24 anonymous sf_bug_id 0 =>
2010-03-10 18:30 anonymous sf_bug_id => 2968098
2010-03-12 22:41 hudsonbot Checkin
2010-03-12 22:41 hudsonbot Note Added: 0025394


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker