GLMGT235 - Profit and Loss with Actuals, Budgets and Variances can error 'Database Vendor Code: 8114...'

Problem

Where the stored procedure and updated report from GLMGT200 - Profit and Loss this year comparative always reports the full year figures 7.00.175 has been installed, running this report will error.

Solution

Download the attached report and install using Refresh from Files in the System > Reports Configuration > Reports form.  There is one small issue with the report that has been logged on DEV-5687 where the report is displaying the date of the Start Period not the End Period e.g. running the report for period 2 to 4 current year displays date as For the Year to Date ended 31 August 2017 instead of 31 October 2017.  Data is correct however.  The corrected report will be attached here when it's available.