Update full fiscal year

I have a need to update an already existing, fully populated fiscal year.
Currently we have
2022 - 1/1/22 to 31/12/22
2023 - 1/1/23 to 31/12/23

But we need to update our year end date for 2022 to 31/3/23 and year start date for 2023 to 1/4/23 with end date to match = 31/3/24.

I cannot do this through the UI as I cannot edit the 2022 or 2023 years, nor can I create any other years to replace them. The software wont allow it. I tried deleting a year but there are many ledger entries against it.

I have tried to do this with system console, but despite the console immediately replying that it worked, seconds later it simply reverts. I tried to redefine each year and create a new one, I tried to shorten existing ones and nothing worked, e.g.
frappe.db.set_value(“Fiscal Year”, “2023”, “is_short_year”, “1”)
frappe.db.set_value(“Fiscal Year”, “2023”, “year_end_date”, “2023-03-30”)

Help, please?


I have no idea what will be the implications of this change, but please try this in test database only.

For System Console to work, you need to tick on the “commit” check mark before executing.