Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#106 svn - fix General Journal report

closed
nobody
5
2011-06-24
2010-03-09
Ian Goodacre
No

The General Journal Reports page was failing with "invalid input syntax
for integer" on ar.invnumber. This field is type but it is cast to
integer in the query. I had, perhaps foolishly, set it to 2010-03-08 on
one of my invoices, causing the cast to fail. The query is a union of
queries on gl, ar and ap and each of gl.reference, ar.invnumber and
ap.invnumber were cast to int, despite all being text fields and all
being compared with LIKE in the where clauses.

With this change the casts to int are removed and the report is
generated without error.

Discussion

  • Ian Goodacre
    Ian Goodacre
    2010-03-09

    This patch is against a recent checkout from subversion.

     
  • Ian Goodacre
    Ian Goodacre
    2010-03-09

    • summary: fix General Journal report --> svn - fix General Journal report
     
  • Chris Travers
    Chris Travers
    2011-05-27

    not applying cleanly at this time due to interceding changes.

     
  • Chris Travers
    Chris Travers
    2011-05-27

    • labels: --> manual merge
     
  • Chris Travers
    Chris Travers
    2011-06-24

    • status: open --> closed
     
  • Chris Travers
    Chris Travers
    2011-06-24

    apparently this was in fact previously applied.