0007327: FACT_ACCT_RESET database procedure unposts all manual settlements when unposting one record

Description

When 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 Reproduce

Introduce 5 manual settlement.
Post them.
Unpost a manual settlement. Also the log says: "Success 5 updated".

Proposed Solution

Improve 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.

Tags

main

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

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

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2009-02-02 19:20	galderromo	New Issue
2009-02-02 19:20	galderromo	Assigned To	=> rafaroda
2009-02-02 19:20	galderromo	sf_bug_id	0 => 2557770
2009-02-02 19:20	galderromo	OBNetwork customer	=> No
2009-02-02 19:20	galderromo	Regression testing	=> No
2009-02-10 10:03	psarobe	Status	new => scheduled
2009-02-10 10:03	psarobe	fix_in_branch	=> trunk
2009-02-10 10:04	psarobe	Assigned To	rafaroda => eduardo_Argal
2009-02-10 10:04	psarobe	fix_in_branch	trunk =>
2009-02-10 12:59	eduardo_Argal	Priority	normal => low
2009-02-10 12:59	eduardo_Argal	Severity	major => minor
2009-02-13 17:28	eduardo_Argal	Status	scheduled => resolved
2009-02-13 17:28	eduardo_Argal	svn_revision	=> 13180
2009-02-13 17:28	eduardo_Argal	Resolution	open => fixed
2009-04-22 11:24	psarobe	Tag Attached: main
2009-04-23 18:41	psarobe	Status	resolved => closed