Openbravo Issue Tracking System - Openbravo ERP | ||||||||||||
| View Issue Details | ||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||||||
| 0003699 | Openbravo ERP | 03. Procurement management | public | 2008-05-06 02:19 | 2008-06-12 09:44 | |||||||
| Reporter | cromero | |||||||||||
| Assigned To | cromero | |||||||||||
| Priority | normal | Severity | minor | Reproducibility | always | |||||||
| Status | closed | Resolution | fixed | |||||||||
| Platform | OS | 5 | OS Version | |||||||||
| Product Version | ||||||||||||
| Target Version | Fixed in Version | 2.35MP4 | ||||||||||
| Merge Request Status | ||||||||||||
| Review Assigned To | ||||||||||||
| OBNetwork customer | No | |||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Support ticket | ||||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0003699: Copy From Settlement does not work | |||||||||||
| Description | Related to bug: 0002938 It fails during execution due to empty not null columns on insertion. The solution, in my opinion: CopyFromSettlement_data.xsql 28,7 → 28,7 ON THE MAIN SELECT INCLUDE: status_initial as status, 77,8 → 77,8 NOT THIS: INSERT INTO C_DEBT_PAYMENT ( C_DEBT_PAYMENT_ID, AD_CLIENT_ID, AD_ORG_ID,CREATEDBY, UPDATEDBY, ISRECEIPT, C_SETTLEMENT_GENERATE_ID,DESCRIPTION, C_BPARTNER_ID, C_CURRENCY_ID, C_BANKACCOUNT_ID,C_CASHBOOK_ID, PAYMENTRULE, AMOUNT, WRITEOFFAMT, DATEPLANNED, ISMANUAL,GLITEMAMT,C_GLITEM_ID, ISDIRECTPOSTING, ISPAID,ISVALID) VALUES (TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),?,TO_NUMB ER(?),?,TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),?,TO_NUMBER(?), TO_NUMBER(?),TO_DATE(?),?,0,TO_NUMBER(?),?,'N','N') BUT THIS: INSERT INTO C_DEBT_PAYMENT ( C_DEBT_PAYMENT_ID, AD_CLIENT_ID, AD_ORG_ID,CREATEDBY, UPDATEDBY, ISRECEIPT, C_SETTLEMENT_GENERATE_ID,DESCRIPTION, C_BPARTNER_ID, C_CURRENCY_ID, C_BANKACCOUNT_ID,C_CASHBOOK_ID, PAYMENTRULE, AMOUNT, WRITEOFFAMT, DATEPLANNED, ISMANUAL,GLITEMAMT,C_GLITEM_ID, ISDIRECTPOSTING, ISPAID,ISVALID, STATUS, STATUS_INITIAL) VALUES (TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),?,TO_NUMB ER(?),?,TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),?,TO_NUMBER(?), TO_NUMBER(?),TO_DATE(?),?,0,TO_NUMBER(?),?,'N','N',?,?) ]]> </Sql> <Parameter name="cDebtPeymentId"/> INCLUDE TWO MORE PARAMETERS 100,6 → 100,8 <Parameter name="status"/> <Parameter name="status"/> CopyFromSettlement.java 122,7 → 122,9 NOT THIS: CopyFromSettlementData.insertDebtPayment(conn,this, strDebtPayment, to[0].client, to[0].org, vars.getUser(), data[i].isreceipt, strSettlement, data[i].description, strCBPartnerId, data[i].cCurrencyId, data[i].cBankaccountId, data[i].cCashbookId, data[i].paymentrule, strImporte, data[i].writeoffamt, strDate, data[i].ismanual, data[i].cGlitemId, data[i].isdirectposting); BUT THIS: CopyFromSettlementData.insertDebtPayment(conn,this, strDebtPayment, to[0].client, to[0].org, vars.getUser(), data[i].isreceipt, strSettlement, data[i].description, strCBPartnerId, data[i].cCurrencyId, data[i].cBankaccountId, data[i].cCashbookId, data[i].paymentrule, strImporte, data[i].writeoffamt, strDate, data[i].ismanual, data[i].cGlitemId, data[i].isdirectposting, data[i].status); | |||||||||||
| Steps To Reproduce | ||||||||||||
| Proposed Solution | ||||||||||||
| Additional Information | ||||||||||||
| Tags | No tags attached. | |||||||||||
| Relationships |
| |||||||||||
| Attached Files | ||||||||||||
| Issue History | ||||||||||||
| Date Modified | Username | Field | Change | |||||||||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||