Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007327Openbravo ERP09. Financial managementpublic2009-02-02 19:202009-04-23 18:41
Reportergalderromo 
Assigned Toeduardo_Argal 
PrioritylowSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionRedHat
Product Version2.35MP4 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0007327: FACT_ACCT_RESET database procedure unposts all manual settlements when unposting one record
DescriptionWhen having 5000 manual settlements and 5000 invoices.
If you want to unpost a manual settlement to unprocess the settlement, all the manual settlements are unposted.
Posting manual settlements with no direct accounting means changing all settlements from posted='N' to posted='Y'.
When you want to unpost a manual settlement, you just want to update posted='Y' to posted='N' so you can unprocess the settlement.
But the application unposts all the manual settlements. Although it does not change the accounting information, the accounting background process posts again all the 5000 manual settlements. So you have to wait until this are posted before the invoices get also posted.
Steps To ReproduceIntroduce 5 manual settlement.
Post them.
Unpost a manual settlement. Also the log says: "Success 5 updated".
Proposed SolutionImprove code at FACT_ACCT_RESET around line 220:

        v_Cmd:='UPDATE ' || Cur_Tables.TableName || ' SET Posted=''N'', Processing=''N'' WHERE AD_Client_ID=''' || Cur_Clients.AD_Client_ID
        || ''' AND (Posted=''Y'' OR Processing<>''N'' OR Processing IS NULL) AND NOT EXISTS (SELECT 1 FROM FACT_ACCT WHERE AD_TABLE_ID =''' || Cur_Tables.AD_Table_ID ||
        ''' AND RECORD_ID = ' || Cur_Tables.TableName || '_ID AND AD_CLIENT_ID =''' || Cur_Clients.AD_Client_ID || ''' )';
            -- DBMS_OUTPUT.PUT_LINE(' executing: ' || v_Cmd);

updates all the records not having accounting info at fact_acct.
Additional Information
Tagsmain
Relationships
depends on backport 0007465 closed eduardo_Argal FACT_ACCT_RESET database procedure unposts all manual settlements when unposting one record 
depends on backport 0007466 closed eduardo_Argal FACT_ACCT_RESET database procedure unposts all manual settlements when unposting one record 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-02-02 19:20galderromoNew Issue
2009-02-02 19:20galderromoAssigned To => rafaroda
2009-02-02 19:20galderromosf_bug_id0 => 2557770
2009-02-02 19:20galderromoOBNetwork customer => No
2009-02-02 19:20galderromoRegression testing => No
2009-02-10 10:03psarobeStatusnew => scheduled
2009-02-10 10:03psarobefix_in_branch => trunk
2009-02-10 10:04psarobeAssigned Torafaroda => eduardo_Argal
2009-02-10 10:04psarobefix_in_branchtrunk =>
2009-02-10 12:59eduardo_ArgalPrioritynormal => low
2009-02-10 12:59eduardo_ArgalSeveritymajor => minor
2009-02-13 17:28eduardo_ArgalStatusscheduled => resolved
2009-02-13 17:28eduardo_Argalsvn_revision => 13180
2009-02-13 17:28eduardo_ArgalResolutionopen => fixed
2009-04-22 11:24psarobeTag Attached: main
2009-04-23 18:41psarobeStatusresolved => closed

There are no notes attached to this issue.