Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0040421 | Openbravo ERP | 07. Sales management | public | 2019-03-20 18:02 | 2022-02-01 07:24 |
| Reporter | ngarcia | ||||
| Assigned To | Triage Platform Base | ||||
| Priority | high | Severity | minor | Reproducibility | always |
| Status | new | Resolution | open | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| 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 | No | ||||
| Summary | 0040421: Cannot add sum summary function to Amount field in Payment Plan - Payment Details tab of Purchase/Sales Invoice windows | ||||
| Description | Cannot add sum summary function to Amount field in Payment Plan - Payment Details tab of Purchase/Sales Invoice windows | ||||
| Steps To Reproduce | As group admin role: Open an already paid Sales Invoice Navigate to the Payment Details tab Click on Amount column and try to Set Summary Function -> Sum The following error is shown: org.hibernate.exception.SQLGrammarException: could not extract ResultSet The log shows: Caused by: org.postgresql.util.PSQLException: ERROR: function sum(timestamp without time zone) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 8 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:118) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2019-03-20 18:02 | ngarcia | New Issue | |||
| 2019-03-20 18:02 | ngarcia | Assigned To | => Triage Finance | ||
| 2019-03-20 18:02 | ngarcia | Modules | => Core | ||
| 2019-03-20 18:02 | ngarcia | Triggers an Emergency Pack | => No | ||
| 2019-03-20 18:04 | ngarcia | Issue Monitored: networkb | |||
| 2019-03-20 18:20 | Practics | Issue Monitored: Practics | |||
| 2019-08-29 13:37 | Sandrahuguet | Assigned To | Triage Finance => platform | ||
| 2019-10-07 09:12 | cberner | Assigned To | platform => cberner | ||
| 2019-10-07 09:12 | cberner | Status | new => scheduled | ||
| 2020-01-17 13:13 | AugustoMauch | Status | scheduled => feedback | ||
| 2020-01-17 13:13 | AugustoMauch | Status | feedback => new | ||
| 2020-01-17 14:40 | cberner | Assigned To | cberner => platform | ||
| 2022-02-01 07:24 | alostale | Assigned To | platform => Triage Platform Base | ||
| There are no notes attached to this issue. |