Can you set the $go_debug flag in config.php to 1 or 2 to trap any errors.

Joe

Report rep707.php does not render any return. Something must be wrong with it. Do not know if this report 707 is for 2.4 or 2.3?

The Balancesheet report works, but when you select Profit and Loss Statement with Period Y-1 instead of accumulated, the report does not render

You can download the changed file here.

Joe

as i see it, the only problem is the Profit and Loss report, when comparing to the same period last year if it is a leap year.

A solution would be check if the to-date is the day of the end month. If this is the case, then we could also convert the period year-1 to be the day of the  end month if year-1 is a leap year.

Should we fix it this way? Do we need this to be an option? No, probably not.

Joe

Banking and General ledger / Inquiries and reports / General Ledger Reports / Profit and Loss Statement:

Select the current financial year Start Date: 01/03/2016 - Select the Current finacial year end date: 28/02/2017; Select compare to: Period Y-1 - Display report.

The amounts on the Profit and Loss Statement for Period Y-1 [Leap Year] is wrong. 

If you compare the reports for Period Y-1 tot the 2016 Fin year report:  Draw report for Period 01/03/2015 to 29/02/2016 [Leap year] the amounts will differ to the period Y-1 [Leap year] for period 01/03/2016 to 28/02/2017 as above. The period Y-1 for the period 01/03/2014 to 28/02/2014 is calculated correctly.

They should be the same which they are not. All amounts processed on the 29th are not calcultaed in the Period Y-1

Id you do Banking and General ledger /  Inquiries and reports / Profit and Loss Drill Down and your select period Start Date: 01/03/2016 - Select the Current financial year end date: 28/02/2017; Select compare to: Period Y-1 - Display report it displays correctly.

Similarly, for a month, it would be DATE_SUB(DATE_ADD(date_field, INTERVAL 1 MONTH), INTERVAL 1 DAY).

If you can pin point the sqls in FA where this causes an error we will be able to fix it. In most instances, the start and end date of the fiscal year are taken from the table's fields so it should not cause any issue.

The problem arises when you select on the report to show Period y-1 and the current finaicl year ends on 28/02 it does not include the correct figures for the previous year on the report since it will only add previous years figure up to 28/02 instead of 29/02. If the 29/02 is the current year and the period y-1 ended on 28/02 the previous year, everything is fine.

I do not know how one will be able to deal with this. Maybe period y-1 should always read 29/02 for february.

Joe

SELECT DATE_SUB(DATE_ADD('2015-03-01', INTERVAL 1 YEAR), INTERVAL 1 DAY)

which will yield 2016-02-29.

Similarly

SELECT DATE_SUB(DATE_ADD('2016-03-01', INTERVAL 1 YEAR), INTERVAL 1 DAY);

will get us 2017-02-28.

Also, how did it affect the JOURNAL entries alone?

Joe