Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010909Openbravo ERP09. Financial managementpublic2009-10-08 11:052009-10-24 00:00
Reporternetworkb 
Assigned Todalsasua 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP5 
Target Version2.50MP7Fixed in Version2.50MP8 
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
Summary0010909: The reset accounting process does not work when you select a table
DescriptionThe reset accounting process does not work when you select a table.
If you don't select anything the process works well but if you
want to delete the accounting only for the selected tab,
the process does not unpost anything.
Steps To Reproduce-Create an post a settlement
-go to Financial management > Accounting > Reset accounting
-Select the settlement table
-Execute the process
You get the folling message:
@Updated@ = 0, @Deleted@ = 0

If you don't select the table the process work
Proposed Solutionreplace the code
        EXECUTE
          'SELECT AD_Org_ID
          FROM ' || v_TableName || '
          WHERE ' || v_TableName || '_ID =''' || v_Record_ID || ''' AND AD_CLIENT_ID =''' || v_AD_Client_ID || ''' '
          INTO v_AD_Org_ID;

with the following in order to select the organization of the parameter instead of the organization of the document.

IF (v_Record_ID!='0') THEN
        EXECUTE
          'SELECT AD_Org_ID
          FROM ' || v_TableName || '
          WHERE ' || v_TableName || '_ID =''' || v_Record_ID || ''' AND AD_CLIENT_ID =''' || v_AD_Client_ID || ''' '
          INTO v_AD_Org_ID;
    END IF;
Additional Information
Tags250MP8, main
Relationships
has duplicate defect 00108492.50MP7 closed vmromanos Reset accounting process: When using the "table" combo box the reset accounting does not delete anything 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-10-08 11:05networkbNew Issue
2009-10-08 11:05networkbAssigned To => rafaroda
2009-10-09 08:27networkbTarget Version2.40MP11 => 2.50MP7
2009-10-09 08:28networkbTarget Version2.50MP7 => 2.50MP8
2009-10-09 08:33rafarodaAssigned Torafaroda => dalsasua
2009-10-09 08:33rafarodaPriorityimmediate => urgent
2009-10-09 08:33rafarodaStatusnew => scheduled
2009-10-09 09:31networkbTarget Version2.50MP8 => 2.50MP7
2009-10-13 12:18psarobeRelationship addedhas duplicate 0010849
2009-10-14 09:46hgbotCheckin
2009-10-14 09:46hgbotNote Added: 0020994
2009-10-14 09:46hgbotStatusscheduled => resolved
2009-10-14 09:46hgbotResolutionopen => fixed
2009-10-14 09:46hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6e2cf9eac6842d16b12a4e5a99fa2e460a319cda [^]
2009-10-22 19:26psarobeTag Attached: main
2009-10-22 19:33psarobeTag Attached: 250MP8
2009-10-23 12:48arunkumarStatusresolved => closed
2009-10-23 12:48arunkumarNote Added: 0021360
2009-10-23 12:48arunkumarFixed in Version => 2.50MP8
2009-10-24 00:00anonymoussf_bug_id0 => 2885058

Notes
(0020994)
hgbot   
2009-10-14 09:46   
Repository: erp/devel/pi
Changeset: 6e2cf9eac6842d16b12a4e5a99fa2e460a319cda
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Wed Oct 14 09:46:06 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6e2cf9eac6842d16b12a4e5a99fa2e460a319cda [^]

Fixes issue 10909: The reset accounting process
does not work when you select a table

---
M src-db/database/model/functions/FACT_ACCT_RESET.xml
---
(0021360)
arunkumar   
2009-10-23 12:48   
Tested & Working fine.