Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0014908 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| feature request | [Openbravo ERP] 03. Procurement management | major | always | 2010-10-19 09:03 | 2011-05-24 10:57 | |||
| Reporter | dalsasua | View Status | public | |||||
| Assigned To | dalsasua | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | d60f21a50638 | ||||
| Projection | none | ETA | none | Target Version | 2.50MP23 | |||
| OS | Linux 32 bit | Database | Oracle | Java version | 1.6.0_14 | |||
| OS Version | Ubuntu 9.04 | Database version | 11.1.0.6.0 SE | Ant version | 1.7.1 | |||
| Product Version | pi | SCM revision | db409a855f2d | |||||
| 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 | 0014908: ERP must allow extension modules to add new document types to work in purchase/sales invoice windows. | |||||||
| Description | Nowadays, c_invoice_post has got the doc base types hardcoded in one of the checks. This means that, if an extension module includes a new doc base type, with new document types, using c_invoice table, when processing an invoice that uses that new document type, it will always fail. | |||||||
| Steps To Reproduce | Install storno ivoice module. Process an invoice with storno invoice document type. Check that it fails. | |||||||
| Proposed Solution | --- a/src-db/database/model/functions/C_INVOICE_POST.xml +++ b/src-db/database/model/functions/C_INVOICE_POST.xml @@ -422,7 +422,7 @@ SELECT COUNT(*) INTO v_Count FROM C_INVOICE C, C_DOCTYPE - WHERE C_DOCTYPE.DocBaseType IN ('ARI', 'API','ARC','APC') + WHERE C_DOCTYPE.DocBaseType IN (select docbasetype from c_doctype where isactive='Y' and ad_table_id='318' and ad_client_id=C.AD_Client_ID) AND C_DOCTYPE.IsSOTrx=C.ISSOTRX AND Ad_Isorgincluded(C.AD_Org_ID,C_DOCTYPE.AD_Org_ID, C.AD_Client_ID) <> -1 AND C.C_DOCTYPETARGET_ID = C_DOCTYPE.C_DOCTYPE_ID | |||||||
| Tags | closingMay2011 | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0031974) hgbot (developer) 2010-10-19 13:49 |
Repository: erp/devel/pi Changeset: d60f21a506384807bc9674254a011406390927f0 Author: David Alsasua <david.alsasua <at> openbravo.com> Date: Tue Oct 19 09:24:18 2010 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/d60f21a506384807bc9674254a011406390927f0 [^] Fixes issue 14908 Now C_Invoice_Post takes dynamically the doc base type elements that works with the invoice documents --- M src-db/database/model/functions/C_INVOICE_POST.xml --- |
|
(0031994) hudsonbot (developer) 2010-10-19 23:51 |
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated: Changeset: http://code.openbravo.com/erp/devel/main/rev/d60f21a50638 [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/483e8e77ad0a [^] Tests: http://builds.openbravo.com/view/int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18564.obx [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-10-19 09:03 | dalsasua | New Issue | |
| 2010-10-19 09:03 | dalsasua | Assigned To | => dalsasua |
| 2010-10-19 13:49 | hgbot | Checkin | |
| 2010-10-19 13:49 | hgbot | Note Added: 0031974 | |
| 2010-10-19 13:49 | hgbot | Status | new => resolved |
| 2010-10-19 13:49 | hgbot | Resolution | open => fixed |
| 2010-10-19 13:49 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/d60f21a506384807bc9674254a011406390927f0 [^] |
| 2010-10-19 23:51 | hudsonbot | Checkin | |
| 2010-10-19 23:51 | hudsonbot | Note Added: 0031994 | |
| 2011-05-24 09:59 | dalsasua | Tag Attached: closingMay2011 | |
| 2011-05-24 10:57 | dalsasua | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |