UK fiscal year starts 6th April

**item** · 09-28-2023, 05:06 AM

Hi Kyle..

sorry for joke but : UK never do think like other people

just for my information, why 6th april ?
in Belgium, 1th april is joke day, so many newspaper have a "front page article" like "this year, Gouvernment don't do fiscal impôt for every people..." or "Gouvernment pay this year your holliday for you"...

search in folder : fiscalYearShift

many result, and it's seemt only "month" is calculed.

PHP Code:

                $fiscalYearShift = $this->getConfig()->get('fiscalYearShift', 0);
                $dt->modify('first day of January this year')->modify('+' . $fiscalYearShift . ' months');

this don't give response at your question.. but maybe a no "upgrade safe" solution

**esforim** · 09-28-2023, 09:03 AM

I handle it manually! Each year our rate get changes, and the only thing that is affected would be our Formula (and sometime infotip Descriptions); so I could copy/paste my old rate, add it as a Comments "// 2022-2023 Rate"

Then just change the value to new field. Maybe in the future I will use $variableRate1 $variableRate2 to help reduce yearly work.... as I write this I have a idea... someone should ask for "Global Variable" feature to be include in Formula!!!

That way I can share $Variable between different entity!

**Kyle** · 10-23-2023, 09:34 PM

Thanks for the feedback, it would be good for this to be supported in the base system.

The inbuilt search functions like this financial year are not useable for UK businesses.

**yuri** · 10-24-2023, 07:06 AM

The workaround is to have a custom read-only date field written by formula.

**yuri** · 10-24-2023, 07:13 AM

> it would be good for this to be supported in the base system

This would be much more difficult to implement than it may seem. It's not just filtering. Grouping by fiscal quarter in reports, the current ORM fiscal functions.

For example: https://github.com/espocrm/espocrm/b...poser.php#L925