Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0012408Openbravo ERP03. Procurement managementpublic2010-02-23 11:132010-03-12 22:41
networkb 
dalsasua 
immediatemajoralways
closedfixed 
5
2.50MP11 
2.50MP142.50MP14 
Core
No
0012408: Error in the fact_acct when a Matched Invoice is eliminated.
When a Matched Invoice is eliminated, its line on fact_acct is not eliminated.
-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.
No tags attached.
Issue History
2010-02-23 11:13networkbNew Issue
2010-02-23 11:13networkbAssigned To => adrianromero
2010-02-23 13:40adrianromeroStatusnew => scheduled
2010-02-23 13:40adrianromerofix_in_branch => pi
2010-02-26 11:07adrianromeroAssigned Toadrianromero => dalsasua
2010-02-26 16:28networkbPriorityurgent => immediate
2010-02-26 16:28networkbfix_in_branchpi =>
2010-03-01 10:12psarobeNote Added: 0024890
2010-03-05 09:03hgbotCheckin
2010-03-05 09:03hgbotNote Added: 0025073
2010-03-05 09:03hgbotStatusscheduled => resolved
2010-03-05 09:03hgbotResolutionopen => fixed
2010-03-05 09:03hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b73fdfd848cc51b9fef77ec4347c5f826b8c58e0 [^]
2010-03-08 10:03arunkumarNote Added: 0025109
2010-03-08 10:03arunkumarStatusresolved => closed
2010-03-08 10:03arunkumarFixed in Version => 2.50MP13
2010-03-08 16:04jpabloaeFixed in Version2.50MP13 => 2.50MP14
2010-03-08 16:05jpabloaeTarget Version2.50MP13 => 2.50MP14
2010-03-10 17:24anonymoussf_bug_id0 =>
2010-03-10 18:30anonymoussf_bug_id => 2968098
2010-03-12 22:41hudsonbotCheckin
2010-03-12 22:41hudsonbotNote Added: 0025394

Notes
(0024890)
psarobe   
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   
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   
2010-03-08 10:03   
Tested & working fine
(0025394)
hudsonbot   
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 [^]