Skip to main content
Solved

Is it possible to Change the financial year after client have at least 1 year history of data

  • September 28, 2023
  • 7 replies
  • 507 views

Ghazalshokrollahi
Jr Varsity III
Forum|alt.badge.img

hi All, 

I am dealing with a client to help them fix the financial year which had been set incorrectly and they have been transacting in the system for at least a year. the issue is where it has to show 2024 as a financial year for the year starting from 1/7/2023 it shows 2023.  ( we are using the MYOB Advanced Australian financial calender) , we are missing this tick box which should have been enabled at the start. has anyone dealth with this issue before or can this be fixed? it is just annoying for the client to always see the incorrect year. 

Thanks

Ghazal 

 

 

Best answer by meganfriesen37

If Acumatica can provide you with a script to change all the fiscal years in the system, that might be the best option.

One possible option would be to have a short financial year (i.e. create a fiscal year with one 1-day period, deleting all the other periods).  This would mean that all historical information would remain incorrect and could cause issues on comparative financial statements (you would likely need to create a copy that would compare current fiscal year to 2 years back instead of just 1). But, this would get you to the correct fiscal year going forward.  I haven’t tried this exact scenario, but I have worked with 2 different companies that have changed their fiscal year in Acumatica after going live (i.e. going from an Jan-Dec fiscal year to a July-June fiscal year) where you have a year with less than 12 periods. 

When you create the fiscal year for the “short” year, you will need to use the “User Defined” period options and you can delete the excess periods.
 

If you are using fixed assets, you will need to make sure you are on at least Acumatica 2023 R1 to be able to sync your fixed asset periods, but you could still end up with 1 period of depreciation in the “short” year.

If you are going to do this, I would advise testing it out in a sandbox/test tenant before trying it in live.

View original
Did this topic help you find an answer to your question?

7 replies

Forum|alt.badge.img

Hi Ghazal

 

Hope you are doing well.

 

As far as my knowledge goes, it is not possible to change the Financial Year once you have transactions.

I suggest that you log a ticket with Acumatica Support and ask them.

 

Kind regards

Marilize van Zyl


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2209 replies
  • September 28, 2023

Hi @Ghazalshokrollahi 

Once you have set up the company and the Financial Year along with transactions being done, you are unable to use that box. The only way to change it, is with a clean new instance.

Here is the help on that. 

 https://help.acumatica.com/(W(13))/Help?ScreenId=ShowWiki&pageid=d2977fb2-7494-463f-9ce5-8c5a80b1f2d0https://help.acumatica.com/(W(13))/Help?ScreenId=ShowWiki&pageid=d2977fb2-7494-463f-9ce5-8c5a80b1f2d0

 

As @marilizevanzyl suggested, you could reach out to Acumatica for assistance and there may be a script they could provide, but it is probably going to be advised against. 


meganfriesen37
Captain II
Forum|alt.badge.img+12
  • Captain II
  • 606 replies
  • Answer
  • September 28, 2023

If Acumatica can provide you with a script to change all the fiscal years in the system, that might be the best option.

One possible option would be to have a short financial year (i.e. create a fiscal year with one 1-day period, deleting all the other periods).  This would mean that all historical information would remain incorrect and could cause issues on comparative financial statements (you would likely need to create a copy that would compare current fiscal year to 2 years back instead of just 1). But, this would get you to the correct fiscal year going forward.  I haven’t tried this exact scenario, but I have worked with 2 different companies that have changed their fiscal year in Acumatica after going live (i.e. going from an Jan-Dec fiscal year to a July-June fiscal year) where you have a year with less than 12 periods. 

When you create the fiscal year for the “short” year, you will need to use the “User Defined” period options and you can delete the excess periods.
 

If you are using fixed assets, you will need to make sure you are on at least Acumatica 2023 R1 to be able to sync your fixed asset periods, but you could still end up with 1 period of depreciation in the “short” year.

If you are going to do this, I would advise testing it out in a sandbox/test tenant before trying it in live.


Forum|alt.badge.img+1

Hello @Ghazalshokrollahi ,

 

The user can change the financial year only if there are no transactions. If there are transactions, this is not possible to do without applying a script.

 

Thank you.,


Ghazalshokrollahi
Jr Varsity III
Forum|alt.badge.img

Thanks all for your help and advise I will first reachout to Acumatica checking for scripts 


  • Freshman I
  • 5 replies
  • November 14, 2023

Ghazal,

 

Was Acumatica able to handle this for you?

 

Thanks,
Dawn


Forum|alt.badge.img+1
  • Jr Varsity II
  • 39 replies
  • April 1, 2024

Acumatica quoted me $8k for the script.  Crazy...


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings