/
GLMGT200 - Profit and Loss this year comparative always reports the full year figures 7.00.175
GLMGT200 - Profit and Loss this year comparative always reports the full year figures 7.00.175
Problem
The report criteria for comparative figures for the current reporting year reports the full year instead of the period selected. This was logged for correction DEV-5651 and passed testing is developer build 7.00.178
Solution
The stored procedure and updated report attached adds a new criteria 'Select This Year Comparative' to GLMGT200 - Profit & Loss report. Options for this new criteria are Full Year, Year to Date and Period Range
Download and save the attached files
Run the SQL script over the relevant database
Add the report to the database using Refresh from Files in the System > Reports Configuration > Reports form
Related articles
, multiple selections available,
Related content
GLMGT235 - Profit & Loss With Actuals, Budgets, Variance reported incorrect budget 2 and 3 information
GLMGT235 - Profit & Loss With Actuals, Budgets, Variance reported incorrect budget 2 and 3 information
More like this
GLMGT200 - Profit & Loss errors Database Vendor Code: 468 Error
GLMGT200 - Profit & Loss errors Database Vendor Code: 468 Error
More like this
GLMGT235 - Profit and Loss with Actuals, Budgets and Variances can error 'Database Vendor Code: 8114...'
GLMGT235 - Profit and Loss with Actuals, Budgets and Variances can error 'Database Vendor Code: 8114...'
More like this
DB GL Reconciliation Report can give variance between Current Year Open + Current Year Movement and Next Year Open - 702.00 and 7.02.01
DB GL Reconciliation Report can give variance between Current Year Open + Current Year Movement and Next Year Open - 702.00 and 7.02.01
More like this
SOMGT051 - Sales with COGS by Debtor displays no data when reporting by Branch - 7.02.01 and earlier
SOMGT051 - Sales with COGS by Debtor displays no data when reporting by Branch - 7.02.01 and earlier
More like this
Trial Balance period end date for Next Year period 12 is incorrect where there are only 2 unrolled years in GL Setup form
Trial Balance period end date for Next Year period 12 is incorrect where there are only 2 unrolled years in GL Setup form
More like this