Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0011217 | Openbravo ERP | 09. Financial management | public | 2009-11-02 18:02 | 2009-11-18 00:00 |
| Reporter | gorkaion | ||||
| Assigned To | eduardo_Argal | ||||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 20 | OS Version | ||
| Product Version | 2.50MP1 | ||||
| Target Version | 2.50MP10 | Fixed in Version | 2.50MP9 | ||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | |||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0011217: Reset accounting does not unpost correctly documents without fact_acct entries | ||||
| Description | The 'Reset Accounting' process does not set as not posted the documents that doesn't have any entry in the fact_acct | ||||
| Steps To Reproduce | 1. Create a manual settlement with the direct posting flag not checked. 2. Process and post it. Notice that the settlement is in status posted but no journal entry is created. 3. Run the 'Reset Accounting' process for the 'Manual Settlement - Settlement' table. 4. Go back to the manual settlement and notice that the settlement is still in posted status. | ||||
| Proposed Solution | Fix the FACT_ACCT_RESET procedure. When the 'Reset Accounting' process is called the Record_ID is 0 and not NULL. 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 || ''') AND (' || Cur_Tables.TableName || '_ID = ''' || v_Record_ID || ''' OR ''' || UPPER(v_Record_ID) ||''' = ''0'')'; | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2009-11-02 18:02 | gorkaion | New Issue | |||
| 2009-11-02 18:02 | gorkaion | Assigned To | => rafaroda | ||
| 2009-11-02 18:03 | gorkaion | version | => 2.50MP1 | ||
| 2009-11-02 18:03 | gorkaion | Target Version | => 2.50MP10 | ||
| 2009-11-02 18:05 | eduardo_Argal | Status | new => scheduled | ||
| 2009-11-02 18:05 | eduardo_Argal | Assigned To | rafaroda => eduardo_Argal | ||
| 2009-11-02 18:05 | eduardo_Argal | fix_in_branch | => pi | ||
| 2009-11-02 19:40 | hgbot | Checkin | |||
| 2009-11-02 19:40 | hgbot | Note Added: 0021520 | |||
| 2009-11-02 19:40 | hgbot | Status | scheduled => resolved | ||
| 2009-11-02 19:40 | hgbot | Resolution | open => fixed | ||
| 2009-11-02 19:40 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/cc27edfb352ee93c6b5c3c7d6be16ac58f66cc2c [^] | ||
| 2009-11-16 17:36 | hgbot | Checkin | |||
| 2009-11-16 17:36 | hgbot | Note Added: 0021881 | |||
| 2009-11-16 17:36 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/cc27edfb352ee93c6b5c3c7d6be16ac58f66cc2c [^] => http://code.openbravo.com/erp/devel/pi/rev/deb8f40cbb9d6589ba4ada7658eade8f3cb3bc65 [^] | ||
| 2009-11-17 12:25 | psarobe | Note Added: 0021916 | |||
| 2009-11-17 12:25 | psarobe | Status | resolved => closed | ||
| 2009-11-17 12:25 | psarobe | Fixed in Version | => 2.50MP9 | ||
| 2009-11-18 00:00 | anonymous | sf_bug_id | 0 => 2899461 | ||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||