Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementminoralways2019-03-20 18:022019-03-20 18:20
ReporterngarciaView Statuspublic 
Assigned ToTriage Finance 
PriorityhighResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0040421: Cannot add sum summary function to Amount field in Payment Plan - Payment Details tab of Purchase/Sales Invoice windows

DescriptionCannot add sum summary function to Amount field in Payment Plan - Payment Details tab of Purchase/Sales Invoice windows
Steps To ReproduceAs 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( ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7]
    at org.postgresql.core.v3.QueryExecutorImpl.processResults( ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7]
    at org.postgresql.core.v3.QueryExecutorImpl.execute( ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7]
    at org.postgresql.jdbc.PgStatement.executeInternal( ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7]
    at org.postgresql.jdbc.PgStatement.execute( ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7]
    at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags( ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7]
    at org.postgresql.jdbc.PgPreparedStatement.executeQuery( ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7]
TagsNo 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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker