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?