Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0003581Openbravo ERP09. Financial managementpublic2008-01-04 16:562008-06-12 09:44
Reportercromero 
Assigned Tocromero 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.35MP4 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0003581: AT235: \'Create Lines From\' in PostgreSQL
DescriptionRelated to bug 0002209

*Environment
OS: Ubuntu 7.04
DB: PostgreSQL 8.2
OB: R2.35
Web browser: Firefox 2

*Steps
1. Receivables & Payables > Transactions > Bank Statement
2. Create a new 'Bank Statement'.
3. Click on 'Create Lines From' button.
4. 'Search' for some bank statement lines.
5. Select more than one bank statement line and then click on 'OK' button.

Lines are not created and 'DebtPaymentReconcilied' error message appears.

If you select only one bank statement line, everything goes right. In
Oracle XE 10g, everything goes right even if you select more than one bank
statement line.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0002209 closed cromero AT235: \'Create Lines From \' in PostgreSQL 
Attached Files
Issue History
Date ModifiedUsernameFieldChange

Notes
(0007170)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:44)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1864020 [^]
(0004056)
cromero   
2008-01-15 16:45   
(edited on: 2008-06-12 09:27)
Logged In: YES
user_id=1500614
Originator: YES

Fixed since revision 1995.

Carlos Romero
Openbravo Team
(0004057)
plujan   
2008-05-15 22:51   
(edited on: 2008-06-12 09:27)
Logged In: YES
user_id=1759992
Originator: NO

I can not create lines from other bank statement on r2.35mp4, log's error message is:
09:23:18 [http-8080-2] ERROR org.openbravo.erpWindows.SalesOrder.HeaderData - SQL error in query: UPDATE C_Order SET AD_Client_ID = TO_NUMBER(?) , AD_Org_ID = TO_NUMBER(?) , DocumentNo = (?) , POReference = (?) , DateOrdered = TO_DATE(?) , C_DocTypeTarget_ID = TO_NUMBER(?) , Description = (?) , DatePromised = TO_DATE(?) , C_BPartner_ID = TO_NUMBER(?) , BillTo_ID = TO_NUMBER(?) , AD_User_ID = TO_NUMBER(?) , C_BPartner_Location_ID = TO_NUMBER(?) , M_PriceList_ID = TO_NUMBER(?) , Delivery_Location_ID = TO_NUMBER(?) , InvoiceRule = (?) , C_Currency_ID = TO_NUMBER(?) , DeliveryRule = (?) , M_Warehouse_ID = TO_NUMBER(?) , PriorityRule = (?) , DeliveryViaRule = (?) , M_Shipper_ID = TO_NUMBER(?) , SalesRep_ID = TO_NUMBER(?) , IsDiscountPrinted = (?) , FreightCostRule = (?) , FreightAmt = TO_NUMBER(?) , C_Charge_ID = TO_NUMBER(?) , ChargeAmt = TO_NUMBER(?) , PaymentRule = (?) , C_PaymentTerm_ID = TO_NUMBER(?) , C_Project_ID = TO_NUMBER(?) , C_Activity_ID = TO_NUMBER(?) , C_Campaign_ID = TO_NUMBER(?) , AD_OrgTrx_ID = TO_NUMBER(?) , User1_ID = TO_NUMBER(?) , User2_ID = TO_NUMBER(?) , TotalLines = TO_NUMBER(?) , GrandTotal = TO_NUMBER(?) , DocStatus = (?) , C_DocType_ID = TO_NUMBER(?) , DocAction = (?) , Posted = (?) , CopyFrom = (?) , CopyFromPO = (?) , Incotermsdescription = (?) , C_Incoterms_ID = TO_NUMBER(?) , Deliverynotes = (?) , Generatetemplate = (?) , SendEMail = (?) , IsSelfService = (?) , DropShip_Location_ID = TO_NUMBER(?) , DropShip_BPartner_ID = TO_NUMBER(?) , DropShip_User_ID = TO_NUMBER(?) , IsSelected = (?) , IsTaxIncluded = (?) , IsSOTrx = (?) , DatePrinted = TO_DATE(?) , Processed = (?) , Processing = (?) , DateAcct = TO_DATE(?) , IsTransferred = (?) , IsPrinted = (?) , IsInvoiced = (?) , IsDelivered = (?) , IsCreditApproved = (?) , IsApproved = (?) , C_Order_ID = TO_NUMBER(?) , IsActive = (?) , updated = now(), updatedby = to_number(?) WHERE C_Order.C_Order_ID = ? Exception:org.postgresql.util.PSQLException: ERROR: Document processed/posted
17:44:51 [http-8080-2] ERROR org.openbravo.erpCommon.ad_actionButton.CreateFromBankData - SQL error in query: SELECT COUNT(*) FROM C_DEBT_Payment_v p WHERE p.C_Debt_Payment_ID = ? AND C_DEBT_PAYMENT_STATUS(p.C_Settlement_Cancel_ID, p.Cancel_Processed, p.Generate_Processed, p.IsPaid, p.IsValid, p.C_CashLine_ID, p.C_BankStatementLine_ID) IN ('P', 'A') AND NOT EXISTS (SELECT * FROM C_BankStatementLine l WHERE p.C_DEBT_Payment_ID=l.C_DEBT_PAYMENT_ID)Exception:org.postgresql.util.PSQLException: The column name COUNT(*) was not found in this ResultSet.
17:44:51 [http-8080-2] WARN org.openbravo.erpCommon.ad_actionButton.CreateFrom - Rollback in transaction
(0004058)
cromero   
2008-05-19 17:11   
(edited on: 2008-06-12 09:27)
Logged In: YES
user_id=1500614
Originator: YES

Fixed in revision 4338

Added AS COUNT to the NotIsReconcilied method.


The error shown related to org.openbravo.erpWindows.SalesOrder.HeaderData is not significant for this case.