0000257: AT235mp4 - On PostgreSQL I cannot create lines for Settlements

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0000257

Openbravo ERP

09. Financial management

public

2008-05-11 18:19

2008-08-14 16:15

Reporter

plujan

Assigned To

cromero

Priority

urgent

Severity

critical

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

2.35

Target Version

Fixed in Version

2.40alpha

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

Summary

0000257: AT235mp4 - On PostgreSQL I cannot create lines for Settlements

Description

When I create a new Settlement and I try to create lines by using "Create Lines From" button I get a "ProcessRunError" error message and I cannot continue. On openbravo.log I get this:

15:59:14 [http-8080-1] ERROR org.openbravo.erpCommon.ad_actionButton.CreateFromSettlementData - SQL error in query: SELECT COUNT(*) FROM C_DEBT_PAYMENT DP WHERE DP.C_DEBT_PAYMENT_ID = ? AND C_DEBT_PAYMENT_STATUS(DP.C_Settlement_Cancel_ID, DP.Cancel_Processed, DP.Generate_Processed, DP.IsPaid, DP.IsValid, DP.C_CashLine_ID, DP.C_BankStatementLine_ID)='P' AND NOT EXISTS (SELECT * FROM C_BankStatementLine l WHERE DP.C_DEBT_Payment_ID=l.C_DEBT_PAYMENT_ID) AND NOT EXISTS (SELECT * FROM C_CashLine l WHERE DP.C_DEBT_Payment_ID=l.C_DEBT_PAYMENT_ID) Exception:org.postgresql.util.PSQLException: The column name COUNT(*) was not found in this ResultSet.
15:59:14 [http-8080-1] WARN org.openbravo.erpCommon.ad_actionButton.CreateFrom - Rollback in transaction

Steps To Reproduce

# Login as userA
# Go to Financial management->Receivables and payables->Transactions->Settlement
# Click New and fill mandatory fields. Save
# Click "Create lines from"

Proposed Solution

Additional Information