#1069 Databases upgraded from 1.3 have ar.force_closed set to null

1.4
closed-fixed
Chris Travers
None
5
2014-02-13
2014-02-13
John Locke
No

With a database updated from 1.3 (and probably earlier), when you go to AR -> Reports -> AR Aging, you get no results. This is because the stored function has this where clause:

WHERE not a.force_closed

Apparently a null value does not evaluate true here, while a false value does.

This column needs to be explicitly set to false after importing data from older schemas where it did not exist.

Same issue applies to AP.

Discussion

  • Chris Travers
    Chris Travers
    2014-02-13

    • status: open --> closed-fixed
    • assigned_to: Chris Travers
     
  • Chris Travers
    Chris Travers
    2014-02-13

    Changing the reports from NOT force_closed to force_closed IS NOT TRUE. The latter handles null, while the former does not.