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]

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.

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