Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0011217 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | major | always | 2009-11-02 18:02 | 2009-11-18 00:00 | |||
| Reporter | gorkaion | View Status | public | |||||
| Assigned To | eduardo_Argal | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 2.50MP9 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | deb8f40cbb9d | |||
| Projection | none | ETA | none | Target Version | 2.50MP10 | |||
| OS | Linux 32 bit | Database | Oracle | Java version | 1.6.0_11 | |||
| OS Version | Database version | 11g | Ant version | 1.7.1 | ||||
| Product Version | 2.50MP1 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| 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'')'; | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0021520) hgbot (developer) 2009-11-02 19:40 |
Repository: erp/devel/pi Changeset: cc27edfb352ee93c6b5c3c7d6be16ac58f66cc2c Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com> Date: Mon Nov 02 19:39:07 2009 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/cc27edfb352ee93c6b5c3c7d6be16ac58f66cc2c [^] Fixes bug 0011217: Reset accounting does not... --- M src-db/database/model/functions/FACT_ACCT_RESET.xml --- |
|
(0021881) hgbot (developer) 2009-11-16 17:36 |
Repository: erp/devel/pi Changeset: deb8f40cbb9d6589ba4ada7658eade8f3cb3bc65 Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com> Date: Mon Nov 16 17:12:50 2009 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/deb8f40cbb9d6589ba4ada7658eade8f3cb3bc65 [^] Fixes issue 0011217: Reset accounting does not unpost correctly documents without fact_acct entries --- M src/org/openbravo/erpCommon/ad_forms/AcctServer.java M src/org/openbravo/erpCommon/ad_forms/AcctServer_data.xsql --- |
|
(0021916) psarobe (manager) 2009-11-17 12:25 |
Tested working fine. Now it's not possible to post a manual settlement if direct posting is not marked (the document is marked then as an error) so to be able to reproduce the error we have to post the document (an error comes and the posted column has the value E=error). Then you delete the accounting and the value will be posted=N |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |